Index: trunk/core/install/install_schema.sql =================================================================== diff -u -N -r8066 -r8092 --- trunk/core/install/install_schema.sql (.../install_schema.sql) (revision 8066) +++ trunk/core/install/install_schema.sql (.../install_schema.sql) (revision 8092) @@ -119,7 +119,7 @@ CREATE TABLE Modules ( `Name` varchar(255) NOT NULL default '', Path varchar(255) NOT NULL default '', - Var varchar(10) NOT NULL default '', + `Var` VARCHAR(100) NOT NULL DEFAULT '', Version varchar(10) NOT NULL default '0.0.0', Loaded tinyint(4) NOT NULL default '1', LoadOrder tinyint(4) NOT NULL default '0', Index: trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql =================================================================== diff -u -N -r8066 -r8092 --- trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql (.../inportal_upgrade_v4.0.2.sql) (revision 8066) +++ trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql (.../inportal_upgrade_v4.0.2.sql) (revision 8092) @@ -9,7 +9,7 @@ ALTER TABLE PortalUser CHANGE CreatedOn CreatedOn INT NOT NULL DEFAULT '0', CHANGE dob dob INT(11) NULL DEFAULT NULL, CHANGE PassResetTime PassResetTime INT(11) UNSIGNED NULL DEFAULT NULL, CHANGE PwRequestTime PwRequestTime INT(11) UNSIGNED NULL DEFAULT NULL, CHANGE `Password` `Password` VARCHAR(255) NULL DEFAULT 'd41d8cd98f00b204e9800998ecf8427e'; -ALTER TABLE Modules CHANGE BuildDate BuildDate INT UNSIGNED NULL DEFAULT NULL, CHANGE Version Version VARCHAR(10) NOT NULL DEFAULT '0.0.0'; +ALTER TABLE Modules CHANGE BuildDate BuildDate INT UNSIGNED NULL DEFAULT NULL, CHANGE Version Version VARCHAR(10) NOT NULL DEFAULT '0.0.0', CHANGE `Var` `Var` VARCHAR(100) NOT NULL DEFAULT ''; ALTER TABLE Language CHANGE Enabled Enabled INT(11) NOT NULL DEFAULT '1', CHANGE InputDateFormat InputDateFormat VARCHAR(50) NOT NULL DEFAULT 'm/d/Y', CHANGE InputTimeFormat InputTimeFormat VARCHAR(50) NOT NULL DEFAULT 'g:i:s A', CHANGE DecimalPoint DecimalPoint VARCHAR(10) NOT NULL DEFAULT '', CHANGE ThousandSep ThousandSep VARCHAR(10) NOT NULL DEFAULT ''; ALTER TABLE Events CHANGE FromUserId FromUserId INT(11) NOT NULL DEFAULT '-1'; Index: trunk/core/install/upgrades.sql =================================================================== diff -u -N -r8066 -r8092 --- trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8066) +++ trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8092) @@ -47,7 +47,8 @@ ALTER TABLE Modules CHANGE BuildDate BuildDate INT UNSIGNED NULL DEFAULT NULL, - CHANGE Version Version VARCHAR(10) NOT NULL DEFAULT '0.0.0'; + CHANGE Version Version VARCHAR(10) NOT NULL DEFAULT '0.0.0', + CHANGE `Var` `Var` VARCHAR(100) NOT NULL DEFAULT ''; ALTER TABLE Language CHANGE Enabled Enabled INT(11) NOT NULL DEFAULT '1',