From a5dba7cbf654d45763d85130e52f66cdce7871ba Mon Sep 17 00:00:00 2001 From: Ludovic Pouzenc Date: Thu, 5 Jul 2018 00:35:24 +0200 Subject: Version AWOR_v1.1 --- final/install/base.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'final/install') diff --git a/final/install/base.sql b/final/install/base.sql index 6d1ba97..48ea5a1 100644 --- a/final/install/base.sql +++ b/final/install/base.sql @@ -47,7 +47,7 @@ CREATE TABLE IF NOT EXISTS `AWOR_Creneau` ( DROP TABLE IF EXISTS `AWOR_Fichier`; CREATE TABLE IF NOT EXISTS `AWOR_Fichier` ( `idFic` int(11) NOT NULL auto_increment, - `nomFic` varchar(256) NOT NULL, + `nomFic` varchar(254) NOT NULL, `idR` int(11) NOT NULL, PRIMARY KEY (`idFic`) ); @@ -97,7 +97,7 @@ DROP TABLE IF EXISTS `AWOR_Repondre`; CREATE TABLE IF NOT EXISTS `AWOR_Repondre` ( `idR` int(11) NOT NULL, `idP` int(11) NOT NULL, - `commentaireReponse` varchar(500) default NULL, + `commentaireReponse` BLOB default NULL, PRIMARY KEY (`idR`,`idP`) ); @@ -113,7 +113,7 @@ CREATE TABLE IF NOT EXISTS `AWOR_Reunion` ( `objetR` varchar(80) NOT NULL, `ordreJourR` varchar(250), `lieuR` varchar(50), - `remarquesR` varchar(500), + `remarquesR` BLOB, `montrerDispoR` set('oui','non') NOT NULL default 'non', `estAnnulee` set('oui','non') NOT NULL default 'non', `idP_Orga` int(11) NOT NULL, -- cgit v1.2.3