73b3721ed64d3a88412644bf4c8de1cd54c2c02c
[Packages/TYPO3.CMS.git] / typo3 / sysext / extbase / Tests / Functional / Fixtures / Extensions / blog_example / ext_tables.sql
1 #
2 # Table structure for table 'tx_blogexample_domain_model_blog'
3 #
4 CREATE TABLE tx_blogexample_domain_model_blog (
5 title varchar(255) DEFAULT '' NOT NULL,
6 subtitle varchar(255) DEFAULT '',
7 description text NOT NULL,
8 logo tinyblob NOT NULL,
9 administrator int(11) DEFAULT '0' NOT NULL,
10
11 posts varchar(255) DEFAULT '' NOT NULL
12 );
13
14 #
15 # Table structure for table 'tx_blogexample_domain_model_post'
16 #
17 CREATE TABLE tx_blogexample_domain_model_post (
18 blog int(11) DEFAULT '0' NOT NULL,
19
20 title varchar(255) DEFAULT '' NOT NULL,
21 date int(11) DEFAULT '0' NOT NULL,
22 author int(11) DEFAULT '0' NOT NULL,
23 second_author int(11) DEFAULT '0' NOT NULL,
24 reviewer int(11) DEFAULT '0' NOT NULL,
25 content text NOT NULL,
26 tags int(11) unsigned DEFAULT '0' NOT NULL,
27 comments int(11) unsigned DEFAULT '0' NOT NULL,
28 related_posts int(11) unsigned DEFAULT '0' NOT NULL,
29 additional_name varchar(255) DEFAULT '' NOT NULL,
30 additional_info int(11) DEFAULT '0' NOT NULL,
31 additional_comments varchar(255) DEFAULT '' NOT NULL
32 );
33
34 #
35 # Table structure for table 'tx_blogexample_domain_model_comment'
36 #
37 CREATE TABLE tx_blogexample_domain_model_comment (
38 post int(11) DEFAULT '0' NOT NULL,
39
40 date datetime,
41 author varchar(255) DEFAULT '' NOT NULL,
42 email varchar(255) DEFAULT '' NOT NULL,
43 content text NOT NULL
44 );
45
46 #
47 # Table structure for table 'tx_blogexample_domain_model_person'
48 #
49 CREATE TABLE tx_blogexample_domain_model_person (
50 firstname varchar(255) DEFAULT '' NOT NULL,
51 lastname varchar(255) DEFAULT '' NOT NULL,
52 email varchar(255) DEFAULT '' NOT NULL,
53 tags int(11) unsigned DEFAULT '0' NOT NULL,
54 tags_special int(11) unsigned DEFAULT '0' NOT NULL
55 );
56
57 #
58 # Table structure for table 'tx_blogexample_domain_model_tag'
59 #
60 CREATE TABLE tx_blogexample_domain_model_tag (
61 name varchar(255) DEFAULT '' NOT NULL,
62 posts int(11) unsigned DEFAULT '0' NOT NULL
63 );
64
65 #
66 # Table structure for table 'tx_blogexample_domain_model_tag_mm'
67 #
68 CREATE TABLE tx_blogexample_domain_model_tag_mm (
69 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
70 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
71 tablenames varchar(255) DEFAULT '' NOT NULL,
72 fieldname varchar(255) DEFAULT '' NOT NULL,
73 sorting int(11) unsigned DEFAULT '0' NOT NULL,
74 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
75
76 KEY uid_local (uid_local),
77 KEY uid_foreign (uid_foreign)
78 );
79
80 #
81 # Table structure for table 'tx_blogexample_post_tag_mm'
82 #
83 CREATE TABLE tx_blogexample_post_tag_mm (
84 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
85 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
86 sorting int(11) unsigned DEFAULT '0' NOT NULL,
87 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
88
89 KEY uid_local (uid_local),
90 KEY uid_foreign (uid_foreign)
91 );
92
93 #
94 # Table structure for table 'tx_blogexample_post_post_mm'
95 #
96 CREATE TABLE tx_blogexample_post_post_mm (
97 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
98 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
99 sorting int(11) unsigned DEFAULT '0' NOT NULL,
100 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
101
102 KEY uid_local (uid_local),
103 KEY uid_foreign (uid_foreign)
104 );
105
106 #
107 # Table structure for table 'tx_blogexample_domain_model_dateexample'
108 #
109 CREATE TABLE tx_blogexample_domain_model_dateexample (
110 datetime_int int(11) DEFAULT '0' NOT NULL,
111 datetime_text varchar(255) DEFAULT '' NOT NULL,
112 datetime_datetime datetime
113 );
114
115 #
116 # Table structure for table 'tx_blogexample_domain_model_info'
117 #
118 CREATE TABLE tx_blogexample_domain_model_info (
119 name varchar(255) DEFAULT '' NOT NULL,
120 post int(11) DEFAULT '0' NOT NULL
121 );