search

camilleregnier / asptt-plongee

Automatically exported from code.google.com/p/asptt-plongee
0 stars 0 forks source link

MEP Database #61

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
0 - Copie de sauvegarde du .war
1 - Arrêt de l'application
2 - Export/Copie sur la deuxième instance (fr_2)
3 - Modifications du schéma :

     3.1 - Adhérent : DATE_CM (timestamp) et ANNEE_COTI (int(4))
              UPDATE ADHERENT set DATE_CM = DATE('2010-09-15 00-00-00');
              UPDATE ADHERENT set ANNEE_COTI = 2011;

     3.2 - Création de la table MESSAGE
              `
CREATE TABLE `MESSAGE` (
  `LIBELLE` varchar(500) NOT NULL,
  `DATE_DEBUT` datetime NOT NULL,
  `DATE_FIN` datetime DEFAULT NULL,
  `idMESSAGE` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`idMESSAGE`) USING BTREE
)

     3.3 - Création de la table CONTACT_URGENT

CREATE TABLE `CONTACT_URGENT` (
  `idCONTACT` int(11) NOT NULL AUTO_INCREMENT,
  `TITRE` varchar(20) DEFAULT NULL,
  `NOM` varchar(70) NOT NULL,
  `PRENOM` varchar(70) NOT NULL,
  `TELEPHONE` varchar(10) NOT NULL,
  `TELEPHTWO` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`idCONTACT`)
)

     3.4 - Création de la table REL_ADHERENT_CONTACT

CREATE TABLE `REL_ADHERENT_CONTACT` (
  `adherent_LICENSE` varchar(10) NOT NULL,
  `contact_urgent_idCONTACT` int(11) NOT NULL,
  PRIMARY KEY (`adherent_LICENSE`,`contact_urgent_idCONTACT`),
  KEY `fk_rel_adherent_contact_adherent1` (`adherent_LICENSE`),
  KEY `fk_rel_adherent_contact_contact_urgent1` (`contact_urgent_idCONTACT`),
  CONSTRAINT `fk_rel_adherent_contact_adherent1` FOREIGN KEY (`adherent_LICENSE`) REFERENCES `adherent` (`LICENSE`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_rel_adherent_contact_contact_urgent1` FOREIGN KEY (`contact_urgent_idCONTACT`) REFERENCES `contact_urgent` (`idCONTACT`) ON DELETE NO ACTION ON UPDATE NO ACTION
)

4 - Déploiement nouveau .war
5 - Démarrage !!

Original issue reported on code.google.com by camille....@gmail.com on 26 Jan 2011 at 5:58

GoogleCodeExporter commented 9 years ago 
Modifier en plus :

LISTE_ATTENTE, ajouter le champ SUPPRIMER (int(1), 0 par défaut)
PLONGEE, ajouter DATE_VISIBLE (datetime, peut être null)

Original comment by camille....@gmail.com on 26 Jan 2011 at 6:41

GoogleCodeExporter commented 9 years ago

Original comment by camille....@gmail.com on 4 May 2011 at 9:52