[prev] [thread] [next] [lurker] [Date index for 2002/08/23]
Update of /cvsroot/siesta/siesta/t In directory usw-pr-cvs1:/tmp/cvs-serv8048 Modified Files: create_db.sql Log Message: make fit into 80 chars Index: create_db.sql =================================================================== RCS file: /cvsroot/siesta/siesta/t/create_db.sql,v retrieving revision 1.9 retrieving revision 1.10 diff -u -d -r1.9 -r1.10 --- create_db.sql 23 Aug 2002 10:08:51 -0000 1.9 +++ create_db.sql 23 Aug 2002 10:54:21 -0000 1.10 @@ -1,10 +1,25 @@ -INSERT INTO users ( id , forename, surname, password, bouncing ) VALUES ( 'jay@xxxxxxxx.xxxxxxxxxx', 'Jay', '', 'FIXME', 0 ); -INSERT INTO users ( id , forename, surname, password, bouncing ) VALUES ( 'bob@xxxxxxxx.xxxxxxxxxx', 'Silent', 'Bob', 'FIXME', 0 ); -INSERT INTO users ( id , forename, surname, password, bouncing ) VALUES ( 'dante@quick-stop', 'Dante', 'Hicks', 'FIXME', 0 ); -INSERT INTO users ( id , forename, surname, password, bouncing ) VALUES ( 'randal@rst-video', 'Randal', 'Graves', 'FIXME', 0 ); -INSERT INTO lists ( id , owner, post_address, return_path ) VALUES ( 'dealers', 'jay@xxxxxxxx.xxxxxxxxxx', 'dealers@xxxxxxxx.xxxxxxxxxx', 'dealers-bounce@xxxxxxxx.xxxxxxxxxx' ); -INSERT INTO list_users ( id, list_id, user_id) VALUES ( 1, 'dealers', 'jay@xxxxxxxx.xxxxxxxxxx' ); -INSERT INTO list_users ( id, list_id, user_id) VALUES ( 2, 'dealers', 'bob@xxxxxxxx.xxxxxxxxxx' ); -INSERT INTO list_plugins ( id, list_id, plugin_id ) VALUES ( 1, 'dealers', 'SimpleSig' ); -INSERT INTO list_plugins ( id, list_id, plugin_id ) VALUES ( 2, 'dealers', 'MembersOnly' ); -INSERT INTO list_plugins ( id, list_id, plugin_id ) VALUES ( 3, 'dealers', 'Send' ); +INSERT INTO users ( id , forename, surname, password, bouncing ) + VALUES ( 'jay@xxxxxxxx.xxxxxxxxxx', 'Jay', '', 'FIXME', 0 ); +INSERT INTO users ( id , forename, surname, password, bouncing ) + VALUES ( 'bob@xxxxxxxx.xxxxxxxxxx', 'Silent', 'Bob', 'FIXME', 0 ); +INSERT INTO users ( id , forename, surname, password, bouncing ) + VALUES ( 'dante@quick-stop', 'Dante', 'Hicks', 'FIXME', 0 ); +INSERT INTO users ( id , forename, surname, password, bouncing ) + VALUES ( 'randal@rst-video', 'Randal', 'Graves', 'FIXME', 0 ); + +INSERT INTO lists ( id , owner, post_address, return_path ) + VALUES ( 'dealers', 'jay@xxxxxxxx.xxxxxxxxxx', + 'dealers@xxxxxxxx.xxxxxxxxxx', + 'dealers-bounce@xxxxxxxx.xxxxxxxxxx' ); + +INSERT INTO list_users ( id, list_id, user_id) + VALUES ( 1, 'dealers', 'jay@xxxxxxxx.xxxxxxxxxx' ); +INSERT INTO list_users ( id, list_id, user_id) + VALUES ( 2, 'dealers', 'bob@xxxxxxxx.xxxxxxxxxx' ); + +INSERT INTO list_plugins ( id, list_id, plugin_id ) + VALUES ( 1, 'dealers', 'SimpleSig' ); +INSERT INTO list_plugins ( id, list_id, plugin_id ) + VALUES ( 2, 'dealers', 'MembersOnly' ); +INSERT INTO list_plugins ( id, list_id, plugin_id ) + VALUES ( 3, 'dealers', 'Send' );
Generated at 13:57 on 01 Jul 2004 by mariachi 0.52