-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathminion_sql.sql
397 lines (315 loc) · 22.2 KB
/
minion_sql.sql
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
# ************************************************************
# Database: minion
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table admin_user
# ------------------------------------------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role` enum('journalist','editor','admin') NOT NULL DEFAULT 'journalist',
`login` varchar(50) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `admin_user` WRITE;
/*!40000 ALTER TABLE `admin_user` DISABLE KEYS */;
INSERT INTO `admin_user` (`id`, `role`, `login`, `email`, `name`, `password`, `active`)
VALUES
(1,'admin','admin','admin@localhost','Admin Name','$2y$10$AgDvbucEVa46YdOyHKq5gOYgWTfsF2PpASkCUm5St7OVIJi5PMLDC',1),
(2,'admin','stuart','stuart@localhost','Stuart','$2y$10$AgDvbucEVa46YdOyHKq5gOYgWTfsF2PpASkCUm5St7OVIJi5PMLDC',1);
/*!40000 ALTER TABLE `admin_user` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table cms_configuration
# ------------------------------------------------------------
DROP TABLE IF EXISTS `cms_configuration`;
CREATE TABLE `cms_configuration` (
`key` varchar(50) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `cms_configuration` WRITE;
/*!40000 ALTER TABLE `cms_configuration` DISABLE KEYS */;
INSERT INTO `cms_configuration` (`key`, `value`)
VALUES
('ADMIN_EMAIL','minion@localhost'),
('DEBUG_MODE','1'),
('PROFILER','1'),
('TECHNICAL_WORKS','0'),
('WIDGETS_CACHE','1');
/*!40000 ALTER TABLE `cms_configuration` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table language
# ------------------------------------------------------------
DROP TABLE IF EXISTS `language`;
CREATE TABLE `language` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`iso` varchar(10) NOT NULL,
`locale` varchar(10) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL,
`short_name` varchar(10) DEFAULT NULL,
`url` varchar(20) DEFAULT NULL,
`sortorder` int(11) DEFAULT NULL,
`primary` enum('0','1') DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `iso` (`iso`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `language` WRITE;
/*!40000 ALTER TABLE `language` DISABLE KEYS */;
INSERT INTO `language` (`id`, `iso`, `locale`, `name`, `short_name`, `url`, `sortorder`, `primary`)
VALUES
(1,'en','en_EN','English','Eng','en',1,'1');
/*!40000 ALTER TABLE `language` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table page
# ------------------------------------------------------------
DROP TABLE IF EXISTS `page`;
CREATE TABLE `page` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`slug` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `page` WRITE;
/*!40000 ALTER TABLE `page` DISABLE KEYS */;
INSERT INTO `page` (`id`, `slug`, `created_at`, `updated_at`)
VALUES
(1,'index','2014-08-03 15:18:47','2016-12-28 15:15:22'),
(2,'contacts','2014-08-03 22:25:13','2016-12-28 13:46:55');
/*!40000 ALTER TABLE `page` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table page_translate
# ------------------------------------------------------------
DROP TABLE IF EXISTS `page_translate`;
CREATE TABLE `page_translate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`foreign_id` int(11) NOT NULL,
`lang` varchar(20) DEFAULT NULL,
`key` varchar(255) DEFAULT NULL,
`value` text,
PRIMARY KEY (`id`),
KEY `foreign_id` (`foreign_id`),
KEY `lang` (`lang`),
CONSTRAINT `page_translate_ibfk_1` FOREIGN KEY (`foreign_id`) REFERENCES `page` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `page_translate_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `language` (`iso`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `page_translate` WRITE;
/*!40000 ALTER TABLE `page_translate` DISABLE KEYS */;
INSERT INTO `page_translate` (`id`, `foreign_id`, `lang`, `key`, `value`)
VALUES
(1,1,'en','title','Homepage'),
(2,1,'en','meta_title','Homepage'),
(3,1,'en','meta_description','meta-description of homepage'),
(4,1,'en','meta_keywords',''),
(5,1,'en','text','<h1 style=\"text-align: center;\">Minion CMS</h1>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">Minion CMS - Written in <a href=\"http://phalconphp.com/\" target=\"_blank\" rel=\"noopener noreferrer\">Phalcon PHP Framework</a> (version 3.x). Inherit from <a href=\"https://github.com/oleksandr-torosh/yona-cms\">YonaCMS</a>, but structure folder look like <a href=\"https://github.com/laravel/laravel\">Laravel</a></p>\r\n<p style=\"text-align: center;\">The official repository on <a href=\"https://github.com/vietdien2005/minion-phalcon\" target=\"_blank\" rel=\"noopener noreferrer\">Github</a></p>\r\n<h2> </h2>'),
(6,2,'en','title','Contacts'),
(7,2,'en','meta_title','Contacts'),
(8,2,'en','meta_description','this is my contact'),
(9,2,'en','meta_keywords','contact'),
(10,2,'en','text','<h1 style=\"text-align: center;\">Contacts</h1>\r\n<p style=\"text-align: center;\">Github: <a href=\"https://github.com/vietdien2005\">https://github.com/vietdien2005</a></p>\r\n<p style=\"text-align: center;\">Gmail: <a href=\"mailto:damviet112@gmail.com\">damviet112@gmail.com</a></p>\r\n<p style=\"text-align: center;\">Facebook: <a href=\"https://www.facebook.com/damviet92\">https://www.facebook.com/damviet92</a></p>\r\n<p style=\"text-align: center;\">Website: <a href=\"/page/admin/edit/vietdien2005.github.io\">vietdien2005.github.io</a></p>');
/*!40000 ALTER TABLE `page_translate` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table publication
# ------------------------------------------------------------
DROP TABLE IF EXISTS `publication`;
CREATE TABLE `publication` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type_id` int(11) DEFAULT NULL,
`slug` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`date` datetime DEFAULT NULL,
`preview_inner` enum('1','0') DEFAULT '1',
`preview_src` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `type_id` (`type_id`),
CONSTRAINT `publication_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `publication_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `publication` WRITE;
/*!40000 ALTER TABLE `publication` DISABLE KEYS */;
INSERT INTO `publication` (`id`, `type_id`, `slug`, `created_at`, `updated_at`, `date`, `preview_inner`, `preview_src`)
VALUES
(1,1,'laravel-5-5-will-required-php-7-0','2014-08-22 10:33:26','2016-12-28 11:11:16','2016-12-27 00:00:00','0','img/original/publication/0/1.jpg'),
(2,1,'laravel-elixir-will-be-reanamed-to-laravel-mix','2014-08-22 10:42:08','2016-12-28 11:10:15','2016-12-27 00:00:00','0','img/original/publication/0/2.jpg'),
(3,2,'laravel-dusk-is-coming-to-laravel-5-4','2014-11-05 18:00:20','2016-12-28 11:09:18','2014-11-05 00:00:00','1','img/original/publication/0/3.jpg'),
(4,2,'changes-coming-to-the-laravel-release-cycle','2014-11-06 18:23:17','2016-12-28 11:23:20','2014-11-06 00:00:00','1','img/original/publication/0/4.jpg'),
(5,1,'leanpub-announces-a-new-pricing-model','2015-04-29 10:42:49','2016-12-28 17:01:43','2016-12-27 00:00:00','0','img/original/publication/0/5.jpg');
/*!40000 ALTER TABLE `publication` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table publication_translate
# ------------------------------------------------------------
DROP TABLE IF EXISTS `publication_translate`;
CREATE TABLE `publication_translate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`foreign_id` int(11) NOT NULL,
`lang` varchar(20) DEFAULT NULL,
`key` varchar(255) DEFAULT NULL,
`value` text,
PRIMARY KEY (`id`),
KEY `foreign_id` (`foreign_id`),
KEY `lang` (`lang`),
CONSTRAINT `publication_translate_ibfk_1` FOREIGN KEY (`foreign_id`) REFERENCES `publication` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `publication_translate_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `language` (`iso`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `publication_translate` WRITE;
/*!40000 ALTER TABLE `publication_translate` DISABLE KEYS */;
INSERT INTO `publication_translate` (`id`, `foreign_id`, `lang`, `key`, `value`)
VALUES
(1,1,'en','title','Laravel 5.5 will require PHP 7.0+'),
(2,1,'en','meta_title','Laravel 5.5 will require PHP 7.0+'),
(3,1,'en','meta_description',''),
(4,1,'en','meta_keywords',''),
(5,1,'en','text','<p>Laravel has always been a framework that isn’t afraid to push forward and Taylor just announced on Twitter that Laravel 5.5 will require PHP 7+.</p>\r\n<p> The 5.5 release is not scheduled until July of 2017 so it’s still months away, however, it’s a good idea to start thinking about upgrading your servers if you are still running PHP 5.x.</p>\r\n<p>Outside of the new developer features PHP 7.0 introduces, it also includes speed improvements that will save your company money. Tumblr recently moved to PHP 7 and they reported:</p>\r\n<p style=\"padding-left: 30px;\"><em>Almost immediately saw the latency drop by half, and the CPU load on the servers decrease at least 50%, often more. Not only were our servers serving pages twice as fast, they were doing it using half the amount of CPU resources.</em></p>\r\n<p>If your code base hasn’t started the transition to PHP 7 yet, the official PHP docs has a great migration guide that includes everything you need to check before moving. For those running Laravel v5 and higher then upgrading should be a relatively painless process since it already runs on the latest PHP version.</p>'),
(6,2,'en','title','Laravel Elixir Will Be Renamed To Laravel Mix'),
(7,2,'en','meta_title','Laravel Elixir Will Be Renamed To Laravel Mix'),
(8,2,'en','meta_description',''),
(9,2,'en','meta_keywords',''),
(10,2,'en','text','<p>Laravel Elixir first came out in October of 2014 and aimed to make automating concatenation, and general file watching easier than setting it up manually. Built on top of Gulp as a wrapper to remove all the difficult parts it has been a popular addition to Laravel.</p>\r\n<p>The next version of Laravel Elixir is changing the underlying system and will be built on Webpack, instead of Gulp. This will replace the plugin ecosystem, and because of such a significant change, it was time to rename the package.</p>\r\n<p>The new name is Laravel Mix, and it should be released along with Laravel 5.4.</p>\r\n<p>If you have been using the default Elixir then switching should be simple and just require updating or moving over your gulp file to the new setup. Of course, complete documentation will be included in the official release.</p>\r\n<p>For more information on Webpack, they have an excellent high level overview of the concepts behind the system.</p>'),
(11,3,'en','title','Laravel Dusk Is Coming to Laravel 5.4'),
(12,3,'en','meta_title','Laravel Dusk Is Coming to Laravel 5.4'),
(13,3,'en','meta_description',''),
(14,3,'en','meta_keywords',''),
(15,3,'en','text','<p>When you write end-to-end tests, Laravel provides a set of useful helper methods which make it easy to click a link, fill an input field, or submit a form. Under the hood, Laravel uses the Symfony BrowserKit component to simulate the behavior of the web browser. However, if your app uses JavaScript and AJAX to load the page, BrowserKit will not work for you.</p>\r\n<p>Laravel Dusk is a new tool that will be introduced in Laravel 5.4 to solve this problem.</p>\r\n<p>Dusk is an end-to-end browser testing tool for JavaScript enabled applications. It aims to provide the right way to do page interaction tests, so you can use Dusk for things like click buttons/links, fill out forms, and even drag and drop!</p>\r\n<p>Dusk is utilizing ChromeDriver and Facebook Php-webdriver for doing end-to-end tests. It can work with any Selenium browser, but it comes with ChromeDriver by default which will save you from installing JDK or Selenium. It makes Dusk very easy to use without the need to go through the tough process of setting up Selenium and starting the server every time. Furthermore, Taylor Otwell mentions Dusk tests are running faster than Selenium.</p>\r\n<p>Dusk will be more natural than BrowserKit; you don’t have to wait on something to finish or use sleeping and pausing while waiting for things to appear. Instead, Dusk allows you to wait for some condition to be true in your JavaScript or wait for CSS selectors to be available to have a better way to test JavaScript enabled applications.</p>\r\n<p>Also, Dusk will save screenshots of your failed tests automatically! You can see what the page looked like and what went wrong.</p>\r\n<p>Another nice feature is that it will provide handy helper methods like loginAs, which allows you to give it a user instance.t will log the user in, and the test will go straight to any authenticated URL directly without going through the login screen every time.</p>\r\n<p>Dusk will allow you to open multiple browser windows per test which will make it easy to test apps which have socket integration.You can open two windows and interact with the first and see the result in the second.</p>\r\n<p>Otwell has also provided some information about the Dusk testing environment; your app root will contain a .env.dusk file to define your testing environment. To run your Dusk test, you will not use PHPUnit directly. Instead, you will call a Dusk artisan command which will proxy down to PHPUnit and backup your .env file. Then, it will move the .env.dusk file to be the environment being used for your Dusk test. When finished, it will restore your real .env file back to its place.</p>\r\n<p>Note that you can use the old BrowserKit testing if you have an app using Laravel 5.3 and want to upgrade to 5.4 without losing your current tests. The Laravel BrowserKit Testing package will provide the Laravel 5.3 style “BrowserKit” testing on Laravel 5.4.</p>'),
(16,4,'en','title','Changes coming to the Laravel release cycle'),
(17,4,'en','meta_title','Changes coming to the Laravel release cycle'),
(18,4,'en','meta_description',''),
(19,4,'en','meta_keywords',''),
(20,4,'en','text','<p>Back in 2013, Taylor announced Laravel’s official release cycle where each year includes two releases. The first in June and the second in December.</p>\r\n<p>Yesterday, Taylor announced on Twitter that this is going to be changing to a January and July cycle, pushing each release out a month from its current schedule.</p>\r\n<p>This has two primary advantages for the development team and the first is it allows more time for testing after Symfony’s release. The second advantage is it’ll better coincide with Laracon, the yearly Laravel conference.</p>\r\n<p>For most of the users of Laravel, this will not affect much, Laravel 5.4 will be pushed out one month to launch in January. Then it’ll be back to the normal six-month release cycle with the next one coming in July.</p>'),
(21,5,'en','title','Leanpub announces a new pricing model'),
(22,5,'en','meta_title','Leanpub announces a new pricing model'),
(23,5,'en','meta_description',''),
(24,5,'en','meta_keywords',''),
(25,5,'en','text','<p>Leanpub is home to many books on Laravel including Easy E-Commerce that I co-authored. Today they have announced a pricing change for all publishers using the service. Creating a book with Leanpub is now $100 per book.</p>\r\n<p style=\"padding-left: 30px;\"><em>Today we are changing the pricing of Leanpub. Until now, Leanpub has been totally free for authors to use. We have earned all of our money from our portion of the storefront revenue. (After the author royalties, PayPal fees and chargeback costs, our gross margin on the storefront is about 8% – for every $100 of book sales on Leanpub, we earn about $8.) </em></p>\r\n<p>They are also keeping the existing fee structure of keeping 10% and 50 cents per paid sale. However, you are not required to use them as a selling agent. All books created with the service can be sold through your own site. Plus they are also giving discounts to existing authors:</p>\r\n<p style=\"padding-left: 30px;\"><em>We want to reward loyal authors who support Leanpub through their storefront sales. So, we have two discounts based on lifetime royalties earned across all your Leanpub books. Once you’ve earned at least $1,000 in royalties, creating a new book costs $49 per book. Once you’ve earned at least $10,000 in royalties, creating a new book is free. Hundreds of Leanpub authors will immediately qualify for one of these discounts, and we hope thousands more do in future.</em></p>\r\n<p>I imagine this move will dampen free book authors from using the service but I think this is a good change because I’ve seen some write their books with the Leanpub system and then sell it completely through other sites.</p>');
/*!40000 ALTER TABLE `publication_translate` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table publication_type
# ------------------------------------------------------------
DROP TABLE IF EXISTS `publication_type`;
CREATE TABLE `publication_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`slug` varchar(50) DEFAULT NULL,
`limit` int(4) DEFAULT NULL,
`format` enum('list','grid') DEFAULT NULL,
`display_date` enum('0','1') DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `publication_type` WRITE;
/*!40000 ALTER TABLE `publication_type` DISABLE KEYS */;
INSERT INTO `publication_type` (`id`, `slug`, `limit`, `format`, `display_date`)
VALUES
(1,'news',3,'grid','1'),
(2,'articles',3,'list','0');
/*!40000 ALTER TABLE `publication_type` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table publication_type_translate
# ------------------------------------------------------------
DROP TABLE IF EXISTS `publication_type_translate`;
CREATE TABLE `publication_type_translate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`foreign_id` int(11) NOT NULL,
`lang` varchar(20) DEFAULT NULL,
`key` varchar(255) DEFAULT NULL,
`value` text,
PRIMARY KEY (`id`),
KEY `foreign_id` (`foreign_id`),
KEY `lang` (`lang`),
CONSTRAINT `publication_type_translate_ibfk_1` FOREIGN KEY (`foreign_id`) REFERENCES `publication_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `publication_type_translate_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `language` (`iso`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `publication_type_translate` WRITE;
/*!40000 ALTER TABLE `publication_type_translate` DISABLE KEYS */;
INSERT INTO `publication_type_translate` (`id`, `foreign_id`, `lang`, `key`, `value`)
VALUES
(1,1,'en','title','News'),
(2,1,'en','head_title','News'),
(3,1,'en','meta_description',''),
(4,1,'en','meta_keywords',''),
(5,1,'en','seo_text',''),
(6,2,'en','title','Articles'),
(7,2,'en','head_title','Articles'),
(8,2,'en','meta_description',''),
(9,2,'en','meta_keywords',''),
(10,2,'en','seo_text','');
/*!40000 ALTER TABLE `publication_type_translate` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table translate
# ------------------------------------------------------------
DROP TABLE IF EXISTS `translate`;
CREATE TABLE `translate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`lang` varchar(20) DEFAULT NULL,
`phrase` varchar(500) DEFAULT NULL,
`translation` varchar(500) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
CONSTRAINT `translate_ibfk_1` FOREIGN KEY (`lang`) REFERENCES `language` (`iso`) ON DELETE CASCADE ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `translate` WRITE;
/*!40000 ALTER TABLE `translate` DISABLE KEYS */;
INSERT INTO `translate` (`id`, `lang`, `phrase`, `translation`)
VALUES
(1,'en','Form validation fails','Form validation fails'),
(2,'en','Read more','Read more'),
(3,'en','Back to the publications list','Back to the publications list'),
(4,'en','SITE NAME','Minion CMS'),
(5,'en','Home','Home'),
(6,'en','News','News'),
(7,'en','Contacts','Contacts'),
(8,'en','Articles','Articles'),
(9,'en','Home','Home'),
(10,'en','News','News'),
(11,'en','Articles','Articles'),
(12,'en','Contacts','Contacts'),
(13,'en','Admin','Admin'),
(14,'en','YonaCms Admin Panel','YonaCms Admin Panel'),
(15,'en','Back to publications list','Back to publications list'),
(16,'en','Page num.','Page num.'),
(17,'en','Full version','Full version'),
(18,'en','Mobile version','Mobile version'),
(19,'en','Services','Services'),
(20,'en','Printing','Printing'),
(21,'en','Design','Design'),
(22,'en','Latest news','Latest news'),
(23,'en','Entries not found','Entries not found'),
(24,'en','Back to publications list','Back to publications list'),
(25,'en','More','More'),
(26,'en','Error form validation','Error form validation'),
(27,'en','Page number','Page number');
/*!40000 ALTER TABLE `translate` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table widget
# ------------------------------------------------------------
DROP TABLE IF EXISTS `widget`;
CREATE TABLE `widget` (
`id` varchar(255) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`html` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `widget` WRITE;
/*!40000 ALTER TABLE `widget` DISABLE KEYS */;
INSERT INTO `widget` (`id`, `title`, `html`)
VALUES
('homepage','Text Homepage','<span class=\"name\">Bello !! I\'m Stuart </span> ');
/*!40000 ALTER TABLE `widget` ENABLE KEYS */;
UNLOCK TABLES;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;