Index: modules/profile/profile.install =================================================================== RCS file: /cvs/drupal/drupal/modules/profile/profile.install,v retrieving revision 1.7 diff -u -p -r1.7 profile.install --- modules/profile/profile.install 1 Sep 2006 07:40:08 -0000 1.7 +++ modules/profile/profile.install 25 Nov 2006 14:09:14 -0000 @@ -12,7 +12,7 @@ function profile_install() { fid int NOT NULL auto_increment, title varchar(255) default NULL, name varchar(128) default NULL, - explanation TEXT default NULL, + explanation TEXT, category varchar(255) default NULL, page varchar(255) default NULL, type varchar(128) default NULL, Index: modules/system/system.install =================================================================== RCS file: /cvs/drupal/drupal/modules/system/system.install,v retrieving revision 1.44 diff -u -p -r1.44 system.install --- modules/system/system.install 24 Nov 2006 11:10:48 -0000 1.44 +++ modules/system/system.install 25 Nov 2006 14:06:08 -0000 @@ -148,7 +148,7 @@ function system_install() { custom tinyint DEFAULT '0' NOT NULL, throttle tinyint DEFAULT '0' NOT NULL, visibility tinyint DEFAULT '0' NOT NULL, - pages text DEFAULT '' NOT NULL, + pages text NOT NULL, title varchar(64) DEFAULT '' NOT NULL ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); @@ -332,9 +332,9 @@ function system_install() { vid int unsigned NOT NULL, uid int NOT NULL default '0', title varchar(128) NOT NULL default '', - body longtext NOT NULL default '', - teaser longtext NOT NULL default '', - log longtext NOT NULL default '', + body longtext NOT NULL, + teaser longtext NOT, + log longtext NOT NULL, timestamp int NOT NULL default '0', format int NOT NULL default '0', PRIMARY KEY (vid), @@ -1563,8 +1563,8 @@ function system_update_133() { if ($GLOBALS['db_type'] == 'mysql') { $ret[] = update_sql("CREATE TABLE {contact} ( subject varchar(255) NOT NULL default '', - recipients longtext NOT NULL default '', - reply longtext NOT NULL default '' + recipients longtext NOT NULL, + reply longtext NOT NULL )"); $ret[] = update_sql("ALTER TABLE {users} ADD login int NOT NULL default '0'"); }