-- fzx 2022.07.31 -- 2022.08.10 -- 2022.10.09
-- Ver 2.5.0
-- 制作模板方法：利用一个空小区（建议利用老模板新建小区，升级到新版本），用小区用户登录,,清空log，数据备份（不选物业公司、不选数据库信息）。
-- 2022.10.09 替换"0000-00-00"为"1000-01-01"，涉及4个表合计5处。
-- //2022.10.09 增加收费员更换仪表、停止仪表授权管理。2022-10-11移除此功能，因为这实用

-- MySQL dump 10.13  Distrib 5.7.29, for Win64 (x86_64)
--
-- Host: 121.4.12.8    Database: qcpcms!alswy!mbxq
-- ------------------------------------------------------
-- Server version	5.5.5-10.5.9-MariaDB-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer` (
  `房产编号` varchar(20) NOT NULL DEFAULT '',
  `客户姓名` varchar(5) DEFAULT NULL,
  `电话号码` varchar(20) DEFAULT NULL,
  `备用电话` varchar(20) DEFAULT NULL,
  `证件类型` varchar(5) DEFAULT NULL,
  `证件号码` varchar(18) DEFAULT NULL,
  `客户备注` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`房产编号`),
  CONSTRAINT `customer_ibfk_2` FOREIGN KEY (`房产编号`) REFERENCES `realty` (`房产编号`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='客户信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deposit`
--

DROP TABLE IF EXISTS `deposit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `deposit` (
  `收取日期` date NOT NULL DEFAULT '1000-01-01',
  `流水号收` mediumint(4) NOT NULL DEFAULT 0,
  `项目名称` varchar(5) NOT NULL DEFAULT '',
  `押金金额` int(11) DEFAULT NULL,
  `房产编号` varchar(20) DEFAULT NULL COMMENT '物业编号，如车位编号、房产编号等',
  `客户姓名` varchar(5) DEFAULT NULL,
  `客户电话` varchar(20) DEFAULT NULL,
  `退还日期` date DEFAULT NULL,
  `流水号退` mediumint(4) DEFAULT NULL,
  `备注` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`收取日期`,`流水号收`),
  KEY `房产编号` (`房产编号`),
  CONSTRAINT `deposit_ibfk_1` FOREIGN KEY (`房产编号`) REFERENCES `realty` (`房产编号`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='押金（保证金）';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deposit`
--

LOCK TABLES `deposit` WRITE;
/*!40000 ALTER TABLE `deposit` DISABLE KEYS */;
/*!40000 ALTER TABLE `deposit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `feelist`
--

DROP TABLE IF EXISTS `feelist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feelist` (
  `房产编号` varchar(20) NOT NULL DEFAULT '',
  `收取日期` date NOT NULL DEFAULT '1000-01-01',
  `流水号` mediumint(4) NOT NULL DEFAULT 0,
  `费用名称` varchar(15) NOT NULL DEFAULT '',
  `计费日期` date NOT NULL DEFAULT '1000-01-01' COMMENT '对于时续性费用，意为止日期',
  `数量` double(15,1) DEFAULT NULL,
  `费用金额` int(11) DEFAULT NULL,
  `优惠金额` int(11) DEFAULT NULL COMMENT '打印到备注中，滞纳金相反',
  PRIMARY KEY (`房产编号`,`收取日期`,`流水号`,`费用名称`,`计费日期`) USING BTREE,
  KEY `费用名称` (`费用名称`),
  CONSTRAINT `feelist_ibfk_1` FOREIGN KEY (`房产编号`) REFERENCES `realty` (`房产编号`) ON UPDATE CASCADE,
  CONSTRAINT `feelist_ibfk_2` FOREIGN KEY (`费用名称`) REFERENCES `feetype` (`费用名称`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='计费清单,一房一费一账户，有各自余额。\r\n';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `feelist`
--

LOCK TABLES `feelist` WRITE;
/*!40000 ALTER TABLE `feelist` DISABLE KEYS */;
/*!40000 ALTER TABLE `feelist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `feerate`
--

DROP TABLE IF EXISTS `feerate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feerate` (
  `房产类型` varchar(5) NOT NULL DEFAULT '',
  `费用名称` varchar(15) NOT NULL DEFAULT '',
  `日期` date NOT NULL DEFAULT '2010-01-01',
  `要求楼层` tinyint(2) unsigned NOT NULL DEFAULT 0 COMMENT '比如超过7楼算高层，收取二次加压。',
  `费率` float(8,3) DEFAULT NULL,
  `附加费率` float(7,3) DEFAULT NULL,
  PRIMARY KEY (`房产类型`,`费用名称`,`日期`,`要求楼层`),
  KEY `费用名称` (`费用名称`),
  CONSTRAINT `feerate_ibfk_1` FOREIGN KEY (`房产类型`) REFERENCES `realtype` (`房产类型`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `feerate_ibfk_2` FOREIGN KEY (`费用名称`) REFERENCES `feetype` (`费用名称`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `feerate`
--

LOCK TABLES `feerate` WRITE;
/*!40000 ALTER TABLE `feerate` DISABLE KEYS */;
INSERT INTO `feerate` VALUES ('商铺','垃圾处理费','2010-01-01',0,7.000,NULL),('商铺','天燃气初装费','2010-01-01',0,2800.000,NULL),('商铺','物业管理费','2010-01-01',0,0.480,NULL),('商铺','电费','2010-01-01',0,0.680,0.120),('商铺','装修垃圾处理','2010-01-01',0,200.000,NULL),('多层','垃圾处理费','2010-01-01',0,7.000,NULL),('多层','天燃气初装费','2010-01-01',0,2800.000,NULL),('多层','有限电视初装','2010-01-01',0,320.000,NULL),('多层','物业管理费','2010-01-01',0,0.480,NULL),('多层','电费','2010-01-01',0,0.560,0.040),('多层','装修垃圾处理','2010-01-01',0,200.000,NULL),('电梯','二次加压','2010-01-01',7,1.000,NULL),('电梯','垃圾处理费','2010-01-01',0,7.000,NULL),('电梯','天燃气初装费','2010-01-01',0,2800.000,NULL),('电梯','有限电视初装','2010-01-01',0,320.000,NULL),('电梯','物业管理费','2010-01-01',0,0.480,NULL),('电梯','物业管理费','2010-01-01',3,0.950,NULL),('电梯','电费','2010-01-01',0,0.560,0.040),('电梯','装修垃圾处理','2010-01-01',0,200.000,NULL);
/*!40000 ALTER TABLE `feerate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `feetype`
--

DROP TABLE IF EXISTS `feetype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feetype` (
  `费用名称` varchar(15) NOT NULL DEFAULT '' COMMENT '以[调整]结尾，可处理奇偶式费率',
  `计费方式` enum('仪表','面积','按户') DEFAULT '面积',
  `启用` enum('Y','') DEFAULT 'Y',
  `费用性质` enum('常规','临时','代收') NOT NULL DEFAULT '常规',
  `计量单位` varchar(3) DEFAULT NULL,
  `仪表名称` varchar(5) DEFAULT NULL COMMENT '按仪表计费才有意义',
  `缺省数量` tinyint(4) DEFAULT NULL COMMENT '常规性质下按户、面积收取时的缺省数量，一般为12，非常规或按仪表时无意义。',
  `附加费名` varchar(5) DEFAULT NULL COMMENT '如电费附加损耗，水费附加二次加压',
  `收取方式` enum('预存','收费','预存/收费') DEFAULT NULL,
  `保留小数` enum('0','1','2') NOT NULL DEFAULT '0',
  `手工优惠` enum('Y','') DEFAULT '',
  `欠费提醒` enum('Y','') DEFAULT '',
  `银行代收` enum('Y','') DEFAULT '',
  `顺序` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`费用名称`),
  KEY `仪表名称` (`仪表名称`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `feetype`
--

LOCK TABLES `feetype` WRITE;
/*!40000 ALTER TABLE `feetype` DISABLE KEYS */;
INSERT INTO `feetype` VALUES ('二次加压','仪表','Y','常规','吨','水表',NULL,NULL,NULL,'2','','Y','',5),('垃圾处理费','按户','Y','常规','月','',12,NULL,NULL,'0','Y','Y','',2),('天燃气初装费','按户','Y','代收','户','',1,NULL,NULL,'0','','','',12),('有限电视初装','按户','Y','代收','户','',1,NULL,NULL,'0','','','',11),('物业管理费','面积','Y','常规','㎡','',12,NULL,NULL,'0','Y','Y','Y',1),('电梯运行费','按户','Y','常规','月',NULL,12,NULL,NULL,'0','','','',3),('电费','仪表','Y','常规','度','电表',NULL,'综合损耗','预存','2',NULL,'Y','Y',4),('装修垃圾处理','按户','Y','临时','户',NULL,1,NULL,NULL,'0','',NULL,'',7);
/*!40000 ALTER TABLE `feetype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inexpensive`
--

DROP TABLE IF EXISTS `inexpensive`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inexpensive` (
  `活动名称` varchar(255) NOT NULL,
  `费用名称` varchar(15) NOT NULL DEFAULT '',
  `优惠活动` varchar(10) DEFAULT NULL COMMENT '格式示例：2/12，表示满12个月，优惠2个月，即只收10个月。',
  `适用房型` varchar(255) DEFAULT NULL,
  `显示方式` enum('全显','半显','不显') DEFAULT '全显' COMMENT '全显--正常费用额，记录优惠额并打印；半显--正常费用额，记录优惠额但不打印；不显--直接减少费用额。',
  `启用` enum('Y','') DEFAULT NULL,
  PRIMARY KEY (`活动名称`) USING BTREE,
  KEY `费用名称` (`费用名称`) USING BTREE,
  CONSTRAINT `inexpensive_ibfk_1` FOREIGN KEY (`费用名称`) REFERENCES `feetype` (`费用名称`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inexpensive`
--

LOCK TABLES `inexpensive` WRITE;
/*!40000 ALTER TABLE `inexpensive` DISABLE KEYS */;
INSERT INTO `inexpensive` VALUES ('入驻有礼','物业管理费','6/12','安置房','不显','Y'),('新春活动','物业管理费','2/12','商品房,安置房','不显','Y');
/*!40000 ALTER TABLE `inexpensive` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log` (
  `日期` datetime NOT NULL COMMENT '套账日志',
  `用户` char(4) NOT NULL,
  `模块` varchar(10) DEFAULT NULL,
  `描述` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`日期`,`描述`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log`
--

LOCK TABLES `log` WRITE;
/*!40000 ALTER TABLE `log` DISABLE KEYS */;
INSERT INTO `log` VALUES ('2022-07-31 07:36:16','ywgl',NULL,'升级数据库，原版本:2.3.1，新版本:2.5.0'),('2022-07-31 08:18:41','gly',NULL,'登录。客户端版本：2.5.0.0');
/*!40000 ALTER TABLE `log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `meter`
--

DROP TABLE IF EXISTS `meter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meter` (
  `房产编号` varchar(20) NOT NULL DEFAULT '',
  `仪表名称` varchar(5) NOT NULL DEFAULT '',
  `安装位置` varchar(5) NOT NULL DEFAULT '',
  `抄表分组` varchar(5) DEFAULT '',
  `排序编号` varchar(8) DEFAULT NULL,
  `启用` enum('Y','') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`房产编号`,`仪表名称`,`安装位置`),
  KEY `仪表名称` (`仪表名称`),
  CONSTRAINT `meter_ibfk_1` FOREIGN KEY (`房产编号`) REFERENCES `realty` (`房产编号`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `meter_ibfk_2` FOREIGN KEY (`仪表名称`) REFERENCES `feetype` (`仪表名称`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='各种表的基本信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `meter`
--

LOCK TABLES `meter` WRITE;
/*!40000 ALTER TABLE `meter` DISABLE KEYS */;
/*!40000 ALTER TABLE `meter` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `meterbalance`
--

DROP TABLE IF EXISTS `meterbalance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meterbalance` (
  `房产编号` varchar(20) NOT NULL DEFAULT '',
  `仪表名称` varchar(8) NOT NULL DEFAULT '',
  `安装位置` varchar(5) NOT NULL DEFAULT '',
  `抄表日期` date NOT NULL DEFAULT '1000-01-01',
  `表显数字` int(11) DEFAULT NULL,
  `费率` float(6,3) DEFAULT NULL,
  `抄表员工` varchar(5) DEFAULT NULL COMMENT '有没实际意义，仅与读表员工一起，备查',
  `用量` int(10) DEFAULT NULL,
  `费用金额` int(11) DEFAULT NULL,
  `附加费率` float(6,3) DEFAULT NULL,
  `附加金额` int(11) DEFAULT NULL,
  `抄表方式` enum('登记','抄表','更换') NOT NULL DEFAULT '抄表',
  `优惠金额` int(11) DEFAULT NULL,
  `收取日期` date DEFAULT NULL,
  `流水号` mediumint(4) DEFAULT NULL,
  PRIMARY KEY (`房产编号`,`仪表名称`,`安装位置`,`抄表日期`),
  KEY `收取流水` (`收取日期`,`流水号`),
  CONSTRAINT `meterbalance_ibfk_1` FOREIGN KEY (`房产编号`, `仪表名称`, `安装位置`) REFERENCES `meter` (`房产编号`, `仪表名称`, `安装位置`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='各种表的余额';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `meterbalance`
--

LOCK TABLES `meterbalance` WRITE;
/*!40000 ALTER TABLE `meterbalance` DISABLE KEYS */;
/*!40000 ALTER TABLE `meterbalance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `money`
--

DROP TABLE IF EXISTS `money`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `money` (
  `收取日期` date NOT NULL DEFAULT '1000-01-01',
  `流水号` mediumint(4) NOT NULL DEFAULT 0,
  `房产编号` varchar(20) DEFAULT NULL,
  `业务类型` varchar(4) DEFAULT NULL,
  `金额` int(11) DEFAULT NULL,
  `收取人` varchar(5) DEFAULT NULL,
  `删除时间` datetime DEFAULT NULL,
  `删除原因` varchar(10) DEFAULT NULL,
  `删除人` varchar(5) DEFAULT NULL,
  `代收银行` varchar(5) DEFAULT NULL,
  `代收流水` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`收取日期`,`流水号`),
  KEY `房产编号` (`房产编号`),
  CONSTRAINT `money_ibfk_1` FOREIGN KEY (`房产编号`) REFERENCES `realty` (`房产编号`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `money`
--

LOCK TABLES `money` WRITE;
/*!40000 ALTER TABLE `money` DISABLE KEYS */;
/*!40000 ALTER TABLE `money` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `precharge`
--

DROP TABLE IF EXISTS `precharge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `precharge` (
  `房产编号` varchar(20) NOT NULL,
  `费用名称` varchar(5) NOT NULL,
  `收取日期` date NOT NULL,
  `流水号` mediumint(4) NOT NULL DEFAULT 0,
  `收取金额` int(11) DEFAULT NULL,
  `扣费金额` int(11) NOT NULL DEFAULT 0,
  `余额` int(11) DEFAULT NULL,
  PRIMARY KEY (`房产编号`,`费用名称`,`收取日期`,`流水号`) USING BTREE,
  KEY `费用名称` (`费用名称`),
  CONSTRAINT `precharge_ibfk_1` FOREIGN KEY (`房产编号`) REFERENCES `realty` (`房产编号`) ON UPDATE CASCADE,
  CONSTRAINT `precharge_ibfk_2` FOREIGN KEY (`费用名称`) REFERENCES `feetype` (`费用名称`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `precharge`
--

LOCK TABLES `precharge` WRITE;
/*!40000 ALTER TABLE `precharge` DISABLE KEYS */;
/*!40000 ALTER TABLE `precharge` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `realty`
--

DROP TABLE IF EXISTS `realty`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `realty` (
  `房产编号` varchar(20) NOT NULL DEFAULT '',
  `房产类型` varchar(5) NOT NULL DEFAULT '',
  `楼层` tinyint(2) unsigned NOT NULL DEFAULT 1,
  `计费面积` double(12,2) DEFAULT NULL,
  `起费日期` date DEFAULT NULL,
  `登记员工` varchar(5) DEFAULT NULL,
  `登记日期` date DEFAULT NULL,
  `银行代收` enum('','关') DEFAULT '',
  `打印分页` varchar(2) DEFAULT NULL COMMENT '标志符号：^P',
  PRIMARY KEY (`房产编号`),
  KEY `房产类型` (`房产类型`),
  KEY `房产编号` (`房产编号`),
  KEY `房产编号_2` (`房产编号`),
  CONSTRAINT `realty_ibfk_1` FOREIGN KEY (`房产类型`) REFERENCES `realtype` (`房产类型`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `realty`
--

LOCK TABLES `realty` WRITE;
/*!40000 ALTER TABLE `realty` DISABLE KEYS */;
/*!40000 ALTER TABLE `realty` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `realtype`
--

DROP TABLE IF EXISTS `realtype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `realtype` (
  `房产类型` varchar(5) NOT NULL COMMENT '例如：住宅、商铺、车位等',
  `编码规则` varchar(20) DEFAULT NULL COMMENT '编码规则：用来对房产进行编码。最多可以设4项，项目间用编码规则间隔符间隔。',
  `楼层节位` tinyint(2) unsigned DEFAULT NULL COMMENT '楼层节位：用于自动抓取楼层，从1开始计数，0或大于节数表示不抓取。',
  `左取字符` tinyint(2) unsigned DEFAULT NULL,
  `序号` tinyint(2) unsigned DEFAULT NULL,
  PRIMARY KEY (`房产类型`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `realtype`
--

LOCK TABLES `realtype` WRITE;
/*!40000 ALTER TABLE `realtype` DISABLE KEYS */;
INSERT INTO `realtype` VALUES ('商铺','铺-栋-间',2,2,5),('多层','栋-单元-户',3,2,3),('电梯','栋-单元-户',3,2,1);
/*!40000 ALTER TABLE `realtype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `variable`
--

DROP TABLE IF EXISTS `variable`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variable` (
  `类别` varchar(5) NOT NULL DEFAULT '',
  `变量名` varchar(10) NOT NULL DEFAULT '',
  `变量值` varchar(50) DEFAULT NULL,
  `枚举值` varchar(100) DEFAULT NULL,
  `枚举缺省` varchar(100) DEFAULT NULL,
  `序号` tinyint(4) DEFAULT NULL,
  `备注说明` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`类别`,`变量名`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统信息及系统变量，变量名为程序约定，所以不能随便改变。类别主要起排序作用。';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variable`
--

LOCK TABLES `variable` WRITE;
/*!40000 ALTER TABLE `variable` DISABLE KEYS */;
INSERT INTO `variable` VALUES ('物业','小区名称','mbxq',NULL,NULL,1,NULL),('物业','抄表月份判断标准日','15',NULL,'10',31,'标准日前算上月,多表取较大值'),('物业','收据仪表汇总方式','抄表分组','抄表分组,安装位置','0',25,NULL),('物业','收据止日自动减一','No','Yes,No','1',15,NULL),('物业','收费凭证按月编号','No','Yes,No','1',17,NULL),('物业','收费凭证标题','XX物业公司（[小区名称]）[收取方式]凭证',NULL,'XX物业公司（[小区名称]）[收取方式]凭证',12,'[小区名称]、[收取方式]为约定变量名称占位符'),('物业','收费凭证联别归属','白联存根　红联客户　黄联记账',NULL,'白联存根　红联客户　黄联记账',4,NULL),('物业','收费员日期权限','No','Yes,No','1',21,NULL),('物业','数据库版本','2.5.0',NULL,NULL,11,NULL),('物业','温馨提示','请每月12-17号到物业办交费。联系电话:',NULL,'请每月12-17号到物业办交费。联系电话:',2,NULL),('物业','物业办电话','',NULL,NULL,3,NULL),('物业','缺省密码强制修改','Yes','Yes,No','0',16,NULL),('物业','附加费用打印方式','主附分行','主附同行,主附分行','1',26,''),('物业','预存提醒阀值','50',NULL,'50',9,NULL);
-- INSERT INTO variable(`类别`, `变量名`, `变量值`, `枚举值`, `枚举缺省`, `序号`, `备注说明`) VALUES ('物业', '收费员换表权限', 'Yes', 'Yes,No', '1', 33, NULL);
-- INSERT INTO variable(`类别`, `变量名`, `变量值`, `枚举值`, `枚举缺省`, `序号`, `备注说明`) VALUES ('物业', '收费员停表权限', 'Yes', 'Yes,No', '1', 34, NULL);
/*!40000 ALTER TABLE `variable` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-07-31  8:19:33
