-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
50 lines (39 loc) · 1.3 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
CREATE TABLE tx_timeline_domain_model_timeline (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
description text,
epochs int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_timeline_domain_model_epoch (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
alternative_title varchar(255) DEFAULT '' NOT NULL,
startdate int(11) DEFAULT '0' NOT NULL,
enddate int(11) DEFAULT '0' NOT NULL,
color varchar(255) DEFAULT '' NOT NULL,
moments int(11) DEFAULT '0' NOT NULL,
timeline int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_timeline_domain_model_moment (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
alternative_title varchar(255) DEFAULT '' NOT NULL,
description text,
exact_day int(11) DEFAULT '0' NOT NULL,
epoch int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid)
);