summaryrefslogtreecommitdiff
path: root/beta_accents/install/base.sql
diff options
context:
space:
mode:
authorLudovic Pouzenc <ludovic@pouzenc.fr>2018-07-05 00:25:51 +0200
committerLudovic Pouzenc <ludovic@pouzenc.fr>2018-07-05 00:25:51 +0200
commitac54f5224d4470de9d8ae088e1338dea52668c9d (patch)
tree7f77b2a8176343e6632fbd99ff431c21974ef482 /beta_accents/install/base.sql
parent9738017972a6d4fea655926525b3c67dd85740cf (diff)
download2007-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.sql123
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`)
-);