MyDynaWeb CVS: sql sukria

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

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : sql

Dir     : mydynaweb/sql


Modified Files:
	MYSQL_create.sql SQL_fill.sql 


Log Message:
** The Road to 0.3.6 **
***********************

First updates of the SQL files.
The goal is to merge each of the sql content of db_upgrades/from_0.3.5_to_0.3.6 in 
MYSQL_create.sql and SQL_fill.sql

To do : 
	- add the create_users.sql file
	- update Postgres file
	- make the perl updater that can do the upgrade automatically



===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -3 -r1.11 -r1.12
--- MYSQL_create.sql	2001/07/13 09:53:03	1.11
+++ MYSQL_create.sql	2001/11/27 13:11:14	1.12
@@ -107,6 +107,7 @@
   content text DEFAULT '' NOT NULL,
   _num_news int(11) DEFAULT '0' NOT NULL,
   user_name varchar(15) DEFAULT 'sukria',
+  user_mail varchar(100) not null default '',
   PRIMARY KEY (num_cmt)
 );
 
@@ -179,11 +180,46 @@
 	primary key(num_topic)
 );
 
-CREATE TABLE counter (
-	num_counter tinyint not null auto_increment,
-	nbvisites int not null default 0,
-	nom varchar(20),
-	PRIMARY KEY(num_counter)
+
+CREATE TABLE REFERERS (
+	REF_ID int not null auto_increment,
+	REF_URL varchar(255) not null default '',
+	PRIMARY KEY(REF_ID)
+);
+
+CREATE TABLE REF_DAY (
+	REF_ID int not null default 0,
+	DAY date not null default '0000-00-00',
+	NB int not null default 0,
+	PRIMARY KEY(REF_ID, DAY)
+);
+
+
+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)
+);
+
+CREATE TABLE calendar_messages (
+  id int(11) NOT NULL auto_increment,
+  date date NOT NULL default '0000-00-00',
+  title tinytext NOT NULL,
+  text text NOT NULL,
+  msg_poster_id int(11) NOT NULL default '0',
+  ocurence tinytext,
+  active int(1) NOT NULL default '0',
+  PRIMARY KEY (id)
+);
+
+CREATE TABLE dyna_settings (
+  varname varchar(125) NOT NULL default '',
+  varvalue varchar(255) default '',
+  PRIMARY KEY (varname)
 );
 
 
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/SQL_fill.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -3 -r1.11 -r1.12
--- SQL_fill.sql	2001/08/02 22:22:55	1.11
+++ SQL_fill.sql	2001/11/27 13:11:14	1.12
@@ -1,3 +1,27 @@
+INSERT INTO dyna_settings VALUES ('SITE_ROOT','http://localhost/');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_EMAIL','you@localhost');
+INSERT INTO dyna_settings VALUES ('HEADLINES','local,mydynaweb,slashdot');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_HOMEPAGE','http://www.your.site/');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_NAME','Your Name');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_LOGIN','Gandalf');
+INSERT INTO dyna_settings VALUES ('DYNACACHE','no');
+INSERT INTO dyna_settings VALUES ('CACHE_DELAY','1000');
+INSERT INTO dyna_settings VALUES ('TOP_BAR_IN_OTHER_LANG','1');
+INSERT INTO dyna_settings VALUES ('TOP_BAR_DEFAULT','1');
+INSERT INTO dyna_settings VALUES ('TOP_BAR_MYDYNAWEB','1');
+INSERT INTO dyna_settings VALUES ('CP_TIME','1');
+INSERT INTO dyna_settings VALUES ('CP_LANG','1');
+INSERT INTO dyna_settings VALUES ('CP_SEEK','1');
+INSERT INTO dyna_settings VALUES ('CP_DATE','1');
+INSERT INTO dyna_settings VALUES ('CP_LOGIN','1');
+INSERT INTO dyna_settings VALUES ('DEFAULT_FAMILY','1');
+INSERT INTO dyna_settings VALUES ('DEFAULT_LANG','EN');
+INSERT INTO dyna_settings VALUES ('SITE_TITLE','yoursite.net');
+INSERT INTO dyna_settings VALUES ('THEMES_BEHAVIOR','CHOOSE');
+INSERT INTO dyna_settings VALUES ('THEME_LIST','smarty,default,basic,enlightened,gnome,dynadot');
+INSERT INTO dyna_settings VALUES ('THEME_PATH','/smarty');
+INSERT INTO dyna_settings VALUES ('THEME_ROOT','/templates');
+
 insert into languages (id_lang, name, flag) values ('EN', 'English', 'images/flags/en.gif');
 insert into languages (id_lang, name, flag) values ('FR', 'Français', 'images/flags/fr.gif');
 insert into languages (id_lang, name, flag) values ('DE', 'Deutsch', 'images/flags/de.gif');