svn: /web/php-master/trunk/ event.sql mirrors.sql
| From: | Hannes Magnusson | Date: | Mon, 10 Oct 2011 10:54:51 +0000 |
| Subject: | svn: /web/php-master/trunk/ event.sql mirrors.sql | ||
| Groups: | php.webmaster | ||
| Request: | Send a blank email to php-webmaster+get-12341@lists.php.net to get a copy of this message | ||
bjori Mon, 10 Oct 2011 10:54:51 +0000
Revision: http://svn.php.net/viewvc?view=revision&revision=317960
Log:
Sync with how the tables are actually on master
Changed paths:
U web/php-master/trunk/event.sql
U web/php-master/trunk/mirrors.sql
Modified: web/php-master/trunk/event.sql
===================================================================
--- web/php-master/trunk/event.sql 2011-10-10 10:53:21 UTC (rev 317959)
+++ web/php-master/trunk/event.sql 2011-10-10 10:54:51 UTC (rev 317960)
@@ -3,19 +3,19 @@
#
CREATE TABLE phpcal (
- id INT(8) NOT NULL AUTO_INCREMENT,
- sdato DATE DEFAULT NULL,
- edato DATE DEFAULT NULL,
- recur VARCHAR(12) DEFAULT NULL,
- sdesc VARCHAR(32) NOT NULL DEFAULT '',
- url VARCHAR(128) DEFAULT NULL,
- email VARCHAR(128) DEFAULT NULL,
- ldesc TEXT,
- tipo INT(1) NOT NULL DEFAULT '0',
- approved INT(1) NOT NULL DEFAULT '0',
- app_by VARCHAR(16) DEFAULT NULL,
- country CHAR(3) NOT NULL DEFAULT '',
- category TINYINT(4) NOT NULL DEFAULT '0',
+ id int(8) NOT NULL auto_increment,
+ sdato date default NULL,
+ edato date default NULL,
+ recur varchar(12) default NULL,
+ sdesc varchar(32) NOT NULL default '',
+ url varchar(128) default NULL,
+ email varchar(128) NOT NULL default '',
+ ldesc text,
+ tipo int(1) NOT NULL default '0',
+ approved int(1) NOT NULL default '0',
+ app_by varchar(16) default NULL,
+ country char(3) NOT NULL default '',
+ category tinyint(4) NOT NULL default '0',
PRIMARY KEY (id),
KEY sdato (sdato),
KEY edato (edato),
@@ -23,3 +23,4 @@
KEY category (category),
FULLTEXT KEY sdesc (sdesc,ldesc,email)
) TYPE=MyISAM;
+
Modified: web/php-master/trunk/mirrors.sql
===================================================================
--- web/php-master/trunk/mirrors.sql 2011-10-10 10:53:21 UTC (rev 317959)
+++ web/php-master/trunk/mirrors.sql 2011-10-10 10:54:51 UTC (rev 317960)
@@ -22,6 +22,7 @@
phpversion varchar(16) NOT NULL default '',
acmt text,
ocmt text,
+ maintainer2 varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY hostname (hostname)
) TYPE=MyISAM;