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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
require 'active_record'
ActiveRecord::Base.establish_connection(adapter: 'sqlite3', database: ':memory:')
ActiveRecord::Schema.verbose = false
ActiveRecord::Schema.define do
create_table :accounts, :force => true do |t|
t.integer :firm_id
t.string :firm_name
t.integer :credit_limit
end
create_table :companies, :force => true do |t|
t.string :type
t.integer :firm_id
t.string :firm_name
t.string :name
t.integer :client_of
t.integer :rating, :default => 1
t.integer :account_id
t.string :description, :default => ""
end
add_index :companies, [:firm_id, :type, :rating], :name => "company_index"
add_index :companies, [:firm_id, :type], :name => "company_partial_index", :where => "rating > 10"
create_table :keyboards, :force => true, :id => false do |t|
t.primary_key :key_number
t.string :name
end
create_table :people, :force => true do |t|
t.string :first_name, :null => false
t.string :gender, :limit => 1
t.string :comments
t.references :best_friend
t.references :best_friend_of
t.timestamps
end
create_table :subscribers, :force => true, :id => false do |t|
t.string :nick, :null => false
t.string :name
end
add_index :subscribers, :nick, :unique => true
create_table :tasks, :force => true do |t|
t.datetime :starting
t.datetime :ending
end
create_table :pirates, :force => true do |t|
end
create_table :groups, :force => true do |t|
end
create_table :memberships, :force => true do |t|
t.integer "group_id"
t.integer "pirate_id"
end
create_table :teams, :force => true
create_table :wolves, :force => true
create_table :vampires, :force => true
create_table :battles, :force => true do |t|
t.integer "team_id"
t.integer "battle_id"
t.string "battle_type"
end
end
QUOTED_TYPE = ActiveRecord::Base.connection.quote_column_name('type')
|
