Changesets can be listed by changeset number.
The Git repository is here.
- Revision:
- 16
- Log:
Configured for temporary /rails/typo location on Alpha. Updated
several layouts for RISC OS Open Limited site style. Now produces
proper "Not found" page in redirect_controller.rb. Updates to
database schema from Typo SVN (small change in the way tables are
defined, but same tables end up being defined). Set location of
SendMail in vendor/rails/actionmailer/lib/action_mailer/base.rb.
- Author:
- adh
- Date:
- Sun Jul 23 10:51:56 +0100 2006
- Size:
- 5478 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, |
12 | [category_id] int, |
13 | [is_primary] int |
14 | ); |
15 | |
16 | CREATE TABLE articles_tags ( |
17 | [article_id] int, |
18 | [tag_id] int |
19 | ); |
20 | |
21 | CREATE TABLE blacklist_patterns ( |
22 | [id] int NOT NULL IDENTITY(1, |
23 | 1) PRIMARY KEY, |
24 | [type] varchar(255), |
25 | [pattern] varchar(255) |
26 | ); |
27 | |
28 | CREATE TABLE blogs ( |
29 | [id] int NOT NULL IDENTITY(1, |
30 | 1) PRIMARY KEY, |
31 | [settings] text |
32 | ); |
33 | |
34 | CREATE TABLE categories ( |
35 | [id] int NOT NULL IDENTITY(1, |
36 | 1) PRIMARY KEY, |
37 | [name] varchar(255), |
38 | [position] int, |
39 | [permalink] varchar(255) |
40 | ); |
41 | |
42 | CREATE TABLE contents ( |
43 | [id] int NOT NULL IDENTITY(1, |
44 | 1) PRIMARY KEY, |
45 | [type] varchar(255), |
46 | [title] varchar(255), |
47 | [author] varchar(255), |
48 | [body] text, |
49 | [body_html] text, |
50 | [extended] text, |
51 | [excerpt] text, |
52 | [keywords] varchar(255), |
53 | [created_at] datetime, |
54 | [updated_at] datetime, |
55 | [extended_html] text, |
56 | [user_id] int, |
57 | [permalink] varchar(255), |
58 | [guid] varchar(255), |
59 | [text_filter_id] int, |
60 | [whiteboard] text, |
61 | [article_id] int, |
62 | [email] varchar(255), |
63 | [url] varchar(255), |
64 | [ip] varchar(40), |
65 | [blog_name] varchar(255), |
66 | [name] varchar(255), |
67 | [comments_count] int, |
68 | [trackbacks_count] int, |
69 | [published] bit DEFAULT 0, |
70 | [allow_pings] bit, |
71 | [allow_comments] bit, |
72 | [blog_id] int NOT NULL, |
73 | [published_at] datetime |
74 | ); |
75 | |
76 | CREATE TABLE notifications ( |
77 | [notify_user_id] int, |
78 | [notify_content_id] int, |
79 | [created_at] datetime, |
80 | [updated_at] datetime |
81 | ); |
82 | |
83 | CREATE TABLE page_caches ( |
84 | [id] int NOT NULL IDENTITY(1, |
85 | 1) PRIMARY KEY, |
86 | [name] varchar(255) |
87 | ); |
88 | |
89 | CREATE TABLE pings ( |
90 | [id] int NOT NULL IDENTITY(1, |
91 | 1) PRIMARY KEY, |
92 | [article_id] int, |
93 | [url] varchar(255), |
94 | [created_at] datetime |
95 | ); |
96 | |
97 | CREATE TABLE redirects ( |
98 | [id] int NOT NULL IDENTITY(1, |
99 | 1) PRIMARY KEY, |
100 | [from_path] varchar(255), |
101 | [to_path] varchar(255) |
102 | ); |
103 | |
104 | CREATE TABLE resources ( |
105 | [id] int NOT NULL IDENTITY(1, |
106 | 1) PRIMARY KEY, |
107 | [size] int, |
108 | [filename] varchar(255), |
109 | [mime] varchar(255), |
110 | [created_at] datetime, |
111 | [updated_at] datetime, |
112 | [article_id] int, |
113 | [itunes_metadata] bit, |
114 | [itunes_author] varchar(255), |
115 | [itunes_subtitle] varchar(255), |
116 | [itunes_duration] int, |
117 | [itunes_summary] text, |
118 | [itunes_keywords] varchar(255), |
119 | [itunes_category] varchar(255), |
120 | [itunes_explicit] bit |
121 | ); |
122 | |
123 | CREATE TABLE sessions ( |
124 | [id] int NOT NULL IDENTITY(1, |
125 | 1) PRIMARY KEY, |
126 | [sessid] varchar(255), |
127 | [data] text, |
128 | [created_at] datetime, |
129 | [updated_at] datetime |
130 | ); |
131 | |
132 | CREATE TABLE sidebars ( |
133 | [id] int NOT NULL IDENTITY(1, |
134 | 1) PRIMARY KEY, |
135 | [controller] varchar(255), |
136 | [active_position] int, |
137 | [config] text, |
138 | [staged_position] int |
139 | ); |
140 | |
141 | CREATE TABLE tags ( |
142 | [id] int NOT NULL IDENTITY(1, |
143 | 1) PRIMARY KEY, |
144 | [name] varchar(255), |
145 | [created_at] datetime, |
146 | [updated_at] datetime, |
147 | [display_name] varchar(255) |
148 | ); |
149 | |
150 | CREATE TABLE text_filters ( |
151 | [id] int NOT NULL IDENTITY(1, |
152 | 1) PRIMARY KEY, |
153 | [name] varchar(255), |
154 | [description] varchar(255), |
155 | [markup] varchar(255), |
156 | [filters] text, |
157 | [params] text |
158 | ); |
159 | |
160 | CREATE TABLE triggers ( |
161 | [id] int NOT NULL IDENTITY(1, |
162 | 1) PRIMARY KEY, |
163 | [pending_item_id] int, |
164 | [pending_item_type] varchar(255), |
165 | [due_at] datetime, |
166 | [trigger_method] varchar(255) |
167 | ); |
168 | |
169 | CREATE TABLE users ( |
170 | [id] int NOT NULL IDENTITY(1, |
171 | 1) PRIMARY KEY, |
172 | [login] varchar(255), |
173 | [password] varchar(255), |
174 | [email] text, |
175 | [name] text, |
176 | [notify_via_email] bit, |
177 | [notify_on_new_articles] bit, |
178 | [notify_on_comments] bit, |
179 | [notify_watch_my_articles] bit, |
180 | [notify_via_jabber] bit, |
181 | [jabber] varchar(255) |
182 | ); |
183 | |
184 | |
185 | -- indexes |
186 | |
187 | CREATE INDEX blacklist_patterns_pattern_index ON blacklist_patterns (pattern); |
188 | CREATE INDEX categories_permalink_index ON categories (permalink); |
189 | CREATE INDEX contents_blog_id_index ON contents (blog_id); |
190 | CREATE INDEX contents_article_id_index ON contents (article_id); |
191 | CREATE INDEX page_caches_name_index ON page_caches (name); |
192 | CREATE INDEX pings_article_id_index ON pings (article_id); |
193 | CREATE INDEX sessions_sessid_index ON sessions (sessid); |
194 | |
195 | -- data |
196 | |
197 | INSERT INTO sidebars ([config], [staged_position], [active_position], [controller]) VALUES(NULL, NULL, 0, 'category'); |
198 | INSERT INTO sidebars ([config], [staged_position], [active_position], [controller]) VALUES(NULL, NULL, 1, 'static'); |
199 | INSERT INTO sidebars ([config], [staged_position], [active_position], [controller]) VALUES(NULL, NULL, 2, 'xml'); |
200 | INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('none', '--- [] |
201 | |
202 | ', 'None', '--- {} |
203 | |
204 | ', 'none'); |
205 | INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('markdown', '--- [] |
206 | |
207 | ', 'Markdown', '--- {} |
208 | |
209 | ', 'markdown'); |
210 | INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('smartypants', '--- |
211 | - :smartypants |
212 | ', 'SmartyPants', '--- {} |
213 | |
214 | ', 'none'); |
215 | INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('markdown smartypants', '--- |
216 | - :smartypants |
217 | ', 'Markdown with SmartyPants', '--- {} |
218 | |
219 | ', 'markdown'); |
220 | INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('textile', '--- [] |
221 | |
222 | ', 'Textile', '--- {} |
223 | |
224 | ', 'textile'); |
225 | |
226 | -- schema version meta-info |
227 | |
228 | CREATE TABLE schema_info ( |
229 | [version] int |
230 | ); |
231 | |
232 | insert into schema_info (version) values (46); |