t3x-contexts/ext_tables.sql at main · netresearch/t3x-contexts · GitHub

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
#
# Table structure for table 'tx_contexts_contexts'
#
CREATE TABLE tx_contexts_contexts
(
    uid             int(11)                NOT NULL auto_increment,
    pid             int(11)    DEFAULT '0' NOT NULL,
    tstamp          int(11)    DEFAULT '0' NOT NULL,
    crdate          int(11)    DEFAULT '0' NOT NULL,
    cruser_id       int(11)    DEFAULT '0' NOT NULL,
    deleted         tinyint(4) DEFAULT '0' NOT NULL,
    type            tinytext,
    title           tinytext,
    alias           tinytext,
    type_conf       mediumtext,
    invert          tinyint(4) DEFAULT '0' NOT NULL,
    use_session     tinyint(4) DEFAULT '0' NOT NULL,
    disabled        tinyint(4) DEFAULT '0' NOT NULL,
    hide_in_backend tinyint(4) DEFAULT '0' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid)
) ENGINE = InnoDB;

#
# Table structure for table 'tx_contexts_settings'
#
CREATE TABLE tx_contexts_settings
(
    uid           int(11)                NOT NULL auto_increment,
    pid           int(11)    DEFAULT '0' NOT NULL,
    tstamp        int(11)    DEFAULT '0' NOT NULL,
    crdate        int(11)    DEFAULT '0' NOT NULL,
    cruser_id     int(11)    DEFAULT '0' NOT NULL,
    context_uid   int(11)    DEFAULT '0' NOT NULL,
    foreign_table tinytext,
    foreign_uid   int(11)    DEFAULT '0' NOT NULL,
    name          tinytext,
    enabled       tinyint(4) DEFAULT '0' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid)
) ENGINE = InnoDB;

#
# Update structure of table 'pages'
#
CREATE TABLE pages
(
    tx_contexts_enable      text,
    tx_contexts_disable     text,
    tx_contexts_nav_enable  text,
    tx_contexts_nav_disable text
);

#
# Update structure of table 'tt_content'
#
CREATE TABLE tt_content
(
    tx_contexts_enable  text,
    tx_contexts_disable text
);