Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.2.sql =================================================================== diff -u --- trunk/admin/install/upgrades/inportal_upgrade_v1.1.2.sql (revision 0) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.2.sql (revision 2414) @@ -0,0 +1,3 @@ +CREATE TABLE Visits (VisitId int(11) NOT NULL auto_increment, VisitDate int(10) unsigned NOT NULL default '0', Referer varchar(255) NOT NULL default '', IPAddress varchar(15) NOT NULL default '', AffiliateId int(10) unsigned NOT NULL default '0', PortalUserId int(11) NOT NULL default '0', PRIMARY KEY (VisitId) ); + +UPDATE Modules SET Version = '1.1.2' WHERE Name = 'In-Portal'; \ No newline at end of file Index: trunk/admin/install/inportal_schema.sql =================================================================== diff -u -r2261 -r2414 --- trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 2261) +++ trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 2414) @@ -675,4 +675,14 @@ DestAbbr2 char(2) default '', PRIMARY KEY (DestId) ) +# -------------------------------------------------------- +CREATE TABLE Visits ( + VisitId int(11) NOT NULL auto_increment, + VisitDate int(10) unsigned NOT NULL default '0', + Referer varchar(255) NOT NULL default '', + IPAddress varchar(15) NOT NULL default '', + AffiliateId int(10) unsigned NOT NULL default '0', + PortalUserId int(11) NOT NULL default '0', + PRIMARY KEY (VisitId) +) # -------------------------------------------------------- \ No newline at end of file Index: trunk/admin/install/inportal_data.sql =================================================================== diff -u -r2263 -r2414 --- trunk/admin/install/inportal_data.sql (.../inportal_data.sql) (revision 2263) +++ trunk/admin/install/inportal_data.sql (.../inportal_data.sql) (revision 2414) @@ -201,7 +201,7 @@ INSERT INTO ItemTypes VALUES (1, 'In-Portal', 'Category', 'Name', 'CreatedById', NULL, NULL, 'la_ItemTab_Categories', 1, 'admin/category/addcategory.php', 'clsCategory', 'Category'); INSERT INTO ItemTypes VALUES (6, 'In-Portal', 'PortalUser', 'Login', 'PortalUserId', NULL, NULL, '', 0, '', 'clsPortalUser', 'User'); -INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('In-Portal', 'kernel/', 'm', '1.1.1', 1, 0, '', 0, '1054738405'); +INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('In-Portal', 'kernel/', 'm', '1.1.2', 1, 0, '', 0, '1054738405'); INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.VIEW', 'lu_PermName_Category.View_desc', 'lu_PermName_Category.View_error', 'In-Portal'); INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.ADD', 'lu_PermName_Category.Add_desc', 'lu_PermName_Category.Add_error', 'In-Portal');