cvs: php-master-web / mirrors.sql note.sql users.sql

bjori Thu Sep 28 18:04:02 2006 UTC Modified files: /php-master-web mirrors.sql note.sql users.sql Log: Update table structure # Thanks Derick! http://cvs.php.net/viewvc.cgi/php-master-web/mirrors.sql?r1=1.2&r2=1.3&diff_format=u Index: php-master-web/mirrors.sql diff -u php-master-web/mirrors.sql:1.2 php-master-web/mirrors.sql:1.3 --- php-master-web/mirrors.sql:1.2 Fri Dec 20 23:07:37 2002 +++ php-master-web/mirrors.sql Thu Sep 28 18:04:02 2006 @@ -20,6 +20,8 @@ lastupdated datetime NOT NULL default '0000-00-00 00:00:00', lastchecked datetime NOT NULL default '0000-00-00 00:00:00', phpversion varchar(16) NOT NULL default '', + acmt text, + ocmt text, PRIMARY KEY (id), UNIQUE KEY hostname (hostname) ) TYPE=MyISAM; http://cvs.php.net/viewvc.cgi/php-master-web/note.sql?r1=1.3&r2=1.4&diff_format=u Index: php-master-web/note.sql diff -u php-master-web/note.sql:1.3 php-master-web/note.sql:1.4 --- php-master-web/note.sql:1.3 Sun Apr 21 19:02:22 2002 +++ php-master-web/note.sql Thu Sep 28 18:04:02 2006 @@ -13,22 +13,22 @@ */ CREATE TABLE IF NOT EXISTS note ( - id INT NOT NULL AUTO_INCREMENT, - sect VARCHAR(80) NOT NULL DEFAULT '', - user VARCHAR(80) DEFAULT NULL, - note TEXT, - ts DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', - status VARCHAR(16) DEFAULT NULL, - lang VARCHAR(16) DEFAULT NULL, - votes INT NOT NULL DEFAULT '0', - rating INT NOT NULL DEFAULT '0', - updated DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + id mediumint(9) NOT NULL auto_increment, + sect varchar(80) NOT NULL default '', + user varchar(80) default NULL, + note text, + ts datetime NOT NULL default '0000-00-00 00:00:00', + status varchar(16) default NULL, + lang varchar(16) default NULL, + votes int(11) NOT NULL default '0', + rating int(11) NOT NULL default '0', + updated datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id), - KEY (sect) + KEY idx_sect (sect) ) TYPE=MyISAM PACK_KEYS=1; CREATE TABLE IF NOT EXISTS alerts ( - user INT NOT NULL, - sect VARCHAR(80) not NULL, + user INT NOT NULL default '0', + sect VARCHAR(80) not NULL default '', updated TIMESTAMP(14) NOT NULL -); +) TYPE=MyISAM; http://cvs.php.net/viewvc.cgi/php-master-web/users.sql?r1=1.4&r2=1.5&diff_format=u Index: php-master-web/users.sql diff -u php-master-web/users.sql:1.4 php-master-web/users.sql:1.5 --- php-master-web/users.sql:1.4 Tue Mar 4 23:56:11 2003 +++ php-master-web/users.sql Thu Sep 28 18:04:02 2006 @@ -34,6 +34,11 @@ dns_allow int(1) NOT NULL default '1', dns_type varchar(5) NOT NULL default 'NONE', dns_target varchar(255) NOT NULL default '', + last_commit datetime default NULL, + num_commits int(11) NOT NULL default '0', + verified int(1) NOT NULL default '0', + use_sa int(11) default '5', + greylist int(11) NOT NULL default '0', PRIMARY KEY (userid), UNIQUE KEY email (email), UNIQUE KEY username (username),