typo3samlauthentication/ext_tables.sql at master · 4wdmedia/typo3samlauthentication · 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
CREATE TABLE 'tx_samlauthentication_domain_model_serviceprovider'
(
    uid              INT(11) UNSIGNED                 NOT NULL AUTO_INCREMENT,
    pid              INT(11)             DEFAULT '0'  NOT NULL,
    crdate           INT(11) UNSIGNED    DEFAULT '0'  NOT NULL,
    tstamp           INT(11) UNSIGNED    DEFAULT '0'  NOT NULL,
    deleted          TINYINT(4) UNSIGNED DEFAULT '0'  NOT NULL,
    hidden           TINYINT(4) UNSIGNED DEFAULT '0'  NOT NULL,
    cruser_id        INT(11) UNSIGNED    DEFAULT '0'  NOT NULL,

    title            VARCHAR(255)        DEFAULT ''   NOT NULL,
    destinationpid   INT(11),
    type             INT(11) UNSIGNED    DEFAULT 1    NOT NULL,
    prefix           VARCHAR(255),
    entityid         VARCHAR(255),
    identityprovider VARCHAR(255)        DEFAULT ''   NOT NULL,
    context          CHAR(2)             DEFAULT 'FE' NOT NULL,
    tablemapping     INT(11)             DEFAULT 0    NOT NULL,

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

CREATE TABLE 'tx_samlauthentication_domain_model_tablemapping'
(
    uid             INT(11) UNSIGNED                NOT NULL AUTO_INCREMENT,
    pid             INT(11)             DEFAULT '0' NOT NULL,
    crdate          INT(11) UNSIGNED    DEFAULT '0' NOT NULL,
    tstamp          INT(11) UNSIGNED    DEFAULT '0' NOT NULL,
    deleted         TINYINT(4) UNSIGNED DEFAULT '0' NOT NULL,
    hidden          TINYINT(4) UNSIGNED DEFAULT '0' NOT NULL,
    cruser_id       INT(11) UNSIGNED    DEFAULT '0' NOT NULL,

    serviceprovider INT(11)             DEFAULT 0   NOT NULL,
    table           VARCHAR(255)        DEFAULT ''  NOT NULL,
    fields          INT(11)             DEFAULT 0   NOT NULL,

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

CREATE TABLE 'tx_samlauthentication_domain_model_fieldmapping'
(
    uid            INT(11) UNSIGNED                NOT NULL AUTO_INCREMENT,
    pid            INT(11)             DEFAULT '0' NOT NULL,
    crdate         INT(11) UNSIGNED    DEFAULT '0' NOT NULL,
    tstamp         INT(11) UNSIGNED    DEFAULT '0' NOT NULL,
    deleted        TINYINT(4) UNSIGNED DEFAULT '0' NOT NULL,
    hidden         TINYINT(4) UNSIGNED DEFAULT '0' NOT NULL,
    cruser_id      INT(11) UNSIGNED    DEFAULT '0' NOT NULL,

    table          INT(11)             DEFAULT 0   NOT NULL,
    identifier     TINYINT(1)          DEFAULT 0   NOT NULL,
    field          VARCHAR(255)        DEFAULT ''  NOT NULL,
    foreignfield   VARCHAR(255)        DEFAULT ''  NOT NULL,
    noforeignfield TINYINT(1)          DEFAULT 0   NOT NULL,
    defaultvalue   VARCHAR(255)        DEFAULT ''  NOT NULL,
    fallback       TINYINT(4) UNSIGNED DEFAULT '0' NOT NULL,

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