const db=require("../comman/db")

let sql="CREATE TABLE IF NOT EXISTS `remotemqtt`.`devuser` (\
  `autoid` INT NOT NULL AUTO_INCREMENT,\
  `devid` INT NOT NULL,\
  `devname` VARCHAR(255) NOT NULL,\
  `simnumber` VARCHAR(20) NOT NULL,\
  `simtotal` INT NULL,\
  `simused` INT NULL,\
  `simdateline` DATE NULL,\
  `devusername` TEXT NULL,\
  `beizhu` TEXT NULL,\
  PRIMARY KEY (`autoid`)\
) ENGINE = InnoDB;\
"

async function initdb(){
    db.query(sql,(err)=>{
        if(err){
            console.log(err);
        }
        else{
            console.log("create devuser success");
        }
    })
}
exports.initdb=initdb;