Changesets can be listed by changeset number.
The Git repository is here.
- 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:
- 6597 Bytes
1 | # This file is autogenerated. Instead of editing this file, please use the |
2 | # migrations feature of ActiveRecord to incrementally modify your database, and |
3 | # then regenerate this schema definition. |
4 | |
5 | ActiveRecord::Schema.define(:version => 61) do |
6 | |
7 | create_table "articles_tags", :id => false, :force => true do |t| |
8 | t.column "article_id", :integer |
9 | t.column "tag_id", :integer |
10 | end |
11 | |
12 | create_table "blacklist_patterns", :force => true do |t| |
13 | t.column "type", :string |
14 | t.column "pattern", :string |
15 | end |
16 | |
17 | add_index "blacklist_patterns", ["pattern"], :name => "blacklist_patterns_pattern_index" |
18 | |
19 | create_table "blogs", :force => true do |t| |
20 | t.column "settings", :text |
21 | t.column "base_url", :string |
22 | end |
23 | |
24 | create_table "categories", :force => true do |t| |
25 | t.column "name", :string |
26 | t.column "position", :integer |
27 | t.column "permalink", :string |
28 | end |
29 | |
30 | add_index "categories", ["permalink"], :name => "categories_permalink_index" |
31 | |
32 | create_table "categorizations", :force => true do |t| |
33 | t.column "article_id", :integer |
34 | t.column "category_id", :integer |
35 | t.column "is_primary", :boolean |
36 | end |
37 | |
38 | create_table "contents", :force => true do |t| |
39 | t.column "type", :string |
40 | t.column "title", :string |
41 | t.column "author", :string |
42 | t.column "body", :text |
43 | t.column "extended", :text |
44 | t.column "excerpt", :text |
45 | t.column "keywords", :string |
46 | t.column "created_at", :datetime |
47 | t.column "updated_at", :datetime |
48 | t.column "user_id", :integer |
49 | t.column "permalink", :string |
50 | t.column "guid", :string |
51 | t.column "text_filter_id", :integer |
52 | t.column "whiteboard", :text |
53 | t.column "name", :string |
54 | t.column "published", :boolean, :default => false |
55 | t.column "allow_pings", :boolean |
56 | t.column "allow_comments", :boolean |
57 | t.column "blog_id", :integer, :null => false |
58 | t.column "published_at", :datetime |
59 | t.column "state", :text |
60 | end |
61 | |
62 | add_index "contents", ["blog_id"], :name => "contents_blog_id_index" |
63 | add_index "contents", ["published"], :name => "index_contents_on_published" |
64 | add_index "contents", ["text_filter_id"], :name => "index_contents_on_text_filter_id" |
65 | |
66 | create_table "feedback", :force => true do |t| |
67 | t.column "type", :string |
68 | t.column "title", :string |
69 | t.column "author", :string |
70 | t.column "body", :text |
71 | t.column "excerpt", :text |
72 | t.column "created_at", :datetime |
73 | t.column "updated_at", :datetime |
74 | t.column "user_id", :integer |
75 | t.column "guid", :string |
76 | t.column "text_filter_id", :integer |
77 | t.column "whiteboard", :text |
78 | t.column "article_id", :integer |
79 | t.column "email", :string |
80 | t.column "url", :string |
81 | t.column "ip", :string, :limit => 40 |
82 | t.column "blog_name", :string |
83 | t.column "published", :boolean, :default => false |
84 | t.column "blog_id", :integer, :null => false |
85 | t.column "published_at", :datetime |
86 | t.column "state", :text |
87 | t.column "status_confirmed", :boolean |
88 | end |
89 | |
90 | add_index "feedback", ["article_id"], :name => "index_feedback_on_article_id" |
91 | add_index "feedback", ["text_filter_id"], :name => "index_feedback_on_text_filter_id" |
92 | |
93 | create_table "notifications", :force => true do |t| |
94 | t.column "content_id", :integer |
95 | t.column "user_id", :integer |
96 | t.column "created_at", :datetime |
97 | t.column "updated_at", :datetime |
98 | end |
99 | |
100 | create_table "page_caches", :force => true do |t| |
101 | t.column "name", :string |
102 | end |
103 | |
104 | add_index "page_caches", ["name"], :name => "page_caches_name_index" |
105 | |
106 | create_table "pings", :force => true do |t| |
107 | t.column "article_id", :integer |
108 | t.column "url", :string |
109 | t.column "created_at", :datetime |
110 | end |
111 | |
112 | add_index "pings", ["article_id"], :name => "pings_article_id_index" |
113 | |
114 | create_table "redirects", :force => true do |t| |
115 | t.column "from_path", :string |
116 | t.column "to_path", :string |
117 | end |
118 | |
119 | create_table "resources", :force => true do |t| |
120 | t.column "size", :integer |
121 | t.column "filename", :string |
122 | t.column "mime", :string |
123 | t.column "created_at", :datetime |
124 | t.column "updated_at", :datetime |
125 | t.column "article_id", :integer |
126 | t.column "itunes_metadata", :boolean |
127 | t.column "itunes_author", :string |
128 | t.column "itunes_subtitle", :string |
129 | t.column "itunes_duration", :integer |
130 | t.column "itunes_summary", :text |
131 | t.column "itunes_keywords", :string |
132 | t.column "itunes_category", :string |
133 | t.column "itunes_explicit", :boolean |
134 | end |
135 | |
136 | create_table "sessions", :force => true do |t| |
137 | t.column "sessid", :string |
138 | t.column "data", :text |
139 | t.column "created_at", :datetime |
140 | t.column "updated_at", :datetime |
141 | end |
142 | |
143 | add_index "sessions", ["sessid"], :name => "sessions_sessid_index" |
144 | |
145 | create_table "sidebars", :force => true do |t| |
146 | t.column "active_position", :integer |
147 | t.column "config", :text |
148 | t.column "staged_position", :integer |
149 | t.column "type", :string |
150 | t.column "blog_id", :integer |
151 | end |
152 | |
153 | create_table "tags", :force => true do |t| |
154 | t.column "name", :string |
155 | t.column "created_at", :datetime |
156 | t.column "updated_at", :datetime |
157 | t.column "display_name", :string |
158 | end |
159 | |
160 | create_table "text_filters", :force => true do |t| |
161 | t.column "name", :string |
162 | t.column "description", :string |
163 | t.column "markup", :string |
164 | t.column "filters", :text |
165 | t.column "params", :text |
166 | end |
167 | |
168 | create_table "triggers", :force => true do |t| |
169 | t.column "pending_item_id", :integer |
170 | t.column "pending_item_type", :string |
171 | t.column "due_at", :datetime |
172 | t.column "trigger_method", :string |
173 | end |
174 | |
175 | create_table "users", :force => true do |t| |
176 | t.column "login", :string |
177 | t.column "password", :string |
178 | t.column "email", :text |
179 | t.column "name", :text |
180 | t.column "notify_via_email", :boolean |
181 | t.column "notify_on_new_articles", :boolean |
182 | t.column "notify_on_comments", :boolean |
183 | t.column "notify_watch_my_articles", :boolean |
184 | t.column "notify_via_jabber", :boolean |
185 | t.column "jabber", :string |
186 | end |
187 | |
188 | end |