1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97
|
CREATE TABLE `act` (
`id_act` int(11) NOT NULL auto_increment,
`nom_act` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id_act`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10000 ;
-- --------------------------------------------------------
--
-- Structure de la table `event`
--
CREATE TABLE `event` (
`id_event` int(11) NOT NULL auto_increment,
`nom_event` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id_event`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10001 ;
-- --------------------------------------------------------
--
-- Structure de la table `event_act`
--
CREATE TABLE `event_act` (
`id_event_ea` int(11) unsigned NOT NULL,
`id_act_ea` int(11) unsigned NOT NULL,
`priority_ea` tinyint(4) NOT NULL,
KEY `_id_event_` (`id_event_ea`,`id_act_ea`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Structure de la table `event_lieux`
--
CREATE TABLE `event_lieux` (
`id_event_el` int(11) unsigned NOT NULL,
`id_lieux_el` int(11) unsigned NOT NULL,
`priority_el` tinyint(4) NOT NULL,
KEY `id_lieux_el` (`id_lieux_el`,`priority_el`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Structure de la table `event_org`
--
CREATE TABLE `event_org` (
`id_event_eo` int(10) unsigned NOT NULL,
`id_org_eo` int(10) unsigned NOT NULL,
`priority_eo` tinyint(4) NOT NULL,
KEY `id_event_eo` (`id_event_eo`,`id_org_eo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Structure de la table `lieux`
--
CREATE TABLE `lieux` (
`id_lieux` int(11) NOT NULL auto_increment,
`nom_lieux` text collate utf8_unicode_ci NOT NULL,
`region_lieux` int(11) NOT NULL,
PRIMARY KEY (`id_lieux`),
KEY `region_lieux` (`region_lieux`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10000 ;
-- --------------------------------------------------------
--
-- Structure de la table `org`
--
CREATE TABLE `org` (
`id_org` int(11) NOT NULL auto_increment,
`nom_org` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id_org`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10000 ;
-- --------------------------------------------------------
--
-- Structure de la table `ville`
--
CREATE TABLE `ville` (
`id_ville` mediumint(8) unsigned NOT NULL default '0',
`nom_ville` tinytext collate utf8_unicode_ci NOT NULL,
`cp_ville` tinytext collate utf8_unicode_ci NOT NULL,
`dep_ville` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id_ville`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
Partager