CREATE TABLE categories(
id INT PRIMARY KEY auto_increment COMMENT 'primary key',
project_id INT COMMENT 'project id',
name VARCHAR(384) COMMENT 'category name',
description VARCHAR(4096) COMMENT 'description',
enabled INT COMMENT 'enabled flag',
order_rank INT COMMENT 'order',
insert_time DATETIME COMMENT 'create datetime',
insert_user INT COMMENT 'create user',
update_time DATETIME COMMENT 'update datetime',
update_user INT COMMENT 'update user'
) type=InnoDB, COMMENT = 'Categories'
;

CREATE INDEX categories_idx01 ON categories( project_id )
;
