laba3.accdb

CREATE TABLE BookCategory (
    ID AUTOINCREMENT PRIMARY KEY,
    PARENT_ID LONG,
    NAME TEXT(100),
    CONSTRAINT fk_parent FOREIGN KEY (PARENT_ID) REFERENCES BookCategory(ID)
);

INSERT INTO BookCategory (NAME, PARENT_ID) VALUES ('Книги', NULL);
INSERT INTO BookCategory (NAME, PARENT_ID) VALUES ('Художественная литература', 1);
INSERT INTO BookCategory (NAME, PARENT_ID) VALUES ('Научная литература', 1);
INSERT INTO BookCategory (NAME, PARENT_ID) VALUES ('Фантастика', 2);
INSERT INTO BookCategory (NAME, PARENT_ID) VALUES ('История', 3);
INSERT INTO BookCategory (NAME, PARENT_ID) VALUES ('Физика', 3);