Changeset 212 for trunk/dns.sql

Timestamp:

12/21/11 17:49:46 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Begin setting up the barest sketch of what will eventually become
a complete automagical DB init/upgrade feature. See #34.

File:

• trunk/dns.sql (modified) (2 diffs)

trunk/dns.sql

@@ -5 +5 @@
 -- CREATE DATABASE dnsdb OWNED BY dnsdb;
 -- SET SESSION AUTHORIZATION 'dnsdb';
+
+-- need a handy place to put eg a DB version identifier - useful for auto-upgrading a DB
+CREATE TABLE misc (
+        misc_id serial NOT NULL,
+        key text DEFAULT '' NOT NULL,
+        value test DEFAULT '' NOT NULL
+);
+
+COPY misc (misc_id, key, value) FROM stdin;
+1       dbversion       1.0
+\.
 
 CREATE TABLE default_records (
@@ -253 +264 @@
 
 -- set starting sequence numbers, since we've inserted data before they're active
+SELECT pg_catalog.setval('misc_misc_id_seq', 1, true);
 SELECT pg_catalog.setval('default_records_record_id_seq', 8, true);
 SELECT pg_catalog.setval('domains_domain_id_seq', 1, false);