From a5dba7cbf654d45763d85130e52f66cdce7871ba Mon Sep 17 00:00:00 2001
From: Ludovic Pouzenc <ludovic@pouzenc.fr>
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/base.sql')

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

