--
-- Host: localhost    Database: src_news
-- ------------------------------------------------------


--
-- Table structure for table `src_news_usr`
--

CREATE TABLE `src_news_usr` (
  `usr_aut_id` int NOT NULL AUTO_INCREMENT,
  `usr_id` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `usr_password` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `usr_name` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `usr_mail` varchar(110) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `usr_day` int DEFAULT NULL,
  `usr_ctgoy_01` int DEFAULT NULL,
  `usr_ctgoy_02` int DEFAULT NULL,
  `usr_ctgoy_03` int DEFAULT NULL,
  `usr_ctgoy_04` int DEFAULT NULL,
  `usr_ctgoy_05` int DEFAULT NULL,
  `usr_ment` int DEFAULT NULL,
  `send_flag` int DEFAULT NULL,
  PRIMARY KEY (`usr_aut_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `src_news_usr`
--

INSERT INTO `src_news_usr` VALUES (1,'cmp_admin','848614510','管理者','ikegami@cmpj.co.jp',20120812,600,600,600,600,600,600,1),(15,'nishigaki','tokaisand','西垣卓馬','nishigaki.takuma@tokai.ac.jp',20240606,250,250,NULL,NULL,NULL,250,1),(13,'takayama','yu060215','高山千里','takayama-c@tokai.ac.jp',20240606,250,250,NULL,NULL,NULL,250,0),(14,'maezawa','abcdefgh','maezawa','maezawa@tokai-u.jp',20210330,250,250,NULL,NULL,NULL,250,0);


