forked from AOEpeople/aoe_ipauth
-
Notifications
You must be signed in to change notification settings - Fork 1
/
ext_tables.sql
executable file
·38 lines (33 loc) · 1.03 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
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_aoeipauth_ip int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'fe_groups'
#
CREATE TABLE fe_groups (
tx_aoeipauth_ip int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_aoeipauth_domain_model_ip'
#
CREATE TABLE tx_aoeipauth_domain_model_ip (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
fe_user int(11) unsigned DEFAULT '0' NOT NULL,
fe_group int(11) unsigned DEFAULT '0' NOT NULL,
ip varchar(255) DEFAULT '' NOT NULL,
range_type tinyint(4) unsigned DEFAULT '0' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);