Changeset 89 for trunk/dns.sql

Timestamp:

04/07/11 15:40:50 (13 years ago)

Author:

Kris Deugau

Message:

/trunk

SQL tabledef updates:

• references and definition for longrecs table to contain data for records that need >100 chars
• Basic initial group permissions switched to include domain and record add/delete/update
• Initial admin user created with a somewhat better username, and first/last name filled in

File:

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

trunk/dns.sql

@@ -8 +8 @@
 CREATE TABLE default_records (
     record_id serial NOT NULL,
+    longrec_id integer,
     group_id integer DEFAULT 1 NOT NULL,
     host character varying(100) DEFAULT ''::character varying NOT NULL,
@@ -54 +55 @@
 
 CREATE TABLE log (
+    log_id serial NOT NULL,
     domain_id integer,
     user_id integer,
@@ -85 +87 @@
 -- 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, user_id, group_id) FROM stdin;
-1       f       f       f       f       f       f       f       f       f       f       f       f       f       f       \N      1
+1       f       f       f       f       f       f       f       f       t       t       t       t       t       t       \N      1
 2       t       f       f       f       f       f       f       f       f       f       f       f       f       f       1       \N
 \.
 
--- fixeme:  need to handle looooong TXT records (eg, SPF)
+-- fixme:  need to handle looooong records (eg, SPF)
 CREATE TABLE records (
     domain_id integer NOT NULL,
     record_id serial NOT NULL,
+    longrec_id integer,
     host character varying(100) DEFAULT ''::character varying NOT NULL,
     "type" integer DEFAULT 1 NOT NULL,
@@ -101 +104 @@
     ttl integer DEFAULT 7200 NOT NULL,
     description character varying(255)
+);
+
+CREATE TABLE longrecs (
+    longrec_id serial NOT NULL,
+    recdata text
 );
 
@@ -196 +204 @@
 -- 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, permission_id, inherit_perm) FROM stdin;
-1       1       test@test       $1$BByge8u2$48AaGX3YeHplfErX5Tlqa1      \N      \N      \N      S       1       2       f
+1       1       admin   $1$PfEBUv9d$wV2/UG4gmKk08DLmdE8/d.      Initial User    \N      S       1       2       f
 \.