Changeset 756 for branches/stable/dns.sql

Timestamp:

06/13/17 13:58:57 (7 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Merge /trunk through r749 for 1.4.0

Location:

branches/stable

Files:

• . (modified) (1 prop)
• dns.sql (modified) (2 diffs)

branches/stable/dns.sql

@@ -31 +31 @@
 
 COPY misc (misc_id, key, value) FROM stdin;
-1       dbversion       1.2.6
+1       dbversion       1.4.0
 \.
 
@@ -136 +136 @@
     entry text,
     stamp timestamp with time zone DEFAULT now(),
-    rdns_id integer
-);
+    rdns_id integer,
+    logparent integer NOT NULL DEFAULT 0
+);
+CREATE INDEX log_domain_id_index ON log(domain_id);
+CREATE INDEX log_user_id_index ON log(user_id);
+CREATE INDEX log_group_id_index ON log(group_id);
+CREATE INDEX log_rdns_id_index ON log(rdns_id);
 
 CREATE TABLE permissions (