EMS2.0-Documents/5.数据库创建脚本以及数据字典/数据库脚本/MongoDB录入文件/cabinet_device.sql

67 lines
1.9 KiB
MySQL
Raw Permalink Normal View History

2024-11-28 09:29:02 +08:00
/*
Navicat Premium Data Transfer
Source Server : mongodb-106
Source Server Type : MongoDB
Source Server Version : 50020
Source Host : 116.236.50.106:37027
Source Schema : cabinet_device
Target Server Type : MongoDB
Target Server Version : 50020
File Encoding : 65001
Date: 05/01/2024 16:28:12
*/
// ----------------------------
// Collection structure for IEMS2-AppConfig
// ----------------------------
db.getCollection("IEMS2-AppConfig").drop();
db.createCollection("IEMS2-AppConfig");
// ----------------------------
// Collection structure for IEMS2-deviceDictionary
// ----------------------------
db.getCollection("IEMS2-deviceDictionary").drop();
db.createCollection("IEMS2-deviceDictionary");
// ----------------------------
// Collection structure for IEMS2-deviceStatus
// ----------------------------
db.getCollection("IEMS2-deviceStatus").drop();
db.createCollection("IEMS2-deviceStatus");
// ----------------------------
// Collection structure for IEMS2-screenBattery
// ----------------------------
db.getCollection("IEMS2-screenBattery").drop();
db.createCollection("IEMS2-screenBattery");
// ----------------------------
// Collection structure for IEMS2-screenPower
// ----------------------------
db.getCollection("IEMS2-screenPower").drop();
db.createCollection("IEMS2-screenPower");
// ----------------------------
// Collection structure for IEMS2-screenRectify
// ----------------------------
db.getCollection("IEMS2-screenRectify").drop();
db.createCollection("IEMS2-screenRectify");
// ----------------------------
// Collection structure for IEMS2-screenSensor
// ----------------------------
db.getCollection("IEMS2-screenSensor").drop();
db.createCollection("IEMS2-screenSensor");
// ----------------------------
// Collection structure for IEMS2-snmpParam
// ----------------------------
db.getCollection("IEMS2-snmpParam").drop();
db.createCollection("IEMS2-snmpParam");