text: -- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
  --
  -- Host: 127.0.0.1    Database: ogsdb
  -- ------------------------------------------------------
  -- Server version	5.6.27-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 `tbl_client`
  --
  
  DROP TABLE IF EXISTS `tbl_client`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tbl_client` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `login_id` varchar(50) NOT NULL,
    `login_password` varchar(256) NOT NULL,
    `access_key` varchar(32) NOT NULL,
    `display_flg` tinyint(4) DEFAULT NULL COMMENT '会場ツールのアカウントに表示をするかの制御1: 表示する0: 表示しない',
    `status` tinyint(4) NOT NULL DEFAULT '0',
    `insert_date` datetime NOT NULL,
    `update_date` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `tbl_client_unique` (`access_key`)
  ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tbl_client`
  --
  
  LOCK TABLES `tbl_client` WRITE;
  /*!40000 ALTER TABLE `tbl_client` DISABLE KEYS */;
  INSERT INTO `tbl_client` VALUES (1,'株式会社デコレーションズ','ACCOUNT-1','$2y$10$YTG2Xr9bGHcNQF1d0hInS./x8kMx/x18VS7wobyvVBLX7f.uzlrR6','66cf8b349d9de1c54748a1c9a6c23643',1,1,'2018-08-09 20:56:50','2018-08-14 14:27:10'),(2,'株式会社UKPM','ACCOUNT-2','$2y$10$B1fndzKgUfCCn7ZI4caCgecctMHkUq3LyEYJodAwIlj3QlU9ZPgCe','a3f79276a6d744529840a8e4287d27d6',1,1,'2018-08-09 20:57:22','2018-08-14 14:27:17'),(3,'SUNDAY FOLK PROMOTION','ACCOUNT-3','$2y$10$lC.cOx3hCGyA1UBa7iylgOniMb0HMp4bH9VVuRR.JXFpOcNJBZWza','9a943cee453961a5446115a272f49c0f',1,1,'2018-08-09 20:57:43','2018-08-14 14:27:22'),(4,'OFFICE KINOSHITA','ACCOUNT-4','$2y$10$rq5e32ZaUtYLVOeazF6EPOUxrk5P2BvBL3Tb4vz8GsJKHN937nDD2','c623ee36f5f255f7358489487b45e882',0,1,'2018-08-09 21:04:16','2018-08-14 14:27:34'),(5,'株式会社MN','ACCOUNT-5','$2y$10$O6cqq1Q.tqObWyx5YpR2uOEvVkHRjSyV3ib91K8n9R5THZLdymdqm','5fab3e6165d80d10dd8fecadd7fa7d73',0,1,'2018-08-14 14:28:06',NULL),(6,'キリキリヴィラ合同会社','ACCOUNT-6','$2y$10$JN.W8k2m4o3bxVRHuVie6.K7IP1hp78mrCQPWsHwUiu9bSz/nzSrO','e1b0463c19cbb1ae46b218ce2a2026a7',0,1,'2018-08-14 14:28:30',NULL),(7,'株式会社RENI','ACCOUNT-7','$2y$10$D1GdbbkUiX8ggpJze55u.OHdO886mFp.hVanHCcEM2.Y6dGGMNxhu','f9bd0d59195a4e8dbc0ec4c3f2613ba7',0,1,'2018-08-14 14:29:04',NULL),(8,'日東電化工業株式会社','ACCOUNT-8','$2y$10$/AJv2eanigS01jyx8VkyzOY9s5AMi3yXLHL/va.rcXyQ1lLxKaOuq','3f96f3f048016dff91e8e45507839218',0,1,'2018-08-14 14:29:34',NULL),(9,'MAY’S 片桐 様','ACCOUNT-9','$2y$10$lAIAgWhb62GViv7BJPbz.e6nboowXKL5.99YTRjl/Gdy2IA8SOKEm','17a7609cb51ba9be21c8eeeba4d1659f',0,1,'2018-08-14 14:30:20',NULL),(10,'株式会社CRAZY JET','ACCOUNT-10','$2y$10$p98t2Wp4mwtuAd9RoHWiJeYVm307iPOBe01O9LoVkpE4iojKS6Dva','ab2848f855c851a8ca67d8613cf9b34f',0,1,'2018-08-14 14:31:08',NULL),(11,'株式会社ヒューベースi','ACCOUNT-11','$2y$10$5mLRGmXqQCHZ7YIZexJQHe9OnWq6k9pwEtYd56UzNzM.mp4Zbmjxi','13e30ff991644a01fa4cbc2a50869d8f',0,1,'2018-08-14 14:31:33',NULL),(12,'有限会社サードストーン','ACCOUNT-12','$2y$10$fOnC63stl6dbq7dMfar1e.WuBBWbOCmPyYDgle2L.WP41X7HzWaM.','a0e3e1e30dc547f97a7d5f0468148f30',0,1,'2018-08-14 14:31:54',NULL),(13,'株式会社A-Sketch','ACCOUNT-13','$2y$10$4zpAwJNuCta4fsB6puTZBeKBZATs8hdDraDYmEzmQBafh4Mec4dla','463ad23c4a94f977b0f14ce1cbd1ca30',0,1,'2018-08-14 14:32:21','2018-08-14 14:34:33'),(14,'株式会社スマッシュ','ACCOUNT-14','$2y$10$2GiE4phr4o/OZrR2kNw0J.zPpzZvN1Uo0R1s7pfYwRt5vbvej8.KC','96f167973a6ebe4fdf577788589d85b0',0,1,'2018-08-14 14:32:43',NULL),(15,'株式会社サンライズプロモーション東京','ACCOUNT-15','$2y$10$e71ogE6qdeyWtRHfJdhoEuf4Fvr63TlLV2QrL7BM12XqFbRElW/pO','702c82756ac6632a575808d8e86333d1',0,1,'2018-08-14 14:33:05',NULL),(16,'JET株式会社','ACCOUNT-16','$2y$10$XFZMIweWljUWRvQ1RDpQ1esg7VLVlXSTeRDvGXXh.Q7qvHT2F8qRi','00843a57a9791c3183fae0e37d7c900c',0,1,'2018-08-14 14:33:26',NULL),(17,'株式会社JTB','ACCOUNT-17','$2y$10$pyHgTpYD.7c9FlkPnJAFz.ku4VHPyGRfxrLy69BjMb1t.Qb636Dlm','1dc7986a59ce50ebffafab37e7834107',0,1,'2018-08-14 14:33:57','2018-08-27 15:40:03'),(18,'TEST','ACCOUNT-99','pass','',0,1,'2018-12-15 00:00:00',NULL);
  /*!40000 ALTER TABLE `tbl_client` 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 2018-12-19 15:22:05
  