diff options
author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2018-07-05 00:25:51 +0200 |
---|---|---|
committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2018-07-05 00:25:51 +0200 |
commit | ac54f5224d4470de9d8ae088e1338dea52668c9d (patch) | |
tree | 7f77b2a8176343e6632fbd99ff431c21974ef482 /final/install/base.sql | |
parent | 9738017972a6d4fea655926525b3c67dd85740cf (diff) | |
download | 2007-AWOR-ac54f5224d4470de9d8ae088e1338dea52668c9d.tar.gz 2007-AWOR-ac54f5224d4470de9d8ae088e1338dea52668c9d.tar.bz2 2007-AWOR-ac54f5224d4470de9d8ae088e1338dea52668c9d.zip |
Renommage beta_accents -> final pour diffs
Diffstat (limited to 'final/install/base.sql')
-rw-r--r-- | final/install/base.sql | 123 |
1 files changed, 123 insertions, 0 deletions
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`) +); |