This query runs:
这个查询:
MariaDB > CREATE TABLE `lines` (`line_id` INT UNSIGNED AUTO_INCREMENT,
-> `page_id` int(10) UNSIGNED NOT NULL,
-> `file_name` varchar(150) NOT NULL,
-> `position` varchar(20) NOT NULL,
-> PRIMARY KEY(line_id),
-> FOREIGN KEY(page_id) REFERENCES pages(page_id)
-> ON DELETE CASCADE
-> )AUTO_INCREMENT=100;
Query OK, 0 rows affected (0.01 sec)
MariaDB > CREATE TAB