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/profile/profile.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/profile/profile.install')
-rw-r--r-- | modules/profile/profile.install | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/modules/profile/profile.install b/modules/profile/profile.install index f6258607b..df1c85c7c 100644 --- a/modules/profile/profile.install +++ b/modules/profile/profile.install @@ -6,18 +6,18 @@ function profile_install() { case 'mysql': case 'mysqli': db_query("CREATE TABLE {profile_fields} ( - fid int(10) NOT NULL auto_increment, + fid int NOT NULL auto_increment, title varchar(255) default NULL, name varchar(128) default NULL, explanation TEXT default NULL, category varchar(255) default NULL, page varchar(255) default NULL, type varchar(128) default NULL, - weight tinyint(1) DEFAULT '0' NOT NULL, - required tinyint(1) DEFAULT '0' NOT NULL, - register tinyint(1) DEFAULT '0' NOT NULL, - visibility tinyint(1) DEFAULT '0' NOT NULL, - autocomplete tinyint(1) DEFAULT '0' NOT NULL, + weight tinyint DEFAULT '0' NOT NULL, + required tinyint DEFAULT '0' NOT NULL, + register tinyint DEFAULT '0' NOT NULL, + visibility tinyint DEFAULT '0' NOT NULL, + autocomplete tinyint DEFAULT '0' NOT NULL, options text, KEY category (category), UNIQUE KEY name (name), @@ -25,8 +25,8 @@ function profile_install() { ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); db_query("CREATE TABLE {profile_values} ( - fid int(10) unsigned default '0', - uid int(10) unsigned default '0', + fid int unsigned default '0', + uid int unsigned default '0', value text, KEY uid (uid), KEY fid (fid) |