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
| --
-- Structure de la table `societe`
--
CREATE TABLE `societe` (
`idsoc` int(11) NOT NULL auto_increment,
`soc` varchar(80) NOT NULL,
`socrew` varchar(80) NOT NULL,
`key` varchar(80) NOT NULL,
`descsoc` varchar(250) NOT NULL,
`telsoc` varchar(30) NOT NULL,
`faxsoc` varchar(30) NOT NULL,
`horsoc` varchar(150) NOT NULL,
`adresse` varchar(150) NOT NULL,
`zipsoc` varchar(15) NOT NULL,
`villesoc` int(11) NOT NULL,
`mailsoc` varchar(150) NOT NULL,
`websoc` varchar(150) NOT NULL,
`valsoc` smallint(1) NOT NULL,
PRIMARY KEY (`idsoc`),
KEY `villesoc` (`villesoc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Contenu de la table `societe`
--
INSERT INTO `societe` (`idsoc`, `soc`, `socrew`, `key`, `descsoc`, `telsoc`, `faxsoc`, `horsoc`, `adresse`, `zipsoc`, `villesoc`, `mailsoc`, `websoc`, `valsoc`) VALUES
(1, 'toto', 'toto', 'plombier', 'desfkjzebgz', '0606060606', '0606060606', 'mlkrhe', 'rekh,etjhek', '64460', 1, 'toto@hotmail.com', 'http://www.toto.com', 1);
-- --------------------------------------------------------
--
-- Structure de la table `ville`
--
CREATE TABLE `ville` (
`idville` int(11) NOT NULL auto_increment,
`ville` varchar(100) NOT NULL,
`lat` float NOT NULL,
`long` float NOT NULL,
`zip` varchar(15) NOT NULL,
PRIMARY KEY (`idville`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Contenu de la table `ville`
--
INSERT INTO `ville` (`idville`, `ville`, `lat`, `long`, `zip`) VALUES
(1, ' aast ', 43.2833, -0.083333, '64460'),
(2, ' Abainville ', 48.5333, 5.5, '55130'); |
Partager