Changeset 734

Timestamp:

06/23/16 17:03:46 (9 years ago)

Author:

Kris Deugau

Message:

/trunk

Add some missing indexes in the targeted 1.4.0 SQL schema.

Location:

trunk

Files:

• dns-upd-1.4.0.sql (added)
• dns.sql (modified) (2 diffs)

trunk/dns.sql

@@ -31 +31 @@
 
 COPY misc (misc_id, key, value) FROM stdin;
-1       dbversion       1.2.6
+1       dbversion       1.4.0
 \.
 
@@ -138 +138 @@
     rdns_id integer
 );
+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 (