CREATE TABLE salaries (
salary_ID int(6) NOT NULL AUTO_INCREMENT,
s_firstname varchar(45) NOT NULL,
s_surname varchar(45) NOT NULL,
s_middlename varchar(45) NOT NULL,
s_age int(3) NOT NULL,
s_experience int(3) NOT NULL,
s_salary decimal(9,2) NULL default '0.00',
PRIMARY KEY (salary_ID)
);
salary_ID int(6) NOT NULL AUTO_INCREMENT,
s_firstname varchar(45) NOT NULL,
s_surname varchar(45) NOT NULL,
s_middlename varchar(45) NOT NULL,
s_age int(3) NOT NULL,
s_experience int(3) NOT NULL,
s_salary decimal(9,2) NULL default '0.00',
PRIMARY KEY (salary_ID)
);
Соседние файлы в папке Схемы и SQL код