XVssXG8e

1
2CREATE TABLE IF NOT EXISTS courses (
3  id INT NOT NULL auto_increment,
4  course varchar(100) NOT NULL,
5  semester boolean NOT NULL DEFAULT 1,
6  status boolean NOT NULL DEFAULT 1,
7  PRIMARY KEY (id)
8);
9
10INSERT INTO courses (course) VALUES
11('OO Programming Java'),
12('Hypermedia');