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();
|
|
}
|
}
|
