Changeset 86 for trunk/dns.sql

Timestamp:

03/08/11 23:08:25 (13 years ago)

Author:

Kris Deugau

Message:

/trunk

Tweak initial SQL definitions further so it actually works out of the box

File:

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

trunk/dns.sql

@@ -49 +49 @@
 
 -- Provide a basic default group
-COPY groups (group_id, parent_group_id, group_name) FROM stdin;
+COPY groups (group_id, parent_group_id, permission_id, group_name) FROM stdin;
 1       1       1       default
 \.
@@ -79 +79 @@
     record_edit boolean DEFAULT false NOT NULL,
     record_delete boolean DEFAULT false NOT NULL,
-    user_id integer DEFAULT 0 NOT NULL,
-    group_id integer DEFAULT 0 NOT NULL
+    user_id integer UNIQUE,
+    group_id integer UNIQUE
 );
 
 -- Need *two* basic permissions;  one for the initial group, one for the default admin user
-COPY permissions (permission_id, admin, self_edit, group_create, group_edit group_delete, user_create, user_edit, user_delete, domain_create, domain_edit, domain_delete, record_create, record_edit, record_delete) FROM stdin;
-1       n       n       n       n       n       n       n       n       n       n       n       n       n       n
-2       y       n       n       n       n       n       n       n       n       n       n       n       n       n
+COPY permissions (permission_id, admin, self_edit, group_create, group_edit, group_delete, user_create, user_edit, user_delete, domain_create, domain_edit, domain_delete, record_create, record_edit, record_delete, user_id, group_id) FROM stdin;
+1       f       f       f       f       f       f       f       f       f       f       f       f       f       f       \N      1
+2       t       f       f       f       f       f       f       f       f       f       f       f       f       f       1       \N
 \.
 
@@ -195 +195 @@
 
 -- create initial default user?  may be better to create an "initialize" script or something
-COPY users (user_id, group_id, username, "password", firstname, lastname, phone, "type", status, acl) FROM stdin;
-1       1       test@test       $1$BByge8u2$48AaGX3YeHplfErX5Tlqa1      \N      \N      \N      S       1       A       2
+COPY users (user_id, group_id, username, "password", firstname, lastname, phone, "type", status, permission_id, inherit_perm) FROM stdin;
+1       1       test@test       $1$BByge8u2$48AaGX3YeHplfErX5Tlqa1      \N      \N      \N      S       1       2       f
 \.
 
@@ -247 +247 @@
 ALTER TABLE ONLY groups
     ADD CONSTRAINT group_parent FOREIGN KEY (parent_group_id) REFERENCES groups(group_id);
+
+-- set starting sequence numbers, since we've inserted data before they're active
+SELECT pg_catalog.setval('default_records_record_id_seq', 8, true);
+SELECT pg_catalog.setval('domains_domain_id_seq', 1, false);
+SELECT pg_catalog.setval('groups_group_id_seq', 2, true);
+SELECT pg_catalog.setval('permissions_permission_id_seq', 3, true);
+SELECT pg_catalog.setval('records_record_id_seq', 1, false);
+SELECT pg_catalog.setval('users_user_id_seq', 2, false);