-- MySQL dump 10.13  Distrib 8.0.31, for Linux (x86_64)
--
-- Host: localhost    Database: finance
-- ------------------------------------------------------
-- Server version	8.0.31-0ubuntu0.20.04.1

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 `balance_type`
--

DROP TABLE IF EXISTS `balance_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `balance_type` (
  `tid` tinyint unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COMMENT='收支選項';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `balance_type`
--

LOCK TABLES `balance_type` WRITE;
/*!40000 ALTER TABLE `balance_type` DISABLE KEYS */;
INSERT INTO `balance_type` VALUES (1,'收入'),(2,'支出'),(3,'互轉'),(4,'初始開帳');
/*!40000 ALTER TABLE `balance_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cash_type`
--

DROP TABLE IF EXISTS `cash_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cash_type` (
  `typeid` tinyint unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `account` varchar(6) NOT NULL COMMENT '代碼',
  `tid` tinyint unsigned NOT NULL COMMENT '類別號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  PRIMARY KEY (`typeid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 COMMENT='款項類別';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cash_type`
--

LOCK TABLES `cash_type` WRITE;
/*!40000 ALTER TABLE `cash_type` DISABLE KEYS */;
INSERT INTO `cash_type` VALUES (1,'1100',1,'現金收入'),(2,'1102',1,'零用金收入'),(3,'1100',2,'現金支出'),(4,'1102',2,'零用金支出'),(5,'1103',1,'匯入款'),(6,'1103',2,'匯出款'),(7,'1103',3,'銀行互轉'),(8,'1121',1,'應收票據'),(9,'1143',1,'應收收入'),(10,'2120',2,'應付票據'),(11,'2170',2,'應付費用'),(12,'3999',4,'上期結轉');
/*!40000 ALTER TABLE `cash_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config_alert`
--

DROP TABLE IF EXISTS `config_alert`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `config_alert` (
  `conid` varchar(10) NOT NULL COMMENT 'ID',
  `payment` tinyint(1) NOT NULL COMMENT '繳交通知',
  `arrear` tinyint(1) NOT NULL COMMENT '欠繳通知',
  PRIMARY KEY (`conid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='通知設定';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_alert`
--

LOCK TABLES `config_alert` WRITE;
/*!40000 ALTER TABLE `config_alert` DISABLE KEYS */;
INSERT INTO `config_alert` VALUES ('config',0,0);
/*!40000 ALTER TABLE `config_alert` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config_close`
--

DROP TABLE IF EXISTS `config_close`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `config_close` (
  `mid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `ymonth` varchar(7) NOT NULL COMMENT '關帳日',
  `account` varchar(30) NOT NULL COMMENT '帳號',
  `username` varchar(60) NOT NULL COMMENT '姓名',
  `cdate` varchar(20) NOT NULL COMMENT '時間',
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='月關帳設定';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_close`
--

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

--
-- Table structure for table `config_ticket`
--

DROP TABLE IF EXISTS `config_ticket`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `config_ticket` (
  `account` varchar(20) NOT NULL COMMENT '特別帳號',
  `code` varchar(10) NOT NULL COMMENT '科目代碼',
  `title` varchar(50) NOT NULL COMMENT '科目名稱',
  `borrow` varchar(10) NOT NULL COMMENT '借方餘額',
  `loan` varchar(10) NOT NULL COMMENT '貸方餘額',
  `note` varchar(200) NOT NULL COMMENT '摘要',
  `odate` varchar(10) NOT NULL COMMENT '開帳日期',
  PRIMARY KEY (`account`,`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='開帳傳票設定';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_ticket`
--

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

--
-- Table structure for table `config_year`
--

DROP TABLE IF EXISTS `config_year`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `config_year` (
  `edate` varchar(10) NOT NULL COMMENT '關帳日',
  `account` varchar(30) NOT NULL COMMENT '帳號',
  `username` varchar(60) NOT NULL COMMENT '姓名',
  `cdate` varchar(20) NOT NULL COMMENT '時間',
  PRIMARY KEY (`edate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='年度結轉設定';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_year`
--

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

--
-- Table structure for table `finances_general`
--

DROP TABLE IF EXISTS `finances_general`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `finances_general` (
  `account` varchar(20) NOT NULL COMMENT '會計帳號',
  `type` varchar(255) NOT NULL,
  `title` varchar(50) NOT NULL COMMENT '會計科目',
  `borrow` varchar(10) NOT NULL COMMENT '借方餘額',
  `loan` varchar(10) NOT NULL COMMENT '貸方餘額',
  `note` varchar(200) NOT NULL COMMENT '摘要',
  `chk` varchar(1) NOT NULL DEFAULT 'N' COMMENT '內定否',
  PRIMARY KEY (`account`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='一般會計科目';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `finances_general`
--

LOCK TABLES `finances_general` WRITE;
/*!40000 ALTER TABLE `finances_general` DISABLE KEYS */;
INSERT INTO `finances_general` VALUES ('1100','','現金','','','系統內定','Y'),('1102','','零用金','','','系統內定','Y'),('1103','','銀行存款','','','系統內定','Y'),('1101','銀行','上海銀行-新莊分行','','','銀行存款-六月份(期初)','N'),('1121','','應收票據','','','系統內定','Y'),('1143','','應收收入','','','系統內定','Y'),('1153','','呆帳','','','系統內定','Y'),('1154','','預付款','','','系統內定','Y'),('2110','','預收款','','','系統內定','Y'),('2120','','應付票據','','','系統內定','Y'),('2143','','應付帳款','','','系統內定','Y'),('2170','','應付費用','','','系統內定','Y'),('3998','','結轉下期','','','系統內定','Y'),('3999','','上期結轉','','','系統內定','Y'),('4101','','社區管理費','','','系統內定','Y'),('4102','','汽車位租金','','','系統內定','Y'),('4103','','機車位租金','','','系統內定','Y'),('4104','','汽車位清潔費','','','系統內定','Y'),('4105','','機車位清潔費','','','系統內定','Y'),('4106','','其它費','','','系統內定','Y'),('4107','','收視費','','','系統內定','Y'),('4108','','特別費','','','系統內定','Y'),('8103','','電費補助','','','','N'),('1702','','電腦設備','','','','N'),('1701','','監視器設備','','','','N'),('11011','銀行','板信銀行-新莊分行','','','銀行存款-六月份(期初)','N'),('11012','銀行','三信銀行-新莊分行','','','銀行存款-六月份(期初)','N'),('3410','','利息收入','','','','N'),('11013','銀行','定期存款','','','上海銀行加板信銀行','N'),('8101','','文具費用','','','','N'),('6004','','電梯費','','','','N'),('6003','','機電費','','','','N'),('6005','','垃圾清運費','','','','N'),('6001','','台灣電力公司','','','','N'),('6002','','保全物業費','','','','N'),('41071','','磁扣收入','','','','N'),('5001','','機電維修費','','','','N'),('5002','','監視器維修費','','','','N'),('5003','','園藝維修費','','','','N'),('5004','','電梯維修費','','','','N'),('5005','','大門維修費','','','','N'),('9001','','規費','','','','N'),('6006','','電信費','','','','N'),('5006','','地下室修維費','','','','N'),('4109','','裝潢保證金','','','','N'),('8102','','裝潢工保證金','','','','N'),('6007','','自來水公司','','','','N'),('6008','','銀行手續費','','','','N');
/*!40000 ALTER TABLE `finances_general` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `finances_special`
--

DROP TABLE IF EXISTS `finances_special`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `finances_special` (
  `sid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `houseid` int unsigned NOT NULL COMMENT '住戶序號',
  `account` varchar(20) NOT NULL COMMENT '會計帳號',
  `title` varchar(50) NOT NULL COMMENT '會計科目',
  `borrow` varchar(10) NOT NULL COMMENT '借方餘額',
  `loan` varchar(10) NOT NULL COMMENT '貸方餘額',
  `note` varchar(200) NOT NULL COMMENT '摘要',
  `fixed` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '定繳',
  `chk_old` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '歷史',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=148 DEFAULT CHARSET=utf8mb3 COMMENT='特別會計科目';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `finances_special`
--

LOCK TABLES `finances_special` WRITE;
/*!40000 ALTER TABLE `finances_special` DISABLE KEYS */;
INSERT INTO `finances_special` VALUES (1,1,'A-288-1-0','中平派出所','','','',1,0),(2,2,'A-288-2-0','中平派出所','','','',1,0),(3,3,'A-288-3-0','江金蓮','','','',1,0),(4,4,'A-288-4-0','徐黃綠雲','','','',1,0),(5,5,'A-288-5-0','劉耿維','','','',1,0),(6,6,'A-288-6-0','王銘勳','','','',1,0),(7,7,'A-288-7-0','林美華','','','',1,0),(8,8,'A-288-8-0','吳麗玉','','','',1,0),(9,9,'A-288-9-0','李廖素霞','','','',1,0),(10,10,'A-288之1-1-0','吳安政','','','',1,0),(11,11,'A-288之1-2-0','林金蓉','','','',1,0),(12,12,'A-288之1-3-0','陳妶微','','','',1,0),(13,13,'A-288之1-4-0','林順桂','','','',1,0),(14,14,'A-288之1-5-0','黃駿橙','','','',1,0),(15,15,'A-288之1-6-0','陳明忠','','','',1,0),(16,16,'A-288之1-7-0','蔡彩英','','','',1,0),(17,17,'A-288之1-8-0','游勝豪','','','',1,0),(18,18,'A-288之1-9-0','李榮純','','','',1,0),(19,77,'A-288之10-1-0','徐常平','','','',1,0),(20,78,'A-288之10-2-0','黃秀玉','','','',1,0),(21,79,'A-288之10-3-0','李清華','','','',1,0),(22,80,'A-288之10-4-0','魏建忠','','','',1,0),(23,81,'A-288之10-5-0','廖怡珍','','','',1,0),(24,82,'A-288之10-6-0','莊廣文','','','',1,0),(25,83,'A-288之10-7-0','林兆利','','','',1,0),(26,84,'A-288之10-8-0','許秀蕙','','','',1,0),(27,85,'A-288之10-9-0','黃琪祥','','','',1,0),(28,86,'A-288之11-1-0','張庭瑞','','','',1,0),(29,87,'A-288之11-2-0','李志峰','','','',1,0),(30,88,'A-288之11-3-0','王炳弦','','','',1,0),(31,89,'A-288之11-4-0','李淑蓉','','','',1,0),(32,90,'A-288之11-5-0','李婉后','','','',1,0),(33,91,'A-288之11-6-0','黃郁善','','','',1,0),(34,92,'A-288之11-7-0','潘陳怡伶','','','',1,0),(35,93,'A-288之11-8-0','周姝吟','','','',1,0),(36,94,'A-288之11-9-0','林淑娟','','','',1,0),(37,95,'A-288之12-1-0','徐婉妮','','','',1,0),(38,96,'A-288之12-2-0','徐婉妮','','','',1,0),(39,97,'A-288之12-3-0','華依帆','','','',1,0),(40,98,'A-288之12-4-0','徐文龍','','','',1,0),(41,99,'A-288之12-5-0','丁正隆','','','',1,0),(42,100,'A-288之12-6-0','吳汶涓','','','',1,0),(43,101,'A-288之12-7-0','陳志勇','','','',1,0),(44,102,'A-288之12-8-0','邱明慧','','','',1,0),(45,103,'A-288之12-9-0','柯宏融','','','',1,0),(46,104,'A-288之13-1-0','姚崑山','','','',1,0),(47,105,'A-288之13-2-0','朱秋玉','','','',1,0),(48,106,'A-288之13-3-0','鍾宜娟','','','',1,0),(49,107,'A-288之13-4-0','賀泳峰','','','',1,0),(50,108,'A-288之13-5-0','林振榮','','','',1,0),(51,109,'A-288之13-6-0','張和華','','','',1,0),(52,110,'A-288之13-7-0','曾清秀','','','',1,0),(53,111,'A-288之13-8-0','潘俊樺','','','',1,0),(54,112,'A-288之13-9-0','陳翠娟','','','',1,0),(55,113,'A-288之15-2-0','黃嬴慧','','','',1,0),(56,114,'A-288之15-3-0','陳鳳玉','','','',1,0),(57,115,'A-288之15-4-0','吳晉寧','','','',1,0),(58,116,'A-288之15-5-0','陳鴻霖','','','',1,0),(59,117,'A-288之15-6-0','黃瀞葳','','','',1,0),(60,118,'A-288之15-7-0','李雅凌','','','',1,0),(61,119,'A-288之15-8-0','黃淑卿','','','',1,0),(62,120,'A-288之15-9-0','陳翠娟','','','',1,0),(63,121,'A-288之16-1-0','李美來','','','',1,0),(64,122,'A-288之16-2-0','中平派出所','','','',1,0),(65,123,'A-288之16-3-0','蔡玉卿','','','',1,0),(66,124,'A-288之16-4-0','林忻','','','',1,0),(67,125,'A-288之16-5-0','游秀珠','','','',1,0),(68,126,'A-288之16-6-0','鍾海山','','','',1,0),(69,127,'A-288之16-7-0','李秉澤','','','',1,0),(70,128,'A-288之16-8-0','王文正','','','',1,0),(71,129,'A-288之16-9-0','留振村','','','',1,0),(72,130,'A-288之17-1-0','楊桂真','','','',1,0),(73,131,'A-288之17-2-0','中平派出所','','','',1,0),(74,132,'A-288之17-3-0','彭美鈴','','','',1,0),(75,133,'A-288之17-4-0','鄭智豪','','','',1,0),(76,134,'A-288之17-5-0','蔣其財','','','',1,0),(77,135,'A-288之17-6-0','蔡秀雯','','','',1,0),(78,136,'A-288之17-7-0','葉麗卿','','','',1,0),(79,137,'A-288之17-8-0','朱婉瑜','','','',1,0),(80,138,'A-288之17-9-0','黃洪春玉','','','',1,0),(81,19,'A-288之2-1-0','徐常平','','','',1,0),(82,20,'A-288之2-2-0','楊菲菲','','','',1,0),(83,21,'A-288之2-3-0','黃清文','','','',1,0),(84,22,'A-288之2-4-0','詹紋璟','','','',1,0),(85,23,'A-288之2-5-0','劉逸梅','','','',1,0),(86,24,'A-288之2-6-0','謝裕益','','','',1,0),(87,25,'A-288之2-7-0','劉秀香','','','',1,0),(88,26,'A-288之2-8-0','謝麗美','','','',1,0),(89,27,'A-288之2-9-0','陳吉隆','','','',1,0),(90,28,'A-288之3-1-0','盧叔湘','','','',1,0),(91,29,'A-288之3-2-0','陳佳慧','','','',1,0),(92,30,'A-288之3-3-0','黃錦鳳','','','',1,0),(93,31,'A-288之3-4-0','黃信真','','','',1,0),(94,32,'A-288之3-5-0','丁健祐','','','',1,0),(95,33,'A-288之3-6-0','王漪夆','','','',1,0),(96,34,'A-288之3-7-0','李路然','','','',1,0),(97,35,'A-288之3-8-0','陳美麗','','','',1,0),(98,36,'A-288之3-9-0','劉炳文','','','',1,0),(99,37,'A-288之5-1-0','李玲玲','','','',1,0),(100,38,'A-288之5-2-0','李玲玲','','','',1,0),(101,39,'A-288之5-3-0','劉耿昌','','','',1,0),(102,40,'A-288之5-4-0','邱創樺','','','',1,0),(103,41,'A-288之5-5-0','高明偉','','','',1,0),(104,42,'A-288之5-6-0','盧純卿','','','',1,0),(105,43,'A-288之5-7-0','徐淑鳳','','','',1,0),(106,44,'A-288之5-8-0','林高煌','','','',1,0),(107,45,'A-288之6-1-0','劉意文','','','',1,0),(108,46,'A-288之6-2-0','吳美佐','','','',1,0),(109,47,'A-288之6-3-0','吳美佐','','','',1,0),(110,48,'A-288之6-4-0','蕭世傑','','','',1,0),(111,49,'A-288之6-5-0','林進益','','','',1,0),(112,50,'A-288之6-6-0','黃月玲','','','',1,0),(113,51,'A-288之6-7-0','王志騰','','','',1,0),(114,52,'A-288之6-8-0','陳淑美','','','',1,0),(115,53,'A-288之7-1-0','梁興品','','','',1,0),(116,54,'A-288之7-2-0','李時茵','','','',1,0),(117,55,'A-288之7-3-0','吳建智','','','',1,0),(118,56,'A-288之7-4-0','施議貴','','','',1,0),(119,57,'A-288之7-5-0','鍾文惠','','','',1,0),(120,58,'A-288之7-6-0','林信杏','','','',1,0),(121,59,'A-288之7-7-0','李東興','','','',1,0),(122,60,'A-288之7-8-0','李能汝','','','',1,0),(123,61,'A-288之8-1-0','黃李助','','','',1,0),(124,62,'A-288之8-2-0','蘇麗芳','','','',1,0),(125,63,'A-288之8-3-0','葉郁菁','','','',1,0),(126,64,'A-288之8-4-0','林秋賓','','','',1,0),(127,65,'A-288之8-5-0','葉懿瑩','','','',1,0),(128,66,'A-288之8-6-0','蔡芙蓉','','','',1,0),(129,67,'A-288之8-7-0','蘇守任','','','',1,0),(130,68,'A-288之8-8-0','林素珠','','','',1,0),(131,69,'A-288之9-1-0','王勝弘','','','',1,0),(132,70,'A-288之9-2-0','羅美穎','','','',1,0),(133,71,'A-288之9-3-0','羅建中','','','',1,0),(134,72,'A-288之9-4-0','陳瑩珊','','','',1,0),(135,73,'A-288之9-5-0','朱修世','','','',1,0),(136,74,'A-288之9-6-0','江姿瑾','','','',1,0),(137,75,'A-288之9-7-0','蔡明君','','','',1,0),(138,76,'A-288之9-8-0','張權毅','','','',1,0),(139,139,'B-286-1-0','中平派出所','','','',1,0),(140,140,'B-286-2-0','中平派出所','','','',1,0),(141,141,'B-286-3-0','江金蓮','','','',1,0),(142,142,'B-286-4-0','徐黃綠雲','','','',1,0),(143,143,'B-286-5-0','簡余伊','','','',1,0),(144,144,'B-286-6-0','王銘勳','','','',1,0),(145,145,'B-286-7-0','林美華','','','',1,0),(146,146,'B-286-8-0','黃柏舜','','','',1,0),(147,147,'B-286-9-0','李廖素霞','','','',1,0);
/*!40000 ALTER TABLE `finances_special` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `finances_subject`
--

DROP TABLE IF EXISTS `finances_subject`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `finances_subject` (
  `cat` varchar(20) NOT NULL COMMENT '科目類別',
  `title` varchar(50) NOT NULL COMMENT '科目名稱',
  `range1` varchar(10) NOT NULL COMMENT '範圍起',
  `range2` varchar(10) NOT NULL COMMENT '範圍迄',
  `note` varchar(200) NOT NULL COMMENT '說明',
  PRIMARY KEY (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='科目類別名稱帳號';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `finances_subject`
--

LOCK TABLES `finances_subject` WRITE;
/*!40000 ALTER TABLE `finances_subject` DISABLE KEYS */;
INSERT INTO `finances_subject` VALUES ('1100','流動資產','1100','1499',''),('1500','固定資產','1500','1699',''),('1700','其它資產','1700','1999',''),('2100','流動負債','2100','2499',''),('2500','長期負債','2500','2699',''),('2700','其它負債','2700','2999',''),('3100','累積盈虧','3100','3199',''),('3200','上期損益','3200','3299',''),('3300','公共基金','3300','3399',''),('3800','本期損益','3800','3899',''),('4100','收入類','4100','4999',''),('5000','社區維護類','5000','5999',''),('6000','費用類','6000','6999',''),('7100','其它收入','7100','7999',''),('8100','其它支出','8100','8999',''),('9100','所得稅','9100','9499','');
/*!40000 ALTER TABLE `finances_subject` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `monthend`
--

DROP TABLE IF EXISTS `monthend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `monthend` (
  `ymonth` varchar(7) NOT NULL COMMENT '年月',
  `get_item` varchar(8) NOT NULL COMMENT '收支項目',
  `get_itemname` varchar(20) NOT NULL COMMENT '項目名稱',
  `getfee` varchar(10) NOT NULL COMMENT '收入',
  `payfee` varchar(10) NOT NULL COMMENT '支出',
  PRIMARY KEY (`ymonth`,`get_item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='月結資料';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `monthend`
--

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

--
-- Table structure for table `op_committee`
--

DROP TABLE IF EXISTS `op_committee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `op_committee` (
  `cid` varchar(10) NOT NULL COMMENT '編號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  `note` varchar(100) NOT NULL COMMENT '摘要',
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='委員職稱設定';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `op_committee`
--

LOCK TABLES `op_committee` WRITE;
/*!40000 ALTER TABLE `op_committee` DISABLE KEYS */;
INSERT INTO `op_committee` VALUES ('C01','主任委員',''),('C02','副主任委員',''),('C03','財務委員',''),('C04','監察委員',''),('C05','行政委員',''),('c06','福利委員','');
/*!40000 ALTER TABLE `op_committee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `op_factory`
--

DROP TABLE IF EXISTS `op_factory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `op_factory` (
  `fid` varchar(10) NOT NULL COMMENT '編號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  `note` varchar(100) NOT NULL COMMENT '摘要',
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='汽機車廠牌';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `op_factory`
--

LOCK TABLES `op_factory` WRITE;
/*!40000 ALTER TABLE `op_factory` DISABLE KEYS */;
INSERT INTO `op_factory` VALUES ('F01','KYMCO光陽',''),('F02','YAMAHA山葉',''),('F03','SUZUKI台鈴',''),('F04','PGO比雅久',''),('F05','SYM三陽',''),('F06','VESPA偉士牌',''),('F07','Toyota豐田',''),('F08','Ford福特',''),('F09','BMW汎德',''),('F10','Honda本田',''),('F11','Hyundai現代',''),('F12','Infiniti英菲尼迪',''),('F13','Lexus凌志',''),('F14','Luxgen納智捷',''),('F15','Mazda馬自達',''),('F16','Mercedes-Benz賓士',''),('F17','Mitsubishi三菱',''),('F18','Nissan日產',''),('F19','Peugeot寶獅',''),('F20','Subaru速霸陸',''),('F21','Suzuki鈴木',''),('F22','Volkswagen福斯',''),('F23','Volvo富豪',''),('f24','nsst 新保','');
/*!40000 ALTER TABLE `op_factory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `op_house`
--

DROP TABLE IF EXISTS `op_house`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `op_house` (
  `hid` varchar(10) NOT NULL COMMENT '編號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  `note` varchar(100) NOT NULL COMMENT '摘要',
  PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='房屋資料基本使用現況';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `op_house`
--

LOCK TABLES `op_house` WRITE;
/*!40000 ALTER TABLE `op_house` DISABLE KEYS */;
INSERT INTO `op_house` VALUES ('H01','住家','系統內定'),('H02','公司','系統內定'),('H03','倉庫','系統內定'),('h04','收納間',''),('H05','經銷商','');
/*!40000 ALTER TABLE `op_house` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `op_moto`
--

DROP TABLE IF EXISTS `op_moto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `op_moto` (
  `mid` varchar(10) NOT NULL COMMENT '編號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  `note` varchar(100) NOT NULL COMMENT '摘要',
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='汽機車車型';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `op_moto`
--

LOCK TABLES `op_moto` WRITE;
/*!40000 ALTER TABLE `op_moto` DISABLE KEYS */;
INSERT INTO `op_moto` VALUES ('M01','輕型機車',''),('M02','重型機車',''),('M03','重型125上',''),('M04','房車',''),('M05','轎旅車',''),('M06','休旅車',''),('M07','小貨車',''),('m08','卡車',''),('m09','貨車',''),('m10','跑車',''),('M11','重型250以上','還是一樣大寫'),('m12','戰車',''),('m13','卡丁車',''),('M14','飛車','');
/*!40000 ALTER TABLE `op_moto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `op_parking`
--

DROP TABLE IF EXISTS `op_parking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `op_parking` (
  `pid` varchar(10) NOT NULL COMMENT '編號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  `note` varchar(100) NOT NULL COMMENT '摘要',
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='車位產權性質';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `op_parking`
--

LOCK TABLES `op_parking` WRITE;
/*!40000 ALTER TABLE `op_parking` DISABLE KEYS */;
INSERT INTO `op_parking` VALUES ('P01','自用','系統內定'),('P02','出租','系統內定'),('P03','管委會','系統內定'),('p04','公司','');
/*!40000 ALTER TABLE `op_parking` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `op_property`
--

DROP TABLE IF EXISTS `op_property`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `op_property` (
  `pid` varchar(10) NOT NULL COMMENT '編號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  `note` varchar(100) NOT NULL COMMENT '摘要',
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='住戶產權房屋狀態';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `op_property`
--

LOCK TABLES `op_property` WRITE;
/*!40000 ALTER TABLE `op_property` DISABLE KEYS */;
INSERT INTO `op_property` VALUES ('P01','自用','系統內定'),('P02','出租','系統內定'),('p03','待售',''),('p04','待賣',''),('P05','待估',''),('P06','待轉','');
/*!40000 ALTER TABLE `op_property` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `op_tv`
--

DROP TABLE IF EXISTS `op_tv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `op_tv` (
  `tvid` varchar(10) NOT NULL COMMENT '編號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  `note` varchar(100) NOT NULL COMMENT '摘要',
  PRIMARY KEY (`tvid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='有線電視設定';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `op_tv`
--

LOCK TABLES `op_tv` WRITE;
/*!40000 ALTER TABLE `op_tv` DISABLE KEYS */;
INSERT INTO `op_tv` VALUES ('TV01','永佳樂有線電視',''),('TV02','大豐有線電視',''),('TV03','聯禾有線電視',''),('TV04','慶聯有線電視',''),('TV05','大新店有線電視',''),('TV06','XXX有線電視','試看看大寫'),('TV07','新保有限電視',''),('TV08','中保有線電視','');
/*!40000 ALTER TABLE `op_tv` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `op_tvfee`
--

DROP TABLE IF EXISTS `op_tvfee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `op_tvfee` (
  `fid` tinyint unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `title` varchar(60) NOT NULL COMMENT '名稱',
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COMMENT='電視收費方式';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `op_tvfee`
--

LOCK TABLES `op_tvfee` WRITE;
/*!40000 ALTER TABLE `op_tvfee` DISABLE KEYS */;
INSERT INTO `op_tvfee` VALUES (1,'月繳'),(2,'季繳'),(3,'半年繳'),(4,'年繳');
/*!40000 ALTER TABLE `op_tvfee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `receipt_month`
--

DROP TABLE IF EXISTS `receipt_month`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `receipt_month` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year` smallint NOT NULL,
  `month` tinyint NOT NULL,
  `receipt` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `receipt_month`
--

LOCK TABLES `receipt_month` WRITE;
/*!40000 ALTER TABLE `receipt_month` DISABLE KEYS */;
INSERT INTO `receipt_month` VALUES (1,2020,9,1090900001);
/*!40000 ALTER TABLE `receipt_month` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `staff` (
  `acc` varchar(15) NOT NULL COMMENT '帳號',
  `psd` varchar(60) NOT NULL COMMENT '密碼',
  `username` varchar(30) NOT NULL COMMENT '姓名',
  `tel` varchar(20) NOT NULL DEFAULT '' COMMENT '電話',
  `cell` varchar(11) NOT NULL COMMENT '手機',
  `email` varchar(35) NOT NULL DEFAULT '' COMMENT '信箱',
  `cdate` varchar(19) NOT NULL COMMENT '建立日期',
  `mdate` varchar(19) NOT NULL COMMENT '修改日期',
  `times` varchar(19) NOT NULL COMMENT '登入時間',
  `staff` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '員工管理',
  `config` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '設定作業',
  `routine` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '例行作業',
  `tv` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '有線電視',
  `car` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '汽車位',
  `moto` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '機車車位',
  `factory` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '協力廠商',
  `committee` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '委員資料',
  `householder` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '住戶產權',
  `subject` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '物業科目',
  `building` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '棟別資料',
  `community` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '社區資料',
  `house` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '房屋資料',
  `meeting` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '會議管理',
  `news` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '公告公文',
  `print` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '報表查印',
  `fsubject` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '會計科目',
  `voucherwork` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '傳票作業',
  `findticket` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '傳票查詢',
  `receivable` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '應收收入',
  `arrears` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '費用欠繳',
  `detail` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '分類明細帳',
  `allcat` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '總分類帳',
  `daily` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '日記帳',
  `payment` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '住戶繳費',
  `special` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '特別分類帳',
  `prepayment` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '預繳明細',
  `backup` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '資料備份',
  `batch` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '批次變更',
  `card_1` varchar(100) DEFAULT NULL,
  `card_2` varchar(100) DEFAULT NULL,
  `card_3` varchar(100) DEFAULT NULL,
  `card_4` varchar(100) DEFAULT NULL,
  `card_5` varchar(100) DEFAULT NULL,
  `card_6` varchar(100) DEFAULT NULL,
  `card_7` varchar(100) DEFAULT NULL,
  `card_8` varchar(100) DEFAULT NULL,
  `card_9` varchar(100) DEFAULT NULL,
  `card_10` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`acc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff`
--

LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES ('ADMIN','admin','ADMIN','12345678','12345678','1234@8888.com','2014/10/26','2016/06/29','2021/07/13 10:18:36',3,3,3,3,3,3,3,3,3,3,3,3,3,1,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,'0785144645','','','0785144645','','','','','',''),('tlt','123456','tlt','12345678','12345678','1234@8888.com','2014/10/26','2016/06/29','2020/01/16 12:53:52',3,3,3,3,3,3,3,3,3,3,3,3,3,1,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,'0785144645','','','0785144645','','','','','',''),('NSST','123456','管理者','','','','2018/07/06','','',3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,0,'','','','','','','','','','');
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff_rfids`
--

DROP TABLE IF EXISTS `staff_rfids`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `staff_rfids` (
  `id` int NOT NULL AUTO_INCREMENT,
  `acc` varchar(100) NOT NULL,
  `card_no` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='管理人員的感應卡';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_rfids`
--

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

--
-- Table structure for table `web_bankpay`
--

DROP TABLE IF EXISTS `web_bankpay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_bankpay` (
  `get_target` varchar(20) NOT NULL COMMENT '特別帳號',
  `paydate` varchar(20) NOT NULL COMMENT '繳款日',
  `bankno` varchar(6) NOT NULL COMMENT '客戶編號',
  `get_targetname` varchar(20) NOT NULL COMMENT '帳號名稱',
  `cash` varchar(8) NOT NULL COMMENT '金額',
  PRIMARY KEY (`get_target`,`paydate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='銀行匯款繳費';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_bankpay`
--

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

--
-- Table structure for table `web_building`
--

DROP TABLE IF EXISTS `web_building`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_building` (
  `bid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號,主鍵',
  `bnum` varchar(30) NOT NULL DEFAULT '' COMMENT '標的物編號',
  `title` varchar(60) NOT NULL DEFAULT '' COMMENT '標的物全名',
  `btype` varchar(30) NOT NULL DEFAULT '' COMMENT '棟別型態',
  `charge` varchar(30) NOT NULL DEFAULT '' COMMENT '收費方式',
  `bcode` varchar(30) NOT NULL DEFAULT '' COMMENT '棟別代碼',
  `bname` varchar(80) NOT NULL DEFAULT '' COMMENT '棟別名稱',
  `company` varchar(60) NOT NULL DEFAULT '' COMMENT '管理公司',
  `contact` varchar(30) NOT NULL DEFAULT '' COMMENT '管理連絡人',
  `tel` varchar(15) NOT NULL DEFAULT '' COMMENT '公司電話',
  `cell` varchar(15) NOT NULL DEFAULT '' COMMENT '連絡人手機',
  `fax` varchar(15) NOT NULL DEFAULT '' COMMENT '公司傳真',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '電子郵件',
  `adds` varchar(100) NOT NULL DEFAULT '' COMMENT '公司地址',
  PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='棟別資料管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_building`
--

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

--
-- Table structure for table `web_car`
--

DROP TABLE IF EXISTS `web_car`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_car` (
  `carid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號',
  `target_id` varchar(30) DEFAULT NULL COMMENT '標的物編號',
  `target_name` varchar(60) DEFAULT NULL COMMENT '標的物全名',
  `park_id` varchar(30) DEFAULT NULL COMMENT '車位編號',
  `park_level` varchar(3) DEFAULT NULL COMMENT '所屬樓層',
  `park_status` varchar(30) DEFAULT NULL COMMENT '使用狀況',
  `park_nature` varchar(10) NOT NULL COMMENT '產權性質',
  `park_owner` varchar(30) DEFAULT NULL COMMENT '所有權人',
  `park_type` varchar(255) DEFAULT NULL COMMENT '車位類型',
  `park_bnum0` varchar(10) NOT NULL DEFAULT '' COMMENT '歸屬棟別',
  `park_bnum` varchar(30) NOT NULL DEFAULT '' COMMENT '歸屬戶號',
  `rent` tinyint(1) NOT NULL DEFAULT '0' COMMENT '對外出租',
  `square` varchar(5) DEFAULT NULL COMMENT '車位坪數',
  `price` varchar(8) DEFAULT NULL COMMENT '車位租金訂價',
  `park_m2` varchar(5) DEFAULT NULL COMMENT '車位m2',
  `park_sdate` varchar(10) DEFAULT NULL COMMENT '購買日期',
  `park_edate` varchar(10) DEFAULT NULL COMMENT '出售日期',
  `park_num` varchar(2) NOT NULL DEFAULT '' COMMENT '車位數',
  `cleanfee` varchar(10) NOT NULL DEFAULT '0' COMMENT '清潔費',
  `b_num0` varchar(10) NOT NULL DEFAULT '' COMMENT '承租棟別',
  `b_num` varchar(30) NOT NULL DEFAULT '' COMMENT '承租戶號',
  `loan_num` varchar(255) DEFAULT NULL COMMENT '承租人編號',
  `loan_name` varchar(30) DEFAULT NULL COMMENT '承租人名稱',
  `loan_add` varchar(100) DEFAULT NULL COMMENT '承租人地址',
  `loan_tel` varchar(20) DEFAULT NULL COMMENT '承租人電話',
  `loan_money` varchar(8) DEFAULT NULL COMMENT '支付之保証金',
  `pay_sdate` varchar(10) NOT NULL DEFAULT '' COMMENT '租貸起日',
  `pay_edate` varchar(10) NOT NULL DEFAULT '' COMMENT '租貸止日',
  `subject` varchar(30) NOT NULL DEFAULT '' COMMENT '收費對象',
  `car_num` varchar(12) DEFAULT NULL COMMENT '車牌號碼',
  `car_type` varchar(10) NOT NULL DEFAULT '' COMMENT '汽車車型',
  `color` varchar(30) DEFAULT NULL COMMENT '汽車顏色',
  `factory` varchar(10) NOT NULL DEFAULT '' COMMENT '汽車廠牌',
  `owner` varchar(30) NOT NULL DEFAULT '' COMMENT '汽車車主',
  `other` varchar(200) NOT NULL DEFAULT '' COMMENT '其他訊息',
  `chk_old` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '歷史',
  PRIMARY KEY (`carid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='汽車車位管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_car`
--

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

--
-- Table structure for table `web_committee`
--

DROP TABLE IF EXISTS `web_committee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_committee` (
  `comid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號',
  `bnum` varchar(80) NOT NULL DEFAULT '' COMMENT '委員標的物',
  `title` varchar(80) NOT NULL DEFAULT '' COMMENT '標的物全名',
  `loan_year` varchar(10) NOT NULL DEFAULT '' COMMENT '擔任年度',
  `loan_sect` varchar(20) NOT NULL DEFAULT '0' COMMENT '擔任屆別',
  `loan_degree` varchar(10) NOT NULL DEFAULT '' COMMENT '委員職稱',
  `sdate` varchar(10) NOT NULL DEFAULT '' COMMENT '職務任期起',
  `edate` varchar(10) NOT NULL DEFAULT '' COMMENT '職務任期止',
  `building` varchar(30) NOT NULL DEFAULT '' COMMENT '委員棟別',
  `com_num` varchar(20) NOT NULL DEFAULT '' COMMENT '委員編號',
  `com_name` varchar(20) NOT NULL DEFAULT '' COMMENT '委員姓名',
  `b_num` varchar(30) NOT NULL DEFAULT '' COMMENT '委員戶號',
  `birthday` varchar(10) NOT NULL DEFAULT '' COMMENT '生日',
  `idcard` varchar(10) NOT NULL DEFAULT '' COMMENT '身份證號',
  `degree` varchar(30) NOT NULL DEFAULT '' COMMENT '公司職稱',
  `sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性別',
  `address` varchar(100) NOT NULL DEFAULT '' COMMENT '聯絡地址',
  `tel` varchar(20) NOT NULL DEFAULT '' COMMENT '家用電話',
  `fax` varchar(20) NOT NULL DEFAULT '' COMMENT '家用傳真',
  `cell` varchar(20) NOT NULL COMMENT '手機',
  `com_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '公司電話',
  `com_fax` varchar(20) NOT NULL DEFAULT '' COMMENT '公司傳真',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '電子郵件',
  `contact_name` varchar(20) NOT NULL DEFAULT '' COMMENT '聯絡姓名',
  `contact_kind` varchar(20) NOT NULL DEFAULT '' COMMENT '聯絡關係',
  `contact_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '聯絡電話',
  `contact_adds` varchar(100) NOT NULL DEFAULT '' COMMENT '聯絡住址',
  `other` varchar(120) NOT NULL DEFAULT '' COMMENT '其他訊息',
  `chk_old` tinyint(1) NOT NULL DEFAULT '0' COMMENT '歷史',
  PRIMARY KEY (`comid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='委員資料管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_committee`
--

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

--
-- Table structure for table `web_community`
--

DROP TABLE IF EXISTS `web_community`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_community` (
  `comid` varchar(6) NOT NULL DEFAULT '' COMMENT '主鍵',
  `com_name` varchar(100) NOT NULL DEFAULT '' COMMENT '社區名稱',
  `committee` varchar(100) NOT NULL DEFAULT '' COMMENT '管委會名稱',
  `top_floor` varchar(10) NOT NULL DEFAULT '' COMMENT '社區最高樓層',
  `doorplate` varchar(30) NOT NULL DEFAULT '' COMMENT '門牌號碼格式',
  `adds_mark` varchar(100) NOT NULL DEFAULT '' COMMENT '門牌地址標示',
  `tv` varchar(100) NOT NULL DEFAULT '' COMMENT '有線電視台',
  `area` varchar(20) NOT NULL DEFAULT '' COMMENT '建築面積',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '社區電子信箱',
  `tel` varchar(20) NOT NULL DEFAULT '' COMMENT '社區電話',
  `fax` varchar(20) NOT NULL DEFAULT '' COMMENT '社區傳真',
  `company` varchar(30) NOT NULL DEFAULT '' COMMENT '管理公司',
  `website` varchar(50) NOT NULL DEFAULT '' COMMENT '社區網站',
  `proportion` varchar(20) NOT NULL DEFAULT '' COMMENT '社區公設比',
  `low_floor` varchar(10) NOT NULL DEFAULT '' COMMENT '社區最低樓層',
  `build_floor` varchar(20) NOT NULL DEFAULT '' COMMENT '總建坪',
  `build_ground` varchar(20) NOT NULL DEFAULT '' COMMENT '總地坪',
  `master` varchar(10) NOT NULL DEFAULT '' COMMENT '主委姓名',
  `floor_m2` varchar(20) NOT NULL DEFAULT '' COMMENT '總建m2',
  `ground_m2` varchar(20) NOT NULL DEFAULT '' COMMENT '總地m2',
  `ground_num` varchar(20) NOT NULL DEFAULT '' COMMENT '地號',
  `tot_house` varchar(10) NOT NULL DEFAULT '' COMMENT '總戶數',
  `tower` varchar(10) NOT NULL DEFAULT '' COMMENT '水塔數',
  `park_car` varchar(10) NOT NULL DEFAULT '' COMMENT '平面車位',
  `elevator` varchar(10) NOT NULL DEFAULT '' COMMENT '電梯數',
  `park_moto` varchar(10) NOT NULL DEFAULT '' COMMENT '機車車位',
  `park_machine` varchar(10) NOT NULL DEFAULT '' COMMENT '機械車位',
  `address` varchar(60) NOT NULL DEFAULT '' COMMENT '地址',
  `more_house` varchar(20) NOT NULL DEFAULT '' COMMENT '建商未售餘屋',
  `payment` varchar(20) NOT NULL DEFAULT '' COMMENT '委託代理繳款',
  `more_park` varchar(10) NOT NULL DEFAULT '' COMMENT '建商未售車位',
  `getfee` varchar(100) NOT NULL DEFAULT '' COMMENT '過戶期間收費處理',
  `carnum1` varchar(10) NOT NULL DEFAULT '' COMMENT '汽車位數量',
  `carnum2` varchar(10) NOT NULL DEFAULT '' COMMENT '社區共有車位',
  `car_pay` varchar(10) NOT NULL DEFAULT '' COMMENT '汽車位付費',
  `people` varchar(50) NOT NULL DEFAULT '' COMMENT '獨立的車位相關人',
  `moto_pay` varchar(10) NOT NULL DEFAULT '' COMMENT '機車位付費',
  `update_car` varchar(50) NOT NULL DEFAULT '' COMMENT '依產權更新汽車位',
  `vote_car` varchar(50) NOT NULL DEFAULT '' COMMENT '汽車位定期抽籤分配',
  `update_moto` varchar(50) NOT NULL DEFAULT '' COMMENT '依產權更新機車位',
  `vote_moto` varchar(50) NOT NULL DEFAULT '' COMMENT '機車位定期抽籤分配',
  `bank_num` varchar(20) NOT NULL DEFAULT '' COMMENT '行庫代號',
  `bank_name` varchar(50) NOT NULL DEFAULT '' COMMENT '管理費收繳銀行名稱',
  `bank_user` varchar(50) NOT NULL DEFAULT '' COMMENT '管理費收繳戶名',
  `bank_account` varchar(30) NOT NULL DEFAULT '' COMMENT '管理費收繳帳號',
  PRIMARY KEY (`comid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='社區資料管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_community`
--

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

--
-- Table structure for table `web_factory`
--

DROP TABLE IF EXISTS `web_factory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_factory` (
  `factoryid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號',
  `sname` varchar(255) NOT NULL DEFAULT '' COMMENT '廠商簡稱',
  `fnum` varchar(255) NOT NULL DEFAULT '' COMMENT '廠商編號',
  `fno` varchar(255) NOT NULL DEFAULT '' COMMENT '統一編號',
  `fullname` varchar(255) NOT NULL DEFAULT '' COMMENT '廠商全名',
  `org` varchar(255) NOT NULL DEFAULT '' COMMENT '公司組織',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT '聯絡地址',
  `boss` varchar(255) NOT NULL DEFAULT '' COMMENT '負責人',
  `ticket_adds` varchar(255) NOT NULL DEFAULT '' COMMENT '發票地址',
  `idcard` varchar(255) NOT NULL DEFAULT '' COMMENT '身份証字號',
  `com_tel` varchar(255) NOT NULL DEFAULT '' COMMENT '公司電話',
  `com_contact` varchar(255) NOT NULL DEFAULT '' COMMENT '聯絡人',
  `com_type` varchar(255) NOT NULL DEFAULT '' COMMENT '行業別',
  `com_fax` varchar(255) NOT NULL DEFAULT '' COMMENT '公司傳真',
  `com_subtel` varchar(255) NOT NULL DEFAULT '' COMMENT '聯絡人分機',
  `boss_cell` varchar(255) NOT NULL DEFAULT '' COMMENT '負責人手機',
  `finance_cell` varchar(255) NOT NULL DEFAULT '' COMMENT '會計分機',
  `contact_cell` varchar(255) NOT NULL DEFAULT '' COMMENT '聯絡人手機',
  `com_email` varchar(255) NOT NULL DEFAULT '' COMMENT '公司Mail',
  `deadline` varchar(10) NOT NULL DEFAULT '' COMMENT '帳單截止日',
  `paydate` varchar(10) NOT NULL DEFAULT '' COMMENT '付款日',
  `bank_no` varchar(255) NOT NULL DEFAULT '' COMMENT '銀行代碼',
  `bank_name` varchar(255) NOT NULL DEFAULT '' COMMENT '開戶銀行',
  `bank_user` varchar(255) NOT NULL DEFAULT '' COMMENT '開戶名稱',
  `bank_account` varchar(255) NOT NULL DEFAULT '' COMMENT '開戶帳號',
  `bank_account1` varchar(255) NOT NULL DEFAULT '' COMMENT '銀行給帳號',
  `attn` varchar(255) NOT NULL DEFAULT '' COMMENT '業務經辦人',
  `attn_cell` varchar(255) NOT NULL DEFAULT '' COMMENT '行動電話',
  `attn_tel` varchar(255) NOT NULL DEFAULT '' COMMENT '住家電話',
  `open_date` int NOT NULL DEFAULT '0' COMMENT '開業日期',
  `capital` varchar(255) NOT NULL DEFAULT '' COMMENT '公司資本額',
  `com_volume` varchar(255) NOT NULL DEFAULT '' COMMENT '年營業額',
  `staff_num` varchar(255) NOT NULL DEFAULT '' COMMENT '員工人數',
  `country` varchar(255) NOT NULL DEFAULT '' COMMENT '國家',
  `stockholder` varchar(255) NOT NULL DEFAULT '' COMMENT '股東人數',
  `other` varchar(120) NOT NULL DEFAULT '' COMMENT '其他訊息',
  PRIMARY KEY (`factoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='廠商資料管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_factory`
--

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

--
-- Table structure for table `web_house`
--

DROP TABLE IF EXISTS `web_house`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_house` (
  `houseid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號',
  `bnum` varchar(255) NOT NULL DEFAULT '' COMMENT '標的物編號',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '標的物全名',
  `btype` varchar(255) NOT NULL DEFAULT '' COMMENT '棟別型態',
  `op_house` varchar(10) NOT NULL DEFAULT '0' COMMENT '使用狀況',
  `adds_mark` varchar(255) NOT NULL DEFAULT '' COMMENT '門牌',
  `bname` varchar(255) NOT NULL DEFAULT '' COMMENT '棟別名稱',
  `house_num` varchar(255) NOT NULL DEFAULT '' COMMENT '戶號',
  `b_num0` varchar(10) NOT NULL COMMENT '棟',
  `b_num1` varchar(10) NOT NULL COMMENT '號',
  `b_num2` varchar(10) NOT NULL COMMENT '樓',
  `b_num3` varchar(10) NOT NULL DEFAULT '0' COMMENT '室',
  `house_name` varchar(255) NOT NULL DEFAULT '' COMMENT '戶號名稱',
  `floor_num` varchar(255) NOT NULL DEFAULT '' COMMENT '坪數',
  `adds` varchar(255) NOT NULL DEFAULT '' COMMENT '地址',
  `build_floor` varchar(255) NOT NULL DEFAULT '' COMMENT '總建坪',
  `ground_m2` varchar(255) NOT NULL DEFAULT '' COMMENT '總地M2',
  `build_ground` varchar(255) NOT NULL DEFAULT '' COMMENT '總地坪',
  `owner` varchar(255) NOT NULL DEFAULT '' COMMENT '所有權人',
  `owner_num` varchar(255) NOT NULL DEFAULT '' COMMENT '所有權人戶號',
  `object` varchar(255) NOT NULL DEFAULT '' COMMENT '收費對象',
  `renter` varchar(255) NOT NULL DEFAULT '' COMMENT '承租人',
  `proportion1` varchar(255) NOT NULL DEFAULT '' COMMENT '持分比例',
  `proportion2` varchar(255) NOT NULL DEFAULT '' COMMENT '區分比例',
  `usetype` varchar(255) NOT NULL DEFAULT '' COMMENT '使用情況',
  `owner_adds` varchar(255) NOT NULL DEFAULT '' COMMENT '所有權人地址',
  `tel` varchar(255) NOT NULL DEFAULT '' COMMENT '所有權人電話',
  `property_num` varchar(255) NOT NULL DEFAULT '' COMMENT '產權編號',
  `fee` varchar(255) NOT NULL DEFAULT '' COMMENT '核定管理費/每坪',
  `other` varchar(120) NOT NULL DEFAULT '' COMMENT '其他訊息',
  PRIMARY KEY (`houseid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='房屋資料管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_house`
--

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

--
-- Table structure for table `web_householder`
--

DROP TABLE IF EXISTS `web_householder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_householder` (
  `houseid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `b_cname0` varchar(30) NOT NULL DEFAULT '' COMMENT '住戶代碼',
  `b_cname1` varchar(30) DEFAULT NULL COMMENT '住戶簡稱',
  `b_cname2` varchar(30) DEFAULT NULL COMMENT '住戶全名',
  `b_num` varchar(30) NOT NULL COMMENT '戶號',
  `b_num0` varchar(10) DEFAULT NULL COMMENT '戶號-棟',
  `b_num1` varchar(10) DEFAULT NULL COMMENT '戶號-號',
  `b_num2` varchar(10) DEFAULT NULL COMMENT '戶號-樓',
  `b_num3` varchar(15) NOT NULL DEFAULT '0' COMMENT '戶號-室',
  `b_sex` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '性別',
  `b_tel0` varchar(15) DEFAULT NULL COMMENT '連絡電話',
  `b_tel1` varchar(15) DEFAULT NULL COMMENT '連絡手機',
  `b_add` varchar(120) DEFAULT NULL COMMENT '門牌地址',
  `b_email` varchar(100) DEFAULT NULL COMMENT '電子郵件',
  `b_size` varchar(20) DEFAULT NULL COMMENT '坪數',
  `b_percent` varchar(20) DEFAULT NULL COMMENT '持分比例',
  `b_fee` varchar(10) DEFAULT NULL COMMENT '核定管理費',
  `b_fee_chk` varchar(10) DEFAULT NULL COMMENT '核定附加費',
  `b_fee_other` varchar(10) NOT NULL COMMENT '其它費',
  `b_proxy` varchar(100) DEFAULT NULL COMMENT '仲介代理',
  `b_code` varchar(10) DEFAULT NULL COMMENT '身份証',
  `b_special` varchar(10) NOT NULL COMMENT '特別費',
  `b_sdate` varchar(11) NOT NULL DEFAULT '0' COMMENT '起付日期',
  `b_edate` varchar(11) NOT NULL DEFAULT '0' COMMENT '止付日期',
  `b_type` varchar(10) NOT NULL COMMENT '房屋狀態',
  `bankno` varchar(10) NOT NULL COMMENT '客戶編號',
  `bankacc` varchar(15) NOT NULL COMMENT '虛擬帳號',
  `c_name0` varchar(60) DEFAULT NULL COMMENT '公司名稱',
  `c_name1` varchar(30) DEFAULT NULL COMMENT '行業別',
  `c_name2` varchar(30) DEFAULT NULL COMMENT '負責人',
  `c_name3` varchar(30) DEFAULT NULL COMMENT '連絡人',
  `c_code0` varchar(10) DEFAULT NULL COMMENT '身份証',
  `c_code1` varchar(15) DEFAULT NULL COMMENT '統一編號',
  `c_tel0` varchar(15) DEFAULT NULL COMMENT '公司電話',
  `c_tel1` varchar(15) DEFAULT NULL COMMENT '連絡人分機',
  `c_fax0` varchar(15) DEFAULT NULL COMMENT '公司傳真',
  `c_add0` varchar(100) DEFAULT NULL COMMENT '連絡地址',
  `c_add1` varchar(100) DEFAULT NULL COMMENT '發票地址',
  `import_file` varchar(20) NOT NULL COMMENT '產權紙本',
  `ccontent0` text COMMENT '其他訊息',
  `d_name0` varchar(60) NOT NULL COMMENT '承租人',
  `d_code` varchar(10) NOT NULL COMMENT '身分證',
  `d_email` varchar(60) NOT NULL COMMENT '電子郵件',
  `d_tel0` varchar(15) NOT NULL COMMENT '聯絡手機',
  `d_tel1` varchar(15) NOT NULL COMMENT '聯絡電話',
  `d_sex` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '性別',
  `d_sdate` varchar(10) NOT NULL COMMENT '起付日期',
  `d_edate` varchar(10) NOT NULL COMMENT '止付日期',
  `d_fee` varchar(10) NOT NULL COMMENT '核定管理費',
  `d_fee_chk` varchar(10) NOT NULL COMMENT '核定付加費',
  `d_add` varchar(100) NOT NULL COMMENT '承租人地址',
  `chk_old` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '歷史',
  PRIMARY KEY (`houseid`),
  KEY `b_cname0` (`b_cname0`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='住戶產權管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_householder`
--

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

--
-- Table structure for table `web_houserenter`
--

DROP TABLE IF EXISTS `web_houserenter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_houserenter` (
  `rid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `houseid` int unsigned NOT NULL COMMENT '住戶序號',
  `d_name0` varchar(60) NOT NULL COMMENT '承租人',
  `d_code` varchar(10) NOT NULL COMMENT '身分證',
  `d_email` varchar(60) NOT NULL COMMENT '電子郵件',
  `d_tel0` varchar(15) NOT NULL COMMENT '連絡手機',
  `d_tel1` varchar(15) NOT NULL COMMENT '連絡電話',
  `d_sex` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '性別',
  `d_sdate` varchar(10) NOT NULL DEFAULT '0' COMMENT '起付日期',
  `d_edate` varchar(10) NOT NULL DEFAULT '0' COMMENT '止付日期',
  `d_fee` varchar(10) DEFAULT NULL COMMENT '核定管理費',
  `d_fee_chk` varchar(10) DEFAULT NULL COMMENT '核定付加費',
  `chk_old` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '歷史',
  PRIMARY KEY (`rid`),
  KEY `houseid` (`houseid`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COMMENT='承租人管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_houserenter`
--

LOCK TABLES `web_houserenter` WRITE;
/*!40000 ALTER TABLE `web_houserenter` DISABLE KEYS */;
INSERT INTO `web_houserenter` VALUES (1,1,'test8','A234573256','abcd@abcd','741852923','147258369',0,'2013/08/10','2014/08/10','3000','2000',1),(2,2,'陳小華','F128536432','123@123.com','0912-123-123','02-1234-1234',0,'2012/05/05','2013/01/30','1900','1200',1),(3,3,'凡爾賽','A120595742','123@yahoo.com.tw','0912-123-111','02-1234-1234',0,'2012/02/01','2012/12/31','1900','1200',1),(4,2,'王加寶','A123456789','1234@mail.com','02-12345678','0921-123456',1,'2013/03/01','2013/05/31','2500','2000',1),(5,2,'劉進華','','','0912-123-123','02-1234-1234',1,'2013/06/01','','','',0),(10,51,'紀曉嵐','A123456789','123@123.com','02-12345678','02-1234-1234',1,'2014/02/01','','','',0),(11,50,'王金平','A120595742','123@123.com','0912-123-111','02-1234-1234',1,'2014/03/05','','','',0);
/*!40000 ALTER TABLE `web_houserenter` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_meeting`
--

DROP TABLE IF EXISTS `web_meeting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_meeting` (
  `mid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `mdate` varchar(14) NOT NULL DEFAULT '' COMMENT '時間',
  `president` varchar(50) NOT NULL DEFAULT '' COMMENT '主席',
  `location` varchar(50) NOT NULL DEFAULT '' COMMENT '地點',
  `others` varchar(100) NOT NULL DEFAULT '' COMMENT '列席',
  `recoder` varchar(50) NOT NULL DEFAULT '' COMMENT '記錄',
  `attend` varchar(100) NOT NULL DEFAULT '' COMMENT '出席',
  `content` text NOT NULL COMMENT '內容',
  `files` varchar(18) NOT NULL COMMENT '檔案',
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='會議管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_meeting`
--

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

--
-- Table structure for table `web_moto`
--

DROP TABLE IF EXISTS `web_moto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_moto` (
  `motoid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號',
  `target_id` varchar(30) DEFAULT NULL COMMENT '標的物編號',
  `target_name` varchar(60) DEFAULT NULL COMMENT '標的物全名',
  `park_id` varchar(30) DEFAULT NULL COMMENT '車位編號',
  `park_level` varchar(3) DEFAULT NULL COMMENT '所屬樓層',
  `park_status` varchar(30) DEFAULT NULL COMMENT '使用狀況',
  `park_nature` varchar(10) NOT NULL COMMENT '產權性質',
  `park_owner` varchar(30) DEFAULT NULL COMMENT '所有權人',
  `park_type` varchar(255) DEFAULT NULL COMMENT '車位類型',
  `park_bnum0` varchar(10) NOT NULL DEFAULT '' COMMENT '歸屬棟別',
  `park_bnum` varchar(30) NOT NULL DEFAULT '' COMMENT '歸屬戶號',
  `rent` tinyint(1) NOT NULL DEFAULT '0' COMMENT '對外出租',
  `square` varchar(5) DEFAULT NULL COMMENT '車位坪數',
  `price` varchar(8) DEFAULT NULL COMMENT '車位租金訂價',
  `park_m2` varchar(5) DEFAULT NULL COMMENT '車位m2',
  `park_sdate` varchar(10) DEFAULT NULL COMMENT '購買日期',
  `park_edate` varchar(10) DEFAULT NULL COMMENT '出售日期',
  `park_num` varchar(2) NOT NULL DEFAULT '' COMMENT '車位數',
  `cleanfee` varchar(10) NOT NULL DEFAULT '0' COMMENT '清潔費',
  `b_num0` varchar(10) NOT NULL DEFAULT '' COMMENT '承租棟別',
  `b_num` varchar(30) NOT NULL DEFAULT '' COMMENT '承租戶號',
  `loan_num` varchar(255) DEFAULT NULL COMMENT '承租人編號',
  `loan_name` varchar(30) DEFAULT NULL COMMENT '承租人名稱',
  `loan_add` varchar(100) DEFAULT NULL COMMENT '承租人地址',
  `loan_tel` varchar(20) DEFAULT NULL COMMENT '承租人電話',
  `loan_money` varchar(8) DEFAULT NULL COMMENT '支付之保証金',
  `pay_sdate` varchar(10) NOT NULL DEFAULT '' COMMENT '租貸起日',
  `pay_edate` varchar(10) NOT NULL DEFAULT '' COMMENT '租貸止日',
  `subject` varchar(30) NOT NULL DEFAULT '' COMMENT '收費對象',
  `car_num` varchar(12) DEFAULT NULL COMMENT '車牌號碼',
  `car_type` varchar(10) NOT NULL DEFAULT '' COMMENT '機車車型',
  `color` varchar(30) DEFAULT NULL COMMENT '機車顏色',
  `factory` varchar(10) NOT NULL DEFAULT '' COMMENT '機車廠牌',
  `owner` varchar(30) NOT NULL DEFAULT '' COMMENT '機車車主',
  `other` varchar(200) NOT NULL DEFAULT '' COMMENT '其他訊息',
  `chk_old` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '歷史',
  PRIMARY KEY (`motoid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='機車車位管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_moto`
--

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

--
-- Table structure for table `web_news`
--

DROP TABLE IF EXISTS `web_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_news` (
  `nid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `mdate` varchar(14) NOT NULL DEFAULT '' COMMENT '日期',
  `getman` varchar(50) NOT NULL COMMENT '受文者',
  `newsno` varchar(30) NOT NULL COMMENT '文號',
  `speed` varchar(30) NOT NULL COMMENT '速別',
  `contact` varchar(50) NOT NULL COMMENT '連絡人',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '主旨',
  `content` text NOT NULL COMMENT '內容',
  `files` varchar(18) NOT NULL COMMENT '檔案',
  PRIMARY KEY (`nid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='公告公文';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_news`
--

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

--
-- Table structure for table `web_paylist`
--

DROP TABLE IF EXISTS `web_paylist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_paylist` (
  `pid` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `account` varchar(30) NOT NULL COMMENT '住戶編號',
  `ymonth` varchar(7) NOT NULL DEFAULT '' COMMENT '年月',
  `adds` varchar(100) NOT NULL COMMENT '門牌地址',
  `target_name` varchar(100) NOT NULL DEFAULT '' COMMENT '門牌地址',
  `park_owner` varchar(30) NOT NULL DEFAULT '' COMMENT '所有權人',
  `loan_name` varchar(30) NOT NULL DEFAULT '' COMMENT '承租人名稱',
  `bfee` varchar(10) NOT NULL COMMENT '管理費',
  `carprice` varchar(8) NOT NULL DEFAULT '' COMMENT '汽租金',
  `cleanfee1` varchar(10) NOT NULL DEFAULT '0' COMMENT '汽清潔費',
  `motoprice` varchar(8) NOT NULL DEFAULT '' COMMENT '機租金',
  `cleanfee2` varchar(10) NOT NULL DEFAULT '0' COMMENT '機清潔費',
  `other` varchar(10) NOT NULL DEFAULT '' COMMENT '其它費',
  `tvfee` varchar(10) NOT NULL DEFAULT '' COMMENT '收視費',
  `tvtitle` varchar(10) NOT NULL COMMENT '繳費方式',
  `special` varchar(30) DEFAULT '' COMMENT '特別費',
  `pay` varchar(10) NOT NULL DEFAULT '' COMMENT '應收金額',
  `paid` varchar(10) NOT NULL DEFAULT '' COMMENT '已繳金額',
  `ticketdate` varchar(10) NOT NULL DEFAULT '' COMMENT '傳票日期',
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=295 DEFAULT CHARSET=utf8mb3 COMMENT='暫存應收費用列表清單';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_paylist`
--

LOCK TABLES `web_paylist` WRITE;
/*!40000 ALTER TABLE `web_paylist` DISABLE KEYS */;
INSERT INTO `web_paylist` VALUES (1,'A-288-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(2,'A-288-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(3,'A-288-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(4,'A-288-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(5,'A-288-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(6,'A-288-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(7,'A-288-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(8,'A-288-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(9,'A-288-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(10,'A-288之1-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(11,'A-288之1-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(12,'A-288之1-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(13,'A-288之1-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(14,'A-288之1-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(15,'A-288之1-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(16,'A-288之1-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(17,'A-288之1-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(18,'A-288之1-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(19,'A-288之10-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(20,'A-288之10-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(21,'A-288之10-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(22,'A-288之10-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(23,'A-288之10-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(24,'A-288之10-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(25,'A-288之10-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(26,'A-288之10-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(27,'A-288之10-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(28,'A-288之11-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(29,'A-288之11-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(30,'A-288之11-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(31,'A-288之11-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(32,'A-288之11-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(33,'A-288之11-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(34,'A-288之11-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(35,'A-288之11-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(36,'A-288之11-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(37,'A-288之12-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(38,'A-288之12-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(39,'A-288之12-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(40,'A-288之12-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(41,'A-288之12-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(42,'A-288之12-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(43,'A-288之12-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(44,'A-288之12-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(45,'A-288之12-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(46,'A-288之13-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(47,'A-288之13-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(48,'A-288之13-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(49,'A-288之13-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(50,'A-288之13-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(51,'A-288之13-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(52,'A-288之13-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(53,'A-288之13-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(54,'A-288之13-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(55,'A-288之15-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(56,'A-288之15-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(57,'A-288之15-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(58,'A-288之15-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(59,'A-288之15-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(60,'A-288之15-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(61,'A-288之15-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(62,'A-288之15-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(63,'A-288之16-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(64,'A-288之16-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(65,'A-288之16-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(66,'A-288之16-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(67,'A-288之16-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(68,'A-288之16-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(69,'A-288之16-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(70,'A-288之16-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(71,'A-288之16-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(72,'A-288之17-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(73,'A-288之17-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(74,'A-288之17-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(75,'A-288之17-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(76,'A-288之17-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(77,'A-288之17-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(78,'A-288之17-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(79,'A-288之17-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(80,'A-288之17-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(81,'A-288之2-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(82,'A-288之2-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(83,'A-288之2-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(84,'A-288之2-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(85,'A-288之2-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(86,'A-288之2-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(87,'A-288之2-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(88,'A-288之2-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(89,'A-288之2-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(90,'A-288之3-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(91,'A-288之3-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(92,'A-288之3-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(93,'A-288之3-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(94,'A-288之3-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(95,'A-288之3-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(96,'A-288之3-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(97,'A-288之3-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(98,'A-288之3-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(99,'A-288之5-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(100,'A-288之5-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(101,'A-288之5-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(102,'A-288之5-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(103,'A-288之5-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(104,'A-288之5-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(105,'A-288之5-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(106,'A-288之5-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(107,'A-288之6-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(108,'A-288之6-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(109,'A-288之6-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(110,'A-288之6-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(111,'A-288之6-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(112,'A-288之6-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(113,'A-288之6-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(114,'A-288之6-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(115,'A-288之7-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(116,'A-288之7-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(117,'A-288之7-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(118,'A-288之7-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(119,'A-288之7-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(120,'A-288之7-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(121,'A-288之7-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(122,'A-288之7-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(123,'A-288之8-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(124,'A-288之8-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(125,'A-288之8-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(126,'A-288之8-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(127,'A-288之8-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(128,'A-288之8-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(129,'A-288之8-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(130,'A-288之8-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(131,'A-288之9-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(132,'A-288之9-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(133,'A-288之9-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(134,'A-288之9-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(135,'A-288之9-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(136,'A-288之9-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(137,'A-288之9-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(138,'A-288之9-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(139,'B-286-1-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(140,'B-286-2-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(141,'B-286-3-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(142,'B-286-4-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(143,'B-286-5-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(144,'B-286-6-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(145,'B-286-7-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(146,'B-286-8-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(147,'B-286-9-0','2020/04','','','','','','','','','','','','','','0','','2020/04/05'),(148,'A-288-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(149,'A-288-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(150,'A-288-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(151,'A-288-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(152,'A-288-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(153,'A-288-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(154,'A-288-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(155,'A-288-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(156,'A-288-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(157,'A-288之1-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(158,'A-288之1-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(159,'A-288之1-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(160,'A-288之1-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(161,'A-288之1-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(162,'A-288之1-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(163,'A-288之1-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(164,'A-288之1-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(165,'A-288之1-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(166,'A-288之10-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(167,'A-288之10-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(168,'A-288之10-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(169,'A-288之10-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(170,'A-288之10-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(171,'A-288之10-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(172,'A-288之10-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(173,'A-288之10-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(174,'A-288之10-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(175,'A-288之11-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(176,'A-288之11-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(177,'A-288之11-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(178,'A-288之11-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(179,'A-288之11-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(180,'A-288之11-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(181,'A-288之11-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(182,'A-288之11-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(183,'A-288之11-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(184,'A-288之12-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(185,'A-288之12-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(186,'A-288之12-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(187,'A-288之12-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(188,'A-288之12-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(189,'A-288之12-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(190,'A-288之12-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(191,'A-288之12-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(192,'A-288之12-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(193,'A-288之13-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(194,'A-288之13-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(195,'A-288之13-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(196,'A-288之13-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(197,'A-288之13-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(198,'A-288之13-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(199,'A-288之13-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(200,'A-288之13-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(201,'A-288之13-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(202,'A-288之15-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(203,'A-288之15-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(204,'A-288之15-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(205,'A-288之15-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(206,'A-288之15-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(207,'A-288之15-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(208,'A-288之15-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(209,'A-288之15-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(210,'A-288之16-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(211,'A-288之16-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(212,'A-288之16-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(213,'A-288之16-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(214,'A-288之16-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(215,'A-288之16-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(216,'A-288之16-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(217,'A-288之16-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(218,'A-288之16-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(219,'A-288之17-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(220,'A-288之17-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(221,'A-288之17-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(222,'A-288之17-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(223,'A-288之17-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(224,'A-288之17-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(225,'A-288之17-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(226,'A-288之17-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(227,'A-288之17-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(228,'A-288之2-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(229,'A-288之2-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(230,'A-288之2-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(231,'A-288之2-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(232,'A-288之2-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(233,'A-288之2-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(234,'A-288之2-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(235,'A-288之2-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(236,'A-288之2-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(237,'A-288之3-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(238,'A-288之3-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(239,'A-288之3-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(240,'A-288之3-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(241,'A-288之3-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(242,'A-288之3-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(243,'A-288之3-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(244,'A-288之3-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(245,'A-288之3-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(246,'A-288之5-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(247,'A-288之5-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(248,'A-288之5-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(249,'A-288之5-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(250,'A-288之5-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(251,'A-288之5-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(252,'A-288之5-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(253,'A-288之5-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(254,'A-288之6-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(255,'A-288之6-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(256,'A-288之6-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(257,'A-288之6-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(258,'A-288之6-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(259,'A-288之6-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(260,'A-288之6-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(261,'A-288之6-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(262,'A-288之7-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(263,'A-288之7-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(264,'A-288之7-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(265,'A-288之7-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(266,'A-288之7-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(267,'A-288之7-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(268,'A-288之7-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(269,'A-288之7-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(270,'A-288之8-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(271,'A-288之8-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(272,'A-288之8-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(273,'A-288之8-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(274,'A-288之8-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(275,'A-288之8-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(276,'A-288之8-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(277,'A-288之8-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(278,'A-288之9-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(279,'A-288之9-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(280,'A-288之9-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(281,'A-288之9-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(282,'A-288之9-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(283,'A-288之9-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(284,'A-288之9-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(285,'A-288之9-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(286,'B-286-1-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(287,'B-286-2-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(288,'B-286-3-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(289,'B-286-4-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(290,'B-286-5-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(291,'B-286-6-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(292,'B-286-7-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(293,'B-286-8-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05'),(294,'B-286-9-0','2020/09','','','','','','','','','','','','','','0','','2020/09/05');
/*!40000 ALTER TABLE `web_paylist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_prepay`
--

DROP TABLE IF EXISTS `web_prepay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_prepay` (
  `get_target` varchar(20) NOT NULL COMMENT '特別帳號',
  `get_targetname` varchar(20) NOT NULL COMMENT '帳號名稱',
  `cash` varchar(8) NOT NULL COMMENT '預收餘額',
  PRIMARY KEY (`get_target`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='預收款餘額';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_prepay`
--

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

--
-- Table structure for table `web_summons`
--

DROP TABLE IF EXISTS `web_summons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_summons` (
  `sid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '序號',
  `ticketid` varchar(14) NOT NULL COMMENT '傳票號碼',
  `masterid` varchar(14) NOT NULL COMMENT '沖銷關聯',
  `upid` varchar(14) NOT NULL COMMENT '來源傳票',
  `part` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0主票1沖票',
  `sort` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0借1貸',
  `workend` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '已沖銷',
  `paydates` date NOT NULL COMMENT '收支日期',
  `balance` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '收支選項',
  `cash_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '款項選擇',
  `cashtype` varchar(20) NOT NULL DEFAULT '0' COMMENT '款項代碼',
  `cash_typename` varchar(20) NOT NULL COMMENT '款項名稱',
  `earn` varchar(8) NOT NULL COMMENT '收支金額',
  `pay_sdate` varchar(10) NOT NULL COMMENT '繳費起',
  `pay_edate` varchar(10) NOT NULL COMMENT '繳費止',
  `deduct` varchar(6) NOT NULL COMMENT '扣金額',
  `get_item` varchar(8) NOT NULL COMMENT '收支項目',
  `get_itemname` varchar(20) NOT NULL COMMENT '項目名稱',
  `get_target` varchar(20) NOT NULL COMMENT '收支對象',
  `get_targetname` varchar(20) NOT NULL COMMENT '對象科目',
  `note1` varchar(60) NOT NULL COMMENT '傳票摘要',
  `bmonth` varchar(10) NOT NULL COMMENT '歸屬月份',
  `note2` varchar(60) NOT NULL COMMENT '傳票備註',
  `receipt` varchar(20) NOT NULL COMMENT '收據編號',
  `receipt_month` varchar(20) NOT NULL,
  `annex` varchar(20) NOT NULL COMMENT '附件編號',
  `cashnote` varchar(60) NOT NULL COMMENT '現金摘要',
  `get_bankitem` varchar(8) NOT NULL COMMENT '會計帳號',
  `get_bankitemname` varchar(10) NOT NULL COMMENT '會計科目',
  `get_banktarget` varchar(10) NOT NULL COMMENT '特別帳號',
  `get_banktargetname` varchar(10) NOT NULL COMMENT '特別科目',
  `remitno` varchar(10) NOT NULL COMMENT '匯款單據',
  `remit_date` varchar(10) NOT NULL COMMENT '匯款時間',
  `banknote1` varchar(60) NOT NULL COMMENT '傳票摘要',
  `banknote2` varchar(60) NOT NULL COMMENT '傳票備註',
  `chequebank` varchar(60) NOT NULL COMMENT '票據銀行',
  `chequeno` varchar(30) NOT NULL COMMENT '票據號碼',
  `chequedate` varchar(10) NOT NULL COMMENT '票據日期',
  `loan` varchar(10) NOT NULL COMMENT '貸方金額',
  `borrow` varchar(10) NOT NULL COMMENT '借方金額',
  `chk_old` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '歷史',
  `del` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '作廢',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COMMENT='傳票資料';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_summons`
--

LOCK TABLES `web_summons` WRITE;
/*!40000 ALTER TABLE `web_summons` DISABLE KEYS */;
INSERT INTO `web_summons` VALUES (1,'20200904-00001','20200904-00001','',0,1,1,'2020-09-04',1,1,'6003','機電費','200','','','','6003','機電費','A-288-5-0','劉耿維','劉耿維機電費','','','','01090900001','','','','','','','','','','','','','','200','',0,0),(2,'20200904-00001','20200904-00001','',0,0,1,'2020-09-04',1,1,'1100','現金','','','','','1100','現金','A-288-5-0','','劉耿維機電費','','','','01090900001','','','','','','','','','','','','','','','200',0,0);
/*!40000 ALTER TABLE `web_summons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_tv`
--

DROP TABLE IF EXISTS `web_tv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_tv` (
  `tid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號',
  `b_num` varchar(30) DEFAULT NULL COMMENT '戶號',
  `b_add` varchar(255) DEFAULT NULL COMMENT '門牌地址',
  `b_cname2` varchar(255) DEFAULT NULL COMMENT '所有權人',
  `d_name0` varchar(255) DEFAULT NULL COMMENT '承租人',
  `tvid` varchar(10) NOT NULL COMMENT '電視台',
  `ctype` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '收費方式',
  `tvfee` varchar(5) DEFAULT NULL COMMENT '收視費用',
  `sdate` varchar(10) NOT NULL COMMENT '起付日期',
  `edate` varchar(10) NOT NULL COMMENT '止付日期',
  `note` varchar(100) NOT NULL COMMENT '備註',
  `chk_old` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '歷史',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='有線電視收視管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_tv`
--

LOCK TABLES `web_tv` WRITE;
/*!40000 ALTER TABLE `web_tv` DISABLE KEYS */;
/*!40000 ALTER TABLE `web_tv` 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-11-24 15:49:31
