20170829-member_grade.sql 366 B

123456789
  1. CREATE TABLE `member_grade` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `gradeName` varchar(50) NOT NULL,
  4. `business` longtext COMMENT '业务',
  5. `cost` longtext COMMENT '费用',
  6. `memberRank` int(11) DEFAULT NULL COMMENT '等级',
  7. PRIMARY KEY (`id`),
  8. UNIQUE KEY `gradeName_UNIQUE` (`gradeName`)
  9. ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8