Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -r1566 -r1588
--- trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 1566)
+++ trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 1588)
@@ -105,6 +105,7 @@
   ValueList varchar(255) default NULL,
   DisplayOrder int(11) NOT NULL default '0',
   OnGeneralTab tinyint(4) NOT NULL default '0',
+  Multilingual TINYINT(4) NOT NULL DEFAULT '0',
   PRIMARY KEY  (CustomFieldId),
   KEY Type (Type)
 )
@@ -341,6 +342,7 @@
   LastChangeIP varchar(15) NOT NULL default '',
   Module varchar(30) NOT NULL default '',
   PRIMARY KEY  (PhraseId),
+  KEY LanguageId (LanguageId),
   INDEX Phrase_Index (Phrase)
 )
 
@@ -386,7 +388,7 @@
   Phone varchar(20) default NULL,
   Street varchar(255) default NULL,
   City varchar(20) default NULL,
-  State varchar(20) NOT NULL default '',
+  State VARCHAR(20) NOT NULL,
   Zip varchar(20) default NULL,
   Country varchar(20) NOT NULL default '',
   ResourceId int(11) NOT NULL default '0',
@@ -437,8 +439,8 @@
   SearchConfigId int(11) NOT NULL auto_increment,
   Priority int(11) NOT NULL default '0',
   FieldType varchar(20) NOT NULL default 'text',
-  ForeignField varchar(255) default NULL,
-  JoinClause varchar(255) default NULL,
+  ForeignField TEXT,
+  JoinClause TEXT,
   IsWhere text,
   IsNotWhere text,
   ContainsWhere text,
@@ -500,6 +502,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',
   PRIMARY KEY  (ThemeId)
 )
 
@@ -568,9 +571,8 @@
   Context varchar(255) default NULL,
   GroupList varchar(255) NOT NULL default '',
   PRIMARY KEY  (SysCacheId),
-  KEY Name (Name),
-  KEY Expire (Expire)
-)    
+  KEY Name (Name)
+)
 
 # --------------------------------------------------------
 
@@ -624,6 +626,14 @@
 
 # --------------------------------------------------------
 
+CREATE TABLE Cache (
+  VarName varchar(255) NOT NULL default '',
+  Data longtext,
+  Cached int(11) default NULL,
+  PRIMARY KEY  (VarName),
+  KEY Cached (Cached)
+)
+# --------------------------------------------------------
 CREATE TABLE StylesheetSelectors (
   SelectorId int(11) NOT NULL auto_increment,
   StylesheetId int(11) NOT NULL default '0',
@@ -636,9 +646,7 @@
   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 '',
@@ -647,4 +655,5 @@
   LastCompiled int(10) unsigned NOT NULL default '0',
   Enabled int(11) NOT NULL default '0',
   PRIMARY KEY  (StylesheetId)
-)
\ No newline at end of file
+)
+# --------------------------------------------------------
\ No newline at end of file
