CREATE TABLE `users` (
  `user_id` int(11) NOT NULL auto_increment,
  `logname` varchar(20) default NULL,
  `logpass` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `logname` (`logname`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

CREATE TABLE `students` (
  `students_id` int(11) NOT NULL auto_increment,
  `nk` varchar(6) NOT NULL,
  `name` varchar(40) NOT NULL,
  `state` varchar(50) NOT NULL,
  `state_date` date default NULL,
  `depart` varchar(50) NOT NULL,
  `tform` varchar(50) NOT NULL,
  `title` varchar(100) NOT NULL,
  `leader1` varchar(40) NOT NULL,
  `leader2` varchar(40) default NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `comment` varchar(100) default NULL,
  PRIMARY KEY  (`nk`),
  UNIQUE KEY `students_id` (`students_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `manage_session` (
  `sess_id` varchar(32) NOT NULL default '',
  `user_id` int(11) NOT NULL,
  `lastlogin` datetime default NULL,
  `query` text NOT NULL,
  PRIMARY KEY  (`sess_id`),
  UNIQUE KEY `user_id` (`user_id`),
  CONSTRAINT `fk_userid` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `department` (
  `depart` varchar(50) NOT NULL,
  PRIMARY KEY  (`depart`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 CREATE TABLE `states` (
  `state` varchar(50) NOT NULL,
  PRIMARY KEY  (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `traning_form` (
  `tform` varchar(50) NOT NULL,
  PRIMARY KEY  (`tform`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;