/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.92.61-lq-db
 Source Server Type    : MySQL
 Source Server Version : 80035
 Source Host           : 192.168.92.61:13306
 Source Schema         : annotation_platform

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

 Date: 31/01/2026 17:50:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for annotations
-- ----------------------------
DROP TABLE IF EXISTS `annotations`;
CREATE TABLE `annotations`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `task_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_annotations_task`(`task_id`) USING BTREE,
  INDEX `idx_annotations_user`(`user_id`) USING BTREE,
  CONSTRAINT `annotations_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of annotations
-- ----------------------------
INSERT INTO `annotations` VALUES ('ann_03b2a396aa76', 'task_11e92924c29d', 'current_user', '{\"result\": [{\"value\": {\"start\": 4, \"end\": 11, \"text\": \"\\u534e\\u5927\\u5b66\\u7684\\u6559\\u6388\\uff0c\", \"labels\": [\"\\u4eba\\u540d\"]}, \"id\": \"gjPTjODjER\", \"from_name\": \"label\", \"to_name\": \"text\", \"type\": \"labels\", \"origin\": \"manual\"}]}', '2026-01-21 07:28:23', '2026-01-21 07:28:23');
INSERT INTO `annotations` VALUES ('ann_093eb88120b0', 'task_49835ad11f75', 'current_user', '{\"result\": [{\"value\": {\"start\": 25, \"end\": 41, \"text\": \"\\u6570\\u636e\\u4e2d\\u5b66\\u4e60\\u5e76\\u505a\\u51fa\\u51b3\\u7b56\\u3002\\u6df1\\u5ea6\\u5b66\\u4e60\\u662f\", \"labels\": [\"\\u95ee\\u9898\"]}, \"id\": \"dmnhTWzRnm\", \"from_name\": \"label\", \"to_name\": \"text\", \"type\": \"labels\", \"origin\": \"manual\"}]}', '2026-01-15 09:12:52', '2026-01-15 09:12:52');
INSERT INTO `annotations` VALUES ('ann_0fd0cf4ceab3', 'task_1af9289d86f7', 'current_user', '{\"result\": [{\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 54, \"y\": 68.29268292682927, \"width\": 4.875, \"height\": 5.44090056285178, \"rotation\": 0, \"rectanglelabels\": [\"\\u8f66\"]}, \"id\": \"jkqFmKZlcs\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}, {\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 46.5, \"y\": 68.66791744840526, \"width\": 5.75, \"height\": 5.44090056285178, \"rotation\": 0, \"rectanglelabels\": [\"\\u8f66\"]}, \"id\": \"gckHOs0xkY\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}]}', '2026-01-21 10:02:15', '2026-01-21 10:02:15');
INSERT INTO `annotations` VALUES ('ann_156bbe8132c3', 'task_4bf9614120e0', 'user_45ff87b34123', '{\"confidence\": 0.95, \"label\": \"positive\"}', '2026-01-22 07:44:20', '2026-01-22 07:44:20');
INSERT INTO `annotations` VALUES ('ann_1cbfaa48f7e4', 'task_156b3b77ffb7', 'current_user', '{\"result\": [{\"value\": {\"choices\": [\"\\u6a21\\u7cca\", \"\\u566a\\u70b9\\u591a\"]}, \"id\": \"VAok790xjK\", \"from_name\": \"issues\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}, {\"value\": {\"choices\": [\"\\u826f\\u597d\"]}, \"id\": \"XS979Tq4Qb\", \"from_name\": \"quality\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}]}', '2026-01-21 08:43:50', '2026-01-21 09:57:34');
INSERT INTO `annotations` VALUES ('ann_25f5dcee7fbf', 'task_9dfba8d63541', 'current_user', '{\"result\": [{\"value\": {\"choices\": [\"\\u52a8\\u7269\"]}, \"id\": \"tVimhVA4ON\", \"from_name\": \"category\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}]}', '2026-01-20 02:57:02', '2026-01-20 02:57:02');
INSERT INTO `annotations` VALUES ('ann_3b7d45bcf93f', 'task_80385274acb5', 'current_user', '{\"result\": [{\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"points\": [[17.07126076742365, 13.396004700352526], [19.42051683633516, 25.381903642773207], [20.751761942051683, 34.665099882491184], [21.456538762725135, 48.766157461809634], [21.1433046202036, 58.049353701527615], [22.16131558339859, 72.[REDACTED]], [24.119028974158184, 77.2032902467685], [21.378230227094754, 81.786133960047], [23.02270947533281, 88.01410105757932], [29.130775254502737, 89.42420681551117], [34.37744714173845, 86.3689776733255], [49.96084573218481, 90.0117508813161], [54.581049334377454, 89.77673325499413], [62.88175411119812, 88.01410105757932], [68.59827721221613, 86.83901292596946], [74.78465152701645, 86.3689776733255], [77.76037588097103, 86.01645123384255], [83.24197337509788, 83.31374853113984], [84.96476115896633, 79.31844888366626], [81.83241973375098, 64.27732079905994], [78.54346123727485, 58.75440658049354], [71.80892717306186, 51.233842538190366], [66.327329678935, 48.64864864864865], [57.321848081440876, 39.9529964747356], [54.97259201252936, 39.60047003525264], [52.07517619420516, 36.54524089306698], [49.569303054032886, 26.08695652173913], [51.21378230227095, 17.038777908343125], [49.96084573218481, 6.462984723854288], [49.80422866092404, 1.8801410105757932], [44.16601409553642, 1.762632197414806], [40.72043852779953, 11.045828437132785], [38.37118245888802, 14.336075205640423], [32.96789350039154, 14.101057579318448], [29.052466718872356, 12.338425381903642], [24.667188723570867, 10.105757931844888], [19.57713390759593, 6.698002350176263], [15.505090054815977, 9.283196239717979]], \"closed\": true, \"polygonlabels\": [\"\\u80cc\\u666f\"]}, \"id\": \"V6m3fq0CDF\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"polygonlabels\", \"origin\": \"manual\"}]}', '2026-01-20 07:23:00', '2026-01-21 07:52:07');
INSERT INTO `annotations` VALUES ('ann_a072ebdfcfa9', 'task_4df2784ccbe2', 'current_user', '{\"result\": [{\"value\": {\"choices\": [\"\\u6a21\\u7cca\", \"\\u66dd\\u5149\\u8fc7\\u5ea6\"]}, \"id\": \"s9Ic31qJyu\", \"from_name\": \"issues\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}, {\"value\": {\"choices\": [\"\\u826f\\u597d\"]}, \"id\": \"INTNWZE1fw\", \"from_name\": \"quality\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}]}', '2026-01-21 08:43:47', '2026-01-21 09:57:32');
INSERT INTO `annotations` VALUES ('ann_c935c2aba079', 'task_e095e9480142', 'current_user', '{\"result\": [{\"original_width\": 800, \"original_height\": 492, \"image_rotation\": 0, \"value\": {\"x\": 22.74549098196393, \"y\": 56.84039087947883, \"width\": 8.517034068136269, \"height\": 16.938110749185668, \"rotation\": 0, \"rectanglelabels\": [\"\\u81ea\\u884c\\u8f66\"]}, \"id\": \"n4AkBzRY0A\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}, {\"original_width\": 800, \"original_height\": 492, \"image_rotation\": 0, \"value\": {\"x\": 44.625, \"y\": 39.22764227642276, \"width\": 21.625, \"height\": 30.487804878048784, \"rotation\": 0, \"rectanglelabels\": [\"\\u72d7\"]}, \"id\": \"SEhj2Ov6Kr\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}]}', '2026-01-21 08:44:12', '2026-01-21 10:00:47');
INSERT INTO `annotations` VALUES ('ann_ddcdd6ca3c36', 'task_918c8f5b76a7', 'current_user', '{\"result\": [{\"value\": {\"start\": 10, \"end\": 17, \"text\": \"\\uff0c\\u5f20\\u4e09\\u5728\\u5317\\u4eac\\u5927\", \"labels\": [\"\\u5730\\u540d\"]}, \"id\": \"IMh75W8bLY\", \"from_name\": \"label\", \"to_name\": \"text\", \"type\": \"labels\", \"origin\": \"manual\"}]}', '2026-01-21 10:02:31', '2026-01-21 10:02:31');
INSERT INTO `annotations` VALUES ('ann_fa2cfdbdf061', 'task_49835ad11f75', 'current_user', '{\"result\": [{\"value\": {\"start\": 18, \"end\": 30, \"text\": \"\\u4f7f\\u8ba1\\u7b97\\u673a\\u80fd\\u591f\\u4ece\\u6570\\u636e\\u4e2d\\u5b66\\u4e60\", \"labels\": [\"\\u5173\\u952e\\u8bcd\"]}, \"id\": \"4nt_bOQqyL\", \"from_name\": \"label\", \"to_name\": \"text\", \"type\": \"labels\", \"origin\": \"manual\"}]}', '2026-01-15 09:12:41', '2026-01-15 09:12:41');
INSERT INTO `annotations` VALUES ('ann_fc486c891408', 'task_651a1eb8eba9', 'current_user', '{\"result\": [{\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 28.625, \"y\": 31.70731707317073, \"width\": 16.375, \"height\": 18.38649155722327, \"rotation\": 0, \"rectanglelabels\": [\"\\u4eba\"]}, \"id\": \"COfSUsIOtR\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}, {\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 52.75, \"y\": 31.70731707317073, \"width\": 16.75, \"height\": 31.33208255159475, \"rotation\": 0, \"rectanglelabels\": [\"\\u8f66\"]}, \"id\": \"3KDhCLs_SW\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}, {\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 23.75, \"y\": 61.16322701688556, \"width\": 24.75, \"height\": 24.577861163227013, \"rotation\": 0, \"rectanglelabels\": [\"\\u81ea\\u884c\\u8f66\"]}, \"id\": \"xUO3CSDxWF\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}]}', '2026-01-21 08:44:22', '2026-01-21 10:00:27');

-- ----------------------------
-- Table structure for projects
-- ----------------------------
DROP TABLE IF EXISTS `projects`;
CREATE TABLE `projects`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of projects
-- ----------------------------
INSERT INTO `projects` VALUES ('proj_184d40f741d3', '关键点标注 - 人体姿态估计', '标注人体关键点（头部、肩膀、肘部、手腕、膝盖、脚踝）', '<View>\n  <Header value=\"关键点标注 - 人体姿态\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <KeyPointLabels name=\"keypoint\" toName=\"image\">\n    <Label value=\"头部\" background=\"red\"/>\n    <Label value=\"肩膀\" background=\"blue\"/>\n    <Label value=\"肘部\" background=\"green\"/>\n    <Label value=\"手腕\" background=\"orange\"/>\n    <Label value=\"膝盖\" background=\"purple\"/>\n    <Label value=\"脚踝\" background=\"pink\"/>\n  </KeyPointLabels>\n</View>', '2026-01-20 01:57:53');
INSERT INTO `projects` VALUES ('proj_1d139f153fc2', 'Project 2', 'Description 2', '<View></View>', '2026-01-12 09:42:01');
INSERT INTO `projects` VALUES ('proj_2cde4d9f0473', 'Test Project', 'A test project', '{\"type\":\"image\"}', '2026-01-22 07:43:24');
INSERT INTO `projects` VALUES ('proj_3371717af8b0', 'Test Project', 'A test project', '{\"type\":\"image\"}', '2026-01-22 07:44:20');
INSERT INTO `projects` VALUES ('proj_54497c8fd0fe', 'Project 0', 'Description 0', '<View></View>', '2026-01-12 09:42:01');
INSERT INTO `projects` VALUES ('proj_6ae8808c8aca', 'Test Project', 'Test Description', '<View></View>', '2026-01-12 09:42:01');
INSERT INTO `projects` VALUES ('proj_72b10c8c9760', '1', '123', '123123', '2026-01-13 01:46:12');
INSERT INTO `projects` VALUES ('proj_74abc15e846f', 'Updated Manual Test Project', 'Testing the API manually', '<View><Text name=\'text\' value=\'$text\'/></View>', '2026-01-12 09:43:42');
INSERT INTO `projects` VALUES ('proj_7bfaa470da67', '目标检测 - 街道场景', '标注街道场景中的人、车、自行车等物体', '<View>\n  <Header value=\"目标检测 - 物体识别\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <RectangleLabels name=\"label\" toName=\"image\">\n    <Label value=\"人\" background=\"red\"/>\n    <Label value=\"车\" background=\"blue\"/>\n    <Label value=\"自行车\" background=\"green\"/>\n    <Label value=\"狗\" background=\"orange\"/>\n    <Label value=\"猫\" background=\"purple\"/>\n  </RectangleLabels>\n</View>', '2026-01-20 01:57:30');
INSERT INTO `projects` VALUES ('proj_88c6a5634055', 'Updated Name', 'Updated Description', '<View></View>', '2026-01-12 09:42:01');
INSERT INTO `projects` VALUES ('proj_8a9a38046843', '多标签图像分类', '为图片添加多个属性标签（室内/室外、白天/夜晚等）', '<View>\n  <Header value=\"多标签图像分类\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <Choices name=\"attributes\" toName=\"image\" choice=\"multiple\" showInline=\"false\">\n    <Choice value=\"室内\"/>\n    <Choice value=\"室外\"/>\n    <Choice value=\"白天\"/>\n    <Choice value=\"夜晚\"/>\n    <Choice value=\"晴天\"/>\n    <Choice value=\"雨天\"/>\n    <Choice value=\"有人\"/>\n    <Choice value=\"无人\"/>\n  </Choices>\n</View>', '2026-01-20 01:57:59');
INSERT INTO `projects` VALUES ('proj_a27d01af8fc5', '文本高亮标注项目', '标记文本中的重要信息、关键词和问题', '<View>\n  <Header value=\"文本高亮标注\"/>\n  <Text name=\"text\" value=\"$text\"/>\n  <Labels name=\"label\" toName=\"text\">\n    <Label value=\"重要信息\" background=\"yellow\"/>\n    <Label value=\"关键词\" background=\"lightblue\"/>\n    <Label value=\"问题\" background=\"pink\"/>\n  </Labels>\n</View>', '2026-01-13 02:25:22');
INSERT INTO `projects` VALUES ('proj_bb449109487e', '情感分析标注项目', '对用户评论进行情感分类（正面/负面/中性）', '<View>\n  <Header value=\"文本分类标注\"/>\n  <Text name=\"text\" value=\"$text\"/>\n  <Choices name=\"sentiment\" toName=\"text\" choice=\"single\" showInline=\"true\">\n    <Choice value=\"正面\"/>\n    <Choice value=\"负面\"/>\n    <Choice value=\"中性\"/>\n  </Choices>\n</View>', '2026-01-13 02:25:08');
INSERT INTO `projects` VALUES ('proj_bdb7e77c0867', '图像分类', '将图片分类为风景、人物、动物、建筑、食物等类别', '<View>\n  <Header value=\"图像分类\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <Choices name=\"category\" toName=\"image\" choice=\"single\" showInline=\"true\">\n    <Choice value=\"风景\"/>\n    <Choice value=\"人物\"/>\n    <Choice value=\"动物\"/>\n    <Choice value=\"建筑\"/>\n    <Choice value=\"食物\"/>\n    <Choice value=\"其他\"/>\n  </Choices>\n</View>', '2026-01-20 01:57:38');
INSERT INTO `projects` VALUES ('proj_ccfcd6e8f988', '图像质量评估', '评估图片质量并标注存在的问题（模糊、曝光等）', '<View>\n  <Header value=\"图像质量评估\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <Choices name=\"quality\" toName=\"image\" choice=\"single\" showInline=\"true\">\n    <Choice value=\"优秀\"/>\n    <Choice value=\"良好\"/>\n    <Choice value=\"一般\"/>\n    <Choice value=\"较差\"/>\n  </Choices>\n  <Choices name=\"issues\" toName=\"image\" choice=\"multiple\" showInline=\"false\">\n    <Choice value=\"模糊\"/>\n    <Choice value=\"曝光过度\"/>\n    <Choice value=\"曝光不足\"/>\n    <Choice value=\"噪点多\"/>\n    <Choice value=\"色彩失真\"/>\n  </Choices>\n</View>', '2026-01-20 01:58:05');
INSERT INTO `projects` VALUES ('proj_dad6cafccde9', '图片测试', '123123', '<View>\n  <Header value=\"Select label and click the image to start\"/>\n  <Image name=\"image\" value=\"$image\" zoom=\"true\"/>\n  <PolygonLabels name=\"label\" toName=\"image\"\n                 strokeWidth=\"3\" pointSize=\"small\"\n                 opacity=\"0.9\">\n    <Label value=\"Airplane\" background=\"red\"/>\n    <Label value=\"Car\" background=\"blue\"/>\n  </PolygonLabels>\n</View>', '2026-01-20 01:35:48');
INSERT INTO `projects` VALUES ('proj_ed0c23756a04', 'Project 1', 'Description 1', '<View></View>', '2026-01-12 09:42:01');
INSERT INTO `projects` VALUES ('proj_f8a01451be86', '图像分割 - 物体轮廓', '使用多边形工具精细标注物体轮廓', '<View>\n  <Header value=\"图像分割 - 精细标注\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <PolygonLabels name=\"label\" toName=\"image\">\n    <Label value=\"前景\" background=\"rgba(255, 0, 0, 0.5)\"/>\n    <Label value=\"背景\" background=\"rgba(0, 0, 255, 0.5)\"/>\n    <Label value=\"物体\" background=\"rgba(0, 255, 0, 0.5)\"/>\n  </PolygonLabels>\n</View>', '2026-01-20 01:57:46');
INSERT INTO `projects` VALUES ('proj_f99b41b4b3f5', '命名实体识别项目', '识别文本中的人名、地名、机构名和时间等实体', '<View>\n  <Header value=\"命名实体识别\"/>\n  <Text name=\"text\" value=\"$text\"/>\n  <Labels name=\"label\" toName=\"text\">\n    <Label value=\"人名\" background=\"red\"/>\n    <Label value=\"地名\" background=\"blue\"/>\n    <Label value=\"机构名\" background=\"green\"/>\n    <Label value=\"时间\" background=\"orange\"/>\n  </Labels>\n</View>', '2026-01-13 02:25:16');
INSERT INTO `projects` VALUES ('proj_fc8b3cfd42e7', 'Test Project', 'Test Description', '<View><Image name=\'img\' value=\'$image\'/></View>', '2026-01-12 09:42:01');

-- ----------------------------
-- Table structure for tasks
-- ----------------------------
DROP TABLE IF EXISTS `tasks`;
CREATE TABLE `tasks`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'pending',
  `assigned_to` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_tasks_project`(`project_id`) USING BTREE,
  INDEX `idx_tasks_status`(`status`) USING BTREE,
  CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tasks
-- ----------------------------
INSERT INTO `tasks` VALUES ('task_03423e2aa5da', 'proj_8a9a38046843', '场景分析-1', '{\"image\": \"https://images.unsplash.com/photo-1464822759023-fed622ff2c3b?w=800\"}', 'pending', NULL, '2026-01-20 01:58:01');
INSERT INTO `tasks` VALUES ('task_0763c5d98044', 'proj_bdb7e77c0867', '风景图片-1', '{\"image\": \"https://images.unsplash.com/photo-1506905925346-21bda4d32df4?w=800\"}', 'pending', NULL, '2026-01-20 01:57:40');
INSERT INTO `tasks` VALUES ('task_11e92924c29d', 'proj_f99b41b4b3f5', '命名实体识别任务-2', '{\"text\": \"\\u674e\\u660e\\u662f\\u6e05\\u534e\\u5927\\u5b66\\u7684\\u6559\\u6388\\uff0c\\u4ed6\\u5728\\u4e0a\\u6d77\\u4ea4\\u901a\\u5927\\u5b66\\u83b7\\u5f97\\u4e86\\u535a\\u58eb\\u5b66\\u4f4d\\u3002\"}', 'completed', NULL, '2026-01-13 02:25:20');
INSERT INTO `tasks` VALUES ('task_12f44bd12afb', 'proj_bdb7e77c0867', '建筑图片-1', '{\"image\": \"https://images.unsplash.com/photo-1480714378408-67cf0d13bc1b?w=800\"}', 'pending', NULL, '2026-01-20 01:57:42');
INSERT INTO `tasks` VALUES ('task_156b3b77ffb7', 'proj_ccfcd6e8f988', '质量评估-1', '{\"image\": \"https://images.unsplash.com/photo-1472214103451-9374bd1c798e?w=800\"}', 'completed', NULL, '2026-01-20 01:58:07');
INSERT INTO `tasks` VALUES ('task_1629da00e218', 'proj_f8a01451be86', '物体分割-2', '{\"image\": \"https://images.unsplash.com/photo-1514888286974-6c03e2ca1dba?w=800\"}', 'pending', NULL, '2026-01-20 01:57:51');
INSERT INTO `tasks` VALUES ('task_1af9289d86f7', 'proj_7bfaa470da67', '街道场景-1', '{\"image\": \"https://images.unsplash.com/photo-1449824913935-59a10b8d2000?w=800\"}', 'completed', NULL, '2026-01-20 01:57:32');
INSERT INTO `tasks` VALUES ('task_1b884bdd989c', 'proj_8a9a38046843', '场景分析-2', '{\"image\": \"https://images.unsplash.com/photo-1469474968028-56623f02e42e?w=800\"}', 'pending', NULL, '2026-01-20 01:58:03');
INSERT INTO `tasks` VALUES ('task_1e6af2e95494', 'proj_1d139f153fc2', '123', '{\"data\": \"\\u8bf7\\u95ee\"}', 'pending', '123', '2026-01-13 02:13:04');
INSERT INTO `tasks` VALUES ('task_29701a5b2324', 'proj_bb449109487e', '文本分类任务-2', '{\"text\": \"\\u4ea7\\u54c1\\u8d28\\u91cf\\u592a\\u5dee\\u4e86\\uff0c\\u7528\\u4e86\\u4e0d\\u5230\\u4e00\\u5468\\u5c31\\u574f\\u4e86\\uff0c\\u5ba2\\u670d\\u6001\\u5ea6\\u4e5f\\u5f88\\u6076\\u52a3\\uff0c\\u975e\\u5e38\\u5931\\u671b\\u3002\"}', 'pending', NULL, '2026-01-13 02:25:12');
INSERT INTO `tasks` VALUES ('task_49835ad11f75', 'proj_a27d01af8fc5', '文本高亮任务-1', '{\"text\": \"\\u673a\\u5668\\u5b66\\u4e60\\u662f\\u4eba\\u5de5\\u667a\\u80fd\\u7684\\u4e00\\u4e2a\\u91cd\\u8981\\u5206\\u652f\\uff0c\\u5b83\\u4f7f\\u8ba1\\u7b97\\u673a\\u80fd\\u591f\\u4ece\\u6570\\u636e\\u4e2d\\u5b66\\u4e60\\u5e76\\u505a\\u51fa\\u51b3\\u7b56\\u3002\\u6df1\\u5ea6\\u5b66\\u4e60\\u662f\\u673a\\u5668\\u5b66\\u4e60\\u7684\\u4e00\\u4e2a\\u5b50\\u9886\\u57df\\uff0c\\u4f7f\\u7528\\u795e\\u7ecf\\u7f51\\u7edc\\u6765\\u6a21\\u62df\\u4eba\\u8111\\u7684\\u5de5\\u4f5c\\u65b9\\u5f0f\\u3002\"}', 'in_progress', NULL, '2026-01-13 02:25:24');
INSERT INTO `tasks` VALUES ('task_4bf9614120e0', 'proj_3371717af8b0', 'Test Task', '{\"items\": [{\"id\": 1, \"text\": \"Sample text\"}]}', 'pending', 'user_45ff87b34123', '2026-01-22 07:44:20');
INSERT INTO `tasks` VALUES ('task_4df2784ccbe2', 'proj_ccfcd6e8f988', '质量评估-2', '{\"image\": \"https://images.unsplash.com/photo-1501594907352-04cda38ebc29?w=800\"}', 'completed', NULL, '2026-01-20 01:58:09');
INSERT INTO `tasks` VALUES ('task_56621217e18a', 'proj_bb449109487e', '文本分类任务-1', '{\"text\": \"\\u8fd9\\u5bb6\\u9910\\u5385\\u7684\\u670d\\u52a1\\u6001\\u5ea6\\u975e\\u5e38\\u597d\\uff0c\\u83dc\\u54c1\\u4e5f\\u5f88\\u7f8e\\u5473\\uff0c\\u73af\\u5883\\u4f18\\u96c5\\uff0c\\u5f3a\\u70c8\\u63a8\\u8350\\uff01\"}', 'pending', NULL, '2026-01-13 02:25:10');
INSERT INTO `tasks` VALUES ('task_5d5fc8a3f8f7', 'proj_184d40f741d3', '人体姿态-2', '{\"image\": \"https://images.unsplash.com/photo-1517836357463-d25dfeac3438?w=800\"}', 'pending', NULL, '2026-01-20 01:57:57');
INSERT INTO `tasks` VALUES ('task_651a1eb8eba9', 'proj_7bfaa470da67', '公园场景', '{\"image\": \"https://images.unsplash.com/photo-1441974231531-c6227db76b6e?w=800\"}', 'completed', NULL, '2026-01-20 01:57:36');
INSERT INTO `tasks` VALUES ('task_80385274acb5', 'proj_f8a01451be86', '物体分割-1', '{\"image\": \"https://images.unsplash.com/photo-1518791841217-8f162f1e1131?w=800\"}', 'completed', NULL, '2026-01-20 01:57:49');
INSERT INTO `tasks` VALUES ('task_918c8f5b76a7', 'proj_f99b41b4b3f5', '命名实体识别任务-1', '{\"text\": \"2024\\u5e741\\u670815\\u65e5\\uff0c\\u5f20\\u4e09\\u5728\\u5317\\u4eac\\u5927\\u5b66\\u53c2\\u52a0\\u4e86\\u4eba\\u5de5\\u667a\\u80fd\\u7814\\u8ba8\\u4f1a\\u3002\"}', 'completed', NULL, '2026-01-13 02:25:18');
INSERT INTO `tasks` VALUES ('task_94503e84b095', 'proj_bb449109487e', '文本分类任务-3', '{\"text\": \"\\u8fd9\\u6b3e\\u624b\\u673a\\u6027\\u80fd\\u4e00\\u822c\\uff0c\\u4ef7\\u683c\\u9002\\u4e2d\\uff0c\\u9002\\u5408\\u65e5\\u5e38\\u4f7f\\u7528\\u3002\"}', 'pending', NULL, '2026-01-13 02:25:14');
INSERT INTO `tasks` VALUES ('task_9dfba8d63541', 'proj_bdb7e77c0867', '动物图片-1', '{\"image\": \"https://images.unsplash.com/photo-1425082661705-1834bfd09dca?w=800\"}', 'in_progress', NULL, '2026-01-20 01:57:44');
INSERT INTO `tasks` VALUES ('task_e095e9480142', 'proj_7bfaa470da67', '街道场景-2', '{\"image\": \"https://images.unsplash.com/photo-1477959858617-67f85cf4f1df?w=800\"}', 'completed', NULL, '2026-01-20 01:57:34');
INSERT INTO `tasks` VALUES ('task_eee0f95c961b', 'proj_184d40f741d3', '人体姿态-1', '{\"image\": \"https://images.unsplash.com/photo-1571019614242-c5c5dee9f50b?w=800\"}', 'pending', NULL, '2026-01-20 01:57:55');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'annotator',
  `oauth_provider` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `oauth_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE,
  UNIQUE INDEX `email`(`email`) USING BTREE,
  INDEX `idx_users_username`(`username`) USING BTREE,
  INDEX `idx_users_email`(`email`) USING BTREE,
  INDEX `idx_users_oauth`(`oauth_provider`, `oauth_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('user_20260122180848_6a6d9cad', 'zhangsan', 'zhangsan@qq.com', '', 'annotator', 'sso', 'd3e906de-b9a6-4a78-a643-233252252776', '2026-01-22 18:08:49', '2026-01-22 10:08:48');
INSERT INTO `users` VALUES ('user_20260129151138_93b2226d', 'admin', 'admin@example.com', '', 'annotator', 'sso', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2026-01-29 15:11:38', '2026-01-29 15:11:37');
INSERT INTO `users` VALUES ('user_45ff87b34123', 'testuser2', 'test2@example.com', '$2b$12$1a9JM.mrG0s5CYvuq7d1ZOetmKN3bjCD1xGs9YaDJzJd17VpX0O9i', 'annotator', NULL, NULL, '2026-01-22 07:44:20', '2026-01-22 07:44:20');
INSERT INTO `users` VALUES ('user_91797832d370', 'testuser', 'test@example.com', '$2b$12$1tw51ab6rLi1mWzrC3NcQujFOswYZ5iLMq3BPZ4VoIy8.QYmCJui2', 'annotator', NULL, NULL, '2026-01-22 07:41:36', '2026-01-22 07:41:36');

SET FOREIGN_KEY_CHECKS = 1;
