DROP TABLE IF EXISTS `field_config`;
CREATE TABLE `field_config`  (
  `text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

INSERT INTO `field_config` VALUES ('area_id');
INSERT INTO `field_config` VALUES ('parent_id');
INSERT INTO `field_config` VALUES ('area_name');
INSERT INTO `field_config` VALUES ('area_type');

DROP TABLE IF EXISTS `ks_areas`;
CREATE TABLE `ks_areas`  (
  `area_id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '地區(qū)id',
  `parent_id` smallint(6) UNSIGNED NOT NULL DEFAULT 0 COMMENT '地區(qū)父id',
  `area_name` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '地區(qū)名稱',
  `area_type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '地區(qū)類型 0:country,1:province,2:city,3:district',
  PRIMARY KEY (`area_id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE,
  INDEX `area_type`(`area_type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3429 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

INSERT INTO `ks_areas` VALUES (1, 0, '中國', 0);
INSERT INTO `ks_areas` VALUES (2, 1, '北京', 1);
INSERT INTO `ks_areas` VALUES (3, 1, '安徽', 1);
INSERT INTO `ks_areas` VALUES (4, 1, '福建', 1);
INSERT INTO `ks_areas` VALUES (5, 1, '甘肅', 1);
INSERT INTO `ks_areas` VALUES (6, 1, '廣東', 1);
INSERT INTO `ks_areas` VALUES (7, 1, '廣西', 1);

SET @var = '1';
SET @var1 = (SELECT CONCAT('JSON_OBJECT\(',GROUP_CONCAT(CONCAT('\'',text,'\',',text)),'\)') from field_config);
SET @strsql = concat('SELECT ',@var1,' from ks_areas where area_id >', @var);
PREPARE stmt FROM @strsql;
EXECUTE stmt;

ALTER TABLE ks_areas ADD test varchar(20) COMMENT '測試字段';

INSERT into field_config VALUE('test');