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
|
# File 'lib/kmdb/migrations/01_kmdb_initial.rb', line 11
def up
execute "SET character_set_database = 'utf8'"
create_table :events do |t|
t.integer :user_id
t.integer :n
t.datetime :t
end
add_index :events, [:n], using: :hash
add_index :events, [:user_id], using: :hash
add_index :events, [:user_id, :n, :t]
create_table :keys do |t|
t.string :string
end
add_index :keys, [:string], using: :hash, unique: true
create_table :properties do |t|
t.integer :user_id
t.integer :event_id
t.integer :key
t.datetime :t
t.string :value
end
add_index :properties, [:key], using: :hash
add_index :properties, [:user_id], using: :hash
add_index :properties, [:event_id], using: :hash
add_index :properties, [:user_id, :key, :t]
create_table :users do |t|
t.string :name, limit: 48
end
add_index :users, [:name], using: :hash, unique: true
create_table :ignored_users do |t|
t.string :name, limit: 48
end
create_table :whitelisted_events do |t|
t.string :name
end
create_table :aliases do |t|
t.string :name1, limit: 48
t.string :name2, limit: 48
t.datetime :t
end
add_index :aliases, [:name1], using: :hash
add_index :aliases, [:name2], using: :hash
create_table :dumpfiles do |t|
t.integer :revision
t.integer :length
t.integer :offset
t.timestamps
end
add_index :dumpfiles, [:revision]
end
|