starter-nessa/ext_tables.sql at main · chriwo/starter-nessa · 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
#
# Extend table structure for table 'tt_content'
#
CREATE TABLE tt_content (
    nessa_team_member_element int(11) DEFAULT '0' NOT NULL,
    nessa_teaser_element int(11) DEFAULT '0' NOT NULL,
    nessa_hero_element int(11) DEFAULT '0' NOT NULL,
    nessa_copyright varchar(255) DEFAULT '0' NOT NULL,
		tx_starter_ctalink varchar(1024) DEFAULT '' NOT NULL,
		tx_starter_ctalink_text varchar(255) DEFAULT '' NOT NULL
);

#
# Extend table structure for table 'sys_file_metadata'
#
CREATE TABLE sys_file_metadata (
    nessa_portfolio_link varchar(1024) DEFAULT '' NOT NULL
);

#
# Table structure for table 'tx_starternessa_team_element'
#
CREATE TABLE tx_starternessa_team_element (
    tt_content_record int(11) DEFAULT '0' NOT NULL,
    realname varchar(255) DEFAULT '' NOT NULL,
    company_position varchar(255) DEFAULT '' NOT NULL,
    email varchar(1024) DEFAULT '' NOT NULL,
    assets int(11) DEFAULT '0' NOT NULL,
    bodytext text,

    KEY parent (pid,sorting),
    KEY language (l10n_parent,sys_language_uid)
);

#
# Table structure for table 'tx_starternessa_teaser_element'
#
CREATE TABLE tx_starternessa_teaser_element (
    tt_content_record int(11) DEFAULT '0' NOT NULL,
    header varchar(255) DEFAULT '' NOT NULL,
    icon varchar(30) DEFAULT '' NOT NULL,
    assets int(11) DEFAULT '0' NOT NULL,
    link varchar(1024) DEFAULT '' NOT NULL,
    link_text varchar(255) DEFAULT '' NOT NULL,
    bodytext text,

    KEY parent (pid,sorting),
    KEY language (l10n_parent,sys_language_uid)
);

#
# Table structure for table 'tx_starternessa_hero_element'
#
CREATE TABLE tx_starternessa_hero_element (
    tt_content_record int(11) DEFAULT '0' NOT NULL,
    header varchar(255) DEFAULT '' NOT NULL,
    assets int(11) DEFAULT '0' NOT NULL,
    bodytext text,
    ctalink varchar(1024) DEFAULT '' NOT NULL,
    ctalink_text varchar(255) DEFAULT '' NOT NULL,

    KEY parent (pid,sorting),
    KEY language (l10n_parent,sys_language_uid)
);