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
|
--
-- Structure de la table `contact`
--
CREATE TABLE IF NOT EXISTS `contact` (
`id_contact` int(11) NOT NULL AUTO_INCREMENT,
`statut` varchar(50) NOT NULL,
`civilite` varchar(15) NOT NULL,
`nom` varchar(150) DEFAULT NULL,
`prenom` varchar(150) NOT NULL,
`adresse` varchar(255) NOT NULL,
`codepostal` varchar(10) NOT NULL,
`ville` varchar(150) NOT NULL,
`suiteadresse` varchar(255) NOT NULL,
`email` varchar(150) DEFAULT NULL,
`sujet` varchar(255) DEFAULT NULL,
`message` text,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id_contact`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;
--
-- Contenu de la table `contact`
--
INSERT INTO `contact` (`id_contact`, `statut`, `civilite`, `nom`, `prenom`, `adresse`, `codepostal`, `ville`, `suiteadresse`, `email`, `sujet`, `message`, `date`) VALUES
(46, 'Société', 'Monsieur', 'XXXXX', 'yyyyy', '34 rue du fort', '75000', 'Paris', 'pt 233', 'xxx@orange.fr', 'bonjour', 'dtsuer', '2010-05-03 15:41:06'),
(47, 'Société', 'Monsieur', 'XXXXX', 'yyyyy', '34 rue du fort', '75000', 'Paris', 'pt 233', 'xxx@orange.fr', 'bonjour', 'dtsuer', '2010-05-03 15:42:06'),;
-- --------------------------------------------------------
--
-- Structure de la table `reponse_contact`
--
CREATE TABLE IF NOT EXISTS `reponse_contact` (
`id_reponse_contact` int(11) NOT NULL AUTO_INCREMENT,
`id_contact` int(11) NOT NULL,
`id_statut_rep` int(11) NOT NULL,
`sujet_rep` varchar(255) NOT NULL,
`message_rep` longtext NOT NULL,
`date_rep` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id_reponse_contact`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
--
-- Contenu de la table `reponse_contact`
--
INSERT INTO `reponse_contact` (`id_reponse_contact`, `id_contact`, `id_statut_rep`, `sujet_rep`, `message_rep`, `date_rep`) VALUES
(18, 47, 5, '', '', '2010-05-03 16:33:39'),
(17, 46, 1, '', '', '2010-05-03 16:34:03');
-- --------------------------------------------------------
--
-- Structure de la table `statut_rep`
--
CREATE TABLE IF NOT EXISTS `statut_rep` (
`id_statut_rep` int(11) NOT NULL AUTO_INCREMENT,
`statut_rep` varchar(20) NOT NULL,
PRIMARY KEY (`id_statut_rep`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Contenu de la table `statut_rep`
--
INSERT INTO `statut_rep` (`id_statut_rep`, `statut_rep`) VALUES
(1, 'Traité'),
(5, 'A voir'),
(4, 'En cours'); |
Partager