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
|
# File 'lib/tkellem/migrations/001_init_db.rb', line 2
def self.up
create_table 'listen_addresses' do |t|
t.string 'address', :null => false
t.integer 'port', :null => false
t.boolean 'ssl', :null => false, :default => false
end
create_table 'users' do |t|
t.string 'username', :null => false
t.string 'password'
t.string 'role', :null => false, :default => 'user'
end
create_table 'networks' do |t|
t.belongs_to 'user'
t.string 'name', :null => false
end
create_table 'hosts' do |t|
t.belongs_to 'network'
t.string 'address', :null => false
t.integer 'port', :null => false
t.boolean 'ssl', :null => false, :default => false
end
create_table 'network_users' do |t|
t.belongs_to 'user'
t.belongs_to 'network'
t.string 'nick'
end
end
|