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
|
using Microsoft.EntityFrameworkCore.Migrations;
namespace Timeline.Migrations
{
public partial class AddTimelineUniqueId : Migration
{
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.Sql(
@"
ALTER TABLE timelines RENAME TO timelines_backup;
CREATE TABLE timelines (
id INTEGER NOT NULL CONSTRAINT PK_timelines PRIMARY KEY AUTOINCREMENT,
unique_id TEXT NOT NULL DEFAULT (timeline_create_guid()),
name TEXT NULL,
description TEXT NULL,
owner INTEGER NOT NULL,
visibility INTEGER NOT NULL,
create_time TEXT NOT NULL, current_post_local_id INTEGER NOT NULL DEFAULT 0,
CONSTRAINT FK_timelines_users_owner FOREIGN KEY (owner) REFERENCES users (id) ON DELETE CASCADE
);
INSERT INTO timelines (id, name, description, owner, visibility, create_time)
SELECT id, name, description, owner, visibility, create_time FROM timelines_backup;
DROP TABLE timelines_backup;
"
);
}
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropColumn(
name: "unique_id",
table: "timelines");
}
}
}
|
