[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.46,1.47
geeklog-cvs-admin at lists.geeklog.net
geeklog-cvs-admin at lists.geeklog.net
Mon May 5 12:52:37 EDT 2003
Update of /usr/cvs/geeklog/geeklog-1.3/sql
In directory internal.geeklog.net:/tmp/cvs-serv5089/sql
Modified Files:
mysql_tableanddata.php
Log Message:
Replaced separate commentspeedlimit and submitspeedlimit tables with a general speedlimit table and new COM_ functions operating on it.
Index: mysql_tableanddata.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.46
retrieving revision 1.47
diff -C2 -d -r1.46 -r1.47
*** mysql_tableanddata.php 5 May 2003 09:33:39 -0000 1.46
--- mysql_tableanddata.php 5 May 2003 16:52:35 -0000 1.47
***************
*** 75,87 ****
$_SQL[6] = "
- CREATE TABLE {$_TABLES['commentspeedlimit']} (
- id int(10) unsigned NOT NULL auto_increment,
- ipaddress varchar(15) NOT NULL default '',
- date int(10) unsigned default NULL,
- PRIMARY KEY (id)
- ) TYPE=MyISAM
- ";
-
- $_SQL[7] = "
CREATE TABLE {$_TABLES['cookiecodes']} (
cc_value int(8) unsigned NOT NULL default '0',
--- 75,78 ----
***************
*** 91,95 ****
";
! $_SQL[8] = "
CREATE TABLE {$_TABLES['dateformats']} (
dfid tinyint(4) NOT NULL default '0',
--- 82,86 ----
";
! $_SQL[7] = "
CREATE TABLE {$_TABLES['dateformats']} (
dfid tinyint(4) NOT NULL default '0',
***************
*** 100,104 ****
";
! $_SQL[9] = "
CREATE TABLE {$_TABLES['events']} (
eid varchar(20) NOT NULL default '',
--- 91,95 ----
";
! $_SQL[8] = "
CREATE TABLE {$_TABLES['events']} (
eid varchar(20) NOT NULL default '',
***************
*** 130,134 ****
";
! $_SQL[10] = "
CREATE TABLE {$_TABLES['eventsubmission']} (
eid varchar(20) NOT NULL default '',
--- 121,125 ----
";
! $_SQL[9] = "
CREATE TABLE {$_TABLES['eventsubmission']} (
eid varchar(20) NOT NULL default '',
***************
*** 152,156 ****
";
! $_SQL[11] = "
CREATE TABLE {$_TABLES['featurecodes']} (
code tinyint(4) NOT NULL default '0',
--- 143,147 ----
";
! $_SQL[10] = "
CREATE TABLE {$_TABLES['featurecodes']} (
code tinyint(4) NOT NULL default '0',
***************
*** 160,164 ****
";
! $_SQL[12] = "
CREATE TABLE {$_TABLES['features']} (
ft_id mediumint(8) NOT NULL auto_increment,
--- 151,155 ----
";
! $_SQL[11] = "
CREATE TABLE {$_TABLES['features']} (
ft_id mediumint(8) NOT NULL auto_increment,
***************
*** 171,175 ****
";
! $_SQL[13] = "
CREATE TABLE {$_TABLES['frontpagecodes']} (
code tinyint(4) NOT NULL default '0',
--- 162,166 ----
";
! $_SQL[12] = "
CREATE TABLE {$_TABLES['frontpagecodes']} (
code tinyint(4) NOT NULL default '0',
***************
*** 179,183 ****
";
! $_SQL[14] = "
CREATE TABLE {$_TABLES['group_assignments']} (
ug_main_grp_id mediumint(8) NOT NULL default '0',
--- 170,174 ----
";
! $_SQL[13] = "
CREATE TABLE {$_TABLES['group_assignments']} (
ug_main_grp_id mediumint(8) NOT NULL default '0',
***************
*** 189,193 ****
";
! $_SQL[15] = "
CREATE TABLE {$_TABLES['groups']} (
grp_id mediumint(8) NOT NULL auto_increment,
--- 180,184 ----
";
! $_SQL[14] = "
CREATE TABLE {$_TABLES['groups']} (
grp_id mediumint(8) NOT NULL auto_increment,
***************
*** 200,204 ****
";
! $_SQL[16] = "
CREATE TABLE {$_TABLES['links']} (
lid varchar(20) NOT NULL default '',
--- 191,195 ----
";
! $_SQL[15] = "
CREATE TABLE {$_TABLES['links']} (
lid varchar(20) NOT NULL default '',
***************
*** 220,224 ****
";
! $_SQL[17] = "
CREATE TABLE {$_TABLES['linksubmission']} (
lid varchar(20) NOT NULL default '',
--- 211,215 ----
";
! $_SQL[16] = "
CREATE TABLE {$_TABLES['linksubmission']} (
lid varchar(20) NOT NULL default '',
***************
*** 233,237 ****
";
! $_SQL[18] = "
CREATE TABLE {$_TABLES['maillist']} (
code int(1) NOT NULL default '0',
--- 224,228 ----
";
! $_SQL[17] = "
CREATE TABLE {$_TABLES['maillist']} (
code int(1) NOT NULL default '0',
***************
*** 241,245 ****
";
! $_SQL[19] = "
CREATE TABLE {$_TABLES['personal_events']} (
eid varchar(20) NOT NULL default '',
--- 232,236 ----
";
! $_SQL[18] = "
CREATE TABLE {$_TABLES['personal_events']} (
eid varchar(20) NOT NULL default '',
***************
*** 270,274 ****
";
! $_SQL[20] = "
CREATE TABLE {$_TABLES['plugins']} (
pi_name varchar(30) NOT NULL default '',
--- 261,265 ----
";
! $_SQL[19] = "
CREATE TABLE {$_TABLES['plugins']} (
pi_name varchar(30) NOT NULL default '',
***************
*** 281,285 ****
";
! $_SQL[21] = "
CREATE TABLE {$_TABLES['pollanswers']} (
qid varchar(20) NOT NULL default '',
--- 272,276 ----
";
! $_SQL[20] = "
CREATE TABLE {$_TABLES['pollanswers']} (
qid varchar(20) NOT NULL default '',
***************
*** 291,295 ****
";
! $_SQL[22] = "
CREATE TABLE {$_TABLES['pollquestions']} (
qid varchar(20) NOT NULL default '',
--- 282,286 ----
";
! $_SQL[21] = "
CREATE TABLE {$_TABLES['pollquestions']} (
qid varchar(20) NOT NULL default '',
***************
*** 314,318 ****
";
! $_SQL[23] = "
CREATE TABLE {$_TABLES['pollvoters']} (
id int(10) unsigned NOT NULL auto_increment,
--- 305,309 ----
";
! $_SQL[22] = "
CREATE TABLE {$_TABLES['pollvoters']} (
id int(10) unsigned NOT NULL auto_increment,
***************
*** 324,328 ****
";
! $_SQL[24] = "
CREATE TABLE {$_TABLES['postmodes']} (
code char(10) NOT NULL default '',
--- 315,319 ----
";
! $_SQL[23] = "
CREATE TABLE {$_TABLES['postmodes']} (
code char(10) NOT NULL default '',
***************
*** 332,336 ****
";
! $_SQL[25] = "
CREATE TABLE {$_TABLES['sessions']} (
sess_id int(10) unsigned NOT NULL default '0',
--- 323,327 ----
";
! $_SQL[24] = "
CREATE TABLE {$_TABLES['sessions']} (
sess_id int(10) unsigned NOT NULL default '0',
***************
*** 346,350 ****
";
! $_SQL[26] = "
CREATE TABLE {$_TABLES['sortcodes']} (
code char(4) NOT NULL default '0',
--- 337,341 ----
";
! $_SQL[25] = "
CREATE TABLE {$_TABLES['sortcodes']} (
code char(4) NOT NULL default '0',
***************
*** 354,357 ****
--- 345,358 ----
";
+ $_SQL[26] = "
+ CREATE TABLE {$_TABLES['speedlimit']} (
+ id int(10) unsigned NOT NULL auto_increment,
+ ipaddress varchar(15) NOT NULL default '',
+ date int(10) unsigned default NULL,
+ type varchar(30) NOT NULL default 'submit',
+ PRIMARY KEY (id)
+ ) TYPE = MyISAM
+ ";
+
$_SQL[27] = "
CREATE TABLE {$_TABLES['statuscodes']} (
***************
*** 411,423 ****
$_SQL[30] = "
- CREATE TABLE {$_TABLES['submitspeedlimit']} (
- id int(10) unsigned NOT NULL auto_increment,
- ipaddress varchar(15) NOT NULL default '',
- date int(10) unsigned default NULL,
- PRIMARY KEY (id)
- ) TYPE=MyISAM
- ";
-
- $_SQL[31] = "
CREATE TABLE {$_TABLES['topics']} (
tid varchar(20) NOT NULL default '',
--- 412,415 ----
***************
*** 437,441 ****
";
! $_SQL[32] = "
CREATE TABLE {$_TABLES['tzcodes']} (
tz char(3) NOT NULL default '',
--- 429,433 ----
";
! $_SQL[31] = "
CREATE TABLE {$_TABLES['tzcodes']} (
tz char(3) NOT NULL default '',
***************
*** 446,450 ****
";
! $_SQL[33] = "
CREATE TABLE {$_TABLES['usercomment']} (
uid mediumint(8) NOT NULL default '1',
--- 438,442 ----
";
! $_SQL[32] = "
CREATE TABLE {$_TABLES['usercomment']} (
uid mediumint(8) NOT NULL default '1',
***************
*** 456,460 ****
";
! $_SQL[34] = "
CREATE TABLE {$_TABLES['userindex']} (
uid mediumint(8) NOT NULL default '1',
--- 448,452 ----
";
! $_SQL[33] = "
CREATE TABLE {$_TABLES['userindex']} (
uid mediumint(8) NOT NULL default '1',
***************
*** 471,475 ****
";
! $_SQL[35] = "
CREATE TABLE {$_TABLES['userinfo']} (
uid mediumint(8) NOT NULL default '1',
--- 463,467 ----
";
! $_SQL[34] = "
CREATE TABLE {$_TABLES['userinfo']} (
uid mediumint(8) NOT NULL default '1',
***************
*** 484,488 ****
";
! $_SQL[36] = "
CREATE TABLE {$_TABLES['userprefs']} (
uid mediumint(8) NOT NULL default '1',
--- 476,480 ----
";
! $_SQL[35] = "
CREATE TABLE {$_TABLES['userprefs']} (
uid mediumint(8) NOT NULL default '1',
***************
*** 497,501 ****
";
! $_SQL[37] = "
CREATE TABLE {$_TABLES['users']} (
uid mediumint(8) NOT NULL auto_increment,
--- 489,493 ----
";
! $_SQL[36] = "
CREATE TABLE {$_TABLES['users']} (
uid mediumint(8) NOT NULL auto_increment,
***************
*** 517,521 ****
";
! $_SQL[38] = "
CREATE TABLE {$_TABLES['vars']} (
name varchar(20) NOT NULL default '',
--- 509,513 ----
";
! $_SQL[37] = "
CREATE TABLE {$_TABLES['vars']} (
name varchar(20) NOT NULL default '',
***************
*** 525,529 ****
";
! $_SQL[39] = "
CREATE TABLE {$_TABLES['article_images']} (
ai_sid varchar(20) NOT NULL,
--- 517,521 ----
";
! $_SQL[38] = "
CREATE TABLE {$_TABLES['article_images']} (
ai_sid varchar(20) NOT NULL,
***************
*** 534,538 ****
";
! $_SQL[40] = "
CREATE TABLE {$_TABLES['staticpage']} (
sp_id varchar(20) NOT NULL default '',
--- 526,530 ----
";
! $_SQL[39] = "
CREATE TABLE {$_TABLES['staticpage']} (
sp_id varchar(20) NOT NULL default '',
More information about the geeklog-cvs
mailing list