#
# ChangeLog for /
#
# Generated by Trac 1.6
# 04/09/25 01:03:12
Tue, 09 Aug 2005 21:17:29 GMT Kris Deugau [274]
* branches/dns/cgi-bin/IPDB.pm (modified)
/branches/dns
Fix missed name change for variable in new subst_rDNS ...
Tue, 09 Aug 2005 21:15:26 GMT Kris Deugau [273]
* branches/dns/cgi-bin/IPDB.pm (modified)
* branches/dns/cgi-bin/main.cgi (modified)
/branches/dns
Updates to main.cgi to pass rDNS data in to IPDB core ...
Thu, 21 Jul 2005 20:42:27 GMT Kris Deugau [272]
* branches/dns/assign.html (modified)
* branches/dns/confirm.html (modified)
* branches/dns/editDisplay.html (modified)
* branches/dns/fb-assign.html (modified)
* branches/dns/updated.html (modified)
/branches/dns
Updates to existing html to support basic DNS info
Thu, 21 Jul 2005 19:26:26 GMT Kris Deugau [271]
* branches/stable/assign.html (modified)
* branches/stable/confirm.html (modified)
* branches/stable/fb-assign.html (modified)
/branches/stable
Light HTML cleanup:
-> unmangle 's ...
Thu, 21 Jul 2005 18:43:23 GMT Kris Deugau [270]
* branches/stable/alloctypes.html (modified)
/branches/stable
Update alloctypes.html with new types (VoIP, ...
Tue, 19 Jul 2005 15:37:40 GMT Kris Deugau [269]
* branches/stable/cgi-bin/admin.cgi (modified)
/branches/stable
Tweak admin.cgi to snag alloctypes from db rather ...
Fri, 15 Jul 2005 21:15:40 GMT Kris Deugau [268]
* branches/stable/cgi-bin/ipdb.psql (modified)
/branches/stable
Add LAN/POP static pool and IP types to SQL definitions
Fri, 15 Jul 2005 20:57:02 GMT Kris Deugau [267]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Oops, missed some possibilities in deliberatly ...
Fri, 15 Jul 2005 20:39:54 GMT Kris Deugau [266]
* branches/stable/assign.html (modified)
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Tweak "new assignment" defaults to avoid private ...
Fri, 15 Jul 2005 20:34:02 GMT Kris Deugau [265]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Bugfix; allow the real error message to actually ...
Wed, 29 Jun 2005 18:11:16 GMT Kris Deugau [264]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Tweak data validation to allow easier use of the ...
Tue, 21 Jun 2005 21:12:52 GMT Kris Deugau [263]
* branches/dns/cgi-bin/dns.cgi (added)
/branches/dns
Add/create dns.cgi stub
Fri, 17 Jun 2005 20:42:45 GMT Kris Deugau [262]
* branches/dns/addmaster.html (copied)
* branches/dns/addmaster.shtml (deleted)
* branches/dns/alloctypes.html (modified)
* branches/dns/cgi-bin/CommonWeb.pm (modified)
* branches/dns/cgi-bin/IPDB.pm (modified)
* branches/dns/cgi-bin/admin.cgi (modified)
* branches/dns/cgi-bin/extras/db2rwhois.pl (modified)
* branches/dns/cgi-bin/ipdb.psql (modified)
* branches/dns/cgi-bin/main.cgi (modified)
* branches/dns/cgi-bin/search.cgi (copied)
* branches/dns/changes.html (modified)
* branches/dns/compsearch.html (copied)
* branches/dns/editDisplay.html (modified)
* branches/dns/header.inc (modified)
* branches/dns/help.html (modified)
* branches/dns/index.shtml (modified)
/branches/dns
Update branch base with trunk changes from r216:261
Fri, 17 Jun 2005 20:08:35 GMT Kris Deugau [261]
* trunk/cgi-bin/main.cgi (modified)
/trunk
Cleanup - remove unused function countRows() and unused
...
Mon, 13 Jun 2005 20:45:27 GMT Kris Deugau [260]
* branches/stable/cgi-bin/admin.cgi (modified)
/branches/stable
Backport admin tool update supporting (very) basic ...
Mon, 13 Jun 2005 20:33:16 GMT Kris Deugau [259]
* trunk/cgi-bin/admin.cgi (modified)
/trunk
Modify add user capability in admin.cgi to allow a
...
Mon, 13 Jun 2005 20:26:30 GMT Kris Deugau [258]
* trunk/cgi-bin/admin.cgi (modified)
/trunk
Add (very) limited user management to admin.cgi - add and
...
Tue, 31 May 2005 21:04:07 GMT Kris Deugau [257]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Update ipdb.psql tabledefs and default alloctypes
Tue, 31 May 2005 18:24:33 GMT Kris Deugau [256]
* trunk/cgi-bin/IPDB.pm (modified)
* trunk/cgi-bin/admin.cgi (modified)
* trunk/cgi-bin/main.cgi (modified)
/trunk
Merge bugfixes from /branches/stable r248:252.
Tue, 31 May 2005 18:18:35 GMT Kris Deugau [255]
* trunk/cgi-bin/main.cgi (modified)
* trunk/editDisplay.html (modified)
/trunk
Merge "Last Modified" display from /branches/stable r245
...
Tue, 31 May 2005 18:09:48 GMT Kris Deugau [254]
* trunk/editDisplay.html (modified)
* trunk/ipdb.css (modified)
/trunk
Revert CSS change that snuck in at r197 in /branches/new- ...
Mon, 30 May 2005 20:09:05 GMT Kris Deugau [253]
* branches/stable/cgi-bin/extras/db2rwhois.pl (modified)
/branches/stable
Cleanup commit for db2rwhois.pl; looks like I ...
Mon, 30 May 2005 15:30:46 GMT Kris Deugau [252]
* branches/stable/cgi-bin/admin.cgi (modified)
/branches/stable
Fixed bug where attempting to allocate a static IP ...
Mon, 30 May 2005 14:54:42 GMT Kris Deugau [251]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Tweak logging to include the actual IP allocated ...
Wed, 25 May 2005 14:25:17 GMT Kris Deugau [250]
* branches/stable/cgi-bin/IPDB.pm (modified)
/branches/stable
Fixed error message passback problem with ...
Wed, 25 May 2005 14:22:55 GMT Kris Deugau [249]
* branches/stable/cgi-bin/admin.cgi (modified)
/branches/stable
Fix error logging bug that dropped the alloctype ...
Wed, 18 May 2005 19:58:31 GMT Kris Deugau [248]
* branches/stable/cgi-bin/IPDB.pm (modified)
/branches/stable
Merge bugfix from /trunk r246
Wed, 18 May 2005 19:51:11 GMT Kris Deugau [247]
* trunk/cgi-bin/main.cgi (modified)
/trunk
Turn off notifications for devel changes. Don't need to ...
Wed, 18 May 2005 19:36:14 GMT Kris Deugau [246]
* trunk/cgi-bin/IPDB.pm (modified)
/trunk
Fix bug where assigning a static DSL block (or equivalent) ...
Thu, 05 May 2005 15:15:21 GMT Kris Deugau [245]
* branches/stable/cgi-bin/main.cgi (modified)
* branches/stable/editDisplay.html (modified)
/branches/stable
Add "Last modified" timestamp display to edit page
Wed, 27 Apr 2005 21:27:22 GMT Kris Deugau [244]
* branches/stable/cgi-bin/main.cgi (modified)
* branches/stable/editDisplay.html (modified)
* branches/stable/updated.html (modified)
/branches/stable
Semi-temporary change to allow SWIPing of existing ...
Tue, 19 Apr 2005 20:31:12 GMT Kris Deugau [243]
* branches/stable/header.inc (modified)
/branches/stable
OOPS!! Committed the "merge" header.inc in r242! ...
Tue, 19 Apr 2005 19:42:43 GMT Kris Deugau [242]
* branches/stable/addmaster.html (copied)
* branches/stable/addmaster.shtml (deleted)
* branches/stable/cgi-bin/CommonWeb.pm (modified)
* branches/stable/cgi-bin/IPDB.pm (modified)
* branches/stable/cgi-bin/admin.cgi (modified)
* branches/stable/cgi-bin/ipdb.psql (modified)
* branches/stable/cgi-bin/main.cgi (modified)
* branches/stable/editDisplay.html (modified)
* branches/stable/header.inc (modified)
* branches/stable/index.shtml (modified)
/branches/stable
Merge ACL support from /branches/acl up to r241
Tue, 19 Apr 2005 18:18:08 GMT Kris Deugau [241]
* branches/acl/cgi-bin/admin.cgi (modified)
/branches/acl
Bugfix and cosmetic cleanup. Remove the TEST warning ...
Tue, 19 Apr 2005 17:52:12 GMT Kris Deugau [240]
* trunk/cgi-bin/main.cgi (modified)
* trunk/editDisplay.html (modified)
/trunk
*Weird* display bugfix that doesn't show up in the branch ...
Tue, 19 Apr 2005 16:58:41 GMT Kris Deugau [239]
* branches/acl/cgi-bin/admin.cgi (modified)
/branches/acl
Bugfix for loading preexisting .htpasswd users - ...
Tue, 19 Apr 2005 16:27:57 GMT Kris Deugau [238]
* branches/acl/cgi-bin/ipdb.psql (modified)
/branches/acl
Bugfix in tabledef for users table (required for ...
Tue, 19 Apr 2005 16:25:47 GMT Kris Deugau [237]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Bugfix in tabledef for users table (required for ACLs)
- ...
Mon, 18 Apr 2005 20:31:34 GMT Kris Deugau [236]
* branches/sql-cleanup (deleted)
Repo cleanup:
Remove /branches/sql-cleanup
Mon, 18 Apr 2005 20:30:38 GMT Kris Deugau [235]
* branches/new-search-20050223 (deleted)
Repo cleanup:
Remove /branches/new-search-20050223
Mon, 18 Apr 2005 20:27:21 GMT Kris Deugau [234]
* trunk/cgi-bin/main.cgi (modified)
* trunk/cgi-bin/search.cgi (copied)
* trunk/compsearch.html (copied)
* trunk/header.inc (modified)
* trunk/help.html (modified)
* trunk/ipdb.css (modified)
/trunk
Merge new search capability from ...
Fri, 15 Apr 2005 22:11:39 GMT Kris Deugau [233]
* trunk/addmaster.html (copied)
* trunk/addmaster.shtml (deleted)
* trunk/cgi-bin/CommonWeb.pm (modified)
* trunk/cgi-bin/IPDB.pm (modified)
* trunk/cgi-bin/admin.cgi (modified)
* trunk/cgi-bin/ipdb.psql (modified)
* trunk/cgi-bin/main.cgi (modified)
* trunk/editDisplay.html (modified)
* trunk/header.inc (modified)
* trunk/index.shtml (modified)
/trunk
Merge /branches/acl r221, 222, 223, 225, 226 back to trunk
Fri, 15 Apr 2005 21:16:16 GMT Kris Deugau [232]
* trunk/changes.html (modified)
/trunk
Missing backport: update changes.html from /branches/stable r193
Fri, 15 Apr 2005 21:10:52 GMT Kris Deugau [231]
* trunk/cgi-bin/main.cgi (modified)
/trunk
Missing backport: update to fix display issue relating to
...
Fri, 15 Apr 2005 20:56:26 GMT Kris Deugau [230]
* branches/stable/footer.inc (modified)
/branches/stable
No idea how, but footer.inc was, er, b0rken. ...
Fri, 15 Apr 2005 20:49:07 GMT Kris Deugau [229]
* trunk/alloctypes.html (modified)
/trunk
Missing backport: pull update to alloctypes.html from
...
Fri, 15 Apr 2005 20:31:44 GMT Kris Deugau [228]
* trunk/cgi-bin/main.cgi (modified)
/trunk
Port forward bugfixes from /branches/stable r215, r220, and r224.
Fri, 15 Apr 2005 20:29:34 GMT Kris Deugau [227]
* trunk/cgi-bin/main.cgi (modified)
/trunk
Revert change from r73 (!!) that "allocates" a static IP ...
Fri, 15 Apr 2005 20:01:04 GMT Kris Deugau [226]
* branches/acl/cgi-bin/admin.cgi (modified)
/branches/acl
Admin tool updated to allow control of ACLs. At ...
Thu, 14 Apr 2005 19:45:44 GMT Kris Deugau [225]
* branches/acl/cgi-bin/main.cgi (modified)
* branches/acl/editDisplay.html (modified)
/branches/acl
All access to change or "delete" (static IPs aren't ...
Thu, 14 Apr 2005 19:33:50 GMT Kris Deugau [224]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Temporary-hack bugfix for extra (extra (extra)) ...
Wed, 13 Apr 2005 21:23:47 GMT Kris Deugau [223]
* branches/acl/addmaster.html (modified)
* branches/acl/cgi-bin/CommonWeb.pm (modified)
* branches/acl/cgi-bin/main.cgi (modified)
* branches/acl/header.inc (modified)
* branches/acl/index.shtml (modified)
/branches/acl
All access to add new records should be ACL-ified. ...
Wed, 13 Apr 2005 20:42:40 GMT Kris Deugau [222]
* branches/acl/addmaster.html (moved)
/branches/acl
"Proper" access controls on adding a master block ...
Wed, 13 Apr 2005 17:24:15 GMT Kris Deugau [221]
* branches/acl/cgi-bin/IPDB.pm (modified)
* branches/acl/cgi-bin/ipdb.psql (modified)
* branches/acl/cgi-bin/main.cgi (modified)
/branches/acl
Basic ACL support - load ACL data from db, do or ...
Thu, 07 Apr 2005 19:35:58 GMT Kris Deugau [220]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Fixed lack of proper break-and-exit on CustID ...
Wed, 06 Apr 2005 21:08:15 GMT Kris Deugau [219]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Missed some tabledef changes in r218
Wed, 06 Apr 2005 21:06:28 GMT Kris Deugau [218]
* trunk/cgi-bin/extras/db2rwhois.pl (modified)
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Updated SQL tabledefs with timestamps for master block, ...
Wed, 06 Apr 2005 20:49:54 GMT Kris Deugau [217]
* branches/acl (copied)
Create branch for ACL support
Wed, 06 Apr 2005 20:49:21 GMT Kris Deugau [216]
* branches/dns (copied)
Create branch for DNS integration
Wed, 06 Apr 2005 13:41:39 GMT Kris Deugau [215]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Fixed bug that blocked updates to city on static IPs
Tue, 05 Apr 2005 18:24:52 GMT Kris Deugau [214]
* trunk/cgi-bin/admin.cgi (modified)
* trunk/cgi-bin/consistency-check.pl (modified)
* trunk/cgi-bin/main.cgi (modified)
* trunk/cgi-bin/newcity.cgi (modified)
/trunk
Port bugfixes from /branches/stable r203-206 and r209-213 ...
Tue, 05 Apr 2005 17:39:53 GMT Kris Deugau [213]
* branches/stable/cgi-bin/consistency-check.pl (modified)
/branches/stable
Fix minor SQL buglets in consistency-check.pl that ...
Tue, 05 Apr 2005 17:36:10 GMT Kris Deugau [212]
* branches/stable/cgi-bin/consistency-check.pl (modified)
/branches/stable
Minor cosmetic fixes to consistency-check.pl, as ...
Mon, 04 Apr 2005 21:19:24 GMT Kris Deugau [211]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Fixed bug-in-waiting that would create some... ...
Fri, 01 Apr 2005 17:17:07 GMT Kris Deugau [210]
* branches/stable/cgi-bin/newcity.cgi (modified)
/branches/stable
Tweaked failure message for new city
Tue, 29 Mar 2005 20:12:14 GMT Kris Deugau [209]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Squash a buglet that caused Dynamic-route DSL ...
Tue, 22 Mar 2005 20:00:35 GMT Kris Deugau [208]
* branches/new-search-20050223/cgi-bin/main.cgi (modified)
* branches/new-search-20050223/cgi-bin/search.cgi (modified)
/branches/new-search-20050223
Final cleanup. This should be ...
Tue, 22 Mar 2005 19:53:24 GMT Kris Deugau [207]
* branches/new-search-20050223/cgi-bin/search.cgi (modified)
/branches/new-search-20050223
All search criteria complete.
Tue, 22 Mar 2005 17:15:10 GMT Kris Deugau [206]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Add Toronto to list of cities DSL pools can be in.
Mon, 21 Mar 2005 22:28:52 GMT Kris Deugau [205]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Add delete notification for tech@example.com
Mon, 21 Mar 2005 20:50:09 GMT Kris Deugau [204]
* branches/stable/cgi-bin/admin.cgi (modified)
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Add another user to admin access list
Mon, 21 Mar 2005 20:49:01 GMT Kris Deugau [203]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Update notifications with ADDED: prefix in subject
Fri, 18 Mar 2005 23:16:13 GMT Kris Deugau [202]
* branches/new-search-20050223/cgi-bin/search.cgi (modified)
* branches/new-search-20050223/compsearch.html (modified)
/branches/new-search-20050223
SQL for all except IP/netblock-based ...
Thu, 17 Mar 2005 23:02:08 GMT Kris Deugau [201]
* branches/new-search-20050223/cgi-bin/search.cgi (modified)
/branches/new-search-20050223
Functional multi-component search, ...
Thu, 17 Mar 2005 18:28:03 GMT Kris Deugau [200]
* branches/stable/cgi-bin/admin.cgi (modified)
* branches/stable/cgi-bin/main.cgi (modified)
* branches/stable/ipdb.css (modified)
/branches/stable
Backport admin.cgi update from /trunk r199
Add ...
Thu, 17 Mar 2005 17:30:51 GMT Kris Deugau [199]
* trunk/cgi-bin/admin.cgi (modified)
* trunk/cgi-bin/main.cgi (modified)
* trunk/ipdb.css (modified)
/trunk
Update admin.cgi (such as it was) to newer IPDB backend ...
Wed, 16 Mar 2005 20:58:48 GMT Kris Deugau [198]
* trunk/cgi-bin/allocate.pl (copied)
/trunk
Port allocate.pl forward to trunk from /branches/stable r188
Tue, 15 Mar 2005 18:48:12 GMT Kris Deugau [197]
* branches/new-search-20050223/cgi-bin/search.cgi (added)
* branches/new-search-20050223/compsearch.html (added)
* branches/new-search-20050223/header.inc (modified)
* branches/new-search-20050223/help.html (modified)
* branches/new-search-20050223/ipdb.css (modified)
/branches/new-search-20050223
Checkpoint commit:
- Search ...
Fri, 11 Mar 2005 21:04:59 GMT Kris Deugau [196]
* branches/new-custids (copied)
New branch - /branches/new-custids
For code updates (such as ...
Thu, 10 Mar 2005 22:15:28 GMT Kris Deugau [195]
* branches/stable/alloctypes.html (modified)
/branches/stable
Update "help me" documentation on alloctypes to ...
Thu, 10 Mar 2005 22:13:59 GMT Kris Deugau [194]
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Fix some potentially confusing display information ...
Thu, 10 Mar 2005 20:55:40 GMT Kris Deugau [193]
* branches/stable/changes.html (modified)
/branches/stable
Note new features merged in r192 in changes.html
Thu, 10 Mar 2005 19:15:19 GMT Kris Deugau [192]
* branches/stable/cgi-bin/IPDB.pm (modified)
* branches/stable/cgi-bin/consistency-check.pl (modified)
* branches/stable/cgi-bin/ipdb.psql (modified)
* branches/stable/cgi-bin/main.cgi (modified)
* branches/stable/fb-assign.html (modified)
/branches/stable
Merge updates and changes (and bugfixes to same) ...
Thu, 10 Mar 2005 18:46:49 GMT Kris Deugau [191]
* trunk/cgi-bin/main.cgi (modified)
/trunk
Fixed buglet that would have incorrectly allowed allocation ...
Tue, 08 Mar 2005 22:40:12 GMT Kris Deugau [190]
* trunk/cgi-bin/consistency-check.pl (modified)
/trunk
consistency-check.pl:
Updated to be consistent with the ...
Tue, 08 Mar 2005 22:37:46 GMT Kris Deugau [189]
* trunk/cgi-bin/IPDB.pm (modified)
* trunk/cgi-bin/ipdb.psql (modified)
* trunk/cgi-bin/main.cgi (modified)
/trunk
Caught some buglets in the HairyPerl(TM) ('$1' vs "$1")
...
Mon, 07 Mar 2005 22:51:25 GMT Kris Deugau [188]
* branches/stable/cgi-bin/allocate.pl (added)
/branches/stable
Added allocate.pl to make allocation of arbitrary ...
Fri, 04 Mar 2005 23:12:54 GMT Kris Deugau [187]
* trunk/cgi-bin/IPDB.pm (modified)
* trunk/cgi-bin/ipdb.psql (modified)
* trunk/cgi-bin/main.cgi (modified)
* trunk/fb-assign.html (modified)
/trunk
Another herd of changes to alloctypes. This cleaned up the ...
Thu, 03 Mar 2005 22:14:54 GMT Kris Deugau [186]
* trunk/cgi-bin/IPDB.pm (modified)
* trunk/cgi-bin/main.cgi (modified)
/trunk
First round of changes for "clean" handling of subblock ...
Tue, 01 Mar 2005 21:31:04 GMT Kris Deugau [185]
* branches/stable/cgi-bin/IPDB.pm (modified)
* branches/stable/cgi-bin/ipdb.psql (modified)
* branches/stable/cgi-bin/main.cgi (modified)
/branches/stable
Backport SQL/SQL-related bugfixes from /trunk r180 ...
Tue, 01 Mar 2005 21:22:39 GMT Kris Deugau [184]
* trunk/cgi-bin/IPDB.pm (modified)
* trunk/cgi-bin/main.cgi (modified)
/trunk
Tweaked another few fixes into place to make a "fresh" ...
Tue, 01 Mar 2005 21:05:45 GMT Kris Deugau [183]
* trunk/cgi-bin/IPDB.pm (modified)
/trunk
Change database connection check slightly to select from the ...
Tue, 01 Mar 2005 20:57:53 GMT Kris Deugau [182]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Preseed alloctypes table with current types ("common" ones ...
Tue, 01 Mar 2005 20:56:35 GMT Kris Deugau [181]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Change SQL definitions to create the database before ...
Tue, 01 Mar 2005 19:44:40 GMT Kris Deugau [180]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Fix another buglet with the SQL definitions. Picky, picky...
Tue, 01 Mar 2005 19:08:15 GMT Kris Deugau [179]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Fix buglet in SQL definitions (ported forward from ...
Tue, 01 Mar 2005 19:05:24 GMT Kris Deugau [178]
* branches/stable/cgi-bin/ipdb.psql (modified)
/branches/stable
Fix buglet in SQL definitions
Tue, 01 Mar 2005 18:33:45 GMT Kris Deugau [177]
* branches/stable/cgi-bin/ipdb.psql (modified)
/branches/stable
Update ipdb.psql database definition with ...
Tue, 01 Mar 2005 18:31:45 GMT Kris Deugau [176]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Full update of ipdb.psql without extraneous pg_dump bits, ...
Tue, 01 Mar 2005 16:49:46 GMT Kris Deugau [175]
* trunk/cgi-bin/ipdb.psql (modified)
/trunk
Updated SQL table definitions - pg_dump format