github.com/gogf/gf/v2@v2.7.4/database/gdb/testdata/issue1401.sql (about)

     1  -- ----------------------------
     2  -- Table structure for parcel_items
     3  -- ----------------------------
     4  DROP TABLE IF EXISTS `parcel_items`;
     5  CREATE TABLE `parcel_items`  (
     6      `id` int(11) NOT NULL,
     7      `parcel_id` int(11) NULL DEFAULT NULL,
     8      `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
     9      PRIMARY KEY (`id`) USING BTREE
    10  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    11  
    12  -- ----------------------------
    13  -- Records of parcel_items
    14  -- ----------------------------
    15  INSERT INTO `parcel_items` VALUES (1, 1, '新品');
    16  INSERT INTO `parcel_items` VALUES (2, 3, '新品2');
    17  
    18  -- ----------------------------
    19  -- Table structure for parcels
    20  -- ----------------------------
    21  DROP TABLE IF EXISTS `parcels`;
    22  CREATE TABLE `parcels`  (
    23      `id` int(11) NOT NULL AUTO_INCREMENT,
    24      PRIMARY KEY (`id`) USING BTREE
    25  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    26  
    27  -- ----------------------------
    28  -- Records of parcels
    29  -- ----------------------------
    30  INSERT INTO `parcels` VALUES (1);
    31  INSERT INTO `parcels` VALUES (2);
    32  INSERT INTO `parcels` VALUES (3);