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 **
***********************

Some SQL updates...

we are near the 0.3.6 release... 

TO DO to publish the release :
- the stats viewer
- testing an install from scratch
- testing an upgrade from 0.3.5
- translate the remaining untranslated stuff
- destroy the nugs you find ;)



===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -3 -r1.12 -r1.13
--- MYSQL_create.sql	2001/11/27 13:11:14	1.12
+++ MYSQL_create.sql	2001/11/27 22:42:58	1.13
@@ -180,6 +180,18 @@
 	primary key(num_topic)
 );
 
+CREATE TABLE USERS (
+	USER_ID int not null auto_increment,
+	USER_COOKIE varchar(255) not null default '',
+	PRIMARY KEY(USER_ID)
+);
+
+CREATE TABLE USERS_DAY (
+	USER_ID int not null default 0,
+	DAY date not null default '0000-00-00',
+	NB int not null default 0,
+	PRIMARY KEY(USER_ID, DAY)
+);
 
 CREATE TABLE REFERERS (
 	REF_ID int not null auto_increment,
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/SQL_fill.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -3 -r1.12 -r1.13
--- SQL_fill.sql	2001/11/27 13:11:14	1.12
+++ SQL_fill.sql	2001/11/27 22:42:58	1.13
@@ -49,16 +49,28 @@
 insert into topic (titre, icone, lang_id) values ('Code Stuff', 'images/topics/programming.gif','EN');
 
 insert into news (titre, date, texte, _num_topic, lang, user_name) 
-          values ('Congratulations !', '2001-08-02', 'You have successfully installed MyDynaWeb.<br> 
+          values ('Félicitations !', '2001-11-27', 'Vous avez installé MyDynaWeb avec succès ! <br> Toute l''équipe de MyDynaWeb vous remercie de lui faire confiance et épsère vous voire très bientôt sur <a href="http://mydynaweb.sf.net">mydynaweb.sourceforge.net</a> :)', 1, 'FR', 'DynaCrew');
+
+insert into news (titre, date, texte, _num_topic, lang, user_name) 
+          values ('Congratulations !', '2001-11-27', 'You have successfully installed MyDynaWeb.<br> 
                    If you can see this piece of news, it means that your installation process has been successfull. <br>
-                   Don''t forget to check the <a href="http://mydynaweb.sf.net">mydynaweb site</a> for fresh news :)', 1, 'EN', 'MyDynaWeb');
+                   Don''t forget to check the <a href="http://mydynaweb.sf.net">mydynaweb site</a> for fresh news :)', 1, 'EN', 'DynaCrew');
 
 insert into item_box_titles values (1, 'News', 'images/news.jpg', 'EN');
-insert into item_box_content values (1, 'Fresh News', 'news.php3', '_self', 1);
-insert into item_box_content values (2, 'Old News', 'news.php3?old=yes', '_self', 1);
-insert into item_box_content values (3, 'Topics', 'show_da_topics.php3', '_self', 1);
+insert into item_box_content values (1, 'Fresh News', 'news.php', '_self', 1);
+insert into item_box_content values (2, 'Old News', 'news.php?old=yes', '_self', 1);
+insert into item_box_content values (3, 'Topics', 'topics.php', '_self', 1);
 
 insert into item_box_titles values (2, 'Overview', 'images/overview.jpg', 'EN');
 insert into item_box_content values (4, 'Stats', 'show_stats.php', '_self', 2);
-insert into item_box_content values (5, 'Search', 'seek.php3', '_self', 2);
+insert into item_box_content values (5, 'Search', 'seek.php', '_self', 2);
+
+insert into item_box_titles values (3, 'Accueil', 'images/news.jpg', 'FR');
+insert into item_box_content values (6, 'Nouvelles', 'news.php', '_self', 3);
+insert into item_box_content values (7, 'Vieilleries', 'news.php?old=yes', '_self', 3);
+insert into item_box_content values (8, 'Rubriques', 'topics.php', '_self', 3);
+
+insert into item_box_titles values (4, 'Survol', 'images/overview.jpg', 'FR');
+insert into item_box_content values (9, 'Stats', 'show_stats.php', '_self', 4);
+insert into item_box_content values (10, 'Recherche', 'seek.php', '_self', 4);