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)
+);