annotate .svn/pristine/bf/bfa97d9d559e780a8074d15bf06989f9711cacb8.svn-base @ 1519:afce8026aaeb redmine-2.4-integration

Merge from branch "live"
author Chris Cannam
date Tue, 09 Sep 2014 09:34:53 +0100
parents cbb26bc654de
children
rev   line source
Chris@909 1 ActiveRecord::Schema.define(:version => 0) do
Chris@909 2 create_table :pages, :force => true do |t|
Chris@909 3 t.column :version, :integer
Chris@909 4 t.column :title, :string, :limit => 255
Chris@909 5 t.column :body, :text
Chris@909 6 t.column :updated_on, :datetime
Chris@909 7 t.column :author_id, :integer
Chris@909 8 t.column :revisor_id, :integer
Chris@909 9 end
Chris@909 10
Chris@909 11 create_table :page_versions, :force => true do |t|
Chris@909 12 t.column :page_id, :integer
Chris@909 13 t.column :version, :integer
Chris@909 14 t.column :title, :string, :limit => 255
Chris@909 15 t.column :body, :text
Chris@909 16 t.column :updated_on, :datetime
Chris@909 17 t.column :author_id, :integer
Chris@909 18 t.column :revisor_id, :integer
Chris@909 19 end
Chris@909 20
Chris@909 21 create_table :authors, :force => true do |t|
Chris@909 22 t.column :page_id, :integer
Chris@909 23 t.column :name, :string
Chris@909 24 end
Chris@909 25
Chris@909 26 create_table :locked_pages, :force => true do |t|
Chris@909 27 t.column :lock_version, :integer
Chris@909 28 t.column :title, :string, :limit => 255
Chris@909 29 t.column :type, :string, :limit => 255
Chris@909 30 end
Chris@909 31
Chris@909 32 create_table :locked_pages_revisions, :force => true do |t|
Chris@909 33 t.column :page_id, :integer
Chris@909 34 t.column :version, :integer
Chris@909 35 t.column :title, :string, :limit => 255
Chris@909 36 t.column :version_type, :string, :limit => 255
Chris@909 37 t.column :updated_at, :datetime
Chris@909 38 end
Chris@909 39
Chris@909 40 create_table :widgets, :force => true do |t|
Chris@909 41 t.column :name, :string, :limit => 50
Chris@909 42 t.column :foo, :string
Chris@909 43 t.column :version, :integer
Chris@909 44 t.column :updated_at, :datetime
Chris@909 45 end
Chris@909 46
Chris@909 47 create_table :widget_versions, :force => true do |t|
Chris@909 48 t.column :widget_id, :integer
Chris@909 49 t.column :name, :string, :limit => 50
Chris@909 50 t.column :version, :integer
Chris@909 51 t.column :updated_at, :datetime
Chris@909 52 end
Chris@909 53
Chris@909 54 create_table :landmarks, :force => true do |t|
Chris@909 55 t.column :name, :string
Chris@909 56 t.column :latitude, :float
Chris@909 57 t.column :longitude, :float
Chris@909 58 t.column :version, :integer
Chris@909 59 end
Chris@909 60
Chris@909 61 create_table :landmark_versions, :force => true do |t|
Chris@909 62 t.column :landmark_id, :integer
Chris@909 63 t.column :name, :string
Chris@909 64 t.column :latitude, :float
Chris@909 65 t.column :longitude, :float
Chris@909 66 t.column :version, :integer
Chris@909 67 end
Chris@909 68 end