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

     1  CREATE TABLE IF NOT EXISTS bookmark(
     2  		id          INT(11)    NOT NULL AUTO_INCREMENT,
     3  		url         TEXT       NOT NULL,
     4  		title       TEXT       NOT NULL,
     5  		excerpt     TEXT       NOT NULL DEFAULT (''),
     6  		author      TEXT       NOT NULL DEFAULT (''),
     7  		public      BOOLEAN    NOT NULL DEFAULT 0,
     8  		content     MEDIUMTEXT NOT NULL DEFAULT (''),
     9  		html        MEDIUMTEXT NOT NULL DEFAULT (''),
    10  		modified    TIMESTAMP  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    11  		has_content BOOLEAN    NOT NULL DEFAULT 0,
    12  		PRIMARY KEY(id),
    13  		UNIQUE KEY bookmark_url_UNIQUE (url(255)),
    14  		FULLTEXT (title, excerpt, content))
    15  		CHARACTER SET utf8mb4;