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
/
Copy pathext_tables.sql
50 lines (45 loc) · 1.54 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
#
# Table structure for table 'tx_koningkiyoh_domain_model_company'
#
CREATE TABLE tx_koningkiyoh_domain_model_company (
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,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
remote_identifier int(11) DEFAULT '0',
name varchar(255) DEFAULT '',
url varchar(255) DEFAULT '',
reviews int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
INDEX remote_identifier (remote_identifier)
);
#
# Table structure for table 'tx_koningkiyoh_domain_model_review'
#
CREATE TABLE tx_koningkiyoh_domain_model_review (
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,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
remote_identifier int(11) DEFAULT '0',
name varchar(255) DEFAULT '',
company int(11) DEFAULT '0' NOT NULL,
review_date int(11) DEFAULT '0' NOT NULL,
score int(11) DEFAULT '0' NOT NULL,
positive_comment text,
negative_comment text,
reaction text,
recommendation tinyint(4) DEFAULT '0' NOT NULL,
image text,
fallback_image int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
INDEX remote_identifier (remote_identifier)
);