diff options
author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2018-07-05 00:25:51 +0200 |
---|---|---|
committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2018-07-05 00:25:51 +0200 |
commit | ac54f5224d4470de9d8ae088e1338dea52668c9d (patch) | |
tree | 7f77b2a8176343e6632fbd99ff431c21974ef482 /beta_accents/install/base.sql | |
parent | 9738017972a6d4fea655926525b3c67dd85740cf (diff) | |
download | 2007-AWOR-ac54f5224d4470de9d8ae088e1338dea52668c9d.tar.gz 2007-AWOR-ac54f5224d4470de9d8ae088e1338dea52668c9d.tar.bz2 2007-AWOR-ac54f5224d4470de9d8ae088e1338dea52668c9d.zip |
Renommage beta_accents -> final pour diffs
Diffstat (limited to 'beta_accents/install/base.sql')
-rw-r--r-- | beta_accents/install/base.sql | 123 |
1 files changed, 0 insertions, 123 deletions
diff --git a/beta_accents/install/base.sql b/beta_accents/install/base.sql deleted file mode 100644 index 6d1ba97..0000000 --- a/beta_accents/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`) -); |