Geeklog: sql/mysql_tableanddata.php@d0952e303944

     1 <?php

     3 $_SQL[] = "

     4 CREATE TABLE {$_TABLES['access']} (

     5   acc_ft_id mediumint(8) NOT NULL default '0',

     6   acc_grp_id mediumint(8) NOT NULL default '0',

     7   PRIMARY KEY  (acc_ft_id,acc_grp_id)

     8 ) TYPE=MyISAM

     9 ";

    11 $_SQL[] = "

    12 CREATE TABLE {$_TABLES['article_images']} (

    13   ai_sid varchar(40) NOT NULL,

    14   ai_img_num tinyint(2) unsigned NOT NULL,

    15   ai_filename varchar(128) NOT NULL,

    16   PRIMARY KEY (ai_sid,ai_img_num)

    17 ) TYPE=MyISAM

    18 ";

    20 $_SQL[] = "

    21 CREATE TABLE {$_TABLES['blocks']} (

    22   bid smallint(5) unsigned NOT NULL auto_increment,

    23   is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',

    24   name varchar(48) NOT NULL default '',

    25   type varchar(20) NOT NULL default 'normal',

    26   title varchar(48) default NULL,

    27   tid varchar(20) NOT NULL default 'All',

    28   blockorder smallint(5) unsigned NOT NULL default '1',

    29   content text,

    30   allow_autotags tinyint(1) unsigned NOT NULL DEFAULT '0',

    31   rdfurl varchar(255) default NULL,

    32   rdfupdated datetime NOT NULL default '0000-00-00 00:00:00',

    33   rdf_last_modified varchar(40) default NULL,

    34   rdf_etag varchar(40) default NULL,

    35   rdflimit smallint(5) unsigned NOT NULL default '0',

    36   onleft tinyint(1) unsigned NOT NULL default '1',

    37   phpblockfn varchar(128) default '',

    38   help varchar(255) default '',

    39   owner_id mediumint(8) unsigned NOT NULL default '1',

    40   group_id mediumint(8) unsigned NOT NULL default '1',

    41   perm_owner tinyint(1) unsigned NOT NULL default '3',

    42   perm_group tinyint(1) unsigned NOT NULL default '3',

    43   perm_members tinyint(1) unsigned NOT NULL default '2',

    44   perm_anon tinyint(1) unsigned NOT NULL default '2',

    45   INDEX blocks_bid(bid),

    46   INDEX blocks_is_enabled(is_enabled),

    47   INDEX blocks_tid(tid),

    48   INDEX blocks_type(type),

    49   INDEX blocks_name(name),

    50   INDEX blocks_onleft(onleft),

    51   PRIMARY KEY  (bid)

    52 ) TYPE=MyISAM

    53 ";

    55 $_SQL[] = "

    56 CREATE TABLE {$_TABLES['commentcodes']} (

    57   code tinyint(4) NOT NULL default '0',

    58   name varchar(32) default NULL,

    59   PRIMARY KEY  (code)

    60 ) TYPE=MyISAM

    61 ";

    63 $_SQL[] = "

    64 CREATE TABLE {$_TABLES['commentedits']} (

    65   cid int(10) NOT NULL,

    66   uid mediumint(8) NOT NULL,

    67   time datetime NOT NULL,

    68   PRIMARY KEY (cid)

    69 ) TYPE=MyISAM

    70 ";

    72 $_SQL[] = "

    73 CREATE TABLE {$_TABLES['commentmodes']} (

    74   mode varchar(10) NOT NULL default '',

    75   name varchar(32) default NULL,

    76   PRIMARY KEY  (mode)

    77 ) TYPE=MyISAM

    78 ";

    80 $_SQL[] = "

    81 CREATE TABLE {$_TABLES['commentnotifications']} (

    82   cid int(10) default NULL,

    83   uid mediumint(8) NOT NULL,

    84   deletehash varchar(32) NOT NULL,

    85   mid int(10) default NULL,

    86   PRIMARY KEY  (deletehash)

    87 ) TYPE=MyISAM

    88 ";

    90 $_SQL[] = "

    91 CREATE TABLE {$_TABLES['comments']} (

    92   cid int(10) unsigned NOT NULL auto_increment,

    93   type varchar(30) NOT NULL DEFAULT 'article',

    94   sid varchar(40) NOT NULL default '',

    95   date datetime default NULL,

    96   title varchar(128) default NULL,

    97   comment text,

    98   score tinyint(4) NOT NULL default '0',

    99   reason tinyint(4) NOT NULL default '0',

   100   pid int(10) unsigned NOT NULL default '0',

   101   lft mediumint(10) unsigned NOT NULL default '0',

   102   rht mediumint(10) unsigned NOT NULL default '0',

   103   indent mediumint(10) unsigned NOT NULL default '0',

   104   name varchar(32) default NULL,

   105   uid mediumint(8) NOT NULL default '1',

   106   ipaddress varchar(15) NOT NULL default '',

   107   INDEX comments_sid(sid),

   108   INDEX comments_uid(uid),

   109   INDEX comments_lft(lft),

   110   INDEX comments_rht(rht),

   111   INDEX comments_date(date),

   112   PRIMARY KEY  (cid)

   113 ) TYPE=MyISAM

   114 ";

   116 $_SQL[] = "

   117 CREATE TABLE {$_TABLES['commentsubmissions']} (

   118   cid int(10) unsigned NOT NULL auto_increment,

   119   type varchar(30) NOT NULL default 'article',

   120   sid varchar(40) NOT NULL,

   121   date datetime default NULL,

   122   title varchar(128) default NULL,

   123   comment text,

   124   uid mediumint(8) NOT NULL default '1',

   125   name varchar(32) default NULL,

   126   pid int(10) NOT NULL default '0',

   127   ipaddress varchar(15) NOT NULL,

   128   PRIMARY KEY  (cid)

   129 ) TYPE=MyISAM

   130 ";

   132 $_SQL[] = "

   133 CREATE TABLE {$_TABLES['conf_values']} (

   134   name varchar(50) default NULL,

   135   value text,

   136   type varchar(50) default NULL,

   137   group_name varchar(50) default NULL,

   138   default_value text,

   139   subgroup int(11) default NULL,

   140   selectionArray int(11) default NULL,

   141   sort_order int(11) default NULL,

   142   fieldset int(11) default NULL

   143 ) TYPE=MyISAM

   144 ";

   146 $_SQL[] = "

   147 CREATE TABLE {$_TABLES['cookiecodes']} (

   148   cc_value int(8) unsigned NOT NULL default '0',

   149   cc_descr varchar(20) NOT NULL default '',

   150   PRIMARY KEY  (cc_value)

   151 ) TYPE=MyISAM

   152 ";

   154 $_SQL[] = "

   155 CREATE TABLE {$_TABLES['dateformats']} (

   156   dfid tinyint(4) NOT NULL default '0',

   157   format varchar(32) default NULL,

   158   description varchar(64) default NULL,

   159   PRIMARY KEY  (dfid)

   160 ) TYPE=MyISAM

   161 ";

   163 $_SQL[] = "

   164 CREATE TABLE {$_TABLES['featurecodes']} (

   165   code tinyint(4) NOT NULL default '0',

   166   name varchar(32) default NULL,

   167   PRIMARY KEY  (code)

   168 ) TYPE=MyISAM

   169 ";

   171 $_SQL[] = "

   172 CREATE TABLE {$_TABLES['features']} (

   173   ft_id mediumint(8) NOT NULL auto_increment,

   174   ft_name varchar(20) NOT NULL default '',

   175   ft_descr varchar(255) NOT NULL default '',

   176   ft_gl_core tinyint(1) NOT NULL default '0',

   177   PRIMARY KEY  (ft_id),

   178   KEY ft_name (ft_name)

   179 ) TYPE=MyISAM

   180 ";

   182 $_SQL[] = "

   183 CREATE TABLE {$_TABLES['frontpagecodes']} (

   184   code tinyint(4) NOT NULL default '0',

   185   name varchar(32) default NULL,

   186   PRIMARY KEY  (code)

   187 ) TYPE=MyISAM

   188 ";

   190 $_SQL[] = "

   191 CREATE TABLE {$_TABLES['group_assignments']} (

   192   ug_main_grp_id mediumint(8) NOT NULL default '0',

   193   ug_uid mediumint(8) unsigned default NULL,

   194   ug_grp_id mediumint(8) unsigned default NULL,

   195   INDEX group_assignments_ug_main_grp_id(ug_main_grp_id),

   196   INDEX group_assignments_ug_uid(ug_uid),

   197   KEY ug_main_grp_id (ug_main_grp_id)

   198 ) TYPE=MyISAM

   199 ";

   201 $_SQL[] = "

   202 CREATE TABLE {$_TABLES['groups']} (

   203   grp_id mediumint(8) NOT NULL auto_increment,

   204   grp_name varchar(50) NOT NULL default '',

   205   grp_descr varchar(255) NOT NULL default '',

   206   grp_gl_core tinyint(1) unsigned NOT NULL default '0',

   207   PRIMARY KEY  (grp_id),

   208   UNIQUE grp_name (grp_name)

   209 ) TYPE=MyISAM

   210 ";

   212 $_SQL[] = "

   213 CREATE TABLE {$_TABLES['maillist']} (

   214   code int(1) NOT NULL default '0',

   215   name char(32) default NULL,

   216   PRIMARY KEY  (code)

   217 ) TYPE=MyISAM

   218 ";

   220 $_SQL[] = "

   221 CREATE TABLE {$_TABLES['pingservice']} (

   222   pid smallint(5) unsigned NOT NULL auto_increment,

   223   name varchar(128) default NULL,

   224   ping_url varchar(255) default NULL,

   225   site_url varchar(255) default NULL,

   226   method varchar(80) default NULL,

   227   is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',

   228   PRIMARY KEY (pid),

   229   INDEX pingservice_is_enabled(is_enabled)

   230 ) TYPE=MyISAM

   231 ";

   233 $_SQL[] = "

   234 CREATE TABLE {$_TABLES['plugins']} (

   235   pi_name varchar(30) NOT NULL default '',

   236   pi_version varchar(20) NOT NULL default '',

   237   pi_gl_version varchar(20) NOT NULL default '',

   238   pi_enabled tinyint(1) unsigned NOT NULL default '1',

   239   pi_homepage varchar(128) NOT NULL default '',

   240   INDEX plugins_enabled(pi_enabled),

   241   PRIMARY KEY  (pi_name)

   242 ) TYPE=MyISAM

   243 ";

   245 $_SQL[] = "

   246 CREATE TABLE {$_TABLES['postmodes']} (

   247   code char(10) NOT NULL default '',

   248   name char(32) default NULL,

   249   PRIMARY KEY  (code)

   250 ) TYPE=MyISAM

   251 ";

   253 $_SQL[] = "

   254 CREATE TABLE {$_TABLES['sessions']} (

   255   sess_id int(10) unsigned NOT NULL default '0',

   256   start_time int(10) unsigned NOT NULL default '0',

   257   remote_ip varchar(15) NOT NULL default '',

   258   uid mediumint(8) NOT NULL default '1',

   259   md5_sess_id varchar(128) default NULL,

   260   PRIMARY KEY  (sess_id),

   261   KEY sess_id (sess_id),

   262   KEY start_time (start_time),

   263   KEY remote_ip (remote_ip)

   264 ) TYPE=MyISAM

   265 ";

   267 $_SQL[] = "

   268 CREATE TABLE {$_TABLES['sortcodes']} (

   269   code char(4) NOT NULL default '0',

   270   name char(32) default NULL,

   271   PRIMARY KEY  (code)

   272 ) TYPE=MyISAM

   273 ";

   275 $_SQL[] = "

   276 CREATE TABLE {$_TABLES['speedlimit']} (

   277   id int(10) unsigned NOT NULL auto_increment,

   278   ipaddress varchar(15) NOT NULL default '',

   279   date int(10) unsigned default NULL,

   280   type varchar(30) NOT NULL default 'submit',

   281   PRIMARY KEY (id),

   282   KEY type_ipaddress (type,ipaddress),

   283   KEY date (date)

   284 ) TYPE = MyISAM

   285 ";

   287 $_SQL[] = "

   288 CREATE TABLE {$_TABLES['statuscodes']} (

   289   code int(1) NOT NULL default '0',

   290   name char(32) default NULL,

   291   PRIMARY KEY  (code)

   292 ) TYPE=MyISAM

   293 ";

   295 $_SQL[] = "

   296 CREATE TABLE {$_TABLES['stories']} (

   297   sid varchar(40) NOT NULL default '',

   298   uid mediumint(8) NOT NULL default '1',

   299   draft_flag tinyint(1) unsigned default '0',

   300   tid varchar(20) NOT NULL default 'General',

   301   date datetime default NULL,

   302   title varchar(128) default NULL,

   303   introtext text,

   304   bodytext text,

   305   hits mediumint(8) unsigned NOT NULL default '0',

   306   numemails mediumint(8) unsigned NOT NULL default '0',

   307   comments mediumint(8) unsigned NOT NULL default '0',

   308   comment_expire datetime NOT NULL default '0000-00-00 00:00:00',

   309   trackbacks mediumint(8) unsigned NOT NULL default '0',

   310   related text,

   311   featured tinyint(1) unsigned NOT NULL default '0',

   312   show_topic_icon tinyint(1) unsigned NOT NULL default '1',

   313   commentcode tinyint(4) NOT NULL default '0',

   314   trackbackcode tinyint(4) NOT NULL default '0',

   315   statuscode tinyint(4) NOT NULL default '0',

   316   expire DATETIME NOT NULL default '0000-00-00 00:00:00',

   317   postmode varchar(10) NOT NULL default 'html',

   318   advanced_editor_mode tinyint(1) unsigned default '0',

   319   frontpage tinyint(1) unsigned default '1',

   320   meta_description TEXT NULL,

   321   meta_keywords TEXT NULL,

   322   owner_id mediumint(8) NOT NULL default '1',

   323   group_id mediumint(8) NOT NULL default '2',

   324   perm_owner tinyint(1) unsigned NOT NULL default '3',

   325   perm_group tinyint(1) unsigned NOT NULL default '3',

   326   perm_members tinyint(1) unsigned NOT NULL default '2',

   327   perm_anon tinyint(1) unsigned NOT NULL default '2',

   328   INDEX stories_sid(sid),

   329   INDEX stories_tid(tid),

   330   INDEX stories_uid(uid),

   331   INDEX stories_featured(featured),

   332   INDEX stories_hits(hits),

   333   INDEX stories_statuscode(statuscode),

   334   INDEX stories_expire(expire),

   335   INDEX stories_date(date),

   336   INDEX stories_frontpage(frontpage),

   337   PRIMARY KEY  (sid)

   338 ) TYPE=MyISAM

   339 ";

   341 $_SQL[] = "

   342 CREATE TABLE {$_TABLES['storysubmission']} (

   343   sid varchar(20) NOT NULL default '',

   344   uid mediumint(8) NOT NULL default '1',

   345   tid varchar(20) NOT NULL default 'General',

   346   title varchar(128) default NULL,

   347   introtext text,

   348   bodytext text,

   349   date datetime default NULL,

   350   postmode varchar(10) NOT NULL default 'html',

   351   PRIMARY KEY  (sid)

   352 ) TYPE=MyISAM

   353 ";

   355 $_SQL[] = "

   356 CREATE TABLE {$_TABLES['syndication']} (

   357   fid int(10) unsigned NOT NULL auto_increment,

   358   type varchar(30) NOT NULL default 'article',

   359   topic varchar(48) NOT NULL default '::all',

   360   header_tid varchar(48) NOT NULL default 'none',

   361   format varchar(20) NOT NULL default 'RSS-2.0',

   362   limits varchar(5) NOT NULL default '10',

   363   content_length smallint(5) unsigned NOT NULL default '0',

   364   title varchar(40) NOT NULL default '',

   365   description text,

   366   feedlogo varchar(255),

   367   filename varchar(40) NOT NULL default 'geeklog.rss',

   368   charset varchar(20) NOT NULL default 'UTF-8',

   369   language varchar(20) NOT NULL default 'en-gb',

   370   is_enabled tinyint(1) unsigned NOT NULL default '1',

   371   updated datetime NOT NULL default '0000-00-00 00:00:00',

   372   update_info text,

   373   PRIMARY KEY (fid),

   374   INDEX syndication_type(type),

   375   INDEX syndication_topic(topic),

   376   INDEX syndication_is_enabled(is_enabled),

   377   INDEX syndication_updated(updated)

   378 ) TYPE=MyISAM

   379 ";

   381 $_SQL[] = "

   382 CREATE TABLE {$_TABLES['tokens']} (

   383   token varchar(32) NOT NULL,

   384   created datetime NOT NULL,

   385   owner_id mediumint(8) unsigned NOT NULL,

   386   urlfor varchar(255) NOT NULL,

   387   ttl mediumint(8) unsigned NOT NULL default '1',

   388   PRIMARY KEY (token)

   389 ) TYPE=MyISAM

   390 ";

   392 $_SQL[] = "

   393 CREATE TABLE {$_TABLES['topics']} (

   394   tid varchar(20) NOT NULL default '',

   395   topic varchar(48) default NULL,

   396   imageurl varchar(255) default NULL,

   397   meta_description TEXT NULL,

   398   meta_keywords TEXT NULL,

   399   sortnum smallint(3) default NULL,

   400   limitnews tinyint(3) default NULL,

   401   is_default tinyint(1) unsigned NOT NULL DEFAULT '0',

   402   archive_flag tinyint(1) unsigned NOT NULL DEFAULT '0',

   403   owner_id mediumint(8) unsigned NOT NULL default '1',

   404   group_id mediumint(8) unsigned NOT NULL default '1',

   405   perm_owner tinyint(1) unsigned NOT NULL default '3',

   406   perm_group tinyint(1) unsigned NOT NULL default '3',

   407   perm_members tinyint(1) unsigned NOT NULL default '2',

   408   perm_anon tinyint(1) unsigned NOT NULL default '2',

   409   PRIMARY KEY  (tid)

   410 ) TYPE=MyISAM

   411 ";

   413 $_SQL[] = "

   414 CREATE TABLE {$_TABLES['trackback']} (

   415   cid int(10) unsigned NOT NULL auto_increment,

   416   sid varchar(40) NOT NULL,

   417   url varchar(255) default NULL,

   418   title varchar(128) default NULL,

   419   blog varchar(80) default NULL,

   420   excerpt text,

   421   date datetime default NULL,

   422   type varchar(30) NOT NULL default 'article',

   423   ipaddress varchar(15) NOT NULL default '',

   424   PRIMARY KEY (cid),

   425   INDEX trackback_sid(sid),

   426   INDEX trackback_url(url),

   427   INDEX trackback_type(type),

   428   INDEX trackback_date(date)

   429 ) TYPE=MyISAM

   430 ";

   432 $_SQL[] = "

   433 CREATE TABLE {$_TABLES['trackbackcodes']} (

   434   code tinyint(4) NOT NULL default '0',

   435   name varchar(32) default NULL,

   436   PRIMARY KEY  (code)

   437 ) TYPE=MyISAM

   438 ";

   440 $_SQL[] = "

   441 CREATE TABLE {$_TABLES['usercomment']} (

   442   uid mediumint(8) NOT NULL default '1',

   443   commentmode varchar(10) NOT NULL default 'threaded',

   444   commentorder varchar(4) NOT NULL default 'ASC',

   445   commentlimit mediumint(8) unsigned NOT NULL default '100',

   446   PRIMARY KEY  (uid)

   447 ) TYPE=MyISAM

   448 ";

   450 $_SQL[] = "

   451 CREATE TABLE {$_TABLES['userindex']} (

   452   uid mediumint(8) NOT NULL default '1',

   453   tids varchar(255) NOT NULL default '',

   454   etids text,

   455   aids varchar(255) NOT NULL default '',

   456   boxes varchar(255) NOT NULL default '',

   457   noboxes tinyint(4) NOT NULL default '0',

   458   maxstories tinyint(4) default NULL,

   459   INDEX userindex_uid(uid),

   460   INDEX userindex_noboxes(noboxes),

   461   INDEX userindex_maxstories(maxstories),

   462   PRIMARY KEY  (uid)

   463 ) TYPE=MyISAM

   464 ";

   466 $_SQL[] = "

   467 CREATE TABLE {$_TABLES['userinfo']} (

   468   uid mediumint(8) NOT NULL default '1',

   469   about text,

   470   location varchar(96) NOT NULL default '',

   471   pgpkey text,

   472   userspace varchar(255) NOT NULL default '',

   473   tokens tinyint(3) unsigned NOT NULL default '0',

   474   totalcomments mediumint(9) NOT NULL default '0',

   475   lastgranted int(10) unsigned NOT NULL default '0',

   476   lastlogin VARCHAR(10) NOT NULL default '0',

   477   PRIMARY KEY  (uid)

   478 ) TYPE=MyISAM

   479 ";

   481 $_SQL[] = "

   482 CREATE TABLE {$_TABLES['userprefs']} (

   483   uid mediumint(8) NOT NULL default '1',

   484   noicons tinyint(1) unsigned NOT NULL default '0',

   485   willing tinyint(3) unsigned NOT NULL default '1',

   486   dfid tinyint(3) unsigned NOT NULL default '0',

   487   tzid varchar(125) NOT NULL default '',

   488   emailstories tinyint(4) NOT NULL default '1',

   489   emailfromadmin tinyint(1) NOT NULL default '1',

   490   emailfromuser tinyint(1) NOT NULL default '1',

   491   showonline tinyint(1) NOT NULL default '1',

   492   PRIMARY KEY  (uid)

   493 ) TYPE=MyISAM

   494 ";

   496 $_SQL[] = "

   497 CREATE TABLE {$_TABLES['users']} (

   498   uid mediumint(8) NOT NULL auto_increment,

   499   username varchar(16) NOT NULL default '',

   500   remoteusername varchar(60) NULL,

   501   remoteservice varchar(60) NULL,

   502   fullname varchar(80) default NULL,

   503   passwd varchar(32) NOT NULL default '',

   504   email varchar(96) default NULL,

   505   homepage varchar(96) default NULL,

   506   sig varchar(160) NOT NULL default '',

   507   regdate datetime NOT NULL default '0000-00-00 00:00:00',

   508   photo varchar(128) DEFAULT NULL,

   509   cookietimeout int(8) unsigned default '28800',

   510   theme varchar(64) default NULL,

   511   language varchar(64) default NULL,

   512   pwrequestid varchar(16) default NULL,

   513   status smallint(5) unsigned NOT NULL default '1',

   514   num_reminders tinyint(1) NOT NULL default 0,

   515   PRIMARY KEY  (uid),

   516   KEY LOGIN (uid,passwd,username),

   517   INDEX users_username(username),

   518   INDEX users_fullname(fullname),

   519   INDEX users_email(email),

   520   INDEX users_passwd(passwd),

   521   INDEX users_pwrequestid(pwrequestid)

   522 ) TYPE=MyISAM

   523 ";

   525 $_SQL[] = "

   526 CREATE TABLE {$_TABLES['vars']} (

   527   name varchar(20) NOT NULL default '',

   528   value varchar(128) default NULL,

   529   PRIMARY KEY  (name)

   530 ) TYPE=MyISAM

   531 ";

   534 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (1,3) ";

   535 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (2,3) ";

   536 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (4,3) ";

   537 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (5,9) ";

   538 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (5,11) ";

   539 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (6,9) ";

   540 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (6,11) ";

   541 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (7,12) ";

   542 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (8,5) ";

   543 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (9,8) ";

   544 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (10,4) ";

   545 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (11,6) ";

   546 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (13,10) ";

   547 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (14,11) ";

   548 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (15,11) ";

   549 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (16,4) ";

   550 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (17,10) ";

   551 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (18,10) ";

   552 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (19,11) ";

   553 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (20,14) ";

   554 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (21,15) ";

   556 $_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (1,1,'user_block','gldefault','User Functions','all',2,'','','0000-00-00 00:00:00',1,'',4,2,3,3,2,2) ";

   557 $_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (2,1,'admin_block','gldefault','Admins Only','all',1,'','','0000-00-00 00:00:00',1,'',4,2,3,3,2,2) ";

   558 $_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (3,1,'section_block','gldefault','Topics','all',0,'','','0000-00-00 00:00:00',1,'',4,2,3,3,2,2) ";

   559 $_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (4,1,'whats_new_block','gldefault','What\'s New','all',3,'','','0000-00-00 00:00:00',0,'',4,2,3,3,2,2) ";

   560 $_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (5,1,'first_block','normal','About Geeklog','homeonly',1,'<p><b>Welcome to Geeklog!</b></p><p>If you\'re already familiar with Geeklog - and especially if you\'re not: There have been many improvements to Geeklog since earlier versions that you might want to read up on. Please read the <a href=\"docs/english/changes.html\">release notes</a>. If you need help, please see the <a href=\"docs/english/support.html\">support options</a>.</p>','','0000-00-00 00:00:00',0,'',4,2,3,3,2,2) ";

   561 $_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (6,1,'whosonline_block','phpblock','Who\'s Online','all',0,'','','0000-00-00 00:00:00',0,'phpblock_whosonline',4,2,3,3,2,2) ";

   562 $_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES (7,1,'older_stories','gldefault','Older Stories','all',5,'','','0000-00-00 00:00:00',1,'',4,2,3,3,2,2) ";

   564 $_DATA[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES (0,'Comments Enabled') ";

   565 $_DATA[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES (-1,'Comments Disabled') ";

   566 $_DATA[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES (1,'Comments Closed') ";

   568 $_DATA[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES ('flat','Flat') ";

   569 $_DATA[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES ('nested','Nested') ";

   570 $_DATA[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES ('threaded','Threaded') ";

   571 $_DATA[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES ('nocomment','No Comments') ";

   573 $_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (0,'(don\'t)') ";

   574 $_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (3600,'1 Hour') ";

   575 $_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (7200,'2 Hours') ";

   576 $_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (10800,'3 Hours') ";

   577 $_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (28800,'8 Hours') ";

   578 $_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (86400,'1 Day') ";

   579 $_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (604800,'1 Week') ";

   580 $_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr) VALUES (2678400,'1 Month') ";

   582 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (0,'','System Default') ";

   583 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (1,'%A %B %d, %Y @%I:%M%p','Sunday March 21, 1999 @10:00PM') ";

   584 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (2,'%A %b %d, %Y @%H:%M','Sunday March 21, 1999 @22:00') ";

   585 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (4,'%A %b %d @%H:%M','Sunday March 21 @22:00') ";

   586 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (5,'%H:%M %d %B %Y','22:00 21 March 1999') ";

   587 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (6,'%H:%M %A %d %B %Y','22:00 Sunday 21 March 1999') ";

   588 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (7,'%I:%M%p - %A %B %d %Y','10:00PM -- Sunday March 21 1999') ";

   589 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (8,'%a %B %d, %I:%M%p','Sun March 21, 10:00PM') ";

   590 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (9,'%a %B %d, %H:%M','Sun March 21, 22:00') ";

   591 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (10,'%m-%d-%y %H:%M','3-21-99 22:00') ";

   592 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (11,'%d-%m-%y %H:%M','21-3-99 22:00') ";

   593 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (12,'%m-%d-%y %I:%M%p','3-21-99 10:00PM') ";

   594 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (13,'%I:%M%p  %B %e, %Y','10:00PM  March 21, 1999') ";

   595 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (14,'%a %b %d, \'%y %I:%M%p','Sun Mar 21, \'99 10:00PM') ";

   596 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (15,'Day %j, %I ish','Day 80, 10 ish') ";

   597 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (16,'%y-%m-%d %I:%M','99-03-21 10:00') ";

   598 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (17,'%d/%m/%y %H:%M','21/03/99 22:00') ";

   599 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (18,'%a %d %b %I:%M%p','Sun 21 Mar 10:00PM') ";

   600 $_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format, description) VALUES (19,'%Y-%m-%d %H:%M','1999-03-21 22:00') ";

   602 $_DATA[] = "INSERT INTO {$_TABLES['featurecodes']} (code, name) VALUES (0,'Not Featured') ";

   603 $_DATA[] = "INSERT INTO {$_TABLES['featurecodes']} (code, name) VALUES (1,'Featured') ";

   605 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (1,'story.edit','Access to story editor',1) ";

   606 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (2,'story.moderate','Ability to moderate pending stories',1) ";

   607 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (3,'story.submit','May skip the story submission queue',1) ";

   608 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (4,'story.ping', 'Ability to send pings, pingbacks, or trackbacks for stories', 1) ";

   609 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (5,'user.edit','Access to user editor',1) ";

   610 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (6,'user.delete','Ability to delete a user',1) ";

   611 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (7,'user.mail','Ability to send email to members',1) ";

   612 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (8,'syndication.edit', 'Access to Content Syndication', 1) ";

   613 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (9,'webservices.atompub', 'May use Atompub Webservices (if restricted)', 1) ";

   614 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (10,'block.edit','Access to block editor',1) ";

   615 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (11,'topic.edit','Access to topic editor',1) ";

   616 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (13,'plugin.edit','Can change plugin status',1) ";

   617 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (14,'group.edit','Ability to edit groups',1) ";

   618 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (15,'group.delete','Ability to delete groups',1) ";

   619 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (16,'block.delete','Ability to delete a block',1) ";

   620 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (17,'plugin.install','Can install/uninstall plugins',1) ";

   621 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (18,'plugin.upload','Can upload new plugins',1) ";

   622 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (19,'group.assign','Ability to assign users to groups',1) ";

   623 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (20, 'comment.moderate', 'Ability to moderate comments', 1)";

   624 $_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core) VALUES (21, 'comment.submit', 'Comments are automatically published', 1)";

   626 $_DATA[] = "INSERT INTO {$_TABLES['frontpagecodes']} (code, name) VALUES (0,'Show Only in Topic') ";

   627 $_DATA[] = "INSERT INTO {$_TABLES['frontpagecodes']} (code, name) VALUES (1,'Show on Front Page') ";

   629 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,1,NULL) ";

   630 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,1) ";

   631 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (3,NULL,1) ";

   632 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (4,NULL,1) ";

   633 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (6,NULL,1) ";

   634 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,NULL,1) ";

   635 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (10,NULL,1) ";

   636 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (11,NULL,1) ";

   637 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (13,2,NULL) ";

   638 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (12,2,NULL) ";

   639 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (11,2,NULL) ";

   640 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,12) ";

   641 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,10) ";

   642 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,9) ";

   643 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,6) ";

   644 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,4) ";

   645 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,3) ";

   646 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (12,NULL,1) ";

   647 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,NULL,11) ";

   648 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,NULL,11) ";

   649 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (10,2,NULL) ";

   650 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (9,2,NULL) ";

   651 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (6,2,NULL) ";

   652 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (4,2,NULL) ";

   653 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (3,2,NULL) ";

   654 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (2,2,NULL) ";

   655 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (1,2,NULL) ";

   656 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (5,NULL,1) ";

   657 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (8,NULL,1) ";

   658 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (14,NULL,1) ";

   659 $_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid, ug_grp_id) VALUES (15,NULL,1) ";

   661 // Traditionally, grp_id 1 = Root, 2 = All Users, 13 = Logged-In Users

   662 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (1,'Root','Has full access to the site',1) ";

   663 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (2,'All Users','Group that a typical user is added to',1) ";

   664 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (3,'Story Admin','Has full access to story features',1) ";

   665 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (4,'Block Admin','Has full access to block features',1) ";

   666 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (5,'Syndication Admin', 'Can create and modify web feeds for the site',1) ";

   667 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (6,'Topic Admin','Has full access to topic features',1) ";

   668 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (7,'Remote Users', 'Users in this group can have authenticated against a remote server.',1) ";

   669 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (8,'Webservices Users', 'Can use the Webservices API (if restricted)',0) ";

   670 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (9,'User Admin','Has full access to user features',1) ";

   671 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (10,'Plugin Admin','Has full access to plugin features',1) ";

   672 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (11,'Group Admin','Is a User Admin with access to groups, too',1) ";

   673 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (12,'Mail Admin','Can use Mail Utility',1) ";

   674 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (13,'Logged-in Users','All registered members',1) ";

   675 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (14, 'Comment Admin', 'Can moderate comments', 1)";

   676 $_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr, grp_gl_core) VALUES (15, 'Comment Submitters', 'Can submit comments', 0);";

   678 $_DATA[] = "INSERT INTO {$_TABLES['maillist']} (code, name) VALUES (0,'Don\'t Email') ";

   679 $_DATA[] = "INSERT INTO {$_TABLES['maillist']} (code, name) VALUES (1,'Email Headlines Each Night') ";

   681 $_DATA[] = "INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url, ping_url, method, is_enabled) VALUES (1, 'Ping-O-Matic', 'http://pingomatic.com/', 'http://rpc.pingomatic.com/', 'weblogUpdates.ping', 1)";

   683 $_DATA[] = "INSERT INTO {$_TABLES['postmodes']} (code, name) VALUES ('plaintext','Plain Old Text') ";

   684 $_DATA[] = "INSERT INTO {$_TABLES['postmodes']} (code, name) VALUES ('html','HTML Formatted') ";

   686 $_DATA[] = "INSERT INTO {$_TABLES['sortcodes']} (code, name) VALUES ('ASC','Oldest First') ";

   687 $_DATA[] = "INSERT INTO {$_TABLES['sortcodes']} (code, name) VALUES ('DESC','Newest First') ";

   689 $_DATA[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES (1,'Refreshing') ";

   690 $_DATA[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES (0,'Normal') ";

   691 $_DATA[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES (10,'Archive') ";

   693 $_DATA[] = "INSERT INTO {$_TABLES['stories']} (sid, uid, draft_flag, tid, date, title, introtext, bodytext, hits, numemails, comments, related, featured, commentcode, statuscode, postmode, frontpage, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('welcome',2,0,'Geeklog',NOW(),'Welcome to Geeklog!','<p>Welcome and let me be the first to congratulate you on installing Geeklog. Please take the time to read everything in the <a href=\"docs/english/index.html\">docs directory</a>. Geeklog now has enhanced, user-based security.  You should thoroughly understand how these work before you run a production Geeklog Site.</p>\r<p>To log into your new Geeklog site, please use this account:</p>\r<p>Username: <b>Admin</b><br />\rPassword: <b>password</b></p><p><b>And don\'t forget to <a href=\"usersettings.php\">change your password</a> after logging in!</b></p>','',100,1,0,'',1,0,0,'html',1,2,3,3,2,2,2) ";

   695 $_DATA[] = "INSERT INTO {$_TABLES['storysubmission']} (sid, uid, tid, title, introtext, date, postmode) VALUES ('security-reminder',2,'Geeklog','Are you secure?','<p>This is a reminder to secure your site once you have Geeklog up and running. What you should do:</p>\r\r<ol>\r<li>Change the default password for the Admin account.</li>\r<li>Remove the install directory (you won\'t need it any more).</li>\r</ol>',NOW(),'html') ";

   697 $_DATA[] = "INSERT INTO {$_TABLES['syndication']} (type, topic, header_tid, format, limits, content_length, title, description, filename, charset, language, is_enabled, updated, update_info) VALUES ('article', '::all', 'all', 'RSS-2.0', 10, 1, 'Geeklog Site', 'Another Nifty Geeklog Site', 'geeklog.rss', 'iso-8859-1', 'en-gb', 1, '0000-00-00 00:00:00', NULL)";

   699 $_DATA[] = "INSERT INTO {$_TABLES['topics']} (tid, topic, imageurl, meta_description, meta_keywords, sortnum, limitnews, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('General','General News','/images/topics/topic_news.gif','A topic that contains general news related posts.','News, Post, Information',1,10,6,2,3,2,2,2)";

   700 $_DATA[] = "INSERT INTO {$_TABLES['topics']} (tid, topic, imageurl, meta_description, meta_keywords, sortnum, limitnews, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('Geeklog','Geeklog','/images/topics/topic_gl.gif','A topic that contains posts about Geeklog.','Geeklog, Posts, Information',2,10,6,2,3,2,2,2)";

   702 $_DATA[] = "INSERT INTO {$_TABLES['usercomment']} (uid, commentmode, commentorder, commentlimit) VALUES (1,'nested','ASC',100) ";

   703 $_DATA[] = "INSERT INTO {$_TABLES['usercomment']} (uid, commentmode, commentorder, commentlimit) VALUES (2,'threaded','ASC',100) ";

   705 $_DATA[] = "INSERT INTO {$_TABLES['userindex']} (uid, tids, etids, aids, boxes, noboxes, maxstories) VALUES (1,'','-','','',0,NULL) ";

   706 $_DATA[] = "INSERT INTO {$_TABLES['userindex']} (uid, tids, etids, aids, boxes, noboxes, maxstories) VALUES (2,'','','','',0,NULL) ";

   708 $_DATA[] = "INSERT INTO {$_TABLES['userinfo']} (uid, about, pgpkey, userspace, tokens, totalcomments, lastgranted) VALUES (1,NULL,NULL,'',0,0,0) ";

   709 $_DATA[] = "INSERT INTO {$_TABLES['userinfo']} (uid, about, pgpkey, userspace, tokens, totalcomments, lastgranted) VALUES (2,NULL,NULL,'',0,0,0) ";

   711 $_DATA[] = "INSERT INTO {$_TABLES['userprefs']} (uid, noicons, willing, dfid, tzid, emailstories) VALUES (1,0,0,0,'',0) ";

   712 $_DATA[] = "INSERT INTO {$_TABLES['userprefs']} (uid, noicons, willing, dfid, tzid, emailstories) VALUES (2,0,1,0,'',1) ";

   714 #

   715 # Dumping data for table 'users'

   716 #

   718 $_DATA[] = "INSERT INTO {$_TABLES['users']} (uid, username, fullname, passwd, email, homepage, sig, regdate, cookietimeout, theme, status) VALUES (1,'Anonymous','Anonymous','',NULL,NULL,'',NOW(),0,NULL,3) ";

   719 $_DATA[] = "INSERT INTO {$_TABLES['users']} (uid, username, fullname, passwd, email, homepage, sig, regdate, cookietimeout, theme, status) VALUES (2,'Admin','Geeklog SuperUser','5f4dcc3b5aa765d61d8327deb882cf99','root@localhost','http://www.geeklog.net/','',NOW(),28800,NULL,3) ";

   721 $_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('totalhits','0') ";

   722 $_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('lastemailedstories','') ";

   723 $_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('last_scheduled_run','') ";

   724 $_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('database_version','0.0.0') ";

   726 $_DATA[] = "INSERT INTO {$_TABLES['trackbackcodes']} (code, name) VALUES (0,'Trackback Enabled') ";

   727 $_DATA[] = "INSERT INTO {$_TABLES['trackbackcodes']} (code, name) VALUES (-1,'Trackback Disabled') ";

   729 ?>

author	Dirk Haun <dirk@haun-online.de>
	Thu, 29 Oct 2009 11:37:11 +0100
branch	HEAD
changeset 7393	d0952e303944
parent 7254	6230420fef6d
child 7454	b52c72b9844c
permissions	-rw-r--r--