Index: branches/RC/core/install/install_schema.sql =================================================================== diff -u -N -r10784 -r10856 --- branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10784) +++ branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10856) @@ -21,23 +21,25 @@ CREATE TABLE CustomField ( CustomFieldId int(11) NOT NULL auto_increment, - Type int(11) NOT NULL default '0', + `Type` int(11) NOT NULL default '0', FieldName varchar(255) NOT NULL default '', FieldLabel varchar(40) default NULL, - MultiLingual TINYINT UNSIGNED NOT NULL DEFAULT '1', + MultiLingual tinyint(3) unsigned NOT NULL default '1', Heading varchar(60) default NULL, Prompt varchar(60) default NULL, ElementType varchar(50) NOT NULL default '', - ValueList varchar(255) default NULL, + ValueList text, + DefaultValue varchar(255) NOT NULL default '', DisplayOrder int(11) NOT NULL default '0', OnGeneralTab tinyint(4) NOT NULL default '0', IsSystem tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (CustomFieldId), - KEY Type (Type), + KEY `Type` (`Type`), KEY MultiLingual (MultiLingual), KEY DisplayOrder (DisplayOrder), KEY OnGeneralTab (OnGeneralTab), - KEY IsSystem (IsSystem) + KEY IsSystem (IsSystem), + KEY DefaultValue (DefaultValue) ); CREATE TABLE ConfigurationAdmin (