forked from sirdiego/importr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
49 lines (41 loc) · 1.47 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
#
# Table structure for table 'tx_importr_domain_model_import'
#
CREATE TABLE tx_importr_domain_model_import (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
strategy int(11) unsigned DEFAULT '0' NOT NULL,
filepath varchar(255) DEFAULT '' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
pointer int(11) unsigned DEFAULT '0' NOT NULL,
amount int(11) unsigned DEFAULT '0' NOT NULL,
inserted int(11) unsigned DEFAULT '0' NOT NULL,
updated int(11) unsigned DEFAULT '0' NOT NULL,
ignored int(11) unsigned DEFAULT '0' NOT NULL,
unknowns int(11) unsigned DEFAULT '0' NOT NULL,
errors int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_importr_domain_model_strategy'
#
CREATE TABLE tx_importr_domain_model_strategy (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
configuration text NOT NULL,
configuration_file varchar(255) DEFAULT '' NOT NULL,
resources text NOT NULL,
resources_file varchar(255) DEFAULT '' NOT NULL,
targets text NOT NULL,
targets_file varchar(255) DEFAULT '' NOT NULL,
general tinyint(4) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);