pascalp

Model Bake:---------------------------------------------------------------Possible Models based on your current database:1. Event2. EventsIndividual3. EventsNote4. Individual5. IndividualsNote6. Info7. NoteEnter a number from the list above, or type in the name of another model.  > 1Would you like to supply validation criteria for the fields in your model? (y/n) [y] > yWarning: Invalid argument supplied for foreach() in /var/www/html/cake/cake/scripts/bake.php on line 445Would you like to define model associations (hasMany, hasOne, belongsTo, etc.)? (y/n) [y] > ========================================================================================================================================================================================================================-- phpMyAdmin SQL Dump-- version 2.10.0-beta1-- http://www.phpmyadmin.net-- -- Serveur: localhost-- Généré le : Mardi 27 Février 2007 à 21:43-- Version du serveur: 5.0.33-- Version de PHP: 5.2.1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";-- -- Base de données: `mvc`-- -- ---------------------------------------------------------- -- Structure de la table `genea_events`-- CREATE TABLE `genea_events` (  `id` mediumint(8) unsigned NOT NULL auto_increment,  `place_id` mediumint(8) unsigned default NULL,  `events_details_descriptor` varchar(4) collate utf8_unicode_ci NOT NULL default '',  `events_details_gedcom_date` varchar(100) collate utf8_unicode_ci NOT NULL default '',  `events_details_age` varchar(20) collate utf8_unicode_ci NOT NULL default '',  `events_details_cause` varchar(255) collate utf8_unicode_ci NOT NULL default '',  `jd_count` mediumint(8) unsigned default NULL,  `jd_precision` tinyint(3) unsigned default NULL,  `jd_calendar` varchar(45) collate utf8_unicode_ci default NULL,  `base` tinyint(4) unsigned NOT NULL default '0',  `events_details_timestamp` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`id`),  KEY `base` (`base`),  KEY `place_id` (`place_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Tables contenant tous les évènements' AUTO_INCREMENT=1 ;-- -- Contenu de la table `genea_events`-- -- ---------------------------------------------------------- -- Structure de la table `genea_events_individuals`-- CREATE TABLE `genea_events_individuals` (  `event_id` mediumint(8) unsigned NOT NULL default '0',  `individual_id` mediumint(8) unsigned NOT NULL default '0',  `events_tag` varchar(4) collate utf8_unicode_ci NOT NULL default '',  `events_attestation` char(1) collate utf8_unicode_ci default NULL,  PRIMARY KEY  (`individual_id`,`event_id`),  KEY `events_id` (`event_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Association d''un évènement ç une famille';-- -- Contenu de la table `genea_events_individuals`-- -- ---------------------------------------------------------- -- Structure de la table `genea_events_notes`-- CREATE TABLE `genea_events_notes` (  `event_id` mediumint(8) unsigned NOT NULL default '0',  `note_id` mediumint(8) unsigned NOT NULL default '0',  PRIMARY KEY  (`event_id`,`note_id`),  KEY `notes_id` (`note_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Association d''une note à un évènement';-- -- Contenu de la table `genea_events_notes`-- -- ---------------------------------------------------------- -- Structure de la table `genea_individuals`-- CREATE TABLE `genea_individuals` (  `id` mediumint(8) unsigned NOT NULL auto_increment,  `base` tinyint(4) unsigned NOT NULL default '0',  `indi_nom` char(100) collate utf8_unicode_ci NOT NULL default '',  `indi_prenom` char(100) collate utf8_unicode_ci NOT NULL default '',  `indi_sexe` char(1) collate utf8_unicode_ci NOT NULL default '',  `indi_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `indi_npfx` char(30) collate utf8_unicode_ci NOT NULL default '',  `indi_givn` char(120) collate utf8_unicode_ci NOT NULL default '',  `indi_nick` char(30) collate utf8_unicode_ci NOT NULL default '',  `indi_spfx` char(30) collate utf8_unicode_ci NOT NULL default '',  `indi_surn` char(120) collate utf8_unicode_ci NOT NULL default '',  `indi_nsfx` char(30) collate utf8_unicode_ci NOT NULL default '',  `indi_resn` enum('locked','privacy') collate utf8_unicode_ci default NULL,  PRIMARY KEY  (`id`),  KEY `indi_nom` (`indi_nom`),  KEY `indi_prenom` (`indi_prenom`),  KEY `base` (`base`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table contenant les individus' AUTO_INCREMENT=1 ;-- -- Contenu de la table `genea_individuals`-- -- ---------------------------------------------------------- -- Structure de la table `genea_individuals_notes`-- CREATE TABLE `genea_individuals_notes` (  `note_id` mediumint(8) unsigned NOT NULL default '0',  `individual_id` mediumint(8) unsigned NOT NULL default '0',  PRIMARY KEY  (`individual_id`,`note_id`),  KEY `notes_id` (`note_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;-- -- Contenu de la table `genea_individuals_notes`-- -- ---------------------------------------------------------- -- Structure de la table `genea_infos`-- CREATE TABLE `genea_infos` (  `id` tinyint(4) unsigned NOT NULL auto_increment,  `nom` varchar(255) collate utf8_unicode_ci NOT NULL default '',  `descriptif` tinytext collate utf8_unicode_ci NOT NULL,  `entetes` text collate utf8_unicode_ci NOT NULL,  `ged_corp` varchar(90) collate utf8_unicode_ci NOT NULL default '',  `subm` mediumint(8) unsigned default NULL,  PRIMARY KEY  (`id`),  KEY `subm` (`subm`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Paramètres généraux des bases de données généalogiques' AUTO_INCREMENT=1 ;-- -- Contenu de la table `genea_infos`-- -- ---------------------------------------------------------- -- Structure de la table `genea_notes`-- CREATE TABLE `genea_notes` (  `id` mediumint(8) unsigned NOT NULL auto_increment,  `base` tinyint(4) unsigned NOT NULL default '0',  `notes_text` text collate utf8_unicode_ci NOT NULL,  `notes_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`id`),  KEY `base` (`base`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Liste des notes' AUTO_INCREMENT=1 ;-- -- Contenu de la table `genea_notes`-- -- -- Contraintes pour les tables exportées-- -- -- Contraintes pour la table `genea_events`-- ALTER TABLE `genea_events`  ADD CONSTRAINT `genea_events_ibfk_1` FOREIGN KEY (`base`) REFERENCES `genea_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;-- -- Contraintes pour la table `genea_events_individuals`-- ALTER TABLE `genea_events_individuals`  ADD CONSTRAINT `genea_events_individuals_ibfk_2` FOREIGN KEY (`individual_id`) REFERENCES `genea_individuals` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT `genea_events_individuals_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `genea_events` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;-- -- Contraintes pour la table `genea_events_notes`-- ALTER TABLE `genea_events_notes`  ADD CONSTRAINT `genea_events_notes_ibfk_2` FOREIGN KEY (`note_id`) REFERENCES `genea_notes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT `genea_events_notes_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `genea_events` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;-- -- Contraintes pour la table `genea_individuals`-- ALTER TABLE `genea_individuals`  ADD CONSTRAINT `genea_individuals_ibfk_1` FOREIGN KEY (`base`) REFERENCES `genea_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;-- -- Contraintes pour la table `genea_individuals_notes`-- ALTER TABLE `genea_individuals_notes`  ADD CONSTRAINT `genea_individuals_notes_ibfk_2` FOREIGN KEY (`individual_id`) REFERENCES `genea_individuals` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT `genea_individuals_notes_ibfk_1` FOREIGN KEY (`note_id`) REFERENCES `genea_notes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;-- -- Contraintes pour la table `genea_notes`-- ALTER TABLE `genea_notes`  ADD CONSTRAINT `genea_notes_ibfk_1` FOREIGN KEY (`base`) REFERENCES `genea_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;