· 8 years ago · May 11, 2018, 06:04 AM
1--
2-- Table structure for table `_admin_module`
3--
4DROP TABLE IF EXISTS _admin_module;
5CREATE TABLE IF NOT EXISTS _admin_module (
6 id serial NOT NULL,
7 name varchar(100) DEFAULT NULL,
8 title varchar(255) DEFAULT NULL,
9 description text,
10 orderer float DEFAULT '0',
11 active BOOLEAN DEFAULT TRUE,
12 enabled BOOLEAN DEFAULT TRUE,
13 time double precision DEFAULT extract(epoch from now()),
14 timee double precision DEFAULT extract(epoch from now())
15)
16WITH (
17 OIDS=FALSE
18);
19
20
21
22
23--
24-- Table structure for table `_admin_module_r`
25--
26DROP TABLE IF EXISTS _admin_module_r;
27CREATE TABLE _admin_module_r (
28 id serial NOT NULL,
29 title varchar(255) DEFAULT NULL,
30 description text,
31 orderer float DEFAULT '0',
32 active BOOLEAN DEFAULT TRUE,
33 enabled BOOLEAN DEFAULT TRUE,
34 time double precision DEFAULT extract(epoch from now()),
35 timee double precision DEFAULT extract(epoch from now())
36)
37WITH (
38 OIDS=FALSE
39);
40
41
42
43
44--
45-- Table structure for table `_admin_module_widget`
46--
47DROP TABLE IF EXISTS _admin_module_widget;
48CREATE TABLE _admin_module_widget (
49 id serial NOT NULL,
50 module_id int DEFAULT NULL,
51 orderer float DEFAULT '0',
52 active BOOLEAN DEFAULT TRUE,
53 enabled BOOLEAN DEFAULT TRUE,
54 time double precision DEFAULT extract(epoch from now()),
55 timee double precision DEFAULT extract(epoch from now())
56)
57WITH (
58 OIDS=FALSE
59);
60
61
62
63
64--
65-- Table structure for table `_app`
66--
67DROP TABLE IF EXISTS _app;
68CREATE TABLE _app (
69 id serial NOT NULL,
70 key varchar(30) DEFAULT NULL,
71 lang varchar(3) DEFAULT NULL,
72 name varchar(100) DEFAULT NULL,
73 title varchar(255) DEFAULT NULL,
74 description text,
75 orderer float DEFAULT '0',
76 active BOOLEAN DEFAULT TRUE,
77 enabled BOOLEAN DEFAULT TRUE,
78 time double precision DEFAULT extract(epoch from now()),
79 timee double precision DEFAULT extract(epoch from now())
80)
81WITH (
82 OIDS=FALSE
83);
84
85
86
87
88--
89-- Table structure for table `_collection`
90--
91DROP TABLE IF EXISTS _collection;
92CREATE TABLE _collection (
93 id serial NOT NULL,
94 key varchar(30) DEFAULT NULL,
95 lang varchar(3) DEFAULT NULL,
96 name varchar(100) DEFAULT NULL,
97 title varchar(255) DEFAULT NULL,
98 description text,
99 orderer float DEFAULT '0',
100 active BOOLEAN DEFAULT TRUE,
101 enabled BOOLEAN DEFAULT TRUE,
102 time double precision DEFAULT extract(epoch from now()),
103 timee double precision DEFAULT extract(epoch from now())
104)
105WITH (
106 OIDS=FALSE
107);
108
109
110
111
112--
113-- Table structure for table `_controller`
114--
115DROP TABLE IF EXISTS _controller;
116CREATE TABLE _controller (
117 id serial NOT NULL,
118 key varchar(30) DEFAULT NULL,
119 lang varchar(3) DEFAULT NULL,
120 name varchar(100) DEFAULT NULL,
121 title varchar(255) DEFAULT NULL,
122 description text,
123 orderer float DEFAULT '0',
124 active BOOLEAN DEFAULT TRUE,
125 enabled BOOLEAN DEFAULT TRUE,
126 time double precision DEFAULT extract(epoch from now()),
127 timee double precision DEFAULT extract(epoch from now())
128)
129WITH (
130 OIDS=FALSE
131);
132
133
134
135
136--
137-- Table structure for table `_email`
138--
139DROP TABLE IF EXISTS _email;
140CREATE TABLE _email (
141 id serial NOT NULL,
142 key varchar(30) DEFAULT NULL,
143 lang varchar(3) DEFAULT NULL,
144 name varchar(100) DEFAULT NULL,
145 subject text,
146 text text,
147 sender_id int DEFAULT '0',
148 orderer float DEFAULT '0',
149 active BOOLEAN DEFAULT TRUE,
150 enabled BOOLEAN DEFAULT TRUE,
151 time double precision DEFAULT extract(epoch from now()),
152 timee double precision DEFAULT extract(epoch from now())
153)
154WITH (
155 OIDS=FALSE
156);
157
158
159
160
161--
162-- Table structure for table `_email_log`
163--
164DROP TABLE IF EXISTS _email_log;
165CREATE TABLE _email_log (
166 id serial NOT NULL,
167 to_ varchar(255) DEFAULT NULL,
168 email_id int DEFAULT NULL,
169 data text,
170 orderer float DEFAULT '0',
171 active BOOLEAN DEFAULT TRUE,
172 enabled BOOLEAN DEFAULT TRUE,
173 time double precision DEFAULT extract(epoch from now()),
174 timee double precision DEFAULT extract(epoch from now())
175)
176WITH (
177 OIDS=FALSE
178);
179
180
181--
182-- Table structure for table `_email_sender`
183--
184DROP TABLE IF EXISTS _email_sender;
185CREATE TABLE _email_sender (
186 id serial NOT NULL,
187 name varchar(100) DEFAULT NULL,
188 server varchar(100) DEFAULT NULL,
189 port varchar(10) DEFAULT NULL,
190 username varchar(100) DEFAULT NULL,
191 password varchar(100) DEFAULT NULL,
192 orderer float DEFAULT '0',
193 active BOOLEAN DEFAULT TRUE,
194 enabled BOOLEAN DEFAULT TRUE,
195 time double precision DEFAULT extract(epoch from now()),
196 timee double precision DEFAULT extract(epoch from now())
197)
198WITH (
199 OIDS=FALSE
200);
201
202
203
204--
205-- Table structure for table `_lang`
206--
207DROP TABLE IF EXISTS _lang;
208CREATE TABLE _lang (
209 id serial NOT NULL,
210 key varchar(30) DEFAULT NULL,
211 lang varchar(3) DEFAULT NULL,
212 name varchar(3) DEFAULT NULL,
213 title_int varchar(100) DEFAULT NULL,
214 title varchar(100) DEFAULT NULL,
215 orderer float DEFAULT '0',
216 active BOOLEAN DEFAULT TRUE,
217 enabled BOOLEAN DEFAULT TRUE,
218 time double precision DEFAULT extract(epoch from now()),
219 timee double precision DEFAULT extract(epoch from now())
220)
221WITH (
222 OIDS=FALSE
223);
224
225
226
227
228--
229-- Table structure for table `_log`
230--
231DROP TYPE IF EXISTS log_type;
232CREATE TYPE log_type AS ENUM ('db','php','fatal','core','user');
233
234DROP TABLE IF EXISTS _log;
235CREATE TABLE _log (
236 id serial NOT NULL,
237 time double precision DEFAULT extract(epoch from now()),
238 type log_type DEFAULT NULL,
239 eid varchar(10) DEFAULT NULL,
240 title text,
241 text text,
242 file text,
243 line int NOT NULL
244)
245WITH (
246 OIDS=FALSE
247);
248
249
250
251
252--
253-- Table structure for table `_menu`
254--
255DROP TABLE IF EXISTS _menu;
256CREATE TABLE _menu (
257 id serial NOT NULL,
258 name varchar(100) DEFAULT NULL,
259 title varchar(255) DEFAULT NULL,
260 orderer float DEFAULT '0',
261 active BOOLEAN DEFAULT TRUE,
262 enabled BOOLEAN DEFAULT TRUE,
263 time double precision DEFAULT extract(epoch from now()),
264 timee double precision DEFAULT extract(epoch from now())
265)
266WITH (
267 OIDS=FALSE
268);
269
270
271
272
273--
274-- Table structure for table `_menu_item`
275--
276DROP TABLE IF EXISTS _menu_item;
277CREATE TABLE _menu_item (
278 id serial NOT NULL,
279 menu_id int DEFAULT NULL,
280 node_id int DEFAULT NULL,
281 uri text,
282 title varchar(255) DEFAULT NULL,
283 orderer float DEFAULT '0',
284 active BOOLEAN DEFAULT TRUE,
285 enabled BOOLEAN DEFAULT TRUE,
286 time double precision DEFAULT extract(epoch from now()),
287 timee double precision DEFAULT extract(epoch from now())
288)
289WITH (
290 OIDS=FALSE
291);
292
293
294
295
296--
297-- Table structure for table `_module`
298--
299DROP TABLE IF EXISTS _module;
300CREATE TABLE _module (
301 id serial NOT NULL,
302 key varchar(30) DEFAULT NULL,
303 lang varchar(3) DEFAULT NULL,
304 name varchar(100) DEFAULT NULL,
305 title varchar(255) DEFAULT NULL,
306 description text,
307 orderer float DEFAULT '0',
308 active BOOLEAN DEFAULT TRUE,
309 enabled BOOLEAN DEFAULT TRUE,
310 time double precision DEFAULT extract(epoch from now()),
311 timee double precision DEFAULT extract(epoch from now())
312)
313WITH (
314 OIDS=FALSE
315);
316
317
318
319
320--
321-- Table structure for table `_node`
322--
323DROP TABLE IF EXISTS _node;
324CREATE TABLE _node (
325 id serial NOT NULL,
326 app int DEFAULT '0',
327 key varchar(30) DEFAULT NULL,
328 lang varchar(3) DEFAULT NULL,
329 pid int DEFAULT '0',
330 level int DEFAULT '0',
331 lft int DEFAULT '0',
332 rgt int DEFAULT '0',
333 path text,
334 name varchar(255) DEFAULT NULL,
335 title varchar(255) DEFAULT NULL,
336 controller_id int DEFAULT '0',
337 module_id int DEFAULT '0',
338 slot text,
339 has_child BOOLEAN DEFAULT TRUE,
340 priv text,
341 orderer float DEFAULT '0',
342 active BOOLEAN DEFAULT TRUE,
343 enabled BOOLEAN DEFAULT TRUE,
344 time double precision DEFAULT extract(epoch from now()),
345 timee double precision DEFAULT extract(epoch from now())
346)
347WITH (
348 OIDS=FALSE
349);
350
351
352
353
354--
355-- Table structure for table `_slot`
356--
357DROP TABLE IF EXISTS _slot;
358CREATE TABLE _slot (
359 id serial NOT NULL,
360 key varchar(30) DEFAULT NULL,
361 lang varchar(3) DEFAULT NULL,
362 orderer float DEFAULT '0',
363 active BOOLEAN DEFAULT TRUE,
364 enabled BOOLEAN DEFAULT TRUE,
365 time double precision DEFAULT extract(epoch from now()),
366 timee double precision DEFAULT extract(epoch from now())
367)
368WITH (
369 OIDS=FALSE
370);
371
372
373
374
375--
376-- Table structure for table `_user`
377--
378DROP TABLE IF EXISTS _user;
379CREATE TABLE _user (
380 id serial NOT NULL,
381 orderer float DEFAULT '0',
382 active BOOLEAN DEFAULT TRUE,
383 enabled BOOLEAN DEFAULT TRUE,
384 time double precision DEFAULT extract(epoch from now()),
385 timee double precision DEFAULT extract(epoch from now())
386)
387WITH (
388 OIDS=FALSE
389);
390
391
392
393
394--
395-- Table structure for table `_user_group`
396--
397DROP TABLE IF EXISTS _user_group;
398CREATE TABLE _user_group (
399 id serial NOT NULL,
400 key varchar(30) DEFAULT NULL,
401 lang varchar(3) DEFAULT NULL,
402 name varchar(100) DEFAULT NULL,
403 title varchar(255) DEFAULT NULL,
404 description text,
405 orderer float DEFAULT '0',
406 active BOOLEAN DEFAULT TRUE,
407 enabled BOOLEAN DEFAULT TRUE,
408 time double precision DEFAULT extract(epoch from now()),
409 timee double precision DEFAULT extract(epoch from now())
410)
411WITH (
412 OIDS=FALSE
413);
414
415
416
417
418--
419-- Table structure for table `_user_info`
420--
421DROP TABLE IF EXISTS _user_info;
422CREATE TABLE _user_info (
423 user_id int DEFAULT NULL,
424 orderer float DEFAULT '0',
425 active BOOLEAN DEFAULT TRUE,
426 enabled BOOLEAN DEFAULT TRUE,
427 time double precision DEFAULT extract(epoch from now()),
428 timee double precision DEFAULT extract(epoch from now())
429)
430WITH (
431 OIDS=FALSE
432);