cvs: php-master-web / mirrors.sql
| From: | jim winstead | Date: | Sun, 02 Jun 2002 05:39:19 +0000 |
| Subject: | cvs: php-master-web / mirrors.sql | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-10620@lists.php.net to get a copy of this message | ||
jimw Sun Jun 2 01:39:19 2002 EDT
Added files:
/php-master-web mirrors.sql
Log:
record mirrors table layout for posterity
Index: php-master-web/mirrors.sql
+++ php-master-web/mirrors.sql
--
-- Table structure for table 'mirrors'
--
CREATE TABLE mirrors (
id int(8) NOT NULL auto_increment,
mirrortype int(1) NOT NULL default '1',
cc char(3) NOT NULL default '',
lang varchar(5) NOT NULL default '',
hostname varchar(40) NOT NULL default '',
cname varchar(80) NOT NULL default '',
maintainer varchar(255) NOT NULL default '',
providername varchar(255) NOT NULL default '',
providerurl varchar(255) NOT NULL default '',
has_stats int(1) NOT NULL default '0',
has_search int(1) NOT NULL default '0',
active int(1) NOT NULL default '0',
created datetime NOT NULL default '0000-00-00 00:00:00',
lastedited datetime NOT NULL default '0000-00-00 00:00:00',
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 '',
PRIMARY KEY (id)
) TYPE=MyISAM;