Index: trunk/admin/install/inportal_schema.sql =================================================================== diff -u -r1451 -r1566 --- trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 1451) +++ trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 1566) @@ -337,6 +337,9 @@ PhraseType int(11) NOT NULL default '0', PhraseId int(11) NOT NULL auto_increment, LanguageId int(11) NOT NULL default '0', + LastChanged int(10) unsigned NOT NULL default '0', + LastChangeIP varchar(15) NOT NULL default '', + Module varchar(30) NOT NULL default '', PRIMARY KEY (PhraseId), INDEX Phrase_Index (Phrase) ) @@ -348,6 +351,7 @@ PhraseList text NOT NULL, CacheDate int(11) NOT NULL default '0', ThemeId int(11) NOT NULL default '0', + StylesheetId int(10) unsigned NOT NULL default '0', PRIMARY KEY (Template) ) @@ -382,7 +386,7 @@ Phone varchar(20) default NULL, Street varchar(255) default NULL, City varchar(20) default NULL, - State varchar(20) default NULL, + State varchar(20) NOT NULL default '', Zip varchar(20) default NULL, Country varchar(20) NOT NULL default '', ResourceId int(11) NOT NULL default '0', @@ -616,4 +620,31 @@ is_requred_fields varchar(255) NOT NULL default '', is_enabled tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (is_id) +) + +# -------------------------------------------------------- + +CREATE TABLE StylesheetSelectors ( + SelectorId int(11) NOT NULL auto_increment, + StylesheetId int(11) NOT NULL default '0', + Name varchar(255) NOT NULL default '', + SelectorName varchar(255) NOT NULL default '', + SelectorData text NOT NULL, + Description text NOT NULL, + Type tinyint(4) NOT NULL default '0', + AdvancedCSS text NOT NULL, + ParentId int(11) NOT NULL default '0', + PRIMARY KEY (SelectorId) +) + +# -------------------------------------------------------- + +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) ) \ No newline at end of file