API tools faq
paste
aymenoppa

Untitled

aymenoppa
Mar 30th, 2016
207
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 64.01 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.0
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Client : 127.0.0.1:3306
  6. -- Généré le : Mer 30 Mars 2016 à 12:53
  7. -- Version du serveur : 5.7.11
  8. -- Version de PHP : 5.5.9-1ubuntu4.14
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Base de données : `testpfe2`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Structure de la table `activity_log`
  21. --
  22.  
  23. CREATE TABLE `activity_log` (
  24. `id` int(11) NOT NULL,
  25. `classname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  26. `entity_id` int(11) NOT NULL,
  27. `user` int(11) NOT NULL,
  28. `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  29. `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  30. `date` datetime NOT NULL
  31. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  32.  
  33. --
  34. -- Contenu de la table `activity_log`
  35. --
  36.  
  37. INSERT INTO `activity_log` (`id`, `classname`, `entity_id`, `user`, `message`, `type`, `date`) VALUES
  38. (76, 'Ben\\UserBundle\\Entity\\User', 17, 1, 'test sms', 'sms', '2014-07-21 11:41:14'),
  39. (80, 'Ben\\UserBundle\\Entity\\User', 8, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  40. (81, 'Ben\\UserBundle\\Entity\\User', 11, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  41. (82, 'Ben\\UserBundle\\Entity\\User', 12, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  42. (86, 'Ben\\UserBundle\\Entity\\User', 17, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  43. (87, 'Ben\\UserBundle\\Entity\\User', 18, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  44. (89, 'Ben\\UserBundle\\Entity\\User', 20, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  45. (91, 'Ben\\UserBundle\\Entity\\User', 22, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  46. (93, 'Ben\\UserBundle\\Entity\\User', 24, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  47. (94, 'Ben\\UserBundle\\Entity\\User', 25, 1, 'ddede', 'sms', '2014-07-26 12:13:31'),
  48. (98, 'Ben\\UserBundle\\Entity\\User', 8, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  49. (99, 'Ben\\UserBundle\\Entity\\User', 11, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  50. (100, 'Ben\\UserBundle\\Entity\\User', 12, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  51. (103, 'Ben\\UserBundle\\Entity\\User', 16, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  52. (104, 'Ben\\UserBundle\\Entity\\User', 17, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  53. (105, 'Ben\\UserBundle\\Entity\\User', 18, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  54. (106, 'Ben\\UserBundle\\Entity\\User', 19, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  55. (107, 'Ben\\UserBundle\\Entity\\User', 20, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  56. (109, 'Ben\\UserBundle\\Entity\\User', 22, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  57. (111, 'Ben\\UserBundle\\Entity\\User', 24, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  58. (112, 'Ben\\UserBundle\\Entity\\User', 25, 1, 'sms groupe test', 'sms', '2014-07-26 12:16:47'),
  59. (139, 'Ben\\UserBundle\\Entity\\User', 11, 1, '', 'sms', '2014-07-26 16:05:38'),
  60. (140, 'Ben\\UserBundle\\Entity\\User', 12, 1, '', 'sms', '2014-07-26 16:11:55'),
  61. (141, 'Ben\\UserBundle\\Entity\\User', 17, 1, 'occupé', 'appel', '2014-07-26 17:32:06'),
  62. (142, 'Ben\\UserBundle\\Entity\\User', 17, 1, 'mail', 'appel', '2014-07-26 17:33:25'),
  63. (146, 'Ben\\UserBundle\\Entity\\User', 0, 1, 'pas de réponse', 'appel', '2014-07-26 17:49:51'),
  64. (155, 'Ben\\UserBundle\\Entity\\User', 19, 1, 'Reunion', 'lettre', '2014-07-29 10:24:08'),
  65. (156, 'Ben\\UserBundle\\Entity\\User', 21, 1, 'Reunion', 'lettre', '2014-07-29 10:24:08'),
  66. (157, 'Ben\\UserBundle\\Entity\\User', 23, 1, 'Reunion', 'lettre', '2014-07-29 10:24:08'),
  67. (158, 'Ben\\UserBundle\\Entity\\User', 24, 1, 'Reunion', 'lettre', '2014-07-29 10:24:08'),
  68. (159, 'Ben\\UserBundle\\Entity\\User', 25, 1, 'Reunion', 'lettre', '2014-07-29 10:24:08'),
  69. (161, 'Ben\\UserBundle\\Entity\\User', 19, 8, 'réponse', 'appel', '2014-07-29 17:18:54'),
  70. (185, 'Ben\\UserBundle\\Entity\\User', 21, 8, '', 'sms', '2014-07-29 18:00:53'),
  71. (186, 'Ben\\UserBundle\\Entity\\User', 23, 8, '', 'sms', '2014-07-29 18:00:53'),
  72. (187, 'Ben\\UserBundle\\Entity\\User', 24, 8, '', 'sms', '2014-07-29 18:00:53'),
  73. (188, 'Ben\\UserBundle\\Entity\\User', 25, 8, '', 'sms', '2014-07-29 18:00:53'),
  74. (190, 'Ben\\UserBundle\\Entity\\User', 19, 8, 'objet', 'mail', '2014-07-29 18:01:35'),
  75. (191, 'Ben\\UserBundle\\Entity\\User', 21, 8, 'objet', 'mail', '2014-07-29 18:01:35'),
  76. (192, 'Ben\\UserBundle\\Entity\\User', 23, 8, 'objet', 'mail', '2014-07-29 18:01:35'),
  77. (193, 'Ben\\UserBundle\\Entity\\User', 24, 8, 'objet', 'mail', '2014-07-29 18:01:35'),
  78. (194, 'Ben\\UserBundle\\Entity\\User', 25, 8, 'objet', 'mail', '2014-07-29 18:01:35'),
  79. (195, 'Ben\\UserBundle\\Entity\\User', 25, 8, 'occupé', 'appel', '2014-07-29 18:02:17'),
  80. (196, 'Ben\\UserBundle\\Entity\\User', 2, 1, '', 'sms', '2014-08-03 14:20:49'),
  81. (197, 'Ben\\UserBundle\\Entity\\User', 19, 1, '', 'sms', '2014-08-03 14:20:49'),
  82. (198, 'Ben\\UserBundle\\Entity\\User', 20, 1, '', 'sms', '2014-08-03 14:20:49'),
  83. (199, 'Ben\\UserBundle\\Entity\\User', 2, 1, 'adam mail', 'mail', '2014-08-03 14:22:18'),
  84. (200, 'Ben\\UserBundle\\Entity\\User', 19, 1, 'adam mail', 'mail', '2014-08-03 14:22:18'),
  85. (201, 'Ben\\UserBundle\\Entity\\User', 20, 1, 'adam mail', 'mail', '2014-08-03 14:22:18'),
  86. (202, 'Ben\\UserBundle\\Entity\\User', 2, 1, '', 'lettre', '2014-08-03 14:28:48'),
  87. (203, 'Ben\\UserBundle\\Entity\\User', 19, 1, '', 'lettre', '2014-08-03 14:28:48'),
  88. (204, 'Ben\\UserBundle\\Entity\\User', 20, 1, '', 'lettre', '2014-08-03 14:28:48'),
  89. (206, 'Ben\\UserBundle\\Entity\\User', 8, 1, 'cotisation', 'mail', '2014-08-09 20:52:34'),
  90. (207, 'Ben\\UserBundle\\Entity\\User', 8, 1, 'cotisation', 'mail', '2014-08-09 20:54:15'),
  91. (208, 'Ben\\UserBundle\\Entity\\User', 8, 1, 'cotisation', 'mail', '2014-08-09 20:57:13'),
  92. (209, 'Ben\\UserBundle\\Entity\\User', 8, 1, 'cotisation', 'Lettre', '2014-08-09 21:04:27'),
  93. (210, 'Ben\\UserBundle\\Entity\\User', 15, 1, 'cotisation', 'Lettre', '2014-08-12 09:23:00'),
  94. (211, 'Ben\\UserBundle\\Entity\\User', 15, 1, 'cotisation', 'Lettre', '2014-08-12 09:32:26'),
  95. (212, 'Ben\\UserBundle\\Entity\\User', 1, 1, 'cotisation', 'mail', '2014-08-12 09:56:38'),
  96. (213, 'Ben\\UserBundle\\Entity\\User', 1, 1, 'cotisation', 'Lettre', '2014-08-12 09:56:54'),
  97. (214, 'Ben\\UserBundle\\Entity\\User', 1, 1, 'cotisation', 'Lettre', '2014-08-15 10:06:21');
  98.  
  99. -- --------------------------------------------------------
  100.  
  101. --
  102. -- Structure de la table `avancement`
  103. --
  104.  
  105. CREATE TABLE `avancement` (
  106. `id` int(11) NOT NULL,
  107. `user_id` int(11) NOT NULL,
  108. `status_id` int(11) NOT NULL,
  109. `date_from` date NOT NULL,
  110. `date_to` date NOT NULL,
  111. `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  112. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  113.  
  114. --
  115. -- Contenu de la table `avancement`
  116. --
  117.  
  118. INSERT INTO `avancement` (`id`, `user_id`, `status_id`, `date_from`, `date_to`, `city`) VALUES
  119. (1, 1, 3, '2013-07-09', '2014-07-09', 'Rabat'),
  120. (2, 2, 5, '2014-07-09', '2014-07-09', ''),
  121. (3, 8, 7, '2013-07-09', '2014-07-09', ''),
  122. (4, 11, 9, '2014-07-09', '2015-01-09', ''),
  123. (5, 15, 7, '2013-07-31', '2015-07-09', 'oujda'),
  124. (6, 16, 3, '2014-07-09', '2014-07-09', 'Rabat'),
  125. (8, 12, 4, '2012-07-11', '2014-09-11', ''),
  126. (9, 14, 4, '2014-07-09', '2014-07-09', ''),
  127. (11, 19, 4, '2014-07-09', '2015-07-09', ''),
  128. (12, 20, 7, '2009-07-10', '2014-07-10', 'Agadir'),
  129. (13, 25, 7, '2014-07-20', '2014-07-20', 'Taza'),
  130. (14, 21, 8, '2014-07-30', '2014-07-30', 'casablaca'),
  131. (15, 22, 4, '2014-07-30', '2015-07-30', 'rabat'),
  132. (16, 23, 4, '2014-07-30', '2014-07-30', 'rabat'),
  133. (17, 28, 5, '2014-07-30', '2014-07-30', 'rabat'),
  134. (19, 41, 4, '2014-07-30', '2015-07-30', 'agadir'),
  135. (20, 24, 8, '2014-07-30', '2014-07-30', 'agadir'),
  136. (21, 29, 3, '2014-07-30', '2014-07-30', 'oujda'),
  137. (22, 40, 2, '2014-07-30', '2014-07-30', 'oujda'),
  138. (23, 45, 7, '2014-07-30', '2014-07-30', 'oujda');
  139.  
  140. -- --------------------------------------------------------
  141.  
  142. --
  143. -- Structure de la table `bac`
  144. --
  145.  
  146. CREATE TABLE `bac` (
  147. `id_bac` int(11) NOT NULL,
  148. `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  149. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  150.  
  151. --
  152. -- Contenu de la table `bac`
  153. --
  154.  
  155. INSERT INTO `bac` (`id_bac`, `type`) VALUES
  156. (1, 'Info'),
  157. (2, 'Science'),
  158. (3, 'Math'),
  159. (4, 'technique'),
  160. (5, 'lettre'),
  161. (6, 'sport');
  162.  
  163. -- --------------------------------------------------------
  164.  
  165. --
  166. -- Structure de la table `config`
  167. --
  168.  
  169. CREATE TABLE `config` (
  170. `id` int(11) NOT NULL,
  171. `the_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  172. `the_value` longtext COLLATE utf8_unicode_ci NOT NULL
  173. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  174.  
  175. --
  176. -- Contenu de la table `config`
  177. --
  178.  
  179. INSERT INTO `config` (`id`, `the_key`, `the_value`) VALUES
  180. (1, 'org_logo', 'uploads/img/d811f96097753f476a1dcc69c6870e312479613e.png'),
  181. (2, 'org_name', 'Universit'),
  182. (3, 'org_description', 'longtext yeaah'),
  183. (4, 'org_slogan', 'test test tes'),
  184. (5, 'org_address', 'rabat agdal rue de france n86'),
  185. (6, 'org_cp', '110600'),
  186. (7, 'org_city', 'Rabat'),
  187. (8, 'org_contry', 'maroc'),
  188. (9, 'org_lang', 'fr_FR'),
  189. (10, 'org_map_url', 'http://google.map.com'),
  190. (11, 'mailserver_url', 'http://mail.com'),
  191. (12, 'org_email', 'bayti@gmail.com'),
  192. (13, 'rows_per_page', '10'),
  193. (14, 'print_permission', ''),
  194. (15, 'org_carte_css', '/* put your css here */\r\nbody{background: #FFFFFF;}'),
  195. (16, 'org_signup', ''),
  196. (17, 'org_twitter', 'twitter'),
  197. (18, 'org_facebook', 'facebook'),
  198. (19, 'org_google', 'google'),
  199. (20, 'org_website', 'http://webcurios.com'),
  200. (21, 'org_gsm', '0566554'),
  201. (22, 'org_tel', '0666445528'),
  202. (23, 'org_map_lat', '34.007836'),
  203. (24, 'org_map_lng', '-6.837305'),
  204. (25, 'letter_invitation', '<p>Bonjour {firstname}</p><p><strong></strong>Nous avons pris note de votre volonté de rejoindre notre association et à ce titre, nous avons l\'honneur de vous inviter à une réunion d\'informations qui aura lieu le {date} à {time}.</p><p> <br></p><p><em><span style="color: rgb(106, 168, 79);">{body}</span></em></p><p><em><br></em></p><p>Nous vous prions d’agréer, Madame, Mademoiselle, Monsieur et Cher(e) adhérent(e), l’assurance de nos salutations les meilleures.</p>'),
  205. (26, 'letter_cotisation', '<p><span><div>Bonjour,</div><div><br></div><div>Votre adhésion à <span>{org_name}</span> a expiré depuis {days_expired} jours.</div><div><br></div><div>A bientôt!</div><div><br></div><div>(ce courriel est un envoi automatique)</div></span><br></p>'),
  206. (27, 'org_diplome', 'bac,dut,licence,master,doctorat'),
  207. (28, 'org_expertise', 'Informatique,Medcine,Mécanique,Physique,mathématique,autres'),
  208. (29, 'letter_header', '<p>{org_name}</p><p>{org_address}</p><h1 style="text-align: center;">A</h1><p style="text-align: right;">{fullname}</p><p style="text-align: right;">{address}</p>'),
  209. (30, 'badge_bgcolor', '#ffffed'),
  210. (31, 'badge_color', '#34495e'),
  211. (32, 'badge_footer_bgcolor', 'rgba(52,73,94,0.77)'),
  212. (33, 'badge_footer_color', '#ffffff'),
  213. (34, 'app_theme', 'theme1'),
  214. (35, 'allowaccess', '');
  215.  
  216. -- --------------------------------------------------------
  217.  
  218. --
  219. -- Structure de la table `contact_physique`
  220. --
  221.  
  222. CREATE TABLE `contact_physique` (
  223. `CO_prenom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  224. `CO_datenaisse` date NOT NULL,
  225. `CO_lieuxnaisse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  226. `CO_codepostal` int(11) NOT NULL,
  227. `CO_telf` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  228. `CO_fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  229. `CO_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  230. `CO_vue` tinyint(1) NOT NULL,
  231. `CO_valider` tinyint(1) NOT NULL,
  232. `CO_Nom` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  233. `CO_Adresse` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  234. `CO_cin` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  235. `CO_regi` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  236. `CO_loginsuivi` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  237. `CO_mdpsuivi` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  238. `statut` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  239. `CO_numcin` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  240. `CO_Id` int(11) NOT NULL
  241. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  242.  
  243. --
  244. -- Contenu de la table `contact_physique`
  245. --
  246.  
  247. INSERT INTO `contact_physique` (`CO_prenom`, `CO_datenaisse`, `CO_lieuxnaisse`, `CO_codepostal`, `CO_telf`, `CO_fax`, `CO_email`, `CO_vue`, `CO_valider`, `CO_Nom`, `CO_Adresse`, `CO_cin`, `CO_regi`, `CO_loginsuivi`, `CO_mdpsuivi`, `statut`, `CO_numcin`, `CO_Id`) VALUES
  248. ('amar1', '2011-01-01', 'amar', 45, '123', '123', 'amar@amar.amar', 0, 1, 'manel1', '123', 'C:\\Program Files (x86)\\EasyPHP-DevServer-14.1VC11\\binaries\\tmp\\phpC861.tmp', '0000', 'aaa', 'bbb', '7atachay', '0000', 2),
  249. ('amar1', '2011-01-01', 'amar', 45, '123', '123', 'amar@amar.amar', 0, 1, 'manel3', '123', 'C:\\Program Files (x86)\\EasyPHP-DevServer-14.1VC11\\binaries\\tmp\\php29DC.tmp', '0000', 'aaa', 'bbb', '7atachay', '0000', 4),
  250. ('amar', '2011-01-01', 'amar', 45, '123', '123', 'amar@amar.amar', 0, 1, 'manel', '123', 'C:\\Program Files (x86)\\EasyPHP-DevServer-14.1VC11\\binaries\\tmp\\php5329.tmp', '0000', 'aaa', 'bbb', '7atachay', '0000', 5),
  251. ('amar', '2011-01-01', 'amar', 45, '123', '123', 'amar@amar.amar', 0, 1, 'manel', '123', 'C:\\Program Files (x86)\\EasyPHP-DevServer-14.1VC11\\binaries\\tmp\\php61F8.tmp', '0000', 'aaa', 'bbb', '7atachay', '0000', 6),
  252. ('amar', '2011-01-01', 'amar', 54, '123', '123', 'amar@amar.amar', 0, 1, 'manel', '123', 'C:\\Program Files (x86)\\EasyPHP-DevServer-14.1VC11\\binaries\\tmp\\phpF327.tmp', '0000', 'amar@amar.amar', 'GAZRj87s', 'En Attente', '0000', 7),
  253. ('amar', '2011-01-01', 'amar', 1, '123', '123', 'amar@amar.amar', 0, 0, 'manel', '123', 'a76ca2fa444b6ae0d66022914ddf486a.txt', 'a76ca2fa444b6ae0d66022914ddf486a.txt', 'amar@amar.amar', '9Pn5yNTm', 'En Attente', '0000', 8),
  254. ('amar', '2011-01-01', 'amar', 1, '123', '123', 'amar@amar.amar', 0, 0, 'manel', '123', 'a1fe026bb9c57754613ef7c3faf4b8eb.jpg', 'a1fe026bb9c57754613ef7c3faf4b8eb.jpg', 'amar@amar.amar', 'WHmSFZUQ', 'En Attente', '0000', 9),
  255. ('amar', '2011-01-01', 'amar', 12, '123', '123', 'amar@amar.amar', 0, 0, 'manel', '123', '364e6e0d313f9edbae72863e33e2ca37.jpg', 'e52c7fa368315dd5dbcd12584d9ad05a.jpg', 'amar@amar.amar', 'yznFrrMg', 'En Attente', '07458', 10),
  256. ('amar', '2011-01-01', 'amar', 12, '123', '123', 'amar@amar.amar', 0, 0, 'manel', '123', 'ad4038b15019e91594bc4910a96e98d2.jpg', '2d169f9298c20847893b6dc4056ba33c.jpg', 'amar@amar.amar', 'Lwp7f7a4', 'En Attente', '0000', 11),
  257. ('amar', '2011-01-01', 'amar', 12, '123', '123', 'amar@amar.amars', 0, 0, 'manel', '123', '2207033228b97f588cc3642bea585612.jpg', '0ae6f6cc7b79e9b84472fddf2206ce05.jpg', 'amar@amar.amars', 'hkKjIUJB', 'En Attente', '07458', 12),
  258. ('amar', '2011-01-01', 'amar', 12, '123', '123', 'amar@amar.amarse', 0, 0, 'manel', '123', 'b91418c71b825bc6b7d6848c242eeb57.jpg', '1620e1e5a1e29eb8d124d53678b9cee8.jpg', 'amar@amar.amarse', 'VOxAHd01', 'En Attente', '0745885', 13);
  259.  
  260. -- --------------------------------------------------------
  261.  
  262. --
  263. -- Structure de la table `cotisation`
  264. --
  265.  
  266. CREATE TABLE `cotisation` (
  267. `id` int(11) NOT NULL,
  268. `user_id` int(11) NOT NULL,
  269. `price` double NOT NULL,
  270. `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  271. `date_from` date NOT NULL,
  272. `date_to` date NOT NULL,
  273. `created` date NOT NULL,
  274. `description` longtext COLLATE utf8_unicode_ci
  275. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  276.  
  277. --
  278. -- Contenu de la table `cotisation`
  279. --
  280.  
  281. INSERT INTO `cotisation` (`id`, `user_id`, `price`, `type`, `date_from`, `date_to`, `created`, `description`) VALUES
  282. (2, 8, 1200, 'Chèque', '2010-07-09', '2011-07-09', '2014-07-24', 'Fiche contribution'),
  283. (5, 11, 1000, 'Virement', '2013-07-10', '2014-07-10', '2014-07-24', 'no thanks'),
  284. (6, 25, 3500, 'Virement', '2014-07-17', '2015-07-29', '2014-07-24', '3500 dh per year'),
  285. (7, 40, 3500, 'Chèque', '2014-07-30', '2015-07-30', '2014-07-24', 'cotisation anuelle'),
  286. (8, 45, 1200, 'Espèces', '2014-01-01', '2014-12-31', '2014-07-24', '2014'),
  287. (10, 2, 1000, 'Virement', '2014-01-01', '2014-02-01', '2014-08-08', 'no'),
  288. (11, 8, 1000, 'Espèces', '2014-05-01', '2014-06-01', '2014-08-08', NULL),
  289. (14, 8, 1000, 'Virement', '2014-03-01', '2014-04-01', '2014-08-08', 'mars'),
  290. (15, 2, 1000, 'Espèces', '2014-02-01', '2014-03-01', '2014-08-08', 'janvier'),
  291. (16, 1, 1000, 'Espèces', '2014-01-01', '2014-02-01', '2014-08-09', NULL),
  292. (17, 1, 1000, 'Espèces', '2014-02-01', '2014-03-01', '2014-08-09', NULL),
  293. (18, 1, 1000, 'Espèces', '2014-03-01', '2014-04-01', '2014-08-09', NULL),
  294. (19, 1, 1000, 'Espèces', '2014-04-01', '2014-05-01', '2014-08-09', NULL),
  295. (22, 8, 1000, 'Espèces', '2014-06-01', '2014-07-01', '2014-08-09', NULL),
  296. (23, 8, 1000, 'Virement', '2014-04-01', '2014-05-01', '2014-08-09', NULL),
  297. (24, 8, 1000, 'Virement', '2014-07-01', '2014-08-01', '2014-08-09', NULL),
  298. (25, 2, 1000, 'Virement', '2014-03-01', '2014-04-01', '2014-08-09', NULL),
  299. (26, 2, 1000, 'Virement', '2014-04-01', '2014-05-01', '2014-08-09', NULL),
  300. (27, 2, 1000, 'Virement', '2014-05-01', '2014-07-01', '2014-08-09', NULL),
  301. (28, 2, 1000, 'Virement', '2014-06-01', '2014-09-01', '2014-08-09', NULL),
  302. (30, 16, 1000, 'Virement', '2014-06-01', '2014-07-01', '2014-08-11', NULL),
  303. (32, 16, 1000, 'Virement', '2014-07-01', '2014-08-01', '2014-08-11', NULL),
  304. (33, 16, 1000, 'Virement', '2014-08-01', '2014-09-01', '2014-08-11', NULL),
  305. (34, 15, 1000, 'Virement', '2014-07-01', '2014-08-01', '2014-08-12', NULL),
  306. (35, 15, 1000, 'Virement', '2014-06-01', '2014-07-01', '2014-08-12', NULL),
  307. (36, 14, 3000, 'Virement', '2014-06-01', '2014-09-01', '2014-08-12', NULL),
  308. (37, 22, 6000, 'Virement', '2014-05-01', '2014-11-01', '2014-08-12', NULL),
  309. (38, 21, 1000, 'Virement', '2014-07-01', '2014-08-01', '2014-08-12', NULL),
  310. (39, 21, 1000, 'Virement', '2014-08-01', '2014-09-01', '2014-08-12', NULL),
  311. (40, 21, 1000, 'Virement', '2014-09-01', '2014-10-01', '2014-08-12', NULL),
  312. (41, 21, 1000, 'Virement', '2014-06-01', '2014-07-01', '2014-08-12', NULL),
  313. (42, 1, 1000, 'Virement', '2014-05-01', '2014-06-01', '2014-08-15', NULL);
  314.  
  315. -- --------------------------------------------------------
  316.  
  317. --
  318. -- Structure de la table `enseignant`
  319. --
  320.  
  321. CREATE TABLE `enseignant` (
  322. `en_id` int(11) NOT NULL,
  323. `en_nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  324. `en_prenom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  325. `en_idprofession` int(11) NOT NULL,
  326. `en_idnivet` int(11) NOT NULL,
  327. `en_cin` int(11) NOT NULL,
  328. `enper_cnss` int(11) NOT NULL,
  329. `enper_universite` int(11) NOT NULL,
  330. `en_dateautorisation` int(11) NOT NULL,
  331. `en_niveaux` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  332. `en_diplome` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  333. `idU` int(11) DEFAULT NULL
  334. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  335.  
  336. --
  337. -- Contenu de la table `enseignant`
  338. --
  339.  
  340. INSERT INTO `enseignant` (`en_id`, `en_nom`, `en_prenom`, `en_idprofession`, `en_idnivet`, `en_cin`, `enper_cnss`, `enper_universite`, `en_dateautorisation`, `en_niveaux`, `en_diplome`, `idU`) VALUES
  341. (5, 'hamid', 'ben ammar', 14, 45, 123456, 458, 45, 1, '8', '7', 1),
  342. (6, 'melek', 'ben khicha', 4, 1, 45678, 12356, 1, 12, '4', '5', 1),
  343. (20, 'ammar', 'benammar', 41, 45, 123456, 4756897, 122, 45, '1', '2002', 2);
  344.  
  345. -- --------------------------------------------------------
  346.  
  347. --
  348. -- Structure de la table `enseigner`
  349. --
  350.  
  351. CREATE TABLE `enseigner` (
  352. `E_Num_U` int(11) DEFAULT NULL,
  353. `E_Datedebut` date NOT NULL,
  354. `E_Datefin` date NOT NULL,
  355. `E_nbsemaine` int(11) NOT NULL,
  356. `E_id` int(11) NOT NULL,
  357. `E_idenseignant` int(11) DEFAULT NULL,
  358. `E_num_M` int(11) DEFAULT NULL
  359. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  360.  
  361. -- --------------------------------------------------------
  362.  
  363. --
  364. -- Structure de la table `etablisement`
  365. --
  366.  
  367. CREATE TABLE `etablisement` (
  368. `U_Num` int(11) NOT NULL,
  369. `U_Nom` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  370. `U_numabilitation` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  371. `U_dateabilitation` date DEFAULT NULL,
  372. `U_Adresse` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  373. `U_Telephone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  374. `U_Fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  375. `U_Email` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  376. `U_Site` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  377. `U_CineD` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  378. `U_createur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  379. `verifier` tinyint(1) NOT NULL,
  380. `contactphysique` int(11) DEFAULT NULL,
  381. `contactmorale` int(11) DEFAULT NULL,
  382. `U_id` int(11) NOT NULL
  383. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  384.  
  385. --
  386. -- Contenu de la table `etablisement`
  387. --
  388.  
  389. INSERT INTO `etablisement` (`U_Num`, `U_Nom`, `U_numabilitation`, `U_dateabilitation`, `U_Adresse`, `U_Telephone`, `U_Fax`, `U_Email`, `U_Site`, `U_CineD`, `U_createur`, `verifier`, `contactphysique`, `contactmorale`, `U_id`) VALUES
  390. (123, 'esprit', '123', '2016-03-02', 'tunisie', '98563212', '98652314', 'espri@gmailc.com', 'www.esprit.com', NULL, NULL, 0, NULL, NULL, 1),
  391. (456, 'ihe', '12', '2016-03-08', 'manouba', '1235', '456', 'mmm@gmail.com', 'www.ihe.com', '09823654', '3ammar', 1, NULL, NULL, 2),
  392. (789, 'université central', '569', '2016-03-11', 'beb khadra', '4598765', '4598765', 'universitecentralo@gmail.com', 'www.central.com', '45879', 'mahmoud', 1, NULL, NULL, 3),
  393. (486, 'upes', '782', '2016-03-21', 'megrine', '789654', '12354', 'upes@hotmail.fr', 'www.upes.com', '458713', 'mehdi', 1, NULL, NULL, 4);
  394.  
  395. -- --------------------------------------------------------
  396.  
  397. --
  398. -- Structure de la table `etudiant`
  399. --
  400.  
  401. CREATE TABLE `etudiant` (
  402. `et_id` int(11) NOT NULL,
  403. `et_bac` int(11) DEFAULT NULL,
  404. `et_nom` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  405. `et_prenom` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  406. `et_sexe` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  407. `et_datenaiss` date NOT NULL,
  408. `et_lieuxnaiss` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  409. `address` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  410. `phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  411. `email` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
  412. `note` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  413. `et_cinpass` int(11) NOT NULL,
  414. `et_paye` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  415. `et_datebac` date NOT NULL,
  416. `et_niveauxetude` int(11) NOT NULL,
  417. `idetablisement` int(11) DEFAULT NULL
  418. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  419.  
  420. --
  421. -- Contenu de la table `etudiant`
  422. --
  423.  
  424. INSERT INTO `etudiant` (`et_id`, `et_bac`, `et_nom`, `et_prenom`, `et_sexe`, `et_datenaiss`, `et_lieuxnaiss`, `address`, `phone`, `email`, `note`, `et_cinpass`, `et_paye`, `et_datebac`, `et_niveauxetude`, `idetablisement`) VALUES
  425. (1, 1, 'zae', 'aze', 'homme', '2016-03-01', 'aze', 'aze', '321', 'aymenlabidi19@gmail.com', '123', 321, '123', '2016-03-01', 321, 1),
  426. (2, 2, 'aze', 'aze', 'homme', '2016-03-15', '321', 'azae', '321', 'aymenlabidi19@gmail.com', '321', 321, 'aze', '2016-03-01', 123, 1),
  427. (3, 2, 'aze', 'aze', 'homme', '2016-03-15', '321', 'azae', '321', 'aymenlabidi19@gmail.com', '321', 321, 'aze', '2016-03-01', 123, 1),
  428. (8, 1, 'aymen', 'labidi', 'femme', '2016-03-03', 'libya', 'libya mosrata', '458789', 'aymen.laabidi@gmail.com', 'bhim msatek bagra', 14789, 'libya', '2016-11-22', 1, 1),
  429. (41, 2, 'manel', 'manel', 'femme', '2016-03-09', 'hong kong', 'japan', '789546', 'manel@gmail.com', 'behya barcha', 78954, 'japan', '2016-03-20', 5, 1),
  430. (70, 3, 'med', 'benali', 'homme', '2016-03-15', 'manouba', 'darmanouba', '4596312', 'med@gmail.com', 'bhim', 14741, 'tunis', '2016-03-03', 2, 2),
  431. (79, 4, 'mehdi', 'med', 'homme', '2016-03-20', 'tunis', 'tunis', '459698', 'med@hotmail.com', '40', 7898654, 'tunis', '2016-03-05', 4, 3);
  432.  
  433. -- --------------------------------------------------------
  434.  
  435. --
  436. -- Structure de la table `event`
  437. --
  438.  
  439. CREATE TABLE `event` (
  440. `id` int(11) NOT NULL,
  441. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  442. `date_from` datetime NOT NULL,
  443. `date_to` datetime NOT NULL,
  444. `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  445. `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  446. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  447.  
  448. --
  449. -- Contenu de la table `event`
  450. --
  451.  
  452. INSERT INTO `event` (`id`, `name`, `date_from`, `date_to`, `description`, `type`) VALUES
  453. (2, 'reunion 12', '2014-04-12 00:00:00', '2014-04-13 00:00:00', 'Cette réunion durera 4 heures, elle aura pour objet de (les raisons de la réunion et thèmes qui seront abordés lors de la réunionà ) : par exemple, de vous sensibiliser à notre cause, de vous faire découvrir plus en détail le fonctionnement de notre association…', 'urgent'),
  454. (3, 'reunion', '2014-04-18 00:00:00', '2014-04-23 00:00:00', 'Votre compt a été modifié par un administrateur ou un membre du bureau.\r\n\r\nVous pouvez vous connecter à l\'adresse pour vérifier ces informations ou les modifier.', 'urgent'),
  455. (4, 'social', '2014-04-09 00:00:00', '2014-04-15 00:00:00', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod\r\n tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,\r\n quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo\r\n consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse\r\n cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non\r\n proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 'routine'),
  456. (13, 'google meeting', '2014-07-07 00:00:00', '2014-07-08 00:00:00', 'It\'s time to play "remember when" at our Doe High Class of \'81 reunion next July, and the organizing committee is in high gear!', 'emergency'),
  457. (16, 'Evenement #1', '2014-07-16 05:00:00', '2014-07-16 11:30:00', 'As soon as we receive your registration, we will send you a packet containing further information, including where to stay, what to wear, how much weight to lose, etc. Come join the fun. It was a blast at 20 years. Think what it will be like at 30!!', ''),
  458. (19, 'ramadan karim', '2014-07-15 08:00:00', '2014-07-15 10:30:00', 'everyone', 'réunion de résolution de problèm'),
  459. (26, 'Avertissement', '2014-07-09 08:00:00', '2014-07-09 10:00:00', 'Le rédacteur de cette lettre est diplômé d’une maîtrise en droit des affaires. Ses qualités rédactionnelles sont utilisées tant par les particuliers, que les entreprises. Elle intervient aussi en tant que formatrice en Français. La rigueur de sa formation se retrouve dans ses écrits et est appréciée par tout public.\r\nMembre du Groupement d’Ecrivains Conseils.', 'réunion de résolution de problèm'),
  460. (27, 'all i want', '2014-07-04 00:00:00', '2014-07-05 00:00:00', 'public calendar test', 'réunion de résolution de problèm'),
  461. (28, 'agenda day', '2014-07-25 08:00:00', '2014-07-25 10:00:00', 'calendar day test', 'réunion d’échanges'),
  462. (29, 'curios', '2014-07-10 00:00:00', '2014-07-11 00:00:00', 'curiospress to night', 'réunion d’information'),
  463. (30, 'Evenement #1', '2014-07-18 00:00:00', '2014-07-19 00:00:00', 'every thing', 'réunion d’information'),
  464. (31, 'event', '2014-06-08 00:00:00', '2014-06-09 00:00:00', 'all i need', 'réunion d’échanges'),
  465. (32, 'soutenance de stage', '2014-07-31 00:00:00', '2014-08-01 00:00:00', 'Après le stage vient la soutenance de stage. Contrairement aux idées reçues, c\'est un exercice délicat, et il faut se préparer pour le réussir.', 'réunion d’information'),
  466. (33, 'soutenance de pfe', '2014-07-31 09:00:00', '2014-07-31 11:30:00', 'theme: gestion d\'une association en ligne', 'réunion d’échanges'),
  467. (34, 'eded', '2014-08-06 00:00:00', '2014-08-07 00:00:00', 'sdsds', 'réunion d’information'),
  468. (35, 'tzst', '2014-08-02 00:00:00', '2014-08-03 00:00:00', 'test', 'réunion d’échanges');
  469.  
  470. -- --------------------------------------------------------
  471.  
  472. --
  473. -- Structure de la table `event_group`
  474. --
  475.  
  476. CREATE TABLE `event_group` (
  477. `event_id` int(11) NOT NULL,
  478. `group_id` int(11) NOT NULL
  479. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  480.  
  481. --
  482. -- Contenu de la table `event_group`
  483. --
  484.  
  485. INSERT INTO `event_group` (`event_id`, `group_id`) VALUES
  486. (2, 2),
  487. (3, 1),
  488. (4, 1),
  489. (4, 2),
  490. (13, 2),
  491. (16, 1),
  492. (16, 2),
  493. (19, 1),
  494. (26, 27),
  495. (26, 29),
  496. (27, 2),
  497. (28, 2),
  498. (28, 32),
  499. (29, 27),
  500. (29, 32),
  501. (30, 27),
  502. (31, 1),
  503. (32, 2),
  504. (32, 27),
  505. (33, 1),
  506. (34, 2),
  507. (35, 2),
  508. (35, 27);
  509.  
  510. -- --------------------------------------------------------
  511.  
  512. --
  513. -- Structure de la table `fields`
  514. --
  515.  
  516. CREATE TABLE `fields` (
  517. `id` int(11) NOT NULL,
  518. `table_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  519. `field_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  520. `required` tinyint(1) NOT NULL,
  521. `visible` tinyint(1) NOT NULL,
  522. `position` int(11) NOT NULL,
  523. `nicename` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  524. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  525.  
  526. --
  527. -- Contenu de la table `fields`
  528. --
  529.  
  530. INSERT INTO `fields` (`id`, `table_name`, `field_name`, `required`, `visible`, `position`, `nicename`) VALUES
  531. (1, 'adherant', 'username', 1, 1, 1, 'id'),
  532. (2, 'adherant', 'familyname', 1, 1, 1, 'nom'),
  533. (3, 'adherant', 'firstname', 1, 1, 2, 'prenom'),
  534. (4, 'adherant', 'cin', 1, 1, 3, 'cin'),
  535. (5, 'adherant', 'birthday', 1, 1, 4, 'date de naissance'),
  536. (6, 'adherant', 'gender', 1, 0, 5, 'sexe'),
  537. (7, 'adherant', 'address', 1, 0, 6, 'adresse'),
  538. (8, 'adherant', 'postcode', 1, 0, 7, 'N°'),
  539. (9, 'adherant', 'contry', 1, 0, 8, 'pay'),
  540. (10, 'adherant', 'job', 1, 0, 9, 'proffession'),
  541. (11, 'adherant', 'tel', 1, 0, 10, 'tel'),
  542. (12, 'adherant', 'gsm', 1, 0, 11, 'gsm'),
  543. (13, 'adherant', 'diplome', 1, 0, 8, 'niveau scolaire'),
  544. (14, 'adherant', 'expertise', 1, 0, 8, 'specialité'),
  545. (15, 'cotisation', 'id', 1, 1, 1, 'Identifiant'),
  546. (16, 'cotisation', 'user', 1, 1, 2, 'Adherent'),
  547. (17, 'cotisation', 'type', 1, 1, 3, 'Type'),
  548. (18, 'cotisation', 'datefrom', 1, 1, 4, 'Date début'),
  549. (19, 'cotisation', 'dateto', 1, 0, 5, 'Date fin'),
  550. (20, 'cotisation', 'description', 1, 0, 6, 'Description'),
  551. (21, 'adherant', 'role', 1, 1, 3, 'Type de compte'),
  552. (22, 'adherant', 'etat', 1, 0, 4, 'Etat'),
  553. (23, 'cotisation', 'price', 1, 1, 3, 'Montant'),
  554. (24, 'adherant', 'groupList', 1, 0, 12, 'Groupe'),
  555. (25, 'adherant', 'status', 1, 1, 13, 'Status'),
  556. (26, 'etablisement', 'UAdresse', 1, 1, 1, ''),
  557. (27, 'etablisement', 'UTelephone', 1, 1, 1, 'Telephone'),
  558. (29, 'etablisement', 'UNumabilitation', 1, 1, 1, 'Numabilitation'),
  559. (30, 'etablisement', 'UNum', 1, 1, 1, 'Num'),
  560. (114, 'etablisement', 'UNom', 1, 1, 2, 'Nom'),
  561. (115, 'etablisement', 'UDateabilitation', 1, 1, 1, 'Dateabilitation'),
  562. (116, 'etablisement', 'UAdresse', 1, 1, 1, 'Adresse'),
  563. (117, 'etablisement', 'UFax', 1, 1, 1, 'Fax'),
  564. (118, 'etablisement', 'UEmail', 1, 1, 1, 'Email'),
  565. (119, 'etablisement', 'USite', 1, 1, 1, 'Site'),
  566. (120, 'etablisement', 'UCined', 1, 1, 1, 'Cined'),
  567. (121, 'etablisement', 'UCreateur', 1, 1, 1, 'Createur'),
  568. (122, 'etablisement', 'Contactphysique', 1, 1, 1, 'Contactphysique'),
  569. (123, 'etablisement', 'Contactmorale', 1, 1, 1, 'Contactmorale'),
  570. (124, 'etablisement', 'UId', 1, 1, 1, 'Id'),
  571. (140, 'etudiant', 'EtNom', 1, 1, 1, 'EtudiantNom'),
  572. (141, 'etudiant', 'EtPrenom', 1, 1, 1, 'EtudiantPrenom'),
  573. (142, 'etudiant', 'EtSexe', 1, 1, 1, 'EtudiantSexe'),
  574. (143, 'etudiant', 'EtDatenaiss', 1, 1, 1, 'EtudiantDatenaissance'),
  575. (144, 'etudiant', 'EtLieuxnaiss', 1, 1, 1, 'EtudiantLieuxnaissance'),
  576. (145, 'etudiant', 'Address', 1, 1, 1, 'Addresse'),
  577. (146, 'etudiant', 'Phone', 1, 1, 1, 'Phone'),
  578. (147, 'etudiant', 'Email', 1, 1, 1, 'Email'),
  579. (148, 'etudiant', 'Note', 1, 1, 1, 'Note'),
  580. (149, 'etudiant', 'EtCinpass', 1, 1, 1, 'EtudiantCinpassword'),
  581. (150, 'etudiant', 'EtPaye', 1, 1, 1, 'EtudiantPaye'),
  582. (151, 'etudiant', 'EtDatebac', 1, 1, 1, 'EtudiantDatebac'),
  583. (152, 'etudiant', 'EtNiveauxetude', 1, 1, 1, 'EtudiantNiveauxetude'),
  584. (153, 'etudiant', 'EtId', 1, 1, 1, 'EtId'),
  585. (154, 'etudiant', 'EtBac', 1, 1, 1, 'EtBac'),
  586. (215, 'enseignant', 'EnNom', 1, 1, 1, 'enseignant nom'),
  587. (216, 'enseignant', 'EnPrenom', 1, 1, 1, 'enseignant prenom'),
  588. (217, 'enseignant', 'EnIdprofession', 1, 1, 1, 'enseignant id profession'),
  589. (218, 'enseignant', 'EnIdnivet', 1, 1, 1, 'EnIdnivet'),
  590. (219, 'enseignant', 'EnCin', 1, 1, 1, 'enseignant cin'),
  591. (220, 'enseignant', 'EnperCnss', 1, 1, 1, 'enseignant cnss'),
  592. (221, 'enseignant', 'EnperUniversite', 1, 1, 1, 'EnperUniversite'),
  593. (222, 'enseignant', 'EnDateautorisation', 1, 1, 1, 'EnDateautorisation'),
  594. (223, 'enseignant', 'EnNiveaux', 1, 1, 1, 'EnNiveaux'),
  595. (224, 'enseignant', 'EnDiplome', 1, 1, 1, 'EnDiplome'),
  596. (225, 'enseignant', 'EnId', 1, 1, 1, 'EnId'),
  597. (236, 'filiere', 'Nomf', 1, 1, 1, 'nomfiliere'),
  598. (237, 'filiere', 'Dateabilifiliere', 1, 1, 1, 'dateabilitationfiliere'),
  599. (238, 'filiere', 'Idetabfil', 1, 1, 1, 'idetablissementfiliere\r\n'),
  600. (239, 'filiere', 'Idf', 1, 1, 1, 'Idf');
  601.  
  602. -- --------------------------------------------------------
  603.  
  604. --
  605. -- Structure de la table `filiere`
  606. --
  607.  
  608. CREATE TABLE `filiere` (
  609. `idf` int(11) NOT NULL,
  610. `nomf` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL,
  611. `dateabilifiliere` date NOT NULL,
  612. `idetabfil` int(11) DEFAULT NULL
  613. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  614.  
  615. --
  616. -- Contenu de la table `filiere`
  617. --
  618.  
  619. INSERT INTO `filiere` (`idf`, `nomf`, `dateabilifiliere`, `idetabfil`) VALUES
  620. (1, 'informatique applique a la lettre', '2016-03-02', 1),
  621. (2, 'gestion appliquer al la science', '2016-03-02', 1);
  622.  
  623. -- --------------------------------------------------------
  624.  
  625. --
  626. -- Structure de la table `image`
  627. --
  628.  
  629. CREATE TABLE `image` (
  630. `id` int(11) NOT NULL,
  631. `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
  632. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  633.  
  634. --
  635. -- Contenu de la table `image`
  636. --
  637.  
  638. INSERT INTO `image` (`id`, `path`) VALUES
  639. (1, 'c91914159ee8f2811782e1ffdd80dbbf8b194694.jpeg'),
  640. (2, '4c0540375af6fc4d3836cb78cd369d9f0b549aea.jpeg'),
  641. (5, '328ea7de1a65a77aa8197125033b670bc812fce2.jpeg'),
  642. (7, 'ba1659fa24d33bd257a592d62f2e4748ea7e75f5.jpeg'),
  643. (8, '26f0587f0b12001e8d31f0bc26cc1efd058a6fad.jpeg'),
  644. (10, '997f897d09cceb1320f6a061ff38b71f5ee56992.png'),
  645. (11, '97f8df77f39af858dd08ffcfb65313ac39cf5a89.jpeg'),
  646. (12, '3d64d7744a943384e987544c0140589eb9fd6a90.jpeg'),
  647. (15, '3d13bcd78407ea86f1c89ac911b59787c8463d19.jpeg'),
  648. (16, '521b1eed29521eef9dd2ed219aadd1f156a7cf28.png'),
  649. (18, '4ff81bd3f6cbc76483f00673eeaf3c8eb0fcb028.jpeg'),
  650. (19, '869417ff687150ce5fd43e97354057d0d2249623.jpeg'),
  651. (20, 'd17b0d14bdd7f7bbbe6081fdc5c8d1301e1792b9.png'),
  652. (23, '49d9d1fad15cf415037d91752c4cee0e7ed30bc6.png'),
  653. (24, 'anonymous.jpg'),
  654. (25, 'anonymous.jpg'),
  655. (26, 'anonymous.jpg'),
  656. (27, 'anonymous.jpg'),
  657. (29, 'unknown.png'),
  658. (30, 'unknown.png'),
  659. (31, '46c6b125daa85f495ac24989e6e9d77a7b9e1ba6.png'),
  660. (33, '7e68963b5f4ed623520c182fd13d4b5d256c4f04.png'),
  661. (34, 'unknown.png'),
  662. (36, '89bdde187dd95c2c71bed7625aaa72b6854c78ed.png'),
  663. (39, 'anonymous.jpg'),
  664. (40, 'c5928045515da702858ef92c2b1e74f139608832.png'),
  665. (45, 'anonymous.jpg'),
  666. (46, 'anonymous.jpg'),
  667. (65, 'anonymous.jpg'),
  668. (66, 'anonymous.jpg'),
  669. (75, '7ef3ebeaf739452883c437b5e3029eae8e1686d1.jpeg'),
  670. (81, 'unknown.png'),
  671. (82, 'unknown.png'),
  672. (83, 'unknown.png');
  673.  
  674. -- --------------------------------------------------------
  675.  
  676. --
  677. -- Structure de la table `matiere`
  678. --
  679.  
  680. CREATE TABLE `matiere` (
  681. `m_id` int(11) NOT NULL,
  682. `m_nommatiere` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  683. `m_nbh_semain` int(11) NOT NULL,
  684. `id_filere` int(11) NOT NULL
  685. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  686.  
  687. -- --------------------------------------------------------
  688.  
  689. --
  690. -- Structure de la table `message`
  691. --
  692.  
  693. CREATE TABLE `message` (
  694. `id` int(11) NOT NULL,
  695. `thread_id` int(11) DEFAULT NULL,
  696. `user_id` int(11) DEFAULT NULL,
  697. `body` longtext COLLATE utf8_unicode_ci NOT NULL,
  698. `created_at` datetime NOT NULL
  699. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  700.  
  701. -- --------------------------------------------------------
  702.  
  703. --
  704. -- Structure de la table `message_metadata`
  705. --
  706.  
  707. CREATE TABLE `message_metadata` (
  708. `id` int(11) NOT NULL,
  709. `message_id` int(11) DEFAULT NULL,
  710. `participant_id` int(11) DEFAULT NULL,
  711. `is_read` tinyint(1) NOT NULL
  712. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  713.  
  714. -- --------------------------------------------------------
  715.  
  716. --
  717. -- Structure de la table `mygroup`
  718. --
  719.  
  720. CREATE TABLE `mygroup` (
  721. `id` int(11) NOT NULL,
  722. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  723. `image_id` int(11) DEFAULT NULL,
  724. `kind` varchar(20) COLLATE utf8_unicode_ci NOT NULL
  725. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  726.  
  727. --
  728. -- Contenu de la table `mygroup`
  729. --
  730.  
  731. INSERT INTO `mygroup` (`id`, `name`, `image_id`, `kind`) VALUES
  732. (1, 'Adhérents', 29, 'groupe'),
  733. (2, 'administrateurs', 30, 'groupe'),
  734. (27, 'actif membe', 31, 'groupe'),
  735. (29, 'Apple', 33, 'groupe'),
  736. (30, 'Femme', 34, 'groupe'),
  737. (32, 'Homme', 36, 'groupe'),
  738. (38, 'commision', 81, 'commission'),
  739. (39, 'Comission A', 82, 'commission'),
  740. (40, 'commision2', 83, 'commission');
  741.  
  742. -- --------------------------------------------------------
  743.  
  744. --
  745. -- Structure de la table `profile`
  746. --
  747.  
  748. CREATE TABLE `profile` (
  749. `id` int(11) NOT NULL,
  750. `image_id` int(11) DEFAULT NULL,
  751. `family_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  752. `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  753. `barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  754. `cin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  755. `birthday` date NOT NULL,
  756. `gender` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  757. `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  758. `post_code` int(11) DEFAULT NULL,
  759. `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  760. `contry` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  761. `job` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  762. `tel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  763. `gsm` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  764. `diplome` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  765. `expertise` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  766. `description` longtext COLLATE utf8_unicode_ci,
  767. `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  768. `facebook` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  769. `google` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  770. `twitter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  771. `frequence` int(11) DEFAULT NULL,
  772. `method` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  773. `montant` double NOT NULL,
  774. `archived` tinyint(1) NOT NULL,
  775. `cause` longtext COLLATE utf8_unicode_ci
  776. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  777.  
  778. --
  779. -- Contenu de la table `profile`
  780. --
  781.  
  782. INSERT INTO `profile` (`id`, `image_id`, `family_name`, `first_name`, `barcode`, `cin`, `birthday`, `gender`, `address`, `post_code`, `city`, `contry`, `job`, `tel`, `gsm`, `diplome`, `expertise`, `description`, `website`, `facebook`, `google`, `twitter`, `frequence`, `method`, `montant`, `archived`, `cause`) VALUES
  783. (1, 1, 'fennira', 'manel', '936562895', 'AE60561', '1992-03-04', 'homme', 'lot charaf n42 salé', 11060, 'rabat', 'maroc', 'web developer', '0644354522', '0532155623', NULL, NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi id neque quam. Aliquam sollicitudin venenatis ipsum ac feugiat. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi id neque quam. Aliquam sollicitu sollicitudin ve din venenatis ipsum action.', 'http://fb.com', 'http://fb.com/med.ben', 'http://plus.google.com', 'http://twitter.com/med_benaich', 1, 'Virement', 1000, 0, NULL),
  784. (2, 2, 'abdelilah', 'saif', '690254796', 'AZ20130', '1992-12-01', 'homme', 'nice 007 casablaca', 11060, 'casablaca', 'maroc', 'designer', '0644354522', '0532155623', NULL, NULL, 'heee', 'http://fb.com', 'http://fb.com/med.ben', 'http://plus.google.com', 'http://twitter.com/med_benaich', 3, 'Virement', 1000, 0, NULL),
  785. (8, 10, 'jeffrey', 'lise', '954674278', 'BH50786', '1990-04-11', 'homme', 'agdal avenue Atlass - Rabat', NULL, 'rabat', NULL, 'designer', NULL, '0532155623', NULL, NULL, 'I recently released my latest book, which covers the ins and outs of testing in PHP and, more specifically, Laravel.', NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 1, 'az'),
  786. (11, 15, 'Chris', 'Brown', '1255723804', 'BH28888', '1993-04-12', 'homme', 'nice 007 casablaca', 11060, 'new york', 'usa', 'designer', '0644354555', '0532155623', NULL, NULL, 'hi', NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, ''),
  787. (12, 16, 'ely', 'john', '556931090', 'AZ20654', '1992-04-18', 'homme', 'lot charaf n42 salé', 1106, 'salé', 'maroc', 'superman', '0622354515', '0541265412', NULL, NULL, 'hi', NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, ''),
  788. (14, 18, 'maldan', 'abir', '1111393039', 'EZ77940', '1990-04-19', 'femme', 'nice 007 casablaca', 25009, 'fez', 'maroc', 'designer', '0644354522', '0541265412', NULL, NULL, 'abire-nane :)', 'http://fb.com', 'http://fb.com/abir', 'http://plus.google.com', 'http://twitter.com/abir_nane', 3, 'Virement', 3000, 0, NULL),
  789. (15, 19, 'el arabi', 'yasser', '425282827', 'AZ4563', '1992-06-22', 'homme', 'lot said hajji n1978', 11060, 'salé', 'maroc', 'Prof', '0645981830', '0537654113', 'licence', 'Physique', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  790. (16, 20, 'bougerr', 'hatim', '1019650613', 'AE5132', '1991-06-24', 'homme', 'lot said hajji n1978', 15902, 'rabat', 'maroc', 'etudiant', '0645981830', '0537654113', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  791. (19, 23, 'el amrani', 'nahid', '749584944', 'AB45635', '1993-07-09', 'femme', 'hay nahda n1956 rabat', 12060, 'rabat', 'maroc', 'webmaster', '0644972133', '0537563215', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  792. (20, 24, 'el hajji', 'anoire', '540809317', 'AZ20156', '1990-07-10', 'homme', 'agdal avenue Atlass - Rabat', 12050, 'rabat', 'maroc', 'Acteur', '0644354522', '0537654113', 'DEUG', 'génie informatique', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 1, 'raison du rejet'),
  793. (21, 25, 'nadir', 'siham', '1200811083', 'AZ20155', '1995-07-13', 'femme', 'agdal avenue Atlass - Rabat', 156201, 'rabat', 'maroc', 'designer', '0622354515', '0537654113', 'dut', 'Informatique', 'nothing', NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 1, 'raison du rejet'),
  794. (22, 26, 'aznag', 'salim', '647722108', 'ED4563', '1980-07-14', 'homme', 'nice 007 casablaca', 11103, 'el jadida', 'maroc', 'medecin', '0644972133', '0537563215', 'doctorat', 'Medcine', NULL, NULL, NULL, NULL, NULL, 6, 'Virement', 6000, 0, NULL),
  795. (23, 27, 'sarah', 'houda', '270565059', 'AV7850', '1993-07-18', 'femme', 'lot tam n788 fez', 154602, 'fez', 'maroc', 'web designer', '0645412462', NULL, 'master', 'Informatique', 'nothing to say !', NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  796. (24, 39, 'Arich', 'sihame', '865662066', 'AS0561', '1990-07-10', 'femme', 'agdal avenue Atlass - Rabat', NULL, 'rabat', 'maroc', 'psychologue', '0645981830', '0532155623', 'master', 'autres', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  797. (25, 40, 'Arich', 'houda', '865662089', 'BH8080', '1990-07-10', 'femme', 'agdal avenue Atlass - Rabat', NULL, 'rabat', 'maroc', 'psychologue', '0645981830', '0532155623', 'master', 'autres', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  798. (30, 45, 'benaich', 'issam', '729572105', 'As605121', '1992-04-03', 'homme', NULL, 11050, 'rabat', 'maroc', 'job', '0644354522', '0532155623', '', '0644354522', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  799. (31, 46, 'nidal', 'affaf', '12088015', 'AS605121', '1994-04-03', 'homme', NULL, 11120, 'casablanca', 'maroc', 'job', '0644354522', '0532155623', '', '0644354522', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  800. (50, 65, 'atih', 'issam', '736496234', 'FR605121', '1992-03-04', 'homme', NULL, 11050, 'rabat', 'maroc', 'job', '0644354522', '0532155623', '', '0644354522', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  801. (51, 66, 'badili', 'islam', '1060641394', 'SV65125', '1994-03-05', 'homme', NULL, 11120, 'casablanca', 'maroc', 'job', '0644354522', '0532155623', '', '0644354522', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL),
  802. (60, 75, 'semouni', 'youssef', '923218000', 'as5122', '1992-11-12', 'homme', 'atyto nasa n245', 221555, 'sefrou', 'maroc', 'pilote', '637546212', '0537562202', 'doctorat', 'mathématique', NULL, NULL, NULL, NULL, NULL, 1, 'Virement', 1000, 0, NULL);
  803.  
  804. -- --------------------------------------------------------
  805.  
  806. --
  807. -- Structure de la table `status`
  808. --
  809.  
  810. CREATE TABLE `status` (
  811. `id` int(11) NOT NULL,
  812. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  813. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  814.  
  815. --
  816. -- Contenu de la table `status`
  817. --
  818.  
  819. INSERT INTO `status` (`id`, `name`) VALUES
  820. (1, 'Président'),
  821. (2, 'Vice-président'),
  822. (3, 'Trésorier'),
  823. (4, 'Secrétaire'),
  824. (5, 'Membre actif'),
  825. (6, 'Membre bienfaiteur'),
  826. (7, 'Membre fondateur'),
  827. (8, 'Ancien membre'),
  828. (9, 'Personne morale');
  829.  
  830. -- --------------------------------------------------------
  831.  
  832. --
  833. -- Structure de la table `thread`
  834. --
  835.  
  836. CREATE TABLE `thread` (
  837. `id` int(11) NOT NULL,
  838. `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  839. `created_at` datetime NOT NULL,
  840. `is_spam` tinyint(1) NOT NULL,
  841. `createdBy_id` int(11) DEFAULT NULL
  842. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  843.  
  844. -- --------------------------------------------------------
  845.  
  846. --
  847. -- Structure de la table `thread_metadata`
  848. --
  849.  
  850. CREATE TABLE `thread_metadata` (
  851. `id` int(11) NOT NULL,
  852. `thread_id` int(11) DEFAULT NULL,
  853. `participant_id` int(11) DEFAULT NULL,
  854. `is_deleted` tinyint(1) NOT NULL,
  855. `last_participant_message_date` datetime DEFAULT NULL,
  856. `last_message_date` datetime DEFAULT NULL
  857. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  858.  
  859. -- --------------------------------------------------------
  860.  
  861. --
  862. -- Structure de la table `user`
  863. --
  864.  
  865. CREATE TABLE `user` (
  866. `id` int(11) NOT NULL,
  867. `profile_id` int(11) DEFAULT NULL,
  868. `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  869. `username_canonical` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  870. `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  871. `email_canonical` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  872. `enabled` tinyint(1) NOT NULL,
  873. `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  874. `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  875. `last_login` datetime DEFAULT NULL,
  876. `locked` tinyint(1) NOT NULL,
  877. `expired` tinyint(1) NOT NULL,
  878. `expires_at` datetime DEFAULT NULL,
  879. `confirmation_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  880. `password_requested_at` datetime DEFAULT NULL,
  881. `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  882. `credentials_expired` tinyint(1) NOT NULL,
  883. `credentials_expire_at` datetime DEFAULT NULL,
  884. `created` datetime NOT NULL,
  885. `lastActivity` datetime NOT NULL
  886. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  887.  
  888. --
  889. -- Contenu de la table `user`
  890. --
  891.  
  892. INSERT INTO `user` (`id`, `profile_id`, `username`, `username_canonical`, `email`, `email_canonical`, `enabled`, `salt`, `password`, `last_login`, `locked`, `expired`, `expires_at`, `confirmation_token`, `password_requested_at`, `roles`, `credentials_expired`, `credentials_expire_at`, `created`, `lastActivity`) VALUES
  893. (1, 1, 'admin', 'admin', 'benaich.med@gmail.com', 'benaich.med@gmail.com', 1, 'i1tqgxrnlb4gwgoc48gck0okck4g80o', '$2y$13$i1tqgxrnlb4gwgoc48gckunaZuRdUt9ki2VmItqFj1VAIQt4493Em', '2016-03-30 08:56:06', 0, 0, NULL, '65h6wbc7ors4ccc8cw080sc4gk4kkcs848g00wo000k4so04kw', '2014-07-29 10:21:14', 'a:1:{i:0;s:10:"ROLE_ADMIN";}', 0, NULL, '2014-04-06 12:50:31', '2014-08-27 11:57:15'),
  894. (2, 2, 'ben', 'ben', 'benaich@gmail.com', 'benaich@gmail.com', 1, 'm9tlvb01d5w4scc888g0o88wso448wk', 'WsVZ/nZ+K1nZhuyZpn7HWV4w4sx6gpzeMTNlQnBvgViEcOtfrM9L5lP3qER6+emNzbQDSbGSCM0eUJM+9Of/Uw==', '2014-07-06 22:22:30', 0, 0, NULL, NULL, NULL, 'a:1:{i:0;s:10:"ROLE_ADMIN";}', 0, NULL, '2014-04-06 12:50:57', '2014-07-06 22:37:02'),
  895. (8, 8, 'jeffrey', 'jeffrey', 'jefway@yahoo.fr', 'jefway@yahoo.fr', 1, 'clkdz5g0xrcok4k0w84ss404oc888s8', '9lIUx9hVq9Ix6NIcrtZqAZXR0yGCMCKiQf/tiihiMoy47hlgcx3YN4s4miBGwyywXfb/O7lQtjAsS0Om62nHRA==', '2014-07-29 17:15:51', 0, 0, NULL, '9b974arbrkkc08kwwcsg8osscwwog0kok004ogssg0wwgckok', '2014-07-10 23:45:01', 'a:1:{i:0;s:12:"ROLE_MANAGER";}', 0, NULL, '2014-04-11 20:23:02', '2014-07-29 18:10:14'),
  896. (11, 11, '@chris', '@chris', 'jefway_way@yahoo.fr', 'jefway_way@yahoo.fr', 1, 'tbobjn6qafkc0cgk0w0k4kkc8ssksk8', 'FW5RA2S1j18w4Zs9fZnnaDTMTQ6CCbeFqi+cf345RS4wrHWdPcbZnIv8V3lAJMXsktShYErUYxy3pv17eg5WzA==', '2014-07-29 18:16:12', 0, 0, NULL, '5ktqe48513goskoc0oswc0gs80c00080o8woo80s4k8c4o44kg', '2014-07-29 18:16:27', 'a:0:{}', 0, NULL, '2014-04-12 09:38:36', '2014-07-29 18:14:23'),
  897. (12, 12, 'ely-john', 'ely-john', 'ely-08@gmail.fr', 'ely-08@gmail.fr', 1, 'd44388lnqgow4k40sgssokgkwo8gogs', 'VFuFaDWimiaJLsDXo6K8sL++F04Ms2FPV7/FcxDITSES8AnyI2Q3FZa5rq5W40dbaH5x2k1S7zP0LsQxiEA2oA==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-04-18 20:03:25', '2014-04-18 20:03:25'),
  898. (14, 14, 'abire-nane', 'abire-nane', 'abir.nane@gmail.com', 'abir.nane@gmail.com', 1, 'kq42s2iayn4ks0s4sk8ww00k80gw0o8', 'DAZ++wYR+xuPG4oXSyyynasYcz2oLQ9bYpJe5MsIjnz6ozCTTUffQF+bJiir7SMZxIRsgzeqAeSgT1gHGIdPdQ==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-04-19 20:46:19', '2014-04-19 20:46:19'),
  899. (15, 15, '@yasser', '@yasser', 'azziz123@gmail.com', 'azziz123@gmail.com', 0, '8bi7dpzp0f0gksskcw88c0s40sg8gw0', 'AcoLxDFoJ8lZRw/YkYF+HNJY1pxYc0PEhPeRlLwW2Q4FJhUgByoiJBq+BNGJ3nQV6mqaygA9FcZ1VbLu62bU8g==', '2014-07-05 14:23:25', 0, 0, NULL, '343kyfahtm048okgs8o40s40gcss08kkwsg0o0gc84wow4wgcs', '2014-07-27 14:59:27', 'a:1:{i:0;s:12:"ROLE_MANAGER";}', 0, NULL, '2014-06-24 19:48:38', '2014-07-05 14:24:42'),
  900. (16, 16, '@hatim', '@hatim', 'rami-h@gmail.com', 'rami-h@gmail.com', 1, 'kfcdl83kkrkggso8k4cokgokg4k4s4o', 'DQFqxbOHGjeK/Avn44WeZuJekVE9jRqMelDx7/A07ATZ2Xcy/b6VQUZCjG+c4W9TRPbF9iXHF794p9S3lLJJdg==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-06-24 20:23:42', '2014-06-24 20:23:42'),
  901. (19, 19, '@nahid', '@nahid', 'nahid@gmail.com', 'nahid@gmail.com', 0, 'de8uq2z2jhw848co0448ckgswosoc8g', 'za92QEt3wxxz4Bcci85j/9b7PWkTuJlB52QhYCoWLAoRxceF12b9cqlr47ub4Z03tyWn8v53c0rqvJQvsmymNw==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-07-09 23:35:17', '2014-07-09 23:35:17'),
  902. (20, 20, '@anoire', '@anoire', 'anoire-05@gmail.com', 'anoire-05@gmail.com', 0, 'bqv9fbramts8w8wsok4k4skcgwcos8w', 'OToSvzTa3I5MYXgmyLsOoykJau0nMa13SX8rUby7AuJHQUGbVwX388Cb9fxuATtAT33Rqish4AbJAT+d31eGrA==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-07-10 13:13:16', '2014-07-10 13:13:16'),
  903. (21, 21, '@sihame', '@sihame', 'sihame03@gmail.com', 'sihame03@gmail.com', 1, '4qwguzf2qw00oss48sook0o0gw08044', 'ZRbK4Cbn1eqQ1W4/WR5BjvWiY50Mb38eYFnVV9kMTuDmjGGrCKhEGPkALl0lbQcW90G9sbu7tUk83STEMDOj3A==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-07-13 22:46:16', '2014-07-13 22:46:16'),
  904. (22, 22, '@salim', '@salim', 'salim10@gmail.com', 'salim10@gmail.com', 0, 'ghy5rx8yuygws8w0cg4sc8gwc8wssgk', 'FADeRkUzxEe6KCYF8PH4U3+UKCvi0sLmZrQGlywOb8l8prrglbI9z7EGJW9fMIUX2aKsEsTO/T1tfsrtnB9h6Q==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-07-14 10:24:17', '2014-07-14 10:24:17'),
  905. (23, 23, '@ben', '@ben', 'sarah09@gmail.com', 'sarah09@gmail.com', 0, 'cbhmxlxaqzccosg8s40kckwwo4g088w', '7ZTeDjY3liwSWip/qtYcA72cRgG1bC449GIapED9GGRwd4vFqJfa6yHhSZrs2m16i/Ae78OZwdTPLss64+GNTQ==', NULL, 0, 0, NULL, '5cijjippzio84c4o0c84so08ookck8wc0kcckkgsk4w808gwk0', '2014-07-27 14:55:01', 'a:0:{}', 0, NULL, '2014-07-18 15:29:02', '2014-07-18 15:29:02'),
  906. (24, 24, '@arich', '@arich', 'adnane@gmail.com', 'adnane@gmail.com', 1, 'nlaf8kxc9q84wccgkcwkskck8soo8s0', 'fPcva05cuCUIRfabUHX3iCZ4kNdx6UMzCe5Jr4ayurg36t0CAqPKgiviPCOJCnrwIMvQjU4On3kimXhUpopzNg==', '2014-07-24 17:30:14', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-07-20 16:27:39', '2014-07-24 17:23:49'),
  907. (25, 25, '@houda', '@houda', 'houda@gmail.com', 'houda@gmail.com', 1, 'n2h5uwbh7c0kc4k0ks8s8ooowoo0sws', 'fRXchgGAd5bqHHqGWB3sxt0w1Z7wg7O7tDomh1wtvpntMOwVt2/PwH5IKLXLaZeE4l4sSWPs7wLnfw0Fc7dCfQ==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-07-20 16:32:25', '2014-07-20 16:32:25'),
  908. (28, 30, '@benmed2', '@benmed2', 'benmed2@gmail.com', 'benmed2@gmail.com', 0, 'c7z2qulf6woww48wwk0g0wocs0cw0sc', 'mgRIXoGl1WmDoCLwS3DFY6F1OVrtCZ4DCRa5zi7P8JVfEESt0iCyejslMNuAAbp9KoaieMve7SBhhODzOHzWlw==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-06-04 00:00:00', '2014-07-29 14:35:56'),
  909. (29, 31, '@affaf', '@affaf', 'affaf@gmail.com', 'affaf@gmail.com', 0, 'jrg32m9rmbkw4kggo4gc4o08gs884gc', '+bh8Azt92xr71smwTbZ6U6ZRx574dnwLHdVc6d1DgiW/mJlp4XZvlvU15aUv6rSBBcgqwPWSPcdYYyCR5rHR8A==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-06-04 00:00:00', '2014-07-29 14:35:56'),
  910. (40, 50, '@atik', '@atik', 'atul@gmail.com', 'atul@gmail.com', 0, 'dpwn84h2wn40o88c8g8wg0ook8oogs8', '6ZoSm1pvYoepd33LviSn9FtJW/AivpFDVe84+whFmoApiFEUUvPDHsEMrlkgwZQIloCErwOz5VzeocNARLglNw==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-04-06 14:59:59', '2014-07-29 14:59:59'),
  911. (41, 51, '@nassim', '@nassim', 'nassim@gmail.com', 'nassim@gmail.com', 0, 'cu4ov9v48rw448kk0gw0wg84kgkw4w4', 'DFYGf4u0Xt4eVtXwcdBkjdznVYkaAvSGdAcjkC/h7lI4JYGEG7YsZq/9XdoBycqrJ9Bu396yuBPK8t8vXIBUTg==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-04-06 15:00:00', '2014-07-29 15:00:00'),
  912. (45, 60, '@sefrou', '@sefrou', 'y.semouni@yahoo.fr', 'y.semouni@yahoo.fr', 0, 'eqyc1subprswswog8wwsck4k0o84w0c', 'GLhwOgepoAqWgizs/R/cK7VrPLIrPh7TUN8AWtncTUn5xCGx7RwkvCp93uEykgK/5sK+uIOLmdSv98XvU1vbIA==', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, '2014-07-29 18:09:27', '2014-07-29 18:09:27');
  913.  
  914. -- --------------------------------------------------------
  915.  
  916. --
  917. -- Structure de la table `user_group`
  918. --
  919.  
  920. CREATE TABLE `user_group` (
  921. `user_id` int(11) NOT NULL,
  922. `group_id` int(11) NOT NULL
  923. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  924.  
  925. --
  926. -- Contenu de la table `user_group`
  927. --
  928.  
  929. INSERT INTO `user_group` (`user_id`, `group_id`) VALUES
  930. (1, 1),
  931. (1, 2),
  932. (2, 1),
  933. (2, 2),
  934. (2, 39),
  935. (8, 1),
  936. (8, 38),
  937. (11, 1),
  938. (12, 1),
  939. (14, 1),
  940. (14, 30),
  941. (14, 40),
  942. (15, 1),
  943. (15, 2),
  944. (15, 40),
  945. (16, 1),
  946. (19, 1),
  947. (19, 30),
  948. (19, 39),
  949. (20, 1),
  950. (20, 39),
  951. (21, 1),
  952. (21, 30),
  953. (22, 1),
  954. (23, 1),
  955. (23, 30),
  956. (24, 1),
  957. (24, 30),
  958. (25, 30),
  959. (45, 40);
  960.  
  961. --
  962. -- Index pour les tables exportées
  963. --
  964.  
  965. --
  966. -- Index pour la table `activity_log`
  967. --
  968. ALTER TABLE `activity_log`
  969. ADD PRIMARY KEY (`id`);
  970.  
  971. --
  972. -- Index pour la table `avancement`
  973. --
  974. ALTER TABLE `avancement`
  975. ADD PRIMARY KEY (`id`),
  976. ADD KEY `IDX_6D2A7A2AA76ED395` (`user_id`),
  977. ADD KEY `IDX_6D2A7A2A6BF700BD` (`status_id`);
  978.  
  979. --
  980. -- Index pour la table `bac`
  981. --
  982. ALTER TABLE `bac`
  983. ADD PRIMARY KEY (`id_bac`);
  984.  
  985. --
  986. -- Index pour la table `config`
  987. --
  988. ALTER TABLE `config`
  989. ADD PRIMARY KEY (`id`);
  990.  
  991. --
  992. -- Index pour la table `contact_physique`
  993. --
  994. ALTER TABLE `contact_physique`
  995. ADD PRIMARY KEY (`CO_Id`);
  996.  
  997. --
  998. -- Index pour la table `cotisation`
  999. --
  1000. ALTER TABLE `cotisation`
  1001. ADD PRIMARY KEY (`id`),
  1002. ADD KEY `IDX_AE64D2EDA76ED395` (`user_id`);
  1003.  
  1004. --
  1005. -- Index pour la table `enseignant`
  1006. --
  1007. ALTER TABLE `enseignant`
  1008. ADD PRIMARY KEY (`en_id`),
  1009. ADD KEY `idU` (`idU`),
  1010. ADD KEY `idU_2` (`idU`);
  1011.  
  1012. --
  1013. -- Index pour la table `enseigner`
  1014. --
  1015. ALTER TABLE `enseigner`
  1016. ADD PRIMARY KEY (`E_id`),
  1017. ADD KEY `E_Num_U` (`E_Num_U`),
  1018. ADD KEY `E_num_F` (`E_num_M`),
  1019. ADD KEY `E_idenseignant` (`E_idenseignant`),
  1020. ADD KEY `E_num_M` (`E_num_M`);
  1021.  
  1022. --
  1023. -- Index pour la table `etablisement`
  1024. --
  1025. ALTER TABLE `etablisement`
  1026. ADD PRIMARY KEY (`U_id`),
  1027. ADD KEY `U_CineD` (`U_CineD`),
  1028. ADD KEY `contactphysique` (`contactphysique`),
  1029. ADD KEY `contactmorale` (`contactmorale`);
  1030.  
  1031. --
  1032. -- Index pour la table `etudiant`
  1033. --
  1034. ALTER TABLE `etudiant`
  1035. ADD PRIMARY KEY (`et_id`),
  1036. ADD KEY `et_bac` (`et_bac`),
  1037. ADD KEY `idetablisement` (`idetablisement`);
  1038.  
  1039. --
  1040. -- Index pour la table `event`
  1041. --
  1042. ALTER TABLE `event`
  1043. ADD PRIMARY KEY (`id`);
  1044.  
  1045. --
  1046. -- Index pour la table `event_group`
  1047. --
  1048. ALTER TABLE `event_group`
  1049. ADD PRIMARY KEY (`event_id`,`group_id`),
  1050. ADD KEY `IDX_2CDBF5E971F7E88B` (`event_id`),
  1051. ADD KEY `IDX_2CDBF5E9FE54D947` (`group_id`);
  1052.  
  1053. --
  1054. -- Index pour la table `fields`
  1055. --
  1056. ALTER TABLE `fields`
  1057. ADD PRIMARY KEY (`id`);
  1058.  
  1059. --
  1060. -- Index pour la table `filiere`
  1061. --
  1062. ALTER TABLE `filiere`
  1063. ADD PRIMARY KEY (`idf`),
  1064. ADD KEY `idetabfil` (`idetabfil`);
  1065.  
  1066. --
  1067. -- Index pour la table `image`
  1068. --
  1069. ALTER TABLE `image`
  1070. ADD PRIMARY KEY (`id`);
  1071.  
  1072. --
  1073. -- Index pour la table `matiere`
  1074. --
  1075. ALTER TABLE `matiere`
  1076. ADD PRIMARY KEY (`m_id`),
  1077. ADD KEY `id_filere` (`id_filere`);
  1078.  
  1079. --
  1080. -- Index pour la table `message`
  1081. --
  1082. ALTER TABLE `message`
  1083. ADD PRIMARY KEY (`id`),
  1084. ADD KEY `IDX_B6BD307FE2904019` (`thread_id`),
  1085. ADD KEY `IDX_B6BD307FA76ED395` (`user_id`);
  1086.  
  1087. --
  1088. -- Index pour la table `message_metadata`
  1089. --
  1090. ALTER TABLE `message_metadata`
  1091. ADD PRIMARY KEY (`id`),
  1092. ADD KEY `IDX_4632F005537A1329` (`message_id`),
  1093. ADD KEY `IDX_4632F0059D1C3019` (`participant_id`);
  1094.  
  1095. --
  1096. -- Index pour la table `mygroup`
  1097. --
  1098. ALTER TABLE `mygroup`
  1099. ADD PRIMARY KEY (`id`),
  1100. ADD UNIQUE KEY `UNIQ_F0C21D8A3DA5256D` (`image_id`);
  1101.  
  1102. --
  1103. -- Index pour la table `profile`
  1104. --
  1105. ALTER TABLE `profile`
  1106. ADD PRIMARY KEY (`id`),
  1107. ADD UNIQUE KEY `UNIQ_8157AA0F3DA5256D` (`image_id`);
  1108.  
  1109. --
  1110. -- Index pour la table `status`
  1111. --
  1112. ALTER TABLE `status`
  1113. ADD PRIMARY KEY (`id`);
  1114.  
  1115. --
  1116. -- Index pour la table `thread`
  1117. --
  1118. ALTER TABLE `thread`
  1119. ADD PRIMARY KEY (`id`),
  1120. ADD KEY `IDX_31204C833174800F` (`createdBy_id`);
  1121.  
  1122. --
  1123. -- Index pour la table `thread_metadata`
  1124. --
  1125. ALTER TABLE `thread_metadata`
  1126. ADD PRIMARY KEY (`id`),
  1127. ADD KEY `IDX_40A577C8E2904019` (`thread_id`),
  1128. ADD KEY `IDX_40A577C89D1C3019` (`participant_id`);
  1129.  
  1130. --
  1131. -- Index pour la table `user`
  1132. --
  1133. ALTER TABLE `user`
  1134. ADD PRIMARY KEY (`id`),
  1135. ADD UNIQUE KEY `UNIQ_8D93D64992FC23A8` (`username_canonical`),
  1136. ADD UNIQUE KEY `UNIQ_8D93D649A0D96FBF` (`email_canonical`),
  1137. ADD UNIQUE KEY `UNIQ_8D93D649CCFA12B8` (`profile_id`);
  1138.  
  1139. --
  1140. -- Index pour la table `user_group`
  1141. --
  1142. ALTER TABLE `user_group`
  1143. ADD PRIMARY KEY (`user_id`,`group_id`),
  1144. ADD KEY `IDX_8F02BF9DA76ED395` (`user_id`),
  1145. ADD KEY `IDX_8F02BF9DFE54D947` (`group_id`);
  1146.  
  1147. --
  1148. -- AUTO_INCREMENT pour les tables exportées
  1149. --
  1150.  
  1151. --
  1152. -- AUTO_INCREMENT pour la table `activity_log`
  1153. --
  1154. ALTER TABLE `activity_log`
  1155. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=215;
  1156. --
  1157. -- AUTO_INCREMENT pour la table `avancement`
  1158. --
  1159. ALTER TABLE `avancement`
  1160. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
  1161. --
  1162. -- AUTO_INCREMENT pour la table `bac`
  1163. --
  1164. ALTER TABLE `bac`
  1165. MODIFY `id_bac` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  1166. --
  1167. -- AUTO_INCREMENT pour la table `config`
  1168. --
  1169. ALTER TABLE `config`
  1170. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
  1171. --
  1172. -- AUTO_INCREMENT pour la table `contact_physique`
  1173. --
  1174. ALTER TABLE `contact_physique`
  1175. MODIFY `CO_Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  1176. --
  1177. -- AUTO_INCREMENT pour la table `cotisation`
  1178. --
  1179. ALTER TABLE `cotisation`
  1180. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
  1181. --
  1182. -- AUTO_INCREMENT pour la table `enseignant`
  1183. --
  1184. ALTER TABLE `enseignant`
  1185. MODIFY `en_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  1186. --
  1187. -- AUTO_INCREMENT pour la table `enseigner`
  1188. --
  1189. ALTER TABLE `enseigner`
  1190. MODIFY `E_id` int(11) NOT NULL AUTO_INCREMENT;
  1191. --
  1192. -- AUTO_INCREMENT pour la table `etablisement`
  1193. --
  1194. ALTER TABLE `etablisement`
  1195. MODIFY `U_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  1196. --
  1197. -- AUTO_INCREMENT pour la table `etudiant`
  1198. --
  1199. ALTER TABLE `etudiant`
  1200. MODIFY `et_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;
  1201. --
  1202. -- AUTO_INCREMENT pour la table `event`
  1203. --
  1204. ALTER TABLE `event`
  1205. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
  1206. --
  1207. -- AUTO_INCREMENT pour la table `fields`
  1208. --
  1209. ALTER TABLE `fields`
  1210. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;
  1211. --
  1212. -- AUTO_INCREMENT pour la table `image`
  1213. --
  1214. ALTER TABLE `image`
  1215. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;
  1216. --
  1217. -- AUTO_INCREMENT pour la table `matiere`
  1218. --
  1219. ALTER TABLE `matiere`
  1220. MODIFY `m_id` int(11) NOT NULL AUTO_INCREMENT;
  1221. --
  1222. -- AUTO_INCREMENT pour la table `message`
  1223. --
  1224. ALTER TABLE `message`
  1225. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1226. --
  1227. -- AUTO_INCREMENT pour la table `message_metadata`
  1228. --
  1229. ALTER TABLE `message_metadata`
  1230. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1231. --
  1232. -- AUTO_INCREMENT pour la table `mygroup`
  1233. --
  1234. ALTER TABLE `mygroup`
  1235. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
  1236. --
  1237. -- AUTO_INCREMENT pour la table `profile`
  1238. --
  1239. ALTER TABLE `profile`
  1240. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
  1241. --
  1242. -- AUTO_INCREMENT pour la table `status`
  1243. --
  1244. ALTER TABLE `status`
  1245. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  1246. --
  1247. -- AUTO_INCREMENT pour la table `thread`
  1248. --
  1249. ALTER TABLE `thread`
  1250. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1251. --
  1252. -- AUTO_INCREMENT pour la table `thread_metadata`
  1253. --
  1254. ALTER TABLE `thread_metadata`
  1255. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1256. --
  1257. -- AUTO_INCREMENT pour la table `user`
  1258. --
  1259. ALTER TABLE `user`
  1260. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
  1261. --
  1262. -- Contraintes pour les tables exportées
  1263. --
  1264.  
  1265. --
  1266. -- Contraintes pour la table `avancement`
  1267. --
  1268. ALTER TABLE `avancement`
  1269. ADD CONSTRAINT `FK_6D2A7A2A6BF700BD` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`),
  1270. ADD CONSTRAINT `FK_6D2A7A2AA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
  1271.  
  1272. --
  1273. -- Contraintes pour la table `cotisation`
  1274. --
  1275. ALTER TABLE `cotisation`
  1276. ADD CONSTRAINT `FK_AE64D2EDA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
  1277.  
  1278. --
  1279. -- Contraintes pour la table `enseignant`
  1280. --
  1281. ALTER TABLE `enseignant`
  1282. ADD CONSTRAINT `enseignant_ibfk_1` FOREIGN KEY (`idU`) REFERENCES `etablisement` (`U_id`) ON DELETE SET NULL ON UPDATE CASCADE;
  1283.  
  1284. --
  1285. -- Contraintes pour la table `enseigner`
  1286. --
  1287. ALTER TABLE `enseigner`
  1288. ADD CONSTRAINT `FK_663E85CD792582C5` FOREIGN KEY (`E_num_M`) REFERENCES `matiere` (`m_id`),
  1289. ADD CONSTRAINT `FK_663E85CDD80F6EB` FOREIGN KEY (`E_idenseignant`) REFERENCES `enseignant` (`en_id`);
  1290.  
  1291. --
  1292. -- Contraintes pour la table `etudiant`
  1293. --
  1294. ALTER TABLE `etudiant`
  1295. ADD CONSTRAINT `FK_717E22E395C913FB` FOREIGN KEY (`et_bac`) REFERENCES `bac` (`id_bac`),
  1296. ADD CONSTRAINT `etudiant_ibfk_1` FOREIGN KEY (`idetablisement`) REFERENCES `etablisement` (`U_id`) ON DELETE SET NULL;
  1297.  
  1298. --
  1299. -- Contraintes pour la table `event_group`
  1300. --
  1301. ALTER TABLE `event_group`
  1302. ADD CONSTRAINT `FK_2CDBF5E971F7E88B` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE,
  1303. ADD CONSTRAINT `FK_2CDBF5E9FE54D947` FOREIGN KEY (`group_id`) REFERENCES `mygroup` (`id`) ON DELETE CASCADE;
  1304.  
  1305. --
  1306. -- Contraintes pour la table `filiere`
  1307. --
  1308. ALTER TABLE `filiere`
  1309. ADD CONSTRAINT `filiere_ibfk_1` FOREIGN KEY (`idetabfil`) REFERENCES `etablisement` (`U_id`);
  1310.  
  1311. --
  1312. -- Contraintes pour la table `message`
  1313. --
  1314. ALTER TABLE `message`
  1315. ADD CONSTRAINT `FK_B6BD307FA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  1316. ADD CONSTRAINT `FK_B6BD307FE2904019` FOREIGN KEY (`thread_id`) REFERENCES `thread` (`id`);
  1317.  
  1318. --
  1319. -- Contraintes pour la table `message_metadata`
  1320. --
  1321. ALTER TABLE `message_metadata`
  1322. ADD CONSTRAINT `FK_4632F005537A1329` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`),
  1323. ADD CONSTRAINT `FK_4632F0059D1C3019` FOREIGN KEY (`participant_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
  1324.  
  1325. --
  1326. -- Contraintes pour la table `mygroup`
  1327. --
  1328. ALTER TABLE `mygroup`
  1329. ADD CONSTRAINT `FK_F0C21D8A3DA5256D` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`);
  1330.  
  1331. --
  1332. -- Contraintes pour la table `profile`
  1333. --
  1334. ALTER TABLE `profile`
  1335. ADD CONSTRAINT `FK_8157AA0F3DA5256D` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`);
  1336.  
  1337. --
  1338. -- Contraintes pour la table `thread`
  1339. --
  1340. ALTER TABLE `thread`
  1341. ADD CONSTRAINT `FK_31204C833174800F` FOREIGN KEY (`createdBy_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
  1342.  
  1343. --
  1344. -- Contraintes pour la table `thread_metadata`
  1345. --
  1346. ALTER TABLE `thread_metadata`
  1347. ADD CONSTRAINT `FK_40A577C89D1C3019` FOREIGN KEY (`participant_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  1348. ADD CONSTRAINT `FK_40A577C8E2904019` FOREIGN KEY (`thread_id`) REFERENCES `thread` (`id`);
  1349.  
  1350. --
  1351. -- Contraintes pour la table `user`
  1352. --
  1353. ALTER TABLE `user`
  1354. ADD CONSTRAINT `FK_8D93D649CCFA12B8` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`);
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!