Форум пользователей MySQL

CREATE TABLE #__UCHPLANS_PROGRESS (
ID_PROGRESS INT ( 4 ) NOT NULL AUTO_INCREMENT,
FIO INT ( 4 ) NOT NULL,
TITLE INT ( 4 ) NOT NULL,
SEMESTER INT ( 2 ),
CONTR_1 INT ( 2 ),
CONTR_2 INT ( 2 ),
EXAM_PR INT ( 2 ),
OFFSET_PR VARCHAR ( 7 ),
COURSE_PROJECT_PR INT ( 2 ),
PUBLISHED varchar(3) NOT NULL default '1',
ORDERING varchar(3) NOT NULL default '1',
PRIMARY KEY (ID_PROGRESS, FIO, TITLE, SEMESTER),
FOREIGN KEY (FIO) REFERENCES #__UCHPLANS_STUDENTS (ID_STUD),
FOREIGN KEY (TITLE) REFERENCES #__UCHPLANS_DISCIPLINA (ID_DISCIP),
FOREIGN KEY (SEMESTER) REFERENCES #__UCHPLANS_PLANS_DISC (SEMESTER)
);