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
| --
-- Structure de la table `ville`
--
CREATE TABLE IF NOT EXISTS `xzclf_areas` (
`areaid` smallint(5) unsigned NOT NULL auto_increment,
`cityid` smallint(5) unsigned NOT NULL default '0',
`pos` smallint(5) unsigned NOT NULL default '0',
`areaname` varchar(50) NOT NULL default '',
`cp` varchar(6) NOT NULL default '',
`lat` float(7,6) NOT NULL default '',
`lon` float(7,6) NOT NULL default '',
`enabled` enum('0','1') NOT NULL default '0',
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`areaid`),
KEY `pos` (`pos`),
KEY `cityid` (`cityid`),
KEY `enabled` (`enabled`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=34488 ;
INSERT INTO `xzclf_areas` (`areaid`, `cityid`, `pos`, `areaname`, `cp`, `lat`, `lon`, `enabled`, `timestamp`) VALUES
(1, 1, 'Amareins', '01090', 9.999999, 4.783514, '1', '2008-12-03 01:02:56'),
(2, 1, 'Ambérieu-en-Bugey', '01500', 9.999999, 5.358829, '1', '2008-12-03 01:02:56'),
(3, 1, 'Ambérieux-en-Dombes', '01330', 9.999999, 4.903213, '1', '2008-12-03 01:02:56'),
(4, 1, 'Ambléon', '01300', 9.999999, 5.601381, '1', '2008-12-03 01:02:56'),
(5, 1, 'Ambronay', '01500', 9.999999, 5.360247, '1', '2008-12-03 01:02:56'),
(6, 1, 'Ambutrix', '01500', 9.999999, 5.338468, '1', '2008-12-03 01:02:56'),
(7, 1, 'Andert-et-Condon', '01300', 9.999999, 5.654058, '1', '2008-12-03 01:02:56'),
(8, 1, 'Anglefort', '01350', 9.999999, 5.808989, '1', '2008-12-03 01:02:56'),
Environ 34 000 lignes |
Partager