# Base de données openparc sur le serveur localhost
# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Serveur: localhost
# Généré le : Mardi 02 Novembre 2006 à 15:04
# Version du serveur: 4.0.18
# Version de PHP: 5.0.0
# 
# Base de données: `openparc`
# 
#
# --------------------------------------------------------

#
# Structure de la table `batiment`
#

CREATE TABLE `batiment` (
  `idbatiment` int(11) NOT NULL auto_increment,
  `libbatiment` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`idbatiment`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# Contenu de la table `batiment`
#

INSERT INTO `batiment` VALUES (1, 'JEAN GIONOT');
INSERT INTO `batiment` VALUES (2, 'HOTEL DE VILLE');
INSERT INTO `batiment` VALUES (3, 'ANNEXE DU CLOITRE');
INSERT INTO `batiment` VALUES (4, 'ANNEXE BALZE');
INSERT INTO `batiment` VALUES (5, '5 Av REPUBLIQUE');

# --------------------------------------------------------

#
# Structure de la table `batiment_seq`
#

CREATE TABLE `batiment_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# Contenu de la table `batiment_seq`
#

INSERT INTO `batiment_seq` VALUES (5);

# --------------------------------------------------------

#
# Structure de la table `collectivite`
#

CREATE TABLE `collectivite` (
  `ville` varchar(30) NOT NULL default '',
  `logo` varchar(40) NOT NULL default '',
  `maire` varchar(40) NOT NULL default '',
  `id` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `collectivite`
#

INSERT INTO `collectivite` VALUES ('LibreVille / mysql', '../dyn/custom/img/logo.png', 'O.PENPARC', 0);

# --------------------------------------------------------

#
# Structure de la table `departement`
#

CREATE TABLE `departement` (
  `iddepartement` int(8) NOT NULL default '0',
  `libdepartement` varchar(50) NOT NULL default '',
  `idorganisme` int(8) NOT NULL default '0',
  PRIMARY KEY  (`iddepartement`),
  KEY `idorganisme` (`idorganisme`)
) TYPE=MyISAM;

#
# Contenu de la table `departement`
#

INSERT INTO `departement` VALUES (3000, 'DIRECTION CULTURE & PATRIMOINE', 1);
INSERT INTO `departement` VALUES (4000, 'ECOLES', 3);
INSERT INTO `departement` VALUES (5000, 'DIRECTION DE L\' ADMINISTRATION GENERALE', 1);
INSERT INTO `departement` VALUES (6000, 'DIRECTION DES RESSOURCES HUMAINES', 1);

# --------------------------------------------------------

#
# Structure de la table `direction`
#

CREATE TABLE `direction` (
  `iddirection` int(8) NOT NULL default '0',
  `libdirection` varchar(50) NOT NULL default '',
  `iddepartement` int(8) NOT NULL default '0',
  PRIMARY KEY  (`iddirection`),
  KEY `iddepartement` (`iddepartement`)
) TYPE=MyISAM;

#
# Contenu de la table `direction`
#

INSERT INTO `direction` VALUES (3100, 'DIRECTION CULTURE & PATRIMOINE', 3000);
INSERT INTO `direction` VALUES (3200, 'MEDIATHEQUE', 3000);
INSERT INTO `direction` VALUES (4100, 'ECOLES ELEMENTAIRES', 4000);
INSERT INTO `direction` VALUES (5100, 'DIRECTION DE L\' ADMINISTRATION GENERALE', 5000);
INSERT INTO `direction` VALUES (6100, 'DIRECTION DES RESSOURCES HUMAINES', 6000);

# --------------------------------------------------------

#
# Structure de la table `direction_seq`
#

CREATE TABLE `direction_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Contenu de la table `direction_seq`
#


# --------------------------------------------------------

#
# Structure de la table `droit`
#

CREATE TABLE `droit` (
  `droit` varchar(30) NOT NULL default '',
  `profil` int(2) NOT NULL default '0',
  PRIMARY KEY  (`droit`)
) TYPE=MyISAM;

#
# Contenu de la table `droit`
#

INSERT INTO `droit` VALUES ('utilisateur', 5);
INSERT INTO `droit` VALUES ('droit', 5);
INSERT INTO `droit` VALUES ('profil', 5);
INSERT INTO `droit` VALUES ('collectivite', 4);

# --------------------------------------------------------

#
# Structure de la table `element`
#

CREATE TABLE `element` (
  `idelement` int(10) NOT NULL default '0',
  `idstation` int(10) NOT NULL default '0',
  `numero` varchar(7) NOT NULL default '',
  `notag` varchar(30) NOT NULL default '';  
  `nomelement` varchar(15) NOT NULL default '',
  `idmodele` int(8) NOT NULL default '0',
  `idutilisateur` int(8) NOT NULL default '0',
  `idservice` int(8) NOT NULL default '0',
  `idbatiment` int(8) NOT NULL default '0',
  `dateachat` date NOT NULL default '0000-00-00',
  `dateatelier` date NOT NULL default '0000-00-00',
  `datescan` date NOT NULL default '0000-00-00',
  `garantie` int(1) NOT NULL default '0',
  `idfournisseur` int(8) NOT NULL default '0',
  `bc` varchar(20) NOT NULL default '',
  `numserie` varchar(30) NOT NULL default '',
  `adressemac` varchar(40) NOT NULL default '',
  `fax` char(1) NOT NULL default 'f',
  `scanner` char(1) NOT NULL default 'f',
  `boitierext` char(1) NOT NULL default 'f',
  `version` varchar(10) NOT NULL default '',
  `idorganisme` int(8) NOT NULL default '1',
  `idetatelement` int(8) NOT NULL default '4',
  PRIMARY KEY  (`idelement`),
  KEY `idstationip` (`idstation`),
  KEY `idmodele` (`idmodele`),
  KEY `idutilisateur` (`idutilisateur`),
  KEY `idservice` (`idservice`),
  KEY `idbatiment` (`idbatiment`),
  KEY `idorganisme` (`idorganisme`)
) TYPE=MyISAM;

#
# Contenu de la table `element`
#

INSERT INTO `element` VALUES (1, 0, '0606001', 'HP4200CULT', 4, 0, 3110, 3, '2006-06-01', '0000-00-00', '0000-00-00', 1, 2, '33301D01234', 'HP230XG224', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (2, 0, '0606002', 'HP4200DRH', 4, 0, 6110, 4, '2005-06-10', '0000-00-00', '0000-00-00', 1, 1, '33501D0458', 'HP124DG32145', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (3, 0, '', '3456', 20, 2, 6110, 4, '2006-06-01', '0000-00-00', '0000-00-00', 1, 1, '33305D04879', '123SD456', '45:12:A8:45:48', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (4, 1, '', '', 18, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (5, 1, '', '', 19, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (6, 1, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (7, 1, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (8, 1, '', '', 15, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (9, 1, '', '', 5, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (10, 1, '', '', 26, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (11, 1, '', '', 24, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (12, 1, '', '', 27, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (13, 1, '', '', 28, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (14, 1, '', '', 2, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (15, 1, '', '', 1, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (16, 1, '', '', 3, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', 'YG12453', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (17, 2, '', '', 18, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (18, 2, '', '', 19, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (19, 2, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (20, 2, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (21, 2, '', '', 15, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (22, 2, '', '', 5, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (23, 2, '', '', 26, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (24, 2, '', '', 24, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (30, 3, '', '', 18, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (27, 2, '', '', 2, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (28, 2, '', '', 1, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (29, 2, '', '', 3, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', 'YPT1278', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (31, 3, '', '', 19, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (32, 3, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (33, 3, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (34, 3, '', '', 15, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (35, 3, '', '', 5, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (36, 3, '', '', 26, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (37, 3, '', '', 24, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (44, 4, '', '', 19, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (43, 4, '', '', 18, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (40, 3, '', '', 2, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (41, 3, '', '', 1, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (42, 3, '', '', 3, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', 'YPT9514', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (45, 4, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (46, 4, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (47, 4, '', '', 15, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (48, 4, '', '', 5, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (49, 4, '', '', 26, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (50, 4, '', '', 24, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (51, 4, '', '', 27, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (52, 4, '', '', 28, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (53, 4, '', '', 2, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (54, 4, '', '', 1, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (55, 4, '', '', 3, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', 'YGT12453', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (56, 5, '', '', 18, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (57, 5, '', '', 19, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (58, 5, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (59, 5, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (60, 5, '', '', 15, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (61, 5, '', '', 5, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (62, 5, '', '', 26, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (63, 5, '', '', 24, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (64, 5, '', '', 27, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (69, 6, '', '', 18, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (66, 5, '', '', 2, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (67, 5, '', '', 1, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (68, 5, '', '', 3, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', 'YPT1485', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (70, 6, '', '', 19, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (71, 6, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (72, 6, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (73, 6, '', '', 15, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (74, 6, '', '', 5, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (75, 6, '', '', 26, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (76, 6, '', '', 24, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (77, 6, '', '', 27, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (78, 6, '', '', 28, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (79, 6, '', '', 2, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (80, 6, '', '', 1, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (81, 6, '', '', 3, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', 'YPTT4562', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (82, 7, '', '', 18, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (83, 7, '', '', 19, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (84, 7, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (85, 7, '', '', 10, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (86, 7, '', '', 15, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (87, 7, '', '', 5, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (88, 7, '', '', 26, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (89, 7, '', '', 24, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (90, 7, '', '', 27, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (91, 7, '', '', 28, 0, 0, 0, '0000-00-00', '0000-00-00', '0000-00-00', 0, 0, '', '', '', 'f', 'f', 'f', '', 4, 1);
INSERT INTO `element` VALUES (92, 7, '', '', 2, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (93, 7, '', '', 1, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', '', '', 'f', 'f', 'f', '', 1, 1);
INSERT INTO `element` VALUES (94, 7, '', '', 3, 0, 0, 0, '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, '33301D0381', 'YPTTT456', '', 'f', 'f', 'f', '', 1, 1);

# --------------------------------------------------------

#
# Structure de la table `element_seq`
#

CREATE TABLE `element_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=95 ;

#
# Contenu de la table `element_seq`
#

INSERT INTO `element_seq` VALUES (94);

# --------------------------------------------------------

#
# Structure de la table `elementrebut`
#

CREATE TABLE `elementrebut` (
  `idelement` int(10) NOT NULL default '0',
  `idstation` int(10) NOT NULL default '0',
  `numero` varchar(7) NOT NULL default '',
  `idmodele` int(8) NOT NULL default '0',
  `dateachat` date NOT NULL default '0000-00-00',
  `daterebut` date NOT NULL default '0000-00-00',
  `garantie` int(1) NOT NULL default '0',
  `idfournisseur` int(8) NOT NULL default '0',
  `bc` varchar(20) NOT NULL default '',
  `numserie` varchar(20) NOT NULL default '',
  `adressemac` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`idelement`)
) TYPE=MyISAM;

#
# Contenu de la table `elementrebut`
#


# --------------------------------------------------------

#
# Structure de la table `elementrebut_seq`
#

CREATE TABLE `elementrebut_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Contenu de la table `elementrebut_seq`
#


# --------------------------------------------------------

#
# Structure de la table `etatintervention`
#

CREATE TABLE `etatintervention` (
  `idetat` int(8) NOT NULL default '0',
  `libetat` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`idetat`)
) TYPE=MyISAM;

#
# Contenu de la table `etatintervention`
#

INSERT INTO `etatintervention` VALUES (2, 'En cours');
INSERT INTO `etatintervention` VALUES (3, 'Cloturée');

# --------------------------------------------------------

#
# Structure de la table `etatmateriel`
#

CREATE TABLE `etatmateriel` (
  `idetat` int(8) NOT NULL default '0',
  `libetat` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`idetat`)
) TYPE=MyISAM;

#
# Contenu de la table `etatmateriel`
#

INSERT INTO `etatmateriel` VALUES (1, 'Affecté');
INSERT INTO `etatmateriel` VALUES (2, 'En panne');
INSERT INTO `etatmateriel` VALUES (3, 'En réparation');
INSERT INTO `etatmateriel` VALUES (4, 'En stock');

# --------------------------------------------------------

#
# Structure de la table `fournisseur`
#

CREATE TABLE `fournisseur` (
  `idfournisseur` int(8) NOT NULL default '0',
  `libfournisseur` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`idfournisseur`)
) TYPE=MyISAM;

#
# Contenu de la table `fournisseur`
#

INSERT INTO `fournisseur` VALUES (1, 'MICRO-SERVICE');
INSERT INTO `fournisseur` VALUES (2, 'UGAP');

# --------------------------------------------------------

#
# Structure de la table `fournisseur_seq`
#

CREATE TABLE `fournisseur_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Contenu de la table `fournisseur_seq`
#

INSERT INTO `fournisseur_seq` VALUES (2);

# --------------------------------------------------------

#
# Structure de la table `intervention`
#

CREATE TABLE `intervention` (
  `idintervention` int(16) NOT NULL default '0',
  `idstation` int(10) NOT NULL default '0',
  `idperipherique` int(10) NOT NULL default '0',
  `idtype` int(8) NOT NULL default '0',
  `iddemandeur` int(8) NOT NULL default '0',
  `idintervenant` int(8) NOT NULL default '0',
  `dateouverture` date NOT NULL default '0000-00-00',
  `datecloture` date NOT NULL default '0000-00-00',
  `observations` text NOT NULL,
  `idetatintervention` int(8) NOT NULL default '1',
  PRIMARY KEY  (`idintervention`),
  KEY `idstationip` (`idstation`),
  KEY `idperipherique` (`idperipherique`),
  KEY `iddemandeur` (`iddemandeur`)
) TYPE=MyISAM;

#
# Contenu de la table `intervention`
#

INSERT INTO `intervention` VALUES (1, 0, 1, 1, 0, 0, '2006-06-04', '2006-06-04', 'Mise en place du périphérique et affectation au service DIRECTION CULTURE & PATRIMOINE.', 3);
INSERT INTO `intervention` VALUES (2, 0, 2, 1, 0, 0, '2006-06-04', '2006-06-04', 'Mise en place du périphérique et affectation au service DIRECTION DES RESSOURCES HUMAINES.', 3);
INSERT INTO `intervention` VALUES (3, 0, 3, 1, 0, 0, '2006-06-04', '2006-06-04', 'Mise en place du périphérique et affectation à Albert DURAND.', 3);
INSERT INTO `intervention` VALUES (4, 1, 0, 7, 0, 0, '2006-06-04', '2006-06-04', 'Enregistrement du poste.', 3);
INSERT INTO `intervention` VALUES (5, 1, 0, 1, 2, 0, '2006-06-04', '2006-06-04', 'Mise en place du poste chez Albert DURAND.', 2);
INSERT INTO `intervention` VALUES (6, 2, 0, 7, 0, 0, '2006-06-04', '2006-06-04', 'Enregistrement du poste.', 3);
INSERT INTO `intervention` VALUES (7, 2, 0, 1, 0, 0, '2006-06-04', '2006-06-04', 'Mise en place du poste.', 2);
INSERT INTO `intervention` VALUES (8, 3, 0, 7, 0, 0, '2006-06-04', '2006-06-04', 'Enregistrement du poste.', 3);
INSERT INTO `intervention` VALUES (9, 3, 0, 1, 0, 0, '2006-06-04', '2006-06-04', 'Mise en place du poste.', 2);
INSERT INTO `intervention` VALUES (10, 4, 0, 7, 0, 0, '2006-06-04', '2006-06-04', 'Enregistrement du poste.', 3);
INSERT INTO `intervention` VALUES (11, 4, 0, 1, 10, 0, '2006-06-04', '2006-06-04', 'Mise en place du poste chez Julie BERTOLI.', 2);
INSERT INTO `intervention` VALUES (12, 5, 0, 7, 0, 0, '2006-06-04', '2006-06-04', 'Enregistrement du poste.', 3);
INSERT INTO `intervention` VALUES (13, 5, 0, 1, 3, 3, '2006-06-04', '2006-06-04', 'Mise en place du poste chez Sylvain DUPOND.', 3);
INSERT INTO `intervention` VALUES (14, 6, 0, 7, 0, 0, '2006-06-04', '2006-06-04', 'Enregistrement du poste.', 3);
INSERT INTO `intervention` VALUES (15, 6, 0, 1, 7, 6, '2006-06-04', '2006-06-04', 'Mise en place du poste chez Denise MARTIN.', 3);
INSERT INTO `intervention` VALUES (16, 6, 81, 5, 7, 4, '2006-06-05', '0000-00-00', 'Ecran ne s\'allume plus.', 2);
INSERT INTO `intervention` VALUES (17, 7, 0, 7, 0, 0, '2006-06-04', '2006-06-04', 'Enregistrement du poste.', 3);
INSERT INTO `intervention` VALUES (18, 7, 0, 1, 8, 3, '2006-06-04', '2006-06-04', 'Mise en place du poste chez Jeanne PELISSIER.', 3);

# --------------------------------------------------------

#
# Structure de la table `intervention_seq`
#

CREATE TABLE `intervention_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;

#
# Contenu de la table `intervention_seq`
#

INSERT INTO `intervention_seq` VALUES (18);

# --------------------------------------------------------

#
# Structure de la table `interventionrebut`
#

CREATE TABLE `interventionrebut` (
  `idintervention` int(16) NOT NULL default '0',
  `idstation` int(10) NOT NULL default '0',
  `idperipherique` int(10) NOT NULL default '0',
  `idtype` int(8) NOT NULL default '0',
  `iddemandeur` int(8) NOT NULL default '0',
  `idintervenant` int(8) NOT NULL default '0',
  `dateouverture` date NOT NULL default '0000-00-00',
  `datecloture` date NOT NULL default '0000-00-00',
  `observations` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`idintervention`)
) TYPE=MyISAM;

#
# Contenu de la table `interventionrebut`
#


# --------------------------------------------------------

#
# Structure de la table `interventionrebut_seq`
#

CREATE TABLE `interventionrebut_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Contenu de la table `interventionrebut_seq`
#


# --------------------------------------------------------

#
# Structure de la table `marque`
#

CREATE TABLE `marque` (
  `idmarque` int(8) NOT NULL default '0',
  `libmarque` varchar(50) NOT NULL default '',
  `publisheronly` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`idmarque`)
) TYPE=MyISAM;

#
# Contenu de la table `marque`
#

INSERT INTO `marque` VALUES (1, 'HEWLETT-PACKARD', 0);
INSERT INTO `marque` VALUES (2, 'MICROSOFT', 1);
INSERT INTO `marque` VALUES (3, 'OpenOffice.org', 1);
INSERT INTO `marque` VALUES (4, 'CISCO', 0);
INSERT INTO `marque` VALUES (0, 'GENERIQUE', 0);
INSERT INTO `marque` VALUES (5, 'EPSON', 0);
INSERT INTO `marque` VALUES (6, 'INTEL', 0);
INSERT INTO `marque` VALUES (7, 'AMD', 0);
INSERT INTO `marque` VALUES (8, 'SAMSUNG', 0);
INSERT INTO `marque` VALUES (9, 'LG', 0);
INSERT INTO `marque` VALUES (10, 'NORTON', 1);
INSERT INTO `marque` VALUES (11, 'ADOBE', 1);

# --------------------------------------------------------

#
# Structure de la table `marque_seq`
#

CREATE TABLE `marque_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

#
# Contenu de la table `marque_seq`
#

INSERT INTO `marque_seq` VALUES (11);

# --------------------------------------------------------

#
# Structure de la table `modeleelement`
#

CREATE TABLE `modeleelement` (
  `idmodele` int(8) NOT NULL default '0',
  `nature` varchar(25) NOT NULL default '',
  `classe` varchar(15) NOT NULL default '',
  `libmodele` varchar(80) NOT NULL default '',
  `chemin` varchar(50) NOT NULL default '',
  `taille` int(8) NOT NULL default '0',
  `vitesse` varchar(10) NOT NULL default '',
  `typecomp` varchar(20) NOT NULL default '0',
  `frequence` int(8) NOT NULL default '0',
  `couleur` char(1) NOT NULL default 'f',
  `reseau` char(1) NOT NULL default 'f',
  `idmarque` int(8) NOT NULL default '0',
  `nbpci` int(8) NOT NULL default '0',
  `nbpcie` int(8) NOT NULL default '0',
  `nbagp` int(8) NOT NULL default '0',
  `nbbank` int(8) NOT NULL default '0',
  `connecteur` varchar(20) NOT NULL default '',
  `format` varchar(5) NOT NULL default '',
  `integre` char(1) NOT NULL default 'f',
  `rank` smallint(8) NOT NULL default '0',
  PRIMARY KEY  (`idmodele`)
) TYPE=MyISAM;

#
# Contenu de la table `modeleelement`
#

INSERT INTO `modeleelement` VALUES (1, 'clavier', 'peripherique', 'Clavier PC/AT étendu (101/102 touches)', '', 0, '', 'PS2', 0, 'f', '', 0, 0, 0, 0, 0, '', '', 'f', 0);
INSERT INTO `modeleelement` VALUES (2, 'souris', 'peripherique', 'Souris compatible PS/2', '', 0, '', 'Boule', 0, 'f', 'f', 0, 0, 0, 0, 0, 'PS2', '', 'v', 0);
INSERT INTO `modeleelement` VALUES (3, 'ecran', 'peripherique', 'SAMSUNG 17\' SyncMaster', '', 17, '', 'LCD', 0, 'f', 'f', 8, 0, 0, 0, 0, '', '', 'v', 0);
INSERT INTO `modeleelement` VALUES (4, 'imprimante', 'peripherique', 'LaserJet 4200', '', 0, '', 'Laser', 0, 'f', 'v', 1, 0, 0, 0, 0, 'DB15', 'A4', 'f', 0);
INSERT INTO `modeleelement` VALUES (5, 'disquedur', 'composant', 'ExcelStor Technology J840 38.3Go', '', 39260, '7200', '0', 0, 'f', 'f', 0, 0, 0, 0, 0, 'IDE', '3.5', 'f', 3);
INSERT INTO `modeleelement` VALUES (6, 'disquedur', 'composant', 'IC35L060AVV207-0 37.3Go', '', 38146, '7200', '0', 0, 'f', 'f', 0, 0, 0, 0, 0, 'IDE', '3.5', 'f', 3);
INSERT INTO `modeleelement` VALUES (7, 'disquedur', 'composant', 'FUJITSU 3.0Go', '', 3090, '5400', '0', 0, 'f', 'f', 0, 0, 0, 0, 0, 'IDE', '3.5', 'f', 3);
INSERT INTO `modeleelement` VALUES (8, 'disquedur', 'composant', 'HDS722516VLAT80 153.4Go', '', 157065, '7200', '0', 0, 'f', 'f', 0, 0, 0, 0, 0, 'SerialATA', '3.5', 'f', 3);
INSERT INTO `modeleelement` VALUES (11, 'memoire', 'composant', 'DDRAM 512Mo (400)', '', 512, '', 'DDRAM', 400, 'f', 'f', 0, 0, 0, 0, 0, '', '', 'f', 2);
INSERT INTO `modeleelement` VALUES (9, 'memoire', 'composant', 'DDRAM 256Mo', '', 256, '', 'DDRAM', 0, 'f', 'f', 0, 0, 0, 0, 0, '', '', 'f', 2);
INSERT INTO `modeleelement` VALUES (10, 'memoire', 'composant', 'DDRAM 256Mo (400)', '', 256, '', 'DDRAM', 400, 'f', 'f', 0, 0, 0, 0, 0, '', '', 'f', 2);
INSERT INTO `modeleelement` VALUES (12, 'memoire', 'composant', 'DDRAM 256Mo (266)', '', 256, '', 'DDRAM', 266, 'f', 'f', 0, 0, 0, 0, 0, '', '', 'f', 2);
INSERT INTO `modeleelement` VALUES (13, 'processeur', 'composant', 'Pentium 4 2.80GHz(800) Socket478', '', 0, '800', '0', 2800, 'f', 'f', 6, 0, 0, 0, 0, 'Socket478', '', 'f', 1);
INSERT INTO `modeleelement` VALUES (14, 'processeur', 'composant', 'Celeron 2.00GHz(100) Socket478', '', 0, '100', '0', 2000, 'f', 'f', 6, 0, 0, 0, 0, 'Socket478', '', 'f', 1);
INSERT INTO `modeleelement` VALUES (15, 'processeur', 'composant', 'Celeron 2.53GHz(133) Socket478', '', 0, '133', '0', 2533, 'f', 'f', 6, 0, 0, 0, 0, 'Socket478', '', 'f', 1);
INSERT INTO `modeleelement` VALUES (16, 'processeur', 'composant', 'Pentium III 566MHz(100) Slot1', '', 0, '100', '0', 566, 'f', 'f', 6, 0, 0, 0, 0, 'Slot1', '', 'f', 1);
INSERT INTO `modeleelement` VALUES (18, 'floppy', 'composant', 'Lecteur disquettes 3\'1/2', '', 0, '', '0', 0, 'f', 'f', 0, 0, 0, 0, 0, '', '', 'f', 0);
INSERT INTO `modeleelement` VALUES (17, 'ecran', 'peripherique', 'LG FLATRON L1715S', '', 17, '', 'LCD', 0, 'f', 'f', 9, 0, 0, 0, 0, '', '', 'f', 0);
INSERT INTO `modeleelement` VALUES (19, 'lecteuroptique', 'composant', 'Lecteur CD', '', 0, 'Inconnu', 'CD', 0, 'f', 'f', 0, 0, 0, 0, 0, 'IDE', '', 'f', 4);
INSERT INTO `modeleelement` VALUES (20, 'telephone', 'telecom', 'CISCO 7940 Series', '', 0, '', '0', 0, 'f', 'f', 4, 0, 0, 0, 0, '', '', 'f', 0);
INSERT INTO `modeleelement` VALUES (21, 'station', 'station', 'Assembleur', '', 0, '', '0', 0, 'f', 'f', 0, 0, 0, 0, 0, '', '', 'f', 0);
INSERT INTO `modeleelement` VALUES (23, 'systeme', 'logiciel', 'Windows XP Professionnel SP2', '', 0, '', '0', 0, 'f', '', 0, 0, 0, 0, 0, '', '', 'f', 0);
INSERT INTO `modeleelement` VALUES (24, 'logiciel', 'logiciel', 'Open Office 2.0', '', 0, '', '0', 0, 'f', 'v', 3, 0, 0, 0, 0, '', '', 'v', 0);
INSERT INTO `modeleelement` VALUES (25, 'logiciel', 'logiciel', 'Symantec Antivirus', '', 0, '', '0', 0, 'f', 'v', 10, 0, 0, 0, 0, '', '', 'v', 0);
INSERT INTO `modeleelement` VALUES (26, 'logiciel', 'logiciel', 'Acrobat Reader', '', 0, '', '0', 0, 'f', 'f', 0, 0, 0, 0, 0, '', '', 'v', 0);
INSERT INTO `modeleelement` VALUES (27, 'logiciel', 'logiciel', 'Oracle 8i', '', 0, '', '0', 0, 'f', 'v', 0, 0, 0, 0, 0, '', '', 'v', 0);
INSERT INTO `modeleelement` VALUES (28, 'logiciel', 'logiciel', 'Sedit Marianne Finances', '', 0, '', '0', 0, 'f', 'v', 0, 0, 0, 0, 0, '', '', 'v', 0);
INSERT INTO `modeleelement` VALUES (29, 'systeme', 'logiciel', 'Windows NT SP6', '', 0, '', '0', 0, 'f', '', 2, 0, 0, 0, 0, '', '', 'f', 0);

# --------------------------------------------------------

#
# Structure de la table `modeleelement_seq`
#

CREATE TABLE `modeleelement_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=30 ;

#
# Contenu de la table `modeleelement_seq`
#

INSERT INTO `modeleelement_seq` VALUES (29);

# --------------------------------------------------------

#
# Structure de la table `modelestation`
#

CREATE TABLE `modelestation` (
  `idmodelestation` int(8) NOT NULL default '0',
  `libmodelestation` varchar(30) NOT NULL default '',
  `idorganisme` int(8) NOT NULL default '0';  
  `idmodele` int(16) NOT NULL default '0',
  `idmarque` int(10) NOT NULL default '0',
  `idtypestation` int(8) NOT NULL default '0',
  `idsysteme` int(16) NOT NULL default '0',
  `dateachat` date NOT NULL default '0000-00-00',
  `idfournisseur` varchar(10) NOT NULL default '',
  `bc` varchar(20) NOT NULL default '',
  `garantie` int(1) NOT NULL default '0',
  `idscomp` varchar(100) NOT NULL default '',
  `idslogi` varchar(100) NOT NULL default '',
  `idsperi` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`idmodelestation`)
) TYPE=MyISAM;

#
# Contenu de la table `modelestation`
#

INSERT INTO `modelestation` VALUES (1, 'Micro-Service 01/06/06', 21, 0, 1, 23, '2006-06-01', '1', '33301D0381', 3, '18,19,10,10,15,5', '26,24,27,28', '2,1,3');

# --------------------------------------------------------

#
# Structure de la table `modelestation_seq`
#

CREATE TABLE `modelestation_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Contenu de la table `modelestation_seq`
#

INSERT INTO `modelestation_seq` VALUES (1);

# --------------------------------------------------------

#
# Structure de la table `naturecomposant`
#

CREATE TABLE `naturecomposant` (
  `idnature` int(8) NOT NULL default '0',
  `nature` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`idnature`)
) TYPE=MyISAM;

#
# Contenu de la table `naturecomposant`
#


# --------------------------------------------------------

#
# Structure de la table `organisme`
#

CREATE TABLE `organisme` (
  `idorganisme` int(8) NOT NULL default '0',
  `liborganisme` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`idorganisme`)
) TYPE=MyISAM;

#
# Contenu de la table `organisme`
#

INSERT INTO `organisme` VALUES (1, 'VILLE');
INSERT INTO `organisme` VALUES (2, 'INTERCO');
INSERT INTO `organisme` VALUES (3, 'ECOLES');

# --------------------------------------------------------

#
# Structure de la table `organisme_seq`
#

CREATE TABLE `organisme_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Contenu de la table `organisme_seq`
#

INSERT INTO `organisme_seq` VALUES (3);

# --------------------------------------------------------

#
# Structure de la table `personnel`
#

CREATE TABLE `personnel` (
  `idutilisateur` int(8) NOT NULL default '0',
  `prenom` varchar(30) NOT NULL default '',
  `nom` varchar(30) NOT NULL default '',
  `idserviceou` int(8) NOT NULL default '0',
  `login` varchar(30) NOT NULL default '',
  `intervenant` char(1) NOT NULL default 'f',
  `telephone` varchar(10) NOT NULL default '',
  `datescan` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`idutilisateur`),
  KEY `idserviceou` (`idserviceou`)
) TYPE=MyISAM;

#
# Contenu de la table `personnel`
#

INSERT INTO `personnel` VALUES (1, 'René', 'VIDAL', 0, '', 'f', '', '0000-00-00');
INSERT INTO `personnel` VALUES (2, 'Albert', 'DURAND', 0, '', 'f', '', '0000-00-00');
INSERT INTO `personnel` VALUES (3, 'Sylvain', 'DUPOND', 0, '', 'v', '', '0000-00-00');
INSERT INTO `personnel` VALUES (4, 'Alphonse', 'GREGOIRE', 0, '', 'v', '', '0000-00-00');
INSERT INTO `personnel` VALUES (5, 'Gabriel', 'GONZALEZ', 0, '', 'f', '', '0000-00-00');
INSERT INTO `personnel` VALUES (6, 'Patricia', 'GIULI', 0, '', 'v', '', '0000-00-00');
INSERT INTO `personnel` VALUES (7, 'Denise', 'MARTIN', 0, '', 'f', '', '0000-00-00');
INSERT INTO `personnel` VALUES (8, 'Jeanne', 'PELISSIER', 0, '', 'f', '', '0000-00-00');
INSERT INTO `personnel` VALUES (9, 'Christine', 'BERNARD', 0, '', 'f', '', '0000-00-00');
INSERT INTO `personnel` VALUES (10, 'Julie', 'BERTOLI', 0, '', 'f', '', '0000-00-00');

# --------------------------------------------------------

#
# Structure de la table `personnel_seq`
#

CREATE TABLE `personnel_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

#
# Contenu de la table `personnel_seq`
#

INSERT INTO `personnel_seq` VALUES (10);

# --------------------------------------------------------

#
# Structure de la table `profil`
#

CREATE TABLE `profil` (
  `profil` int(2) NOT NULL default '0',
  `libelle_profil` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`profil`)
) TYPE=MyISAM;

#
# Contenu de la table `profil`
#

INSERT INTO `profil` VALUES (5, 'ADMINISTRATEUR');
INSERT INTO `profil` VALUES (4, 'SUPER UTILISATEUR');
INSERT INTO `profil` VALUES (3, 'UTILISATEUR');
INSERT INTO `profil` VALUES (2, 'UTILISATEUR LIMITE');
INSERT INTO `profil` VALUES (1, 'CONSULTATION');

# --------------------------------------------------------

#
# Structure de la table `requete`
#

CREATE TABLE `requete` (
  `idrequete` int(8) NOT NULL default '0',
  `librequete` varchar(50) NOT NULL default '',
  `naturemateriel` varchar(20) NOT NULL default '',
  `reseaumairie` varchar(20) NOT NULL default '',
  `etataffectation` varchar(20) NOT NULL default '',
  `etatintervention` varchar(20) NOT NULL default '',
  `datedebut` date NOT NULL default '0000-00-00',
  `datefin` date NOT NULL default '0000-00-00',
  `idsrecherche` varchar(100) NOT NULL default '',
  `tablerecherche` varchar(20) NOT NULL default '',
  `idsrecherche2` varchar(100) NOT NULL default '',
  `tablerecherche2` varchar(20) NOT NULL default '',
  `souschaprecherche` varchar(30) NOT NULL default '',
  `souschaprecherche2` varchar(30) NOT NULL default '',
  `organisme` int( 8 ) NOT NULL default '0',
  `trigeneral` varchar( 20 ) NOT NULL default 'Alpha',
  PRIMARY KEY  (`idrequete`),
  KEY `organisme` (`organisme`)
) TYPE=MyISAM;

#
# Contenu de la table `requete`
#


# --------------------------------------------------------

#
# Structure de la table `requete_seq`
#

CREATE TABLE `requete_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Contenu de la table `requete_seq`
#


# --------------------------------------------------------

#
# Structure de la table `service`
#

CREATE TABLE `service` (
  `idservice` int(8) NOT NULL default '0',
  `libservice` varchar(50) NOT NULL default '',
  `iddirection` int(8) NOT NULL default '0',
  `scolaire` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`idservice`),
  KEY `iddirection` (`iddirection`)
) TYPE=MyISAM;

#
# Contenu de la table `service`
#

INSERT INTO `service` VALUES (3110, 'DIRECTION CULTURE & PATRIMOINE', 3100, 0);
INSERT INTO `service` VALUES (3120, 'THEATRE MUNICIPAL', 3100, 0);
INSERT INTO `service` VALUES (3130, 'INTERVENTIONS CULTURELLES', 3100, 0);
INSERT INTO `service` VALUES (3210, 'MEDIATHEQUE', 3200, 0);
INSERT INTO `service` VALUES (3220, 'MEDIATHEQUE (Kiosque)', 3200, 0);
INSERT INTO `service` VALUES (4110, 'ECOLES MATERNELLES (Directeur)', 4100, 1);
INSERT INTO `service` VALUES (4120, 'ECOLES PRIMAIRES (Salle)', 4100, 1);
INSERT INTO `service` VALUES (5110, 'DSIT', 5100, 0);
INSERT INTO `service` VALUES (5111, 'DSIT (Serveur)', 5100, 0);
INSERT INTO `service` VALUES (5112, 'DSIT (Formation)', 5100, 0);
INSERT INTO `service` VALUES (6110, 'DIRECTION DES RESSOURCES HUMAINES', 6100, 0);
INSERT INTO `service` VALUES (6120, 'PILOTAGE FINANCIER', 6100, 0);

# --------------------------------------------------------

#
# Structure de la table `service_seq`
#

CREATE TABLE `service_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Contenu de la table `service_seq`
#


# --------------------------------------------------------

#
# Structure de la table `serviceou`
#

CREATE TABLE `serviceou` (
  `idserviceou` int(8) NOT NULL default '0',
  `libserviceou` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`idserviceou`)
) TYPE=MyISAM;

#
# Contenu de la table `serviceou`
#


# --------------------------------------------------------

#
# Structure de la table `serviceou_seq`
#

CREATE TABLE `serviceou_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Contenu de la table `serviceou_seq`
#


# --------------------------------------------------------

#
# Structure de la table `station`
#

CREATE TABLE `station` (
  `idstation` int(10) NOT NULL default '0',
  `numero` varchar(7) NOT NULL default '0',
  `notag` varchar(30) NOT NULL default '';    
  `nomstation` varchar(20) NOT NULL default '',
  `idutilisateur` int(8) NOT NULL default '0',
  `idservice` int(8) NOT NULL default '0',
  `idbatiment` int(8) NOT NULL default '0',
  `idtypestation` int(8) NOT NULL default '0',
  `numserie` varchar(30) NOT NULL default '',
  `dateachat` date NOT NULL default '0000-00-00',
  `dateatelier` date NOT NULL default '0000-00-00',
  `datescan` date NOT NULL default '0000-00-00',
  `garantie` int(1) NOT NULL default '0',
  `idfournisseur` int(8) NOT NULL default '0',
  `idmodele` int(8) NOT NULL default '0',
  `idmarque` int(8) NOT NULL default '0',
  `idsysteme` int(8) NOT NULL default '0',
  `seriesysteme` varchar(30) NOT NULL default '',
  `bc` varchar(15) NOT NULL default '',
  `ipecole` varchar(15) NOT NULL default '',
  `idetatstation` int(8) NOT NULL default '4',
  `idorganisme` int(8) NOT NULL default '1',
  PRIMARY KEY  (`idstation`),
  KEY `idutilisateur` (`idutilisateur`),
  KEY `idservice` (`idservice`),
  KEY `idsysteme` (`idsysteme`),
  KEY `idbatiment` (`idbatiment`),
  KEY `idorganisme` (`idorganisme`)
) TYPE=MyISAM;

#
# Contenu de la table `station`
#

INSERT INTO `station` VALUES (1, '0606003', 'DRH-1', 2, 6110, 4, 1, '', '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, 21, 0, 23, '', '33301D0381', '', 1, 1);
INSERT INTO `station` VALUES (2, '0606004', 'GIONOT-1', 0, 4120, 1, 1, '', '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, 21, 0, 23, '', '33301D0381', '10.0.0.1', 1, 3);
INSERT INTO `station` VALUES (3, '0606005', 'GIONOT-2', 0, 4120, 1, 1, '', '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, 21, 0, 23, '', '33301D0381', '', 1, 3);
INSERT INTO `station` VALUES (4, '0606006', 'CULTURE-1', 10, 3110, 3, 1, '', '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, 21, 0, 23, '', '33301D0381', '', 1, 1);
INSERT INTO `station` VALUES (5, '0606007', 'DSIT-1', 3, 5110, 2, 1, '', '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, 21, 0, 23, '', '33301D0381', '', 1, 1);
INSERT INTO `station` VALUES (6, '0606008', 'PILOTAGE-2', 7, 6120, 4, 1, '', '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, 21, 0, 23, '', '33301D0381', '', 1, 1);
INSERT INTO `station` VALUES (7, '0606009', 'THEATRE-1', 8, 3120, 2, 1, '', '2006-06-01', '0000-00-00', '0000-00-00', 3, 1, 21, 0, 23, '', '33301D0381', '', 1, 1);

# --------------------------------------------------------

#
# Structure de la table `station_seq`
#

CREATE TABLE `station_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

#
# Contenu de la table `station_seq`
#

INSERT INTO `station_seq` VALUES (7);

# --------------------------------------------------------

#
# Structure de la table `stationad`
#

CREATE TABLE `stationad` (
  `idstationad` int(16) NOT NULL default '0',
  `nomstationad` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`idstationad`)
) TYPE=MyISAM;

#
# Contenu de la table `stationad`
#


# --------------------------------------------------------

#
# Structure de la table `stationad_seq`
#

CREATE TABLE `stationad_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Contenu de la table `stationad_seq`
#


# --------------------------------------------------------

#
# Structure de la table `stationrebut`
#

CREATE TABLE `stationrebut` (
  `idstation` int(10) NOT NULL default '0',
  `numero` varchar(7) NOT NULL default '0',
  `idtypestation` int(8) NOT NULL default '0',
  `numserie` varchar(20) NOT NULL default '',
  `dateachat` date NOT NULL default '0000-00-00',
  `daterebut` date NOT NULL default '0000-00-00',
  `garantie` int(1) NOT NULL default '0',
  `idfournisseur` int(8) NOT NULL default '0',
  `idmodele` int(8) NOT NULL default '0',
  `idmarque` int(8) NOT NULL default '0',
  `bc` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`idstation`)
) TYPE=MyISAM;

#
# Contenu de la table `stationrebut`
#


# --------------------------------------------------------

#
# Structure de la table `stationrebut_seq`
#

CREATE TABLE `stationrebut_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Contenu de la table `stationrebut_seq`
#


# --------------------------------------------------------

#
# Structure de la table `tcpip`
#

CREATE TABLE `tcpip` (
  `idip` int(12) NOT NULL default '0',
  `idstation` int(10) NOT NULL default '0',
  `idperipherique` int(10) NOT NULL default '0',
  `adresseip` varchar(15) NOT NULL default '',
  `ipa` int(8) NOT NULL default '0',
  `ipb` int(8) NOT NULL default '0',
  `ipc` int(8) NOT NULL default '0',
  `ipd` int(8) NOT NULL default '0',
  `ipmaitre` char(1) NOT NULL default 'v',
  PRIMARY KEY  (`idip`),
  KEY `idstationip` (`idstation`),
  KEY `idperipherique` (`idperipherique`)
) TYPE=MyISAM;

#
# Contenu de la table `tcpip`
#

INSERT INTO `tcpip` VALUES (1, 0, 1, '10.1.3.28', 10, 1, 3, 28, 'v');
INSERT INTO `tcpip` VALUES (2, 0, 2, '10.1.2.34', 10, 1, 2, 34, 'v');
INSERT INTO `tcpip` VALUES (3, 1, 0, '10.1.2.1', 10, 1, 2, 1, 'v');
INSERT INTO `tcpip` VALUES (4, 4, 0, '10.1.3.1', 10, 1, 3, 1, 'v');
INSERT INTO `tcpip` VALUES (5, 5, 0, '10.1.0.1', 10, 1, 0, 1, 'v');
INSERT INTO `tcpip` VALUES (6, 6, 0, '10.1.2.2', 10, 1, 2, 2, 'v');

# --------------------------------------------------------

#
# Structure de la table `tcpip_seq`
#

CREATE TABLE `tcpip_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

#
# Contenu de la table `tcpip_seq`
#

INSERT INTO `tcpip_seq` VALUES (6);

# --------------------------------------------------------

#
# Structure de la table `typeintervention`
#

CREATE TABLE `typeintervention` (
  `idtype` int(2) NOT NULL default '0',
  `libtype` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`idtype`)
) TYPE=MyISAM;

#
# Contenu de la table `typeintervention`
#

INSERT INTO `typeintervention` VALUES (1, 'Mise en place');
INSERT INTO `typeintervention` VALUES (2, 'Retour en atelier');
INSERT INTO `typeintervention` VALUES (3, 'Réinstallation syst.');
INSERT INTO `typeintervention` VALUES (4, 'Logiciel');
INSERT INTO `typeintervention` VALUES (5, 'Matériel');
INSERT INTO `typeintervention` VALUES (6, 'Mise au rebut');
INSERT INTO `typeintervention` VALUES (7, 'Enregistrement');
INSERT INTO `typeintervention` VALUES (8, 'Dépot pour réparation');
INSERT INTO `typeintervention` VALUES (9, 'Système');
INSERT INTO `typeintervention` VALUES (10, 'Réseau');
INSERT INTO `typeintervention` VALUES (11, 'Bureautique');
INSERT INTO `typeintervention` VALUES (12, 'Retour en stock');

# --------------------------------------------------------

#
# Structure de la table `typestation`
#

CREATE TABLE `typestation` (
  `idtypestation` int(8) NOT NULL default '0',
  `libtypestation` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`idtypestation`)
) TYPE=MyISAM;

#
# Contenu de la table `typestation`
#

INSERT INTO `typestation` VALUES (1, 'Client');
INSERT INTO `typestation` VALUES (3, 'Portable');
INSERT INTO `typestation` VALUES (4, 'Serveur');
INSERT INTO `typestation` VALUES (6, 'Terminal');

# --------------------------------------------------------

#
# Structure de la table `utilisateur`
#

CREATE TABLE `utilisateur` (
  `idUtilisateur` int(8) NOT NULL default '0',
  `nom` varchar(30) NOT NULL default '',
  `Login` varchar(30) NOT NULL default '',
  `Pwd` varchar(100) NOT NULL default '',
  `profil` int(2) NOT NULL default '0',
  PRIMARY KEY  (`idUtilisateur`)
) TYPE=MyISAM COMMENT='Liste utilisateurs';

#
# Contenu de la table `utilisateur`
#

INSERT INTO `utilisateur` VALUES (3, 'util', 'util', '05c7e24700502a079cdd88012b5a76d3', 3);
INSERT INTO `utilisateur` VALUES (6, 'demo', 'demo', 'fe01ce2a7fbac8fafaed7c982a04e229', 5);

# --------------------------------------------------------

#
# Structure de la table `utilisateur_seq`
#

CREATE TABLE `utilisateur_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

#
# Contenu de la table `utilisateur_seq`
#

INSERT INTO `utilisateur_seq` VALUES (6);
    