summaryrefslogtreecommitdiff
path: root/final/install/base.txt
diff options
context:
space:
mode:
Diffstat (limited to 'final/install/base.txt')
-rw-r--r--final/install/base.txt123
1 files changed, 123 insertions, 0 deletions
diff --git a/final/install/base.txt b/final/install/base.txt
new file mode 100644
index 0000000..3e090bd
--- /dev/null
+++ b/final/install/base.txt
@@ -0,0 +1,123 @@
+--
+-- 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(254) 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` blob(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` blob(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`)
+);