Changeset 395 for trunk

Timestamp:

09/24/12 17:42:30 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Fix thinko in recording tabledef update for record location for new DB. See #10.
Remove duplicate primary key definition in new DB.

File:

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

trunk/dns.sql

@@ -162 +162 @@
     ttl integer DEFAULT 7200 NOT NULL,
     description text,
-    default_location character varying (4) DEFAULT '' NOT NULL
+    location character varying (4) DEFAULT '' NOT NULL
 );
 
@@ -284 +284 @@
 
 ALTER TABLE ONLY domains
-    ADD CONSTRAINT domains_pkey PRIMARY KEY ("domain");
-
-ALTER TABLE ONLY domains
     ADD CONSTRAINT domains_domain_id_key UNIQUE (domain_id);