github.com/soulteary/pocket-bookcase@v0.0.0-20240428065142-0b5a9a0fc98a/internal/database/migrations/mysql/0001_initial_account.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS account(
     2  		id       INT(11)        NOT NULL AUTO_INCREMENT,
     3  		username VARCHAR(250)   NOT NULL,
     4  		password BINARY(80)     NOT NULL,
     5  		owner    TINYINT(1)     NOT NULL DEFAULT '0',
     6  		config   JSON           NOT NULL DEFAULT '{}',
     7  		PRIMARY KEY (id),
     8  		UNIQUE KEY account_username_UNIQUE (username))
     9  		CHARACTER SET utf8mb4;