-- MySQL dump 10.11 -- -- Host: localhost Database: mMLTIn82CBnDD9Xn -- ------------------------------------------------------ -- Server version 5.0.95-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 `T_body` -- DROP TABLE IF EXISTS `T_body`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `T_body` ( `recno` float unsigned NOT NULL auto_increment, `head_no` float unsigned NOT NULL, `oder_ymd` text, `seq_no` int(10) unsigned default NULL, `des_text1` text, `des_text2` text, `memo_text` text, `order_count` int(10) unsigned default NULL, `count_type` text, `order_s_pay` int(10) unsigned default NULL, `tax_pay` int(10) unsigned default NULL, `tax_par` int(10) unsigned default NULL, `create_date` text, `order_t_pay` int(11) default NULL, `flg_2` text, PRIMARY KEY (`recno`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T_body` -- LOCK TABLES `T_body` WRITE; /*!40000 ALTER TABLE `T_body` DISABLE KEYS */; INSERT INTO `T_body` VALUES (1,1,NULL,0,'商品A','',NULL,10,'個',1500,NULL,NULL,'2019-10-3',15000,NULL),(2,1,NULL,1,'サポート','時間対応',NULL,10,'H',5000,NULL,NULL,'2019-10-3',50000,NULL),(3,1,NULL,2,'サポートについては、交通費実費となります。','',NULL,NULL,NULL,NULL,NULL,NULL,'2019-10-3',0,NULL),(4,1,NULL,3,'私鉄利用で10%減','NO',NULL,NULL,NULL,NULL,NULL,NULL,'2019-10-3',0,NULL),(5,1,'8',4,'9','NO',NULL,11,'10',11,NULL,NULL,'2019-10-3',11,NULL),(6,1,NULL,5,'請求書へ移行できます','NO',NULL,NULL,NULL,NULL,NULL,NULL,'2019-10-3',0,NULL),(7,1,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-10-3',NULL,NULL),(8,1,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-10-3',NULL,NULL),(9,1,NULL,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-10-3',NULL,NULL),(10,1,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-10-3',NULL,NULL),(11,2,'9月〆',0,'9月納入商品A',NULL,NULL,5,'1',2000,NULL,NULL,NULL,10000,NULL),(12,2,NULL,1,NULL,'時間対応',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,2,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,2,NULL,3,NULL,'NO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,2,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,2,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,2,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,2,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,2,NULL,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,2,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `T_body` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `T_han` -- DROP TABLE IF EXISTS `T_han`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `T_han` ( `recno` float NOT NULL, `text` text NOT NULL, `text2` text NOT NULL, `sys_date` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T_han` -- LOCK TABLES `T_han` WRITE; /*!40000 ALTER TABLE `T_han` DISABLE KEYS */; INSERT INTO `T_han` VALUES (1,'〒XXXX 都道府県住所/ビル名/TEL 11111/FAX 22222 ','','2019-10-3'),(2,'銀行/支店/口座名義人/','','2019-10-3'); /*!40000 ALTER TABLE `T_han` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `T_head` -- DROP TABLE IF EXISTS `T_head`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `T_head` ( `recno` float NOT NULL, `cust_comp` text NOT NULL, `c_name` text NOT NULL, `total_pay` int(10) unsigned default NULL, `tax_par` int(10) unsigned default NULL, `tax_pay` int(10) unsigned default NULL, `send_date` text COMMENT '請求書作成年月日', `memo` text NOT NULL, `sys_date` text, `create_date` text, `order_no` float unsigned default NULL COMMENT '見積状態=NULL 請求済=番号', PRIMARY KEY (`recno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T_head` -- LOCK TABLES `T_head` WRITE; /*!40000 ALTER TABLE `T_head` DISABLE KEYS */; INSERT INTO `T_head` VALUES (1,'見積先','担当者殿',71500,10,6500,'2019/10/16','','2019-10-3',NULL,NULL),(2,'請求先','担当者殿',11000,10,1000,'2019/10/30','',NULL,NULL,1); /*!40000 ALTER TABLE `T_head` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `T_info` -- DROP TABLE IF EXISTS `T_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `T_info` ( `recno` float NOT NULL, `code` text NOT NULL, `text` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T_info` -- LOCK TABLES `T_info` WRITE; /*!40000 ALTER TABLE `T_info` DISABLE KEYS */; /*!40000 ALTER TABLE `T_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `T_link_key` -- DROP TABLE IF EXISTS `T_link_key`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `T_link_key` ( `recno` float NOT NULL auto_increment, `item_key1` text NOT NULL, `item_key2` text NOT NULL, `item_key3` text NOT NULL, `sys_date` text NOT NULL, PRIMARY KEY (`recno`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T_link_key` -- LOCK TABLES `T_link_key` WRITE; /*!40000 ALTER TABLE `T_link_key` DISABLE KEYS */; /*!40000 ALTER TABLE `T_link_key` 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 2019-10-03 14:36:38