0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
40 lines
1.0 KiB
SQL
40 lines
1.0 KiB
SQL
CREATE TABLE authors (
|
|
id BIGINT PRIMARY KEY,
|
|
foo ENUM("ok") DEFAULT "ok" NOT NULL,
|
|
renamed ENUM("ok") DEFAULT "ok" NOT NULL,
|
|
removed ENUM("ok") DEFAULT "ok" NOT NULL,
|
|
add_item ENUM("ok") DEFAULT "ok" NOT NULL,
|
|
remove_item ENUM("ok", "removed") DEFAULT "ok" NOT NULL
|
|
);
|
|
|
|
CREATE TABLE renamed (
|
|
id BIGINT PRIMARY KEY,
|
|
foo ENUM("ok") DEFAULT "ok" NOT NULL
|
|
);
|
|
|
|
CREATE TABLE removed (
|
|
id BIGINT PRIMARY KEY,
|
|
foo ENUM("ok") DEFAULT "ok" NOT NULL
|
|
);
|
|
|
|
/* Rename column */
|
|
ALTER TABLE authors RENAME COLUMN renamed TO bar;
|
|
|
|
/* Drop column */
|
|
ALTER TABLE authors DROP COLUMN removed;
|
|
|
|
/* Add column */
|
|
ALTER TABLE authors ADD COLUMN added ENUM("ok") DEFAULT "ok" NOT NULL;
|
|
|
|
/* Add enum values */
|
|
ALTER TABLE authors MODIFY add_item ENUM("ok", "added") DEFAULT "ok" NOT NULL;
|
|
|
|
/* Remove enum values */
|
|
ALTER TABLE authors MODIFY remove_item ENUM("ok") DEFAULT "ok" NOT NULL;
|
|
|
|
/* Drop table */
|
|
DROP TABLE removed;
|
|
|
|
/* Rename table */
|
|
ALTER TABLE renamed RENAME TO books;
|