Index: branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql =================================================================== diff -u -r7829 -r7837 --- branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql (.../install_schema.sql) (revision 7829) +++ branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql (.../install_schema.sql) (revision 7837) @@ -117,16 +117,16 @@ ); CREATE TABLE Modules ( - Name varchar(255) NOT NULL default '', + `Name` varchar(255) NOT NULL default '', Path varchar(255) NOT NULL default '', Var varchar(10) NOT NULL default '', - Version varchar(10) NOT NULL default '', + Version varchar(10) NOT NULL default '0.0.0', Loaded tinyint(4) NOT NULL default '1', LoadOrder tinyint(4) NOT NULL default '0', TemplatePath varchar(255) NOT NULL default '', RootCat int(11) NOT NULL default '0', BuildDate int(10) unsigned default NULL, - PRIMARY KEY (Name) + PRIMARY KEY (`Name`) ); CREATE TABLE PersistantSessionData ( @@ -308,7 +308,7 @@ DestParentId int(11) default NULL, DestName varchar(255) NOT NULL default '', DestAbbr char(3) NOT NULL default '', - DestAbbr2 char(2) default '', + DestAbbr2 char(2) default NULL, PRIMARY KEY (DestId) ); @@ -397,7 +397,6 @@ CategoryId int(11) NOT NULL default '0', PermId int(11) NOT NULL default '0', ACL varchar(255) NOT NULL default '', - DACL varchar(255) NOT NULL default '', PRIMARY KEY (PermCacheId), KEY CategoryId (CategoryId), KEY PermId (PermId)