migration.rb

# encoding: utf-8

#创建Admin表
class AddAdmin < ActiveRecord::Migration
	def self.up
		create_table :admins do |t|
			t.string :adminname
			t.string :adminpwd
		end
	end

	def self.down
		drop_table :admins
	end
end

if not Admin.table_exists?
	AddAdmin.up
end

#创建User表
class AddUser < ActiveRecord::Migration
	def self.up
		create_table :users do |t|
			t.string :login_id
			t.string :password
			t.string :real_name
			t.string :ceilphone
			t.string :qq
			t.string :address
			t.string :gender
			t.string :email
			t.string :privilege
			t.string :use_flag
			t.string :last_login
			t.string :add_id
			t.string :add_date
			t.string :upd_id
			t.string :upd_date
		end
	end

	def self.down
		drop_table :users
	end
end

if not User.table_exists?
	AddUser.up
end

#create TypeOne
class AddTypeOne < ActiveRecord::Migration 
	def self.up
		create_table :type_ones do |t|
			t.string :name
			t.string :use_flag
			t.string :type_no
			t.string :name_s
			t.string :add_id
			t.string :add_date
			t.string :upd_id
			t.string :upd_date
		end
	end

	def self.down
		drop_table :type_ones
	end
end

if not TypeOne.table_exists?
	AddTypeOne.up
end

#create TypeTwo
class AddTypeTwo < ActiveRecord::Migration 
	def self.up
		create_table :type_twos do |t|
			t.string :name
			t.string :type_no
			t.string :name_s
			t.string :type_one_id
			t.string :use_flag
			t.string :add_id
			t.string :add_date
			t.string :upd_id
			t.string :upd_date
		end
	end

	def self.down
		drop_table :type_twos
	end
end

if not TypeTwo.table_exists?
	AddTypeTwo.up
end

#create TypeThree
class AddTypeThree < ActiveRecord::Migration 
	def self.up
		create_table :type_threes do |t|
			t.string :name
			t.string :type_no
			t.string :name_s
			t.integer :type_one_id
			t.string :type_one_no
			t.string :type_one_name
			t.integer :type_two_id
			t.string :type_two_name
			t.string :type_two_no
			t.string :use_flag
			t.string :add_id
			t.string :add_date
			t.string :upd_id
			t.string :upd_date
		end
	end

	def self.down
		drop_table :type_threes
	end
end

if not TypeThree.table_exists?
	AddTypeThree.up
end

#create suppliers
class AddSupplier < ActiveRecord::Migration 
	def self.up
		create_table :suppliers do |t|
			t.string :name
			t.string :name_s
			t.string :address
			t.string :telphone
			t.string :ceilphone
			t.string :fax
			t.string :remark
			t.string :supp_flag	
			t.string :use_flag
			t.string :add_id
			t.string :add_date
			t.string :upd_id
			t.string :upd_date
		end
	end

	def self.down
		drop_table :suppliers
	end
end

if not Supplier.table_exists?
	AddSupplier.up
end


#create shevles
class AddShevle < ActiveRecord::Migration 
	def self.up
		create_table :shevles do |t|
			t.string :name
			t.string :no
			t.string :shevle_type
			t.string :remark
			t.string :spec
			t.string :use_flag
			t.string :add_id
			t.string :add_date
			t.string :upd_id
			t.string :upd_date
		end
	end

	def self.down
		drop_table :shevles
	end
end

if not Shevle.table_exists?
	AddShevle.up
end

#create goods
class AddGood < ActiveRecord::Migration 
	def self.up
		create_table :goods do |t|
			t.string :no
			t.string :spec
			t.string :name
			t.string :name_s
			t.string :picture
			t.string :barcode
			t.string :unit
			t.integer :unit_price
			t.integer :price
			t.string :area
			t.string :produce_date
			t.string :valildity_date
			t.string :shevle_id
			t.integer :shevle_least
			t.integer :shevle_most
			t.integer :stock_most
			t.integer :stock_least
			t.string :supplier_id
			t.string :supplier_name
			t.integer :type_one_id
			t.integer :type_two_id
			t.integer :type_three_id
			t.string :use_flag
			t.string :add_id
			t.string :add_date
			t.string :upd_id
			t.string :upd_date
		end
	end

	def self.down
		drop_table :goods
	end
end

if not Good.table_exists?
	AddGood.up
end

#create purchase
class AddPurchase < ActiveRecord::Migration 
	def self.up
		create_table :purchases do |t|
			t.string 	:no
			t.integer 	:good_id
			t.integer 	:type_one_id
			t.integer 	:type_two_id
			t.integer 	:type_three_id
			t.string 	:good_name
			t.string 	:good_unit
			t.string 	:pur_count
			t.string 	:pur_date
			t.string 	:pur_id
			t.string 	:unit
			t.integer 	:unit_price
			t.string 	:supplier_id
			t.string 	:supplier_name
			t.string 	:enforce_code
			t.string 	:check_flag
			t.string 	:remark
			t.string 	:use_flag
			t.string 	:add_id
			t.string 	:add_date
			t.string 	:upd_id
			t.string 	:upd_date
		end
	end

	def self.down
		drop_table :purchases
	end
end

if not Purchase.table_exists?
	AddPurchase.up
end


#create inventory
class AddInventory < ActiveRecord::Migration 
	def self.up
		create_table :inventorys do |t|
			t.integer 	:purchase_id
			t.string 	:purchase_no
			t.integer 	:good_id
			t.integer 	:type_one_id
			t.integer 	:type_two_id
			t.integer 	:type_three_id
			t.string 	:good_name
			t.string 	:good_barcode
			t.string 	:good_unit
			t.string 	:unit_price
			t.integer 	:quantity
			t.string 	:arrival_date
			t.string 	:produce_date
			t.string 	:expiry_date
			t.string 	:supplier_id
			t.string 	:supplier_name
			t.string 	:enforce_code
			t.string 	:check_flag
			t.string 	:remark
			t.string 	:use_flag
			t.string 	:main_flag
			t.string 	:add_id
			t.string 	:add_date
			t.string 	:upd_id
			t.string 	:upd_date
		end
	end

	def self.down
		drop_table :inventorys
	end
end

if not Inventory.table_exists?
	AddInventory.up
end

#create inventory
class AddInventoryMX < ActiveRecord::Migration 
	def self.up
		create_table :inventorys_mx do |t|
			t.integer 	:purchase_id
			t.string 	:purchase_no
			t.integer 	:good_id
			t.integer 	:type_one_id
			t.integer 	:type_two_id
			t.integer 	:type_three_id
			t.string 	:good_name
			t.string 	:good_barcode
			t.string 	:good_unit
			t.string 	:unit_price
			t.integer 	:quantity
			t.string 	:arrival_date
			t.string 	:produce_date
			t.string 	:expiry_date
			t.string 	:supplier_id
			t.string 	:supplier_name
			t.string 	:enforce_code
			t.string 	:reason_flag
			t.string 	:use_flag
			t.string 	:main_flag
			t.string 	:add_id
			t.string 	:add_date
			t.string 	:upd_id
			t.string 	:upd_date
		end
	end

	def self.down
		drop_table :inventorys_mx
	end
end

if not InventoryMX.table_exists?
	AddInventoryMX.up
end