-- Structure de la table `service`
--
CREATE TABLE `service` (
`id` int(255) NOT NULL auto_increment,
`id_user` int(255) NOT NULL,
`date_relance` int(255) NOT NULL,
`service` text NOT NULL,
`civilite` text NOT NULL,
`prenom` text NOT NULL,
`nom` text NOT NULL,
`fonction` text NOT NULL,
`telephone` int(15) NOT NULL,
`fax` int(15) NOT NULL,
`type_prestation` text NOT NULL,
`nbparticipant` int(255) NOT NULL,
`budgetppersonne` int(255) NOT NULL,
`clientmgp` int(11) NOT NULL,
`statut` text NOT NULL,
`note2` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12333 ;
-- Contenu de la table `service`
--
INSERT INTO `service` (`id`, `id_user`, `date_relance`, `service`, `civilite`, `prenom`, `nom`, `fonction`, `telephone`, `fax`, `type_prestation`, `nbparticipant`, `budgetppersonne`, `clientmgp`, `statut`, `note2`) VALUES
(1, 1, 1355266800, 'premier service', '8', '8', '8', '8', 0, 8, '8', 8, 8, 1, '8', ''),
(2, 2, 1280959200, 'administration', '', 'ue', '', '', 0, 0, '', 0, 0, 1, '', ''),
(3, 3, 1577833200, 'accueil', 'MME', 'CORINNE', 'LACOUR', 'Secretaire', 0, 0, '', 0, 0, 0, '', ''),
(12332, 15, -3600, 'service', 'civilite', 'prenom', 'nom', 'fonction', 111, 0, 'type prestation', 0, 0, 0, 'statut', 'bloc');
Partager