Changeset 89
- Timestamp:
- 04/07/11 15:40:50 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dns.sql
r87 r89 8 8 CREATE TABLE default_records ( 9 9 record_id serial NOT NULL, 10 longrec_id integer, 10 11 group_id integer DEFAULT 1 NOT NULL, 11 12 host character varying(100) DEFAULT ''::character varying NOT NULL, … … 54 55 55 56 CREATE TABLE log ( 57 log_id serial NOT NULL, 56 58 domain_id integer, 57 59 user_id integer, … … 85 87 -- Need *two* basic permissions; one for the initial group, one for the default admin user 86 88 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; 87 1 f f f f f f f f f f f f f f\N 189 1 f f f f f f f f t t t t t t \N 1 88 90 2 t f f f f f f f f f f f f f 1 \N 89 91 \. 90 92 91 -- fix eme: need to handle looooong TXTrecords (eg, SPF)93 -- fixme: need to handle looooong records (eg, SPF) 92 94 CREATE TABLE records ( 93 95 domain_id integer NOT NULL, 94 96 record_id serial NOT NULL, 97 longrec_id integer, 95 98 host character varying(100) DEFAULT ''::character varying NOT NULL, 96 99 "type" integer DEFAULT 1 NOT NULL, … … 101 104 ttl integer DEFAULT 7200 NOT NULL, 102 105 description character varying(255) 106 ); 107 108 CREATE TABLE longrecs ( 109 longrec_id serial NOT NULL, 110 recdata text 103 111 ); 104 112 … … 196 204 -- create initial default user? may be better to create an "initialize" script or something 197 205 COPY users (user_id, group_id, username, "password", firstname, lastname, phone, "type", status, permission_id, inherit_perm) FROM stdin; 198 1 1 test@test $1$BByge8u2$48AaGX3YeHplfErX5Tlqa1 \N \N\N S 1 2 f206 1 1 admin $1$PfEBUv9d$wV2/UG4gmKk08DLmdE8/d. Initial User \N S 1 2 f 199 207 \. 200 208
Note:
See TracChangeset
for help on using the changeset viewer.