mydynaweb-cvs-commits

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 


Log Message:
quelques traductions en plus
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -3 -r1.14 -r1.15
--- MYSQL_create.sql	5 Mar 2002 09:16:00 -0000	1.14
+++ MYSQL_create.sql	28 Feb 2003 13:37:57 -0000	1.15
@@ -33,6 +33,7 @@
   prenom varchar(50),
   email varchar(255),
   photo varchar(150) default NULL,
+  last_login date,
   PRIMARY KEY (name)
 );
 

MyDynaWeb CVS: sql sukria

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

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : sql

Dir     : mydynaweb/sql/upgrades


Modified Files:
	core_text.sql 


Log Message:
on ne parle plus de 'nouvelles' mais d'articles désormais
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/upgrades/core_text.sql,v
retrieving revision 1.45
retrieving revision 1.46
diff -u -3 -r1.45 -r1.46
--- core_text.sql	28 Feb 2003 13:37:57 -0000	1.45
+++ core_text.sql	28 Feb 2003 13:48:27 -0000	1.46
@@ -45,12 +45,12 @@
 INSERT INTO core_text VALUES ('YOU_CAN_LOGIN_HERE', 'DE', 'If you want to become a member, you have to <a href=''new_account.php''>create an account</a><p> If are a registrated member, you can login here.'); 
 
 INSERT INTO core_text VALUES ('NO_NEWS', 'EN', 'Sorry, no news here !'); 
-INSERT INTO core_text VALUES ('NO_NEWS', 'FR', 'Désolé mais il n''y a plus de  nouvelles !'); 
+INSERT INTO core_text VALUES ('NO_NEWS', 'FR', 'Désolé mais il n''y a plus d''articles !'); 
 INSERT INTO core_text VALUES ('NO_NEWS', 'ES', 'Sorry, no news here !'); 
 INSERT INTO core_text VALUES ('NO_NEWS', 'DE', 'Sorry, no news here !'); 
 
 INSERT INTO core_text VALUES ('TOPNEWS', 'EN', 'News Podium'); 
-INSERT INTO core_text VALUES ('TOPNEWS', 'FR', 'Top des nouvelles'); 
+INSERT INTO core_text VALUES ('TOPNEWS', 'FR', 'Top des articles'); 
 INSERT INTO core_text VALUES ('TOPNEWS', 'ES', 'News Podium'); 
 INSERT INTO core_text VALUES ('TOPNEWS', 'DE', 'News Podium'); 
 
@@ -75,7 +75,7 @@
 INSERT INTO core_text VALUES ('REACT', 'DE', 'Reply to this comment'); 
 
 INSERT INTO core_text VALUES ('NEW_THREAD', 'EN', 'Comment this piece of news'); 
-INSERT INTO core_text VALUES ('NEW_THREAD', 'FR', 'Commenter cette nouvelle'); 
+INSERT INTO core_text VALUES ('NEW_THREAD', 'FR', 'Commenter cet article'); 
 INSERT INTO core_text VALUES ('NEW_THREAD', 'ES', 'Start a new thread'); 
 INSERT INTO core_text VALUES ('NEW_THREAD', 'DE', 'Start a new thread'); 
 
@@ -108,13 +108,13 @@
 You''ve recently post a comment about the piece of news entitled :
 ');
 INSERT INTO core_text VALUES ('NEW_COMMENT_MAIL1', 'FR', 'Bonjour, 
-Vous avez récemment posté un commentaire par rapport à la nouvelle intitulée :
+Vous avez récemment posté un commentaire par rapport à l''article intitulée :
 ');
 INSERT INTO core_text VALUES ('NEW_COMMENT_MAIL1', 'DE', 'Bonjour, 
-Vous avez récemment posté un commentaire par rapport à la nouvelle intitulée :
+Vous avez récemment posté un commentaire par rapport à l''article intitulée :
 ');
 INSERT INTO core_text VALUES ('NEW_COMMENT_MAIL1', 'ES', 'Bonjour, 
-Vous avez récemment posté un commentaire par rapport à la nouvelle intitulée :
+Vous avez récemment posté un commentaire par rapport à la article intitulée :
 ');
 
 
@@ -134,7 +134,7 @@
 INSERT INTO core_text VALUES ('FAMOUS_NEWS', 'DE', 'Most famous news items');
 
 INSERT INTO core_text VALUES ('BEST_NEWS', 'EN', 'Best news of the month');
-INSERT INTO core_text VALUES ('BEST_NEWS', 'FR', 'Meilleures nouvelles du mois');
+INSERT INTO core_text VALUES ('BEST_NEWS', 'FR', 'Meilleurs articles du mois');
 INSERT INTO core_text VALUES ('BEST_NEWS', 'ES', 'Most read news item');
 INSERT INTO core_text VALUES ('BEST_NEWS', 'DE', 'Most read news item');
 
@@ -169,17 +169,17 @@
 INSERT INTO core_text VALUES ('DERNIER_COMMENTAIRE', 'ES', 'Last comment');
 
 INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'EN', 'Last piece of news');
-INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'FR', 'Dernière nouvelle');
-INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'DE', 'Dernière nouvelle');
-INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'ES', 'Dernière nouvelle');
+INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'FR', 'Dernier article');
+INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'DE', 'Dernier article');
+INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'ES', 'Dernier article');
 
 INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'EN', 'Here are the last 5 news sorted by categories.');
-INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'FR', 'Voici les 5 dernière nouvelles pour chaque catégorie.');
-INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'DE', 'Voici les 5 dernière nouvelles pour chaque catégorie.');
-INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'ES', 'Voici les 5 dernière nouvelles pour chaque catégorie.');
+INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'FR', 'Voici les 5 derniers articles pour chaque catégorie.');
+INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'DE', 'Voici les 5 derniers articles pour chaque catégorie.');
+INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'ES', 'Voici les 5 derniers articles pour chaque catégorie.');
 
 INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'EN', 'News Contents');
-INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'FR', 'Sommaire des nouvelles');
+INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'FR', 'Sommaire des articles');
 INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'DE', 'News Contents');
 INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'ES', 'News Contents');
 
@@ -242,7 +242,7 @@
 INSERT INTO core_text VALUES ('SEARCH_RESULTS', 'ES', 'Search Results');
 
 INSERT INTO core_text VALUES ('NO_NEWS_MATCH_YOUR_CRITERIA', 'EN', 'There are no news in the database that match your criteria.');
-INSERT INTO core_text VALUES ('NO_NEWS_MATCH_YOUR_CRITERIA', 'FR', 'Il n''y a aucune nouvelle qui correspond à votre demande.');
+INSERT INTO core_text VALUES ('NO_NEWS_MATCH_YOUR_CRITERIA', 'FR', 'Il n''y a aucun article qui correspond à votre demande.');
 INSERT INTO core_text VALUES ('NO_NEWS_MATCH_YOUR_CRITERIA', 'ES', 'There are no news in the database that match your criteria.');
 INSERT INTO core_text VALUES ('NO_NEWS_MATCH_YOUR_CRITERIA', 'DE', 'There are no news in the database that match your criteria.');
 
@@ -252,17 +252,17 @@
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_THE_KEYWORD', 'ES', 'we looked for the keyword : ');
 
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_POSTED_BY', 'EN', 'I''ve looked for news posted by : ');
-INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_POSTED_BY', 'FR', 'J''ai recherché des nouvelles dont l''auteur est : ');
+INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_POSTED_BY', 'FR', 'J''ai recherché des articles dont l''auteur est : ');
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_POSTED_BY', 'DE', 'whose author is : ');
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_POSTED_BY', 'ES', 'whose author is : ');
 
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_CATEGORY', 'EN', 'I''ve looked for news whose category is : ');
-INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_CATEGORY', 'FR', 'J''ai recherché des nouvelles dont la categorie est : ');
+INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_CATEGORY', 'FR', 'J''ai recherché des articles dont la categorie est : ');
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_CATEGORY', 'ES', 'whose category is : ');
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_CATEGORY', 'DE', 'whose category is : ');
 
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_TOPIC', 'EN', 'I''ve looked for news whose topic is : ');
-INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_TOPIC', 'FR', 'J''ai recherché des nouvelles dont la rubrique est : ');
+INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_TOPIC', 'FR', 'J''ai recherché des articles dont la rubrique est : ');
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_TOPIC', 'DE', 'whose topic is : ');
 INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_BOUND_TO_TOPIC', 'ES', 'whose topic is : ');
 
@@ -328,7 +328,7 @@
 
 
 INSERT INTO core_text VALUES ('POST_NEWS','EN','Post a news item');
-INSERT INTO core_text VALUES ('POST_NEWS','FR','Poster une nouvelle');
+INSERT INTO core_text VALUES ('POST_NEWS','FR','Poster un article');
 INSERT INTO core_text VALUES ('POST_NEWS','DE','Post a news item');
 INSERT INTO core_text VALUES ('POST_NEWS','ES','Post a news item');
 
@@ -352,7 +352,7 @@
 
 
 INSERT INTO core_text VALUES ('COMMENT_HEADER_TEXT', 'EN', 'You can here post a comment. <br>Be aware that HTTP and FTP URL will be detected. <br> Do not put the &lt;A HREF="..."&gt; tag.');
-INSERT INTO core_text VALUES ('COMMENT_HEADER_TEXT', 'FR', 'Vous pouvez poster un commentaire. <br>Les liens HTTP et FTP seront détéctés automatiquement. <BR> Ne mettez donc pas le tag &lt;A HREF="..."&gt;. <p>Votre email ne sera pas affiché, il sera utilisé pour vous notifier<br> lorsqu''un nouveau commentaire est posté pour cette nouvelle.');
+INSERT INTO core_text VALUES ('COMMENT_HEADER_TEXT', 'FR', 'Vous pouvez poster un commentaire. <br>Les liens HTTP et FTP seront détéctés automatiquement. <BR> Ne mettez donc pas le tag &lt;A HREF="..."&gt;. <p>Votre email ne sera pas affiché, il sera utilisé pour vous notifier<br> lorsqu''un nouveau commentaire est posté pour cet article.');
 INSERT INTO core_text VALUES ('COMMENT_HEADER_TEXT', 'ES', 'You can here post a comment. <br>Be aware that HTTP and FTP URL will be detected ; do not put the &lt;A HREF="..."&gt; tag.');
 INSERT INTO core_text VALUES ('COMMENT_HEADER_TEXT', 'DE', 'You can here post a comment. <br>Be aware that HTTP and FTP URL will be detected ; do not put the &lt;A HREF="..."&gt; tag.');
 
@@ -362,17 +362,17 @@
 INSERT INTO core_text VALUES ('Y_C_SEND_EMAIL','DE','You can send this news item to the following email addresses');
 
 INSERT INTO core_text VALUES ('NEWS_HEAD','EN','Enter the head of the piece of news');
-INSERT INTO core_text VALUES ('NEWS_HEAD','FR','Entrez l''en-tête de la nouvelle');
+INSERT INTO core_text VALUES ('NEWS_HEAD','FR','Entrez l''en-tête de l''article');
 INSERT INTO core_text VALUES ('NEWS_HEAD','ES','Enter the head of the piece of news');
 INSERT INTO core_text VALUES ('NEWS_HEAD','DE','Enter the head of the piece of news');
 
 INSERT INTO core_text VALUES ('NEWS_BODY','EN','Enter the body of the piece of news');
-INSERT INTO core_text VALUES ('NEWS_BODY','FR','Entrez le corps de la nouvelle');
+INSERT INTO core_text VALUES ('NEWS_BODY','FR','Entrez le corps de l''article');
 INSERT INTO core_text VALUES ('NEWS_BODY','ES','Enter the body of the piece of news');
 INSERT INTO core_text VALUES ('NEWS_BODY','DE','Enter the body of the piece of news');
 
 INSERT INTO core_text VALUES ('FORWARD_TITLE','EN','News Forwarder');
-INSERT INTO core_text VALUES ('FORWARD_TITLE','FR','Faire suivre une nouvelle');
+INSERT INTO core_text VALUES ('FORWARD_TITLE','FR','Faire suivre un article');
 INSERT INTO core_text VALUES ('FORWARD_TITLE','ES','News Forwarder');
 INSERT INTO core_text VALUES ('FORWARD_TITLE','DE','News Forwarder');
 
@@ -469,7 +469,7 @@
 INSERT INTO core_text VALUES ('OLD_NEWS','DE','Hier sind die alten Nachrichten.');
 
 INSERT INTO core_text VALUES ('NEW_NEWS','EN','Here are my fresh news.');
-INSERT INTO core_text VALUES ('NEW_NEWS','FR','Voici les nouvelles fraîches.');
+INSERT INTO core_text VALUES ('NEW_NEWS','FR','Voici les nouveaux articles.');
 INSERT INTO core_text VALUES ('NEW_NEWS','ES','Aqu&iacute; est&aacute;n las novedades.');
 INSERT INTO core_text VALUES ('NEW_NEWS','DE','Hier sind die Neuigkeiten.');
 
@@ -546,7 +546,7 @@
 INSERT INTO core_text VALUES ('TOP_TEXT','EN','Here you will find all the topics
 that my news are related to.');
 INSERT INTO core_text VALUES ('TOP_TEXT','FR','Vous trouverez ici toutes les
-rubriques auxquelles se rapportent les nouvelles');
+rubriques auxquelles se rapportent les articles');
 INSERT INTO core_text VALUES ('TOP_TEXT','ES','Aqu&iacute;
 encontrar&aacute; todos los temas relacionados con mis noticias.');
 INSERT INTO core_text VALUES ('TOP_TEXT','DE','Hier werden sie alle die Themen
@@ -699,7 +699,7 @@
 INSERT INTO core_text VALUES ('ON','DE','\\on');
 
 INSERT INTO core_text VALUES ('COMMENT_NEWS','EN','Comment on this piece of news');
-INSERT INTO core_text VALUES ('COMMENT_NEWS','FR','Commenter cette nouvelle ?');
+INSERT INTO core_text VALUES ('COMMENT_NEWS','FR','Commenter cet article ?');
 INSERT INTO core_text VALUES ('COMMENT_NEWS','ES','\\Comment on this piece of news');
 INSERT INTO core_text VALUES ('COMMENT_NEWS','DE','\\Comment on this piece of news');
 
@@ -744,12 +744,12 @@
 INSERT INTO core_text VALUES ('NEWS_BY_TOPICS_LIST_HEADER','DE','\\News in the selected topic');
 
 INSERT INTO core_text VALUES ('OLD_NEWS_LIST_TITLE','EN','Old News are good news ?');
-INSERT INTO core_text VALUES ('OLD_NEWS_LIST_TITLE','FR','Nouvelle ancienne, bonne nouvelle ?');
+INSERT INTO core_text VALUES ('OLD_NEWS_LIST_TITLE','FR','Article précédemment postés');
 INSERT INTO core_text VALUES ('OLD_NEWS_LIST_TITLE','ES','\\List Of Old News');
 INSERT INTO core_text VALUES ('OLD_NEWS_LIST_TITLE','DE','\\List Of Old News');
 
 INSERT INTO core_text VALUES ('OLD_NEWS_LIST_HEADER','EN','Here are the old news');
-INSERT INTO core_text VALUES ('OLD_NEWS_LIST_HEADER','FR','Voici la liste des vieilles nouvelles');
+INSERT INTO core_text VALUES ('OLD_NEWS_LIST_HEADER','FR','Voici la liste des vieux articles');
 INSERT INTO core_text VALUES ('OLD_NEWS_LIST_HEADER','ES','\\Here are the old news');
 INSERT INTO core_text VALUES ('OLD_NEWS_LIST_HEADER','DE','\\Here are the old news');
 

MyDynaWeb CVS: sql sukria

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

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : sql

Dir     : mydynaweb/sql/db_upgrade


Added Files:
	from-0.5pre1__to-mytinyweb.sql 


Log Message:
fichier de migration vers la structure de base de mytinyweb

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 


Log Message:
table pour les sondages
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -3 -r1.15 -r1.16
--- MYSQL_create.sql	28 Feb 2003 13:37:57 -0000	1.15
+++ MYSQL_create.sql	5 Mar 2003 15:43:59 -0000	1.16
@@ -97,6 +97,7 @@
   lang varchar(2) NOT NULL default '',
   family int not null default 1,
   is_online int not null default 0,
+  approved int not null default 0,
   user_name varchar(15) default '[nobody]',
   PRIMARY KEY (num_news)
 );
@@ -236,4 +237,31 @@
   PRIMARY KEY (varname)
 );
 
+CREATE TABLE email_forward (
+	mail varchar(125) not null default '',
+	num_news int not null default 0,
+	date DATE not null
+);
+
+CREATE TABLE poll (
+	pol_id int not null default 0,
+	pol_title varchar (125) not null default '',
+	
+	pol_question_1_str varchar(255),
+	pol_question_2_str varchar(255),
+	pol_question_3_str varchar(255),
+	pol_question_4_str varchar(255),
+	pol_question_5_str varchar(255),
+	pol_question_6_str varchar(255),
+	pol_question_7_str varchar(255),
+	
+	pol_question_1_num int,
+	pol_question_2_num int,
+	pol_question_3_num int,
+	pol_question_4_num int,
+	pol_question_5_num int,
+	pol_question_6_num int,
+	pol_question_7_num int,
 
+	PRIMARY KEY (pol_id)
+);

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 


Log Message:
pour les sondages
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -3 -r1.16 -r1.17
--- MYSQL_create.sql	5 Mar 2003 15:43:59 -0000	1.16
+++ MYSQL_create.sql	5 Mar 2003 18:10:10 -0000	1.17
@@ -246,7 +246,8 @@
 CREATE TABLE poll (
 	pol_id int not null default 0,
 	pol_title varchar (125) not null default '',
-	
+	pol_is_open tinyint not null default 0,
+
 	pol_question_1_str varchar(255),
 	pol_question_2_str varchar(255),
 	pol_question_3_str varchar(255),
@@ -265,3 +266,12 @@
 
 	PRIMARY KEY (pol_id)
 );
+
+
+CREATE TABLE poll_users (
+	pol_id int not null default 0,
+	user_ip_addr varchar(16) not null default '',
+
+	primary key (pol_id, user_ip_addr)
+);
+

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 


Log Message:
quelques mise à jour avant le premier taggage en mytinyweb_0.1
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -3 -r1.17 -r1.18
--- MYSQL_create.sql	5 Mar 2003 18:10:10 -0000	1.17
+++ MYSQL_create.sql	14 Mar 2003 15:09:53 -0000	1.18
@@ -264,6 +264,8 @@
 	pol_question_6_num int,
 	pol_question_7_num int,
 
+	pol_date_creation date not null,
+	
 	PRIMARY KEY (pol_id)
 );
 

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 


Log Message:
on loggue le user-agent lors des votes afin de controller qu'il n'y a pas d'abus
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -3 -r1.18 -r1.19
--- MYSQL_create.sql	14 Mar 2003 15:09:53 -0000	1.18
+++ MYSQL_create.sql	21 Mar 2003 09:17:27 -0000	1.19
@@ -88,7 +88,7 @@
 
 CREATE TABLE news (
   num_news int NOT NULL auto_increment,
-  titre varchar(50) NOT NULL default '',
+  titre varchar(255) NOT NULL default '',
   date date NOT NULL default '0000-00-00',
   texte text NOT NULL,
   long_text text not null default '',
@@ -105,7 +105,7 @@
 CREATE TABLE comments (
   num_cmt int(11) NOT NULL auto_increment,
   pere int not null default 0,
-  title varchar(35) DEFAULT '' NOT NULL,
+  title varchar(255) DEFAULT '' NOT NULL,
   date_ins date DEFAULT '0000-00-00' NOT NULL,
   content text DEFAULT '' NOT NULL,
   _num_news int(11) DEFAULT '0' NOT NULL,
@@ -273,6 +273,7 @@
 CREATE TABLE poll_users (
 	pol_id int not null default 0,
 	user_ip_addr varchar(16) not null default '',
+	user_agent varchar(255) not null default '',
 
 	primary key (pol_id, user_ip_addr)
 );

MyDynaWeb CVS: sql sukria

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

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : sql

Dir     : mydynaweb/sql/db_upgrade


Modified Files:
	from-0.5pre1__to-mytinyweb.sql 


Log Message:
on loggue le user-agent lors des votes afin de controller qu'il n'y a pas d'abus
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.5pre1__to-mytinyweb.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -3 -r1.1 -r1.2
--- from-0.5pre1__to-mytinyweb.sql	3 Mar 2003 10:22:19 -0000	1.1
+++ from-0.5pre1__to-mytinyweb.sql	21 Mar 2003 09:17:27 -0000	1.2
@@ -1,3 +1,4 @@
 alter table news add approved tinyint not null default 0;
 alter table news add nb_forward int not null default 0;
 alter table comments add show_user_mail tinyint not null default 1;
+alter table poll_users add user_agent varchar(255) not null default '';

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 


Log Message:
il manquait des colones pour la gestion des commentaires sur les galleries d'images
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -3 -r1.19 -r1.20
--- MYSQL_create.sql	21 Mar 2003 09:17:27 -0000	1.19
+++ MYSQL_create.sql	27 Mar 2003 14:54:40 -0000	1.20
@@ -111,6 +111,8 @@
   _num_news int(11) DEFAULT '0' NOT NULL,
   user_name varchar(15) DEFAULT 'sukria',
   user_mail varchar(100) not null default '',
+  _imgname varchar(255) not null default '',
+  _gallery varchar(255) not null default '',
   PRIMARY KEY (num_cmt)
 );
 

MyDynaWeb CVS: sql sukria

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

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : sql

Dir     : mydynaweb/sql/db_upgrade


Modified Files:
	from-0.5pre1__to-mytinyweb.sql 


Log Message:
il manquait des colones pour la gestion des commentaires sur les galleries d'images
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.5pre1__to-mytinyweb.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -3 -r1.2 -r1.3
--- from-0.5pre1__to-mytinyweb.sql	21 Mar 2003 09:17:27 -0000	1.2
+++ from-0.5pre1__to-mytinyweb.sql	27 Mar 2003 14:54:40 -0000	1.3
@@ -2,3 +2,5 @@
 alter table news add nb_forward int not null default 0;
 alter table comments add show_user_mail tinyint not null default 1;
 alter table poll_users add user_agent varchar(255) not null default '';
+alter table comments add _gallery varchar(255) not null default '';
+alter table comments add _imgname varchar(255) not null default '';

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 


Log Message:
ajout de la table de comptabilisation des liens
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -3 -r1.20 -r1.21
--- MYSQL_create.sql	27 Mar 2003 14:54:40 -0000	1.20
+++ MYSQL_create.sql	2 Apr 2003 13:46:19 -0000	1.21
@@ -280,3 +280,13 @@
 	primary key (pol_id, user_ip_addr)
 );
 
+CREATE TABLE links (
+	num_link int not null auto_increment,
+	url varchar(255) not null default '',
+	name varchar(125) not null default '',
+	hits int not null default 0,
+	_num_news int not null default 0,
+	_num_page int not null default 0,
+
+	primary key (num_link)
+);

MyDynaWeb CVS: sql sukria

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

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : sql

Dir     : mydynaweb/sql/upgrades


Modified Files:
	core_text.sql 


Log Message:
traductions pour l'espace membre
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/upgrades/core_text.sql,v
retrieving revision 1.46
retrieving revision 1.47
diff -u -3 -r1.46 -r1.47
--- core_text.sql	28 Feb 2003 13:48:27 -0000	1.46
+++ core_text.sql	3 Apr 2003 10:11:51 -0000	1.47
@@ -1,5 +1,23 @@
 DELETE FROM core_text;
 
+INSERT INTO core_text VALUES ('MEMBERS_AREA_HEADER', 'EN', 'Welcome in your member area. You can here submit stories and change your password. You can also see the new stories since your last visit. When you submit a story, don''t expect it to appear automatically on the website : it must be approved by the administrator first.'); 
+INSERT INTO core_text VALUES ('MEMBERS_AREA_HEADER', 'FR', 'Bienvenue dans votre espace membre. Vous pouvez rédiger des articles et changer votre mot de passe. Vous pouvez également voir les articles qui ont été postés depuis votre dernière visite. Les articles que vous rédigez n''apparaissent pas automatiquement sur le site car ils doivent d''abord être approuvés par le modérateur.'); 
+
+INSERT INTO core_text VALUES ('ADMIN', 'EN', 'Admin'); 
+INSERT INTO core_text VALUES ('ADMIN', 'FR', 'Administration'); 
+
+INSERT INTO core_text VALUES ('MANAGE_STORIES', 'EN', 'Manage stories'); 
+INSERT INTO core_text VALUES ('MANAGE_STORIES', 'FR', 'Gestion des articles');
+
+INSERT INTO core_text VALUES ('SINCE_LAST_VISIT', 'EN', 'New posted stories since your last visit'); 
+INSERT INTO core_text VALUES ('SINCE_LAST_VISIT', 'FR', 'Articles postés depuis votre dernière visite'); 
+
+INSERT INTO core_text VALUES ('UPDATE_NEWS', 'EN', 'Story Edition'); 
+INSERT INTO core_text VALUES ('UPDATE_NEWS', 'FR', 'Edition d''article'); 
+
+INSERT INTO core_text VALUES ('TO_BE_APPROVED', 'EN', 'Stories you wrotewaiting for approval : '); 
+INSERT INTO core_text VALUES ('TO_BE_APPROVED', 'FR', 'Vos articles en attente de validation : '); 
+
 INSERT INTO core_text VALUES ('EMAIL', 'EN', 'email'); 
 INSERT INTO core_text VALUES ('EMAIL', 'FR', 'email'); 
 INSERT INTO core_text VALUES ('EMAIL', 'DE', 'email');