Changesets can be listed by changeset number.
The Git repository is here.
- Revision:
- 71
- Log:
Start of upgrade to Typo 4.0.0, the latest stable release since
2.6.0. Note test/mocks/themes/azure changes from a file to a
directory, so the file has been removed in this revision and
the directory will be added in the next revision.
- Author:
- adh
- Date:
- Mon Aug 07 22:18:11 +0100 2006
- Size:
- 6000 Bytes
1 | -- This file is autogenerated by the Rail schema generator, using |
2 | -- the schema defined in db/migration/*.rb |
3 | -- |
4 | -- Do not edit this file. Instead, add a new migration using |
5 | -- ./script/generate migration <name>, and then run |
6 | -- ./script/generate schema |
7 | |
8 | -- tables |
9 | |
10 | CREATE TABLE articles_categories ( |
11 | `article_id` int(11), |
12 | `category_id` int(11), |
13 | `is_primary` int(11) |
14 | ) ENGINE=InnoDB; |
15 | |
16 | CREATE TABLE articles_tags ( |
17 | `article_id` int(11), |
18 | `tag_id` int(11) |
19 | ) ENGINE=InnoDB; |
20 | |
21 | CREATE TABLE blacklist_patterns ( |
22 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
23 | `type` varchar(255), |
24 | `pattern` varchar(255) |
25 | ) ENGINE=InnoDB; |
26 | |
27 | CREATE TABLE blogs ( |
28 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
29 | `settings` text |
30 | ) ENGINE=InnoDB; |
31 | |
32 | CREATE TABLE categories ( |
33 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
34 | `name` varchar(255), |
35 | `position` int(11), |
36 | `permalink` varchar(255) |
37 | ) ENGINE=InnoDB; |
38 | |
39 | CREATE TABLE contents ( |
40 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
41 | `type` varchar(255), |
42 | `title` varchar(255), |
43 | `author` varchar(255), |
44 | `body` text, |
45 | `body_html` text, |
46 | `extended` text, |
47 | `excerpt` text, |
48 | `keywords` varchar(255), |
49 | `created_at` datetime, |
50 | `updated_at` datetime, |
51 | `extended_html` text, |
52 | `user_id` int(11), |
53 | `permalink` varchar(255), |
54 | `guid` varchar(255), |
55 | `text_filter_id` int(11), |
56 | `whiteboard` text, |
57 | `article_id` int(11), |
58 | `email` varchar(255), |
59 | `url` varchar(255), |
60 | `ip` varchar(40), |
61 | `blog_name` varchar(255), |
62 | `name` varchar(255), |
63 | `comments_count` int(11), |
64 | `trackbacks_count` int(11), |
65 | `published` tinyint(1) DEFAULT 0, |
66 | `allow_pings` tinyint(1), |
67 | `allow_comments` tinyint(1), |
68 | `blog_id` int(11) NOT NULL, |
69 | `published_at` datetime |
70 | ) ENGINE=InnoDB; |
71 | |
72 | CREATE TABLE notifications ( |
73 | `notify_user_id` int(11), |
74 | `notify_content_id` int(11), |
75 | `created_at` datetime, |
76 | `updated_at` datetime |
77 | ) ENGINE=InnoDB; |
78 | |
79 | CREATE TABLE page_caches ( |
80 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
81 | `name` varchar(255) |
82 | ) ENGINE=InnoDB; |
83 | |
84 | CREATE TABLE pings ( |
85 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
86 | `article_id` int(11), |
87 | `url` varchar(255), |
88 | `created_at` datetime |
89 | ) ENGINE=InnoDB; |
90 | |
91 | CREATE TABLE redirects ( |
92 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
93 | `from_path` varchar(255), |
94 | `to_path` varchar(255) |
95 | ) ENGINE=InnoDB; |
96 | |
97 | CREATE TABLE resources ( |
98 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
99 | `size` int(11), |
100 | `filename` varchar(255), |
101 | `mime` varchar(255), |
102 | `created_at` datetime, |
103 | `updated_at` datetime, |
104 | `article_id` int(11), |
105 | `itunes_metadata` tinyint(1), |
106 | `itunes_author` varchar(255), |
107 | `itunes_subtitle` varchar(255), |
108 | `itunes_duration` int(11), |
109 | `itunes_summary` text, |
110 | `itunes_keywords` varchar(255), |
111 | `itunes_category` varchar(255), |
112 | `itunes_explicit` tinyint(1) |
113 | ) ENGINE=InnoDB; |
114 | |
115 | CREATE TABLE sessions ( |
116 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
117 | `sessid` varchar(255), |
118 | `data` text, |
119 | `created_at` datetime, |
120 | `updated_at` datetime |
121 | ) ENGINE=InnoDB; |
122 | |
123 | CREATE TABLE sidebars ( |
124 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
125 | `controller` varchar(255), |
126 | `active_position` int(11), |
127 | `config` text, |
128 | `staged_position` int(11) |
129 | ) ENGINE=InnoDB; |
130 | |
131 | CREATE TABLE tags ( |
132 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
133 | `name` varchar(255), |
134 | `created_at` datetime, |
135 | `updated_at` datetime, |
136 | `display_name` varchar(255) |
137 | ) ENGINE=InnoDB; |
138 | |
139 | CREATE TABLE text_filters ( |
140 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
141 | `name` varchar(255), |
142 | `description` varchar(255), |
143 | `markup` varchar(255), |
144 | `filters` text, |
145 | `params` text |
146 | ) ENGINE=InnoDB; |
147 | |
148 | CREATE TABLE triggers ( |
149 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
150 | `pending_item_id` int(11), |
151 | `pending_item_type` varchar(255), |
152 | `due_at` datetime, |
153 | `trigger_method` varchar(255) |
154 | ) ENGINE=InnoDB; |
155 | |
156 | CREATE TABLE users ( |
157 | `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, |
158 | `login` varchar(255), |
159 | `password` varchar(255), |
160 | `email` text, |
161 | `name` text, |
162 | `notify_via_email` tinyint(1), |
163 | `notify_on_new_articles` tinyint(1), |
164 | `notify_on_comments` tinyint(1), |
165 | `notify_watch_my_articles` tinyint(1), |
166 | `notify_via_jabber` tinyint(1), |
167 | `jabber` varchar(255) |
168 | ) ENGINE=InnoDB; |
169 | |
170 | |
171 | -- indexes |
172 | |
173 | CREATE INDEX `blacklist_patterns_pattern_index` ON blacklist_patterns (`pattern`); |
174 | CREATE INDEX `categories_permalink_index` ON categories (`permalink`); |
175 | CREATE INDEX `contents_blog_id_index` ON contents (`blog_id`); |
176 | CREATE INDEX `contents_article_id_index` ON contents (`article_id`); |
177 | CREATE INDEX `page_caches_name_index` ON page_caches (`name`); |
178 | CREATE INDEX `pings_article_id_index` ON pings (`article_id`); |
179 | CREATE INDEX `sessions_sessid_index` ON sessions (`sessid`); |
180 | |
181 | -- data |
182 | |
183 | INSERT INTO sidebars (`config`, `staged_position`, `active_position`, `controller`) VALUES(NULL, NULL, 0, 'category'); |
184 | INSERT INTO sidebars (`config`, `staged_position`, `active_position`, `controller`) VALUES(NULL, NULL, 1, 'static'); |
185 | INSERT INTO sidebars (`config`, `staged_position`, `active_position`, `controller`) VALUES(NULL, NULL, 2, 'xml'); |
186 | INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('none', '--- [] |
187 | |
188 | ', 'None', '--- {} |
189 | |
190 | ', 'none'); |
191 | INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('markdown', '--- [] |
192 | |
193 | ', 'Markdown', '--- {} |
194 | |
195 | ', 'markdown'); |
196 | INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('smartypants', '--- |
197 | - :smartypants |
198 | ', 'SmartyPants', '--- {} |
199 | |
200 | ', 'none'); |
201 | INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('markdown smartypants', '--- |
202 | - :smartypants |
203 | ', 'Markdown with SmartyPants', '--- {} |
204 | |
205 | ', 'markdown'); |
206 | INSERT INTO text_filters (`name`, `filters`, `description`, `params`, `markup`) VALUES('textile', '--- [] |
207 | |
208 | ', 'Textile', '--- {} |
209 | |
210 | ', 'textile'); |
211 | |
212 | -- schema version meta-info |
213 | |
214 | CREATE TABLE schema_info ( |
215 | `version` int(11) |
216 | ) ENGINE=InnoDB; |
217 | |
218 | insert into schema_info (version) values (46); |