cps-download/ext_tables.sql at main · CPS-IT/cps-download · 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
#
# Table definition for "tx_cpsdownload_domain_model_download"
#
CREATE TABLE tx_cpsdownload_domain_model_download
(
    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(3)       DEFAULT '0',
    hidden           tinyint(4)       DEFAULT '0' NOT NULL,
    starttime        int(11)          DEFAULT '0' NOT NULL,
    endtime          int(11)          DEFAULT '0' NOT NULL,
    fe_group         varchar(100)     DEFAULT '0' NOT NULL,
    sorting          int(11)          DEFAULT '0' NOT NULL,

    type             tinyint(4)       DEFAULT '0' NOT NULL,
    title            varchar(255)     DEFAULT ''  NOT NULL,
    teaser           varchar(255)     DEFAULT ''  NOT NULL,
    categories       int(11) UNSIGNED             NOT NULL DEFAULT '0',
    accessibility    tinyint(4)       DEFAULT '0' NOT NULL,
    size             varchar(20)      DEFAULT ''  NOT NULL,
    file_ext         varchar(20)      DEFAULT ''  NOT NULL,
    link             varchar(1024)    DEFAULT ''  NOT NULL,
    files            int(11) unsigned DEFAULT '0' NOT NULL,
    author           int(11) unsigned DEFAULT '0' NOT NULL,
    information_date int(11) unsigned DEFAULT '0' NOT NULL,

    sys_language_uid int(11)          DEFAULT '0' NOT NULL,
    l10n_parent      int(11)          DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumblob,

    t3ver_oid        int(11)          DEFAULT '0' NOT NULL,
    t3ver_id         int(11)          DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)          DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)      DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)       DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)       DEFAULT '0' NOT NULL,
    t3ver_count      int(11)          DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)          DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)          DEFAULT '0' NOT NULL,
    t3_origuid       int(11)          DEFAULT '0' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY author (author),
    KEY sys_language_uid_l10n_parent (sys_language_uid, l10n_parent)
);

#
# Extend table structure of table 'sys_category'
#
CREATE TABLE sys_category
(
    downloads int(11) UNSIGNED NOT NULL DEFAULT '0'
);