-- phpMyAdmin SQL Dump -- version 2.6.1-pl3 -- http://www.phpmyadmin.net -- -- Serveur: 10.0.0.4 -- Généré le : Vendredi 25 Août 2006 à 13:43 -- Version du serveur: 4.1.10 -- Version de PHP: 4.4.3 -- -- Base de données: `jetons1` -- -- -------------------------------------------------------- -- -- Structure de la table `t_categories` -- CREATE TABLE `t_categories` ( `id_cat` smallint(6) NOT NULL auto_increment, `nom` varchar(50) NOT NULL default '', PRIMARY KEY (`id_cat`), UNIQUE KEY `id_cat` (`id_cat`), KEY `id_cat_2` (`id_cat`,`nom`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=96 ; -- -- Contenu de la table `t_categories` -- INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (1, '06'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (2, '80'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (3, '14'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (4, '17'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (5, '18'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (6, '29'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (7, '50'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (8, '55'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (9, '58'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (10, '63'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (11, '65'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (12, '75'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (13, '77'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (14, '78'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (15, '80'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (16, '86'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (17, '89'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (18, '92'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (20, 'euro'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (21, '07'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (22, '08'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (23, '09'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (24, '10'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (25, '11'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (26, '12'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (27, '13'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (28, '15'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (29, '16'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (30, '19'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (33, '21'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (34, '22'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (35, '23'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (36, '24'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (37, '25'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (38, '26'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (39, '26'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (40, '26'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (41, '27'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (42, '28'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (43, '20'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (44, '30'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (45, '31'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (46, '32'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (47, '33'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (48, '34'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (49, '35'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (50, '36'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (51, '37'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (52, '38'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (53, '39'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (54, '40'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (55, '41'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (56, '42'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (57, '43'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (58, '44'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (59, '45'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (60, '46'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (61, '47'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (62, '48'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (63, '49'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (64, '51'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (65, '52'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (66, '53'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (67, '54'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (68, '56'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (69, '57'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (70, '59'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (71, '60'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (72, '61'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (73, '62'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (74, '64'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (75, '66'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (76, '69'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (77, '70'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (78, '71'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (79, '72'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (80, '73'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (81, '74'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (82, '76'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (83, '79'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (84, '81'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (85, '82'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (86, '84'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (87, '85'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (88, '87'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (89, '88'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (90, '90'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (92, '91'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (93, '93'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (94, '94'); INSERT INTO `t_categories` (`id_cat`, `nom`) VALUES (95, '95'); -- -------------------------------------------------------- -- -- Structure de la table `t_images` -- CREATE TABLE `t_images` ( `id_im` smallint(6) NOT NULL auto_increment, `nom` varchar(50) NOT NULL default '', `verso` varchar(30) NOT NULL default '', `titre` varchar(40) default NULL, `taille` varchar(20) default NULL, `lamy` varchar(15) default NULL, `date` varchar(5) default NULL, `comment` text, `cota` varchar(10) default NULL, `parte` varchar(30) default NULL, `embal` varchar(40) default NULL, `nb_vis` int(11) NOT NULL default '0', `blocage` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id_im`), UNIQUE KEY `id_im` (`id_im`), UNIQUE KEY `nom` (`nom`), KEY `id_im_2` (`id_im`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ; -- -- Contenu de la table `t_images` -- INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (1, '06antibes.jpg', '2000.jpg', '', ' x', '1/003', '2000', 'Marineland - Les dauphins', '', 'non', '', 12, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (2, '06antibes2.jpg', '2002.jpg', '', ' x', 'epuisé', '2002', 'marineland - Orque', '', 'non', '', 4, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (3, '14arromanches.jpg', 'simple.jpg', '', ' x', '1/024', '', 'Musée du débarquement', '', 'non', '', 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (4, '17larochelle.jpg', '2003.jpg', '', ' x', '3/204', '2003', 'Aquarium de La Rochelle\r\nle requin gris', '', 'non', '', 7, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (5, '18bourges.jpg', 'simple.jpg', '', ' x', '1/039', '', 'Cathédrale Saint-Etienne de Bourges', '', 'non', '', 21, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (6, '18noirlac.jpg', '2005.jpg', '', ' x', 'non classé', '2005', 'Abbaye de noirlac\r\nl''art sistérien', '', 'oui', '', 16, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (7, '18stamand.jpg', '2005.jpg', '', ' x', 'non classé', '2005', 'La cité de l''or\r\nle lion gardien de la pyramide', '', 'oui', '', 11, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (8, '17larochelle2.jpg', '2003.jpg', '', ' x', '1/033', '2003', 'Tours de La Rochelle - face simple', '', 'non', '', 7, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (9, '17lesmathes.jpg', '2001.jpg', NULL, NULL, '1/034', '2001', 'Zoo la Palmyre - les éléphants', NULL, 'non', NULL, 6, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (10, '17lesmathes2.jpg', '2003.jpg', NULL, NULL, '1/035', '2003', 'Zoo la palmyre - la girafe et la mascotte', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (11, '17lesmathes3.jpg', '2002.jpg', NULL, NULL, '1/036', '2002', 'Zoo la Palmyre - le gorille', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (12, '17lesmathes4.jpg', '2003.jpg', NULL, NULL, '1/037', '2003', 'Zoo la Palmyre - les guépards', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (13, '17oleron.jpg', '2001.jpg', NULL, NULL, '1/032', '2001', 'Ile Oléron - Fort Boyard', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (14, '17oleron2.jpg', '2001.jpg', NULL, NULL, '3/203', '2001', 'Ile Oléron - Phare de Chassiron', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (15, '29brest.jpg', '2001.jpg', NULL, NULL, '1/057', '2001', 'Brest - Océanoplolis - le phoque', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (16, '50mtstmichel.jpg', 'simple.jpg', NULL, NULL, '3/229', '', 'Le Mont Saint Michel', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (17, '55verdun.jpg', 'simple.jpg', NULL, NULL, '2/098', '', 'Mémorial de verdun', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (18, '58chtchinon.jpg', '2002.jpg', NULL, NULL, '3/234', '2002', 'Musée du septennat', NULL, 'non', NULL, 3, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (19, '63clermontfd.jpg', '2005.jpg', NULL, NULL, '2/111', '2005', 'le Puy de Dôme', NULL, 'oui', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (20, '63mtdore.jpg', '2006.jpg', NULL, NULL, '2/113', '2006', 'Le Mont Dore - sommet du Puy de Sancy', NULL, 'oui', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (21, '63murol.jpg', '2006.jpg', NULL, NULL, '3/240', '2006', 'Le Château médiéval de Murol', NULL, 'oui', NULL, 4, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (22, '65lourdes.jpg', 'lourdes.jpg', NULL, NULL, '2/118', '', 'Sanctuaire Notre-dame', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (23, '75parisnotredame.jpg', '2000.jpg', NULL, NULL, '2/155', '2000', 'Notre-Dame de Paris - Vierge à l"enfant', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (24, '75parismuseearmee.jpg', '2001.jpg', NULL, NULL, '2/138', '2001', 'Musée de l armée - Tombeau de Napoléon', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (25, '75parismadeleine.jpg', '2001.jpg', NULL, NULL, '2/139', '2001', 'Eglise da la Madeleine', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (26, '75pariszoovincennes.jpg', '2001.jpg', NULL, NULL, '2/166', '2001', 'Parc zoologique de Paris', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (27, '75parissacrecoeur.jpg', '2001.jpg', NULL, NULL, '2/160', '2001', 'Basilique du Sacré-Coeur de Montmartre', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (28, '75pariscitescience.jpg', '2002.jpg', NULL, NULL, 'épuisé', '2002', 'Cité des Sciences - Poussières d Etoiles', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (29, '75pariscitescience2.jpg', '2003.jpg', NULL, NULL, '3/256', '2003', 'Cité des Sciences - Le Titanic', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (30, '77disneyland.jpg', '2003.jpg', NULL, NULL, '3/270', '2003', 'Disneyland Resort Paris - Le Château et Mickey', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (31, '77disneyland2.jpg', '2003.jpg', NULL, NULL, 'épuisé', '2003', 'Disneyland 2004', NULL, 'non', NULL, 0, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (32, '78versailles.jpg', '2004.jpg', NULL, NULL, '2/170', '2004', 'Château de Versailles', NULL, 'non', NULL, 2, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (33, '80amiens.jpg', '2001.jpg', NULL, NULL, '2/171', '2001', 'Cathédrale Notre-Dame à Amiens', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (34, '86futuroscope.jpg', '2001.jpg', NULL, NULL, '2/177', '2001', 'Futuroscope - Le parc européen de l image\r\npossède revers 2001 et 1999', NULL, 'non', NULL, 2, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (35, '89vezelay.jpg', '2002.jpg', NULL, NULL, '3/286', '2002', 'Basilique de la Madeleine', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (36, '92ladefense.jpg', '2000.jpg', NULL, NULL, '2/182', '2000', 'Le toit de la Grande Arche de la Défense', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (37, '98monaco.jpg', '2000.jpg', NULL, NULL, '2/190', '2000', 'La Cathédrale de Monaco - façade', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (38, '98monaco2.jpg', '2002.jpg', NULL, NULL, '2/191', '2002', 'Musée océanographique de Monaco - Navire', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (39, '98monaco3.jpg', '2001.jpg', NULL, NULL, '2/192', '2001', 'Palais Princier de Monaco', NULL, 'non', NULL, 1, 0); INSERT INTO `t_images` (`id_im`, `nom`, `verso`, `titre`, `taille`, `lamy`, `date`, `comment`, `cota`, `parte`, `embal`, `nb_vis`, `blocage`) VALUES (40, 'euro.jpg', '2001.jpg', NULL, NULL, '1/001', '2001', '1er jeton offert par la Monnaie de Paris avec les classeurs', NULL, 'non', NULL, 2, 0); -- -------------------------------------------------------- -- -- Structure de la table `t_news` -- CREATE TABLE `t_news` ( `id_news` smallint(6) NOT NULL auto_increment, `news` text NOT NULL, `date` date NOT NULL default '0000-00-00', PRIMARY KEY (`id_news`), KEY `id_news` (`id_news`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Contenu de la table `t_news` -- -- -------------------------------------------------------- -- -- Structure de la table `tj_cat_image` -- CREATE TABLE `tj_cat_image` ( `id_ima` smallint(6) NOT NULL default '0', `id_cat` smallint(6) NOT NULL default '0', PRIMARY KEY (`id_ima`,`id_cat`), KEY `id_ima` (`id_ima`,`id_cat`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Contenu de la table `tj_cat_image` -- INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (1, 1); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (2, 1); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (3, 3); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (4, 4); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (5, 5); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (6, 5); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (7, 5); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (8, 4); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (9, 4); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (10, 4); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (11, 4); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (12, 4); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (13, 4); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (14, 4); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (15, 6); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (16, 7); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (17, 8); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (18, 9); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (19, 10); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (20, 10); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (21, 10); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (22, 11); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (23, 12); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (24, 12); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (25, 12); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (26, 12); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (27, 12); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (28, 12); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (29, 12); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (30, 13); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (31, 13); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (32, 14); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (33, 2); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (34, 16); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (35, 17); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (36, 18); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (37, 19); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (38, 19); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (39, 19); INSERT INTO `tj_cat_image` (`id_ima`, `id_cat`) VALUES (40, 20);