Changesets can be listed by changeset number.
The Git repository is here.
- Revision:
- 15
- Log:
Attempt to update Typo to a Typo SVN HEAD release from around the
time the prototype installation was set up on the RISC OS Open Limited
web site. Timestamps place this at 04-Jul so a revision from 05-Jul or
earlier was pulled and copied over the 2.6.0 tarball stable code.
- Author:
- adh
- Date:
- Sat Jul 22 23:27:35 +0100 2006
- Size:
- 5454 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" integer, |
12 | "category_id" integer, |
13 | "is_primary" integer |
14 | ); |
15 | |
16 | CREATE TABLE articles_tags ( |
17 | "article_id" integer, |
18 | "tag_id" integer |
19 | ); |
20 | |
21 | CREATE TABLE blacklist_patterns ( |
22 | "id" INTEGER PRIMARY KEY NOT NULL, |
23 | "type" varchar(255), |
24 | "pattern" varchar(255) |
25 | ); |
26 | |
27 | CREATE TABLE blogs ( |
28 | "id" INTEGER PRIMARY KEY NOT NULL, |
29 | "settings" text |
30 | ); |
31 | |
32 | CREATE TABLE categories ( |
33 | "id" INTEGER PRIMARY KEY NOT NULL, |
34 | "name" varchar(255), |
35 | "position" integer, |
36 | "permalink" varchar(255) |
37 | ); |
38 | |
39 | CREATE TABLE contents ( |
40 | "id" INTEGER PRIMARY KEY NOT NULL, |
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" integer, |
53 | "permalink" varchar(255), |
54 | "guid" varchar(255), |
55 | "text_filter_id" integer, |
56 | "whiteboard" text, |
57 | "article_id" integer, |
58 | "email" varchar(255), |
59 | "url" varchar(255), |
60 | "ip" varchar(40), |
61 | "blog_name" varchar(255), |
62 | "name" varchar(255), |
63 | "comments_count" integer, |
64 | "trackbacks_count" integer, |
65 | "published" boolean DEFAULT 'f', |
66 | "allow_pings" boolean, |
67 | "allow_comments" boolean, |
68 | "blog_id" integer NOT NULL, |
69 | "published_at" datetime |
70 | ); |
71 | |
72 | CREATE TABLE notifications ( |
73 | "notify_user_id" integer, |
74 | "notify_content_id" integer, |
75 | "created_at" datetime, |
76 | "updated_at" datetime |
77 | ); |
78 | |
79 | CREATE TABLE page_caches ( |
80 | "id" INTEGER PRIMARY KEY NOT NULL, |
81 | "name" varchar(255) |
82 | ); |
83 | |
84 | CREATE TABLE pings ( |
85 | "id" INTEGER PRIMARY KEY NOT NULL, |
86 | "article_id" integer, |
87 | "url" varchar(255), |
88 | "created_at" datetime |
89 | ); |
90 | |
91 | CREATE TABLE redirects ( |
92 | "id" INTEGER PRIMARY KEY NOT NULL, |
93 | "from_path" varchar(255), |
94 | "to_path" varchar(255) |
95 | ); |
96 | |
97 | CREATE TABLE resources ( |
98 | "id" INTEGER PRIMARY KEY NOT NULL, |
99 | "size" integer, |
100 | "filename" varchar(255), |
101 | "mime" varchar(255), |
102 | "created_at" datetime, |
103 | "updated_at" datetime, |
104 | "article_id" integer, |
105 | "itunes_metadata" boolean, |
106 | "itunes_author" varchar(255), |
107 | "itunes_subtitle" varchar(255), |
108 | "itunes_duration" integer, |
109 | "itunes_summary" text, |
110 | "itunes_keywords" varchar(255), |
111 | "itunes_category" varchar(255), |
112 | "itunes_explicit" boolean |
113 | ); |
114 | |
115 | CREATE TABLE sessions ( |
116 | "id" INTEGER PRIMARY KEY NOT NULL, |
117 | "sessid" varchar(255), |
118 | "data" text, |
119 | "created_at" datetime, |
120 | "updated_at" datetime |
121 | ); |
122 | |
123 | CREATE TABLE sidebars ( |
124 | "id" INTEGER PRIMARY KEY NOT NULL, |
125 | "controller" varchar(255), |
126 | "active_position" integer, |
127 | "config" text, |
128 | "staged_position" integer |
129 | ); |
130 | |
131 | CREATE TABLE tags ( |
132 | "id" INTEGER PRIMARY KEY NOT NULL, |
133 | "name" varchar(255), |
134 | "created_at" datetime, |
135 | "updated_at" datetime, |
136 | "display_name" varchar(255) |
137 | ); |
138 | |
139 | CREATE TABLE text_filters ( |
140 | "id" INTEGER PRIMARY KEY NOT NULL, |
141 | "name" varchar(255), |
142 | "description" varchar(255), |
143 | "markup" varchar(255), |
144 | "filters" text, |
145 | "params" text |
146 | ); |
147 | |
148 | CREATE TABLE triggers ( |
149 | "id" INTEGER PRIMARY KEY NOT NULL, |
150 | "pending_item_id" integer, |
151 | "pending_item_type" varchar(255), |
152 | "due_at" datetime, |
153 | "trigger_method" varchar(255) |
154 | ); |
155 | |
156 | CREATE TABLE users ( |
157 | "id" INTEGER PRIMARY KEY NOT NULL, |
158 | "login" varchar(255), |
159 | "password" varchar(255), |
160 | "email" text, |
161 | "name" text, |
162 | "notify_via_email" boolean, |
163 | "notify_on_new_articles" boolean, |
164 | "notify_on_comments" boolean, |
165 | "notify_watch_my_articles" boolean, |
166 | "notify_via_jabber" boolean, |
167 | "jabber" varchar(255) |
168 | ); |
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" integer |
216 | ); |
217 | |
218 | insert into schema_info (version) values (46); |