diff options
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) |