-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Mardi 18 Juillet 2006 à 19:38
-- Version du serveur: 4.1.14
-- Version de PHP: 4.4.2-1+b1
-- 
-- Base de données: `pldaie`
-- 

-- --------------------------------------------------------

-- 
-- Structure de la table `formulaire_communes`
-- 

CREATE TABLE `formulaire_communes` (
  `id_commune` int(11) NOT NULL auto_increment,
  `id_groupe` int(11) NOT NULL default '0',
  `nom` varchar(100) NOT NULL default '',
  `date` varchar(100) NOT NULL default '',
  `valide` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id_commune`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

-- 
-- Contenu de la table `formulaire_communes`
-- 

INSERT INTO `formulaire_communes` VALUES (1, 1, 'Lille', '1152266610', '1');
INSERT INTO `formulaire_communes` VALUES (4, 1, 'Roubaix', '1152267364', '1');
INSERT INTO `formulaire_communes` VALUES (5, 1, 'Croix', '1152449901', '1');
INSERT INTO `formulaire_communes` VALUES (7, 1, 'Tourcoing', '1152479204', '');
INSERT INTO `formulaire_communes` VALUES (11, 1, 'Marquette', '1152480978', '');
INSERT INTO `formulaire_communes` VALUES (14, 4, 'Dunkerque', '1152530742', '');
INSERT INTO `formulaire_communes` VALUES (15, 4, 'Toto', '1152546247', '');
INSERT INTO `formulaire_communes` VALUES (16, 4, 'Titi', '1152546270', '');
INSERT INTO `formulaire_communes` VALUES (17, 0, 'Kathmandu', '1152690786', '1');
INSERT INTO `formulaire_communes` VALUES (18, 0, 'aurillac', '1152727134', '1');
INSERT INTO `formulaire_communes` VALUES (19, 0, 'lile', '1152801822', '');
INSERT INTO `formulaire_communes` VALUES (20, 0, 'Lyon', '1152874215', '1');

-- --------------------------------------------------------

-- 
-- Structure de la table `formulaire_formCCI_C`
-- 

CREATE TABLE `formulaire_formCCI_C` (
  `id` int(11) NOT NULL auto_increment,
  `id_acteur` int(11) NOT NULL default '0',
  `id_commune` int(100) NOT NULL default '0',
  `NBHAB` int(100) NOT NULL default '0',
  `DATE_VALIDITE` datetime NOT NULL default '0000-00-00 00:00:00',
  `DATE_VALIDATION` varchar(100) NOT NULL default '',
  `DATE_SAISIE` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

-- 
-- Contenu de la table `formulaire_formCCI_C`
-- 

INSERT INTO `formulaire_formCCI_C` VALUES (2, 1, 4, 120000, '2006-01-01 00:00:00', '1152471423', '1152471419');
INSERT INTO `formulaire_formCCI_C` VALUES (8, 1, 11, 4000, '2006-02-03 00:00:00', '1152551811', '1152480978');
INSERT INTO `formulaire_formCCI_C` VALUES (15, 1, 15, 120, '2006-07-29 00:00:00', '1152625929', '1152546247');
INSERT INTO `formulaire_formCCI_C` VALUES (17, 1, 1, 850000, '2006-05-18 00:00:00', '1153218219', '1153218206');
INSERT INTO `formulaire_formCCI_C` VALUES (16, 1, 16, 10, '2006-07-21 00:00:00', '1152625929', '1152546287');
INSERT INTO `formulaire_formCCI_C` VALUES (14, 1, 14, 65000, '2005-07-07 00:00:00', '1152625929', '1152530742');
INSERT INTO `formulaire_formCCI_C` VALUES (13, 1, 7, 45000, '2005-07-22 00:00:00', '1152625929', '1152530676');
INSERT INTO `formulaire_formCCI_C` VALUES (18, 1, 1, 350000, '2005-07-10 00:00:00', '1152551811', '1152551796');
INSERT INTO `formulaire_formCCI_C` VALUES (19, 1, 1, 150000, '2004-07-10 00:00:00', '1152553155', '1152552460');
INSERT INTO `formulaire_formCCI_C` VALUES (20, 1, 17, 1500000, '2006-07-07 00:00:00', '', '1152690786');
INSERT INTO `formulaire_formCCI_C` VALUES (21, 12, 1, 100000, '2006-03-01 00:00:00', '1152873560', '1152873528');
INSERT INTO `formulaire_formCCI_C` VALUES (22, 12, 4, 10000, '2006-07-10 00:00:00', '1152874167', '1152726748');
INSERT INTO `formulaire_formCCI_C` VALUES (23, 12, 15, 100000, '2006-07-03 00:00:00', '', '1152726882');
INSERT INTO `formulaire_formCCI_C` VALUES (24, 12, 18, 30000, '2006-07-03 00:00:00', '1152874176', '1152727134');
INSERT INTO `formulaire_formCCI_C` VALUES (25, 12, 19, 1000, '2006-07-25 00:00:00', '', '1152801822');
INSERT INTO `formulaire_formCCI_C` VALUES (27, 1, 5, 1000, '2006-07-05 00:00:00', '1152874181', '1152807540');
INSERT INTO `formulaire_formCCI_C` VALUES (28, 1, 11, 12, '2006-07-03 00:00:00', '', '1152807773');
INSERT INTO `formulaire_formCCI_C` VALUES (29, 1, 20, 1300000, '2006-07-28 00:00:00', '1152874227', '1152874215');
INSERT INTO `formulaire_formCCI_C` VALUES (31, 1, 18, 15000, '2006-07-19 00:00:00', '', '1153141536');

-- --------------------------------------------------------

-- 
-- Structure de la table `formulaire_formGroupCom`
-- 

CREATE TABLE `formulaire_formGroupCom` (
  `id_groupe` int(11) NOT NULL auto_increment,
  `id_acteur` int(11) NOT NULL default '0',
  `GROUPE` varchar(50) NOT NULL default '',
  `LISTE_COMMUNES` varchar(200) NOT NULL default '',
  `DATE_VALIDITE` datetime NOT NULL default '0000-00-00 00:00:00',
  `DATE_VALIDATION` varchar(50) NOT NULL default '',
  `DATE_SAISIE` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id_groupe`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Contenu de la table `formulaire_formGroupCom`
-- 

INSERT INTO `formulaire_formGroupCom` VALUES (1, 1, 'Communauté lilloise', 'Lille;Roubaix', '2006-04-18 00:00:00', '1153218250', '1153218247');
INSERT INTO `formulaire_formGroupCom` VALUES (4, 1, 'G10', 'Dunkerque;Toto;Titi', '2006-07-14 00:00:00', '1152625849', '1152625839');
INSERT INTO `formulaire_formGroupCom` VALUES (6, 12, 'ZA Pascal', 'Lille;Croix;Tourcoing', '2006-07-05 00:00:00', '', '1152806784');
INSERT INTO `formulaire_formGroupCom` VALUES (7, 1, 'gg', 'Kathmandu;aurillac;lile', '2006-07-28 00:00:00', '', '1152812229');

-- --------------------------------------------------------

-- 
-- Structure de la table `formulaire_formGroupCom_commune`
-- 

CREATE TABLE `formulaire_formGroupCom_commune` (
  `id_commune` int(11) NOT NULL default '0',
  `id_groupe` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `formulaire_formGroupCom_commune`
-- 

INSERT INTO `formulaire_formGroupCom_commune` VALUES (4, 1);
INSERT INTO `formulaire_formGroupCom_commune` VALUES (1, 1);