-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy pathext_tables.sql
More file actions
27 lines (22 loc) · 838 Bytes
/
ext_tables.sql
File metadata and controls
27 lines (22 loc) · 838 Bytes
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
CREATE TABLE tx_t3am_decryption_key
(
uid int(11) NOT NULL auto_increment,
private_key text,
PRIMARY KEY (uid)
);
CREATE TABLE tx_t3am_client
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' 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(1) unsigned DEFAULT '0' NOT NULL,
disabled tinyint(4) unsigned DEFAULT '0' NOT NULL,
identifier varchar(255) DEFAULT '' NOT NULL,
instance_notice text,
token varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY token (token),
KEY parent (pid)
);