-
Notifications
You must be signed in to change notification settings - Fork 1
/
migrations.moon
81 lines (65 loc) · 2.85 KB
/
migrations.moon
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
74
75
76
77
78
79
80
81
import create_table, types, add_column, drop_column, drop_table, rename_table from require "lapis.db.schema"
{
[1]: =>
create_table "users", {
{"id", types.serial primary_key: true}
{"name", types.text unique: true}
{"password", types.text}
}
[2]: =>
add_column "users", "logs", types.integer
add_column "users", "saplings", types.integer
add_column "users", "apples", types.integer
[3]: =>
drop_column "users", "logs"
drop_column "users", "saplings"
drop_column "users", "apples"
create_table "stuffs", {
{"id", types.serial primary_key: true}
{"user_id", types.foreign_key unique: true}
{"logs", types.integer}
{"saplings", types.integer}
{"apples", types.integer}
}
[4]: =>
drop_table "stuffs"
create_table "stuffs", {
{"id", types.serial primary_key: true}
{"user_id", types.foreign_key unique: true}
{"logs", types.integer default: 0}
{"saplings", types.integer default: 0}
{"apples", types.integer default: 0}
}
[5]: =>
add_column "stuffs", "wooden_planks", types.integer default: 0
add_column "stuffs", "crafting_tables", types.integer default: 0
[6]: =>
add_column "stuffs", "sticks", types.integer default: 0
add_column "stuffs", "wooden_axes", types.integer default: 0
[7]: =>
rename_table "stuffs", "resources"
[8]: =>
add_column "resources", "wooden_pickaxes", types.integer default: 0
add_column "resources", "wooden_shovels", types.integer default: 0
add_column "resources", "wooden_swords", types.integer default: 0
[9]: =>
add_column "resources", "cobblestone", types.integer default: 0
add_column "resources", "dirt", types.integer default: 0
[10]: =>
add_column "users", "digest", types.text default: "none"
add_column "resources", "stone_axes", types.integer default: 0
add_column "resources", "stone_pickaxes", types.integer default: 0
add_column "resources", "stone_shovels", types.integer default: 0
add_column "resources", "stone_swords", types.integer default: 0
add_column "resources", "coal", types.integer default: 0
[11]: =>
add_column "resources", "gravel", types.integer default: 0
add_column "resources", "flint", types.integer default: 0
add_column "resources", "clay", types.integer default: 0
add_column "resources", "torches", types.integer default: 0
add_column "resources", "tree_farms", types.integer default: 0
add_column "resources", "ideas", types.integer default: 0
[12]: =>
add_column "resources", "fence_posts", types.integer default: 0
add_column "resources", "fence_gates", types.integer default: 0
}