versatile-crawler/ext_tables.sql at main · webcoast-dk/versatile-crawler · GitHub

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
62
63
64
65
66
CREATE TABLE tx_versatilecrawler_domain_model_configuration (
  uid int(11) NOT NULL auto_increment,
  pid int(11) NOT NULL DEFAULT '0',
  crdate int(11) NOT NULL DEFAULT '0',
  cruser_id int(11) NOT NULL DEFAULT '0',
  tstamp int(11) NOT NULL DEFAULT '0',
  deleted int(11) NOT NULL DEFAULT '0',
  disabled int(11) NOT NULL DEFAULT '0',

  title varchar(100) NOT NULL DEFAULT '',
  domain int(11) NOT NULL DEFAULT '0',
  base_url varchar(200) NOT NULL DEFAULT '',
  type varchar(200) NOT NULL DEFAULT '',
  indexing_configuration int(11) NOT NULL DEFAULT '0',

  # fields for page indexer
  levels tinyint(2) NOT NULL DEFAULT '0',
  exclude_pages_with_configuration tinyint(1) NOT NULL DEFAULT '1',

  # languages field, is used by page and record indexer
  languages varchar(1000) NOT NULL DEFAULT '',

  # fields for record indexer
  table_name varchar(500) NOT NULL DEFAULT '',
  record_storage_page int(11) NOT NULL DEFAULT '0',
  record_storage_page_recursive tinyint(1) NOT NULL DEFAULT '0',
  query_string varchar(1000) NOT NULL DEFAULT '',

  # fields for meta configuration
  configurations int(11) NOT NULL DEFAULT '0',

  # fields for files configuration
  file_storages int(11) NOT NULL DEFAULT '0',
  file_extensions varchar(200) NOT NULL DEFAULT '',

  PRIMARY KEY (uid),
  KEY parent(pid)
) Engine = InnoDB;

CREATE TABLE tx_versatilecrawler_domain_model_configuration_mm (
  uid_local int(11) NOT NULL DEFAULT '0',
  uid_foreign int(11) NOT NULL DEFAULT '0',
  sorting int(11) NOT NULL DEFAULT '0'
) Engine = InnoDB;

CREATE TABLE tx_versatilecrawler_domain_model_configuration_file_storage_mm (
  uid_local int(11) NOT NULL DEFAULT '0',
  uid_foreign int(11) NOT NULL DEFAULT '0',
  sorting int(11) NOT NULL DEFAULT '0'
) Engine = InnoDB;

CREATE TABLE tx_versatilecrawler_domain_model_queue_item (
  uid int(11) NOT NULL auto_increment,
  pid int(11) NOT NULL DEFAULT '0',
  tstamp int(11) NOT NULL DEFAULT '0',

  configuration int(11) NOT NULL DEFAULT '0',
  identifier varchar(300) NOT NULL DEFAULT '0',
  hash varchar(32) NOT NULL DEFAULT '',
  state tinyint(1) NOT NULL DEFAULT '0',
  message text,
  data json,

  PRIMARY KEY (uid),
  KEY parent(pid)
) Engine = InnoDB;