1 diff -Nur -x '*.orig' -x '*.rej' gforge-3.0/db/gforge3.sql mezzanine_patched_gforge-3.0/db/gforge3.sql
2 --- gforge-3.0/db/gforge3.sql Fri Jun 20 07:42:09 2003
3 +++ mezzanine_patched_gforge-3.0/db/gforge3.sql Tue Sep 30 21:48:34 2003
5 SELECT setval ('"user_metric0_pk_seq"', 1, false);
8 -SELECT setval ('"users_pk_seq"', 101, true);
9 +SELECT setval ('"users_pk_seq"', 102, true);
12 SELECT setval ('"unix_uid_seq"', 1, false);
13 @@ -4091,3 +4091,18 @@
15 SELECT setval ('"user_plugin_pk_seq"', 1, false);
17 +INSERT INTO "users" ("user_id","user_name","email","user_pw","realname","status","shell","unix_pw","unix_status","unix_uid","unix_box","add_date","confirm_hash","mail_siteupdates","mail_va","authorized_keys","email_new","people_view_skills","people_resume","timezone","language","block_ratings","jabber_address","jabber_only") VALUES (101,'siteadmin','gforge@localhost','','GForge Site Admin','A','/bin/bash','','N',0,'shell1',1043359556,'',0,0,NULL,NULL,0,'','GMT',1,0,'',0);
19 +INSERT INTO user_group (user_id, group_id, admin_flags) VALUES (101, 1, 'A');
20 +INSERT INTO user_group (user_id, group_id, admin_flags) VALUES (101, 2, 'A');
21 +INSERT INTO user_group (user_id, group_id, admin_flags) VALUES (101, 3, 'A');
22 +INSERT INTO user_group (user_id, group_id, admin_flags) VALUES (101, 4, 'A');
24 +UPDATE groups SET homepage = '/admin/' WHERE group_id = 1;
25 +UPDATE groups SET homepage = '/news/' WHERE group_id = 2;
26 +UPDATE groups SET homepage = '/stats/' WHERE group_id = 3;
27 +UPDATE groups SET homepage = '/peerrating/' WHERE group_id = 4;
29 +ALTER TABLE themes ADD COLUMN enabled BOOLEAN ;
30 +ALTER TABLE themes ALTER enabled SET DEFAULT TRUE ;
31 +UPDATE themes SET enabled=true;