· 10 years ago · Mar 31, 2016, 09:15 PM
1-- phpMyAdmin SQL Dump
2-- version 3.2.0.1
3-- http://www.phpmyadmin.net
4--
5-- Serveur: localhost
6-- Généré le : Mar 04 Mai 2010 à 15:36
7-- Version du serveur: 5.1.36
8-- Version de PHP: 5.3.0
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Base de données: `koursi`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Structure de la table `articles`
20--
21
22CREATE TABLE IF NOT EXISTS `articles` (
23 `id` bigint(21) NOT NULL AUTO_INCREMENT,
24 `Titre` varchar(50) NOT NULL,
25 `chemin` varchar(60) NOT NULL,
26 `date_creation` datetime NOT NULL,
27 `maj` datetime DEFAULT NULL,
28 `statut` varchar(10) NOT NULL,
29 `idConference` bigint(21) NOT NULL,
30 PRIMARY KEY (`id`),
31 UNIQUE KEY `Titre` (`Titre`)
32) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
33
34--
35-- Contenu de la table `articles`
36--
37
38INSERT INTO `articles` (`id`, `Titre`, `chemin`, `date_creation`, `maj`, `statut`, `idConference`) VALUES
39(1, 'mon premier Article', '/uploads/articles/', '2010-05-04 00:33:39', NULL, 'waitting', 2),
40(2, 'article conference 1 de ramy', '/uploads/articles/', '2010-05-04 08:13:26', NULL, 'waitting', 1);
41
42-- --------------------------------------------------------
43
44--
45-- Structure de la table `assignationrapport`
46--
47
48CREATE TABLE IF NOT EXISTS `assignationrapport` (
49 `idPersonne` bigint(21) NOT NULL,
50 `idArticle` bigint(21) NOT NULL,
51 `fait` varchar(10) NOT NULL
52) ENGINE=MyISAM DEFAULT CHARSET=latin1;
53
54--
55-- Contenu de la table `assignationrapport`
56--
57
58INSERT INTO `assignationrapport` (`idPersonne`, `idArticle`, `fait`) VALUES
59(4, 2, 'oui');
60
61-- --------------------------------------------------------
62
63--
64-- Structure de la table `auteur`
65--
66
67CREATE TABLE IF NOT EXISTS `auteur` (
68 `idArticle` bigint(21) NOT NULL,
69 `idPersonne` bigint(21) NOT NULL
70) ENGINE=MyISAM DEFAULT CHARSET=latin1;
71
72--
73-- Contenu de la table `auteur`
74--
75
76INSERT INTO `auteur` (`idArticle`, `idPersonne`) VALUES
77(2, 2),
78(1, 2);
79
80-- --------------------------------------------------------
81
82--
83-- Structure de la table `chairs`
84--
85
86CREATE TABLE IF NOT EXISTS `chairs` (
87 `id_conference` varchar(256) NOT NULL,
88 `id_personne` bigint(21) NOT NULL,
89 KEY `id_conference` (`id_conference`),
90 KEY `id_perssone` (`id_personne`)
91) ENGINE=MyISAM DEFAULT CHARSET=latin1;
92
93--
94-- Contenu de la table `chairs`
95--
96
97INSERT INTO `chairs` (`id_conference`, `id_personne`) VALUES
98('1', 1),
99('2', 1);
100
101-- --------------------------------------------------------
102
103--
104-- Structure de la table `commentaire`
105--
106
107CREATE TABLE IF NOT EXISTS `commentaire` (
108 `id` bigint(21) NOT NULL AUTO_INCREMENT,
109 `idRapport` bigint(21) NOT NULL,
110 `idPersonne` bigint(21) NOT NULL,
111 `commentaire` varchar(256) NOT NULL,
112 PRIMARY KEY (`id`,`idRapport`)
113) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
114
115--
116-- Contenu de la table `commentaire`
117--
118
119INSERT INTO `commentaire` (`id`, `idRapport`, `idPersonne`, `commentaire`) VALUES
120(1, 4, 4, 'merde'),
121(2, 3, 4, 'puree'),
122(3, 3, 4, 'ceci est une image'),
123(4, 3, 4, 'bien');
124
125-- --------------------------------------------------------
126
127--
128-- Structure de la table `conference`
129--
130
131CREATE TABLE IF NOT EXISTS `conference` (
132 `id` bigint(21) NOT NULL AUTO_INCREMENT,
133 `nom` varchar(20) NOT NULL,
134 `date_creation` date NOT NULL,
135 `limite_depot` date NOT NULL,
136 `limite_rendu` date NOT NULL,
137 `resultats` date NOT NULL,
138 `limite_modif` date NOT NULL,
139 `date_envoi` date NOT NULL,
140 PRIMARY KEY (`id`,`nom`),
141 UNIQUE KEY `nom` (`nom`)
142) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
143
144--
145-- Contenu de la table `conference`
146--
147
148INSERT INTO `conference` (`id`, `nom`, `date_creation`, `limite_depot`, `limite_rendu`, `resultats`, `limite_modif`, `date_envoi`) VALUES
149(1, 'ma premiere conferen', '2010-05-03', '2010-05-06', '2010-05-20', '2010-05-21', '2010-05-25', '2010-05-31'),
150(2, 'ma deuxieme conferen', '2010-05-03', '2010-05-05', '2010-05-12', '2010-05-17', '2010-05-26', '2010-05-28');
151
152-- --------------------------------------------------------
153
154--
155-- Structure de la table `personne`
156--
157
158CREATE TABLE IF NOT EXISTS `personne` (
159 `id` bigint(21) NOT NULL AUTO_INCREMENT,
160 `nom` varchar(20) NOT NULL,
161 `prenom` varchar(20) NOT NULL,
162 `login` varchar(20) NOT NULL,
163 `password` varchar(50) CHARACTER SET utf8 NOT NULL,
164 `mail` varchar(30) NOT NULL,
165 `date_inscription` datetime NOT NULL,
166 `photo` tinyint(1) DEFAULT NULL,
167 `extension` varchar(3) DEFAULT NULL,
168 PRIMARY KEY (`id`),
169 UNIQUE KEY `mail` (`mail`)
170) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
171
172--
173-- Contenu de la table `personne`
174--
175
176INSERT INTO `personne` (`id`, `nom`, `prenom`, `login`, `password`, `mail`, `date_inscription`, `photo`, `extension`) VALUES
177(1, 'bendris', 'amine', 'bendris.amine', 'e10adc3949ba59abbe56e057f20f883e', 'bendris.amine@gmail.com', '2010-05-03 13:56:41', 1, 'jpg'),
178(2, 'boudames', 'ramy', 'hamouramix', 'e10adc3949ba59abbe56e057f20f883e', 'hamouramix@gmail.com', '2010-05-03 23:46:28', 0, ''),
179(3, 'afsatou', 'toure', 'afsa', 'e10adc3949ba59abbe56e057f20f883e', 'afsa@gmail.com', '2010-05-04 00:35:47', 0, ''),
180(4, 'bendris', 'hamza', 'mezzzou', 'e10adc3949ba59abbe56e057f20f883e', 'hbenriss@hotmail.com', '2010-05-04 00:36:31', 0, ''),
181(5, 'messali', 'farouk', 'foufou.eni', 'e10adc3949ba59abbe56e057f20f883e', 'messali-ini@yahoo.fr', '2010-05-04 00:37:23', 0, ''),
182(6, 'sarkozy', 'nicolas', 'sarko', 'e10adc3949ba59abbe56e057f20f883e', 'nicolas.one@hotmail.com', '2010-05-04 00:38:23', 0, '');
183
184-- --------------------------------------------------------
185
186--
187-- Structure de la table `rapport`
188--
189
190CREATE TABLE IF NOT EXISTS `rapport` (
191 `id` bigint(21) NOT NULL AUTO_INCREMENT,
192 `depot` datetime NOT NULL,
193 `maj` datetime NOT NULL,
194 `idPersone` bigint(21) NOT NULL,
195 `idArticle` bigint(21) NOT NULL,
196 PRIMARY KEY (`id`)
197) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
198
199--
200-- Contenu de la table `rapport`
201--
202
203INSERT INTO `rapport` (`id`, `depot`, `maj`, `idPersone`, `idArticle`) VALUES
204(3, '2010-05-04 10:26:20', '2010-05-04 10:26:20', 4, 2),
205(4, '2010-05-04 10:29:01', '2010-05-04 10:29:01', 4, 2),
206(5, '2010-05-04 10:30:17', '2010-05-04 10:30:17', 4, 2);
207
208-- --------------------------------------------------------
209
210--
211-- Structure de la table `rapporteurs`
212--
213
214CREATE TABLE IF NOT EXISTS `rapporteurs` (
215 `id_conference` bigint(21) NOT NULL,
216 `id_perssone` bigint(21) NOT NULL,
217 KEY `id_conference` (`id_conference`),
218 KEY `id_perssone` (`id_perssone`)
219) ENGINE=MyISAM DEFAULT CHARSET=latin1;
220
221--
222-- Contenu de la table `rapporteurs`
223--
224
225INSERT INTO `rapporteurs` (`id_conference`, `id_perssone`) VALUES
226(1, 2),
227(1, 3),
228(1, 4),
229(1, 5),
230(1, 6);