package newnotable;

import DataBase.DatabaseManagement;

/**
 * ÓÃÓÚ´´½¨²»´æÔÚµÄÊý¾Ý¿â±í·½·¨
 *
 * @yang2021
 */
public class Creattable {
    /**
     * ´´½¨CO¼Ç¼±íÈç¹û²»´æÔÚ
     */
    public void tb_cojilu() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_cojilu` ("
                + "`id` int(100) NOT NULL AUTO_INCREMENT,"
                + "`tagid` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©ID',"
                + "`name` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'Ãû³Æ',"
                + " `nongdu` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'Ũ¶È',"
                + "`oknongdu` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'Õý³£·¶Î§',"
                + "`state` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '״̬',"
                + "`xypos` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'λÖÃ×ø±ê',"
                + "`time` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'ʱ¼ä',"
                + "`baoliu1` varchar(100) COLLATE utf8_bin DEFAULT NULL,"
                + "`baoliu2` varchar(100) COLLATE utf8_bin DEFAULT NULL,"
                + "`baoliu3` varchar(100) COLLATE utf8_bin DEFAULT NULL,"
                + "`baoliu4` varchar(100) COLLATE utf8_bin DEFAULT NULL,"
                + "`baoliu5` varchar(100) COLLATE utf8_bin DEFAULT NULL,"
                + "`baoliu6` varchar(100) COLLATE utf8_bin DEFAULT NULL,"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    public void tb_heart_record() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_heart_record` ("
                + "`id` int(20) NOT NULL AUTO_INCREMENT,"
                + "`tagid` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©ID',"
                + "`name` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'ÐÕÃû',"
                + "`heart` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'ÐÄÌø',"
                + "`okheart` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'Õý³£ÐÄÂÊÖµ',"
                + "`state` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'ÐÄÂÊ״̬',"
                + "`time` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '¼Ç¼ʱ¼ä',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    /**
     * ±êÇ©ÀëÏ߼Ǽ±í
     */
    public void tb_lixianrecord_0829() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_lixianrecord_0829` ("
                + "`id` int(20) NOT NULL AUTO_INCREMENT,"
                + "`tagid` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©ID',"
                + "`name` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'ÐÕÃû',"
                + "`bumen` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '²¿ÃÅ',"
                + "`phone` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'µç»°',"
                + "`time` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'ÀëÏßʱ¼ä',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB AUTO_INCREMENT=312 DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    public void tb_nav() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_nav` ("
                + "`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ÐòºÅ',"
                + "`label` varchar(255) DEFAULT NULL COMMENT '±êÇ©¹ÜÀí',"
                + "`achor` varchar(255) DEFAULT NULL COMMENT '»ùÕ¾¹ÜÀí',"
                + "`gps` varchar(255) DEFAULT NULL COMMENT 'urtÊý¾Ý',"
                + "`fence` varchar(255) DEFAULT NULL COMMENT 'ΧÀ¸¹ÜÀí',"
                + "`warning` varchar(255) DEFAULT NULL COMMENT '¸æ¾¯¹ÜÀí',"
                + "`history` varchar(255) DEFAULT NULL COMMENT 'ÀúÊ·Êý¾Ý',"
                + "`attendance` varchar(255) DEFAULT NULL COMMENT '¿¼ÇÚ¹ÜÀí',"
                + "`basiclnfo` varchar(255) DEFAULT NULL COMMENT '»ù´¡ÐÅÏ¢',"
                + "`video` varchar(255) DEFAULT NULL COMMENT 'ÊÓƵÁª¶¯',"
                + " `gas` varchar(255) DEFAULT NULL COMMENT 'ÆøÌå¼ì²â',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8";
        DatabaseManagement.update(sql);

    }

    public void tb_permission() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_permission` ("
                + "`id` int(20) NOT NULL AUTO_INCREMENT,"
                + "`type` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '¼Ç¼ÀàÐÍ',"
                + "`name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT 'ÐÕÃû',"
                + "`tagid` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©ID',"
                + "`event` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT 'ʼþ',"
                + "`details` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT 'Î¥¹æ¼Ç¼',"
                + "`addtime` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT 'Ìí¼Óʱ¼ä',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);

    }

    public void tb_task() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_task` ("
                + "`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ÐòºÅ',"
                + "`name` varchar(255) DEFAULT NULL COMMENT 'ÈÎÎñÃû³Æ',"
                + "`phone` varchar(255) DEFAULT NULL COMMENT 'µç»°',"
                + "`fences` varchar(255) DEFAULT NULL COMMENT '°ó¶¨µÄΧÀ¸',"
                + "`bumen` varchar(255) DEFAULT NULL COMMENT '°ó¶¨µÄ²¿ÃÅ',"
                + "`tagids` varchar(255) DEFAULT NULL COMMENT '±êÇ©ID',"
                + "`addtime` varchar(255) DEFAULT NULL COMMENT 'Ìí¼Óʱ¼ä',"
                + "`startup` varchar(255) DEFAULT NULL COMMENT 'ÊÇ·ñ¿ªÆôÈÎÎñ',"
                + "`baoliu1` varchar(50) DEFAULT NULL,"
                + "`baoliu2` varchar(50) DEFAULT NULL,"
                + "`baoliu3` varchar(50) DEFAULT NULL,"
                + "`baoliu4` varchar(50) DEFAULT NULL,"
                + "`baoliu5` varchar(50) DEFAULT NULL,"
                + "`baoliu6` varchar(50) DEFAULT NULL,"
                + "`baoliu7` varchar(50) DEFAULT NULL,"
                + "`baoliu8` varchar(50) DEFAULT NULL,"
                + "`baoliu9` varchar(50) DEFAULT NULL,"
                + "`baoliu10` varchar(50) DEFAULT NULL,"
                + "`baoliu11` varchar(50) DEFAULT NULL,"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8";
        DatabaseManagement.update(sql);

    }

    public void tb_person() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_person` ("
                + "`id` int(11) NOT NULL AUTO_INCREMENT,"
                + "`p_name` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT 'δ°ó¶¨' COMMENT 'ÈËÔ±ÐÕÃû',"
                + "`p_tagid` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '°ó¶¨µÄtagid',"
                + "`p_sex` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'ÄÐ' COMMENT 'ÐÔ±ð',"
                + "`p_minzu` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT 'ºº' COMMENT 'Ãñ×å',"
                + "`p_phone` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '152****' COMMENT 'µç»°',"
                + "`p_department` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT 'ϵͳĬÈÏ' COMMENT '²¿ÃÅ',"
                + "`p_ban` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '°à',"
                + "`p_zu` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '×é',"
                + "`p_idcardnum` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT 'Éí·ÝÖ¤ºÅ',"
                + "`p_adress` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT 'Éí·ÝÖ¤µØÖ·',"
                + "`p_canin` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '¿É´ïÇøÓò',"
                + "`p_x` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT 'x×ø±ê',"
                + "`p_y` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT 'y×ø±ê',"
                + "`p_floor` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT 'ËùÔÚ²ã',"
                + "`p_sos` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT 'SOS״̬1±¨¾¯£¬0䱨¾¯',"
                + "`p_online` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÔÚÏß0ÀëÏߣ¬1ÔÚÏß',"
                + "`p_power` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '100' COMMENT 'µçÁ¿',"
                + "`p_kaoqing` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñ½øÈ뿼ÇÚÇøÓò0ûÓнøÈë1½øÈë',"
                + "`p_fence` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñ½øÈëΧÀ¸ÇøÓò0²»ÔÚ£¬1ÔÚ',"
                + "`p_fencename` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT 'ËùÔÚΧÀ¸ÇøÓòÃû³Æ',"
                + "`p_kaoqqingname` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT 'ËùÔÚ¿¼ÇÚÇøÓòÃû³Æ',"
                + "`p_image` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT 'image/targeticon/default.png' COMMENT 'ͼ±êµØÖ·',"
                + "`p_addtiem` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '2021-06-08 08:25:04' COMMENT 'Ìí¼Óʱ¼ä',"
                + "`p_power_wanig` varchar(10) CHARACTER SET utf8 DEFAULT '0' COMMENT '±êÇ©µÍµçÁ¿¸æ¾¯×´Ì¬¸æ¾¯Îª1ûÓи澯Ϊ0',"
                + "`p_sousuo` varchar(10) CHARACTER SET utf8 DEFAULT '0' COMMENT 'ĬÈÏ0δËÑË÷״̬£¬1ËÑË÷״̬',"
                + "`p_shipin` varchar(10) CHARACTER SET utf8 DEFAULT '0' COMMENT 'ÊÇ·ñ½øÈëÊÓƵÇøÓò',"
                + "`p_shipingname` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT 'ÊÓƵÇøÓòÃû³Æ',"
                + "`baoliu1` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '·Ã¿ÍID',"
                + "`baoliu2` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '±êÇ©µÄ¾­¶È',"
                + "`baoliu3` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '±êÇ©µÄγ¶È',"
                + "`baoliu4` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '±êÇ©µÄ¸ß³Ì',"
                + "`baoliu5` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '±êÇ©ÊÇʲôÀàÐͱêÇ©£¬ÈںϱêÇ©2£¬´¿UWB±êÇ©1',"
                + "`baoliu6` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '²ð³ý¸æ¾¯1',"
                + "`baoliu7` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'µ¥Î»',"
                + "`baoliu8` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©µÄµØÖ·IPµØÖ·ÈںϱêÇ©ÓÃ',"
                + "`baoliu9` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©µÄ¶Ë¿ÚÈںϱêÇ©ÓÃ',"
                + "`baoliu10` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'Ïà¶Ôº£°Î¸ß¶È',"
                + "`baoliu11` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'RTCMÔ´',"
                + "`baoliu12` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '°ó¶¨µÄΧÀ¸',"
                + "`baoliu13` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'GPS״̬',"
                + "`baoliu14` varchar(50) COLLATE utf8_bin DEFAULT NULL,"
                + "`baoliu15` varchar(50) COLLATE utf8_bin DEFAULT NULL,"
                + "`baoliu16` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'ÈËÔ±µÄÐÄÂÊ',"
                + "`baoliu17` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©ÊÇ·ñ³ö×÷ÒµÇøÓòÊÇΪ1²»ÊÇΪ0',"
                + "`baoliu18` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '³öÈëȨÏÞ',"
                + "`baoliu19` varchar(50) COLLATE utf8_bin DEFAULT 'ϵͳĬÈÏ' COMMENT '±êÇ©µÄÀàÐÍ',"
                + "`baoliu20` varchar(50) COLLATE utf8_bin DEFAULT '0' COMMENT 'ÊÇ·ñÔÚ½øß澯ÇøÓò1ÔÚ',"
                + "`baoliu21` varchar(50) COLLATE utf8_bin DEFAULT '0' COMMENT 'ÊÇ·ñÔÚ³öß澯ÇøÓò0²»ÔÚ',"
                + "`baoliu22` varchar(50) COLLATE utf8_bin DEFAULT NULL,"
                + "`baoliu23` varchar(50) COLLATE utf8_bin DEFAULT NULL,"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    /**
     * ´´½¨Ëã·¨2±í
     */
    public void tb_suanfa2() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_suanfa2` ("
                + "`id` int(10) NOT NULL DEFAULT '0',"
                + "`gnss2xy` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '1' COMMENT 'GNSSתXY×ø±êĬÈÏ¿ªÆô',"
                + "`pingmianbuju` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '1' COMMENT 'ÔÊÐíƽÃæ²¼¾Ö',"
                + "`dis_juge_indo0r` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ͨ¹ý²â¾à¾àÀëÅжÏÊÒÄÚÍâ',"
                + "`gps_xinhao_indoor` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ͨ¹ýÎÀÐÇÐźÅÇ¿¶ÈÅжÏÊÒÄÚÍâ',"
                + "`just_buju_qu` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '½ö²¼¾ÖÇøÄÚÓÐЧ',"
                + "`jnalog` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '¿ªÆôJNAlog¿ª¹Ø',"
                + "`indoor_juge_in` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '1' COMMENT 'ͨ¹ýÊÒÄÚÇøÓòÅжÏÊÒÄÚÍ⹦ÄÜ',"
                + "`jing_zhi_lv_zhi` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '¾²Ö¹¹ýÂËÖµ£¬Ä¬ÈÏ0',"
                + "`shi_xi_fen_pei` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ʱϸ·Ö·ÖÅä0±íʾMIX£¬1±íʾGAP',"
                + "`lv_bo_fang_shi` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Â˲¨·½Ê½0»¬¶¯Âʲ¨£¬1µÍͨÂ˲¨',"
                + "`wei_zhi_guo_lv` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '300' COMMENT 'λÖùýÂËÖµ',"
                + "`shu_ju_zhuan_fa` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Êý¾Ýת·¢ÉèÖÃ0²»×ª·¢×îºóλÖã¬1ÀëÏßת·¢£¬2ÐÝÃßת·¢£¬3ÀëÏßÐÝÃßת·¢',"
                + "`gps_qiangdu` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '28;26;10' COMMENT 'ÎÀÐÇÐźÅÇ¿¶È·¶Î§',"
                + "`baoliu2` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu3` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu4` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu5` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu6` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu7` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu8` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu9` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu10` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    public void tb_ceng_zu() {
        String sql = "CREATE TABLE IF NOT EXISTS`tb_ceng_zu` ("
                + "`id` varchar(10) COLLATE utf8_bin NOT NULL,"
                + "`floor` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '²ã',"
                + "`zu` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '×é',"
                + "`bi_jing_ju_li` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '±Ø¾­¾àÀë',"
                + "`is_shi_wai_zu` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ',"
                + "`is_bi_jing_zu` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ',"
                + "`suan_fa_wei_du` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '2' COMMENT 'Ëã·¨µÄά¶È0,1,2,3',"
                + "`suan_fa` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT 'TOF' COMMENT 'ĬÈÏTOF',"
                + "`zu_kua_duo_ceng` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT '×é¿ç¶à²ã',"
                + "`you_xiao_qu_yu` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'ÓÐЧÇøÓò',"
                + "`zu_kuang_du` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '×é¿í¶È',"
                + "`baoliu1` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu2` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu3` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu4` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu5` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu6` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu7` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu8` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu9` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "`baoliu10` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '0',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    /**
     * ´´½¨Æøѹ»ùÕ¾µÄÊý¾Ý±í·½·¨yang20230730
     */
    public void creat_tb_gas_anchor() {
        String sql = "CREATE TABLE IF NOT EXISTS`tb_gas_anchor` ("
                + " `id` int(10) NOT NULL AUTO_INCREMENT,"
                + " `anchorid` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Æøѹ»ùÕ¾ID',"
                + "`anchorid2` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '±¸ÓÃÆøѹ»ùÕ¾ID',"
                + "`anchorx` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Æøѹ»ùÕ¾X×ø±ê',"
                + "`anchory` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Æøѹ»ùÕ¾Y×ø±ê',"
                + "`anchorz` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT 'Æøѹ»ùÕ¾Z×ø±ê',"
                + "`onlie` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT 'Æøѹ»ùվ״̬ÔÚÏß1ÀëÏß0',"
                + "`gasvalue` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT 'Æøѹ»ùÕ¾Æøѹֵ',"
                + "`refresh_time` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT 'Æøѹ»ùÕ¾¸üÐÂÊý¾Ýʱ¼ä',"
                + "`baoliu1` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu2` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu3` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu4` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu5` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + " PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    public void tb_line() {
        String sql = "CREATE TABLE IF NOT EXISTS  `tb_line` ("
                + "`id` int(11) NOT NULL AUTO_INCREMENT,"
                + "`flr` varchar(270) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`grp` varchar(270) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`vnum` varchar(270) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`px` varchar(900) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`py` varchar(900) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`wd` varchar(90) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`lineId` varchar(270) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu1` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu2` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu3` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    public void tb_ac_history_power() {
        String sql = "CREATE TABLE IF NOT EXISTS `tb_ac_history_power` ("
                + "`id` int(50) NOT NULL AUTO_INCREMENT,"
                + "`anchorId` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0001' COMMENT '»ùÕ¾ID',"
                + "`power` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '''-1''' COMMENT 'µçÁ¿',"
                + "`addtime` varchar(500) COLLATE utf8_bin NOT NULL DEFAULT '2015-11-02 12:00:00' COMMENT 'Ìí¼Óʱ¼ä',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB AUTO_INCREMENT=83763 DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);

    }

    /**
     * ±£´æ±êÇ©ÆøѹУ׼ֵ
     *
     * @author yang20230801
     */
    public void tb_tag_gas_jiaozhun_value() {
        String sql = "CREATE TABLE IF NOT EXISTS  `tb_tag_gas_jiaozhun_value` ("
                + "`id` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '±£´æ±êÇ©ÆøѹУ׼ֵ',"
                + "`tagid` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT '±êÇ©±àºÅ',"
                + "`gasanchorid` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT 'Æøѹ»ùÕ¾ID',"
                + "`value` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT 'ÆøѹУ׼ֵ',"
                + "`timesnum` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT 'У׼´ÎÊý',"
                + "`time` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1' COMMENT '×îÐÂУ׼ʱ¼ä',"
                + "`baoliu1` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1'  COMMENT 'У׼Çé¿ö',"
                + "`baoliu2` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu3` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu4` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "`baoliu5` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '-1',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }

    /**
     * ±êÇ©ÆøѹÀúÊ·¼Ç¼ֵ
     */
    public void tag_gas_history() {
        String sql = "CREATE TABLE IF NOT EXISTS   `tag_gas_history` ("
                + "`id` int(100) NOT NULL AUTO_INCREMENT,"
                + "`tagid` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©ID',"
                + "`gasanchorid` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'Æøѹ»ùÕ¾ID',"
                + "`taggas` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '±êÇ©Æøѹֵ',"
                + "`anchorgas` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '»ùÕ¾Æøѹֵ',"
                + "`reallgao` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '±êǩʵʱ¸ß¶È',"
                + "`time` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'Êý¾ÝÌí¼Óʱ¼ä',"
                + "PRIMARY KEY (`id`)"
                + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin";
        DatabaseManagement.update(sql);
    }


    /**
     * ´´½¨²»´æÔڵıí
     */
    public void no_exists_table() {
        tb_line();//´´½¨Ò»Î¬ÏßÊý¾Ý±í
        tb_cojilu();//CO±í
        tb_heart_record();//ÐÄÂʼǼ±í
        tb_lixianrecord_0829();//ÀëÏ߼Ǽ±í
        tb_nav();
        tb_permission();
        tb_task();
        tb_person();
        tb_suanfa2();//´´½¨Ëã·¨2Êý¾Ý±í
        tb_ceng_zu();//´´½¨²ã×éÊý¾Ý±í
        creat_tb_gas_anchor();//´´½¨Æøѹ»ùÕ¾Êý¾Ý±í
        tb_ac_history_power();
        tb_tag_gas_jiaozhun_value();//±£´æ±êÇ©ÆøѹУ׼ֵ
        tag_gas_history();

    }
}