diff options
Diffstat (limited to 'final/install/base.sql')
| -rw-r--r-- | final/install/base.sql | 6 |
1 files changed, 3 insertions, 3 deletions
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, |