27 lines
624 B
JavaScript
27 lines
624 B
JavaScript
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; |