pagebased/ext_tables.sql at master · zeroseven/pagebased · 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
70
71
72
73
74
75
76
77
78
79
CREATE TABLE pages
(
	pagebased_top               tinyint(1) unsigned DEFAULT '0' NOT NULL,
	pagebased_date              int(11) DEFAULT '0' NOT NULL,
	pagebased_tags              text,
	pagebased_topics            int(11) unsigned DEFAULT '0' NOT NULL,
	pagebased_contact           int(11) unsigned DEFAULT '0' NOT NULL,
	pagebased_relations_to      int(11) unsigned DEFAULT '0' NOT NULL,
	pagebased_relations_from    int(11) unsigned DEFAULT '0' NOT NULL,
	pagebased_redirect_category tinyint(1) unsigned DEFAULT '0' NOT NULL,
	_pagebased_site             int(11) DEFAULT '0' NOT NULL,
	_pagebased_registration     varchar(255) DEFAULT '' NOT NULL,
	_pagebased_child_object     tinyint(1) unsigned DEFAULT '0' NOT NULL,

	KEY pagebased_registration (_pagebased_registration),
	KEY pagebased_site (_pagebased_site),
	KEY pagebased_registration_site (_pagebased_registration, _pagebased_site)
);

CREATE TABLE tx_pagebased_domain_model_topic
(
	uid   int(11) NOT NULL auto_increment,
	title varchar(255) DEFAULT '' NOT NULL,

	PRIMARY KEY (uid),
	KEY   parent (pid),
	KEY language (l10n_parent,sys_language_uid)
);

CREATE TABLE tx_pagebased_domain_model_contact
(
	uid         int(11) NOT NULL auto_increment,
	firstname   varchar(255) DEFAULT '' NOT NULL,
	lastname    varchar(255) DEFAULT '' NOT NULL,
	company     varchar(255) DEFAULT '' NOT NULL,
	expertise   varchar(255) DEFAULT '' NOT NULL,
	email       varchar(255) DEFAULT '' NOT NULL,
	phone       varchar(255) DEFAULT '' NOT NULL,
	website     varchar(255) DEFAULT '' NOT NULL,
	address     text                    NOT NULL,
	city        varchar(255) DEFAULT '' NOT NULL,
	zip         varchar(255) DEFAULT '' NOT NULL,
	country     varchar(255) DEFAULT '' NOT NULL,
	description text                    NOT NULL,
	image       int(11) unsigned NOT NULL default '0',
	page        varchar(255) DEFAULT '' NOT NULL,
	twitter     varchar(255) DEFAULT '' NOT NULL,
	facebook    varchar(255) DEFAULT '' NOT NULL,
	linkedin    varchar(255) DEFAULT '' NOT NULL,
	xing        varchar(255) DEFAULT '' NOT NULL,

	PRIMARY KEY (uid),
	KEY         parent (pid),
	KEY language (l10n_parent,sys_language_uid)
);

CREATE TABLE tx_pagebased_object_topic_mm
(
	uid_local       int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign     int(11) unsigned DEFAULT '0' NOT NULL,
	sorting         int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid_local, uid_foreign),
	KEY             uid_local (uid_local),
	KEY             uid_foreign (uid_foreign)
);

CREATE TABLE tx_pagebased_relation_mm
(
	uid_local       int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign     int(11) unsigned DEFAULT '0' NOT NULL,
	sorting         int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid_local, uid_foreign),
	KEY             uid_local (uid_local),
	KEY             uid_foreign (uid_foreign)
);