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
| --
-- Structure de la table 'fondscartes'
--
CREATE TABLE fondscartes (
FondIndex int(10) unsigned NOT NULL auto_increment,
FondNumOrdre char(2) NOT NULL default '',
FondLibelle varchar(100) NOT NULL default '',
FondNivGeo varchar(20) NOT NULL default '',
FondNomTable varchar(100) NOT NULL default '',
FondType varchar(10) NOT NULL default '',
FondProfondeur varchar(5) default NULL,
FondHierarchique binary(1) NOT NULL default '1',
FondMaillage binary(1) NOT NULL default '1',
FondProgramme varchar(50) default NULL,
PRIMARY KEY (FondIndex),
UNIQUE KEY I_FondNivGeo (FondNivGeo),
KEY I_FondNumOrdre (FondNumOrdre),
KEY I_FondLibelle (FondLibelle),
KEY I_FondProfondeur (FondProfondeur)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Fonds de cartes disponibles avec leur hiérarchie';
--
-- Contenu de la table 'fondscartes'
--
INSERT INTO fondscartes (FondIndex, FondNumOrdre, FondLibelle, FondNivGeo, FondNomTable, FondType, FondProfondeur, FondHierarchique, FondMaillage, FondProgramme) VALUES
(1, '1', 'canton', 'c', 'mifc', 'corr', '30', 0x31, 0x31, ''),
(2, '3', 'code 27 initial', 'c27a', 'mifc27a', 'corr', '20', 0x31, 0x30, ''),
(3, '11', 'grande région', 'gr', 'mifgr', 'corr', '80', 0x31, 0x30, ''),
(4, '10', 'région', 'r', 'mifr', 'corr', '70', 0x31, 0x31, ''),
(5, '5', 'arrondissement', 'a', 'mifa', 'corr', '40', 0x31, 0x30, ''),
(6, '8', 'département', 'd', 'mifd', 'corr', '60', 0x31, 0x31, ''),
(7, '0', 'commune', 'm', 'mifm', 'base', '10', 0x31, 0x31, ''),
(8, '4', 'code 27', 'c27', 'mifc27', 'calc', '25', 0x31, 0x31, 'fdsinfos_c27.php'),
(9, '17', 'CAD', 'cad', 'mifcad', 'corr', '55', 0x30, 0x31, ''),
(10, '19', 'PRA', 'pra', 'mifpra', 'corr', '55', 0x30, 0x31, ''),
(11, '21', 'PRA Département', 'prad', 'mifprad', 'corr', '50', 0x30, 0x31, ''),
(12, '23', 'Parc Naturel', 'pnr', 'mifpnr', 'corr', '55', 0x30, 0x31, ''),
(13, '25', 'PNR Département', 'pnrdep', 'mifpnrdep', 'corr', '50', 0x30, 0x31, ''),
(14, '27', 'Pays', 'pays', 'mifpays', 'corr', '55', 0x30, 0x31, ''),
(15, '29', 'INAT Département', 'inatdep', 'mifinatdep', 'corr', '50', 0x30, 0x31, ''),
(16, '31', 'DOCUP Département', 'docupdep', 'mifdocupdep', 'corr', '50', 0x30, 0x31, ''),
(17, '33', 'Bassin de vie', 'bv', 'mifbv', 'corr', '55', 0x30, 0x31, ''),
(18, '35', 'Zone emploi', 'ze', 'mifze', 'corr', '55', 0x30, 0x31, ''),
(19, '20', 'France', 'f', 'miff', 'corr', '90', 0x31, 0x31, ''),
(20, '37', 'Zone défavorisée', 'def', 'mifdef', 'corr', '55', 0x30, 0x31, ''),
(21, '39', 'bassin de vie Etic', 'bv2', 'mifbv2', 'corr', '55', 0x30, 0x31, ''),
(22, '45', 'Zone Vulnérable reg', 'zvr', 'mifzvr', 'corr', '65', 0x30, 0x31, ''),
(23, '43', 'Zone Vulnérable depa', 'zvd', 'mifzvd', 'corr', '50', 0x30, 0x31, ''),
(24, '47', 'Unités Urbaines', 'ua', 'mifua', 'corr', '55', 0x30, 0x31, ''),
(25, '49', 'SPIDE', 'spi', 'mifspi', 'corr', '45', 0x30, 0x31, ''),
(26, '51', 'bassin versant sud du Gers', 'bvgers', 'mifbvgers', 'corr', '45', 0x30, 0x31, ''),
(27, '53', 'cte aude tarn', 'cat', 'mifcat', 'corr', '55', 0x30, 0x31, ''),
(28, '55', 'INAT4 Département', 'inat4dep', 'mifinat4dep', 'corr', '50', 0x30, 0x31, ''),
(29, '57', 'Massif', 'massif', 'mifmassif', 'corr', '50', 0x30, 0x31, ''),
(30, '59', 'inter_région forestière', 'irf', 'mifirf', 'corr', '80', 0x31, 0x30, ''),
(31, '61', 'bassins laitiers', 'bl', 'mifbl', 'corr', '60', 0x31, 0x30, ''),
(32, '63', 'littoral', 'litto', 'miflitto', 'corr', '', 0x31, 0x31, ''),
(33, '65', 'Zone laitière', 'zl', 'mifzl', 'corr', '55', 0x30, 0x31, ''); |
Partager