Index: branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql =================================================================== diff -u -r7816 -r7829 --- branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql (.../install_schema.sql) (revision 7816) +++ branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql (.../install_schema.sql) (revision 7829) @@ -87,7 +87,7 @@ EventId int(11) NOT NULL auto_increment, Event varchar(40) NOT NULL default '', Enabled int(11) NOT NULL default '1', - FromUserId int(11) NOT NULL default '0', + FromUserId int(11) NOT NULL default '-1', Module varchar(40) NOT NULL default '', Description varchar(255) NOT NULL default '', Type int(11) NOT NULL default '0', @@ -102,16 +102,16 @@ LanguageId int(11) NOT NULL auto_increment, PackName varchar(40) NOT NULL default '', LocalName varchar(40) NOT NULL default '', - Enabled int(11) NOT NULL default '0', + Enabled int(11) NOT NULL default '1', PrimaryLang int(11) NOT NULL default '0', IconURL varchar(255) default NULL, DateFormat varchar(50) NOT NULL default '', TimeFormat varchar(50) NOT NULL default '', - InputDateFormat varchar(50) NOT NULL default '', - InputTimeFormat varchar(50) NOT NULL default '', - DecimalPoint char(2) NOT NULL default '.', - ThousandSep tinytext NULL, - Charset varchar(20) NOT NULL default '', + InputDateFormat varchar(50) NOT NULL default 'm/d/Y', + InputTimeFormat varchar(50) NOT NULL default 'g:i:s A', + DecimalPoint char(2) NOT NULL default '', + ThousandSep tinytext, + `Charset` varchar(20) NOT NULL default '', UnitSystem tinyint(4) NOT NULL default '1', PRIMARY KEY (LanguageId) ); @@ -125,7 +125,7 @@ LoadOrder tinyint(4) NOT NULL default '0', TemplatePath varchar(255) NOT NULL default '', RootCat int(11) NOT NULL default '0', - BuildDate double NOT NULL default '0', + BuildDate int(10) unsigned default NULL, PRIMARY KEY (Name) );