CREATE TABLE `courses` (
`courseId` bigint(20) unsigned NOT NULL auto_increment,
`name` varchar(20) default NULL,
`price` float NOT NULL,
`semester` int(10) unsigned NOT NULL,
`major` varchar(45) NOT NULL,
PRIMARY KEY (`courseId`)
) ENGINE=InnoDB CHARACTER set gb2312 collate gb2312_chinese_ci;

CREATE TABLE `users` (
`userId` bigint(20) unsigned NOT NULL auto_increment,
`name` varchar(20) default NULL,
`password` varchar(20) NOT NULL,
`major` varchar(45) NOT NULL,
`balance` float NOT NULL,
`year` integer unsigned NOT NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB CHARACTER set gb2312 collate gb2312_chinese_ci;

CREATE TABLE `selected` (
`selectedId` bigint(20) unsigned NOT NULL auto_increment,
`name` varchar(20) default NULL,
`userId` bigint(20) unsigned NOT NULL,
`courseId` bigint(20) unsigned NOT NULL,
`semester` int(10) unsigned NOT NULL,
PRIMARY KEY (`selectedId`)
) ENGINE=InnoDB CHARACTER set gb2312 collate gb2312_chinese_ci;

CREATE TABLE `admins` (
`adminId` bigint(20) unsigned NOT NULL auto_increment,
`name` varchar(20) default NULL,
`userId` bigint(20) unsigned NOT NULL,
`password` varchar(20) NOT NULL,
`major` varchar(45) NOT NULL,
PRIMARY KEY (`adminId`)
) ENGINE=InnoDB CHARACTER set gb2312 collate gb2312_chinese_ci;[@more@]