EukUcBAG

1-- Adminer 4.7.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `admin`;
9CREATE TABLE `admin` (
10  `matricule` int(11) NOT NULL,
11  `nom` varchar(100) NOT NULL,
12  `prenom` varchar(100) NOT NULL,
13  `pwd` varchar(100) NOT NULL,
14  PRIMARY KEY (`matricule`)
15) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16
17
18DROP TABLE IF EXISTS `cablage`;
19CREATE TABLE `cablage` (
20  `orderNumber` varchar(100) NOT NULL,
21  `nom_ligne` varchar(100) NOT NULL,
22  `comletedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
23  `dispositionCode` varchar(100) NOT NULL
24) ENGINE=InnoDB DEFAULT CHARSET=latin1;
25
26
27DROP TABLE IF EXISTS `chef_ligne`;
28CREATE TABLE `chef_ligne` (
29  `matricule` varchar(100) NOT NULL,
30  `nom` varchar(100) NOT NULL,
31  `prenom` varchar(100) NOT NULL,
32  `nom_ligne` varchar(100) DEFAULT NULL,
33  `pwd` varchar(100) NOT NULL,
34  PRIMARY KEY (`matricule`),
35  KEY `fk_ligne_chef` (`nom_ligne`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38INSERT INTO `chef_ligne` (`matricule`, `nom`, `prenom`, `nom_ligne`, `pwd`) VALUES
39('22222222',	'Mohsen',	'Brahim',	'LEIM',	'123456');
40
41DROP TABLE IF EXISTS `efficience`;
42CREATE TABLE `efficience` (
43  `id_efficience` int(11) NOT NULL AUTO_INCREMENT,
44  `efficience` int(11) NOT NULL,
45  `nom_ligne` varchar(100) DEFAULT NULL,
46  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
47  PRIMARY KEY (`id_efficience`),
48  KEY `fk_ligne_efficience` (`nom_ligne`),
49  CONSTRAINT `fk_ligne_efficience` FOREIGN KEY (`nom_ligne`) REFERENCES `ligne` (`nom_ligne`)
50) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
51
52
53DROP TABLE IF EXISTS `heure_presence`;
54CREATE TABLE `heure_presence` (
55  `id` int(11) NOT NULL AUTO_INCREMENT,
56  `nbr_heure` int(11) NOT NULL,
57  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
58  `nom_ligne` varchar(100) NOT NULL,
59  PRIMARY KEY (`id`),
60  KEY `fk_ligne_hPresence` (`nom_ligne`),
61  CONSTRAINT `fk_ligne_hPresence` FOREIGN KEY (`nom_ligne`) REFERENCES `ligne` (`nom_ligne`)
62) ENGINE=InnoDB DEFAULT CHARSET=latin1;
63
64
65DROP TABLE IF EXISTS `heure_produite`;
66CREATE TABLE `heure_produite` (
67  `id` int(11) NOT NULL,
68  `nb_heure` float NOT NULL,
69  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
70  `nom_ligne` varchar(100) NOT NULL,
71  PRIMARY KEY (`id`),
72  KEY `fk_ligne_hProduite` (`nom_ligne`),
73  CONSTRAINT `fk_ligne_hProduite` FOREIGN KEY (`nom_ligne`) REFERENCES `ligne` (`nom_ligne`)
74) ENGINE=InnoDB DEFAULT CHARSET=latin1;
75
76
77DROP TABLE IF EXISTS `ligne`;
78CREATE TABLE `ligne` (
79  `nom_ligne` varchar(100) NOT NULL,
80  `superviseur` int(11) NOT NULL,
81  PRIMARY KEY (`nom_ligne`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83
84
85DROP TABLE IF EXISTS `nb_empolyes`;
86CREATE TABLE `nb_empolyes` (
87  `id` int(11) NOT NULL AUTO_INCREMENT,
88  `nbr_emp` int(11) NOT NULL,
89  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
90  `nom_ligne` varchar(100) NOT NULL,
91  PRIMARY KEY (`id`),
92  KEY `fk_ligne_nbEmp` (`nom_ligne`),
93  CONSTRAINT `fk_ligne_nbEmp` FOREIGN KEY (`nom_ligne`) REFERENCES `ligne` (`nom_ligne`)
94) ENGINE=InnoDB DEFAULT CHARSET=latin1;
95
96
97DROP TABLE IF EXISTS `notification`;
98CREATE TABLE `notification` (
99  `id_notif` int(11) NOT NULL AUTO_INCREMENT,
100  `description` varchar(255) NOT NULL,
101  `nom_ligne` varchar(100) DEFAULT NULL,
102  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
103  PRIMARY KEY (`id_notif`),
104  KEY `fk_notif_ligne` (`nom_ligne`),
105  CONSTRAINT `fk_notif_ligne` FOREIGN KEY (`nom_ligne`) REFERENCES `ligne` (`nom_ligne`)
106) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
107
108
109DROP TABLE IF EXISTS `objectif`;
110CREATE TABLE `objectif` (
111  `id_obj` int(11) NOT NULL AUTO_INCREMENT,
112  `objectif` int(11) NOT NULL,
113  `nom_ligne` varchar(100) DEFAULT NULL,
114  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
115  PRIMARY KEY (`id_obj`),
116  KEY `fk_obj_ligne` (`nom_ligne`),
117  CONSTRAINT `fk_obj_ligne` FOREIGN KEY (`nom_ligne`) REFERENCES `ligne` (`nom_ligne`)
118) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
119
120
121DROP TABLE IF EXISTS `orderattribut`;
122CREATE TABLE `orderattribut` (
123  `orderNumber` varchar(100) NOT NULL,
124  `index_production` varchar(100) NOT NULL,
125  PRIMARY KEY (`orderNumber`,`index_production`)
126) ENGINE=InnoDB DEFAULT CHARSET=latin1;
127
128
129DROP TABLE IF EXISTS `superviseur`;
130CREATE TABLE `superviseur` (
131  `matricule` int(11) NOT NULL,
132  `nom` varchar(100) NOT NULL,
133  `prenom` varchar(100) NOT NULL,
134  `pwd` varchar(100) NOT NULL,
135  PRIMARY KEY (`matricule`)
136) ENGINE=InnoDB DEFAULT CHARSET=latin1;
137
138
139DROP TABLE IF EXISTS `vgz`;
140CREATE TABLE `vgz` (
141  `index_production` varchar(100) NOT NULL,
142  `ps` varchar(100) NOT NULL,
143  `m` float NOT NULL,
144  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
145  PRIMARY KEY (`index_production`)
146) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147
148
149-- 2019-06-16 21:32:35