· 10 years ago · Sep 17, 2016, 09:54 AM
1DROP SCHEMA IF EXISTS juice;
2CREATE SCHEMA juice;
3USE juice;
4
5Drop table IF exists employee;
6CREATE TABLE Employee (
7staff_id INT(11) NOT NULL AUTO_INCREMENT,
8name VARCHAR(10),
9manager_id INT(11) ,
10FOREIGN KEY (manager_id)
11 REFERENCES managers (manager_id),
12PRIMARY KEY (staff_id));