0014-add-guild-active.sql « migrations « db « src - matrix/thirdparty/out-of-your-element.git - Unnamed repository; edit this file 'description' to name the repository.

index : matrix/thirdparty/out-of-your-element.git

Unnamed repository; edit this file 'description' to name the repository.

summary refs log tree commit diff

path: root/src/db/migrations/0014-add-guild-active.sql

blob: 01e2f166fdbc82daabe0f66fef50b9c0f7747e2b (plain) (blame)

BEGIN TRANSACTION;

CREATE TABLE "guild_active" (
	"guild_id"	TEXT NOT NULL,
	"autocreate"	INTEGER NOT NULL,
	PRIMARY KEY("guild_id")
) WITHOUT ROWID;

INSERT INTO guild_active (guild_id, autocreate) SELECT guild_id, 1 FROM guild_space;

COMMIT;