Mercurial > hg > soundsoftware-site

annotate lib/plugins/acts_as_versioned/test/schema.rb @ 1295:622f24f53b42 redmine-2.3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Update to Redmine SVN revision 11972 on 2.3-stable branch
author Chris Cannam
date Fri, 14 Jun 2013 09:02:21 +0100
parents 433d4f72a19b
children
rev   line source
Chris@0 1 ActiveRecord::Schema.define(:version => 0) do
Chris@0 2 create_table :pages, :force => true do |t|
Chris@0 3 t.column :version, :integer
Chris@0 4 t.column :title, :string, :limit => 255
Chris@0 5 t.column :body, :text
Chris@0 6 t.column :updated_on, :datetime
Chris@0 7 t.column :author_id, :integer
Chris@0 8 t.column :revisor_id, :integer
Chris@0 9 end
Chris@0 10
Chris@0 11 create_table :page_versions, :force => true do |t|
Chris@0 12 t.column :page_id, :integer
Chris@0 13 t.column :version, :integer
Chris@0 14 t.column :title, :string, :limit => 255
Chris@0 15 t.column :body, :text
Chris@0 16 t.column :updated_on, :datetime
Chris@0 17 t.column :author_id, :integer
Chris@0 18 t.column :revisor_id, :integer
Chris@0 19 end
Chris@0 20
Chris@0 21 create_table :authors, :force => true do |t|
Chris@0 22 t.column :page_id, :integer
Chris@0 23 t.column :name, :string
Chris@0 24 end
Chris@0 25
Chris@0 26 create_table :locked_pages, :force => true do |t|
Chris@0 27 t.column :lock_version, :integer
Chris@0 28 t.column :title, :string, :limit => 255
Chris@0 29 t.column :type, :string, :limit => 255
Chris@0 30 end
Chris@0 31
Chris@0 32 create_table :locked_pages_revisions, :force => true do |t|
Chris@0 33 t.column :page_id, :integer
Chris@0 34 t.column :version, :integer
Chris@0 35 t.column :title, :string, :limit => 255
Chris@0 36 t.column :version_type, :string, :limit => 255
Chris@0 37 t.column :updated_at, :datetime
Chris@0 38 end
Chris@0 39
Chris@0 40 create_table :widgets, :force => true do |t|
Chris@0 41 t.column :name, :string, :limit => 50
Chris@0 42 t.column :foo, :string
Chris@0 43 t.column :version, :integer
Chris@0 44 t.column :updated_at, :datetime
Chris@0 45 end
Chris@0 46
Chris@0 47 create_table :widget_versions, :force => true do |t|
Chris@0 48 t.column :widget_id, :integer
Chris@0 49 t.column :name, :string, :limit => 50
Chris@0 50 t.column :version, :integer
Chris@0 51 t.column :updated_at, :datetime
Chris@0 52 end
Chris@0 53
Chris@0 54 create_table :landmarks, :force => true do |t|
Chris@0 55 t.column :name, :string
Chris@0 56 t.column :latitude, :float
Chris@0 57 t.column :longitude, :float
Chris@0 58 t.column :version, :integer
Chris@0 59 end
Chris@0 60
Chris@0 61 create_table :landmark_versions, :force => true do |t|
Chris@0 62 t.column :landmark_id, :integer
Chris@0 63 t.column :name, :string
Chris@0 64 t.column :latitude, :float
Chris@0 65 t.column :longitude, :float
Chris@0 66 t.column :version, :integer
Chris@0 67 end
Chris@0 68 end