forked from TYPO3-Documentation/blog_example
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
85 lines (74 loc) · 2.42 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
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
80
81
82
83
84
#
# Table structure for table 'tx_blogexample_domain_model_blog'
#
CREATE TABLE tx_blogexample_domain_model_blog (
title varchar(255) DEFAULT '' NOT NULL,
subtitle varchar(255) DEFAULT '',
description text NOT NULL,
logo tinyblob DEFAULT NULL,
administrator int(11) UNSIGNED NOT NULL DEFAULT '0',
posts varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_blogexample_domain_model_post'
#
CREATE TABLE tx_blogexample_domain_model_post (
blog int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
date int(11) DEFAULT '0' NOT NULL,
author int(11) DEFAULT '0' NOT NULL,
second_author int(11) DEFAULT '0' NOT NULL,
reviewer int(11) DEFAULT '0' NOT NULL,
content text NOT NULL,
tags int(11) unsigned DEFAULT '0' NOT NULL,
comments int(11) unsigned DEFAULT '0' NOT NULL,
related_posts int(11) unsigned DEFAULT '0' NOT NULL,
additional_name varchar(255) DEFAULT '' NOT NULL,
additional_info int(11) DEFAULT '0' NOT NULL,
additional_comments varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_blogexample_domain_model_comment'
#
CREATE TABLE tx_blogexample_domain_model_comment (
post int(11) DEFAULT '0' NOT NULL,
date datetime,
author varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
content text NOT NULL
);
#
# Table structure for table 'tx_blogexample_domain_model_person'
#
CREATE TABLE tx_blogexample_domain_model_person (
firstname varchar(255) DEFAULT '' NOT NULL,
lastname varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
tags int(11) unsigned DEFAULT '0' NOT NULL,
tags_special int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_blogexample_domain_model_tag'
#
CREATE TABLE tx_blogexample_domain_model_tag (
name varchar(255) DEFAULT '' NOT NULL,
priority int(11) DEFAULT '0' NOT NULL,
posts int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_blogexample_domain_model_info'
#
CREATE TABLE tx_blogexample_domain_model_info (
name varchar(255) DEFAULT '' NOT NULL,
bodytext text,
post int(11) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_blogexample_domain_model_tag_mm'
# @TODO fix tx_blogexample_domain_model_person to create and recognize this mm-table
# with the field `fieldname` automatically, remove this entry
# @see https://forge.typo3.org/issues/98322
#
CREATE TABLE `tx_blogexample_domain_model_tag_mm` (
`fieldname` varchar(63) DEFAULT '' NOT NULL
);