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) +); Index: trunk/core/install/install_data.sql =================================================================== diff -u -N -r6729 -r7403 --- trunk/core/install/install_data.sql (.../install_data.sql) (revision 6729) +++ trunk/core/install/install_data.sql (.../install_data.sql) (revision 7403) @@ -113,7 +113,7 @@ INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Web_Address', '', 'In-Portal', 'in-portal:configure_general'); INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Server_Time', '14', 'In-Portal', 'in-portal:configure_general'); INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Site_Time', '14', 'In-Portal', 'in-portal:configure_general'); -INSERT INTO ConfigurationValues VALUES (NULL, 'Site_Name', 'In-Portal', 'Kernel.X Project', 'in-portal:configure_general'); +INSERT INTO ConfigurationValues VALUES (NULL, 'Site_Name', 'In-Portal', 'In-Portal', 'in-portal:configure_general'); INSERT INTO ConfigurationValues VALUES (NULL, 'Backup_Path', '', 'In-Portal', 'in-portal:configure_general'); INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Items', '20', 'In-Portal', ''); INSERT INTO ConfigurationValues VALUES (NULL, 'GuestSessions', '1', 'In-Portal', ''); @@ -548,4 +548,29 @@ INSERT INTO StdDestinations VALUES (307, 2, 225, 'la_state_AK', 'AK', NULL); INSERT INTO StdDestinations VALUES (306, 2, 225, 'la_state_AL', 'AL', NULL); +INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.VIEW', 'lu_PermName_Category.View_desc', 'lu_PermName_Category.View_error', 'In-Portal'); INSERT INTO PermCache (CategoryId, PermId, ACL) VALUES (0, 1, '11,12,13,14,15'); + +INSERT INTO Permissions VALUES (0, 'LOGIN', 13, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'LOGIN', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'ADMIN', 11, 1, 1, 0); + +INSERT INTO Permissions VALUES (0, 'in-portal:root.view', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'in-portal:system.view', 11, 1, 1, 0); + +INSERT INTO Permissions VALUES (0, 'in-portal:user_list.view', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'in-portal:user_list.add', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'in-portal:user_list.edit', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'in-portal:user_list.delete', 11, 1, 1, 0); + +INSERT INTO Permissions VALUES (0, 'in-portal:configure_lang.view', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'in-portal:configure_lang.add', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'in-portal:configure_lang.edit', 11, 1, 1, 0); +INSERT INTO Permissions VALUES (0, 'in-portal:configure_lang.delete', 11, 1, 1, 0); + +INSERT INTO Permissions VALUES (0, 'CATEGORY.VIEW', 11, 1, 0, 0); +INSERT INTO Permissions VALUES (0, 'CATEGORY.ADD', 11, 1, 0, 0); +INSERT INTO Permissions VALUES (0, 'CATEGORY.DELETE', 11, 1, 0, 0); +INSERT INTO Permissions VALUES (0, 'CATEGORY.MODIFY', 11, 1, 0, 0); + +INSERT INTO Permissions VALUES (0, 'in-portal:service.view', 11, 1, 1, 0);