25 lines
678 B
SQL
25 lines
678 B
SQL
-- MariaDB dump 10.19 Distrib 10.6.16-MariaDB, for debian-linux-gnu (x86_64)
|
|
|
|
--
|
|
-- Table structure for table `sys_user_post`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sys_user_post`;
|
|
CREATE TABLE `sys_user_post` (
|
|
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
|
|
`post_id` bigint(20) NOT NULL COMMENT '岗位ID',
|
|
PRIMARY KEY (`user_id`,`post_id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户与岗位关联表';
|
|
|
|
--
|
|
-- Dumping data for table `sys_user_post`
|
|
--
|
|
|
|
LOCK TABLES `sys_user_post` WRITE;
|
|
|
|
INSERT INTO `sys_user_post` VALUES (1,1),(2,1),(3,2),(4,3);
|
|
|
|
UNLOCK TABLES;
|
|
|
|
-- Dump completed on 2024-03-06 17:27:00
|