Location: PHPKode > projects > VIRTUAL.ID > Data Base/Script_BD.txt
-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Mardi 03 Juillet 2007 à 16:24
-- Version du serveur: 4.1.9
-- Version de PHP: 4.3.10
-- 
-- Base de données: `base_user_pfe`
-- 

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

-- 
-- Structure de la table `annuaires`
-- 

CREATE TABLE `annuaires` (
  `id_dir` int(3) NOT NULL auto_increment,
  `name_dir` varchar(25) NOT NULL default '',
  `provider_dir` varchar(200) NOT NULL default '',
  `user_dir` varchar(100) NOT NULL default '',
  `pwd_dir` varchar(100) NOT NULL default '',
  `dn_dir` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id_dir`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Contenu de la table `annuaires`
-- 

INSERT INTO `annuaires` VALUES (1, 'OpenLdap', 'ldap://localhost:389/o=pfe,c=tn', 'cn=marouen,o=pfe,c=tn', 'secret', 'o=direction2,o=min1,o=ministry');
INSERT INTO `annuaires` VALUES (2, 'ApacheDS', 'ldap://localhost:10390/o=pfe,c=tn', 'uid=admin,ou=system', 'secret', 'o=direction3,o=min2,o=ministry');

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

-- 
-- Structure de la table `appartenance`
-- 

CREATE TABLE `appartenance` (
  `id_app` int(4) NOT NULL auto_increment,
  `name_att` varchar(25) NOT NULL default '',
  `name_show_att` varchar(25) NOT NULL default '',
  `name_oc` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`id_app`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ;

-- 
-- Contenu de la table `appartenance`
-- 

INSERT INTO `appartenance` VALUES (58, 'description', 'Commentaires', 'Person');
INSERT INTO `appartenance` VALUES (57, 'dmdName', 'Date de naissance', 'Person');
INSERT INTO `appartenance` VALUES (88, 'personalTitle', 'Salaire', 'Pret');
INSERT INTO `appartenance` VALUES (55, 'mobile', 'Telphone Mobile', 'Organization');
INSERT INTO `appartenance` VALUES (54, 'carLicense', 'Numéro Permis', 'Organization');
INSERT INTO `appartenance` VALUES (80, 'email', 'E-Mail', 'Person');
INSERT INTO `appartenance` VALUES (52, 'gidNumber', 'Nombre enfant(s)', 'Organization');
INSERT INTO `appartenance` VALUES (86, 'postalAddress', 'Adresse', 'Pret');
INSERT INTO `appartenance` VALUES (87, 'documentIdentifier', 'Matricule CNSS', 'Pret');
INSERT INTO `appartenance` VALUES (49, 'uniqueIdentifier', 'CIN', 'Organization');
INSERT INTO `appartenance` VALUES (79, 'documentIdentifier', 'Matricule CNSS', 'Santé');
INSERT INTO `appartenance` VALUES (45, 'cn', 'Nom', 'Organization');
INSERT INTO `appartenance` VALUES (46, 'sn', 'Prenom', 'Organization');
INSERT INTO `appartenance` VALUES (85, 'uniqueIdentifier', 'CIN', 'Pret');
INSERT INTO `appartenance` VALUES (59, 'givenName', 'Nom et Prenom de mère', 'Person');
INSERT INTO `appartenance` VALUES (60, 'st', 'Nom et Prenom conjoint', 'Person');
INSERT INTO `appartenance` VALUES (61, 'l', 'Nationalité', 'Person');
INSERT INTO `appartenance` VALUES (62, 'employeeNumber', 'Matricule Etudiant', 'Person');
INSERT INTO `appartenance` VALUES (63, 'employeeType', 'Domaine Activité', 'Person');
INSERT INTO `appartenance` VALUES (83, 'cn', 'Nom', 'Pret');
INSERT INTO `appartenance` VALUES (65, 'o', 'Profession', 'Person');
INSERT INTO `appartenance` VALUES (66, 'telephoneNumber', 'Telephone Fixe', 'Person');
INSERT INTO `appartenance` VALUES (67, 'generationQualifier', 'Situation milllitaire', 'Organization');
INSERT INTO `appartenance` VALUES (78, 'houseIdentifier', 'Mort', 'Santé');
INSERT INTO `appartenance` VALUES (69, 'preferredLanguage', 'N° Passport', 'Organization');
INSERT INTO `appartenance` VALUES (70, 'departmentNumber', 'Nombre de locale', 'Person');
INSERT INTO `appartenance` VALUES (71, 'displayName', 'Prénom père', 'Person');
INSERT INTO `appartenance` VALUES (90, 'personalTitle', 'Salaire', 'Finance');
INSERT INTO `appartenance` VALUES (73, 'sn', 'Prenom', 'Person');
INSERT INTO `appartenance` VALUES (84, 'sn', 'Prenom', 'Pret');
INSERT INTO `appartenance` VALUES (75, 'postalCode', 'Code Postal', 'Adresse');
INSERT INTO `appartenance` VALUES (76, 'c', 'Pays', 'Adresse');
INSERT INTO `appartenance` VALUES (77, 'postalAddress', 'Adresse', 'Adresse');
INSERT INTO `appartenance` VALUES (89, 'telephoneNumber', 'Telephone Fixe', 'Pret');

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

-- 
-- Structure de la table `attributs`
-- 

CREATE TABLE `attributs` (
  `id_at` int(5) NOT NULL auto_increment,
  `name_at` varchar(25) NOT NULL default '',
  `name_show_at` varchar(25) NOT NULL default '',
  `desc_at` varchar(50) NOT NULL default '',
  `modif_at` int(1) NOT NULL default '0',
  `ajout_at` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id_at`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;

-- 
-- Contenu de la table `attributs`
-- 

INSERT INTO `attributs` VALUES (11, 'cn', 'Nom', 'nom', 0, 0);
INSERT INTO `attributs` VALUES (44, 'sn', 'Prenom', 'prenom citoyen', 0, 0);
INSERT INTO `attributs` VALUES (14, 'postalCode', 'Code Postal', 'code postal de la ville', 0, 0);
INSERT INTO `attributs` VALUES (16, 'uniqueIdentifier', 'CIN', 'cin de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (19, 'c', 'Pays', 'info pays', 0, 0);
INSERT INTO `attributs` VALUES (20, 'email', 'E-Mail', 'info mail', 0, 0);
INSERT INTO `attributs` VALUES (22, 'gidNumber', 'Nombre enfant(s)', 'nombre enfants', 0, 0);
INSERT INTO `attributs` VALUES (43, 'houseIdentifier', 'Mort', 'etat des parents', 0, 1);
INSERT INTO `attributs` VALUES (24, 'carLicense', 'Numéro Permis', 'info permis de conduite', 0, 0);
INSERT INTO `attributs` VALUES (25, 'mobile', 'Telphone Mobile', 'telephone portable', 0, 0);
INSERT INTO `attributs` VALUES (26, 'postalAddress', 'Adresse', 'adresse de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (27, 'dmdName', 'Date de naissance', 'date de naissance de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (28, 'description', 'Commentaires', 'autres info sur le citoyen', 0, 0);
INSERT INTO `attributs` VALUES (29, 'givenName', 'Nom et Prenom de mère', 'nom de la mere de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (30, 'st', 'Nom et Prenom conjoint', 'info conjoint', 0, 0);
INSERT INTO `attributs` VALUES (31, 'l', 'Nationalité', 'nationalité de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (32, 'employeeNumber', 'Matricule Etudiant', 'info etudiant', 0, 0);
INSERT INTO `attributs` VALUES (33, 'employeeType', 'Domaine Activité', 'type activité de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (34, 'documentIdentifier', 'Matricule CNSS', 'cnss de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (35, 'o', 'Profession', 'info profession', 0, 0);
INSERT INTO `attributs` VALUES (36, 'telephoneNumber', 'Telephone Fixe', 'telephone fixe de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (37, 'generationQualifier', 'Situation milllitaire', 'situation millitaire de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (38, 'personalTitle', 'Salaire', 'salaire de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (39, 'preferredLanguage', 'N° Passport', 'numero passport de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (40, 'departmentNumber', 'Nombre de locale', 'nombre de local de citoyen', 0, 0);
INSERT INTO `attributs` VALUES (42, 'displayName', 'Prénom père', 'prenom pere', 0, 0);

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

-- 
-- Structure de la table `demandes`
-- 

CREATE TABLE `demandes` (
  `id_demande` int(11) NOT NULL auto_increment,
  `name_dem` varchar(25) NOT NULL default '',
  `uid_dem` varchar(25) NOT NULL default '',
  `pwd_dem` varchar(25) NOT NULL default '',
  `user_un` varchar(25) NOT NULL default 'no!',
  `pwd_un` varchar(25) NOT NULL default 'no!',
  `user_conjoint` varchar(25) NOT NULL default 'no!',
  `pwd_conjoint` varchar(25) NOT NULL default 'no!',
  `date_dem` varchar(25) NOT NULL default '',
  `etat_dem` int(5) NOT NULL default '0',
  PRIMARY KEY  (`id_demande`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

-- 
-- Contenu de la table `demandes`
-- 

INSERT INTO `demandes` VALUES (40, 'Marouen Prod', '1004', '1004', 'najehje33', 'jeb2217107', 'Mort', 'Mort', '21/06/2007', 3);

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

-- 
-- Structure de la table `interface`
-- 

CREATE TABLE `interface` (
  `id_bt` int(4) NOT NULL auto_increment,
  `name_bt` varchar(25) NOT NULL default '',
  `desc_bt` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id_bt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- 
-- Contenu de la table `interface`
-- 

INSERT INTO `interface` VALUES (1, 'Configuration', 'configuration dans l''accueil');
INSERT INTO `interface` VALUES (2, 'Interface', 'l''onglet de gestion de l''interface');
INSERT INTO `interface` VALUES (3, 'Ajouter', 'bouton ajouter');
INSERT INTO `interface` VALUES (4, 'Supprimer', 'bouton supprimer');
INSERT INTO `interface` VALUES (5, 'Rechercher', 'bouton rechercher');
INSERT INTO `interface` VALUES (6, 'Services', 'bouton services');
INSERT INTO `interface` VALUES (7, 'Modifier', 'modifier un citoyen');
INSERT INTO `interface` VALUES (8, 'Profils', 'profils attributs');
INSERT INTO `interface` VALUES (9, 'Appartenances', 'attributs et profils');
INSERT INTO `interface` VALUES (10, 'Utilisateurs', 'utilisateurs et droits acces');
INSERT INTO `interface` VALUES (11, 'Attributs', 'les attributs');

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

-- 
-- Structure de la table `object_class`
-- 

CREATE TABLE `object_class` (
  `id_oc` int(4) NOT NULL auto_increment,
  `name_oc` varchar(25) NOT NULL default '',
  `info_oc` text NOT NULL,
  PRIMARY KEY  (`id_oc`),
  UNIQUE KEY `name_oc` (`name_oc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;

-- 
-- Contenu de la table `object_class`
-- 

INSERT INTO `object_class` VALUES (64, 'Finance', 'info finance');
INSERT INTO `object_class` VALUES (65, 'Santé', 'info santé');
INSERT INTO `object_class` VALUES (51, 'Organization', 'info org');
INSERT INTO `object_class` VALUES (66, 'Adresse', 'info adresse');
INSERT INTO `object_class` VALUES (67, 'Authentification', 'info user');
INSERT INTO `object_class` VALUES (68, 'Pret', 'pret universitaire');
INSERT INTO `object_class` VALUES (62, 'Person', 'info person beta');

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

-- 
-- Structure de la table `user_access`
-- 

CREATE TABLE `user_access` (
  `id_user` int(4) NOT NULL auto_increment,
  `nom` varchar(30) NOT NULL default '',
  `user_name` varchar(25) NOT NULL default '',
  `user_pwd` varchar(25) NOT NULL default '',
  `user_admin` int(2) NOT NULL default '0',
  `user_info` varchar(50) NOT NULL default '',
  `Configuration` int(2) NOT NULL default '0',
  `Interface` int(2) NOT NULL default '0',
  `Ajouter` int(2) NOT NULL default '0',
  `Supprimer` int(2) NOT NULL default '0',
  `Rechercher` int(2) NOT NULL default '0',
  `Modifier` int(2) NOT NULL default '0',
  `Services` int(2) NOT NULL default '0',
  `Utilisateurs` int(2) NOT NULL default '0',
  `Attributs` int(2) NOT NULL default '0',
  `Profils` int(2) NOT NULL default '0',
  `Appartenances` int(2) NOT NULL default '0',
  `Organization` int(2) NOT NULL default '0',
  `Person` varchar(25) NOT NULL default '0',
  `Santé` int(2) NOT NULL default '0',
  `Finance` varchar(25) NOT NULL default '0',
  `Adresse` int(2) NOT NULL default '0',
  `Authentification` int(2) NOT NULL default '0',
  `Pret` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id_user`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

-- 
-- Contenu de la table `user_access`
-- 

INSERT INTO `user_access` VALUES (8, 'Marouen', 'Marouen', 'marop', 1, 'info marop', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2', 2, '0', 2, 1, 0);
INSERT INTO `user_access` VALUES (9, 'Mohammed', 'Midou', 'code', 0, 'code', 1, 0, 0, 0, 1, 1, 0, 0, 1, 0, 1, 0, '0', 0, '0', 0, 0, 0);
INSERT INTO `user_access` VALUES (14, 'khadija', 'dja', 'dja', 0, 'info dja', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1', 0, '0', 0, 0, 0);
INSERT INTO `user_access` VALUES (15, 'El Fki Khadija', 'Khadija', 'dja', 0, 'agence 23', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, '2', 0, '0', 0, 0, 0);
INSERT INTO `user_access` VALUES (16, 'admin', 'admin', 'aaa', 1, 'info', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '0', 0, 0, 0);
INSERT INTO `user_access` VALUES (17, 'Khadija', 'userkhadija', 'azerty', 0, 'info Khadija', 0, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 2, '1', 0, '0', 0, 0, 0);
INSERT INTO `user_access` VALUES (18, 'Ahmed', 'user_pret', 'user', 0, 'info ahmed', 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '0', 0, '0', 0, 0, 1);
INSERT INTO `user_access` VALUES (19, 'soumaya', 'soma', 'ffff', 1, 'info ffff', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '0', 0, 0, 0);
        
Return current item: VIRTUAL.ID