Skip to content

Commit 4b85f2b

Browse files
SasSwartSasSwart
committed
chore(coderd/database): renumber migration
1 parent cf3afd4 commit 4b85f2b

3 files changed

+93
-93
lines changed

‎coderd/database/migrations/000261_improve_notification_templates.down.sql

Lines changed: 0 additions & 83 deletions
This file was deleted.

‎coderd/database/migrations/000262_improve_notification_templates.down.sql

Lines changed: 83 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,83 @@
1+
UPDATE notification_templates
2+
SET
3+
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', 'Hi {{.UserName}}')::text
4+
WHERE
5+
id = '29a09665-2a4c-403f-9648-54301670e7be';
6+
7+
UPDATE notification_templates
8+
SET
9+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},\n', E'Hi {{.UserName}},')::text
10+
WHERE
11+
id = '9f5af851-8408-4e73-a7a1-c6502ba46689';
12+
13+
UPDATE notification_templates
14+
SET
15+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},\n', E'Hi {{.UserName}},')::text
16+
WHERE
17+
id = 'b02ddd82-4733-4d02-a2d7-c36f3598997d';
18+
19+
UPDATE notification_templates
20+
SET
21+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},\n', E'Hi {{.UserName}}')::text
22+
WHERE
23+
id = 'c34a0c09-0704-4cac-bd1c-0c0146811c2b';
24+
25+
UPDATE notification_templates
26+
SET
27+
body_template = REPLACE(body_template::text, E'({{.Labels.template_version_name}}).\n\n', E'({{.Labels.template_version_name}}).\n')::text
28+
WHERE
29+
id = 'c34a0c09-0704-4cac-bd1c-0c0146811c2b';
30+
31+
UPDATE notification_templates
32+
SET
33+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},\n', E'Hi {{.UserName}}')::text
34+
WHERE
35+
id = '381df2a9-c0c0-4749-420f-80a9280c66f9';
36+
37+
UPDATE notification_templates
38+
SET
39+
body_template = REPLACE(body_template::text, E'\nThe specified reason', E'The specified reason')::text
40+
WHERE
41+
id = '381df2a9-c0c0-4749-420f-80a9280c66f9';
42+
43+
UPDATE notification_templates
44+
SET
45+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},', E'Hi {{.UserName}}')::text
46+
WHERE
47+
id = 'f517da0b-cdc9-410f-ab89-a86107c420ed';
48+
49+
UPDATE notification_templates
50+
SET
51+
body_template = REPLACE(body_template::text, E'\nThe specified reason', E'The specified reason')::text
52+
WHERE
53+
id = 'f517da0b-cdc9-410f-ab89-a86107c420ed';
54+
55+
UPDATE notification_templates
56+
SET
57+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},', E'Hi {{.UserName}}')::text
58+
WHERE
59+
id = '0ea69165-ec14-4314-91f1-69566ac3c5a0';
60+
61+
UPDATE notification_templates
62+
SET
63+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},', E'Hi {{.UserName}}')::text
64+
WHERE
65+
id = '51ce2fdf-c9ca-4be1-8d70-628674f9bc42';
66+
67+
UPDATE notification_templates
68+
SET
69+
body_template = REPLACE(body_template::text, E'\nThe workspace build was initiated by', E'The workspace build was initiated by')::text
70+
WHERE
71+
id = '2faeee0f-26cb-4e96-821c-85ccb9f71513';
72+
73+
UPDATE notification_templates
74+
SET
75+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},\n', 'Hi {{.UserName}},')::text
76+
WHERE
77+
id = '1a6a6bea-ee0a-43e2-9e7c-eabdb53730e4';
78+
79+
UPDATE notification_templates
80+
SET
81+
body_template = REPLACE(body_template::text, E'Hi {{.UserName}},\n', 'Hi {{.UserName}},')::text
82+
WHERE
83+
id = '6a2f0609-9b69-4d36-a989-9f5925b6cbff';

‎coderd/database/migrations/000261_improve_notification_templates.up.sql renamed to ‎coderd/database/migrations/000262_improve_notification_templates.up.sql

Lines changed: 10 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -6,37 +6,37 @@ WHERE
66

77
UPDATE notification_templates
88
SET
9-
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', 'Hi {{.UserName}},\n')::text
9+
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', E'Hi {{.UserName}},\n')::text
1010
WHERE
1111
id = '9f5af851-8408-4e73-a7a1-c6502ba46689';
1212

1313
UPDATE notification_templates
1414
SET
15-
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', 'Hi {{.UserName}},\n')::text
15+
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', E'Hi {{.UserName}},\n')::text
1616
WHERE
1717
id = 'b02ddd82-4733-4d02-a2d7-c36f3598997d';
1818

1919
UPDATE notification_templates
2020
SET
21-
body_template = REPLACE(body_template::text, 'Hi {{.UserName}}', 'Hi {{.UserName}},\n')::text
21+
body_template = REPLACE(body_template::text, 'Hi {{.UserName}}', E'Hi {{.UserName}},\n')::text
2222
WHERE
2323
id = 'c34a0c09-0704-4cac-bd1c-0c0146811c2b';
2424

2525
UPDATE notification_templates
2626
SET
27-
body_template = REPLACE(body_template::text, '({{.Labels.template_version_name}}).\n', '({{.Labels.template_version_name}}).\n\n')::text
27+
body_template = REPLACE(body_template::text, E'({{.Labels.template_version_name}}).\n', E'({{.Labels.template_version_name}}).\n\n')::text
2828
WHERE
2929
id = 'c34a0c09-0704-4cac-bd1c-0c0146811c2b';
3030

3131
UPDATE notification_templates
3232
SET
33-
body_template = REPLACE(body_template::text, 'Hi {{.UserName}}', 'Hi {{.UserName}},\n')::text
33+
body_template = REPLACE(body_template::text, 'Hi {{.UserName}}', E'Hi {{.UserName}},\n')::text
3434
WHERE
3535
id = '381df2a9-c0c0-4749-420f-80a9280c66f9';
3636

3737
UPDATE notification_templates
3838
SET
39-
body_template = REPLACE(body_template::text, 'The specified reason', '\nThe specified reason')::text
39+
body_template = REPLACE(body_template::text, 'The specified reason', E'\nThe specified reason')::text
4040
WHERE
4141
id = '381df2a9-c0c0-4749-420f-80a9280c66f9';
4242

@@ -48,7 +48,7 @@ WHERE
4848

4949
UPDATE notification_templates
5050
SET
51-
body_template = REPLACE(body_template::text, 'The specified reason', '\nThe specified reason')::text
51+
body_template = REPLACE(body_template::text, 'The specified reason', E'\nThe specified reason')::text
5252
WHERE
5353
id = 'f517da0b-cdc9-410f-ab89-a86107c420ed';
5454

@@ -66,18 +66,18 @@ WHERE
6666

6767
UPDATE notification_templates
6868
SET
69-
body_template = REPLACE(body_template::text, 'The workspace build was initiated by', '\nThe workspace build was initiated by')::text
69+
body_template = REPLACE(body_template::text, 'The workspace build was initiated by', E'\nThe workspace build was initiated by')::text
7070
WHERE
7171
id = '2faeee0f-26cb-4e96-821c-85ccb9f71513';
7272

7373
UPDATE notification_templates
7474
SET
75-
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', 'Hi {{.UserName}},\n')::text
75+
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', E'Hi {{.UserName}},\n')::text
7676
WHERE
7777
id = '1a6a6bea-ee0a-43e2-9e7c-eabdb53730e4';
7878

7979
UPDATE notification_templates
8080
SET
81-
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', 'Hi {{.UserName}},\n')::text
81+
body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', E'Hi {{.UserName}},\n')::text
8282
WHERE
8383
id = '6a2f0609-9b69-4d36-a989-9f5925b6cbff';

0 commit comments

Comments
 (0)