DROP TABLE D; | |
DROP TABLE C; | |
DROP TABLE B; | |
DROP TABLE A; | |
CREATE TABLE A | |
( | |
ID INT PRIMARY KEY, | |
LASTNAME VARCHAR(32) NULL, | |
FIRSTNAME VARCHAR(32) NULL, | |
HIREDATE DATE NULL, | |
BIRTHDATE DATE NULL, | |
SALARY FLOAT NOT NULL | |
) ENGINE=INNODB; | |
CREATE TABLE B | |
( | |
ID DATE PRIMARY KEY, | |
NAME VARCHAR(32) NULL | |
) ENGINE=INNODB; | |
CREATE TABLE C | |
( | |
ID INT PRIMARY KEY, | |
NAME VARCHAR(32) NULL | |
) ENGINE=INNODB; | |
commit; | |
quit; |