Index: trunk/dns.sql
===================================================================
--- trunk/dns.sql	(revision 88)
+++ trunk/dns.sql	(revision 89)
@@ -8,4 +8,5 @@
 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,4 +55,5 @@
 
 CREATE TABLE log (
+    log_id serial NOT NULL,
     domain_id integer,
     user_id integer,
@@ -85,12 +87,13 @@
 -- 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,4 +104,9 @@
     ttl integer DEFAULT 7200 NOT NULL,
     description character varying(255)
+);
+
+CREATE TABLE longrecs (
+    longrec_id serial NOT NULL,
+    recdata text
 );
 
@@ -196,5 +204,5 @@
 -- 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
 \.