[siesta-commit] siesta/bin create_db.sql,1.12,1.13 populate_db.sql,1.13,1.14

[prev] [thread] [next] [lurker] [Date index for 2002/09/08]

Update of /cvsroot/siesta/siesta/bin
In directory usw-pr-cvs1:/tmp/cvs-serv24094/bin

Modified Files:
	create_db.sql populate_db.sql 
Log Message:
Add config stuff.


Index: create_db.sql
===================================================================
RCS file: /cvsroot/siesta/siesta/bin/create_db.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -d -r1.12 -r1.13
--- create_db.sql	2 Sep 2002 15:16:07 -0000	1.12
+++ create_db.sql	8 Sep 2002 10:59:48 -0000	1.13
@@ -24,22 +24,10 @@
 	plugin_id	VARCHAR(20),
 	list_id		VARCHAR(20)
 );
-CREATE TABLE list_config (
-	id              VARCHAR(20),
-	namespace	VARCHAR(255),
-	key             VARCHAR(255),
-	value           VARCHAR(255)
-);
-CREATE TABLE user_config (
-	id              VARCHAR(20),
-	namespace	VARCHAR(255),
-	key             VARCHAR(255),
-	value           VARCHAR(255)
-);
-CREATE TABLE listuser_config (
-	id              VARCHAR(20),
+CREATE TABLE config (
 	namespace	VARCHAR(255),
+        list_id         VARCHAR(20),
+        user_id         VARCHAR(30),
 	key             VARCHAR(255),
 	value           VARCHAR(255)
 );
-

Index: populate_db.sql
===================================================================
RCS file: /cvsroot/siesta/siesta/bin/populate_db.sql,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -d -r1.13 -r1.14
--- populate_db.sql	2 Sep 2002 15:16:07 -0000	1.13
+++ populate_db.sql	8 Sep 2002 10:59:48 -0000	1.14
@@ -50,9 +50,16 @@
 	VALUES ( 11, 'Send', 'siesta-commit' );
 
 
-INSERT INTO user_config (id, namespace, key, value)
-	VALUES ('jay@xxxxxxxx.xxxxxxxxxx', 'bar', 'a', 'b');
 
-INSERT INTO list_config (id, namespace, key, value)
-	VALUES ('dealers', 'bar', 'a', 'b');
+INSERT INTO config (namespace, user_id, list_id, key, value)
+	VALUES ('ReplyTo', '', '', 'munge', '1');
+
+INSERT INTO config (namespace, user_id, list_id, key, value)
+	VALUES ('ReplyTo', '', 'siesta-dev', 'munge', '0');
+
+INSERT INTO config (namespace, user_id, list_id, key, value)
+	VALUES ('ReplyTo', 'simon@xxxxxxxxxx.xxx', '', 'munge', '1');
+
+INSERT INTO config (namespace, user_id, list_id, key, value)
+	VALUES ('ReplyTo', 'simon@xxxxxxxxxx.xxx', 'siesta-dev', 'munge', '0');
 

• [siesta-commit] siesta/bin create_db.sql,1.12,1.13 populate_db.sql,1.13,1.14 muttley 11:59 on 08 Sep 2002

Generated at 13:57 on 01 Jul 2004 by mariachi 0.52