/
changelog-1.1.groovy
142 lines (111 loc) · 5.52 KB
/
changelog-1.1.groovy
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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
databaseChangeLog = {
changeSet(author: "pledbrook (generated)", id: "1310034469414-3") {
createTable(tableName: "role_permissions") {
column(name: "role_id", type: "bigint")
column(name: "permissions_string", type: "varchar(255)")
}
}
// This changeset is required if the changelog is executed against an InnoDB database.
// Without it, later changesets fail due to problems creating associated foreign keys.
changeSet(author: "pledbrook", id: "FixRolePermissionsTableType") {
sql('ALTER TABLE role_permissions ENGINE=MyISAM')
}
changeSet(author: "pledbrook (generated)", id: "1320427106545-1") {
createTable(tableName: "bi_images") {
column(autoIncrement: "true", name: "id", type: "bigint") {
constraints(nullable: "false", primaryKey: "true", primaryKeyName: "bi_imagesPK")
}
column(name: "version", type: "bigint") {
constraints(nullable: "false")
}
column(name: "data", type: "longblob") {
constraints(nullable: "false")
}
column(name: "type", type: "varchar(255)") {
constraints(nullable: "false")
}
}
}
changeSet(author: "pledbrook (generated)", id: "1320427106545-2") {
createTable(tableName: "like_dislike") {
column(autoIncrement: "true", name: "id", type: "bigint") {
constraints(nullable: "false", primaryKey: "true", primaryKeyName: "like_dislikePK")
}
column(name: "version", type: "bigint") {
constraints(nullable: "false")
}
column(name: "vote", type: "integer") {
constraints(nullable: "false")
}
column(name: "what_id", type: "bigint") {
constraints(nullable: "false")
}
column(name: "what_type", type: "varchar(255)") {
constraints(nullable: "false")
}
column(name: "who_id", type: "varchar(255)") {
constraints(nullable: "false")
}
}
}
changeSet(author: "pledbrook (generated)", id: "1320427106545-5") {
createTable(tableName: "web_site") {
column(autoIncrement: "true", name: "id", type: "bigint") {
constraints(nullable: "false", primaryKey: "true", primaryKeyName: "web_sitePK")
}
column(name: "version", type: "bigint") {
constraints(nullable: "false")
}
column(name: "date_created", type: "datetime") {
constraints(nullable: "false")
}
column(name: "description", type: "longtext") {
constraints(nullable: "false")
}
column(name: "popularity_disliked", type: "integer") {
constraints(nullable: "false")
}
column(name: "popularity_liked", type: "integer") {
constraints(nullable: "false")
}
column(name: "popularity_net_liked", type: "integer") {
constraints(nullable: "false")
}
column(name: "title", type: "varchar(255)") {
constraints(nullable: "false")
}
column(name: "url", type: "varchar(255)") {
constraints(nullable: "false")
}
}
}
changeSet(author: "pledbrook (generated)", id: "1320427106545-6") {
createTable(tableName: "web_site_bi_image") {
column(name: "web_site_bi_image_id", type: "bigint")
column(name: "image_id", type: "bigint")
column(name: "bi_image_idx", type: "varchar(255)")
}
}
changeSet(author: "pledbrook (generated)", id: "1320427106545-18") {
createIndex(indexName: "name_unique_1320427106197", tableName: "role", unique: "true") {
column(name: "name")
}
}
changeSet(author: "pledbrook (generated)", id: "1320427106545-19") {
createIndex(indexName: "FKEAD9D23B75B39296", tableName: "role_permissions") {
column(name: "role_id")
}
}
changeSet(author: "pledbrook (generated)", id: "1310034469414-28") {
addForeignKeyConstraint(baseColumnNames: "role_id", baseTableName: "role_permissions", constraintName: "FKEAD9D23B75B39296", deferrable: "false", initiallyDeferred: "false", referencedColumnNames: "id", referencedTableName: "role", referencesUniqueColumn: "false")
}
changeSet(author: "pledbrook (generated)", id: "1310034469414-32") {
addForeignKeyConstraint(baseColumnNames: "user_id", baseTableName: "user_info", constraintName: "FK1437D8A21ADE5676", deferrable: "false", initiallyDeferred: "false", referencedColumnNames: "id", referencedTableName: "user", referencesUniqueColumn: "false")
}
changeSet(author: "pledbrook (generated)", id: "1310034469414-33") {
addForeignKeyConstraint(baseColumnNames: "role_id", baseTableName: "user_role", constraintName: "FK143BF46A75B39296", deferrable: "false", initiallyDeferred: "false", referencedColumnNames: "id", referencedTableName: "role", referencesUniqueColumn: "false")
}
changeSet(author: "pledbrook (generated)", id: "1310034469414-34") {
addForeignKeyConstraint(baseColumnNames: "user_roles_id", baseTableName: "user_role", constraintName: "FK143BF46A16D0D038", deferrable: "false", initiallyDeferred: "false", referencedColumnNames: "id", referencedTableName: "user", referencesUniqueColumn: "false")
}
}