|
From: mdw c. <myd...@li...> - 2001-12-06 16:35:16
|
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-stats.sql Log Message: removing the unsigned flag of int fields =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-stats.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -3 -r1.2 -r1.3 --- create-stats.sql 2001/11/26 22:57:47 1.2 +++ create-stats.sql 2001/12/06 16:35:15 1.3 @@ -1,10 +1,9 @@ - CREATE TABLE STATS ( - 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, - REFERER VARCHAR(255) not null default '', - PRIMARY KEY (DAY) +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) ); |