· 6 years ago · Jun 10, 2019, 06:06 PM
1$$\ $$\ $$$$$$\
2$$$\ $$ | $$ __$$\
3$$$$\ $$ | $$$$$$\ $$\ $$\ $$\ $$ / \__| $$$$$$\ $$$$$$$\
4$$ $$\$$ |$$ __$$\ $$ | $$ | $$ |\$$$$$$\ $$ __$$\ $$ _____|
5$$ \$$$$ |$$$$$$$$ |$$ | $$ | $$ | \____$$\ $$$$$$$$ |$$ /
6$$ |\$$$ |$$ ____|$$ | $$ | $$ |$$\ $$ |$$ ____|$$ |
7$$ | \$$ |\$$$$$$$\ \$$$$$\$$$$ |\$$$$$$ |\$$$$$$$\ \$$$$$$$\
8\__| \__| \_______| \_____\____/ \______/ \_______| \_______|
9
10
11
12 $$\ $$\ $$$$$$\ $$$$$$\ $$\ $$\
13 $$ \$$ \ $$ __$$\ \_$$ _| $$ | \__|
14$$$$$$$$$$\ $$ / $$ | $$$$$$\ $$ | $$$$$$$\ $$$$$$$ | $$$$$$\ $$$$$$$\ $$$$$$\ $$$$$$$\ $$\ $$$$$$\
15\_$$ $$ |$$ | $$ |$$ __$$\ $$ | $$ __$$\ $$ __$$ |$$ __$$\ $$ __$$\ $$ __$$\ $$ _____|$$ | \____$$\
16$$$$$$$$$$\ $$ | $$ |$$ / $$ | $$ | $$ | $$ |$$ / $$ |$$ / $$ |$$ | $$ |$$$$$$$$ |\$$$$$$\ $$ | $$$$$$$ |
17\_$$ $$ _|$$ | $$ |$$ | $$ | $$ | $$ | $$ |$$ | $$ |$$ | $$ |$$ | $$ |$$ ____| \____$$\ $$ |$$ __$$ |
18 $$ |$$ | $$$$$$ |$$$$$$$ |$$$$$$\ $$ | $$ |\$$$$$$$ |\$$$$$$ |$$ | $$ |\$$$$$$$\ $$$$$$$ |$$ |\$$$$$$$ |
19 \__|\__| \______/ $$ ____/ \______|\__| \__| \_______| \______/ \__| \__| \_______|\_______/ \__| \_______|
20 $$ |
21 $$ |
22 \__|
23
24----------------------------------------------------------------------------------------------------------------------------
25
26Target : https://www.simalungunkab.go.id/ ( Government of the District of Simalungun )
27
28Database, Tables, Columns Dumpeds
29
30By : NewSec Group | We Are : DemonSad, Kami, NedLock, Silv3r
31
32----------------------------------------------------------------------------------------------------------------------------
33-- **** Values to replace ****
34-- MY_DATABASE
35-- MY_DB_USER
36-- MY_DB_PASS
37-- USER_EMAIL
38-- USER_LOGIN
39-- USER_PASS
40-- INSTALL_DATE
41
42-- **** Tables ****
43-- pm_user
44-- pm_lang
45-- pm_lang_file
46-- pm_page
47-- pm_page_file
48-- pm_media
49-- pm_media_file
50-- pm_text
51-- pm_widget
52-- pm_article
53-- pm_article_file
54-- pm_comment
55-- pm_tag
56-- pm_slide
57-- pm_slide_file
58-- pm_location
59-- pm_message
60-- pm_currency
61-- pm_country
62
63-- **** Edit with the name of your database ****
64CREATE DATABASE IF NOT EXISTS MY_DATABASE;
65USE MY_DATABASE;
66
67-- **** Uncomment the following line if you are allowed to create users ****
68-- GRANT SELECT, INSERT, UPDATE, DELETE ON MY_DATABASE.* TO 'MY_DB_USER'@'localhost' IDENTIFIED BY 'MY_DB_PASS' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
69
70-- ================= CREATION OF THE TABLE pm_user ===============
71
72CREATE TABLE IF NOT EXISTS pm_user(
73 id int NOT NULL AUTO_INCREMENT,
74 name varchar(100),
75 email varchar(100),
76 login varchar(50),
77 pass varchar(100),
78 type varchar(20),
79 add_date int,
80 edit_date int,
81 checked int DEFAULT 0,
82 PRIMARY KEY(id)
83) ENGINE=INNODB DEFAULT CHARSET=utf8;
84
85-- **** Edit with the informations of the admin user ****
86INSERT INTO pm_user (id, name, email, login, pass, type, add_date, edit_date, checked) VALUES
87(1, 'Administrator', 'USER_EMAIL', 'USER_LOGIN', 'USER_PASS', 'administrator', INSTALL_DATE, INSTALL_DATE, 1);
88
89-- ================= CREATION OF THE TABLE pm_lang ===============
90
91CREATE TABLE IF NOT EXISTS pm_lang(
92 id int NOT NULL AUTO_INCREMENT,
93 title varchar(20),
94 locale varchar(20),
95 main int DEFAULT 0,
96 checked int DEFAULT 0,
97 rank int DEFAULT 0,
98 tag varchar(20),
99 rtl int DEFAULT 0,
100 PRIMARY KEY(id)
101) ENGINE=INNODB DEFAULT CHARSET=utf8;
102
103--
104-- Content OF THE TABLE pm_lang
105--
106
107INSERT INTO pm_lang (id, title, locale, main, checked, rank, tag, rtl) VALUES
108(1, 'Français', 'fr_FR', 0, 1, 2, 'fr', 0),
109(2, 'English', 'en_GB', 1, 1, 1, 'en', 0),
110(3, 'عربي', 'ar_MA', 0, 1, 3, 'ar', 1);
111
112-- ============== CREATION OF THE TABLE pm_lang_file =============
113
114CREATE TABLE IF NOT EXISTS pm_lang_file (
115 id int NOT NULL AUTO_INCREMENT,
116 id_item int NOT NULL,
117 home int DEFAULT 0,
118 checked int DEFAULT 1,
119 rank int DEFAULT 0,
120 file varchar(250),
121 label varchar(250),
122 type varchar(20),
123 PRIMARY KEY(id)
124) ENGINE=INNODB DEFAULT CHARSET=utf8;
125
126ALTER TABLE pm_lang_file ADD CONSTRAINT lang_file_fkey FOREIGN KEY (id_item) REFERENCES pm_lang(id) ON UPDATE NO ACTION ON DELETE CASCADE;
127
128--
129-- Content OF THE TABLE pm_lang_file
130--
131
132INSERT INTO pm_lang_file (id, id_item, home, checked, rank, file, label, type) VALUES
133(1, 1, 0, 1, 2, 'fr.png', '', 'image'),
134(2, 2, 0, 1, 1, 'gb.png', '', 'image'),
135(3, 3, 0, 1, 3, 'ar.png', '', 'image');
136
137-- ================= CREATION OF THE TABLE pm_page ===============
138
139CREATE TABLE IF NOT EXISTS pm_page(
140 id int NOT NULL AUTO_INCREMENT,
141 lang int NOT NULL,
142 name varchar(50),
143 title varchar(250),
144 subtitle varchar(250),
145 title_tag varchar(250),
146 alias varchar(100),
147 descr longtext,
148 robots varchar(20),
149 keywords varchar(250),
150 intro longtext,
151 text longtext,
152 text2 longtext,
153 id_parent int,
154 page_model varchar(50),
155 article_model varchar(50),
156 main int DEFAULT 1,
157 footer int DEFAULT 0,
158 home int DEFAULT 0,
159 checked int DEFAULT 0,
160 rank int DEFAULT 0,
161 add_date int,
162 edit_date int,
163 comment int DEFAULT 0,
164 rating int DEFAULT 0,
165 system int DEFAULT 0,
166 PRIMARY KEY(id, lang)
167) ENGINE=INNODB DEFAULT CHARSET=utf8;
168
169ALTER TABLE pm_page ADD CONSTRAINT page_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
170
171--
172-- Content OF THE TABLE pm_page
173--
174
175INSERT INTO pm_page (id, lang, name, title, subtitle, title_tag, alias, descr, robots, keywords, intro, text, text2, id_parent, page_model, article_model, main, footer, home, checked, rank, add_date, edit_date, comment, rating, system) VALUES
176(1, 1, 'Accueil', 'Lorem ipsum dolor sit amet', 'Consectetur adipiscing elit', 'Accueil', '', '', 'index,follow', '', '', '', '', 0, 'home', '', 1, 0, 1, 1, 1, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
177(1, 2, 'Home', 'Pandao CMS', 'web software to create and manage your own website', 'Pandao CMS web software to create and manage your own website', '', '', 'index,follow', '', '', '<h3>Light weight</h3>\r\n\r\n<p><em>"The web should be fast", Google.</em> Only 10Mb and less than 450 files against 20Mb and a bit more than 1100 files for a famous CMS! <strong>Optimized page loading</strong> to be faster and more efficient.</p>\r\n\r\n<hr />\r\n<h3>Multilingual support</h3>\r\n\r\n<p><strong>Ready to be translated!</strong> Simply insert a new language into the admin panel and draft your articles, your pages and other texts in your website...</p>\r\n\r\n<hr />\r\n<h3>Easy to use</h3>\r\n\r\n<p>Studied to be personalized by novices and used by <strong>people without skills in computing</strong>. All the features are simple and intuitive.</p>\r\n', '', 0, 'home', '', 1, 0, 1, 1, 1, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
178(1, 3, 'ترحيب', 'هو سقطت الساحلية ذات, أن.', 'غير بمعارضة وهولندا، الإقتصادية قد, فقد الفرنسي المعاهدات قد من.', 'ترحيب', '', '', 'index,follow', '', '', '', '', 0, 'home', '', 1, 0, 1, 1, 1, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
179(2, 1, 'Contact', 'Contact', '', 'Contact', 'contact', '', 'index,follow', '', '', '', '', 0, 'contact', '', 1, 1, 0, 1, 4, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
180(2, 2, 'Contact', 'Contact', '', 'Contact', 'contact', '', 'index,follow', '', '', '', '', 0, 'contact', '', 1, 1, 0, 1, 4, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
181(2, 3, 'جهة الاتصال', 'جهة الاتصال', '', 'جهة الاتصال', 'contact', '', 'index,follow', '', '', '', '', 0, 'contact', '', 1, 1, 0, 1, 4, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
182(3, 1, 'Mentions légales', 'Mentions légales', '', 'Mentions légales', 'mentions-legales', '', 'index,follow', '', '', '', '', 0, 'page', '', 0, 1, 0, 1, 5, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
183(3, 2, 'Legal notices', 'Legal notices', '', 'Legal notices', 'legal-notices', '', 'index,follow', '', '', '', '', 0, 'page', '', 0, 1, 0, 1, 5, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
184(3, 3, 'يذكر القانونية', 'يذكر القانونية', '', 'يذكر القانونية', 'legal-notices', '', 'index,follow', '', '', '', '', 0, 'page', '', 0, 1, 0, 1, 5, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
185(4, 1, 'Plan du site', 'Plan du site', '', 'Plan du site', 'plan-site', '', 'index,follow', '', '', '', '', 0, 'sitemap', '', 0, 1, 0, 1, 6, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
186(4, 2, 'Sitemap', 'Sitemap', '', 'Sitemap', 'sitemap', '', 'index,follow', '', '', '', '', 0, 'sitemap', '', 0, 1, 0, 1, 6, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
187(4, 3, 'خريطة الموقع', 'خريطة الموقع', '', 'خريطة الموقع', 'sitemap', '', 'index,follow', '', '', '', '', 0, 'sitemap', '', 0, 1, 0, 1, 6, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
188(5, 1, 'Ma première page', 'Ma première page', '', 'Ma première page', 'my-first-page', '', 'index,follow', '', '', '', '', 0, 'page', 'article', 1, 0, 0, 1, 2, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
189(5, 2, 'My first page', 'My first page', '', 'My first page', 'my-first-page', '', 'index,follow', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque fringilla vel est at rhoncus. Cras porttitor ligula vel magna vehicula accumsan. Mauris eget elit et sem commodo interdum. Aenean dolor sem, tincidunt ac neque tempus, hendrerit blandit lacus. Vivamus placerat nulla in mi tristique, fringilla fermentum nisl vehicula. Nullam quis eros non magna tincidunt interdum ac eu eros. Morbi malesuada pulvinar ultrices. Etiam bibendum efficitur risus, sit amet venenatis urna ullamcorper non. Proin fermentum malesuada tortor, vitae mattis sem scelerisque in. Curabitur rutrum leo at mi efficitur suscipit. Vivamus tristique lorem eros, sit amet malesuada augue sodales sed.</p>\r\n', '<p>Etiam bibendum efficitur risus, sit amet venenatis urna ullamcorper non. Proin fermentum malesuada tortor, vitae mattis sem scelerisque in. Curabitur rutrum leo at mi efficitur.</p>\r\n', 0, 'page', 'article', 1, 0, 0, 1, 2, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
190(5, 3, 'صفحتي الأولى', 'صفحتي الأولى', '', 'صفحتي الأولى', 'my-first-page', '', 'index,follow', '', '', '', '', 0, 'page', 'article', 1, 0, 0, 1, 2, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
191(6, 1, 'Recherche', 'Recherche', '', 'Recherche', 'search', '', 'noindex,nofollow', '', '', '', '', 0, 'search', '', 0, 0, 0, 1, 7, INSTALL_DATE, INSTALL_DATE, 0, 0, 1),
192(6, 2, 'Search', 'Search', '', 'Search', 'search', '', 'noindex,nofollow', '', '', '', '', 0, 'search', '', 0, 0, 0, 1, 7, INSTALL_DATE, INSTALL_DATE, 0, 0, 1),
193(6, 3, 'بحث', 'بحث', '', 'بحث', 'search', '', 'noindex,nofollow', '', '', '', '', 0, 'search', '', 0, 0, 0, 1, 7, INSTALL_DATE, INSTALL_DATE, 0, 0, 1),
194(7, 1, 'Galerie', 'Galerie', '', 'Galerie', 'galerie', '', 'index,follow', '', '', '', '', 0, 'page', 'gallery', 1, 0, 0, 1, 3, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
195(7, 2, 'Gallery', 'Gallery', '', 'Gallery', 'gallery', '', 'index,follow', '', '', '', '', 0, 'page', 'gallery', 1, 0, 0, 1, 3, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
196(7, 3, 'صور معرض', 'صور معرض', '', 'صور معرض', 'gallery', '', 'index,follow', '', '', '', '', 0, 'page', 'gallery', 1, 0, 0, 1, 3, INSTALL_DATE, INSTALL_DATE, 0, 0, 0),
197(8, 1, '404', 'Erreur 404 : Page introuvable !', '', '404 Page introuvable', '404', '', 'noindex,nofollow', '', '', '<p>L''URL demandée n''a pas été trouvée sur ce serveur.<br />\r\nLa page que vous voulez afficher n''existe pas, ou est temporairement indisponible.</p>\r\n\r\n<p>Merci d''essayer les actions suivantes :</p>\r\n\r\n<ul>\r\n <li>Assurez-vous que l''URL dans la barre d''adresse de votre navigateur est correctement orthographiée et formatée.</li>\r\n <li>Si vous avez atteint cette page en cliquant sur un lien ou si vous pensez que cela concerne une erreur du serveur, contactez l''administrateur pour l''alerter.</li>\r\n</ul>\r\n', '', 0, '404', '', 0, 0, 0, 1, 8, INSTALL_DATE, INSTALL_DATE, 0, 0, 1),
198(8, 2, '404', '404 Error: Page not found!', '', '404 Not Found', '404', '', 'noindex,nofollow', '', '', '<p>The wanted URL was not found on this server.<br />\r\nThe page you wish to display does not exist, or is temporarily unavailable.</p>\r\n\r\n<p>Thank you for trying the following actions :</p>\r\n\r\n<ul>\r\n <li>Be sure the URL in the address bar of your browser is correctly spelt and formated.</li>\r\n <li>If you reached this page by clicking a link or if you think that it is about an error of the server, contact the administrator to alert him.</li>\r\n</ul>\r\n', '', 0, '404', '', 0, 0, 0, 1, 8, INSTALL_DATE, INSTALL_DATE, 0, 0, 1),
199(8, 3, '404', '404 Error: Page not found!', '', '404 Not Found', '404', '', 'noindex,nofollow', '', '', '', '', 0, '404', '', 0, 0, 0, 1, 8, INSTALL_DATE, INSTALL_DATE, 0, 0, 1);
200
201-- ============== CREATION OF THE TABLE pm_page_file =============
202
203CREATE TABLE IF NOT EXISTS pm_page_file (
204 id int NOT NULL AUTO_INCREMENT,
205 lang int NOT NULL,
206 id_item int NOT NULL,
207 home int DEFAULT 0,
208 checked int DEFAULT 1,
209 rank int DEFAULT 0,
210 file varchar(250),
211 label varchar(250),
212 type varchar(20),
213 PRIMARY KEY(id,lang)
214) ENGINE=INNODB DEFAULT CHARSET=utf8;
215
216ALTER TABLE pm_page_file ADD CONSTRAINT page_file_fkey FOREIGN KEY (id_item, lang) REFERENCES pm_page(id, lang) ON UPDATE NO ACTION ON DELETE CASCADE;
217ALTER TABLE pm_page_file ADD CONSTRAINT page_file_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
218
219-- ================ CREATION OF THE TABLE pm_media ===============
220
221CREATE TABLE IF NOT EXISTS pm_media(
222 id int NOT NULL AUTO_INCREMENT,
223 PRIMARY KEY(id)
224) ENGINE=INNODB DEFAULT CHARSET=utf8;
225
226-- ============== CREATION OF THE TABLE pm_media_file ============
227
228CREATE TABLE IF NOT EXISTS pm_media_file (
229 id int NOT NULL AUTO_INCREMENT,
230 id_item int NOT NULL,
231 home int DEFAULT 0,
232 checked int DEFAULT 1,
233 rank int DEFAULT 0,
234 file varchar(250),
235 label varchar(250),
236 type varchar(20),
237 PRIMARY KEY(id)
238) ENGINE=INNODB DEFAULT CHARSET=utf8;
239
240ALTER TABLE pm_media_file ADD CONSTRAINT media_file_fkey FOREIGN KEY (id_item) REFERENCES pm_media(id) ON UPDATE NO ACTION ON DELETE CASCADE;
241
242-- ================ CREATION OF THE TABLE pm_text ================
243
244CREATE TABLE IF NOT EXISTS pm_text(
245 id int NOT NULL AUTO_INCREMENT,
246 lang int NOT NULL,
247 name varchar(50),
248 value varchar(250),
249 PRIMARY KEY(id, lang)
250) ENGINE=INNODB DEFAULT CHARSET=utf8;
251
252ALTER TABLE pm_text ADD CONSTRAINT text_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
253
254--
255-- Content OF THE TABLE pm_text
256--
257
258INSERT INTO pm_text (id, lang, name, value) VALUES
259(1, 1, 'CREATION', 'Création'),
260(1, 2, 'CREATION', 'Creation'),
261(1, 3, 'CREATION', 'إنشاء'),
262(2, 1, 'MESSAGE', 'Message'),
263(2, 2, 'MESSAGE', 'Message'),
264(2, 3, 'MESSAGE', 'رسالة'),
265(3, 1, 'EMAIL', 'E-mail'),
266(3, 2, 'EMAIL', 'E-mail'),
267(3, 3, 'EMAIL', 'بَرِيدٌ إلِكْترونيّ'),
268(4, 1, 'PHONE', 'Tél.'),
269(4, 2, 'PHONE', 'Phone'),
270(4, 3, 'PHONE', 'رقم هاتف'),
271(5, 1, 'FAX', 'Fax'),
272(5, 2, 'FAX', 'Fax'),
273(5, 3, 'FAX', 'فاكس'),
274(6, 1, 'COMPANY', 'Société'),
275(6, 2, 'COMPANY', 'Company'),
276(6, 3, 'COMPANY', 'مشروع'),
277(7, 1, 'COPY_CODE', 'Recopiez le code'),
278(7, 2, 'COPY_CODE', 'Copy the code'),
279(7, 3, 'COPY_CODE', 'رمز الأمان'),
280(8, 1, 'SUBJECT', 'Sujet'),
281(8, 2, 'SUBJECT', 'Subject'),
282(8, 3, 'SUBJECT', 'موضوع'),
283(9, 1, 'REQUIRED_FIELD', 'Champ requis'),
284(9, 2, 'REQUIRED_FIELD', 'Required field'),
285(9, 3, 'REQUIRED_FIELD', 'الحقل المطلوب'),
286(10, 1, 'INVALID_CAPTCHA_CODE', 'Le code de sécurité saisi est incorrect'),
287(10, 2, 'INVALID_CAPTCHA_CODE', 'Invalid security code'),
288(10, 3, 'INVALID_CAPTCHA_CODE', 'رمز الحماية أدخلته غير صحيح'),
289(11, 1, 'INVALID_EMAIL', 'Adresse e-mail invalide'),
290(11, 2, 'INVALID_EMAIL', 'Invalid email address'),
291(11, 3, 'INVALID_EMAIL', 'بريد إلكتروني خاطئ'),
292(12, 1, 'FIRSTNAME', 'Prénom'),
293(12, 2, 'FIRSTNAME', 'Firstname'),
294(12, 3, 'FIRSTNAME', 'الاسم الأول'),
295(13, 1, 'LASTNAME', 'Nom'),
296(13, 2, 'LASTNAME', 'Lastname'),
297(13, 3, 'LASTNAME', 'اسم العائلة'),
298(14, 1, 'ADDRESS', 'Adresse'),
299(14, 2, 'ADDRESS', 'Address'),
300(14, 3, 'ADDRESS', 'عنوان الشارع'),
301(15, 1, 'POSTCODE', 'Code postal'),
302(15, 2, 'POSTCODE', 'Post code'),
303(15, 3, 'POSTCODE', 'الرمز البريدي'),
304(16, 1, 'CITY', 'Ville'),
305(16, 2, 'CITY', 'City'),
306(16, 3, 'CITY', 'مدينة'),
307(17, 1, 'MOBILE', 'Portable'),
308(17, 2, 'MOBILE', 'Mobile'),
309(17, 3, 'MOBILE', 'هاتف'),
310(18, 1, 'ADD', 'Ajouter'),
311(18, 2, 'ADD', 'Add'),
312(18, 3, 'ADD', 'إضافة على'),
313(19, 1, 'EDIT', 'Modifier'),
314(19, 2, 'EDIT', 'Edit'),
315(19, 3, 'EDIT', 'تغيير'),
316(20, 1, 'INVALID_INPUT', 'Saisie invalide'),
317(20, 2, 'INVALID_INPUT', 'Invalid input'),
318(20, 3, 'INVALID_INPUT', 'إدخال غير صالح'),
319(21, 1, 'MAIL_DELIVERY_FAILURE', 'Echec lors de l''envoi du message.'),
320(21, 2, 'MAIL_DELIVERY_FAILURE', 'A failure occurred during the delivery of this message.'),
321(21, 3, 'MAIL_DELIVERY_FAILURE', 'حدث فشل أثناء تسليم هذه الرسالة.'),
322(22, 1, 'MAIL_DELIVERY_SUCCESS', 'Merci de votre intérêt, votre message a bien été envoyé.\nNous vous contacterons dans les plus brefs délais.'),
323(22, 2, 'MAIL_DELIVERY_SUCCESS', 'Thank you for your interest, your message has been sent.\nWe will contact you as soon as possible.'),
324(22, 3, 'MAIL_DELIVERY_SUCCESS', 'خزان لاهتمامك ، تم إرسال رسالتك . سوف نتصل بك في أقرب وقت ممكن .'),
325(23, 1, 'SEND', 'Envoyer'),
326(23, 2, 'SEND', 'Send'),
327(23, 3, 'SEND', 'ارسل انت'),
328(24, 1, 'FORM_ERRORS', 'Le formulaire comporte des erreurs.'),
329(24, 2, 'FORM_ERRORS', 'The following form contains some errors.'),
330(24, 3, 'FORM_ERRORS', 'النموذج التالي يحتوي على بعض الأخطاء.'),
331(25, 1, 'FROM_DATE', 'Du'),
332(25, 2, 'FROM_DATE', 'From'),
333(25, 3, 'FROM_DATE', 'من'),
334(26, 1, 'TO_DATE', 'au'),
335(26, 2, 'TO_DATE', 'till'),
336(26, 3, 'TO_DATE', 'حتى'),
337(27, 1, 'FROM', 'De'),
338(27, 2, 'FROM', 'From'),
339(27, 3, 'FROM', 'من'),
340(28, 1, 'TO', 'à'),
341(28, 2, 'TO', 'to'),
342(28, 3, 'TO', 'إلى'),
343(29, 1, 'BOOK', 'Réserver'),
344(29, 2, 'BOOK', 'Book'),
345(29, 3, 'BOOK', 'للحجز'),
346(30, 1, 'READMORE', 'Lire la suite'),
347(30, 2, 'READMORE', 'Read more'),
348(30, 3, 'READMORE', 'اقرأ المزيد'),
349(31, 1, 'BACK', 'Retour'),
350(31, 2, 'BACK', 'Back'),
351(31, 3, 'BACK', 'عودة'),
352(32, 1, 'DISCOVER', 'Découvrir'),
353(32, 2, 'DISCOVER', 'Discover'),
354(32, 3, 'DISCOVER', 'اكتشف'),
355(33, 1, 'ALL', 'Tous'),
356(33, 2, 'ALL', 'All'),
357(33, 3, 'ALL', 'كل'),
358(34, 1, 'ALL_RIGHTS_RESERVED', 'Tous droits réservés'),
359(34, 2, 'ALL_RIGHTS_RESERVED', 'All rights reserved'),
360(34, 3, 'ALL_RIGHTS_RESERVED', 'جميع الحقوق محفوظه'),
361(35, 1, 'FORGOTTEN_PASSWORD', 'Mot de passe oublié ?'),
362(35, 2, 'FORGOTTEN_PASSWORD', 'Forgotten password?'),
363(35, 3, 'FORGOTTEN_PASSWORD', 'هل نسيت كلمة المرور؟'),
364(36, 1, 'LOG_IN', 'Connexion'),
365(36, 2, 'LOG_IN', 'Log in'),
366(36, 3, 'LOG_IN', 'تسجيل الدخول'),
367(37, 1, 'SIGN_UP', 'Inscription'),
368(37, 2, 'SIGN_UP', 'Sign up'),
369(37, 3, 'SIGN_UP', 'تسجيل'),
370(38, 1, 'LOG_OUT', 'Déconnexion'),
371(38, 2, 'LOG_OUT', 'Log out'),
372(38, 3, 'LOG_OUT', 'تسجيل الخروج'),
373(39, 1, 'SEARCH', 'Rechercher'),
374(39, 2, 'SEARCH', 'Search'),
375(39, 3, 'SEARCH', 'ابحث عن'),
376(40, 1, 'RESET_PASS_SUCCESS', 'Votre nouveau mot de passe vous a été envoyé sur votre adresse e-mail.'),
377(40, 2, 'RESET_PASS_SUCCESS', 'Your new password was sent to you on your e-mail.'),
378(40, 3, 'RESET_PASS_SUCCESS', 'تم إرسال كلمة المرور الجديدة إلى عنوان البريد الإلكتروني الخاص بك'),
379(41, 1, 'PASS_TOO_SHORT', 'Le mot de passe doit contenir 6 caractères au minimum'),
380(41, 2, 'PASS_TOO_SHORT', 'The password must contain 6 characters at least'),
381(41, 3, 'PASS_TOO_SHORT', 'يجب أن يحتوي على كلمة المرور ستة أحرف على الأقل'),
382(42, 1, 'PASS_DONT_MATCH', 'Les mots de passe doivent correspondre'),
383(42, 2, 'PASS_DONT_MATCH', 'The passwords don''t match'),
384(42, 3, 'PASS_DONT_MATCH', 'يجب أن تتطابق كلمات المرور'),
385(43, 1, 'ACCOUNT_EXISTS', 'Un compte existe déjà avec cette adresse e-mail'),
386(43, 2, 'ACCOUNT_EXISTS', 'An account already exists with this e-mail'),
387(43, 3, 'ACCOUNT_EXISTS', 'حساب موجود بالفعل مع هذا عنوان البريد الإلكتروني'),
388(44, 1, 'ACCOUNT_CREATED', 'Votre compte a bien été créé.'),
389(44, 2, 'ACCOUNT_CREATED', 'Your account was well created.'),
390(44, 3, 'ACCOUNT_CREATED', 'لقد تم إنشاء حسابك'),
391(45, 1, 'INCORRECT_LOGIN', 'Les informations de connexion sont incorrectes.'),
392(45, 2, 'INCORRECT_LOGIN', 'Incorrect login information.'),
393(45, 3, 'INCORRECT_LOGIN', 'معلومات تسجيل الدخول غير صحيحة.'),
394(46, 1, 'I_SIGN_UP', 'Je m''inscris'),
395(46, 2, 'I_SIGN_UP', 'I sign up'),
396(46, 3, 'I_SIGN_UP', 'يمكنني الاشتراك'),
397(47, 1, 'ALREADY_HAVE_ACCOUNT', 'J''ai déjà un compte'),
398(47, 2, 'ALREADY_HAVE_ACCOUNT', 'I already have an account'),
399(47, 3, 'ALREADY_HAVE_ACCOUNT', 'لدي بالفعل حساب'),
400(48, 1, 'MY_ACCOUNT', 'Mon compte'),
401(48, 2, 'MY_ACCOUNT', 'My account'),
402(48, 3, 'MY_ACCOUNT', 'حسابي'),
403(49, 1, 'COMMENTS', 'Commentaires'),
404(49, 2, 'COMMENTS', 'Comments'),
405(49, 3, 'COMMENTS', 'تعليقات'),
406(50, 1, 'LET_US_KNOW', 'Faîtes-nous savoir ce que vous pensez'),
407(50, 2, 'LET_US_KNOW', 'Let us know what you think'),
408(50, 3, 'LET_US_KNOW', 'ماذا عن رايك؟'),
409(51, 1, 'COMMENT_SUCCESS', 'Merci de votre intérêt, votre commentaire va être soumis à validation.'),
410(51, 2, 'COMMENT_SUCCESS', 'Thank you for your interest, your comment will be checked.'),
411(51, 3, 'COMMENT_SUCCESS', 'شكرا ل اهتمامك، و سيتم التحقق من صحة للتعليق.'),
412(52, 1, 'NO_SEARCH_RESULT', 'Aucun résultat. Vérifiez l''orthographe des termes de recherche (> 3 caractères) ou essayez d''autres mots.'),
413(52, 2, 'NO_SEARCH_RESULT', 'No result. Check the spelling terms of search (> 3 characters) or try other words.'),
414(52, 3, 'NO_SEARCH_RESULT', 'لا نتيجة. التدقيق الإملائي للكلمات (أكثر من ثلاثة أحرف ) أو محاولة بعبارة أخرى .'),
415(53, 1, 'SEARCH_EXCEEDED', 'Nombre de recherches dépassé.'),
416(53, 2, 'SEARCH_EXCEEDED', 'Number of researches exceeded.'),
417(53, 3, 'SEARCH_EXCEEDED', 'عدد من الأبحاث السابقة .'),
418(54, 1, 'SECONDS', 'secondes'),
419(54, 2, 'SECONDS', 'seconds'),
420(54, 3, 'SECONDS', 'ثواني'),
421(55, 1, 'FOR_A_TOTAL_OF', 'sur un total de'),
422(55, 2, 'FOR_A_TOTAL_OF', 'for a total of'),
423(55, 3, 'FOR_A_TOTAL_OF', 'من الكل'),
424(56, 1, 'COMMENT', 'Commentaire'),
425(56, 2, 'COMMENT', 'Comment'),
426(56, 3, 'COMMENT', 'تعقيب'),
427(57, 1, 'VIEW', 'Visionner'),
428(57, 2, 'VIEW', 'View'),
429(57, 3, 'VIEW', 'ل عرض'),
430(58, 1, 'RECENT_ARTICLES', 'Articles récents'),
431(58, 2, 'RECENT_ARTICLES', 'Recent articles'),
432(58, 3, 'RECENT_ARTICLES', 'المقالات الأخيرة'),
433(59, 1, 'RSS_FEED', 'Flux RSS'),
434(59, 2, 'RSS_FEED', 'RSS feed'),
435(59, 3, 'RSS_FEED', 'تغذية RSS'),
436(60, 1, 'RATINGS', 'Note(s)'),
437(60, 2, 'RATINGS', 'Rating(s)'),
438(60, 3, 'RATINGS', 'Rating(s)');
439
440-- =============== CREATION OF THE TABLE pm_widget ===============
441
442CREATE TABLE IF NOT EXISTS pm_widget(
443 id int NOT NULL AUTO_INCREMENT,
444 lang int NOT NULL,
445 title varchar(250),
446 showtitle int,
447 pos varchar(20),
448 allpages int,
449 pages varchar(250),
450 type varchar(20),
451 class varchar(250),
452 content longtext,
453 checked int DEFAULT 0,
454 rank int DEFAULT 0,
455 PRIMARY KEY(id, lang)
456) ENGINE=INNODB DEFAULT CHARSET=utf8;
457
458ALTER TABLE pm_widget ADD CONSTRAINT widget_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
459
460--
461-- Content OF THE TABLE pm_widget
462--
463
464INSERT INTO pm_widget (id, lang, title, showtitle, pos, allpages, pages, type, class, content, checked, rank) VALUES
465(1, 1, 'Qui sommes-nous ?', 1, 'footer', 1, '', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum eget auctor ipsum. Mauris pharetra neque a mauris commodo, at aliquam leo malesuada. Maecenas eget elit eu ligula rhoncus dapibus at non erat. In sed velit eget eros gravida consectetur varius imperdiet lectus.</p>\r\n', 1, 1),
466(1, 2, 'About us', 1, 'footer', 1, '', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum eget auctor ipsum. Mauris pharetra neque a mauris commodo, at aliquam leo malesuada. Maecenas eget elit eu ligula rhoncus dapibus at non erat. In sed velit eget eros gravida consectetur varius imperdiet lectus.</p>\r\n', 1, 1),
467(1, 3, 'عنا', 1, 'footer', 1, '', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum eget auctor ipsum. Mauris pharetra neque a mauris commodo, at aliquam leo malesuada. Maecenas eget elit eu ligula rhoncus dapibus at non erat. In sed velit eget eros gravida consectetur varius imperdiet lectus.</p>\r\n', 1, 1),
468(3, 1, 'Derniers articles', 1, 'footer', 1, '', 'latest_articles', '', '', 1, 2),
469(3, 2, 'Latest articles', 1, 'footer', 1, '', 'latest_articles', '', '', 1, 2),
470(3, 3, 'المقالات الأخيرة', 1, 'footer', 1, '', 'latest_articles', '', '', 1, 2),
471(4, 1, 'Contactez-nous', 0, 'footer', 1, '', 'contact_informations', '', '', 1, 3),
472(4, 2, 'Contact us', 0, 'footer', 1, '', 'contact_informations', '', '', 1, 3),
473(4, 3, 'اتصل بنا', 0, 'footer', 1, '', 'contact_informations', '', '', 1, 3);
474
475-- ================ CREATION OF THE TABLE pm_article =============
476
477CREATE TABLE IF NOT EXISTS pm_article(
478 id int NOT NULL AUTO_INCREMENT,
479 lang int NOT NULL,
480 title varchar(250),
481 subtitle varchar(250),
482 alias varchar(100),
483 text longtext,
484 url varchar(250),
485 tags varchar(250),
486 id_page int,
487 id_user int,
488 home int DEFAULT 0,
489 checked int DEFAULT 0,
490 rank int DEFAULT 0,
491 add_date int,
492 edit_date int,
493 publish_date int,
494 unpublish_date int,
495 comment int DEFAULT 0,
496 rating int DEFAULT 0,
497 PRIMARY KEY(id, lang)
498) ENGINE=INNODB DEFAULT CHARSET=utf8;
499
500ALTER TABLE pm_article ADD CONSTRAINT article_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
501ALTER TABLE pm_article ADD CONSTRAINT article_page_fkey FOREIGN KEY (id_page, lang) REFERENCES pm_page(id, lang) ON DELETE CASCADE ON UPDATE NO ACTION;
502
503--
504-- Content OF THE TABLE pm_article
505--
506
507INSERT INTO pm_article (id, lang, title, subtitle, alias, text, url, tags, id_page, id_user, home, checked, rank, add_date, edit_date, publish_date, unpublish_date, comment, rating) VALUES
508(1, 1, 'Mon premier article', '', 'mon-premier-article', '', '', '1,2', 5, 1, 1, 1, 1, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
509(1, 2, 'My first article', '', 'my-first-article', '<p>Lorem ipsum dolor sit amet consectetur adipiscing elit. Nullam molestie, nunc eu consequat varius, nisi metus iaculis nulla, nec ornare odio leo quis eros. Donec gravida eget velit eget pulvinar. Phasellus eget est quis est faucibus condimentum. Morbi tellus turpis, posuere vel tincidunt non, varius ac ante. Suspendisse in sem neque. Donec et faucibus justo. Nulla vitae nisl lacus. Fusce tincidunt quam nec vestibulum vestibulum. Vivamus vulputate, nunc non ullamcorper mattis, nunc orci imperdiet nulla, at laoreet ipsum nisl non leo. Aenean dapibus aliquet sem, ut lacinia magna mattis in.</p>\r\n\r\n<h3>Mauris et euismod enim, eget elementum orci</h3>\r\n\r\n<p>Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur tempor arcu eu sapien ullamcorper sodales. Aenean eu massa in ante commodo scelerisque vitae sed sapien. Aenean eu dictum arcu. Mauris ultricies dolor eu molestie egestas.<br />\r\nProin feugiat, nunc at pellentesque fringilla, ex purus efficitur dolor, ac pretium odio lacus id leo. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Suspendisse eu ipsum viverra dolor tempus vehicula eu eu risus. Praesent rutrum dapibus odio, nec accumsan justo fermentum in. Ut quis neque a ante facilisis bibendum.</p>\r\n', '', '1,2', 5, 1, 1, 1, 1, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
510(1, 3, 'My first article', '', 'my-first-article', '<p>Lorem ipsum dolor sit amet consectetur adipiscing elit. Nullam molestie, nunc eu consequat varius, nisi metus iaculis nulla, nec ornare odio leo quis eros. Donec gravida eget velit eget pulvinar. Phasellus eget est quis est faucibus condimentum. Morbi tellus turpis, posuere vel tincidunt non, varius ac ante. Suspendisse in sem neque. Donec et faucibus justo. Nulla vitae nisl lacus. Fusce tincidunt quam nec vestibulum vestibulum. Vivamus vulputate, nunc non ullamcorper mattis, nunc orci imperdiet nulla, at laoreet ipsum nisl non leo. Aenean dapibus aliquet sem, ut lacinia magna mattis in.</p>\r\n\r\n<h3>Mauris et euismod enim, eget elementum orci</h3>\r\n\r\n<p>Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur tempor arcu eu sapien ullamcorper sodales. Aenean eu massa in ante commodo scelerisque vitae sed sapien. Aenean eu dictum arcu. Mauris ultricies dolor eu molestie egestas.<br />\r\nProin feugiat, nunc at pellentesque fringilla, ex purus efficitur dolor, ac pretium odio lacus id leo. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Suspendisse eu ipsum viverra dolor tempus vehicula eu eu risus. Praesent rutrum dapibus odio, nec accumsan justo fermentum in. Ut quis neque a ante facilisis bibendum.</p>\r\n', '', '1,2', 5, 1, 1, 1, 1, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
511(2, 1, 'Panel de gestion intuitif', '', 'panel-de-gestion-intuitif', '', '', '1', 5, 1, 1, 1, 2, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
512(2, 2, 'Intuitive admin panel', '', 'intuitive-admin-panel', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam molestie, nunc eu consequat varius, nisi metus iaculis nulla, nec ornare odio leo quis eros. Donec gravida eget velit eget pulvinar. Phasellus eget est quis est faucibus condimentum. Morbi tellus turpis, posuere vel tincidunt non, varius ac ante. Suspendisse in sem neque. Donec et faucibus justo. Nulla vitae nisl lacus. Fusce tincidunt quam nec vestibulum vestibulum. Vivamus vulputate, nunc non ullamcorper mattis, nunc orci imperdiet nulla, at laoreet ipsum nisl non leo. Aenean dapibus aliquet sem, ut lacinia magna mattis in.</p>\r\n\r\n<p>Mauris et euismod enim, eget elementum orci. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur tempor arcu eu sapien ullamcorper sodales. Aenean eu massa in ante commodo scelerisque vitae sed sapien. Aenean eu dictum arcu. Mauris ultricies dolor eu molestie egestas. Proin feugiat, nunc at pellentesque fringilla, ex purus efficitur dolor, ac pretium odio lacus id leo. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Suspendisse eu ipsum viverra dolor tempus vehicula eu eu risus. Praesent rutrum dapibus odio, nec accumsan justo fermentum in. Ut quis neque a ante facilisis bibendum.</p>\r\n', '', '1', 5, 1, 1, 1, 2, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
513(2, 3, 'Intuitive admin panel', '', 'intuitive-admin-panel', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam molestie, nunc eu consequat varius, nisi metus iaculis nulla, nec ornare odio leo quis eros. Donec gravida eget velit eget pulvinar. Phasellus eget est quis est faucibus condimentum. Morbi tellus turpis, posuere vel tincidunt non, varius ac ante. Suspendisse in sem neque. Donec et faucibus justo. Nulla vitae nisl lacus. Fusce tincidunt quam nec vestibulum vestibulum. Vivamus vulputate, nunc non ullamcorper mattis, nunc orci imperdiet nulla, at laoreet ipsum nisl non leo. Aenean dapibus aliquet sem, ut lacinia magna mattis in.</p>\r\n\r\n<p>Mauris et euismod enim, eget elementum orci. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur tempor arcu eu sapien ullamcorper sodales. Aenean eu massa in ante commodo scelerisque vitae sed sapien. Aenean eu dictum arcu. Mauris ultricies dolor eu molestie egestas. Proin feugiat, nunc at pellentesque fringilla, ex purus efficitur dolor, ac pretium odio lacus id leo. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Suspendisse eu ipsum viverra dolor tempus vehicula eu eu risus. Praesent rutrum dapibus odio, nec accumsan justo fermentum in. Ut quis neque a ante facilisis bibendum.</p>\r\n', '', '1', 5, 1, 1, 1, 2, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
514(3, 1, 'Fully responsive', '', 'fully-responsive', '', '', '2', 5, 1, 1, 1, 3, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
515(3, 2, 'Fully responsive', '', 'fully-responsive', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam molestie, nunc eu consequat varius, nisi metus iaculis nulla, nec ornare odio leo quis eros. Donec gravida eget velit eget pulvinar. Phasellus eget est quis est faucibus condimentum. Morbi tellus turpis, posuere vel tincidunt non, varius ac ante. Suspendisse in sem neque. Donec et faucibus justo. Nulla vitae nisl lacus. Fusce tincidunt quam nec vestibulum vestibulum. Vivamus vulputate, nunc non ullamcorper mattis, nunc orci imperdiet nulla, at laoreet ipsum nisl non leo. Aenean dapibus aliquet sem, ut lacinia magna mattis in.</p>\r\n\r\n<p>Mauris et euismod enim, eget elementum orci. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur tempor arcu eu sapien ullamcorper sodales. Aenean eu massa in ante commodo scelerisque vitae sed sapien. Aenean eu dictum arcu. Mauris ultricies dolor eu molestie egestas. Proin feugiat, nunc at pellentesque fringilla, ex purus efficitur dolor, ac pretium odio lacus id leo. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Suspendisse eu ipsum viverra dolor tempus vehicula eu eu risus. Praesent rutrum dapibus odio, nec accumsan justo fermentum in. Ut quis neque a ante facilisis bibendum.</p>\r\n', '', '2', 5, 1, 1, 1, 3, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
516(3, 3, 'Fully responsive', '', 'fully-responsive', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam molestie, nunc eu consequat varius, nisi metus iaculis nulla, nec ornare odio leo quis eros. Donec gravida eget velit eget pulvinar. Phasellus eget est quis est faucibus condimentum. Morbi tellus turpis, posuere vel tincidunt non, varius ac ante. Suspendisse in sem neque. Donec et faucibus justo. Nulla vitae nisl lacus. Fusce tincidunt quam nec vestibulum vestibulum. Vivamus vulputate, nunc non ullamcorper mattis, nunc orci imperdiet nulla, at laoreet ipsum nisl non leo. Aenean dapibus aliquet sem, ut lacinia magna mattis in.</p>\r\n\r\n<p>Mauris et euismod enim, eget elementum orci. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur tempor arcu eu sapien ullamcorper sodales. Aenean eu massa in ante commodo scelerisque vitae sed sapien. Aenean eu dictum arcu. Mauris ultricies dolor eu molestie egestas. Proin feugiat, nunc at pellentesque fringilla, ex purus efficitur dolor, ac pretium odio lacus id leo. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Suspendisse eu ipsum viverra dolor tempus vehicula eu eu risus. Praesent rutrum dapibus odio, nec accumsan justo fermentum in. Ut quis neque a ante facilisis bibendum.</p>\r\n', '', '2', 5, 1, 1, 1, 3, INSTALL_DATE, INSTALL_DATE, null, null, 1, 0),
517(4, 1, 'Première gallery', '', 'premiere-gallery', '', '', '' , 7, 1, 0, 1, 4, INSTALL_DATE, INSTALL_DATE, null, null, 0, 0),
518(4, 2, 'First gallery', '', 'first-gallery', '', '', '' , 7, 1, 0, 1, 4, INSTALL_DATE, INSTALL_DATE, null, null, 0, 0),
519(4, 3, 'First gallery', '', 'first-gallery', '', '', '' , 7, 1, 0, 1, 4, INSTALL_DATE, INSTALL_DATE, null, null, 0, 0);
520
521-- ============= CREATION OF THE TABLE pm_article_file ===========
522
523CREATE TABLE IF NOT EXISTS pm_article_file (
524 id int NOT NULL AUTO_INCREMENT,
525 lang int NOT NULL,
526 id_item int NOT NULL,
527 home int DEFAULT 0,
528 checked int DEFAULT 1,
529 rank int DEFAULT 0,
530 file varchar(250),
531 label varchar(250),
532 type varchar(20),
533 PRIMARY KEY(id, lang)
534) ENGINE=INNODB DEFAULT CHARSET=utf8;
535
536ALTER TABLE pm_article_file ADD CONSTRAINT article_file_fkey FOREIGN KEY (id_item, lang) REFERENCES pm_article(id, lang) ON UPDATE NO ACTION ON DELETE CASCADE;
537ALTER TABLE pm_article_file ADD CONSTRAINT article_file_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
538
539--
540-- Content OF THE TABLE pm_article_file
541--
542
543INSERT INTO pm_article_file (id, lang, id_item, home, checked, rank, file, label, type) VALUES
544(1, 1, 1, 0, 1, 1, 'sample.jpg', '', 'image'),
545(1, 2, 1, 0, 1, 1, 'sample.jpg', '', 'image'),
546(1, 3, 1, 0, 1, 1, 'sample.jpg', '', 'image'),
547(2, 1, 2, 0, 1, 2, 'sample2.jpg', '', 'image'),
548(2, 2, 2, 0, 1, 2, 'sample2.jpg', '', 'image'),
549(2, 3, 2, 0, 1, 2, 'sample2.jpg', '', 'image'),
550(3, 1, 3, 0, 1, 3, 'sample3.jpg', '', 'image'),
551(3, 2, 3, 0, 1, 3, 'sample3.jpg', '', 'image'),
552(3, 3, 3, 0, 1, 3, 'sample3.jpg', '', 'image'),
553(4, 1, 4, 0, 1, 4, 'sample4.jpg', '', 'image'),
554(4, 2, 4, 0, 1, 4, 'sample4.jpg', '', 'image'),
555(4, 3, 4, 0, 1, 4, 'sample4.jpg', '', 'image');
556
557-- ================ CREATION OF THE TABLE pm_comment =============
558
559CREATE TABLE IF NOT EXISTS pm_comment (
560 id int NOT NULL AUTO_INCREMENT,
561 item_type varchar(30),
562 id_item int,
563 rating int,
564 checked int DEFAULT 0,
565 add_date int,
566 edit_date int,
567 name varchar(100),
568 email varchar(100),
569 msg longtext,
570 ip varchar(50),
571 PRIMARY KEY(id)
572) ENGINE=INNODB DEFAULT CHARSET=utf8;
573
574-- ================= CREATION OF THE TABLE pm_tag ================
575
576CREATE TABLE IF NOT EXISTS pm_tag(
577 id int NOT NULL AUTO_INCREMENT,
578 lang int NOT NULL,
579 value varchar(250),
580 pages varchar(250),
581 checked int DEFAULT 0,
582 rank int DEFAULT 0,
583 PRIMARY KEY(id, lang)
584) ENGINE=INNODB DEFAULT CHARSET=utf8;
585
586ALTER TABLE pm_tag ADD CONSTRAINT tag_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
587
588--
589-- Content OF THE TABLE pm_tag
590--
591
592INSERT INTO pm_tag (id, lang, value, pages, checked, rank) VALUES
593(1, 1, 'Autre', '1,2,3,5,4,6', 1, 1),
594(1, 2, 'Other', '1,2,3,5,4,6', 1, 1),
595(2, 1, 'Projets web', '1,2,3,5,4,6', 1, 2),
596(2, 2, 'Web projects', '1,2,3,5,4,6', 1, 2);
597
598-- ================= CREATION OF THE TABLE pm_slide ==============
599
600CREATE TABLE IF NOT EXISTS pm_slide(
601 id int NOT NULL AUTO_INCREMENT,
602 lang int NOT NULL,
603 legend text,
604 url varchar(250),
605 id_page int,
606 checked int DEFAULT 0,
607 rank int DEFAULT 0,
608 PRIMARY KEY(id, lang)
609) ENGINE=INNODB DEFAULT CHARSET=utf8;
610
611ALTER TABLE pm_slide ADD CONSTRAINT slide_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
612ALTER TABLE pm_slide ADD CONSTRAINT slide_page_fkey FOREIGN KEY (id_page, lang) REFERENCES pm_page(id, lang) ON DELETE CASCADE ON UPDATE NO ACTION;
613
614--
615-- Content OF THE TABLE pm_slide
616--
617
618INSERT INTO pm_slide (id, lang, legend, id_page, checked, rank) VALUES
619(1, 1, '', 1, 1, 1),
620(1, 2, '', 1, 1, 1),
621(1, 3, '', 1, 1, 1),
622(2, 1, '', 1, 1, 2),
623(2, 2, '', 1, 1, 2),
624(2, 3, '', 1, 1, 2);
625
626-- ============== CREATION OF THE TABLE pm_slide_file ============
627
628CREATE TABLE IF NOT EXISTS pm_slide_file (
629 id int NOT NULL AUTO_INCREMENT,
630 lang int NOT NULL,
631 id_item int NOT NULL,
632 home int DEFAULT 0,
633 checked int DEFAULT 1,
634 rank int DEFAULT 0,
635 file varchar(250),
636 label varchar(250),
637 type varchar(20),
638 PRIMARY KEY(id, lang)
639) ENGINE=INNODB DEFAULT CHARSET=utf8;
640
641ALTER TABLE pm_slide_file ADD CONSTRAINT slide_file_fkey FOREIGN KEY (id_item, lang) REFERENCES pm_slide(id, lang) ON UPDATE NO ACTION ON DELETE CASCADE;
642ALTER TABLE pm_slide_file ADD CONSTRAINT slide_file_lang_fkey FOREIGN KEY (lang) REFERENCES pm_lang(id) ON DELETE CASCADE ON UPDATE NO ACTION;
643
644--
645-- Content OF THE TABLE pm_slide_file
646--
647
648INSERT INTO pm_slide_file (id, lang, id_item, home, checked, rank, file, label, type) VALUES
649(1, 1, 1, 0, 1, 2, 'slide1.jpg', '', 'image'),
650(1, 2, 1, 0, 1, 2, 'slide1.jpg', '', 'image'),
651(1, 3, 1, 0, 1, 2, 'slide1.jpg', '', 'image'),
652(2, 1, 2, 0, 1, 3, 'slide2.jpg', '', 'image'),
653(2, 2, 2, 0, 1, 3, 'slide2.jpg', '', 'image'),
654(2, 3, 2, 0, 1, 3, 'slide2.jpg', '', 'image');
655
656-- =============== CREATION OF THE TABLE pm_location =============
657
658CREATE TABLE IF NOT EXISTS pm_location(
659 id int NOT NULL AUTO_INCREMENT,
660 name varchar(100),
661 address varchar(250),
662 lat double,
663 lng double,
664 checked int DEFAULT 0,
665 PRIMARY KEY(id)
666) ENGINE=INNODB DEFAULT CHARSET=utf8;
667
668--
669-- Content OF THE TABLE pm_location
670--
671
672INSERT INTO pm_location (id, name, address, lat, lng, checked) VALUES
673(1, 'Big Ben', 'London SW1A 0AA', '51.500729', '-0.124625', 1);
674
675-- ================ CREATION OF THE TABLE pm_message =============
676
677CREATE TABLE IF NOT EXISTS pm_message (
678 id int NOT NULL AUTO_INCREMENT,
679 add_date int,
680 edit_date int,
681 name varchar(100),
682 email varchar(100),
683 address longtext,
684 phone varchar(100),
685 subject varchar(250),
686 msg longtext,
687 PRIMARY KEY(id)
688) ENGINE=INNODB DEFAULT CHARSET=utf8;
689
690-- =============== CREATION OF THE TABLE pm_currency =============
691
692CREATE TABLE IF NOT EXISTS pm_currency(
693 id int NOT NULL AUTO_INCREMENT,
694 code varchar(5),
695 sign varchar(5),
696 main int DEFAULT 0,
697 rank int DEFAULT 0,
698 PRIMARY KEY(id)
699) ENGINE=INNODB DEFAULT CHARSET=utf8;
700
701--
702-- Content of the table pm_currency
703--
704
705INSERT INTO pm_currency (id, code, sign, main, rank) VALUES
706(1, 'USD', '$', 1, 1),
707(2, 'EUR', '€', 0, 2),
708(3, 'GBP', '£', 0, 3),
709(4, 'INR', '₹', 0, 4),
710(5, 'AUD', 'A$', 0, 5),
711(6, 'CAD', 'C$', 0, 6),
712(7, 'CNY', '¥', 0, 7),
713(8, 'TRY', '₺', 0, 8);
714
715-- =============== CREATION OF THE TABLE pm_country ==============
716
717CREATE TABLE IF NOT EXISTS pm_country(
718 id int NOT NULL AUTO_INCREMENT,
719 name varchar(100),
720 code varchar(3),
721 PRIMARY KEY(id)
722) ENGINE=INNODB DEFAULT CHARSET=utf8;
723
724--
725-- Content of the table pm_country
726--
727
728INSERT INTO pm_country VALUES
729('', 'Afghanistan', 'AF'),
730('', 'Åland', 'AX'),
731('', 'Albania', 'AL'),
732('', 'Algeria', 'DZ'),
733('', 'American Samoa', 'AS'),
734('', 'Andorra', 'AD'),
735('', 'Angola', 'AO'),
736('', 'Anguilla', 'AI'),
737('', 'Antarctica', 'AQ'),
738('', 'Antigua and Barbuda', 'AG'),
739('', 'Argentina', 'AR'),
740('', 'Armenia', 'AM'),
741('', 'Aruba', 'AW'),
742('', 'Australia', 'AU'),
743('', 'Austria', 'AT'),
744('', 'Azerbaijan', 'AZ'),
745('', 'Bahamas', 'BS'),
746('', 'Bahrain', 'BH'),
747('', 'Bangladesh', 'BD'),
748('', 'Barbados', 'BB'),
749('', 'Belarus', 'BY'),
750('', 'Belgium', 'BE'),
751('', 'Belize', 'BZ'),
752('', 'Benin', 'BJ'),
753('', 'Bermuda', 'BM'),
754('', 'Bhutan', 'BT'),
755('', 'Bolivia', 'BO'),
756('', 'Bonaire', 'BQ'),
757('', 'Bosnia and Herzegovina', 'BA'),
758('', 'Botswana', 'BW'),
759('', 'Bouvet Island', 'BV'),
760('', 'Brazil', 'BR'),
761('', 'British Indian Ocean Territory', 'IO'),
762('', 'British Virgin Islands', 'VG'),
763('', 'Brunei', 'BN'),
764('', 'Bulgaria', 'BG'),
765('', 'Burkina Faso', 'BF'),
766('', 'Burundi', 'BI'),
767('', 'Cambodia', 'KH'),
768('', 'Cameroon', 'CM'),
769('', 'Canada', 'CA'),
770('', 'Cape Verde', 'CV'),
771('', 'Cayman Islands', 'KY'),
772('', 'Central African Republic', 'CF'),
773('', 'Chad', 'TD'),
774('', 'Chile', 'CL'),
775('', 'China', 'CN'),
776('', 'Christmas Island', 'CX'),
777('', 'Cocos [Keeling] Islands', 'CC'),
778('', 'Colombia', 'CO'),
779('', 'Comoros', 'KM'),
780('', 'Cook Islands', 'CK'),
781('', 'Costa Rica', 'CR'),
782('', 'Croatia', 'HR'),
783('', 'Cuba', 'CU'),
784('', 'Curacao', 'CW'),
785('', 'Cyprus', 'CY'),
786('', 'Czech Republic', 'CZ'),
787('', 'Democratic Republic of the Congo', 'CD'),
788('', 'Denmark', 'DK'),
789('', 'Djibouti', 'DJ'),
790('', 'Dominica', 'DM'),
791('', 'Dominican Republic', 'DO'),
792('', 'East Timor', 'TL'),
793('', 'Ecuador', 'EC'),
794('', 'Egypt', 'EG'),
795('', 'El Salvador', 'SV'),
796('', 'Equatorial Guinea', 'GQ'),
797('', 'Eritrea', 'ER'),
798('', 'Estonia', 'EE'),
799('', 'Ethiopia', 'ET'),
800('', 'Falkland Islands', 'FK'),
801('', 'Faroe Islands', 'FO'),
802('', 'Fiji', 'FJ'),
803('', 'Finland', 'FI'),
804('', 'France', 'FR'),
805('', 'French Guiana', 'GF'),
806('', 'French Polynesia', 'PF'),
807('', 'French Southern Territories', 'TF'),
808('', 'Gabon', 'GA'),
809('', 'Gambia', 'GM'),
810('', 'Georgia', 'GE'),
811('', 'Germany', 'DE'),
812('', 'Ghana', 'GH'),
813('', 'Gibraltar', 'GI'),
814('', 'Greece', 'GR'),
815('', 'Greenland', 'GL'),
816('', 'Grenada', 'GD'),
817('', 'Guadeloupe', 'GP'),
818('', 'Guam', 'GU'),
819('', 'Guatemala', 'GT'),
820('', 'Guernsey', 'GG'),
821('', 'Guinea', 'GN'),
822('', 'Guinea-Bissau', 'GW'),
823('', 'Guyana', 'GY'),
824('', 'Haiti', 'HT'),
825('', 'Heard Island and McDonald Islands', 'HM'),
826('', 'Honduras', 'HN'),
827('', 'Hong Kong', 'HK'),
828('', 'Hungary', 'HU'),
829('', 'Iceland', 'IS'),
830('', 'India', 'IN'),
831('', 'Indonesia', 'ID'),
832('', 'Iran', 'IR'),
833('', 'Iraq', 'IQ'),
834('', 'Ireland', 'IE'),
835('', 'Isle of Man', 'IM'),
836('', 'Israel', 'IL'),
837('', 'Italy', 'IT'),
838('', 'Ivory Coast', 'CI'),
839('', 'Jamaica', 'JM'),
840('', 'Japan', 'JP'),
841('', 'Jersey', 'JE'),
842('', 'Jordan', 'JO'),
843('', 'Kazakhstan', 'KZ'),
844('', 'Kenya', 'KE'),
845('', 'Kiribati', 'KI'),
846('', 'Kosovo', 'XK'),
847('', 'Kuwait', 'KW'),
848('', 'Kyrgyzstan', 'KG'),
849('', 'Laos', 'LA'),
850('', 'Latvia', 'LV'),
851('', 'Lebanon', 'LB'),
852('', 'Lesotho', 'LS'),
853('', 'Liberia', 'LR'),
854('', 'Libya', 'LY'),
855('', 'Liechtenstein', 'LI'),
856('', 'Lithuania', 'LT'),
857('', 'Luxembourg', 'LU'),
858('', 'Macao', 'MO'),
859('', 'Macedonia', 'MK'),
860('', 'Madagascar', 'MG'),
861('', 'Malawi', 'MW'),
862('', 'Malaysia', 'MY'),
863('', 'Maldives', 'MV'),
864('', 'Mali', 'ML'),
865('', 'Malta', 'MT'),
866('', 'Marshall Islands', 'MH'),
867('', 'Martinique', 'MQ'),
868('', 'Mauritania', 'MR'),
869('', 'Mauritius', 'MU'),
870('', 'Mayotte', 'YT'),
871('', 'Mexico', 'MX'),
872('', 'Micronesia', 'FM'),
873('', 'Moldova', 'MD'),
874('', 'Monaco', 'MC'),
875('', 'Mongolia', 'MN'),
876('', 'Montenegro', 'ME'),
877('', 'Montserrat', 'MS'),
878('', 'Morocco', 'MA'),
879('', 'Mozambique', 'MZ'),
880('', 'Myanmar [Burma]', 'MM'),
881('', 'Namibia', 'NA'),
882('', 'Nauru', 'NR'),
883('', 'Nepal', 'NP'),
884('', 'Netherlands', 'NL'),
885('', 'New Caledonia', 'NC'),
886('', 'New Zealand', 'NZ'),
887('', 'Nicaragua', 'NI'),
888('', 'Niger', 'NE'),
889('', 'Nigeria', 'NG'),
890('', 'Niue', 'NU'),
891('', 'Norfolk Island', 'NF'),
892('', 'North Korea', 'KP'),
893('', 'Northern Mariana Islands', 'MP'),
894('', 'Norway', 'NO'),
895('', 'Oman', 'OM'),
896('', 'Pakistan', 'PK'),
897('', 'Palau', 'PW'),
898('', 'Palestine', 'PS'),
899('', 'Panama', 'PA'),
900('', 'Papua New Guinea', 'PG'),
901('', 'Paraguay', 'PY'),
902('', 'Peru', 'PE'),
903('', 'Philippines', 'PH'),
904('', 'Pitcairn Islands', 'PN'),
905('', 'Poland', 'PL'),
906('', 'Portugal', 'PT'),
907('', 'Puerto Rico', 'PR'),
908('', 'Qatar', 'QA'),
909('', 'Republic of the Congo', 'CG'),
910('', 'Réunion', 'RE'),
911('', 'Romania', 'RO'),
912('', 'Russia', 'RU'),
913('', 'Rwanda', 'RW'),
914('', 'Saint Barthélemy', 'BL'),
915('', 'Saint Helena', 'SH'),
916('', 'Saint Kitts and Nevis', 'KN'),
917('', 'Saint Lucia', 'LC'),
918('', 'Saint Martin', 'MF'),
919('', 'Saint Pierre and Miquelon', 'PM'),
920('', 'Saint Vincent and the Grenadines', 'VC'),
921('', 'Samoa', 'WS'),
922('', 'San Marino', 'SM'),
923('', 'São Tomé and Príncipe', 'ST'),
924('', 'Saudi Arabia', 'SA'),
925('', 'Senegal', 'SN'),
926('', 'Serbia', 'RS'),
927('', 'Seychelles', 'SC'),
928('', 'Sierra Leone', 'SL'),
929('', 'Singapore', 'SG'),
930('', 'Sint Maarten', 'SX'),
931('', 'Slovakia', 'SK'),
932('', 'Slovenia', 'SI'),
933('', 'Solomon Islands', 'SB'),
934('', 'Somalia', 'SO'),
935('', 'South Africa', 'ZA'),
936('', 'South Georgia and the South Sandwich Islands', 'GS'),
937('', 'South Korea', 'KR'),
938('', 'South Sudan', 'SS'),
939('', 'Spain', 'ES'),
940('', 'Sri Lanka', 'LK'),
941('', 'Sudan', 'SD'),
942('', 'Suriname', 'SR'),
943('', 'Svalbard and Jan Mayen', 'SJ'),
944('', 'Swaziland', 'SZ'),
945('', 'Sweden', 'SE'),
946('', 'Switzerland', 'CH'),
947('', 'Syria', 'SY'),
948('', 'Taiwan', 'TW'),
949('', 'Tajikistan', 'TJ'),
950('', 'Tanzania', 'TZ'),
951('', 'Thailand', 'TH'),
952('', 'Togo', 'TG'),
953('', 'Tokelau', 'TK'),
954('', 'Tonga', 'TO'),
955('', 'Trinidad and Tobago', 'TT'),
956('', 'Tunisia', 'TN'),
957('', 'Turkey', 'TR'),
958('', 'Turkmenistan', 'TM'),
959('', 'Turks and Caicos Islands', 'TC'),
960('', 'Tuvalu', 'TV'),
961('', 'U.S. Minor Outlying Islands', 'UM'),
962('', 'U.S. Virgin Islands', 'VI'),
963('', 'Uganda', 'UG'),
964('', 'Ukraine', 'UA'),
965('', 'United Arab Emirates', 'AE'),
966('', 'United Kingdom', 'GB'),
967('', 'United States', 'US'),
968('', 'Uruguay', 'UY'),
969('', 'Uzbekistan', 'UZ'),
970('', 'Vanuatu', 'VU'),
971('', 'Vatican City', 'VA'),
972('', 'Venezuela', 'VE'),
973('', 'Vietnam', 'VN'),
974('', 'Wallis and Futuna', 'WF'),
975('', 'Western Sahara', 'EH'),
976('', 'Yemen', 'YE'),
977('', 'Zambia', 'ZM'),
978('', 'Zimbabwe', 'ZW');