diff options
author | Dries Buytaert <dries@buytaert.net> | 2006-08-20 06:38:50 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2006-08-20 06:38:50 +0000 |
commit | 7178f2f99e813b2eb6926a562c1448dbc6b715e5 (patch) | |
tree | 38080358708c6edf14456e45ca6c70ed45616372 /modules/aggregator/aggregator.install | |
parent | 3646f8914f3c58a4c5178cf5db484cef246918fb (diff) | |
download | brdo-7178f2f99e813b2eb6926a562c1448dbc6b715e5.tar.gz brdo-7178f2f99e813b2eb6926a562c1448dbc6b715e5.tar.bz2 |
- Patch #79428 by Chris Johnson: remove int display width declarations from MySQL create table statements.
Diffstat (limited to 'modules/aggregator/aggregator.install')
-rw-r--r-- | modules/aggregator/aggregator.install | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/modules/aggregator/aggregator.install b/modules/aggregator/aggregator.install index 5d042cc02..d1d43c608 100644 --- a/modules/aggregator/aggregator.install +++ b/modules/aggregator/aggregator.install @@ -6,51 +6,51 @@ function aggregator_install() { case 'mysql': case 'mysqli': db_query("CREATE TABLE {aggregator_category} ( - cid int(10) NOT NULL auto_increment, + cid int NOT NULL auto_increment, title varchar(255) NOT NULL default '', description longtext NOT NULL, - block tinyint(2) NOT NULL default '0', + block tinyint NOT NULL default '0', PRIMARY KEY (cid), UNIQUE KEY title (title) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); db_query("CREATE TABLE {aggregator_category_feed} ( - fid int(10) NOT NULL default '0', - cid int(10) NOT NULL default '0', + fid int NOT NULL default '0', + cid int NOT NULL default '0', PRIMARY KEY (fid,cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); db_query("CREATE TABLE {aggregator_category_item} ( - iid int(10) NOT NULL default '0', - cid int(10) NOT NULL default '0', + iid int NOT NULL default '0', + cid int NOT NULL default '0', PRIMARY KEY (iid,cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); db_query("CREATE TABLE {aggregator_feed} ( - fid int(10) NOT NULL auto_increment, + fid int NOT NULL auto_increment, title varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', - refresh int(10) NOT NULL default '0', - checked int(10) NOT NULL default '0', + refresh int NOT NULL default '0', + checked int NOT NULL default '0', link varchar(255) NOT NULL default '', description longtext NOT NULL, image longtext NOT NULL, etag varchar(255) NOT NULL default '', - modified int(10) NOT NULL default '0', - block tinyint(2) NOT NULL default '0', + modified int NOT NULL default '0', + block tinyint NOT NULL default '0', PRIMARY KEY (fid), UNIQUE KEY link (url), UNIQUE KEY title (title) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); db_query("CREATE TABLE {aggregator_item} ( - iid int(10) NOT NULL auto_increment, - fid int(10) NOT NULL default '0', + iid int NOT NULL auto_increment, + fid int NOT NULL default '0', title varchar(255) NOT NULL default '', link varchar(255) NOT NULL default '', author varchar(255) NOT NULL default '', description longtext NOT NULL, - timestamp int(11) default NULL, + timestamp int default NULL, guid varchar(255), PRIMARY KEY (iid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); |