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:
- 3529 Bytes
1 | class InitialSchema < ActiveRecord::Migration |
2 | def self.up |
3 | ActiveRecord::Base.transaction do |
4 | create_table :users do |t| |
5 | t.column :login, :string |
6 | t.column :password, :string |
7 | end |
8 | |
9 | create_table :articles do |t| |
10 | t.column :title, :string |
11 | t.column :author, :string |
12 | t.column :body, :text |
13 | t.column :body_html, :text |
14 | t.column :extended, :text |
15 | t.column :excerpt, :text |
16 | t.column :keywords, :string |
17 | t.column :allow_comments, :integer |
18 | t.column :allow_pings, :integer |
19 | t.column :published, :integer, :default => 1 |
20 | t.column :text_filter, :string |
21 | t.column :created_at, :datetime |
22 | t.column :updated_at, :datetime |
23 | t.column :extended_html, :text |
24 | t.column :permalink, :string |
25 | end |
26 | |
27 | add_index :articles, :permalink |
28 | |
29 | create_table :categories do |t| |
30 | t.column :name, :string |
31 | t.column :position, :integer |
32 | end |
33 | |
34 | create_table :articles_categories, :id => false do |t| |
35 | t.column :article_id, :integer |
36 | t.column :category_id, :integer |
37 | t.column :is_primary, :integer |
38 | end |
39 | |
40 | create_table :blacklist_patterns do |t| |
41 | t.column :type, :string |
42 | t.column :pattern, :string |
43 | end |
44 | |
45 | add_index :blacklist_patterns, :pattern |
46 | |
47 | create_table :comments do |t| |
48 | t.column :article_id, :integer |
49 | t.column :title, :string |
50 | t.column :author, :string |
51 | t.column :email, :string |
52 | t.column :url, :string |
53 | t.column :ip, :string |
54 | t.column :body, :text |
55 | t.column :body_html, :text |
56 | t.column :created_at, :datetime |
57 | t.column :updated_at, :datetime |
58 | end |
59 | |
60 | add_index :comments, :article_id |
61 | |
62 | create_table :pings do |t| |
63 | t.column :article_id, :integer |
64 | t.column :url, :string |
65 | t.column :created_at, :datetime |
66 | end |
67 | |
68 | add_index :pings, :article_id |
69 | |
70 | create_table :resources do |t| |
71 | t.column :size, :integer |
72 | t.column :filename, :string |
73 | t.column :mime, :string |
74 | t.column :created_at, :datetime |
75 | t.column :updated_at, :datetime |
76 | end |
77 | |
78 | create_table :sessions do |t| |
79 | t.column :sessid, :string |
80 | t.column :data, :text |
81 | t.column :created_at, :datetime |
82 | t.column :updated_at, :datetime |
83 | end |
84 | |
85 | create_table :settings do |t| |
86 | t.column :name, :string |
87 | t.column :value, :string |
88 | t.column :position, :integer |
89 | end |
90 | |
91 | create_table :trackbacks do |t| |
92 | t.column :article_id, :integer |
93 | t.column :blog_name, :string |
94 | t.column :title, :string |
95 | t.column :excerpt, :string |
96 | t.column :url, :string |
97 | t.column :ip, :string |
98 | t.column :created_at, :datetime |
99 | t.column :updated_at, :datetime |
100 | end |
101 | |
102 | add_index :trackbacks, :article_id |
103 | end |
104 | end |
105 | |
106 | def self.down |
107 | ActiveRecord::Base.transaction do |
108 | remove_index :articles, :permalink |
109 | remove_index :blacklist_patterns, :pattern |
110 | remove_index :comments, :article_id |
111 | remove_index :pings, :article_id |
112 | remove_index :trackbacks, :article_id |
113 | |
114 | drop_table :users |
115 | drop_table :articles |
116 | drop_table :categories |
117 | drop_table :articles_categories |
118 | drop_table :blacklist_patterns |
119 | drop_table :comments |
120 | drop_table :pings |
121 | drop_table :resources |
122 | drop_table :sessions |
123 | drop_table :settings |
124 | drop_table :trackbacks |
125 | end |
126 | end |
127 | end |