[Sommaire] [Imprimer]

   1  CREATE TABLE access (
   2    acc_ft_id mediumint(8) NOT NULL default '0',
   3    acc_grp_id mediumint(8) NOT NULL default '0',
   4    PRIMARY KEY  (acc_ft_id,acc_grp_id)
   5  ) TYPE=MyISAM;
   6  
   7  ALTER TABLE blocks ADD name varchar(48) NOT NULL default '';
   8  ALTER TABLE blocks DROP seclev;
   9  ALTER TABLE blocks ADD onleft tinyint(3) unsigned NOT NULL default '1';
  10  ALTER TABLE blocks ADD phpblockfn varchar(64) default '';
  11  ALTER TABLE blocks ADD group_id mediumint(8) unsigned NOT NULL default '1';
  12  ALTER TABLE blocks ADD owner_id mediumint(8) unsigned NOT NULL default '0';
  13  ALTER TABLE blocks ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
  14  ALTER TABLE blocks ADD perm_group tinyint(1) unsigned NOT NULL default '3';
  15  ALTER TABLE blocks ADD perm_members tinyint(1) unsigned NOT NULL default '2';
  16  ALTER TABLE blocks ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
  17  
  18  CREATE TABLE cookiecodes (
  19    cc_value int(8) unsigned NOT NULL default '0',
  20    cc_descr varchar(20) NOT NULL default '',
  21    PRIMARY KEY  (cc_value)
  22  ) TYPE=MyISAM;
  23  
  24  ALTER TABLE events MODIFY location varchar(128) default NULL;
  25  ALTER TABLE events ADD event_type varchar(40) NOT NULL default '';
  26  ALTER TABLE events ADD timestart time default NULL;
  27  ALTER TABLE events ADD timeend time default NULL;
  28  ALTER TABLE events ADD allday tinyint(1) NOT NULL default '0';
  29  ALTER TABLE events ADD address1 varchar(40) default NULL;
  30  ALTER TABLE events ADD address2 varchar(40) default NULL;
  31  ALTER TABLE events ADD city varchar(60) default NULL;
  32  ALTER TABLE events ADD state char(2) default NULL;
  33  ALTER TABLE events ADD zipcode varchar(5) default NULL;
  34  ALTER TABLE events ADD group_id mediumint(8) unsigned NOT NULL default '1';
  35  ALTER TABLE events ADD owner_id mediumint(8) unsigned NOT NULL default '0';
  36  ALTER TABLE events ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
  37  ALTER TABLE events ADD perm_group tinyint(1) unsigned NOT NULL default '3';
  38  ALTER TABLE events ADD perm_members tinyint(1) unsigned NOT NULL default '2';
  39  ALTER TABLE events ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
  40  ALTER TABLE eventsubmission MODIFY location varchar(128) default NULL;
  41  ALTER TABLE eventsubmission ADD event_type varchar(40) NOT NULL default '';
  42  ALTER TABLE eventsubmission ADD timestart time default NULL;
  43  ALTER TABLE eventsubmission ADD timeend time default NULL;
  44  ALTER TABLE eventsubmission ADD allday tinyint(1) NOT NULL default '0';
  45  ALTER TABLE eventsubmission ADD address1 varchar(40) default NULL;
  46  ALTER TABLE eventsubmission ADD address2 varchar(40) default NULL;
  47  ALTER TABLE eventsubmission ADD city varchar(60) default NULL;
  48  ALTER TABLE eventsubmission ADD state char(2) default NULL;
  49  ALTER TABLE eventsubmission ADD zipcode varchar(5) default NULL;
  50  
  51  CREATE TABLE features (
  52    ft_id mediumint(8) NOT NULL auto_increment,
  53    ft_name varchar(20) NOT NULL default '',
  54    ft_descr varchar(255) NOT NULL default '',
  55    ft_gl_core tinyint(1) NOT NULL default '0',
  56    PRIMARY KEY  (ft_id),
  57    KEY ft_name (ft_name)
  58  ) TYPE=MyISAM;
  59                          
  60  CREATE TABLE group_assignments (
  61    ug_main_grp_id mediumint(8) NOT NULL default '0',
  62    ug_uid mediumint(8) unsigned default NULL,
  63    ug_grp_id mediumint(8) unsigned default NULL,
  64    KEY ug_main_grp_id (ug_main_grp_id)
  65  ) TYPE=MyISAM;
  66  
  67  CREATE TABLE groups (
  68    grp_id mediumint(8) NOT NULL auto_increment,
  69    grp_name varchar(50) NOT NULL default '',
  70    grp_descr varchar(255) NOT NULL default '',
  71    grp_gl_core tinyint(1) unsigned NOT NULL default '0',
  72    PRIMARY KEY  (grp_id),
  73    KEY grp_name (grp_name)
  74  ) TYPE=MyISAM;
  75  
  76  ALTER TABLE links ADD group_id mediumint(8) unsigned NOT NULL default '1';
  77  ALTER TABLE links ADD owner_id mediumint(8) unsigned NOT NULL default '0';
  78  ALTER TABLE links ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
  79  ALTER TABLE links ADD perm_group tinyint(1) unsigned NOT NULL default '3';
  80  ALTER TABLE links ADD perm_members tinyint(1) unsigned NOT NULL default '2';
  81  ALTER TABLE links ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
  82  
  83  CREATE TABLE personal_events (
  84    eid varchar(20) NOT NULL default '',
  85    uid mediumint(8) NOT NULL default '0',
  86    title varchar(128) default NULL,
  87    event_type varchar(40) NOT NULL default '',
  88    datestart date default NULL,
  89    timestart time default NULL,
  90    dateend date default NULL,
  91    timeend time default NULL,
  92    location varchar(128) default NULL,
  93    address1 varchar(40) default NULL,
  94    address2 varchar(40) default NULL,
  95    city varchar(60) default NULL,
  96    state char(2) default NULL,
  97    zipcode varchar(5) default NULL,
  98    allday tinyint(1) NOT NULL default '0',
  99    url varchar(128) default NULL,
 100    description text,
 101    group_id mediumint(8) unsigned NOT NULL default '1',
 102    owner_id mediumint(8) unsigned NOT NULL default '0',
 103    perm_owner tinyint(1) unsigned NOT NULL default '3',
 104    perm_group tinyint(1) unsigned NOT NULL default '3',
 105    perm_members tinyint(1) unsigned NOT NULL default '2',
 106    perm_anon tinyint(1) unsigned NOT NULL default '2',
 107    PRIMARY KEY  (eid)
 108  ) TYPE=MyISAM;
 109  
 110  CREATE TABLE plugins (
 111    pi_name varchar(30) NOT NULL default '',
 112    pi_version varchar(20) NOT NULL default '',
 113    pi_gl_version varchar(20) NOT NULL default '',
 114    pi_enabled tinyint(3) unsigned NOT NULL default '1',
 115    pi_homepage varchar(128) NOT NULL default '',
 116    PRIMARY KEY  (pi_name)
 117  ) TYPE=MyISAM;
 118                                                                                                          
 119  ALTER TABLE stories ADD numemails mediumint(8) unsigned NOT NULL default '0';
 120  ALTER TABLE stories ADD owner_id mediumint(8) NOT NULL default '0';
 121  ALTER TABLE stories ADD group_id mediumint(8) NOT NULL default '2';
 122  ALTER TABLE stories ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
 123  ALTER TABLE stories ADD perm_group tinyint(1) unsigned NOT NULL default '3';
 124  ALTER TABLE stories ADD perm_members tinyint(1) unsigned NOT NULL default '2';
 125  ALTER TABLE stories ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
 126  ALTER TABLE topics ADD group_id mediumint(8) unsigned NOT NULL default '1';
 127  ALTER TABLE topics ADD owner_id mediumint(8) unsigned NOT NULL default '0';
 128  ALTER TABLE topics ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
 129  ALTER TABLE topics ADD perm_group tinyint(1) unsigned NOT NULL default '3';
 130  ALTER TABLE topics ADD perm_members tinyint(1) unsigned NOT NULL default '2';
 131  ALTER TABLE topics ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
 132  DROP TABLE userevent;
 133  ALTER TABLE users ADD regdate datetime NOT NULL default '0000-00-00 00:00:00';
 134  ALTER TABLE users ADD cookietimeout int(8) unsigned default '0';
 135  ALTER TABLE users ADD theme varchar(64) default NULL;
 136  ALTER TABLE users ADD language varchar(64) default NULL;
 137  ALTER TABLE users DROP seclev;
 138  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (1,3) ;
 139  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (2,3) ;
 140  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (3,5) ;
 141  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (4,5) ;
 142  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (5,9) ;
 143  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (5,11) ;
 144  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (6,9) ;
 145  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (6,11) ;
 146  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (8,7) ;
 147  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (9,7) ;
 148  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (10,4) ;
 149  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (11,6) ;
 150  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (12,8) ;
 151  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (13,10) ;
 152  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (14,11) ;
 153  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (15,11) ;
 154  INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (16,4) ;
 155  INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('user_block','gldefault','User Block','all',2,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) ;
 156  INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('admin_block','gldefault','Admin Block','all',1,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) ;
 157  INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('section_block','gldefault','Section Block','all',0,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) ;
 158  INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('poll_block','gldefault','Poll Block','all',2,'','','0000-00-00 00:00:00',0,'0',1,2,3,3,2,2) ;
 159  INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('events_block','gldefault','Events Block','all',3,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) ;
 160  INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('whats_new_block','gldefault','Whats New Block','all',3,'','','0000-00-00 00:00:00',0,'1',1,2,3,3,2,2) ;
 161  INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (3600,'1 Hour') ;
 162  INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (7200,'2 Hours') ;
 163  INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (10800,'3 Hours') ;
 164  INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (28800,'8 Hours') ;
 165  INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (86400,'1 Day') ;
 166  INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (604800,'1 Week') ;
 167  INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (2678400,'1 Month') ;
 168  INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (31536000,'1 Year') ;
 169  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (1,'story.edit','Access to story editor',1) ;
 170  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (2,'story.moderate','Ablility to moderate pending stories',1) ;
 171  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (3,'link.moderate','Ablility to moderate pending links',1) ;
 172  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (4,'link.edit','Access to link editor',1) ;
 173  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (5,'user.edit','Access to user editor',1) ;
 174  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (6,'user.delete','Ablility to delete a user',1) ;
 175  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (7,'user.mail','Ablility to send email to members',1) ;
 176  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (8,'event.moderate','Ablility to moderate pending events',1) ;
 177  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (9,'event.edit','Access to event editor',1) ;
 178  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (10,'block.edit','Access to block editor',1) ;
 179  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (11,'topic.edit','Access to topic editor',1) ;
 180  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (12,'poll.edit','Access to poll editor',1) ;
 181  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (13,'plugin.edit','Access to plugin editor',1);
 182  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (14,'group.edit','Ability to edit groups',1) ;
 183  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (15,'group.delete','Ability to delete groups',1) ;
 184  INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (16,'block.delete','Ability to delete a block',1) ;
 185  INSERT INTO users (username, fullname, passwd, email, homepage, sig, regdate, cookietimeout, theme) VALUES ('NewAdmin','Geeklog SuperUser','5f4dcc3b5aa765d61d8327deb882cf99','root@localhost','http://geekog.sourceforge.net','','0000-00-00 00:00:00',0,NULL) ;
 186  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,1,NULL) ;
 187  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,1) ;
 188  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (3,NULL,1) ;
 189  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (4,NULL,1) ;
 190  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (5,NULL,1) ;
 191  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (6,NULL,1) ;
 192  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (7,NULL,1) ;
 193  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (8,NULL,1) ;
 194  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,NULL,1) ;
 195  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (10,NULL,1) ;
 196  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (11,NULL,1) ;
 197  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (13,LAST_INSERT_ID(),NULL) ;
 198  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (12,LAST_INSERT_ID(),NULL) ;
 199  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (11,LAST_INSERT_ID(),NULL) ;
 200  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,12) ;
 201  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,10) ;
 202  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,9) ;
 203  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,8) ;
 204  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,7) ;
 205  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,6) ;
 206  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,5) ;
 207  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,4) ;
 208  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,3) ;
 209  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (12,NULL,1) ;
 210  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,NULL,11) ;
 211  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,11) ;
 212  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (10,LAST_INSERT_ID(),NULL) ;
 213  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,LAST_INSERT_ID(),NULL) ;
 214  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (8,LAST_INSERT_ID(),NULL) ;
 215  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (7,LAST_INSERT_ID(),NULL) ;
 216  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (6,LAST_INSERT_ID(),NULL) ;
 217  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (5,LAST_INSERT_ID(),NULL) ;
 218  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (4,LAST_INSERT_ID(),NULL) ;
 219  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (3,LAST_INSERT_ID(),NULL) ;
 220  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,LAST_INSERT_ID(),NULL) ;
 221  INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (1,LAST_INSERT_ID(),NULL) ;
 222  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (1,'Root','Has full access to the site',1) ;
 223  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (2,'All Users','Group that a typical user is added to',1) ;
 224  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (3,'Story Admin','Has full access to story features',1) ;
 225  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (4,'Block Admin','Has full access to block features',1) ;
 226  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (5,'Link Admin','Has full access to link features',1) ;
 227  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (6,'Topic Admin','Has full access to topic features',1) ;
 228  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (7,'Event Admin','Has full access to event features',1) ;
 229  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (8,'Poll Admin','Has full access to poll features',1) ;
 230  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (9,'User Admin','Has full access to user features',1) ;
 231  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (10,'Plugin Admin','Has full access to plugin features',1) ;
 232  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (11,'Group Admin','Is a User Admin with Acces to Groups too',1) ;
 233  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (12,'Mail Admin','Can Use Mail Utility',1) ;
 234  INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (13,'Logged-in Users','All users except anonymous should belong to this group',1) ;
 235  ALTER TABLE pollquestions ADD group_id mediumint(8) unsigned NOT NULL default '1';
 236  ALTER TABLE pollquestions ADD owner_id mediumint(8) unsigned NOT NULL default '1';
 237  ALTER TABLE pollquestions ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
 238  ALTER TABLE pollquestions ADD perm_group tinyint(1) unsigned NOT NULL default '3';
 239  ALTER TABLE pollquestions ADD perm_members tinyint(1) unsigned NOT NULL default '2';
 240  ALTER TABLE pollquestions ADD perm_anon tinyint(1) unsigned NOT NULL default '2';