This repository has been archived by the owner on Oct 17, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
61 lines (53 loc) · 1.79 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
#
# Table structure for table 'tx_koningapiqueue_domain_model_api'
#
CREATE TABLE tx_koningapiqueue_domain_model_api (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0',
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
editlock tinyint(4) DEFAULT '0' NOT NULL,
identifier varchar(225) DEFAULT '',
name varchar(225) DEFAULT '',
description text NOT NULL,
location varchar(225) DEFAULT '',
requests int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_koningapiqueue_domain_model_request'
#
CREATE TABLE tx_koningapiqueue_domain_model_request (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0',
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
editlock tinyint(4) DEFAULT '0' NOT NULL,
api int(11) DEFAULT '0' NOT NULL,
request int(11) DEFAULT '0' NOT NULL,
location varchar(225) DEFAULT '',
method varchar(6) DEFAULT '',
body longtext NOT NULL,
headers text NOT NULL,
last_process_date int(11) DEFAULT '0' NOT NULL,
responses int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_koningapiqueue_domain_model_request'
#
CREATE TABLE tx_koningapiqueue_domain_model_response (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0',
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
editlock tinyint(4) DEFAULT '0' NOT NULL,
request int(11) DEFAULT '0' NOT NULL,
processed_date int(11) DEFAULT '0' NOT NULL,
status_code int(11) DEFAULT '0' NOT NULL,
body longtext NOT NULL,
PRIMARY KEY (uid)
);