MyDynaWeb CVS: sql sukria

[mdw c. <myd...@li...>]

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : sql

Dir     : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6


Modified Files:
	create-referer.sql create-stats.sql create-users.sql 


Log Message:
Adding the thread concept in the comments
we are close to forum aren't we ? ;-)



===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-referer.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -3 -r1.7 -r1.8
--- create-referer.sql	13 Dec 2001 23:08:20 -0000	1.7
+++ create-referer.sql	19 Feb 2002 18:37:32 -0000	1.8
@@ -1,3 +1,4 @@
+DROP TABLE REFERRERS;
 
 CREATE TABLE REFERRERS (
 	REF_ID int not null auto_increment,
@@ -5,6 +6,7 @@
 	PRIMARY KEY(REF_ID)
 );
 
+DROP TABLE REF_DAY;
 CREATE TABLE REF_DAY (
 	REF_ID int not null default 0,
 	DAY date not null,
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-stats.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -3 -r1.3 -r1.4
--- create-stats.sql	6 Dec 2001 16:35:15 -0000	1.3
+++ create-stats.sql	19 Feb 2002 18:37:32 -0000	1.4
@@ -1,9 +1,8 @@
 CREATE TABLE STATS
 (
-DAY date not null ,
-PAGEVIEWS int not null default 0,
-VISITS int not null default 0,
-PEOPLE int not null default 0,
-REFERER VARCHAR(255) not null default '',
-PRIMARY KEY (DAY)
+	DAY date not null ,
+	PAGEVIEWS int unsigned not null default 0,
+	VISITS int unsigned not null default 0,
+	PEOPLE int unsigned not null default 0,
+	PRIMARY KEY (DAY)
 );
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-users.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -3 -r1.1 -r1.2
--- create-users.sql	27 Nov 2001 22:01:44 -0000	1.1
+++ create-users.sql	19 Feb 2002 18:37:32 -0000	1.2
@@ -1,10 +1,11 @@
-
+DROP TABLE USERS;
 CREATE TABLE USERS (
 	USER_ID int not null auto_increment,
 	USER_COOKIE varchar(255) not null default '',
 	PRIMARY KEY(USER_ID)
 );
 
+DROP TABLE USERS_DAY;
 CREATE TABLE USERS_DAY (
 	USER_ID int not null default 0,
 	DAY date not null default '0000-00-00',