brofix/ext_tables.sql at main · sypets/brofix · 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
67
68
69
# table for broken links
# @deprecated tstamp
CREATE TABLE tx_brofix_broken_links (
	uid int(11) NOT NULL auto_increment,
	tstamp int(11) DEFAULT '0' NOT NULL,
  crdate int(11) DEFAULT '0' NOT NULL,
	record_uid int(11) DEFAULT '0' NOT NULL,
	record_pid int(11) DEFAULT '0' NOT NULL,
	record_pageid  int(11) DEFAULT '0' NOT NULL,
	language int(11) DEFAULT '-1' NOT NULL,
	headline varchar(255) DEFAULT '' NOT NULL,
	field varchar(255) DEFAULT '' NOT NULL,
	flexform_field varchar(255) DEFAULT '' NOT NULL,
	flexform_field_label varchar(255) DEFAULT '' NOT NULL,
	table_name varchar(255) DEFAULT '' NOT NULL,
	element_type varchar(255) DEFAULT '' NOT NULL,
	link_title text,
	url text,
	url_hash varchar(40) DEFAULT '' NOT NULL,

	url_response text,
	check_status int(5) DEFAULT '4' NOT NULL,
	url_checker varchar(100) DEFAULT '' NOT NULL,
	error_type  varchar(50) DEFAULT '' NOT NULL,
	errno int(11) unsigned DEFAULT '0' NOT NULL,

	last_check int(11) DEFAULT '0' NOT NULL,
	last_check_url int(11) DEFAULT '0' NOT NULL,
	link_type varchar(50) DEFAULT '' NOT NULL,
	exclude_link_targets_pid int(11) DEFAULT '0' NOT NULL,

	KEY url_combined (url_hash,link_type,check_status),
	PRIMARY KEY (uid)
);

# table for link target cache
CREATE TABLE tx_brofix_link_target_cache (
	uid int(11) NOT NULL auto_increment,
	link_type varchar(50) DEFAULT 'external' NOT NULL,
	url text,
	last_check int(11) unsigned DEFAULT '0' NOT NULL,

	check_status int(11) unsigned DEFAULT '0' NOT NULL,
	url_response text,
	url_checker varchar(100) DEFAULT '' NOT NULL,
	error_type varchar(50) DEFAULT '' NOT NULL,
	errno int(11) unsigned DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid)
);

# table for excluding link targets
CREATE TABLE tx_brofix_exclude_link_target (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    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) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    linktarget text,
    link_type varchar(20) DEFAULT '' NOT NULL,
    match varchar(20) DEFAULT '' NOT NULL,
    reason int(4) DEFAULT '0' NOT NULL,
    notes varchar(80) DEFAULT '' NOT NULL,

    PRIMARY KEY (uid)
);