summaryrefslogtreecommitdiff
path: root/beta_old1/install/base.sql
diff options
context:
space:
mode:
authorLudovic Pouzenc <ludovic@pouzenc.fr>2018-06-30 11:37:30 +0200
committerLudovic Pouzenc <ludovic@pouzenc.fr>2018-06-30 11:37:30 +0200
commit5dac82f52f45ad27f16ec2ff63ee75e2f39ef942 (patch)
tree62cf671332976c83024139fc4c22009b382d45ff /beta_old1/install/base.sql
parent34795da1b6bd714df0d5dce93558e04b2bb8a287 (diff)
download2007-AWOR-5dac82f52f45ad27f16ec2ff63ee75e2f39ef942.tar.gz
2007-AWOR-5dac82f52f45ad27f16ec2ff63ee75e2f39ef942.tar.bz2
2007-AWOR-5dac82f52f45ad27f16ec2ff63ee75e2f39ef942.zip
Renommage pour diff de beta_old1 vers beta_accents
Diffstat (limited to 'beta_old1/install/base.sql')
-rw-r--r--beta_old1/install/base.sql123
1 files changed, 0 insertions, 123 deletions
diff --git a/beta_old1/install/base.sql b/beta_old1/install/base.sql
deleted file mode 100644
index 6d1ba97..0000000
--- a/beta_old1/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`)
-);