· 6 years ago · Apr 22, 2019, 07:20 AM
1CREATE DATABASE IF NOT EXISTS ci_sip;
2USE ci_sip;
3
4CREATE TABLE IF NOT EXISTS categories(
5 id int PRIMARY KEY AUTO_INCREMENT,
6 name VARCHAR(150) NOT NULL,
7 status enum('active', 'inactive') NOT NULL
8);