Index: trunk/core/install/install_schema.sql =================================================================== diff -u -N -r8057 -r8066 --- trunk/core/install/install_schema.sql (.../install_schema.sql) (revision 8057) +++ trunk/core/install/install_schema.sql (.../install_schema.sql) (revision 8066) @@ -420,3 +420,16 @@ PRIMARY KEY (PopupId), KEY TemplateName (TemplateName) ); + +CREATE TABLE Counters ( + CounterId int(10) unsigned NOT NULL auto_increment, + Name varchar(100) NOT NULL default '', + CountQuery text, + CountValue text, + LastCounted int(10) unsigned default NULL, + LifeTime int(10) unsigned NOT NULL default '3600', + IsClone tinyint(3) unsigned NOT NULL default '0', + TablesAffected text, + PRIMARY KEY (CounterId), + UNIQUE KEY Name (Name) +); Index: trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql =================================================================== diff -u -N -r8057 -r8066 --- trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql (.../inportal_upgrade_v4.0.2.sql) (revision 8057) +++ trunk/admin/install/upgrades/inportal_upgrade_v4.0.2.sql (.../inportal_upgrade_v4.0.2.sql) (revision 8066) @@ -34,4 +34,6 @@ UPDATE Phrase SET Translation = REPLACE(Translation, CHAR(146), "'"); +CREATE TABLE Counters (CounterId int(10) unsigned NOT NULL auto_increment,Name varchar(100) NOT NULL default '',CountQuery text,CountValue text,LastCounted int(10) unsigned default NULL,LifeTime int(10) unsigned NOT NULL default '3600',IsClone tinyint(3) unsigned NOT NULL default '0',TablesAffected text,PRIMARY KEY (CounterId),UNIQUE KEY Name (Name)); + UPDATE Modules SET Version = '4.0.2' WHERE Name = 'In-Portal'; \ No newline at end of file Index: trunk/core/install/upgrades.sql =================================================================== diff -u -N -r8057 -r8066 --- trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8057) +++ trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8066) @@ -72,3 +72,16 @@ CHANGE PortalUserId PortalUserId INT(11) NOT NULL DEFAULT '-2', CHANGE Language Language INT(11) NOT NULL DEFAULT '1', CHANGE Theme Theme INT(11) NOT NULL DEFAULT '1'; + +CREATE TABLE Counters ( + CounterId int(10) unsigned NOT NULL auto_increment, + Name varchar(100) NOT NULL default '', + CountQuery text, + CountValue text, + LastCounted int(10) unsigned default NULL, + LifeTime int(10) unsigned NOT NULL default '3600', + IsClone tinyint(3) unsigned NOT NULL default '0', + TablesAffected text, + PRIMARY KEY (CounterId), + UNIQUE KEY Name (Name) +);