| Hannes Magnusson 2006-09-28, 6:57 pm |
| 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-m...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-m...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-m...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),
|