Renommage pour diff entre appli_3_alpha_old et beta_old1

1 files changed, 0 insertions, 123 deletions

diff --git a/appli_3_alpha_old/app/install/base.sql b/appli_3_alpha_old/app/install/base.sql
deleted file mode 100644
index 6d1ba97..0000000
--- a/appli_3_alpha_old/app/install/base.sql
+++ /dev/null
@@ -1,123 +0,0 @@
--- 
--- Structure de la table `AWOR_Appartenir`
--- 
-
-DROP TABLE IF EXISTS `AWOR_Appartenir`;
-CREATE TABLE IF NOT EXISTS `AWOR_Appartenir` (
-  `idL` int(11) NOT NULL,
-  `idP` int(11) NOT NULL,
-  PRIMARY KEY  (`idL`,`idP`)
-);
-
--- --------------------------------------------------------
-
--- 
--- Structure de la table `Choisir`
--- 
-
-DROP TABLE IF EXISTS `AWOR_Choisir`;
-CREATE TABLE IF NOT EXISTS `AWOR_Choisir` (
-  `idC` int(11) NOT NULL,
-  `idP` int(11) NOT NULL,
-  `estDispo` set('oui','non') NOT NULL,
-  PRIMARY KEY  (`idC`,`idP`)
-);
-
--- --------------------------------------------------------
-
--- 
--- Structure de la table `AWOR_Creneau`
--- 
-
-DROP TABLE IF EXISTS `AWOR_Creneau`;
-CREATE TABLE IF NOT EXISTS `AWOR_Creneau` (
-  `idC` int(11) NOT NULL auto_increment,
-  `dateHeure` datetime NOT NULL,
-  `duree` int(11) NOT NULL,
-  `idR` int(11) NOT NULL,
-  PRIMARY KEY  (`idC`)
-);
-
--- --------------------------------------------------------
-
--- 
--- Structure de la table `AWOR_Fichier`
--- 
-
-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,
-  `idR` int(11) NOT NULL,
-  PRIMARY KEY  (`idFic`)
-);
-
--- --------------------------------------------------------
-
--- 
--- Structure de la table `AWOR_Liste`
--- 
-
-DROP TABLE IF EXISTS `AWOR_Liste`;
-CREATE TABLE IF NOT EXISTS `AWOR_Liste` (
-  `idL` int(11) NOT NULL auto_increment,
-  `libelleL` varchar(50) NOT NULL,
-  `estPrivee` set('oui','non') NOT NULL default 'oui',
-  `idP_Createur` int(11) default NULL,
-  PRIMARY KEY  (`idL`)
-);
-
--- --------------------------------------------------------
-
--- 
--- Structure de la table `AWOR_Personne`
--- 
-
-DROP TABLE IF EXISTS `AWOR_Personne`;
-CREATE TABLE IF NOT EXISTS `AWOR_Personne` (
-  `idP` int(11) NOT NULL auto_increment,
-  `courrielP` varchar(50) NOT NULL,
-  `loginP` varchar(50) default NULL,
-  `nomP` varchar(50) NOT NULL,
-  `prenomP` varchar(50) NOT NULL,
-  `estAdmin` set('oui','non') NOT NULL default 'non',
-  `methodeAuth` set('pop','webetud','bypass') NOT NULL default 'pop',
-  PRIMARY KEY  (`idP`),
-  UNIQUE KEY `loginP` (`loginP`),
-  UNIQUE KEY `courrielP` (`courrielP`)
-);
-
--- --------------------------------------------------------
-
--- 
--- Structure de la table `AWOR_Repondre`
--- 
-
-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,
-  PRIMARY KEY  (`idR`,`idP`)
-);
-
--- --------------------------------------------------------
-
--- 
--- Structure de la table `Reunion`
--- 
-
-DROP TABLE IF EXISTS `AWOR_Reunion`;
-CREATE TABLE IF NOT EXISTS `AWOR_Reunion` (
-  `idR` int(11) NOT NULL auto_increment,
-  `objetR` varchar(80) NOT NULL,
-  `ordreJourR` varchar(250),
-  `lieuR` varchar(50),
-  `remarquesR` varchar(500),
-  `montrerDispoR` set('oui','non') NOT NULL default 'non',
-  `estAnnulee` set('oui','non') NOT NULL default 'non',
-  `idP_Orga` int(11) NOT NULL,
-  `idC_Fixe` int(11) default NULL,
-  `idL` int(11) default NULL,
-  PRIMARY KEY  (`idR`)
-);