新增求种和个人中心接口
Change-Id: Ibf3eef5b91a45a0ccf7b99d08afa29960884a8cf
diff --git "a/\345\274\200\345\217\221\346\226\207\346\241\243/create.sql" "b/\345\274\200\345\217\221\346\226\207\346\241\243/create.sql"
index 12d9233..24fe897 100644
--- "a/\345\274\200\345\217\221\346\226\207\346\241\243/create.sql"
+++ "b/\345\274\200\345\217\221\346\226\207\346\241\243/create.sql"
@@ -188,4 +188,15 @@
FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE,
FOREIGN KEY (`beg_id`) REFERENCES `BegSeed` (`beg_id`) ON DELETE CASCADE,
FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE
+) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
+
+-- 种子促销表
+CREATE TABLE `SeedPromotion` (
+ `promotion_id` VARCHAR(64) NOT NULL,
+ `seed_id` VARCHAR(64) NOT NULL,
+ `start_time` DATETIME NOT NULL,
+ `end_time` DATETIME NOT NULL,
+ `discount` TINYINT NOT NULL DEFAULT 1 COMMENT '折扣率, 1表示无折扣',
+ PRIMARY KEY (`promotion_id`),
+ FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
\ No newline at end of file