From 3fc908d3a1d0f6c9b1fca690561098541a73266e Mon Sep 17 00:00:00 2001
From: Ludovic Pouzenc <ludovic@pouzenc.fr>
Date: Sat, 30 Jun 2018 11:13:09 +0200
Subject: Version alpha_old5 2007-02-22+15:00:00 - 2007-03-11+16:30:15
---
appli_3_alpha_old/app/install/base.sql | 123 +++++++++++++++++++++++++++++++++
1 file changed, 123 insertions(+)
create mode 100644 appli_3_alpha_old/app/install/base.sql
(limited to 'appli_3_alpha_old/app/install/base.sql')
diff --git a/appli_3_alpha_old/app/install/base.sql b/appli_3_alpha_old/app/install/base.sql
new file mode 100644
index 0000000..e531f4d
--- /dev/null
+++ b/appli_3_alpha_old/app/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 default 'Remplissez',
+ `ordreJourR` varchar(250) default 'Remplissez',
+ `lieuR` varchar(50) default 'Remplissez',
+ `remarquesR` varchar(500) default 'Remplissez',
+ `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