summaryrefslogtreecommitdiff
path: root/appli_3_alpha_old/app/install/base.sql
diff options
context:
space:
mode:
Diffstat (limited to 'appli_3_alpha_old/app/install/base.sql')
-rw-r--r--appli_3_alpha_old/app/install/base.sql123
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`)
-);