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:
- 5392 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 => 47) do |
6 | |
7 | create_table "articles_categories", :id => false, :force => true do |t| |
8 | t.column "article_id", :integer |
9 | t.column "category_id", :integer |
10 | t.column "primary_item", :integer |
11 | end |
12 | |
13 | create_table "articles_tags", :id => false, :force => true do |t| |
14 | t.column "article_id", :integer |
15 | t.column "tag_id", :integer |
16 | end |
17 | |
18 | create_table "blacklist_patterns", :force => true do |t| |
19 | t.column "type", :string, :limit => 15 |
20 | t.column "pattern", :string |
21 | end |
22 | |
23 | add_index "blacklist_patterns", ["pattern"], :name => "idx_blacklist_pattern" |
24 | |
25 | create_table "blogs", :force => true do |t| |
26 | t.column "settings", :text |
27 | end |
28 | |
29 | create_table "categories", :force => true do |t| |
30 | t.column "name", :string |
31 | t.column "position", :integer, :default => 0, :null => false |
32 | t.column "is_primary", :integer |
33 | t.column "permalink", :string |
34 | end |
35 | |
36 | add_index "categories", ["permalink"], :name => "categories_permalink_index" |
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 "body_html", :text |
44 | t.column "extended", :text |
45 | t.column "excerpt", :text |
46 | t.column "keywords", :string |
47 | t.column "created_at", :datetime |
48 | t.column "updated_at", :datetime |
49 | t.column "extended_html", :text |
50 | t.column "user_id", :integer |
51 | t.column "permalink", :string |
52 | t.column "guid", :string |
53 | t.column "text_filter_id", :integer |
54 | t.column "whiteboard", :text |
55 | t.column "article_id", :integer |
56 | t.column "email", :string |
57 | t.column "url", :string |
58 | t.column "ip", :string, :limit => 40 |
59 | t.column "blog_name", :string |
60 | t.column "name", :string |
61 | t.column "comments_count", :integer |
62 | t.column "trackbacks_count", :integer |
63 | t.column "published", :boolean, :default => false |
64 | t.column "allow_pings", :boolean |
65 | t.column "allow_comments", :boolean |
66 | t.column "blog_id", :integer |
67 | t.column "published_at", :datetime |
68 | t.column "state", :text |
69 | end |
70 | |
71 | add_index "contents", ["article_id"], :name => "contents_article_id_index" |
72 | add_index "contents", ["blog_id"], :name => "contents_blog_id_index" |
73 | |
74 | create_table "notifications", :id => false, :force => true do |t| |
75 | t.column "notify_user_id", :integer |
76 | t.column "notify_content_id", :integer |
77 | t.column "created_at", :datetime |
78 | t.column "updated_at", :datetime |
79 | end |
80 | |
81 | create_table "page_caches", :force => true do |t| |
82 | t.column "name", :string |
83 | end |
84 | |
85 | add_index "page_caches", ["name"], :name => "page_caches_name_index" |
86 | |
87 | create_table "pings", :force => true do |t| |
88 | t.column "article_id", :integer, :null => false |
89 | t.column "url", :string |
90 | t.column "created_at", :datetime |
91 | end |
92 | |
93 | add_index "pings", ["article_id"], :name => "idx_pings_article_id" |
94 | |
95 | create_table "redirects", :force => true do |t| |
96 | t.column "from_path", :string |
97 | t.column "to_path", :string |
98 | end |
99 | |
100 | create_table "resources", :force => true do |t| |
101 | t.column "size", :integer |
102 | t.column "filename", :string |
103 | t.column "mime", :string |
104 | t.column "created_at", :datetime |
105 | t.column "updated_at", :datetime |
106 | t.column "article_id", :integer |
107 | t.column "itunes_metadata", :boolean |
108 | t.column "itunes_author", :string |
109 | t.column "itunes_subtitle", :string |
110 | t.column "itunes_duration", :integer |
111 | t.column "itunes_summary", :text |
112 | t.column "itunes_keywords", :string |
113 | t.column "itunes_category", :string |
114 | t.column "itunes_explicit", :boolean |
115 | end |
116 | |
117 | create_table "sessions", :force => true do |t| |
118 | t.column "sessid", :string |
119 | t.column "data", :text |
120 | t.column "created_at", :datetime |
121 | t.column "updated_at", :datetime |
122 | end |
123 | |
124 | add_index "sessions", ["sessid"], :name => "sessions_sessid_index" |
125 | |
126 | create_table "sidebars", :force => true do |t| |
127 | t.column "active_position", :integer |
128 | t.column "controller", :string |
129 | t.column "staged_position", :integer |
130 | t.column "config", :string, :limit => nil |
131 | end |
132 | |
133 | create_table "tags", :force => true do |t| |
134 | t.column "name", :string |
135 | t.column "created_at", :datetime |
136 | t.column "updated_at", :datetime |
137 | t.column "display_name", :string |
138 | end |
139 | |
140 | create_table "text_filters", :force => true do |t| |
141 | t.column "name", :string |
142 | t.column "description", :string |
143 | t.column "markup", :string |
144 | t.column "filters", :text |
145 | t.column "params", :text |
146 | end |
147 | |
148 | create_table "triggers", :force => true do |t| |
149 | t.column "pending_item_id", :integer |
150 | t.column "pending_item_type", :string |
151 | t.column "due_at", :datetime |
152 | t.column "trigger_method", :string |
153 | end |
154 | |
155 | create_table "users", :force => true do |t| |
156 | t.column "login", :string, :limit => 40 |
157 | t.column "password", :string, :limit => 40 |
158 | t.column "email", :text |
159 | t.column "name", :text |
160 | t.column "notify_via_email", :boolean |
161 | t.column "notify_on_new_articles", :boolean |
162 | t.column "notify_on_comments", :boolean |
163 | t.column "notify_watch_my_articles", :boolean |
164 | t.column "notify_via_jabber", :boolean |
165 | t.column "jabber", :string |
166 | end |
167 | |
168 | add_index "users", ["login"], :name => "users_login_key", :unique => true |
169 | |
170 | end |