[prev] [thread] [next] [lurker] [Date index for 2002/08/23]
Update of /cvsroot/siesta/siesta/bin In directory usw-pr-cvs1:/tmp/cvs-serv9807 Modified Files: populate_db.sql Log Message: 80 chars Index: populate_db.sql =================================================================== RCS file: /cvsroot/siesta/siesta/bin/populate_db.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- populate_db.sql 22 Aug 2002 20:52:51 -0000 1.4 +++ populate_db.sql 23 Aug 2002 10:58:38 -0000 1.5 @@ -1,17 +1,47 @@ -INSERT INTO users ( id , forename, surname, password, bouncing ) VALUES ( 'greg@xxxxxxxxx.xxxxx.xx.xx', 'Greg', 'McCarroll', 'FIXME', 0 ); -INSERT INTO users ( id , forename, surname, password, bouncing ) VALUES ( 'richardc@xxxxxxxxx.xxx', 'Richard', 'Clamp', 'FIXME', 0 ); -INSERT INTO users ( id , forename, surname, password, bouncing ) VALUES ( 'simon@xxxxxxxxxx.xxx', 'Simon', 'Wistow', 'FIXME', 0 ); -INSERT INTO lists ( id , owner, post_address, return_path ) VALUES ( 'siesta-dev', 'greg@xxxxxxxxx.xxxxx.xx.xx', 'siesta-dev@xxxxxxxxx.xxx', 'siesta-dev-bounce@xxxxxxxxx.xxx' ); -INSERT INTO lists ( id , owner, post_address, return_path ) VALUES ( 'siesta-commit', 'richardc@xxxxxxxxx.xxx', 'siesta-commit@xxxxxxxxx.xxx', 'siesta-commit-bounce@xxxxxxxxx.xxx' ); -INSERT INTO lists ( id , owner, post_address, return_path ) VALUES ( 'siesta-test', 'greg@xxxxxxxxx.xxxxx.xx.xx', 'siesta-test@xxxxxxxxx.xxx', 'siesta-test-bounce@xxxxxxxxx.xxx' ); -INSERT INTO list_users ( list_id, user_id) VALUES ( 'siesta-dev', 'greg@xxxxxxxxx.xxxxx.xx.xx' ); -INSERT INTO list_users ( list_id, user_id) VALUES ( 'siesta-dev', 'richardc@xxxxxxxxx.xxx' ); -INSERT INTO list_users ( list_id, user_id) VALUES ( 'siesta-dev', 'simon@xxxxxxxxxx.xxx' ); -INSERT INTO list_users ( list_id, user_id) VALUES ( 'siesta-commit', 'richardc@xxxxxxxxx.xxx' ); -INSERT INTO list_plugins ( plugin_id , list_id ) VALUES ( 'SimpleSig', 'siesta-dev' ); -INSERT INTO list_plugins ( plugin_id , list_id ) VALUES ( 'MembersOnly', 'siesta-dev' ); -INSERT INTO list_plugins ( plugin_id , list_id ) VALUES ( 'Archive', 'siesta-dev' ); -INSERT INTO list_plugins ( plugin_id , list_id ) VALUES ( 'Send', 'siesta-dev' ); -INSERT INTO list_plugins ( plugin_id , list_id ) VALUES ( 'Send', 'siesta-commit' ); -INSERT INTO list_plugins ( plugin_id , list_id ) VALUES ( 'Archive', 'siesta-commit' ); -INSERT INTO list_plugins ( plugin_id , list_id ) VALUES ( 'Archive', 'siesta-test' ); +INSERT INTO users ( id , forename, surname, password, bouncing ) + VALUES ( 'greg@xxxxxxxxx.xxxxx.xx.xx', 'Greg', 'McCarroll', 'FIXME', 0 ); +INSERT INTO users ( id , forename, surname, password, bouncing ) + VALUES ( 'richardc@xxxxxxxxx.xxx', 'Richard', 'Clamp', 'FIXME', 0 ); +INSERT INTO users ( id , forename, surname, password, bouncing ) + VALUES ( 'simon@xxxxxxxxxx.xxx', 'Simon', 'Wistow', 'FIXME', 0 ); + +INSERT INTO lists ( id , owner, post_address, return_path ) + VALUES ( 'siesta-dev', 'greg@xxxxxxxxx.xxxxx.xx.xx', + 'siesta-dev@xxxxxxxxx.xxx', + 'siesta-dev-bounce@xxxxxxxxx.xxx' ); +INSERT INTO lists ( id , owner, post_address, return_path ) + VALUES ( 'siesta-commit', 'richardc@xxxxxxxxx.xxx', + 'siesta-commit@xxxxxxxxx.xxx', + 'siesta-commit-bounce@xxxxxxxxx.xxx' ); +INSERT INTO lists ( id , owner, post_address, return_path ) + VALUES ( 'siesta-test', 'greg@xxxxxxxxx.xxxxx.xx.xx', + 'siesta-test@xxxxxxxxx.xxx', + 'siesta-test-bounce@xxxxxxxxx.xxx' ); + +INSERT INTO list_users ( list_id, user_id) + VALUES ( 'siesta-dev', 'greg@xxxxxxxxx.xxxxx.xx.xx' ); +INSERT INTO list_users ( list_id, user_id) + VALUES ( 'siesta-dev', 'richardc@xxxxxxxxx.xxx' ); +INSERT INTO list_users ( list_id, user_id) + VALUES ( 'siesta-dev', 'simon@xxxxxxxxxx.xxx' ); + +INSERT INTO list_users ( list_id, user_id) + VALUES ( 'siesta-commit', 'richardc@xxxxxxxxx.xxx' ); + + +INSERT INTO list_plugins ( plugin_id , list_id ) + VALUES ( 'SimpleSig', 'siesta-dev' ); +INSERT INTO list_plugins ( plugin_id , list_id ) + VALUES ( 'MembersOnly', 'siesta-dev' ); +INSERT INTO list_plugins ( plugin_id , list_id ) + VALUES ( 'Archive', 'siesta-dev' ); +INSERT INTO list_plugins ( plugin_id , list_id ) + VALUES ( 'Send', 'siesta-dev' ); + +INSERT INTO list_plugins ( plugin_id , list_id ) + VALUES ( 'Send', 'siesta-commit' ); +INSERT INTO list_plugins ( plugin_id , list_id ) + VALUES ( 'Archive', 'siesta-commit' ); + +INSERT INTO list_plugins ( plugin_id , list_id ) + VALUES ( 'Archive', 'siesta-test' );
Generated at 13:57 on 01 Jul 2004 by mariachi 0.52