SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE b_user_book_highlight ( id BIGINT NOT NULL, version INT NULL, created datetime NULL, modified datetime NULL, deleted BIT(1) NOT NULL, user_id BIGINT NOT NULL, publication_id BIGINT NOT NULL, chapter_index INT NULL, content_post VARCHAR(255) NULL, content_pre VARCHAR(255) NULL, end_parent_x_path VARCHAR(255) NULL, start_parent_x_path VARCHAR(255) NULL, select_text LONGTEXT NOT NULL, CONSTRAINT pk_b_user_book_highlight PRIMARY KEY (id) ); ALTER TABLE b_user_book_highlight ADD CONSTRAINT uc_656495de0edead255e17d4740 UNIQUE (user_id, publication_id, select_text); ALTER TABLE b_user_book_highlight ADD CONSTRAINT FK_B_USER_BOOK_HIGHLIGHT_ON_PUBLICATION FOREIGN KEY (publication_id) REFERENCES b_product (id); ALTER TABLE b_user_book_highlight ADD CONSTRAINT FK_B_USER_BOOK_HIGHLIGHT_ON_USER FOREIGN KEY (user_id) REFERENCES b_user (id); ALTER TABLE pk_b_user_book_highlig ADD CONSTRAINT MD5(select_text)