· 7 years ago · Sep 12, 2018, 09:12 AM
1CREATE TABLE IF NOT EXISTS `categories` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `parent_id` int(10) unsigned DEFAULT NULL,
4 `name` varchar(50) NOT NULL,
5 `lft` int(10) unsigned DEFAULT NULL,
6 `rght` int(10) unsigned DEFAULT NULL,
7 PRIMARY KEY (`id`),
8);