--
-- Host: localhost    Database: butterflies_nagai
-- ------------------------------------------------------


--
-- Table structure for table `usr`
--

CREATE TABLE `usr` (
  `auto_no` int NOT NULL AUTO_INCREMENT,
  `usr_id` varchar(45) DEFAULT NULL,
  `usr_pw` varchar(45) DEFAULT NULL,
  `usr_name` varchar(45) DEFAULT NULL,
  `usr_mail` varchar(45) DEFAULT NULL,
  `last_update` varchar(45) DEFAULT NULL,
  `usr_flag` int DEFAULT NULL,
  `input_usr_id` varchar(45) DEFAULT NULL,
  `question` text,
  PRIMARY KEY (`auto_no`)
) ENGINE=InnoDB AUTO_INCREMENT=260 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `usr`
--

INSERT INTO `usr` VALUES (1,'cmp','1111','管理者','ikegami@cmpj.co.jp','0000-00-00 00:00:00',1,'1',NULL),(2,'sasaki','sasaki','佐々木','sasaki@cmpj.co.jp',NULL,1,'1',NULL),(13,'kakinuma','kakinuma','柿沼','atmwam@yahoo.co.jp','2021-05-15 18:08:42',2,NULL,NULL),(14,'aknagai@cello.ocn.ne.jp','h_B2c84D','永井','aknagai@cello.ocn.ne.jp','2021-06-02 14:52:43',1,'1',NULL),(210,'anagai543351712','h_B2c84D','永井　彰','aknagai@cello.ocn.ne.jp','2021-12-30-16:42:56',3,NULL,''),(225,NULL,NULL,NULL,NULL,'2023-09-21-14:14:22',99,NULL,''),(226,NULL,NULL,NULL,NULL,'2023-11-05-11:46:17',99,NULL,''),(227,NULL,NULL,NULL,NULL,'2023-12-13-13:42:12',99,NULL,''),(228,NULL,NULL,NULL,NULL,'2024-03-25-03:05:05',99,NULL,''),(229,NULL,NULL,NULL,NULL,'2024-04-30-07:31:11',99,NULL,''),(230,NULL,NULL,NULL,NULL,'2024-05-26-13:00:41',99,NULL,''),(231,NULL,NULL,NULL,NULL,'2024-05-27-15:48:45',99,NULL,''),(232,NULL,NULL,NULL,NULL,'2024-05-28-10:57:12',99,NULL,''),(233,NULL,NULL,NULL,NULL,'2024-05-28-21:31:05',99,NULL,''),(234,NULL,NULL,NULL,NULL,'2024-05-29-12:10:09',99,NULL,''),(235,NULL,NULL,NULL,NULL,'2024-05-30-02:37:00',99,NULL,''),(236,NULL,NULL,NULL,NULL,'2024-06-01-07:26:34',99,NULL,''),(237,NULL,NULL,NULL,NULL,'2024-06-05-15:17:18',99,NULL,''),(238,NULL,NULL,NULL,NULL,'2024-06-06-10:20:08',99,NULL,''),(239,NULL,NULL,NULL,NULL,'2024-06-07-05:37:06',99,NULL,''),(240,NULL,NULL,NULL,NULL,'2024-06-08-02:36:38',99,NULL,''),(241,NULL,NULL,NULL,NULL,'2024-06-09-00:28:38',99,NULL,''),(242,NULL,NULL,NULL,NULL,'2024-06-09-02:47:29',99,NULL,''),(243,NULL,NULL,NULL,NULL,'2024-06-09-07:59:24',99,NULL,''),(244,NULL,NULL,NULL,NULL,'2024-06-09-10:11:18',99,NULL,''),(245,NULL,NULL,NULL,NULL,'2024-06-10-07:46:37',99,NULL,''),(246,NULL,NULL,NULL,NULL,'2024-06-10-08:31:38',99,NULL,''),(247,NULL,NULL,NULL,NULL,'2024-06-10-22:49:00',99,NULL,''),(248,NULL,NULL,NULL,NULL,'2024-06-11-18:54:31',99,NULL,''),(249,NULL,NULL,NULL,NULL,'2024-06-12-02:30:39',99,NULL,''),(250,NULL,NULL,NULL,NULL,'2024-06-12-16:26:38',99,NULL,''),(251,NULL,NULL,NULL,NULL,'2024-06-13-01:27:29',99,NULL,''),(252,NULL,NULL,NULL,NULL,'2024-06-13-03:29:50',99,NULL,''),(253,NULL,NULL,NULL,NULL,'2024-06-14-00:04:21',99,NULL,''),(254,NULL,NULL,NULL,NULL,'2024-06-14-14:28:52',99,NULL,''),(255,NULL,NULL,NULL,NULL,'2024-07-06-07:43:02',99,NULL,''),(256,NULL,NULL,NULL,NULL,'2024-07-10-07:47:52',99,NULL,''),(257,NULL,NULL,NULL,NULL,'2024-07-10-16:15:50',99,NULL,''),(258,NULL,NULL,NULL,NULL,'2024-07-12-07:56:34',99,NULL,''),(259,NULL,NULL,NULL,NULL,'2024-08-06-19:06:02',99,NULL,'');


