[geeklog-cvs] Geeklog-1.x/sql mysql_tableanddata.php,1.201,1.202
Dirk Haun
dhaun at qs1489.pair.com
Sat Apr 12 07:21:48 EDT 2008
Update of /cvsroot/geeklog/Geeklog-1.x/sql
In directory qs1489.pair.com:/tmp/cvs-serv31469/sql
Modified Files:
mysql_tableanddata.php
Log Message:
Cosmetics: Ordered tables (by name) and grouped them (by Core and plugins)
Index: mysql_tableanddata.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mysql_tableanddata.php,v
retrieving revision 1.201
retrieving revision 1.202
diff -C2 -d -r1.201 -r1.202
*** mysql_tableanddata.php 21 Feb 2008 19:52:53 -0000 1.201
--- mysql_tableanddata.php 12 Apr 2008 11:21:46 -0000 1.202
***************
*** 1,5 ****
<?php
! $_SQL[1] = "
CREATE TABLE {$_TABLES['access']} (
acc_ft_id mediumint(8) NOT NULL default '0',
--- 1,5 ----
<?php
! $_SQL[] = "
CREATE TABLE {$_TABLES['access']} (
acc_ft_id mediumint(8) NOT NULL default '0',
***************
*** 9,12 ****
--- 9,21 ----
";
+ $_SQL[] = "
+ CREATE TABLE {$_TABLES['article_images']} (
+ ai_sid varchar(40) NOT NULL,
+ ai_img_num tinyint(2) unsigned NOT NULL,
+ ai_filename varchar(128) NOT NULL,
+ PRIMARY KEY (ai_sid,ai_img_num)
+ ) TYPE=MyISAM
+ ";
+
$_SQL[2] = "
CREATE TABLE {$_TABLES['blocks']} (
***************
*** 44,48 ****
";
! $_SQL[3] = "
CREATE TABLE {$_TABLES['commentcodes']} (
code tinyint(4) NOT NULL default '0',
--- 53,57 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['commentcodes']} (
code tinyint(4) NOT NULL default '0',
***************
*** 52,56 ****
";
! $_SQL[4] = "
CREATE TABLE {$_TABLES['commentmodes']} (
mode varchar(10) NOT NULL default '',
--- 61,65 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['commentmodes']} (
mode varchar(10) NOT NULL default '',
***************
*** 60,64 ****
";
! $_SQL[5] = "
CREATE TABLE {$_TABLES['comments']} (
cid int(10) unsigned NOT NULL auto_increment,
--- 69,73 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['comments']} (
cid int(10) unsigned NOT NULL auto_increment,
***************
*** 85,89 ****
";
! $_SQL[6] = "
CREATE TABLE {$_TABLES['conf_values']} (
name varchar(50) default NULL,
--- 94,98 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['conf_values']} (
name varchar(50) default NULL,
***************
*** 99,103 ****
";
! $_SQL[7] = "
CREATE TABLE {$_TABLES['cookiecodes']} (
cc_value int(8) unsigned NOT NULL default '0',
--- 108,112 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['cookiecodes']} (
cc_value int(8) unsigned NOT NULL default '0',
***************
*** 107,111 ****
";
! $_SQL[8] = "
CREATE TABLE {$_TABLES['dateformats']} (
dfid tinyint(4) NOT NULL default '0',
--- 116,120 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['dateformats']} (
dfid tinyint(4) NOT NULL default '0',
***************
*** 116,120 ****
";
! $_SQL[9] = "
CREATE TABLE {$_TABLES['events']} (
eid varchar(20) NOT NULL default '',
--- 125,129 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['events']} (
eid varchar(20) NOT NULL default '',
***************
*** 150,154 ****
";
! $_SQL[10] = "
CREATE TABLE {$_TABLES['eventsubmission']} (
eid varchar(20) NOT NULL default '',
--- 159,163 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['eventsubmission']} (
eid varchar(20) NOT NULL default '',
***************
*** 172,176 ****
";
! $_SQL[11] = "
CREATE TABLE {$_TABLES['featurecodes']} (
code tinyint(4) NOT NULL default '0',
--- 181,185 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['featurecodes']} (
code tinyint(4) NOT NULL default '0',
***************
*** 180,184 ****
";
! $_SQL[12] = "
CREATE TABLE {$_TABLES['features']} (
ft_id mediumint(8) NOT NULL auto_increment,
--- 189,193 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['features']} (
ft_id mediumint(8) NOT NULL auto_increment,
***************
*** 191,195 ****
";
! $_SQL[13] = "
CREATE TABLE {$_TABLES['frontpagecodes']} (
code tinyint(4) NOT NULL default '0',
--- 200,204 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['frontpagecodes']} (
code tinyint(4) NOT NULL default '0',
***************
*** 199,203 ****
";
! $_SQL[14] = "
CREATE TABLE {$_TABLES['group_assignments']} (
ug_main_grp_id mediumint(8) NOT NULL default '0',
--- 208,212 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['group_assignments']} (
ug_main_grp_id mediumint(8) NOT NULL default '0',
***************
*** 210,214 ****
";
! $_SQL[15] = "
CREATE TABLE {$_TABLES['groups']} (
grp_id mediumint(8) NOT NULL auto_increment,
--- 219,223 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['groups']} (
grp_id mediumint(8) NOT NULL auto_increment,
***************
*** 221,260 ****
";
! $_SQL[16] = "
! CREATE TABLE {$_TABLES['links']} (
! lid varchar(20) NOT NULL default '',
! cid varchar(32) default NULL,
! url varchar(255) default NULL,
! description text,
! title varchar(96) default NULL,
! hits int(11) NOT NULL default '0',
! date datetime default NULL,
! owner_id mediumint(8) unsigned NOT NULL default '1',
! group_id mediumint(8) unsigned NOT NULL default '1',
! perm_owner tinyint(1) unsigned NOT NULL default '3',
! perm_group tinyint(1) unsigned NOT NULL default '2',
! perm_members tinyint(1) unsigned NOT NULL default '2',
! perm_anon tinyint(1) unsigned NOT NULL default '2',
! INDEX links_category(cid),
! INDEX links_date(date),
! PRIMARY KEY (lid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[17] = "
! CREATE TABLE {$_TABLES['linksubmission']} (
! lid varchar(20) NOT NULL default '',
! cid varchar(32) default NULL,
! url varchar(255) default NULL,
! description text,
! title varchar(96) default NULL,
! hits int(11) default NULL,
! date datetime default NULL,
! owner_id mediumint(8) unsigned NOT NULL default '1',
! PRIMARY KEY (lid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[18] = "
CREATE TABLE {$_TABLES['maillist']} (
code int(1) NOT NULL default '0',
--- 230,234 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['maillist']} (
code int(1) NOT NULL default '0',
***************
*** 264,268 ****
";
! $_SQL[19] = "
CREATE TABLE {$_TABLES['personal_events']} (
eid varchar(20) NOT NULL default '',
--- 238,242 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['personal_events']} (
eid varchar(20) NOT NULL default '',
***************
*** 294,298 ****
";
! $_SQL[20] = "
CREATE TABLE {$_TABLES['plugins']} (
pi_name varchar(30) NOT NULL default '',
--- 268,285 ----
";
! $_SQL[] = "
! CREATE TABLE {$_TABLES['pingservice']} (
! pid smallint(5) unsigned NOT NULL auto_increment,
! name varchar(128) default NULL,
! ping_url varchar(255) default NULL,
! site_url varchar(255) default NULL,
! method varchar(80) default NULL,
! is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',
! PRIMARY KEY (pid),
! INDEX pingservice_is_enabled(is_enabled)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
CREATE TABLE {$_TABLES['plugins']} (
pi_name varchar(30) NOT NULL default '',
***************
*** 306,368 ****
";
! $_SQL[21] = "
! CREATE TABLE {$_TABLES['pollanswers']} (
! pid varchar(20) NOT NULL default '',
! qid mediumint(9) NOT NULL default '0',
! aid tinyint(3) unsigned NOT NULL default '0',
! answer varchar(255) default NULL,
! votes mediumint(8) unsigned default NULL,
! remark varchar(255) NULL,
! PRIMARY KEY (pid, qid, aid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[22] = "
! CREATE TABLE {$_TABLES['pollquestions']} (
! qid mediumint(9) NOT NULL DEFAULT '0',
! pid varchar(20) NOT NULL,
! question varchar(255) NOT NULL,
! PRIMARY KEY (qid, pid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[23] = "
! CREATE TABLE {$_TABLES['polltopics']} (
! pid varchar(20) NOT NULL,
! topic varchar(255) default NULL,
! voters mediumint(8) unsigned default NULL,
! questions int(11) NOT NULL default '0',
! date datetime default NULL,
! display tinyint(4) NOT NULL default '0',
! open tinyint(1) NOT NULL default '1',
! hideresults tinyint(1) NOT NULL default '0',
! commentcode tinyint(4) NOT NULL default '0',
! statuscode tinyint(4) NOT NULL default '0',
! owner_id mediumint(8) unsigned NOT NULL default '1',
! group_id mediumint(8) unsigned NOT NULL default '1',
! perm_owner tinyint(1) unsigned NOT NULL default '3',
! perm_group tinyint(1) unsigned NOT NULL default '2',
! perm_members tinyint(1) unsigned NOT NULL default '2',
! perm_anon tinyint(1) unsigned NOT NULL default '2',
! INDEX pollquestions_pid(pid),
! INDEX pollquestions_date(date),
! INDEX pollquestions_display(display),
! INDEX pollquestions_commentcode(commentcode),
! INDEX pollquestions_statuscode(statuscode),
! PRIMARY KEY (pid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[24] = "
! CREATE TABLE {$_TABLES['pollvoters']} (
! id int(10) unsigned NOT NULL auto_increment,
! pid varchar(20) NOT NULL default '',
! ipaddress varchar(15) NOT NULL default '',
! date int(10) unsigned default NULL,
! PRIMARY KEY (id)
! ) TYPE=MyISAM
! ";
!
! $_SQL[25] = "
CREATE TABLE {$_TABLES['postmodes']} (
code char(10) NOT NULL default '',
--- 293,297 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['postmodes']} (
code char(10) NOT NULL default '',
***************
*** 372,376 ****
";
! $_SQL[26] = "
CREATE TABLE {$_TABLES['sessions']} (
sess_id int(10) unsigned NOT NULL default '0',
--- 301,305 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['sessions']} (
sess_id int(10) unsigned NOT NULL default '0',
***************
*** 386,390 ****
";
! $_SQL[27] = "
CREATE TABLE {$_TABLES['sortcodes']} (
code char(4) NOT NULL default '0',
--- 315,319 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['sortcodes']} (
code char(4) NOT NULL default '0',
***************
*** 394,398 ****
";
! $_SQL[28] = "
CREATE TABLE {$_TABLES['speedlimit']} (
id int(10) unsigned NOT NULL auto_increment,
--- 323,327 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['speedlimit']} (
id int(10) unsigned NOT NULL auto_increment,
***************
*** 406,410 ****
";
! $_SQL[29] = "
CREATE TABLE {$_TABLES['statuscodes']} (
code int(1) NOT NULL default '0',
--- 335,339 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['statuscodes']} (
code int(1) NOT NULL default '0',
***************
*** 414,418 ****
";
! $_SQL[30] = "
CREATE TABLE {$_TABLES['stories']} (
sid varchar(40) NOT NULL default '',
--- 343,347 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['stories']} (
sid varchar(40) NOT NULL default '',
***************
*** 459,463 ****
";
! $_SQL[31] = "
CREATE TABLE {$_TABLES['storysubmission']} (
sid varchar(20) NOT NULL default '',
--- 388,392 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['storysubmission']} (
sid varchar(20) NOT NULL default '',
***************
*** 473,477 ****
";
! $_SQL[32] = "
CREATE TABLE {$_TABLES['syndication']} (
fid int(10) unsigned NOT NULL auto_increment,
--- 402,406 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['syndication']} (
fid int(10) unsigned NOT NULL auto_increment,
***************
*** 499,503 ****
";
! $_SQL[33] = "
CREATE TABLE {$_TABLES['topics']} (
tid varchar(20) NOT NULL default '',
--- 428,443 ----
";
! $_SQL[] = "
! CREATE TABLE {$_TABLES['tokens']} (
! token varchar(32) NOT NULL,
! created datetime NOT NULL,
! owner_id mediumint(8) unsigned NOT NULL,
! urlfor varchar(2000) NOT NULL,
! ttl mediumint(8) unsigned NOT NULL default '1',
! PRIMARY KEY (token)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
CREATE TABLE {$_TABLES['topics']} (
tid varchar(20) NOT NULL default '',
***************
*** 518,522 ****
";
! $_SQL[34] = "
CREATE TABLE {$_TABLES['usercomment']} (
uid mediumint(8) NOT NULL default '1',
--- 458,489 ----
";
! $_SQL[] = "
! CREATE TABLE {$_TABLES['trackback']} (
! cid int(10) unsigned NOT NULL auto_increment,
! sid varchar(40) NOT NULL,
! url varchar(255) default NULL,
! title varchar(128) default NULL,
! blog varchar(80) default NULL,
! excerpt text,
! date datetime default NULL,
! type varchar(30) NOT NULL default 'article',
! ipaddress varchar(15) NOT NULL default '',
! PRIMARY KEY (cid),
! INDEX trackback_sid(sid),
! INDEX trackback_url(url),
! INDEX trackback_type(type),
! INDEX trackback_date(date)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
! CREATE TABLE {$_TABLES['trackbackcodes']} (
! code tinyint(4) NOT NULL default '0',
! name varchar(32) default NULL,
! PRIMARY KEY (code)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
CREATE TABLE {$_TABLES['usercomment']} (
uid mediumint(8) NOT NULL default '1',
***************
*** 528,532 ****
";
! $_SQL[35] = "
CREATE TABLE {$_TABLES['userindex']} (
uid mediumint(8) NOT NULL default '1',
--- 495,499 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['userindex']} (
uid mediumint(8) NOT NULL default '1',
***************
*** 544,548 ****
";
! $_SQL[36] = "
CREATE TABLE {$_TABLES['userinfo']} (
uid mediumint(8) NOT NULL default '1',
--- 511,515 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['userinfo']} (
uid mediumint(8) NOT NULL default '1',
***************
*** 559,563 ****
";
! $_SQL[37] = "
CREATE TABLE {$_TABLES['userprefs']} (
uid mediumint(8) NOT NULL default '1',
--- 526,530 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['userprefs']} (
uid mediumint(8) NOT NULL default '1',
***************
*** 574,578 ****
";
! $_SQL[38] = "
CREATE TABLE {$_TABLES['users']} (
uid mediumint(8) NOT NULL auto_increment,
--- 541,545 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['users']} (
uid mediumint(8) NOT NULL auto_increment,
***************
*** 603,607 ****
";
! $_SQL[39] = "
CREATE TABLE {$_TABLES['vars']} (
name varchar(20) NOT NULL default '',
--- 570,574 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['vars']} (
name varchar(20) NOT NULL default '',
***************
*** 611,656 ****
";
! $_SQL[40] = "
! CREATE TABLE {$_TABLES['article_images']} (
! ai_sid varchar(40) NOT NULL,
! ai_img_num tinyint(2) unsigned NOT NULL,
! ai_filename varchar(128) NOT NULL,
! PRIMARY KEY (ai_sid,ai_img_num)
) TYPE=MyISAM
";
! $_SQL[41] = "
! CREATE TABLE {$_TABLES['trackback']} (
! cid int(10) unsigned NOT NULL auto_increment,
! sid varchar(40) NOT NULL,
url varchar(255) default NULL,
! title varchar(128) default NULL,
! blog varchar(80) default NULL,
! excerpt text,
date datetime default NULL,
! type varchar(30) NOT NULL default 'article',
ipaddress varchar(15) NOT NULL default '',
! PRIMARY KEY (cid),
! INDEX trackback_sid(sid),
! INDEX trackback_url(url),
! INDEX trackback_type(type),
! INDEX trackback_date(date)
) TYPE=MyISAM
";
! $_SQL[42] = "
! CREATE TABLE {$_TABLES['pingservice']} (
! pid smallint(5) unsigned NOT NULL auto_increment,
! name varchar(128) default NULL,
! ping_url varchar(255) default NULL,
! site_url varchar(255) default NULL,
! method varchar(80) default NULL,
! is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',
! PRIMARY KEY (pid),
! INDEX pingservice_is_enabled(is_enabled)
) TYPE=MyISAM
";
! $_SQL[43] = "
CREATE TABLE {$_TABLES['staticpage']} (
sp_id varchar(40) NOT NULL default '',
--- 578,705 ----
";
! // Tables used by the bundled plugins
!
! $_SQL[] = "
! CREATE TABLE {$_TABLES['linkcategories']} (
! cid varchar(32) NOT NULL,
! pid varchar(32) NOT NULL,
! category varchar(32) NOT NULL,
! description text DEFAULT NULL,
! tid varchar(20) DEFAULT NULL,
! created datetime DEFAULT NULL,
! modified datetime DEFAULT NULL,
! owner_id mediumint(8) unsigned NOT NULL default '1',
! group_id mediumint(8) unsigned NOT NULL default '1',
! perm_owner tinyint(1) unsigned NOT NULL default '3',
! perm_group tinyint(1) unsigned NOT NULL default '2',
! perm_members tinyint(1) unsigned NOT NULL default '2',
! perm_anon tinyint(1) unsigned NOT NULL default '2',
! PRIMARY KEY (cid),
! KEY links_pid (pid)
) TYPE=MyISAM
";
! $_SQL[] = "
! CREATE TABLE {$_TABLES['links']} (
! lid varchar(20) NOT NULL default '',
! cid varchar(32) default NULL,
url varchar(255) default NULL,
! description text,
! title varchar(96) default NULL,
! hits int(11) NOT NULL default '0',
date datetime default NULL,
! owner_id mediumint(8) unsigned NOT NULL default '1',
! group_id mediumint(8) unsigned NOT NULL default '1',
! perm_owner tinyint(1) unsigned NOT NULL default '3',
! perm_group tinyint(1) unsigned NOT NULL default '2',
! perm_members tinyint(1) unsigned NOT NULL default '2',
! perm_anon tinyint(1) unsigned NOT NULL default '2',
! INDEX links_category(cid),
! INDEX links_date(date),
! PRIMARY KEY (lid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
! CREATE TABLE {$_TABLES['linksubmission']} (
! lid varchar(20) NOT NULL default '',
! cid varchar(32) default NULL,
! url varchar(255) default NULL,
! description text,
! title varchar(96) default NULL,
! hits int(11) default NULL,
! date datetime default NULL,
! owner_id mediumint(8) unsigned NOT NULL default '1',
! PRIMARY KEY (lid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
! CREATE TABLE {$_TABLES['pollanswers']} (
! pid varchar(20) NOT NULL default '',
! qid mediumint(9) NOT NULL default '0',
! aid tinyint(3) unsigned NOT NULL default '0',
! answer varchar(255) default NULL,
! votes mediumint(8) unsigned default NULL,
! remark varchar(255) NULL,
! PRIMARY KEY (pid, qid, aid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
! CREATE TABLE {$_TABLES['pollquestions']} (
! qid mediumint(9) NOT NULL DEFAULT '0',
! pid varchar(20) NOT NULL,
! question varchar(255) NOT NULL,
! PRIMARY KEY (qid, pid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
! CREATE TABLE {$_TABLES['polltopics']} (
! pid varchar(20) NOT NULL,
! topic varchar(255) default NULL,
! voters mediumint(8) unsigned default NULL,
! questions int(11) NOT NULL default '0',
! date datetime default NULL,
! display tinyint(4) NOT NULL default '0',
! open tinyint(1) NOT NULL default '1',
! hideresults tinyint(1) NOT NULL default '0',
! commentcode tinyint(4) NOT NULL default '0',
! statuscode tinyint(4) NOT NULL default '0',
! owner_id mediumint(8) unsigned NOT NULL default '1',
! group_id mediumint(8) unsigned NOT NULL default '1',
! perm_owner tinyint(1) unsigned NOT NULL default '3',
! perm_group tinyint(1) unsigned NOT NULL default '2',
! perm_members tinyint(1) unsigned NOT NULL default '2',
! perm_anon tinyint(1) unsigned NOT NULL default '2',
! INDEX pollquestions_pid(pid),
! INDEX pollquestions_date(date),
! INDEX pollquestions_display(display),
! INDEX pollquestions_commentcode(commentcode),
! INDEX pollquestions_statuscode(statuscode),
! PRIMARY KEY (pid)
! ) TYPE=MyISAM
! ";
!
! $_SQL[] = "
! CREATE TABLE {$_TABLES['pollvoters']} (
! id int(10) unsigned NOT NULL auto_increment,
! pid varchar(20) NOT NULL default '',
ipaddress varchar(15) NOT NULL default '',
! date int(10) unsigned default NULL,
! PRIMARY KEY (id)
) TYPE=MyISAM
";
! $_SQL[] = "
! CREATE TABLE {$_TABLES['spamx']} (
! name varchar(20) NOT NULL default '',
! value varchar(255) NOT NULL default '',
! INDEX spamx_name(name)
) TYPE=MyISAM
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['staticpage']} (
sp_id varchar(40) NOT NULL default '',
***************
*** 685,735 ****
KEY staticpage_sp_tid (sp_tid),
KEY staticpage_sp_where (sp_where)
- ) TYPE=MyISAM
- ";
-
- $_SQL[44] = "
- CREATE TABLE {$_TABLES['spamx']} (
- name varchar(20) NOT NULL default '',
- value varchar(255) NOT NULL default '',
- INDEX spamx_name(name)
- ) TYPE=MyISAM
- ";
-
- $_SQL[45] = "
- CREATE TABLE {$_TABLES['trackbackcodes']} (
- code tinyint(4) NOT NULL default '0',
- name varchar(32) default NULL,
- PRIMARY KEY (code)
- ) TYPE=MyISAM
- ";
-
- $_SQL[46] = "
- CREATE TABLE {$_TABLES['linkcategories']} (
- cid varchar(32) NOT NULL,
- pid varchar(32) NOT NULL,
- category varchar(32) NOT NULL,
- description text DEFAULT NULL,
- tid varchar(20) DEFAULT NULL,
- created datetime DEFAULT NULL,
- modified datetime DEFAULT NULL,
- owner_id mediumint(8) unsigned NOT NULL default '1',
- group_id mediumint(8) unsigned NOT NULL default '1',
- perm_owner tinyint(1) unsigned NOT NULL default '3',
- perm_group tinyint(1) unsigned NOT NULL default '2',
- perm_members tinyint(1) unsigned NOT NULL default '2',
- perm_anon tinyint(1) unsigned NOT NULL default '2',
- PRIMARY KEY (cid),
- KEY links_pid (pid)
- ) TYPE=MyISAM
- ";
-
- $_SQL[47] = "
- CREATE TABLE {$_TABLES['tokens']} (
- token varchar(32) NOT NULL,
- created datetime NOT NULL,
- owner_id mediumint(8) unsigned NOT NULL,
- urlfor varchar(2000) NOT NULL,
- ttl mediumint(8) unsigned NOT NULL default '1',
- PRIMARY KEY (token)
) TYPE=MyISAM
";
--- 734,737 ----
More information about the geeklog-cvs
mailing list