Model Bake:
---------------------------------------------------------------
Possible Models based on your current database:
1. Event
2. EventsIndividual
3. EventsNote
4. Individual
5. IndividualsNote
6. Info
7. Note

Enter a number from the list above, or type in the name of another model.  
> 1

Would you like to supply validation criteria for the fields in your model? (y/n) 
[y] > y

Warning: Invalid argument supplied for foreach() in /var/www/html/cake/cake/scripts/bake.php on line 445

Would 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.1

SET 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;