/*
 Navicat Premium Data Transfer

 Source Server         : mysql_dev
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 192.168.182.10:3306
 Source Schema         : REST_DB_02

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 01/03/2022 21:36:21
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `auth_group_permissions_group_id_permission_id_0cd325b0_uniq`(`group_id`, `permission_id`) USING BTREE,
  INDEX `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm`(`permission_id`) USING BTREE,
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `auth_permission_content_type_id_codename_01ab375a_uniq`(`content_type_id`, `codename`) USING BTREE,
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
INSERT INTO `auth_permission` VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` VALUES (4, 'Can view log entry', 1, 'view_logentry');
INSERT INTO `auth_permission` VALUES (5, 'Can add permission', 2, 'add_permission');
INSERT INTO `auth_permission` VALUES (6, 'Can change permission', 2, 'change_permission');
INSERT INTO `auth_permission` VALUES (7, 'Can delete permission', 2, 'delete_permission');
INSERT INTO `auth_permission` VALUES (8, 'Can view permission', 2, 'view_permission');
INSERT INTO `auth_permission` VALUES (9, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` VALUES (10, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` VALUES (12, 'Can view group', 3, 'view_group');
INSERT INTO `auth_permission` VALUES (13, 'Can add user', 4, 'add_user');
INSERT INTO `auth_permission` VALUES (14, 'Can change user', 4, 'change_user');
INSERT INTO `auth_permission` VALUES (15, 'Can delete user', 4, 'delete_user');
INSERT INTO `auth_permission` VALUES (16, 'Can view user', 4, 'view_user');
INSERT INTO `auth_permission` VALUES (17, 'Can add content type', 5, 'add_contenttype');
INSERT INTO `auth_permission` VALUES (18, 'Can change content type', 5, 'change_contenttype');
INSERT INTO `auth_permission` VALUES (19, 'Can delete content type', 5, 'delete_contenttype');
INSERT INTO `auth_permission` VALUES (20, 'Can view content type', 5, 'view_contenttype');
INSERT INTO `auth_permission` VALUES (21, 'Can add session', 6, 'add_session');
INSERT INTO `auth_permission` VALUES (22, 'Can change session', 6, 'change_session');
INSERT INTO `auth_permission` VALUES (23, 'Can delete session', 6, 'delete_session');
INSERT INTO `auth_permission` VALUES (24, 'Can view session', 6, 'view_session');
INSERT INTO `auth_permission` VALUES (25, 'Can add Account', 7, 'add_account');
INSERT INTO `auth_permission` VALUES (26, 'Can change Account', 7, 'change_account');
INSERT INTO `auth_permission` VALUES (27, 'Can delete Account', 7, 'delete_account');
INSERT INTO `auth_permission` VALUES (28, 'Can view Account', 7, 'view_account');
INSERT INTO `auth_permission` VALUES (29, 'Can add Department', 8, 'add_department');
INSERT INTO `auth_permission` VALUES (30, 'Can change Department', 8, 'change_department');
INSERT INTO `auth_permission` VALUES (31, 'Can delete Department', 8, 'delete_department');
INSERT INTO `auth_permission` VALUES (32, 'Can view Department', 8, 'view_department');
INSERT INTO `auth_permission` VALUES (33, 'Can add Position', 9, 'add_position');
INSERT INTO `auth_permission` VALUES (34, 'Can change Position', 9, 'change_position');
INSERT INTO `auth_permission` VALUES (35, 'Can delete Position', 9, 'delete_position');
INSERT INTO `auth_permission` VALUES (36, 'Can view Position', 9, 'view_position');
INSERT INTO `auth_permission` VALUES (37, 'Can add Roles', 10, 'add_roles');
INSERT INTO `auth_permission` VALUES (38, 'Can change Roles', 10, 'change_roles');
INSERT INTO `auth_permission` VALUES (39, 'Can delete Roles', 10, 'delete_roles');
INSERT INTO `auth_permission` VALUES (40, 'Can view Roles', 10, 'view_roles');
INSERT INTO `auth_permission` VALUES (41, 'Can add Token', 11, 'add_token');
INSERT INTO `auth_permission` VALUES (42, 'Can change Token', 11, 'change_token');
INSERT INTO `auth_permission` VALUES (43, 'Can delete Token', 11, 'delete_token');
INSERT INTO `auth_permission` VALUES (44, 'Can view Token', 11, 'view_token');
INSERT INTO `auth_permission` VALUES (45, 'Can add token', 12, 'add_tokenproxy');
INSERT INTO `auth_permission` VALUES (46, 'Can change token', 12, 'change_tokenproxy');
INSERT INTO `auth_permission` VALUES (47, 'Can delete token', 12, 'delete_tokenproxy');
INSERT INTO `auth_permission` VALUES (48, 'Can view token', 12, 'view_tokenproxy');

-- ----------------------------
-- Table structure for auth_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `last_login` datetime(6) NULL DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `first_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `last_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `email` varchar(254) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of auth_user
-- ----------------------------
INSERT INTO `auth_user` VALUES (1, 'pbkdf2_sha256$260000$Y4W0dLGBM9phUKThgagkDw$qakjJVIK9MLHT550nPINk2D5PenIfQsBT1pI8KT1t+k=', '2022-03-01 13:04:33.320206', 1, 'steven', '', '', 'steven@abc.com', 1, 1, '2022-03-01 10:31:41.590071');
INSERT INTO `auth_user` VALUES (2, 'pbkdf2_sha256$260000$rOIxyJ7Nxn23D2oolylK9I$q3t8Oz67KUp+NjIXtlANGqrG/B3jNKN4H7i+gXd3Xf0=', '2022-03-01 12:45:03.856177', 1, 'alice', '', '', 'alice@gmail.com', 1, 1, '2022-03-01 12:43:12.226182');

-- ----------------------------
-- Table structure for auth_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `auth_user_groups_user_id_group_id_94350c0c_uniq`(`user_id`, `group_id`) USING BTREE,
  INDEX `auth_user_groups_group_id_97559544_fk_auth_group_id`(`group_id`) USING BTREE,
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auth_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq`(`user_id`, `permission_id`) USING BTREE,
  INDEX `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm`(`permission_id`) USING BTREE,
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for authtoken_token
-- ----------------------------
DROP TABLE IF EXISTS `authtoken_token`;
CREATE TABLE `authtoken_token`  (
  `key` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created` datetime(6) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`key`) USING BTREE,
  UNIQUE INDEX `user_id`(`user_id`) USING BTREE,
  CONSTRAINT `authtoken_token_user_id_35299eff_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of authtoken_token
-- ----------------------------
INSERT INTO `authtoken_token` VALUES ('50850b5cfef426b6b795a91782f135eefabae09c', '2022-03-01 13:17:22.244242', 1);

-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `object_repr` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `action_flag` smallint(5) UNSIGNED NOT NULL,
  `change_message` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `content_type_id` int(11) NULL DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `django_admin_log_content_type_id_c4bce8eb_fk_django_co`(`content_type_id`) USING BTREE,
  INDEX `django_admin_log_user_id_c564eba6_fk_auth_user_id`(`user_id`) USING BTREE,
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `model` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `django_content_type_app_label_model_76bd3d3b_uniq`(`app_label`, `model`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
INSERT INTO `django_content_type` VALUES (1, 'admin', 'logentry');
INSERT INTO `django_content_type` VALUES (3, 'auth', 'group');
INSERT INTO `django_content_type` VALUES (2, 'auth', 'permission');
INSERT INTO `django_content_type` VALUES (4, 'auth', 'user');
INSERT INTO `django_content_type` VALUES (11, 'authtoken', 'token');
INSERT INTO `django_content_type` VALUES (12, 'authtoken', 'tokenproxy');
INSERT INTO `django_content_type` VALUES (5, 'contenttypes', 'contenttype');
INSERT INTO `django_content_type` VALUES (6, 'sessions', 'session');
INSERT INTO `django_content_type` VALUES (7, 'userweb', 'account');
INSERT INTO `django_content_type` VALUES (8, 'userweb', 'department');
INSERT INTO `django_content_type` VALUES (9, 'userweb', 'position');
INSERT INTO `django_content_type` VALUES (10, 'userweb', 'roles');

-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of django_migrations
-- ----------------------------
INSERT INTO `django_migrations` VALUES (1, 'contenttypes', '0001_initial', '2022-03-01 09:50:32.556346');
INSERT INTO `django_migrations` VALUES (2, 'auth', '0001_initial', '2022-03-01 09:50:32.768957');
INSERT INTO `django_migrations` VALUES (3, 'admin', '0001_initial', '2022-03-01 09:50:32.810997');
INSERT INTO `django_migrations` VALUES (4, 'admin', '0002_logentry_remove_auto_add', '2022-03-01 09:50:32.825053');
INSERT INTO `django_migrations` VALUES (5, 'admin', '0003_logentry_add_action_flag_choices', '2022-03-01 09:50:32.840131');
INSERT INTO `django_migrations` VALUES (6, 'contenttypes', '0002_remove_content_type_name', '2022-03-01 09:50:32.878049');
INSERT INTO `django_migrations` VALUES (7, 'auth', '0002_alter_permission_name_max_length', '2022-03-01 09:50:32.897998');
INSERT INTO `django_migrations` VALUES (8, 'auth', '0003_alter_user_email_max_length', '2022-03-01 09:50:32.917032');
INSERT INTO `django_migrations` VALUES (9, 'auth', '0004_alter_user_username_opts', '2022-03-01 09:50:32.928361');
INSERT INTO `django_migrations` VALUES (10, 'auth', '0005_alter_user_last_login_null', '2022-03-01 09:50:32.950934');
INSERT INTO `django_migrations` VALUES (11, 'auth', '0006_require_contenttypes_0002', '2022-03-01 09:50:32.952949');
INSERT INTO `django_migrations` VALUES (12, 'auth', '0007_alter_validators_add_error_messages', '2022-03-01 09:50:32.964002');
INSERT INTO `django_migrations` VALUES (13, 'auth', '0008_alter_user_username_max_length', '2022-03-01 09:50:32.982953');
INSERT INTO `django_migrations` VALUES (14, 'auth', '0009_alter_user_last_name_max_length', '2022-03-01 09:50:33.011099');
INSERT INTO `django_migrations` VALUES (15, 'auth', '0010_alter_group_name_max_length', '2022-03-01 09:50:33.032233');
INSERT INTO `django_migrations` VALUES (16, 'auth', '0011_update_proxy_permissions', '2022-03-01 09:50:33.046967');
INSERT INTO `django_migrations` VALUES (17, 'auth', '0012_alter_user_first_name_max_length', '2022-03-01 09:50:33.067974');
INSERT INTO `django_migrations` VALUES (18, 'sessions', '0001_initial', '2022-03-01 09:50:33.090977');
INSERT INTO `django_migrations` VALUES (19, 'userweb', '0001_initial', '2022-03-01 09:50:33.222243');
INSERT INTO `django_migrations` VALUES (20, 'authtoken', '0001_initial', '2022-03-01 13:13:54.684369');
INSERT INTO `django_migrations` VALUES (21, 'authtoken', '0002_auto_20160226_1747', '2022-03-01 13:13:54.746962');
INSERT INTO `django_migrations` VALUES (22, 'authtoken', '0003_tokenproxy', '2022-03-01 13:13:54.762295');

-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session`  (
  `session_key` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `session_data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`) USING BTREE,
  INDEX `django_session_expire_date_a5c62663`(`expire_date`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of django_session
-- ----------------------------
INSERT INTO `django_session` VALUES ('3pcu9jl824jmhi3w7yffu4aya4kxijv6', 'eyJ1c2VyIjp7ImxvZ2luaWQiOiIxMDAxIiwibmFtZSI6Ilx1NTIxOFx1NjY1M1x1NjYwZSJ9fQ:1nP0vZ:TJ6zGgSFUqOC8egU9bgKTyIXNaFKoNHnqFbcAnBdT5s', '2022-03-15 11:44:25.937884');
INSERT INTO `django_session` VALUES ('h1wnwchl77t6ed8q5ow450g9xhkpat9l', '.eJxVjEEOwiAQRe_C2pBCYcq4dO8ZyMCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-ZnEWWpx-t0DxkeoO-E711mRsdV3mIHdFHrTLa-P0vBzu30GhXr61y4DBDYG0BZONQYWYrR5JkUomITJnO4QJwGpS4FADwBhHDRO7yEG8P8nwNzA:1nP1sF:2ICRiA3alDjVtSARiPKW4f0BCaVqW2M31-K_-NWUP2Y', '2022-03-15 12:45:03.860356');
INSERT INTO `django_session` VALUES ('xjo9f520k19hsnks7u1j6nuhba1q0x77', '.eJxVjDkOwjAUBe_iGlne5IWSnjNYfwsOoESKkwpxd4iUAto3M--lKmxrq1uXpY6szsqq0--GQA-ZdsB3mG6zpnlalxH1ruiDdn2dWZ6Xw_07aNDbtzZMCYnRRk8OWEJxKbMz2RVPxiMToS8SXSrCmYUMWoSQQ4hDSgOo9wcCeDi-:1nP2B7:QHE-wma0kwdHVwgaUdDdpAw7TTML7uvXHBxmtKg1tIE', '2022-03-15 13:04:33.326243');

-- ----------------------------
-- Table structure for user_Account
-- ----------------------------
DROP TABLE IF EXISTS `user_Account`;
CREATE TABLE `user_Account`  (
  `loginid` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `loginpwd` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `mobile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `last_login` datetime(6) NULL DEFAULT NULL,
  `create_time` datetime(6) NULL DEFAULT NULL,
  `edit_time` datetime(6) NULL DEFAULT NULL,
  `department_id` bigint(20) NOT NULL,
  `position_id` bigint(20) NOT NULL,
  PRIMARY KEY (`loginid`) USING BTREE,
  INDEX `user_Account_department_id_1a509b6c_fk_user_Department_id`(`department_id`) USING BTREE,
  INDEX `user_Account_position_id_69582261_fk_user_Position_id`(`position_id`) USING BTREE,
  CONSTRAINT `user_Account_department_id_1a509b6c_fk_user_Department_id` FOREIGN KEY (`department_id`) REFERENCES `user_Department` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `user_Account_position_id_69582261_fk_user_Position_id` FOREIGN KEY (`position_id`) REFERENCES `user_Position` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_Account
-- ----------------------------
INSERT INTO `user_Account` VALUES ('1001', '1234.com', '刘晓明', 1, '13412349870', 'liuxiaoming@ab.com', NULL, '2022-03-01 17:52:53.000000', NULL, 1, 1);
INSERT INTO `user_Account` VALUES ('1002', '1234.com', '陈鹏', 1, '15052120909', 'chenpeng', NULL, '2022-03-01 17:53:27.000000', NULL, 3, 3);
INSERT INTO `user_Account` VALUES ('1003', '1234.com', '陈晓明', 1, '13900998877', 'chenxiaomign@sohu.com', NULL, '2022-03-01 17:54:20.000000', NULL, 3, 4);
INSERT INTO `user_Account` VALUES ('1004', '1234.com', '马建', 1, '15000993344', 'majian@hotmail.com', NULL, '2022-03-02 17:56:40.000000', NULL, 3, 5);

-- ----------------------------
-- Table structure for user_Department
-- ----------------------------
DROP TABLE IF EXISTS `user_Department`;
CREATE TABLE `user_Department`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_Department
-- ----------------------------
INSERT INTO `user_Department` VALUES (1, '市场部');
INSERT INTO `user_Department` VALUES (2, '销售部');
INSERT INTO `user_Department` VALUES (3, '信息部');
INSERT INTO `user_Department` VALUES (4, '财务部');
INSERT INTO `user_Department` VALUES (5, '人力资源部');

-- ----------------------------
-- Table structure for user_Position
-- ----------------------------
DROP TABLE IF EXISTS `user_Position`;
CREATE TABLE `user_Position`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_Position
-- ----------------------------
INSERT INTO `user_Position` VALUES (1, '主管');
INSERT INTO `user_Position` VALUES (2, '专员');
INSERT INTO `user_Position` VALUES (3, '系统工程师');
INSERT INTO `user_Position` VALUES (4, '网络工程师');
INSERT INTO `user_Position` VALUES (5, '安全工程师');

-- ----------------------------
-- Table structure for user_Roles
-- ----------------------------
DROP TABLE IF EXISTS `user_Roles`;
CREATE TABLE `user_Roles`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `desc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_Roles
-- ----------------------------
INSERT INTO `user_Roles` VALUES (1, '角色1', NULL);
INSERT INTO `user_Roles` VALUES (2, '角色2', NULL);
INSERT INTO `user_Roles` VALUES (3, '角色3', NULL);

-- ----------------------------
-- Table structure for user_Roles_account
-- ----------------------------
DROP TABLE IF EXISTS `user_Roles_account`;
CREATE TABLE `user_Roles_account`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `roles_id` int(11) NOT NULL,
  `account_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `user_Roles_account_roles_id_account_id_fea93de4_uniq`(`roles_id`, `account_id`) USING BTREE,
  INDEX `user_Roles_account_account_id_0592418f_fk_user_Account_loginid`(`account_id`) USING BTREE,
  CONSTRAINT `user_Roles_account_account_id_0592418f_fk_user_Account_loginid` FOREIGN KEY (`account_id`) REFERENCES `user_Account` (`loginid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `user_Roles_account_roles_id_f2cf1203_fk_user_Roles_id` FOREIGN KEY (`roles_id`) REFERENCES `user_Roles` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_Roles_account
-- ----------------------------
INSERT INTO `user_Roles_account` VALUES (7, 1, '1002');
INSERT INTO `user_Roles_account` VALUES (8, 1, '1003');
INSERT INTO `user_Roles_account` VALUES (2, 2, '1001');
INSERT INTO `user_Roles_account` VALUES (3, 2, '1002');
INSERT INTO `user_Roles_account` VALUES (6, 2, '1004');
INSERT INTO `user_Roles_account` VALUES (4, 3, '1003');

SET FOREIGN_KEY_CHECKS = 1;