[prev] [thread] [next] [lurker] [Date index for 2002/08/23]
Update of /cvsroot/siesta/siesta/bin In directory usw-pr-cvs1:/tmp/cvs-serv14362 Modified Files: populate_db.sql Log Message: insert ids Index: populate_db.sql =================================================================== RCS file: /cvsroot/siesta/siesta/bin/populate_db.sql,v retrieving revision 1.5 retrieving revision 1.6 diff -u -d -r1.5 -r1.6 --- populate_db.sql 23 Aug 2002 10:58:38 -0000 1.5 +++ populate_db.sql 23 Aug 2002 13:33:50 -0000 1.6 @@ -18,30 +18,30 @@ '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 ( id, list_id, user_id) + VALUES ( 1, 'siesta-dev', 'greg@xxxxxxxxx.xxxxx.xx.xx' ); +INSERT INTO list_users ( id, list_id, user_id) + VALUES ( 2, 'siesta-dev', 'richardc@xxxxxxxxx.xxx' ); +INSERT INTO list_users ( id, list_id, user_id) + VALUES ( 3, 'siesta-dev', 'simon@xxxxxxxxxx.xxx' ); -INSERT INTO list_users ( list_id, user_id) - VALUES ( 'siesta-commit', 'richardc@xxxxxxxxx.xxx' ); +INSERT INTO list_users ( id, list_id, user_id) + VALUES ( 4, '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 ( id, plugin_id , list_id ) + VALUES ( 1, 'SimpleSig', 'siesta-dev' ); +INSERT INTO list_plugins ( id, plugin_id , list_id ) + VALUES ( 2, 'MembersOnly', 'siesta-dev' ); +INSERT INTO list_plugins ( id, plugin_id , list_id ) + VALUES ( 3, 'Archive', 'siesta-dev' ); +INSERT INTO list_plugins ( id, plugin_id , list_id ) + VALUES ( 4, '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 ( id, plugin_id , list_id ) + VALUES ( 5, 'Send', 'siesta-commit' ); +INSERT INTO list_plugins ( id, plugin_id , list_id ) + VALUES ( 6, 'Archive', 'siesta-commit' ); -INSERT INTO list_plugins ( plugin_id , list_id ) - VALUES ( 'Archive', 'siesta-test' ); +INSERT INTO list_plugins ( id, plugin_id , list_id ) + VALUES ( 7, 'Archive', 'siesta-test' );
Generated at 13:57 on 01 Jul 2004 by mariachi 0.52