11 lines
441 B
SQL
11 lines
441 B
SQL
DROP TABLE IF EXISTS item_details_book_pages;
|
|
CREATE TABLE item_details_book_pages (
|
|
id INTEGER PRIMARY KEY,
|
|
item_id INTEGER NOT NULL DEFAULT 0,
|
|
page INTEGER NOT NULL DEFAULT 0,
|
|
page_text TEXT NOT NULL,
|
|
page_text_valign INTEGER NOT NULL DEFAULT 0,
|
|
page_text_halign INTEGER NOT NULL DEFAULT 0
|
|
);
|
|
CREATE INDEX idx_item_details_book_pages_item_id ON item_details_book_pages(item_id);
|