Index: branches/5.0.x/core/install/install_schema.sql
===================================================================
diff -u -N -r12703 -r12808
--- branches/5.0.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 12703)
+++ branches/5.0.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 12808)
@@ -277,33 +277,38 @@
 );
 
 CREATE TABLE Theme (
-  ThemeId int(11) NOT NULL auto_increment,
-  Name varchar(40) NOT NULL default '',
-  Enabled int(11) NOT NULL default '1',
-  Description varchar(255) default NULL,
-  PrimaryTheme int(11) NOT NULL default '0',
-  CacheTimeout int(11) NOT NULL default '0',
-  StylesheetId int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY  (ThemeId),
+  ThemeId int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(40) NOT NULL DEFAULT '',
+  Enabled int(11) NOT NULL DEFAULT '1',
+  Description varchar(255) DEFAULT NULL,
+  PrimaryTheme int(11) NOT NULL DEFAULT '0',
+  CacheTimeout int(11) NOT NULL DEFAULT '0',
+  StylesheetId int(10) unsigned NOT NULL DEFAULT '0',
+  LanguagePackInstalled tinyint(3) unsigned NOT NULL DEFAULT '0',
+  TemplateAliases text,
+  PRIMARY KEY (ThemeId),
   KEY Enabled (Enabled),
   KEY StylesheetId (StylesheetId),
-  KEY PrimaryTheme (PrimaryTheme)
+  KEY PrimaryTheme (PrimaryTheme),
+  KEY LanguagePackInstalled (LanguagePackInstalled)
 );
 
 CREATE TABLE ThemeFiles (
-  FileId int(11) NOT NULL auto_increment,
-  ThemeId int(11) NOT NULL default '0',
-  FileName varchar(255) NOT NULL default '',
-  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',
+  FileId int(11) NOT NULL AUTO_INCREMENT,
+  ThemeId int(11) NOT NULL DEFAULT '0',
+  FileName varchar(255) NOT NULL DEFAULT '',
+  FilePath varchar(255) NOT NULL DEFAULT '',
+  TemplateAlias 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',
   FileMetaInfo text,
-  PRIMARY KEY  (FileId),
+  PRIMARY KEY (FileId),
   KEY theme (ThemeId),
   KEY FileName (FileName),
   KEY FilePath (FilePath),
-  KEY FileFound (FileFound)
+  KEY FileFound (FileFound),
+  KEY TemplateAlias (TemplateAlias)
 );
 
 CREATE TABLE UserGroup (