Version alpha_old5 2007-02-22+15:00:00 - 2007-03-11+16:30:15

1 files changed, 123 insertions, 0 deletions

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`)
+);