更新求种后端函数
Change-Id: I9e593e5eecfc6337120f75b3f6338f8279579dd1
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 24fe897..2f66b7c 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"
@@ -190,6 +190,8 @@
FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
+<<<<<<< Updated upstream
+<<<<<<< Updated upstream
-- 种子促销表
CREATE TABLE `SeedPromotion` (
`promotion_id` VARCHAR(64) NOT NULL,
@@ -199,4 +201,15 @@
`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
+) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
+
+CREATE TABLE `BegInfo` (
+ `beg_id` varchar(64) NOT NULL,
+ `user_id` varchar(36) NOT NULL,
+ `Info` text NOT NULL,
+ PRIMARY KEY (`beg_id`),
+ CONSTRAINT `fk_BegInfo_BegSeed` FOREIGN KEY (`beg_id`) REFERENCES `BegSeed` (`beg_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `fk_BegInfo_User` FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
+
+) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci
+