forked from pixelant/dashboard
-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathext_tables.sql
78 lines (58 loc) · 2.29 KB
/
ext_tables.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
#
# Table structure for table 'tx_dashboard_domain_model_dashboard'
#
CREATE TABLE tx_dashboard_domain_model_dashboard (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
dashboard_widget_settings int(11) unsigned DEFAULT '0' NOT NULL,
beuser int(11) unsigned DEFAULT '0',
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_dashboard_domain_model_dashboardwidgetsettings'
#
CREATE TABLE tx_dashboard_domain_model_dashboardwidgetsettings (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
dashboard int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
widget_identifier varchar(50) DEFAULT '' NOT NULL,
x int(11) unsigned DEFAULT '0' NOT NULL,
y int(11) unsigned DEFAULT '0' NOT NULL,
width int(11) unsigned DEFAULT '0' NOT NULL,
height int(11) unsigned DEFAULT '0' NOT NULL,
settings_flexform text NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_dashboard_domain_model_dashboardwidgetsettings'
#
CREATE TABLE tx_dashboard_domain_model_dashboardwidgetsettings (
dashboard int(11) unsigned DEFAULT '0' NOT NULL,
);
## EXTENSION BUILDER DEFAULTS END TOKEN - Everything BEFORE this line is overwritten with the defaults of the extension builder