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

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

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

Modified Files:
	create_db.sql populate_db.sql 
Log Message:
Huge batch of changes to get config working. 


Index: create_db.sql
===================================================================
RCS file: /cvsroot/siesta/siesta/bin/create_db.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- create_db.sql	1 Sep 2002 12:09:15 -0000	1.11
+++ create_db.sql	2 Sep 2002 15:16:07 -0000	1.12
@@ -24,19 +24,19 @@
 	plugin_id	VARCHAR(20),
 	list_id		VARCHAR(20)
 );
-create TABLE list_config (
+CREATE TABLE list_config (
 	id              VARCHAR(20),
 	namespace	VARCHAR(255),
 	key             VARCHAR(255),
 	value           VARCHAR(255)
 );
-create TABLE user_config (
+CREATE TABLE user_config (
 	id              VARCHAR(20),
 	namespace	VARCHAR(255),
 	key             VARCHAR(255),
 	value           VARCHAR(255)
 );
-create TABLE listuser_config (
+CREATE TABLE listuser_config (
 	id              VARCHAR(20),
 	namespace	VARCHAR(255),
 	key             VARCHAR(255),

Index: populate_db.sql
===================================================================
RCS file: /cvsroot/siesta/siesta/bin/populate_db.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -d -r1.12 -r1.13
--- populate_db.sql	29 Aug 2002 07:32:09 -0000	1.12
+++ populate_db.sql	2 Sep 2002 15:16:07 -0000	1.13
@@ -48,3 +48,11 @@
 	VALUES ( 10, 'Archive', 'siesta-commit' );
 INSERT INTO list_plugins ( id, plugin_id , list_id ) 
 	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');
+

• [siesta-commit] siesta/bin create_db.sql,1.11,1.12 populate_db.sql,1.12,1.13 muttley 16:16 on 02 Sep 2002

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