RISC OS Open: Bugs and sources: Browsing repository

You are currently browsing the Subversion repository.
Changesets can be listed by changeset number.
The Git repository is here.

root
» rool
» rails
» typo
» trunk
» db
» schema.sqlserver.sql

Revision:: 193

Log:

First stage commit of Typo 4.1, modified for the ROOL site.
Includes all local modifications but a final pass needs to be
made to delete any files left over from earlier Typo versions
that shouldn't be here anymore. See the 'tags' section of the
repository for a clean Typo 4.1 tree.

Note that symlinks to shared files in the RISC OS Open theme
directory have been deliberately included this time around; I
decided that on balance it was better to leave them in as
placeholders, since unlike symlinks in app/views/shared, the
Typo theme structure is not a standard Rails concept.

Author:: rool

Date:: Wed Apr 04 18:51:02 +0100 2007

Size:: 9113 Bytes

Show revision log

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_tags (
11	[article_id] integer DEFAULT NULL,
12	[tag_id] integer DEFAULT NULL
13	);
14
15	CREATE TABLE blacklist_patterns (
16	[id] int NOT NULL IDENTITY(1,
17	1) PRIMARY KEY,
18	[type] varchar(255) DEFAULT NULL,
19	[pattern] varchar(255) DEFAULT NULL
20	);
21
22	CREATE TABLE blogs (
23	[id] int NOT NULL IDENTITY(1,
24	1) PRIMARY KEY,
25	[settings] text DEFAULT NULL,
26	[base_url] varchar(255) DEFAULT NULL
27	);
28
29	CREATE TABLE categories (
30	[id] int NOT NULL IDENTITY(1,
31	1) PRIMARY KEY,
32	[name] varchar(255) DEFAULT NULL,
33	[position] integer DEFAULT NULL,
34	[permalink] varchar(255) DEFAULT NULL
35	);
36
37	CREATE TABLE categorizations (
38	[id] int NOT NULL IDENTITY(1,
39	1) PRIMARY KEY,
40	[article_id] integer DEFAULT NULL,
41	[category_id] integer DEFAULT NULL,
42	[is_primary] bit DEFAULT NULL
43	);
44
45	CREATE TABLE contents (
46	[id] int NOT NULL IDENTITY(1,
47	1) PRIMARY KEY,
48	[type] varchar(255) DEFAULT NULL,
49	[title] varchar(255) DEFAULT NULL,
50	[author] varchar(255) DEFAULT NULL,
51	[body] text DEFAULT NULL,
52	[extended] text DEFAULT NULL,
53	[excerpt] text DEFAULT NULL,
54	[keywords] varchar(255) DEFAULT NULL,
55	[created_at] datetime DEFAULT NULL,
56	[updated_at] datetime DEFAULT NULL,
57	[user_id] integer DEFAULT NULL,
58	[permalink] varchar(255) DEFAULT NULL,
59	[guid] varchar(255) DEFAULT NULL,
60	[text_filter_id] integer DEFAULT NULL,
61	[whiteboard] text DEFAULT NULL,
62	[name] varchar(255) DEFAULT NULL,
63	[published] bit DEFAULT 0,
64	[allow_pings] bit DEFAULT NULL,
65	[allow_comments] bit DEFAULT NULL,
66	[blog_id] integer NOT NULL,
67	[published_at] datetime DEFAULT NULL,
68	[state] text DEFAULT NULL
69	);
70
71	CREATE TABLE feedback (
72	[id] int NOT NULL IDENTITY(1,
73	1) PRIMARY KEY,
74	[type] varchar(255) DEFAULT NULL,
75	[title] varchar(255) DEFAULT NULL,
76	[author] varchar(255) DEFAULT NULL,
77	[body] text DEFAULT NULL,
78	[extended] text DEFAULT NULL,
79	[excerpt] text DEFAULT NULL,
80	[keywords] varchar(255) DEFAULT NULL,
81	[created_at] datetime DEFAULT NULL,
82	[updated_at] datetime DEFAULT NULL,
83	[user_id] integer DEFAULT NULL,
84	[permalink] varchar(255) DEFAULT NULL,
85	[guid] varchar(255) DEFAULT NULL,
86	[text_filter_id] integer DEFAULT NULL,
87	[whiteboard] text DEFAULT NULL,
88	[article_id] integer DEFAULT NULL,
89	[email] varchar(255) DEFAULT NULL,
90	[url] varchar(255) DEFAULT NULL,
91	[ip] varchar(40) DEFAULT NULL,
92	[blog_name] varchar(255) DEFAULT NULL,
93	[name] varchar(255) DEFAULT NULL,
94	[published] bit DEFAULT 0,
95	[allow_pings] bit DEFAULT NULL,
96	[allow_comments] bit DEFAULT NULL,
97	[blog_id] integer NOT NULL,
98	[published_at] datetime DEFAULT NULL,
99	[state] text DEFAULT NULL,
100	[status_confirmed] bit DEFAULT NULL
101	);
102
103	CREATE TABLE notifications (
104	[id] int NOT NULL IDENTITY(1,
105	1) PRIMARY KEY,
106	[content_id] integer DEFAULT NULL,
107	[user_id] integer DEFAULT NULL,
108	[created_at] datetime DEFAULT NULL,
109	[updated_at] datetime DEFAULT NULL
110	);
111
112	CREATE TABLE page_caches (
113	[id] int NOT NULL IDENTITY(1,
114	1) PRIMARY KEY,
115	[name] varchar(255) DEFAULT NULL
116	);
117
118	CREATE TABLE pings (
119	[id] int NOT NULL IDENTITY(1,
120	1) PRIMARY KEY,
121	[article_id] integer DEFAULT NULL,
122	[url] varchar(255) DEFAULT NULL,
123	[created_at] datetime DEFAULT NULL
124	);
125
126	CREATE TABLE redirects (
127	[id] int NOT NULL IDENTITY(1,
128	1) PRIMARY KEY,
129	[from_path] varchar(255) DEFAULT NULL,
130	[to_path] varchar(255) DEFAULT NULL
131	);
132
133	CREATE TABLE resources (
134	[id] int NOT NULL IDENTITY(1,
135	1) PRIMARY KEY,
136	[size] integer DEFAULT NULL,
137	[filename] varchar(255) DEFAULT NULL,
138	[mime] varchar(255) DEFAULT NULL,
139	[created_at] datetime DEFAULT NULL,
140	[updated_at] datetime DEFAULT NULL,
141	[article_id] integer DEFAULT NULL,
142	[itunes_metadata] bit DEFAULT NULL,
143	[itunes_author] varchar(255) DEFAULT NULL,
144	[itunes_subtitle] varchar(255) DEFAULT NULL,
145	[itunes_duration] integer DEFAULT NULL,
146	[itunes_summary] text DEFAULT NULL,
147	[itunes_keywords] varchar(255) DEFAULT NULL,
148	[itunes_category] varchar(255) DEFAULT NULL,
149	[itunes_explicit] bit DEFAULT NULL
150	);
151
152	CREATE TABLE sessions (
153	[id] int NOT NULL IDENTITY(1,
154	1) PRIMARY KEY,
155	[sessid] varchar(255) DEFAULT NULL,
156	[data] text DEFAULT NULL,
157	[created_at] datetime DEFAULT NULL,
158	[updated_at] datetime DEFAULT NULL
159	);
160
161	CREATE TABLE sidebars (
162	[id] int NOT NULL IDENTITY(1,
163	1) PRIMARY KEY,
164	[active_position] integer DEFAULT NULL,
165	[config] text DEFAULT NULL,
166	[staged_position] integer DEFAULT NULL,
167	[type] varchar(255) DEFAULT NULL,
168	[blog_id] integer DEFAULT NULL
169	);
170
171	CREATE TABLE tags (
172	[id] int NOT NULL IDENTITY(1,
173	1) PRIMARY KEY,
174	[name] varchar(255) DEFAULT NULL,
175	[created_at] datetime DEFAULT NULL,
176	[updated_at] datetime DEFAULT NULL,
177	[display_name] varchar(255) DEFAULT NULL
178	);
179
180	CREATE TABLE text_filters (
181	[id] int NOT NULL IDENTITY(1,
182	1) PRIMARY KEY,
183	[name] varchar(255) DEFAULT NULL,
184	[description] varchar(255) DEFAULT NULL,
185	[markup] varchar(255) DEFAULT NULL,
186	[filters] text DEFAULT NULL,
187	[params] text DEFAULT NULL
188	);
189
190	CREATE TABLE triggers (
191	[id] int NOT NULL IDENTITY(1,
192	1) PRIMARY KEY,
193	[pending_item_id] integer DEFAULT NULL,
194	[pending_item_type] varchar(255) DEFAULT NULL,
195	[due_at] datetime DEFAULT NULL,
196	[trigger_method] varchar(255) DEFAULT NULL
197	);
198
199	CREATE TABLE users (
200	[id] int NOT NULL IDENTITY(1,
201	1) PRIMARY KEY,
202	[login] varchar(255) DEFAULT NULL,
203	[password] varchar(255) DEFAULT NULL,
204	[email] text DEFAULT NULL,
205	[name] text DEFAULT NULL,
206	[notify_via_email] bit DEFAULT NULL,
207	[notify_on_new_articles] bit DEFAULT NULL,
208	[notify_on_comments] bit DEFAULT NULL,
209	[notify_watch_my_articles] bit DEFAULT NULL,
210	[notify_via_jabber] bit DEFAULT NULL,
211	[jabber] varchar(255) DEFAULT NULL
212	);
213
214
215	-- indexes
216
217	CREATE INDEX [index_blacklist_patterns_on_pattern] ON blacklist_patterns ([pattern]);
218	CREATE INDEX [index_categories_on_permalink] ON categories ([permalink]);
219	CREATE INDEX [index_contents_on_blog_id] ON contents ([blog_id]);
220	CREATE INDEX [index_contents_on_text_filter_id] ON contents ([text_filter_id]);
221	CREATE INDEX [index_contents_on_published] ON contents ([published]);
222	CREATE INDEX [index_feedback_on_text_filter_id] ON feedback ([text_filter_id]);
223	CREATE INDEX [index_feedback_on_article_id] ON feedback ([article_id]);
224	CREATE INDEX [index_page_caches_on_name] ON page_caches ([name]);
225	CREATE INDEX [index_pings_on_article_id] ON pings ([article_id]);
226	CREATE INDEX [index_sessions_on_sessid] ON sessions ([sessid]);
227
228	-- data
229
230	INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('none', '--- []
231
232	', 'None', '--- {}
233
234	', 'none');
235	INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('markdown', '--- []
236
237	', 'Markdown', '--- {}
238
239	', 'markdown');
240	INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('smartypants', '---
241	- :smartypants
242	', 'SmartyPants', '--- {}
243
244	', 'none');
245	INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('markdown smartypants', '---
246	- :smartypants
247	', 'Markdown with SmartyPants', '--- {}
248
249	', 'markdown');
250	INSERT INTO text_filters ([name], [filters], [description], [params], [markup]) VALUES('textile', '--- []
251
252	', 'Textile', '--- {}
253
254	', 'textile');
255
256	INSERT INTO sidebars ([id], [active_position], [config], [staged_position], [type], [blog_id]) VALUES (1, 0, '--- !map:HashWithIndifferentAccess \nempty: false\ncount: true\n', 0, 'CategorySidebar', 1);
257	INSERT INTO sidebars ([id], [active_position], [config], [staged_position], [type], [blog_id]) VALUES (2, 2, '--- !map:HashWithIndifferentAccess \nformat: rss20\ntrackbacks: false\ncomments: true\narticles: true\n', 2, 'XmlSidebar', 1);
258	INSERT INTO sidebars ([id], [active_position], [config], [staged_position], [type], [blog_id]) VALUES (3, 1, '--- !map:HashWithIndifferentAccess \nbody: "<ul>\\n <li><a href=\\"http://www.typosphere.org\\" title=\\"Typo\\">Typo</a></li>\\n <li><a href=\\"http://blog.leetsoft.com\\" title=\\"too-biased\\">too-biased</a></li>\\n <li><a href=\\"http://blog.remor.com/\\" title=\\"seth hall\\">Seth Hall</a></li>\\n <li><a href=\\"http://scottstuff.net\\" title=\\"Scottstuff\\">scottstuff.net</a></li>\\n <li><a href=\\"http://www.bofh.org.uk\\" title=\\"Just a Summary\\">Just A Summary</a></li>\\n <li><a href=\\"http://nubyonrails.com\\" title=\\"Topfunky\\">Topfunky</a></li>\\n <li><a href=\\"http://planettypo.com\\" title=\\"PlanetTypo\\">PlanetTypo</a></li>\\n <li><a href=\\"http://typoforums.org\\" title=\\"Typo Forums\\">Typo Forums</a></li>\\n <li><a href=\\"http://fredericdevillamil.com\\" title=\\"Fr\\xC3\\xA9d\\xC3\\xA9ric de Villamil\\">Fr\\xC3\\xA9d\\xC3\\xA9ric de Villamil</a></li>\\n\\\n </ul>\\n"\ntitle: Links\n', NULL, 'StaticSidebar', 1);
259
260
261	-- schema version meta-info
262
263	CREATE TABLE schema_info (
264	[version] integer DEFAULT NULL
265	);
266
267	insert into schema_info (version) values (61);

Download in other formats:

raw | text

Download in other formats:

Search tickets

Social

ROOL Store

Donate! Why?

RISC OS IPR

Options

RSS feeds