diff options
| author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2018-07-05 00:35:24 +0200 |
|---|---|---|
| committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2018-07-05 00:35:24 +0200 |
| commit | a5dba7cbf654d45763d85130e52f66cdce7871ba (patch) | |
| tree | f5623cbdc7500c3f639d722b346b8576b01ceb11 /final/install | |
| parent | e7cf0e99f41ab8ba3bab8aed516123c6f4ff3979 (diff) | |
| download | 2007-AWOR-a5dba7cbf654d45763d85130e52f66cdce7871ba.tar.gz 2007-AWOR-a5dba7cbf654d45763d85130e52f66cdce7871ba.tar.bz2 2007-AWOR-a5dba7cbf654d45763d85130e52f66cdce7871ba.zip | |
Diffstat (limited to 'final/install')
| -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, |