Ticket #8088: setup_table.rb

require 'rubygems'
require_gem 'activerecord'

# testing in ms sql server
=begin
ActiveRecord::Base::establish_connection(:adapter => 'sqlserver',
                                         :dsn => 'sql_server_db',
                                         :mode => 'odbc',
                                         :username => 'sa',
                                         :password => 'my_password')
=end

# testing in postgresql
ActiveRecord::Base::establish_connection(:adapter => 'postgresql',
                                         :database => 'ruby_development',
                                         :host => 'localhost',
                                         :username => 'postgres',
                                         :password => 'postgres')

if ActiveRecord::Base.connection.supports_migrations?
  ActiveRecord::Base.connection.create_table 'NowPlaying', :id => false do |t|
    t.column "NPId", :primary_key 
    t.column "EPlayListId", :integer
    t.column "EBubbleId", :integer
    t.column "ETrackId", :integer
    t.column "EStoreId", :integer
    t.column "PlayedDate", :datetime
    t.column "ContentType", :integer, :default => 1
  end
else
  ActiveRecord::Base.connection.execute(
  %{CREATE TABLE NowPlaying
    (
      "NPId" integer, 
      "EPlayListId" integer,
      "EBubbleId" integer,
      "ETrackId" integer,
      "EStoreId" integer,
      "PlayedDate" date,
      "ContentType" integer DEFAULT 1
    )})
    #TODO: manually set up NPId as a primary key
end