rubycas-server/db/migrate/001_create_initial_structure.rb at 6a78edd9fba8cdf00743e0a9abb2821bf7799ac8 · rubycas/rubycas-server · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
class CreateInitialStructure < ActiveRecord::Migration[4.2]
  def self.up
    # Oracle table names cannot exceed 30 chars...
    # See http://code.google.com/p/rubycas-server/issues/detail?id=15
    create_table 'casserver_lt', :force => true do |t|
      t.string    'ticket',          :null => false
      t.timestamp 'created_on',      :null => false
      t.datetime  'consumed',        :null => true
      t.string    'client_hostname', :null => false
    end

    create_table 'casserver_st', :force => true do |t|
      t.string    'ticket',            :null => false
      t.text      'service',           :null => false
      t.timestamp 'created_on',        :null => false
      t.datetime  'consumed',          :null => true
      t.string    'client_hostname',   :null => false
      t.string    'username',          :null => false
      t.string    'type',              :null => false
      t.integer   'granted_by_pgt_id', :null => true
      t.integer   'granted_by_tgt_id', :null => true
    end

    create_table 'casserver_tgt', :force => true do |t|
      t.string    'ticket',           :null => false
      t.timestamp 'created_on',       :null => false
      t.string    'client_hostname',  :null => false
      t.string    'username',         :null => false
      t.text      'extra_attributes', :null => true
    end

    create_table 'casserver_pgt', :force => true do |t|
      t.string    'ticket',            :null => false
      t.timestamp 'created_on',        :null => false
      t.string    'client_hostname',   :null => false
      t.string    'iou',               :null => false
      t.integer   'service_ticket_id', :null => false
    end
  end # self.up

  def self.down
    drop_table 'casserver_pgt'
    drop_table 'casserver_tgt'
    drop_table 'casserver_st'
    drop_table 'casserver_lt'
  end # self.down
end