l10nmgr/ext_tables.sql at master · CodersCare/l10nmgr · 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
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
#
# Table structure for table 'tx_l10nmgr_cfg'
#
CREATE TABLE tx_l10nmgr_cfg
(
    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,
    title                        tinytext,
    depth                        int(11)    DEFAULT '0' NOT NULL,
    pages                        text,
    displaymode                  int(11)    DEFAULT '0' NOT NULL,
    tablelist                    text,
    exclude                      mediumtext,
    include                      mediumtext,
    flexformdiff                 mediumtext,
    metadata                     text,
    sourceLangStaticId           char(3)    NOT NULL default '',
    forcedSourceLanguage         int(11)    DEFAULT '0' NOT NULL,
    onlyForcedSourceLanguage     tinyint(4) DEFAULT '0',
    incfcewithdefaultlanguage    tinyint(4) DEFAULT '0',
    filenameprefix               tinytext,
    overrideexistingtranslations tinyint(4) DEFAULT '0',
    sortexports                  tinyint(4) DEFAULT '0',
    applyExcludeToChildren       tinyint(4) DEFAULT '0',

    PRIMARY KEY (uid),
    KEY parent (pid)
);


#
# Table structure for table 'sys_refindex'
#
CREATE TABLE tx_l10nmgr_index
(
    hash               varchar(32) DEFAULT ''  NOT NULL,
    tablename          varchar(64) DEFAULT ''  NOT NULL,
    recuid             int(11)     DEFAULT '0' NOT NULL,
    recpid             int(11)     DEFAULT '0' NOT NULL,
    sys_language_uid   int(11)     DEFAULT '0' NOT NULL,
    translation_lang   int(11)     DEFAULT '0' NOT NULL,
    translation_recuid int(11)     DEFAULT '0' NOT NULL,
    workspace          int(11)     DEFAULT '0' NOT NULL,
    serializedDiff     mediumblob,
    flag_new           int(11)     DEFAULT '0' NOT NULL,
    flag_unknown       int(11)     DEFAULT '0' NOT NULL,
    flag_noChange      int(11)     DEFAULT '0' NOT NULL,
    flag_update        int(11)     DEFAULT '0' NOT NULL,

    PRIMARY KEY (hash),
    KEY lookup_rec (tablename, recuid, translation_lang, workspace),
    KEY lookup_pid (recpid, translation_lang, workspace)
);


#
# Table structure for table 'tx_l10nmgr_priorities'
#
CREATE TABLE tx_l10nmgr_priorities
(
    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,
    sorting     int(10)    DEFAULT '0' NOT NULL,
    deleted     tinyint(4) DEFAULT '0' NOT NULL,
    hidden      tinyint(4) DEFAULT '0' NOT NULL,
    title       tinytext,
    description text,
    languages   blob,
    element     blob,

    PRIMARY KEY (uid),
    KEY parent (pid)
);

#
# Table structure for table 'tx_l10nmgr_exportdata'
#
CREATE TABLE tx_l10nmgr_exportdata
(
    uid              int(11)                 NOT NULL auto_increment,
    pid              int(11)     DEFAULT '0' NOT NULL,
    l10ncfg_id       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,
    title            tinytext,
    source_lang      varchar(40) DEFAULT ''  NOT NULL,
    translation_lang varchar(40) DEFAULT ''  NOT NULL,
    tablelist        text,
    exportType       blob,
    filename         text,

    PRIMARY KEY (uid)
);

#
# Extend Table structure for table 'pages'
#
CREATE TABLE pages
(
    l10nmgr_configuration            tinyint(4) DEFAULT '0' NOT NULL,
    l10nmgr_configuration_next_level tinyint(4) DEFAULT '0' NOT NULL,
);