From ac54f5224d4470de9d8ae088e1338dea52668c9d Mon Sep 17 00:00:00 2001
From: Ludovic Pouzenc <ludovic@pouzenc.fr>
Date: Thu, 5 Jul 2018 00:25:51 +0200
Subject: Renommage beta_accents -> final pour diffs

---
 final/install/base.sql | 123 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 123 insertions(+)
 create mode 100644 final/install/base.sql

(limited to 'final/install/base.sql')

diff --git a/final/install/base.sql b/final/install/base.sql
new file mode 100644
index 0000000..6d1ba97
--- /dev/null
+++ b/final/install/base.sql
@@ -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(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`)
+);
-- 
cgit v1.2.3