Index: trunk/core/install/install_schema.sql =================================================================== diff -u -N -r6729 -r7403 --- trunk/core/install/install_schema.sql (.../install_schema.sql) (revision 6729) +++ trunk/core/install/install_schema.sql (.../install_schema.sql) (revision 7403) @@ -1,3 +1,40 @@ +CREATE TABLE PermissionConfig ( + PermissionConfigId int(11) NOT NULL auto_increment, + PermissionName varchar(30) NOT NULL default '', + Description varchar(255) NOT NULL default '', + ErrorMessage varchar(255) NOT NULL default '', + ModuleId varchar(20) NOT NULL default '0', + PRIMARY KEY (PermissionConfigId), + KEY PermissionName (PermissionName) +); + +CREATE TABLE Permissions ( + PermissionId int(11) NOT NULL auto_increment, + Permission varchar(255) NOT NULL default '', + GroupId int(11) default '0', + PermissionValue int(11) NOT NULL default '0', + `Type` tinyint(4) NOT NULL default '0', + CatId int(11) NOT NULL default '0', + PRIMARY KEY (PermissionId), + UNIQUE KEY PermIndex (Permission,GroupId,CatId,`Type`) +); + +CREATE TABLE CustomField ( + CustomFieldId int(11) NOT NULL auto_increment, + Type int(11) NOT NULL default '0', + FieldName varchar(255) NOT NULL default '', + FieldLabel varchar(40) default NULL, + Heading varchar(60) default NULL, + Prompt varchar(60) default NULL, + ElementType varchar(50) NOT NULL default '', + ValueList varchar(255) default NULL, + 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) +); + CREATE TABLE ConfigurationAdmin ( VariableName varchar(80) NOT NULL default '', heading varchar(255) default NULL, @@ -27,6 +64,7 @@ MessageType enum('html','text') NOT NULL default 'text', LanguageId int(11) NOT NULL default '0', EventId int(11) NOT NULL default '0', + Subject text, PRIMARY KEY (EmailMessageId) ); @@ -196,7 +234,7 @@ Description varchar(255) default NULL, PrimaryTheme int(11) NOT NULL default '0', CacheTimeout int(11) NOT NULL default '0', - StylesheetId INTEGER(10) UNSIGNED NOT NULL DEFAULT '0', + StylesheetId int(10) unsigned NOT NULL default '0', PRIMARY KEY (ThemeId) ); @@ -207,10 +245,12 @@ FilePath varchar(255) NOT NULL default '', Description varchar(255) default NULL, FileType int(11) NOT NULL default '0', + FileFound tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (FileId), KEY theme (ThemeId), KEY FileName (FileName), - KEY FilePath (FilePath) + KEY FilePath (FilePath), + KEY FileFound (FileFound) ); CREATE TABLE UserGroup ( @@ -333,6 +373,13 @@ KEY l5_Description (l5_Description(5)) ); +CREATE TABLE CategoryCustomData ( + CustomDataId int(11) NOT NULL auto_increment, + ResourceId int(10) unsigned NOT NULL default '0', + KEY ResourceId (ResourceId), + PRIMARY KEY (CustomDataId) +); + CREATE TABLE CategoryItems ( `CategoryId` int(11) NOT NULL default '0', `ItemResourceId` int(11) NOT NULL default '0', @@ -356,4 +403,21 @@ KEY PermId (PermId) ); +CREATE TABLE Stylesheets ( + StylesheetId int(11) NOT NULL auto_increment, + Name varchar(255) NOT NULL default '', + Description varchar(255) NOT NULL default '', + AdvancedCSS text NOT NULL, + LastCompiled int(10) unsigned NOT NULL default '0', + Enabled int(11) NOT NULL default '0', + PRIMARY KEY (StylesheetId) +); +CREATE TABLE PopupSizes ( + PopupId int(10) unsigned NOT NULL auto_increment, + TemplateName varchar(255) NOT NULL default '', + PopupWidth int(11) NOT NULL default '0', + PopupHeight int(11) NOT NULL default '0', + PRIMARY KEY (PopupId), + KEY TemplateName (TemplateName) +);