|
From: <pau...@us...> - 2006-04-26 16:25:34
|
Revision: 1827 Author: paulsohier Date: 2006-04-26 09:25:29 -0700 (Wed, 26 Apr 2006) ViewCVS: http://svn.sourceforge.net/rcts/?rev=1827&view=rev Log Message: ----------- Added pgsql schema(Don't know if it is working yet ;)). Small changes to mysql schema. Modified Paths: -------------- trunk/schemas/mysql/install.sql Modified: trunk/schemas/mysql/install.sql =================================================================== --- trunk/schemas/mysql/install.sql 2006-04-26 16:19:46 UTC (rev 1826) +++ trunk/schemas/mysql/install.sql 2006-04-26 16:25:29 UTC (rev 1827) @@ -1,5 +1,5 @@ # -# Really Coding Traffic Statistics +# Really Coding Traffic Statistics 2 # Begin: October, 3rd 2005 # install.sql # $Id: install.sql 1743 2006-04-19 14:24:55Z eroeling $ @@ -7,12 +7,12 @@ # USE ALWAYS AS PREFIX rcts !!! # After every query must be come a ; -CREATE TABLE `rcts_sessions` ( - `sid` varchar(32) NOT NULL default '', - `tijd` int(10) NOT NULL default '0', - `counted` int(1) NOT NULL default '0', - UNIQUE KEY `sid` (`sid`) -); +#CREATE TABLE `rcts_sessions` ( +# `sid` varchar(32) NOT NULL default '', +# `tijd` int(10) NOT NULL default '0', +# `counted` int(1) NOT NULL default '0', +# UNIQUE KEY `sid` (`sid`) +#); CREATE TABLE `rcts_indentifer` ( `id` int(10) NOT NULL auto_increment, `indentifer` varchar(255) NOT NULL default '', @@ -82,7 +82,7 @@ `id` int(10) NOT NULL auto_increment, `graph` varchar(255) NOT NULL default '', `tijd` int(10) NOT NULL default '0', - `idid` varchar(11) NOT NULL default '0', + `idid` int(20) NOT NULL default '0', `extra` longtext NOT NULL, PRIMARY KEY (`id`) ); @@ -139,7 +139,7 @@ stat_value varchar(255) NOT NULL default '', stat_count int(10) unsigned NOT NULL default '0', stat_type_id int(10) unsigned NOT NULL default '0', - idid int(10) unsigned NOT NULL default '0', + idid int(20) unsigned NOT NULL default '0', stat_timestamp int(10) unsigned NOT NULL default '0', stat_time_array longtext NOT NULL, PRIMARY KEY (stat_id) @@ -154,28 +154,3 @@ INSERT INTO `rcts_layout` (`id`, `name`, `content`, `order`) VALUES (1, 'stats_main', 'a:10:{i:1;s:11:"visitsToday";i:2;s:14:"last30daysDisp";i:3;s:11:"topBrowsers";i:4;s:9:"topColors";i:5;s:13:"topEntryPages";i:6;s:8:"topFlash";i:7;s:12:"topLanguages";i:8;s:5:"topOs";i:9;s:11:"topReferers";i:10;s:14:"topResolutions";}', '1.0'), (2, 'stats_time', 'a:7:{i:1;s:5:"Hours";i:2;s:5:"DaysW";i:3;s:5:"DaysM";i:4;s:9:"MonthDisp";i:5;s:13:"TimezonesDisp";i:6;s:8:"LoadTime";i:7;s:10:"OnlineTime";}', '2.0'), (3, 'stats_load', 'a:3:{i:1;s:8:"LoadTime";i:2;s:7:"Average";i:3;s:13:"AvarageOnline";}', '3.0'),(4, 'uniek', 'a:1:{i:0;s:9:"uniekDisp";}', '3.0'); -CREATE TABLE `rcts_module` ( - `module_id` int(10) NOT NULL auto_increment, - `module_name` varchar(255) NOT NULL, - `module_parent` int(10) NOT NULL, - `module_left` int(10) NOT NULL, - `module_right` int(10) NOT NULL, - `module_enabled` tinyint(1) NOT NULL, - `module_sort` varchar(50) NOT NULL, - `module_langname` varchar(255) NOT NULL, - `module_mode` varchar(255) NOT NULL, - PRIMARY KEY (`module_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; - - -INSERT INTO `rcts_module` (`module_id`, `module_name`, `module_parent`, `module_left`, `module_right`, `module_enabled`, `module_sort`, `module_langname`, `module_mode`) VALUES (1, '', 0, 1, 4, 1, 'acp', 'INFO', ''), -(2, 'info', 1, 2, 3, 1, 'acp', 'INFO', 'info'), -(3, '', 0, 5, 20, 1, 'acp', 'CONFIG', 'config'), -(4, 'config_general', 3, 6, 7, 1, 'acp', 'CONFIG_GENERAL', 'config'), -(6, 'layout', 3, 8, 9, 1, 'acp', 'LAYOUT', 'layout'), -(8, 'config_user', 3, 10, 11, 1, 'acp', 'CONFIG_USER', 'config_user'), -(9, 'ftp', 3, 12, 13, 1, 'acp', 'FTP', 'ftp'), -(10, 'smtp', 3, 14, 15, 1, 'acp', 'SMTP', 'smtp'), -(11, 'multisite', 3, 16, 17, 1, 'acp', 'MULTISITE', 'multi'), -(12, 'header', 3, 18, 19, 1, 'acp', 'HEADER', 'header'), -(14, 'tree', 0, 21, 22, 1, 'acp', 'TREE', 'tree'); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <pau...@us...> - 2006-05-16 15:22:59
|
Revision: 1842 Author: paulsohier Date: 2006-05-16 08:22:40 -0700 (Tue, 16 May 2006) ViewCVS: http://svn.sourceforge.net/rcts/?rev=1842&view=rev Log Message: ----------- Update for mysql schema. Modified Paths: -------------- trunk/schemas/mysql/install.sql Modified: trunk/schemas/mysql/install.sql =================================================================== --- trunk/schemas/mysql/install.sql 2006-05-16 14:45:49 UTC (rev 1841) +++ trunk/schemas/mysql/install.sql 2006-05-16 15:22:40 UTC (rev 1842) @@ -140,7 +140,7 @@ `id` bigint(21) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `content` longtext NOT NULL, - `order` decimal(10,1) NOT NULL, + `orderd` decimal(10,1) NOT NULL, PRIMARY KEY (`id`) ); INSERT INTO `rcts_layout` (`id`, `name`, `content`, `order`) VALUES (1, 'stats_main', 'a:10:{i:1;s:11:"visitsToday";i:2;s:14:"last30daysDisp";i:3;s:11:"topBrowsers";i:4;s:9:"topColors";i:5;s:13:"topEntryPages";i:6;s:8:"topFlash";i:7;s:12:"topLanguages";i:8;s:5:"topOs";i:9;s:11:"topReferers";i:10;s:14:"topResolutions";}', '1.0'), This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <bas...@us...> - 2006-09-08 11:39:34
|
Revision: 1939
http://svn.sourceforge.net/rcts/?rev=1939&view=rev
Author: bastimmer
Date: 2006-09-08 04:39:27 -0700 (Fri, 08 Sep 2006)
Log Message:
-----------
Erik forgot something... :P
Modified Paths:
--------------
trunk/schemas/mysql/install.sql
Modified: trunk/schemas/mysql/install.sql
===================================================================
--- trunk/schemas/mysql/install.sql 2006-09-08 11:34:52 UTC (rev 1938)
+++ trunk/schemas/mysql/install.sql 2006-09-08 11:39:27 UTC (rev 1939)
@@ -120,4 +120,14 @@
`email` VARCHAR( 255 ) NOT NULL ,
`is_admin` INT( 1 ) NOT NULL DEFAULT '0',
`lastlogin` VARCHAR( 255 ) NOT NULL
+);
+
+CREATE TABLE `rcts_sessions` (
+ `sessionid` text NOT NULL,
+ `uid` int(15) NOT NULL default '0',
+ `ip` varchar(255) NOT NULL,
+ `starttime` varchar(255) NOT NULL,
+ `lastaction` varchar(255) NOT NULL,
+ `rememberme` int(1) NOT NULL default '0',
+ `vars` text NOT NULL
);
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <bas...@us...> - 2006-09-15 07:41:58
|
Revision: 1971
http://svn.sourceforge.net/rcts/?rev=1971&view=rev
Author: bastimmer
Date: 2006-09-15 00:41:51 -0700 (Fri, 15 Sep 2006)
Log Message:
-----------
Just some preparations. :)
Modified Paths:
--------------
trunk/schemas/mysql/install.sql
Modified: trunk/schemas/mysql/install.sql
===================================================================
--- trunk/schemas/mysql/install.sql 2006-09-14 10:15:37 UTC (rev 1970)
+++ trunk/schemas/mysql/install.sql 2006-09-15 07:41:51 UTC (rev 1971)
@@ -85,7 +85,7 @@
CREATE TABLE rcts_calendar (
stat_id int(10) unsigned NOT NULL auto_increment,
stat_type varchar(255) NOT NULL default '',
- stat_value varchar(255) NOT NULL default '',
+ stat_value text NOT NULL default '',
stat_count int(10) unsigned NOT NULL default '0',
stat_type_id int(10) unsigned NOT NULL default '0',
idid int(20) unsigned NOT NULL default '0',
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <bas...@us...> - 2006-09-15 10:40:18
|
Revision: 1974
http://svn.sourceforge.net/rcts/?rev=1974&view=rev
Author: bastimmer
Date: 2006-09-15 03:40:10 -0700 (Fri, 15 Sep 2006)
Log Message:
-----------
Jippee, even more tables... :P
Modified Paths:
--------------
trunk/schemas/mysql/install.sql
Modified: trunk/schemas/mysql/install.sql
===================================================================
--- trunk/schemas/mysql/install.sql 2006-09-15 08:00:42 UTC (rev 1973)
+++ trunk/schemas/mysql/install.sql 2006-09-15 10:40:10 UTC (rev 1974)
@@ -130,4 +130,13 @@
`lastaction` varchar(255) NOT NULL,
`rememberme` int(1) NOT NULL default '0',
`vars` text NOT NULL
+);
+
+CREATE TABLE `rcts_visitor_pages` (
+ `page_id` int(11) NOT NULL auto_increment,
+ `idid` int(11) NOT NULL,
+ `page_ip` varchar(255) NOT NULL,
+ `page_urls` text NOT NULL,
+ `page_date` int(11) NOT NULL,
+ PRIMARY KEY (`page_id`)
);
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
