-
Notifications
You must be signed in to change notification settings - Fork 0
/
GotCms_GotCms.sql
332 lines (332 loc) · 40.4 KB
/
GotCms_GotCms.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
INSERT INTO document_type VALUES (4, '2013-05-24 08:49:53.537851', '2013-06-02 11:29:27.171857', 'Blog ticket', 'Ticket blog', 6, 11, 1)
INSERT INTO property_value VALUES (47, 8, 32, 'Two Column #2 (left-hand sidebar)')
INSERT INTO view VALUES (5, '2012-09-20 22:12:33', '2012-09-20 22:21:24', 'Navigation', 'navigation', 'Navigation')
INSERT INTO property_value VALUES (52, 8, 28, 'Two Column #2')
INSERT INTO view VALUES (4, '2012-09-19 19:33:51', '2012-10-08 22:32:28', 'About', 'about', 'About page')
INSERT INTO layout VALUES (1, '2012-09-19 19:28:34', '2012-09-20 22:31:50', 'Main', 'main-layout', 'Main layout')
INSERT INTO property_value VALUES (52, 8, 28, '\x54776f20436f6c756d6e202332')
INSERT INTO property_value VALUES (53, 8, 29, '')
INSERT INTO property_value VALUES (17, 1, 17, '\x5468652043434120332e30204c6963656e7365')
INSERT INTO property_value VALUES (16, 1, 16, 'Responsive? Really?')
INSERT INTO property VALUES (1, 'Meta description', 'metaDescription', 'Description', false, NULL, 5, 1)
INSERT INTO document VALUES (3, '2012-09-20 22:09:29', '2013-05-25 13:58:10.973436', 'Contact', 'contact', 1, 3, true, true, NULL, 1, 2, 3, 1, NULL)
INSERT INTO property_value VALUES (53, 8, 29, '\x')
INSERT INTO property_value VALUES (11, 3, 6, 'Contact')
INSERT INTO property_value VALUES (27, 4, 40, '')
INSERT INTO view VALUES (6, '2012-10-25 19:57:05', '2013-06-02 12:22:18.393061', 'Flash messages', 'flash-messages', 'Flash messages displayer')
INSERT INTO property_value VALUES (46, 7, 31, '\x54776f20436f6c756d6e202332')
SELECT id FROM user_acl_role WHERE name = '" . $v . "'
INSERT INTO property_value VALUES (4, 1, 3, '\x4d792077656273697465')
INSERT INTO tab VALUES (8, 'Title and meta', 'Meta description', NULL, 3)
INSERT INTO view VALUES (6, '2012-10-25 19:57:05', '2012-10-25 20:27:48', 'Flash messages', 'flash-messages', 'Flash messages displayer')
INSERT INTO property_value VALUES (10, 2, 13, 'About')
INSERT INTO document_type_dependency VALUES (10, 6, 5)
INSERT INTO property_value VALUES (21, 1, 21, '\x3c703e0d0a0954686973206973203c7374726f6e673e417263616e613c2f7374726f6e673e2c20612066756c6c7920726573706f6e736976652048544d4c3520736974652074656d706c6174652064657369676e6564206279203c6120687265663d22687474703a2f2f6e33332e636f2f223e6e33333c2f613e20616e642072656c656173656420666f722066726565206279203c6120687265663d22687474703a2f2f68746d6c3575702e6e65742f223e48544d4c352055503c2f613e20497420666561747572657320612073696d706c652079657420656c6567616e742064657369676e2c20736f6c69642048544d4c3520616e64204353533320636f64652c20616e642066756c6c20726573706f6e7369766520737570706f727420666f72206465736b746f702c207461626c65742c20616e64206d6f62696c6520646973706c6179732e3c2f703e0d0a')
INSERT INTO activity_log_template VALUES (5, 'Gc\Document\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (5, 1, 4, '\x4d792077656273697465')
INSERT INTO tab VALUES (9, 'Banner', 'Banner', 1, 1)
INSERT INTO property VALUES (27, 'Image', 'image', '', false, 5, 12, 7)
INSERT INTO view VALUES (2, '2012-09-19 19:29:50', '2013-05-26 13:26:11.840543', 'Blog', 'blog', 'Blog')
INSERT INTO document VALUES (1, '2012-09-20 22:06:53', '2013-05-26 13:28:51.590892', 'Home', '', 1, 0, true, true, NULL, 1, 1, 1, 1, NULL)
INSERT INTO property_value VALUES (14, 3, 9, '\x436f6e74616374')
CREATE TABLE `document` ( `id` INT NOT NULL AUTO_INCREMENT, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, `name` VARCHAR(255) NOT NULL, `url_key` VARCHAR(255) NOT NULL, `status` INT NOT NULL DEFAULT 0, `sort_order` INT NOT NULL DEFAULT 0, `show_in_nav` boolean DEFAULT false, `can_be_cached` boolean DEFAULT true, `locale` VARCHAR(255) DEFAULT NULL, `user_id` INT NOT NULL, `document_type_id` integer, `view_id` integer, `layout_id` integer, `parent_id` integer DEFAULT 0, PRIMARY KEY (`id`))
INSERT INTO document_type VALUES (4, '2013-05-24 08:49:53.537851', '2013-05-24 19:03:37.181713', 'Blog ticket', 'Ticket blog', 6, 11, 1)
CREATE TABLE `script` ( `id` INT NOT NULL AUTO_INCREMENT, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, `name` VARCHAR(255) NOT NULL, `identifier` VARCHAR(255), `description` VARCHAR(255), PRIMARY KEY (`id`), UNIQUE KEY `name` (`identifier`))
INSERT INTO view VALUES (10, '2013-05-24 19:02:21.732603', '2013-05-26 13:26:11.862514', 'Blog categories', 'blog-categories', 'List all categories')
INSERT INTO document VALUES (8, '2013-05-25 14:01:26.09229', '2013-05-26 13:32:27.671487', 'Article 2', 'article-about-something', 1, 0, false, false, NULL, 1, 4, 11, 1, 6)
INSERT INTO document VALUES (7, '2013-05-25 14:00:54.412118', '2013-05-26 13:32:18.374819', 'Article 1', 'article-about-something', 1, 0, false, false, NULL, 1, 4, 11, 1, 5)
INSERT INTO tab VALUES (18, 'Sidebar', 'Sidebar text', 1, 4)
INSERT INTO document VALUES (3, '2012-09-20 22:09:29', '2012-10-09 08:00:21', 'Contact', 'contact', 1, 2, true, true, NULL, 1, 2, 3, 1, NULL)
INSERT INTO property VALUES (4, 'Main Title', 'mainTitle', 'Title', false, 14, 5, 1)
INSERT INTO document_type_dependency VALUES (4, 5, 4)
INSERT INTO property_value VALUES (14, 3, 9, 'Contact')
INSERT INTO view VALUES (3, '2012-09-19 19:32:56', '2013-05-26 13:26:11.884399', 'Contact', 'contact', 'Contact form')
CREATE TABLE `module` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`))
INSERT INTO activity_log_template VALUES (8, 'Gc\\Layout\\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO activity_log_template VALUES (2, 'Gc\Datatype\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (37, 6, 38, '\x5365636f6e642063617465676f7279202d20426c6f67')
INSERT INTO view VALUES (6, '2012-10-25 19:57:05', '2012-10-25 20:27:48', 'Flash messages', 'flash-messages', 'Flash messages displayer')
INSERT INTO tab VALUES (4, 'Content', 'Content', NULL, 3)
INSERT INTO activity_log_template VALUES (7, 'Gc\DocumentType\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (46, 7, 31, 'Two Column #2')
CREATE TABLE `property_value` ( `id` INT NOT NULL AUTO_INCREMENT, `document_id` INT NOT NULL, `property_id` INT NOT NULL, `value` LONGBLOB, PRIMARY KEY (`id`))
INSERT INTO property VALUES (2, 'Keywords', 'metaKeywords', 'Keywords', false, 12, 5, 1)
INSERT INTO property VALUES (4, 'Main Title', 'mainTitle', 'Title', false, NULL, 5, 1)
INSERT INTO property_value VALUES (7, 2, 10, '\x41626f7574')
INSERT INTO property VALUES (33, 'Publication date', 'published_at', '', false, 2, 11, 6)
SELECT name, 4 FROM module;
INSERT INTO property_value VALUES (41, 7, 26, '\x3c703e0d0a0953757370656e64697373652066617563696275732064696374756d2074656c6c757320696420706f73756572652e204372617320717569732065726f732074656c6c75732c20696420706f7375657265206c616375732e205072616573656e74206163206573742065726f732e20416c697175616d20656c656966656e64206e756e63207574206e6571756520636f6e736571756174207175697320737573636970697420656c69742074696e636964756e742e20467573636520696e74657264756d20677261766964612074696e636964756e742e2053656420657420616e7465206e6563206c6967756c61206672696e67696c6c6120636f6e64696d656e74756d2e204d61757269732076656c2073656d206163206c6967756c6120736564206c6f72656d20766573746962756c756d206f726e6172652076656c20736564206e6962682e2046757363652072686f6e6375732074696e636964756e7420616e74652c206e6f6e2068656e647265726974206d61676e6120766573746962756c756d20717569732e20496e74656765722076656c20656e696d2073656d2070686173656c6c75732074656d707573206c6f72656d2e3c2f703e0d0a')
INSERT INTO property_value VALUES (45, 7, 30, '\x54776f20436f6c756d6e202332')
INSERT INTO property VALUES (6, 'Meta description', 'metaDescription', 'Description', false, NULL, 7, 1)
INSERT INTO tab VALUES (15, 'Title and meta', 'Meta description', 1, 6)
INSERT INTO property_value VALUES (10, 2, 13, '\x41626f7574')
INSERT INTO property_value VALUES (17, 1, 17, 'The CCA 3.0 License')
INSERT INTO property VALUES (7, 'Keywords', 'metaKeywords', 'Keywords', false, 2, 7, 1)
SELECT VIEW_NAME, TEXT FROM ALL_VIEWS WHERE OWNER=:OWNER', $bind);
CREATE TABLE `layout` ( `id` INT NOT NULL AUTO_INCREMENT, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, `name` VARCHAR(255) NOT NULL, `identifier` VARCHAR(255) NOT NULL, `description` VARCHAR(255), PRIMARY KEY (`id`), UNIQUE KEY `name` (`identifier`))
INSERT INTO document VALUES (4, '2013-05-25 13:57:47.516331', '2013-05-26 13:31:30.638063', 'Blog', 'blog', 1, 1, true, false, NULL, 1, 6, 2, 1, NULL)
CREATE TABLE `user_acl` ( `id` INT NOT NULL AUTO_INCREMENT, `user_acl_permission_id` INT NOT NULL, `user_acl_role_id` INT NOT NULL, PRIMARY KEY (`id`))
INSERT INTO property_value VALUES (58, 4, 49, '\x613a353a7b733a353a2276616c7565223b733a33353a222f6d656469612f66696c65732f342f34392f353161623139373335646164322e6a7067223b733a353a227769647468223b693a3230343b733a363a22686569676874223b693a3132383b733a343a2268746d6c223b693a323b733a343a226d696d65223b733a31303a22696d6167652f6a706567223b7d')
INSERT INTO property_value VALUES (26, 4, 39, 'Blog')
CREATE TABLE `tab` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `description` VARCHAR(255), `sort_order` integer DEFAULT 0, `document_type_id` INT NOT NULL, PRIMARY KEY (`id`))
CREATE TABLE `core_config_data` ( `id` INT NOT NULL AUTO_INCREMENT, `identifier` VARCHAR(255) NOT NULL, `value` VARCHAR(255), PRIMARY KEY (`id`), UNIQUE KEY `name` (`identifier`))
INSERT INTO tab VALUES (11, 'Content', 'Content', 1, 4)
INSERT INTO tab VALUES (21, 'Featured', 'Featured content', 1, 6)
INSERT INTO tab VALUES (5, 'Title and meta', 'Meta description', 3, 1)
INSERT INTO tab VALUES (15, 'Title and meta', 'Meta description', 3, 6)
INSERT INTO property_value VALUES (8, 2, 11, '\x')
INSERT INTO property_value VALUES (44, 7, 29, '\x')
CREATE TABLE `property` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255), `identifier` VARCHAR(255) NOT NULL, `description` VARCHAR(255), `required` boolean NOT NULL DEFAULT false, `sort_order` integer DEFAULT 0, `tab_id` INT NOT NULL, `datatype_id` INT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`identifier`, `tab_id`))
INSERT INTO activity_log_template VALUES (8, 'Gc\Layout\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property VALUES (1, 'Meta description', 'metaDescription', 'Description', false, 11, 5, 1)
INSERT INTO property_value VALUES (55, 8, 31, 'Two Column #2')
INSERT INTO property_value VALUES (19, 1, 19, '\x3c703e0d0a0948544d4c35205550206973206120736d616c6c20736964652070726f6a65637420627920414a2028616b61206e33332920746f20707261637469636520776f726b696e6720776974682048544d4c3520616e6420726573706f6e736976652064657369676e20746563686e69717565732e20596f752063616e2066696e64206d6f726520636f6f6c2064657369676e73206174203c6120687265663d22687474703a2f2f68746d6c3575702e6e65742f223e68746d6c3575702e6e65743c2f613e206f7220666f6c6c6f77207573206f6e205477697474657220283c6120687265663d22687474703a2f2f747769747465722e636f6d2f6e3333636f223e406e3333636f3c2f613e2920666f72206e65772072656c6561736520616e6e6f756e63656d656e747320616e64206f7468657220636f6f6c2073747566662e3c2f703e0d0a')
INSERT INTO document VALUES (5, '2013-05-25 13:58:49.09857', '2013-05-27 08:53:50.482773', 'First category', 'first-category', 1, 0, true, false, NULL, 1, 5, 1, 1, 4)
CREATE TABLE `document_type_dependency` ( `id` INT NOT NULL AUTO_INCREMENT, `parent_id` INT NOT NULL, `children_id` INT NOT NULL, PRIMARY KEY (`id`))
INSERT INTO property_value VALUES (55, 8, 31, '\x54776f20436f6c756d6e202332')
CREATE TABLE `log_visitor` ( `id` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT, `session_id` CHAR(64) NOT NULL DEFAULT '', `http_user_agent` VARCHAR(255) DEFAULT NULL, `http_accept_CHARset` VARCHAR(255) DEFAULT NULL, `http_accept_language` VARCHAR(255) DEFAULT NULL, `server_addr` BIGINT(20) DEFAULT NULL, `remote_addr` BIGINT(20) DEFAULT NULL, PRIMARY KEY (`id`))
INSERT INTO tab VALUES (7, 'Title and meta', 'Meta description', NULL, 2)
INSERT INTO property_value VALUES (44, 7, 29, '')
CREATE TABLE `user_acl_resource` ( `id` INT NOT NULL AUTO_INCREMENT, `resource` VARCHAR(255), PRIMARY KEY (`id`))
INSERT INTO property_value VALUES (11, 3, 6, '\x436f6e74616374')
INSERT INTO property_value VALUES (5, 1, 4, 'My website')
INSERT INTO activity_log_template VALUES (9, 'Gc\\View\\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
SELECT id FROM user_acl_resource WHERE resource = '" . $key . "'
INSERT INTO property_value VALUES (38, 7, 32, 'Two Column #2 (left-hand sidebar)')
INSERT INTO document_type_dependency VALUES (8, 5, 4)
INSERT INTO activity_log_template VALUES (10, 'Gc\\Script\\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO tab VALUES (4, 'Content', 'Content', 1, 3)
INSERT INTO property VALUES (38, 'Main Title', 'mainTitle', 'Title', false, 4, 14, 1)
INSERT INTO view VALUES (11, '2013-05-24 19:02:58.584746', '2013-06-02 12:22:18.347423', 'Blog ticket', 'blog-ticket', 'Simple blog ticket')
INSERT INTO property_value VALUES (54, 8, 30, '\x54776f20436f6c756d6e202332')
INSERT INTO property VALUES (32, 'Title', 'title', '', false, 1, 11, 1)
INSERT INTO script VALUES (1, '2012-09-20 22:26:23', '2012-09-20 22:26:23', 'Contact', 'contact', 'Contact ')
INSERT INTO view VALUES (2, '2012-09-19 19:29:50', '2012-09-19 19:29:50', 'Blog', 'blog', 'Blog')
INSERT INTO property VALUES (29, 'Keywords', 'metaKeywords', 'Keywords', false, 7, 13, 1)
INSERT INTO property VALUES (36, 'Keywords', 'metaKeywords', 'Keywords', false, 2, 14, 1)
INSERT INTO document_type VALUES (3, '2012-09-20 22:06:37', '2012-10-08 21:02:07', 'About', 'About this website', 13, 4, 1)
INSERT INTO document VALUES (1, '2012-09-20 22:06:53', '2012-10-08 22:30:43', 'Home', '', 1, 0, true, true, NULL, 1, 1, 1, 1, NULL)
INSERT INTO property VALUES (39, 'Meta description', 'metaDescription', 'Description', false, 4, 15, 1)
INSERT INTO property VALUES (27, 'Image', 'image', '', false, 6, 12, 7)
CREATE TABLE `core_translate` ( `id` INT NOT NULL AUTO_INCREMENT, `source` TEXT NOT NULL, PRIMARY KEY (`id`))
INSERT INTO property VALUES (11, 'Keywords', 'metaKeywords', 'Keywords', false, 4, 8, 1)
INSERT INTO property_value VALUES (42, 7, 27, '\x623a303b')
INSERT INTO property_value VALUES (32, 5, 37, '\x46697273742063617465676f7279202d20426c6f67')
INSERT INTO document_type VALUES (2, '2012-09-20 22:05:53', '2013-06-02 11:29:45.535129', 'Contact', 'Contact form', 11, 3, 1)
INSERT INTO property VALUES (30, 'Title', 'pageTitle', 'Title', false, 8, 13, 1)
CREATE TABLE activity_log_template ( `id` INT NOT null AUTO_INCREMENT, /* The event id */ `event_identifier` VARCHAR(255) NOT NULL, /* The event identifier */ `event_name` VARCHAR(255) NOT NULL, /* The event name */ `template` TEXT NOT NULL, /* The template */ PRIMARY KEY (`id`))
INSERT INTO property_value VALUES (13, 3, 8, '\x436f6e74616374')
INSERT INTO tab VALUES (2, 'Content', 'Content', NULL, 1)
INSERT INTO document_type VALUES (6, '2013-05-24 08:57:15.489668', '2013-06-02 12:06:43.23561', 'Blog', 'Blog', 24, 1, 1)
INSERT INTO property_value VALUES (30, 5, 35, 'First category - Blog')
INSERT INTO property VALUES (46, 'Elements', 'sidebarElements', '', false, 11, 18, 8)
INSERT INTO property VALUES (12, 'Title', 'pageTitle', 'Title', false, 5, 8, 1)
CREATE TABLE `view` ( `id` INT NOT NULL AUTO_INCREMENT, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, `name` VARCHAR(255) NOT NULL, `identifier` VARCHAR(255), `description` VARCHAR(255), PRIMARY KEY (`id`), UNIQUE KEY `name` (`identifier`))
INSERT INTO activity_log_template VALUES (1, 'Gc\\User\\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (31, 5, 36, '\x')
INSERT INTO property_value VALUES (39, 7, 33, '\x323031332f30352f32352030323a33323a3137')
INSERT INTO tab VALUES (13, 'Title and meta', 'Meta description', 3, 4)
INSERT INTO view VALUES (4, '2012-09-19 19:33:51', '2013-06-02 12:22:18.425809', 'One column', 'one-column', 'One column page')
INSERT INTO property VALUES (3, 'Title', 'pageTitle', 'Title', false, 13, 5, 1)
INSERT INTO property VALUES (26, 'Short content', 'shortContent', '', false, 4, 12, 2)
INSERT INTO property VALUES (47, 'Elements', 'sidebarElements', '', false, 5, 19, 8)
INSERT INTO activity_log_template VALUES (3, 'Gc\\Datatype\\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (32, 5, 37, 'First category - Blog')
INSERT INTO property VALUES (15, 'Title', 'title', 'Title', false, 1, 4, 1)
INSERT INTO property VALUES (40, 'Keywords', 'metaKeywords', 'Keywords', false, 2, 15, 1)
INSERT INTO property VALUES (50, 'Content', 'content', '', false, 2, 21, 2)
CREATE TABLE `log_url_info` ( `id` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT, `url` VARCHAR(255) NOT NULL DEFAULT '', `referer` VARCHAR(255) DEFAULT NULL, PRIMARY KEY (`id`))
INSERT INTO view VALUES (8, '2013-05-22 19:29:56.943005', '2013-05-26 13:26:11.922496', 'Header', 'header', 'Header')
INSERT INTO property_value VALUES (3, 1, 2, '\x')
INSERT INTO property_value VALUES (29, 4, 42, '\x426c6f67')
INSERT INTO property VALUES (7, 'Keywords', 'metaKeywords', 'Keywords', false, NULL, 7, 1)
CREATE TABLE `icon` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `url` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`))
CREATE TABLE `activity_log_event` ( `id` INT NOT null AUTO_INCREMENT, /* The activity id */ `created_at` DATETIME NOT null, /* The time the activity occurred */ `content` TEXT, /* The content already generate */ `target_id` INT, /* The target id (document, user, model, etc) */ `template_id` INT NOT null, /* The template id */ `user_id` INT, /* The user id who trigger the event */ PRIMARY KEY (`id`))
INSERT INTO property_value VALUES (36, 6, 37, 'Second category - Blog')
INSERT INTO document VALUES (5, '2013-05-25 13:58:49.09857', '2013-05-26 13:31:50.957512', 'First category', 'first-category', 1, 0, true, false, NULL, 1, 5, 2, 1, 4)
INSERT INTO property VALUES (14, 'Slider', 'slider', 'Slider', false, NULL, 2, 5)
INSERT INTO property VALUES (21, 'First content', 'blockContent1', 'First block content', false, 4, 2, 2)
INSERT INTO tab VALUES (11, 'Content', 'Content', 2, 4)
INSERT INTO property VALUES (20, 'First title', 'blockTitle1', 'First block content', false, 3, 2, 1)
INSERT INTO property_value VALUES (47, 8, 32, '\x54776f20436f6c756d6e20233220286c6566742d68616e64207369646562617229')
INSERT INTO document VALUES (2, '2012-09-20 22:09:06', '2013-05-25 13:58:10.956633', 'About', 'about', 1, 2, true, true, NULL, 1, 3, 4, 1, NULL)
INSERT INTO tab VALUES (12, 'Relay', 'Relay', 3, 4)
INSERT INTO property VALUES (2, 'Keywords', 'metaKeywords', 'Keywords', false, NULL, 5, 1)
INSERT INTO property_value VALUES (48, 8, 33, '2013/05/25 02:33:09')
INSERT INTO tab VALUES (2, 'Four blocks', 'four blocks title and content', 2, 1)
INSERT INTO layout VALUES (1, '2012-09-19 19:28:34', '2012-09-20 22:31:50', 'Main', 'main-layout', 'Main layout')
INSERT INTO property VALUES (22, 'Second content', 'blockContent2', 'Second block content', false, 6, 2, 2)
CREATE TABLE `document_type` ( `id` INT NOT NULL AUTO_INCREMENT, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, `name` VARCHAR(255) NOT NULL, `description` TEXT, `icon_id` integer, `default_view_id` integer, `user_id` INT NOT NULL, PRIMARY KEY (`id`))
CREATE TABLE `user_acl_permission` ( `id` INT NOT NULL AUTO_INCREMENT, `permission` VARCHAR(255) NOT NULL, `user_acl_resource_id` INT NOT NULL, PRIMARY KEY (`id`))
INSERT INTO view VALUES (7, '2013-05-20 15:52:38.647561', '2013-06-02 12:22:18.442743', 'Paginator', 'paginator', 'Paginator control')
INSERT INTO property_value VALUES (2, 1, 1, 'My website')
INSERT INTO tab VALUES (13, 'Title and meta', 'Meta description', 4, 4)
CREATE TABLE `datatype` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `prevalue_value` TEXT, `model` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`))
INSERT INTO property_value VALUES (18, 1, 18, 'About HTML5 UP')
INSERT INTO activity_log_template VALUES (12, 'Gc\Script\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (13, 3, 8, 'Contact')
INSERT INTO property_value VALUES (23, 1, 23, '\x3c703e0d0a093c7374726f6e673e417263616e613c2f7374726f6e673e2069732072656c656173656420666f72206672656520756e64657220746865203c6120687265663d22687474703a2f2f68746d6c3575702e6e65742f6c6963656e7365223e437265617469766520436f6d6d6f6e73204174747269627574696f6e20332e30206c6963656e73653c2f613e2c207768696368206d65616e7320796f752063616e2075736520697420666f7220707265747479206d75636820616e7920706572736f6e616c206f7220636f6d6d65726369616c207573652e205468652063617463683f204a75737420676976652075732063726564697420776865726576657220796f752075736520697420286f682c20616e642074656c6c20796f757220667269656e64732061626f75742075732c2074686f7567682074686174262333393b73206e6f7420696e20746865206c6963656e7365203a293c2f703e0d0a')
INSERT INTO property_value VALUES (29, 4, 42, 'Blog')
INSERT INTO property VALUES (11, 'Keywords', 'metaKeywords', 'Keywords', false, NULL, 8, 1)
INSERT INTO property_value VALUES (25, 1, 25, 'Arcana: A responsive HTML5 site template by HTML5 UP')
INSERT INTO tab VALUES (8, 'Title and meta', 'Meta description', 3, 3)
INSERT INTO property_value VALUES (15, 2, 15, 'About')
INSERT INTO property VALUES (16, 'Second title', 'blockTitle2', 'Second block title', false, 5, 2, 1)
INSERT INTO property_value VALUES (56, 4, 44, '\x613a313a7b693a303b613a323a7b693a303b613a313a7b733a353a2276616c7565223b733a31363a2241626f75742053696c766572426c6f67223b7d693a313b613a313a7b733a353a2276616c7565223b733a3231313a223c703e0d0a0953696c766572426c6f6720697320612066726565204353532054656d706c6174652072656c656173656420756e64657220474e552047504c206c6963656e73652e20596f7520617265206672656520746f20757365202f206d6f6469667920697420696e20616e792077617920796f752077616e7420776974686f757420616e79207265737472696374696f6e732e2041206c696e6b206261636b20746f207468697320776562736974652077696c6c20616c776179732062652061707072656369617465642e3c2f703e0d0a223b7d7d7d')
INSERT INTO script VALUES (1, '2012-09-20 22:26:23', '2012-09-20 22:26:23', 'Contact', 'contact', 'Contact')
INSERT INTO view VALUES (1, '2012-09-19 19:29:04', '2013-06-02 12:22:18.410393', 'Home page', 'home', 'Home page content')
INSERT INTO activity_log_template VALUES (6, 'Gc\DocumentType\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property VALUES (12, 'Title', 'pageTitle', 'Title', false, NULL, 8, 1)
INSERT INTO property_value VALUES (48, 8, 33, '\x323031332f30352f32352030323a33333a3039')
INSERT INTO property VALUES (41, 'Title', 'pageTitle', 'Title', false, 6, 15, 1)
INSERT INTO property_value VALUES (43, 7, 28, '\x54776f20436f6c756d6e202332')
INSERT INTO tab VALUES (17, 'Sidebar', 'Sidebar text', 1, 5)
INSERT INTO property_value VALUES (39, 7, 33, '2013/05/25 02:32:17')
INSERT INTO document_type VALUES (5, '2013-05-24 08:56:17.202506', '2013-06-02 11:28:48.731862', 'Blog category', 'Blog category', 8, 1, 1)
INSERT INTO property_value VALUES (8, 2, 11, '')
INSERT INTO activity_log_template VALUES (9, 'Gc\View\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (59, 4, 50, '\x3c68333e0d0a09466561747572656420436f6e74656e743c2f68333e0d0a3c703e0d0a094c6f72656d61207073756d20646f6c6f722073697420616d65742c20636f6e73656374657475722061646970697363696e6720656c69742e20496e7465676572206567657374617320707572757320626962656e64756d206e6571756520616c697175616d20757420706f737565726520656c69742073656d7065722e2046757363652073616769747469732070686172657472612065726f732c2073697420616d657420636f6e7365717561742073656d206d6f6c6c69732076697461652e3c2f703e0d0a')
INSERT INTO activity_log_template VALUES (4, 'Gc\\Document\\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
CREATE TABLE `core_translate_locale` ( `id` INT NOT NULL AUTO_INCREMENT, `destination` TEXT NOT NULL, `locale` VARCHAR(255) NOT NULL, `core_translate_id` INT NOT NULL, PRIMARY KEY (`id`))
INSERT INTO view VALUES (1, '2012-09-19 19:29:04', '2012-10-08 22:42:57', 'Home page', 'home', 'Home page content')
INSERT INTO tab VALUES (19, 'Sidebar', 'Sidebar text', 2, 2)
INSERT INTO property VALUES (41, 'Title', 'pageTitle', 'Title', false, 3, 15, 1)
INSERT INTO view VALUES (4, '2012-09-19 19:33:51', '2013-05-26 13:26:11.955889', 'One column', 'one-column', 'One column page')
INSERT INTO property VALUES (30, 'Title', 'pageTitle', 'Title', false, 9, 13, 1)
INSERT INTO document VALUES (4, '2013-05-25 13:57:47.516331', '2013-06-02 12:07:47.590756', 'Home', '', 1, 1, true, true, NULL, 1, 6, 1, 1, NULL)
INSERT INTO property_value VALUES (35, 6, 36, '\x')
CREATE TABLE `user` ( `id` INT NOT NULL AUTO_INCREMENT, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, `lastname` VARCHAR(255) NOT NULL, `firstname` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `login` VARCHAR(255) NOT NULL, `password` VARCHAR(255) NOT NULL, `retrieve_password_key` VARCHAR(40) DEFAULT NULL, `retrieve_updated_at` DATETIME DEFAULT NULL, `active` BOOLEAN DEFAULT true, `user_acl_role_id` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `name` (`email`))
INSERT INTO view VALUES (5, '2012-09-20 22:12:33', '2012-09-20 22:21:24', 'Navigation', 'navigation', 'Navigation')
INSERT INTO property_value VALUES (12, 3, 7, '\x436f6e74616374')
INSERT INTO document_type VALUES (6, '2013-05-24 08:57:15.489668', '2013-05-24 19:01:16.968222', 'Blog', 'Blog', 24, 2, 1)
INSERT INTO document_type VALUES (2, '2012-09-20 22:05:53', '2012-10-08 20:44:24', 'Contact', 'Contact form', 11, 3, 1)
INSERT INTO property VALUES (42, 'Main Title', 'mainTitle', 'Title', false, 4, 15, 1)
INSERT INTO property VALUES (45, 'Elements', 'sidebarElements', '', false, 5, 17, 8)
INSERT INTO property VALUES (31, 'Main Title', 'mainTitle', 'Title', false, 9, 13, 1)
SELECT USERNAME FROM ALL_USERS';
INSERT INTO view VALUES (9, '2013-05-22 19:32:25.295636', '2013-05-26 13:26:11.910965', 'Footer', 'footer', 'Footer navigation')
INSERT INTO document_type VALUES (3, '2012-09-20 22:06:37', '2013-05-22 21:08:15.543148', 'About', 'About this website', 13, 4, 1)
INSERT INTO activity_log_template VALUES (6, 'Gc\\DocumentType\\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
CREATE TABLE `core_session` ( `id` VARCHAR(255) NOT NULL, `name` VARCHAR(50) NOT NULL, `updated_at` INT NOT NULL, `lifetime` INT NOT NULL, `data` TEXT, PRIMARY KEY (`id`))
CREATE TABLE `document_type_view` ( `id` INT NOT NULL AUTO_INCREMENT, `view_id` INT NOT NULL, `document_type_id` INT NOT NULL, PRIMARY KEY (`id`))
INSERT INTO document_type VALUES (1, '2012-09-20 22:01:55', '2013-05-26 13:29:33.312101', 'Home', 'Home page', 1, 1, 1)
INSERT INTO property VALUES (29, 'Keywords', 'metaKeywords', 'Keywords', false, 8, 13, 1)
INSERT INTO property VALUES (10, 'Meta description', 'metaDescription', 'Description', false, NULL, 8, 1)
INSERT INTO property VALUES (37, 'Title', 'pageTitle', 'Title', false, 3, 14, 1)
INSERT INTO property_value VALUES (24, 1, 24, '\x613a353a7b733a353a2276616c7565223b733a33353a222f6d656469612f66696c65732f312f32342f353139646262336162666464382e6a7067223b733a353a227769647468223b693a313230303b733a363a22686569676874223b693a3236353b733a343a2268746d6c223b693a323b733a343a226d696d65223b733a31303a22696d6167652f6a706567223b7d')
INSERT INTO property_value VALUES (15, 2, 15, '\x41626f7574')
INSERT INTO document_type VALUES (1, '2012-09-20 22:01:55', '2012-10-08 21:01:06', 'Home', 'Home page', 1, 1, 1)
INSERT INTO property VALUES (48, 'Elements', 'sidebarElements', '', false, 7, 20, 8)
INSERT INTO property VALUES (23, 'Third content', 'blockContent3', 'Third block content', false, 8, 2, 2)
INSERT INTO property_value VALUES (50, 8, 26, '<p> Suspendisse faucibus dictum tellus id posuere. Cras quis eros tellus, id posuere lacus. Praesent ac est eros. Aliquam eleifend nunc ut neque consequat quis suscipit elit tincidunt. Fusce interdum gravida tincidunt. Sed et ante nec ligula fringilla condimentum. Mauris vel sem ac ligula sed lorem vestibulum ornare vel sed nibh. Fusce rhoncus tincidunt ante, non hendrerit magna vestibulum quis. Integer vel enim sem phasellus tempus lorem.</p>')
INSERT INTO property_value VALUES (51, 8, 27, '\x623a303b')
INSERT INTO property_value VALUES (2, 1, 1, '\x4d792077656273697465')
SELECT id FROM user_acl_permission WHERE user_acl_resource_id = 4);
INSERT INTO property_value VALUES (35, 6, 36, '')
INSERT INTO document VALUES (2, '2012-09-20 22:09:06', '2013-06-02 12:00:33.863005', 'About', 'about', 1, 2, true, true, NULL, 1, 3, 4, 1, NULL)
INSERT INTO view VALUES (11, '2013-05-24 19:02:58.584746', '2013-05-26 13:26:11.869185', 'Blog ticket', 'blog-ticket', 'Simple blog ticket')
INSERT INTO property VALUES (8, 'Title', 'pageTitle', 'Title', false, NULL, 7, 1)
INSERT INTO property_value VALUES (54, 8, 30, 'Two Column #2')
INSERT INTO activity_log_template VALUES (13, 'Gc\\Layout\\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO layout VALUES (1, '2012-09-19 19:28:34', '2013-06-02 12:26:50.037182', 'Main', 'main', 'Main layout')
INSERT INTO property_value VALUES (33, 5, 38, '\x46697273742063617465676f7279202d20426c6f67')
INSERT INTO property_value VALUES (34, 6, 35, '\x5365636f6e642063617465676f7279202d20426c6f67')
INSERT INTO property VALUES (13, 'Main Title', 'mainTitle', 'Title', false, NULL, 8, 1)
INSERT INTO view VALUES (6, '2012-10-25 19:57:05', '2013-05-26 13:26:11.897632', 'Flash messages', 'flash-messages', 'Flash messages displayer')
INSERT INTO property VALUES (34, 'Content', 'content', '', false, 3, 11, 2)
INSERT INTO activity_log_template VALUES (1, 'Gc\User\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property VALUES (9, 'Main Title', 'mainTitle', 'Title', false, NULL, 7, 1)
INSERT INTO property VALUES (24, 'Banner', 'banner', 'Banner', false, 2, 9, 4)
INSERT INTO property VALUES (28, 'Meta description', 'metaDescription', 'Description', false, 7, 13, 1)
INSERT INTO property_value VALUES (4, 1, 3, 'My website')
INSERT INTO document VALUES (3, '2012-09-20 22:09:29', '2013-05-25 13:58:10.973436', 'Contact', 'contact', 1, 3, true, false, NULL, 1, 2, 3, 1, NULL)
SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER=:OWNER')->execute($bind);
INSERT INTO property VALUES (13, 'Main Title', 'mainTitle', 'Title', false, 6, 8, 1)
INSERT INTO activity_log_template VALUES (4, 'Gc\Document\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO activity_log_template VALUES (7, 'Gc\\DocumentType\\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO tab VALUES (5, 'Title and meta', 'Meta description', NULL, 1)
INSERT INTO view VALUES (3, '2012-09-19 19:32:56', '2013-06-02 12:22:18.37399', 'Contact', 'contact', 'Contact form')
INSERT INTO property_value VALUES (38, 7, 32, '\x54776f20436f6c756d6e20233220286c6566742d68616e64207369646562617229')
INSERT INTO property_value VALUES (30, 5, 35, '\x46697273742063617465676f7279202d20426c6f67')
INSERT INTO view VALUES (7, '2013-05-20 15:52:38.647561', '2013-05-26 13:26:11.972645', 'Paginator', 'paginator', 'Paginator control')
INSERT INTO property VALUES (17, 'Third title', 'blockTitle3', 'Third block title', false, 7, 2, 1)
INSERT INTO property_value VALUES (20, 1, 20, '\x57656c636f6d6520746f20417263616e61')
INSERT INTO view VALUES (4, '2012-09-19 19:33:51', '2012-10-08 22:32:28', 'About', 'about', 'About page')
INSERT INTO tab VALUES (16, 'Sidebar', 'Sidebar text', 2, 6)
INSERT INTO property_value VALUES (25, 1, 25, '\x417263616e613a204120726573706f6e736976652048544d4c3520736974652074656d706c6174652062792048544d4c35205550')
INSERT INTO tab VALUES (12, 'Relay', 'Relay', 2, 4)
INSERT INTO property_value VALUES (36, 6, 37, '\x5365636f6e642063617465676f7279202d20426c6f67')
CREATE TABLE `user_acl_role` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255), `description` VARCHAR(255), PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`))
INSERT INTO property_value VALUES (59, 4, 50, '<h3> Featured Content</h3><p> Lorema psum dolor sit amet, consectetur adipiscing elit. Integer egestas purus bibendum neque aliquam ut posuere elit semper. Fusce sagittis pharetra eros, sit amet consequat sem mollis vitae.</p>')
INSERT INTO property_value VALUES (27, 4, 40, '\x')
INSERT INTO property VALUES (34, 'Content', 'content', '', false, 4, 11, 2)
INSERT INTO property VALUES (42, 'Main Title', 'mainTitle', 'Title', false, 7, 15, 1)
INSERT INTO property_value VALUES (22, 1, 22, '\x3c703e0d0a095975702e205468697320736974652074656d706c6174652069732066756c6c7920726573706f6e736976652c206d65616e696e67206974262333393b6c6c206c6f6f6b206772656174206f6e206465736b746f7020287769646573637265656e20616e64207374616e64617264292c207461626c657420616e64206d6f62696c652064657669636520646973706c6179732e2054727920697420666f7220796f757273656c663a2073696d706c7920726573697a6520796f75722062726f777365722077696e646f7720746f2073656520686f77207374756666207368696674732061726f756e6420616e64206368616e6765732e3c2f703e0d0a')
INSERT INTO property VALUES (6, 'Meta description', 'metaDescription', 'Description', false, 1, 7, 1)
CREATE TABLE `blog_comment` ( `id` INT NOT null AUTO_INCREMENT, `created_at` DATETIME NOT null, `username` VARCHAR(255) NOT null, `email` VARCHAR(255) NOT null, `show_email` SMALLINT NOT null DEFAULT 0, `is_active` SMALLINT NOT null DEFAULT 0, `message` TEXT, `document_id` INT, PRIMARY KEY (`id`))
INSERT INTO document_type VALUES (3, '2012-09-20 22:06:37', '2013-06-02 11:58:48.587983', 'About', 'About this website', 13, 4, 1)
INSERT INTO property_value VALUES (57, 2, 48, '\x4e3b')
INSERT INTO document VALUES (2, '2012-09-20 22:09:06', '2012-10-08 22:30:55', 'About', 'about', 1, 1, true, true, NULL, 1, 3, 4, 1, NULL)
INSERT INTO property_value VALUES (28, 4, 41, 'Blog')
INSERT INTO property_value VALUES (26, 4, 39, '\x426c6f67')
INSERT INTO tab VALUES (8, 'Title and meta', 'Meta description', 2, 3)
SELECT something FROM core_config_data');
INSERT INTO property VALUES (33, 'Publication date', 'published_at', '', false, 3, 11, 6)
INSERT INTO property_value VALUES (28, 4, 41, '\x426c6f67')
INSERT INTO property VALUES (26, 'Short content', 'shortContent', '', false, 5, 12, 2)
INSERT INTO property VALUES (40, 'Keywords', 'metaKeywords', 'Keywords', false, 5, 15, 1)
INSERT INTO view VALUES (12, '2013-05-27 08:55:24.70931', '2013-06-02 12:22:18.464786', 'Sidebar', 'sidebar', 'Sidebar')
INSERT INTO activity_log_template VALUES (14, 'Gc\User\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO activity_log_template VALUES (11, 'Gc\\View\\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO tab VALUES (14, 'Title and meta', 'Meta description', 1, 5)
INSERT INTO document VALUES (6, '2013-05-25 13:59:05.99698', '2013-05-27 08:53:53.785471', 'Second category', 'second-category', 1, 0, true, false, NULL, 1, 5, 1, 1, 4)
INSERT INTO property_value VALUES (20, 1, 20, 'Welcome to Arcana')
CREATE TABLE `log_url` ( `id` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT, `visit_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `log_url_info_id` BIGINT(20) unsigned, `log_visitor_id` BIGINT(20) unsigned, PRIMARY KEY (`id`))
INSERT INTO property_value VALUES (41, 7, 26, '<p> Suspendisse faucibus dictum tellus id posuere. Cras quis eros tellus, id posuere lacus. Praesent ac est eros. Aliquam eleifend nunc ut neque consequat quis suscipit elit tincidunt. Fusce interdum gravida tincidunt. Sed et ante nec ligula fringilla condimentum. Mauris vel sem ac ligula sed lorem vestibulum ornare vel sed nibh. Fusce rhoncus tincidunt ante, non hendrerit magna vestibulum quis. Integer vel enim sem phasellus tempus lorem.</p>')
INSERT INTO document VALUES (6, '2013-05-25 13:59:05.99698', '2013-05-26 13:32:01.369958', 'Second category', 'second-category', 1, 0, true, false, NULL, 1, 5, 2, 1, 4)
INSERT INTO property VALUES (9, 'Main Title', 'mainTitle', 'Title', false, 4, 7, 1)
INSERT INTO activity_log_template VALUES (5, 'Gc\\Document\\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO tab VALUES (14, 'Title and meta', 'Meta description', 2, 5)
INSERT INTO property_value VALUES (18, 1, 18, '\x41626f75742048544d4c35205550')
INSERT INTO layout VALUES (1, '2012-09-19 19:28:34', '2013-05-24 08:24:49.350913', 'Main', 'main', 'Main layout')
INSERT INTO activity_log_template VALUES (13, 'Gc\Layout\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO document_type_dependency VALUES (2, 6, 5)
INSERT INTO activity_log_template VALUES (3, 'Gc\Datatype\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (37, 6, 38, 'Second category - Blog')
INSERT INTO property VALUES (8, 'Title', 'pageTitle', 'Title', false, 3, 7, 1)
INSERT INTO document_type VALUES (5, '2013-05-24 08:56:17.202506', '2013-05-25 14:13:02.199039', 'Blog category', 'Blog category', 8, 2, 1)
INSERT INTO property VALUES (25, 'Title', 'bannerTitle', 'Banner title', false, 1, 9, 1)
INSERT INTO property VALUES (19, 'Fourth content', 'blockContent4', 'Fourth block content', false, 10, 2, 2)
INSERT INTO property_value VALUES (9, 2, 12, '\x41626f7574')
INSERT INTO tab VALUES (7, 'Title and meta', 'Meta description', 1, 2)
INSERT INTO property_value VALUES (31, 5, 36, '')
INSERT INTO activity_log_template VALUES (10, 'Gc\Script\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property VALUES (18, 'Fourth title', 'blockTitle4', 'Fourth block title', false, 9, 2, 1)
INSERT INTO activity_log_template VALUES (12, 'Gc\\Script\\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (45, 7, 30, 'Two Column #2')
INSERT INTO property VALUES (28, 'Meta description', 'metaDescription', 'Description', false, 6, 13, 1)
INSERT INTO property_value VALUES (34, 6, 35, 'Second category - Blog')
INSERT INTO property VALUES (43, 'Author name', 'authorName', '', false, 2, 11, 1)
INSERT INTO tab VALUES (20, 'Sidebar', 'Sidebar text', 2, 3)
INSERT INTO property VALUES (31, 'Main Title', 'mainTitle', 'Title', false, 10, 13, 1)
INSERT INTO view VALUES (3, '2012-09-19 19:32:56', '2012-09-20 22:27:02', 'Contact', 'contact', 'Contact form')
INSERT INTO property VALUES (10, 'Meta description', 'metaDescription', 'Description', false, 3, 8, 1)
INSERT INTO activity_log_template VALUES (11, 'Gc\View\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property VALUES (39, 'Meta description', 'metaDescription', 'Description', false, 1, 15, 1)
INSERT INTO property_value VALUES (50, 8, 26, '\x3c703e0d0a0953757370656e64697373652066617563696275732064696374756d2074656c6c757320696420706f73756572652e204372617320717569732065726f732074656c6c75732c20696420706f7375657265206c616375732e205072616573656e74206163206573742065726f732e20416c697175616d20656c656966656e64206e756e63207574206e6571756520636f6e736571756174207175697320737573636970697420656c69742074696e636964756e742e20467573636520696e74657264756d20677261766964612074696e636964756e742e2053656420657420616e7465206e6563206c6967756c61206672696e67696c6c6120636f6e64696d656e74756d2e204d61757269732076656c2073656d206163206c6967756c6120736564206c6f72656d20766573746962756c756d206f726e6172652076656c20736564206e6962682e2046757363652072686f6e6375732074696e636964756e7420616e74652c206e6f6e2068656e647265726974206d61676e6120766573746962756c756d20717569732e20496e74656765722076656c20656e696d2073656d2070686173656c6c75732074656d707573206c6f72656d2e3c2f703e0d0a')
INSERT INTO property VALUES (5, 'Content', 'content', 'content', false, NULL, 4, 2)
INSERT INTO activity_log_template VALUES (14, 'Gc\\User\\Model', 'after.delete', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (9, 2, 12, 'About')
INSERT INTO property VALUES (3, 'Title', 'pageTitle', 'Title', false, NULL, 5, 1)
INSERT INTO activity_log_template VALUES (2, 'Gc\\Datatype\\Model', 'after.save', '<?= $this->escapeHtml($this->event->getParam(''user'')
INSERT INTO property_value VALUES (7, 2, 10, 'About')
INSERT INTO property VALUES (35, 'Meta description', 'metaDescription', 'Description', false, 1, 14, 1)
INSERT INTO property VALUES (49, 'Image', 'image', '', false, 1, 21, 9)
INSERT INTO property_value VALUES (3, 1, 2, '')
INSERT INTO view VALUES (1, '2012-09-19 19:29:04', '2013-05-26 13:26:11.939612', 'Home page', 'home', 'Home page content')
INSERT INTO property_value VALUES (16, 1, 16, '\x526573706f6e736976653f205265616c6c793f')
INSERT INTO property VALUES (5, 'Content', 'content', 'content', false, 2, 4, 2)
INSERT INTO property_value VALUES (43, 7, 28, 'Two Column #2')
INSERT INTO property VALUES (44, 'Elements', 'sidebarElements', '', false, 3, 16, 8)
INSERT INTO property_value VALUES (33, 5, 38, 'First category - Blog')
INSERT INTO property_value VALUES (12, 3, 7, 'Contact')