forked from xperseguers/t3ext-ig_ldap_sso_auth
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
executable file
·87 lines (76 loc) · 2.4 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
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
#
# Table structure for table 'tx_igldapssoauth_config'
#
CREATE TABLE tx_igldapssoauth_config (
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,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
sites text NOT NULL,
ldap_server int(11) DEFAULT '0' NOT NULL,
ldap_charset varchar(255) DEFAULT '' NOT NULL,
ldap_host varchar(255) DEFAULT '' NOT NULL,
ldap_port int(11) DEFAULT '0' NOT NULL,
ldap_tls tinyint(4) DEFAULT '0' NOT NULL,
ldap_tls_reqcert tinyint(4) DEFAULT '1' NOT NULL,
ldap_ssl tinyint(4) DEFAULT '0' NOT NULL,
ldap_timeout int(11) DEFAULT '0' NOT NULL,
ldap_binddn tinytext NOT NULL,
ldap_password varchar(255) DEFAULT '' NOT NULL,
group_membership tinyint(4) DEFAULT '0' NOT NULL,
be_users_basedn varchar(255) DEFAULT '' NOT NULL,
be_users_filter text,
be_users_mapping text,
be_groups_basedn varchar(255) DEFAULT '' NOT NULL,
be_groups_filter text,
be_groups_mapping text,
be_groups_required varchar(100) DEFAULT '' NOT NULL,
be_groups_assigned varchar(100) DEFAULT '' NOT NULL,
be_groups_admin varchar(100) DEFAULT '' NOT NULL,
fe_users_basedn varchar(255) DEFAULT '' NOT NULL,
fe_users_filter text,
fe_users_mapping text,
fe_groups_basedn varchar(255) DEFAULT '' NOT NULL,
fe_groups_filter text,
fe_groups_mapping text,
fe_groups_required text,
fe_groups_assigned text,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'be_groups'
#
CREATE TABLE be_groups (
tx_igldapssoauth_dn varchar(255) DEFAULT '' NOT NULL,
KEY title (title),
KEY tx_igldapssoauth_dn (tx_igldapssoauth_dn(64))
);
#
# Table structure for table 'be_users'
#
CREATE TABLE be_users (
tx_igldapssoauth_dn varchar(255) DEFAULT '' NOT NULL,
tx_igldapssoauth_id int(11) unsigned DEFAULT '0' NOT NULL,
KEY tx_igldapssoauth_dn (tx_igldapssoauth_dn(64))
);
#
# Table structure for table 'fe_groups'
#
CREATE TABLE fe_groups (
tx_igldapssoauth_dn varchar(255) DEFAULT '' NOT NULL,
KEY title (title),
KEY tx_igldapssoauth_dn (tx_igldapssoauth_dn(64))
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_igldapssoauth_dn varchar(255) DEFAULT '' NOT NULL,
tx_igldapssoauth_id int(11) unsigned DEFAULT '0' NOT NULL,
KEY tx_igldapssoauth_dn (tx_igldapssoauth_dn(64))
);