Contents

class CreateCasDatabase < ActiveRecord::Migration
  def self.up
    create_table :login_tickets,   :force => true do |t|
      t.column :ticket,           :string,    :null => false
      t.column :client_hostname,  :string,    :null => false
      t.column :consumed_at,      :datetime,  :null => true
      t.column :created_at,       :datetime,  :null => false
    end

    create_table :service_tickets,   :force => true do |t|
      t.column :proxy_granting_ticket_id,     :integer, :null => true
      t.column :ticket_granting_ticket_id,    :integer, :null => true

      t.column :ticket,           :string,    :null => false
      t.column :client_hostname,  :string,    :null => false
      t.column :service,          :text,      :null => false
      t.column :username,         :string,    :null => false
      t.column :type,             :string,    :null => true
      t.column :consumed_at,      :datetime,  :null => true
      t.column :created_at,       :datetime,  :null => false
    end

    create_table :ticket_granting_tickets,  :force => true do |t|
      t.column :ticket,           :string,    :null => false
      t.column :client_hostname,  :string,    :null => false
      t.column :username,         :string,    :null => false

      t.column :created_at,       :datetime,  :null => false
    end

    create_table :proxy_granting_tickets,  :force => true do |t|
      t.column :service_ticket_id,  :integer,   :null => false

      t.column :ticket,             :string,    :null => false
      t.column :client_hostname,    :string,    :null => false
      t.column :iou,                :string,    :null => false
      t.column :created_at,         :datetime,  :null => false
    end
  end

  def self.down
    drop_table :proxy_granting_tickets
    drop_table :ticket_granting_tickets
    drop_table :service_tickets
    drop_table :login_tickets
  end
end

Version data entries

27 entries across 27 versions & 6 rubygems

Version	Path
3mix-castronaut-0.5.0.2	lib/castronaut/db/001_create_cas_database.rb
masover-castronaut-0.4.4.4	lib/castronaut/db/001_create_cas_database.rb
masover-castronaut-0.4.4.5	lib/castronaut/db/001_create_cas_database.rb
masover-castronaut-0.5.0.1	lib/castronaut/db/001_create_cas_database.rb
p8-castronaut-0.6.1.1	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.2.0	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.2.5	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.3.0	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.3.5	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.3.6	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.4.1	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.4.2	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.4.3	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.4.4	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.4.5	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.4.6	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.5.0	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.5.1	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.5.2	lib/castronaut/db/001_create_cas_database.rb
relevance-castronaut-0.5.3	lib/castronaut/db/001_create_cas_database.rb