-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathext_tables.sql
62 lines (54 loc) · 2.67 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
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)
);