-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 
-- サーバのバージョン： 10.1.35-MariaDB
-- PHP Version: 7.2.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `narajwwa_shinsei2`
--

-- --------------------------------------------------------

--
-- テーブルの構造 `s_count_city_month`
--

CREATE TABLE `s_count_city_month` (
  `市町村CD` int(6) NOT NULL,
  `市町村名` varchar(10) NOT NULL,
  `新規04` int(2) NOT NULL,
  `新規05` int(2) NOT NULL,
  `新規06` int(2) NOT NULL,
  `新規07` int(2) NOT NULL,
  `新規08` int(2) NOT NULL,
  `新規09` int(2) NOT NULL,
  `新規10` int(2) NOT NULL,
  `新規11` int(2) NOT NULL,
  `新規12` int(2) NOT NULL,
  `新規01` int(2) NOT NULL,
  `新規02` int(2) NOT NULL,
  `新規03` int(2) NOT NULL,
  `新規計` int(2) NOT NULL,
  `変更04` int(2) NOT NULL,
  `変更05` int(2) NOT NULL,
  `変更06` int(2) NOT NULL,
  `変更07` int(2) NOT NULL,
  `変更08` int(2) NOT NULL,
  `変更09` int(2) NOT NULL,
  `変更10` int(2) NOT NULL,
  `変更11` int(2) NOT NULL,
  `変更12` int(2) NOT NULL,
  `変更01` int(2) NOT NULL,
  `変更02` int(2) NOT NULL,
  `変更03` int(2) NOT NULL,
  `変更計` int(2) NOT NULL,
  `廃止04` int(2) NOT NULL,
  `廃止05` int(2) NOT NULL,
  `廃止06` int(2) NOT NULL,
  `廃止07` int(2) NOT NULL,
  `廃止08` int(2) NOT NULL,
  `廃止09` int(2) NOT NULL,
  `廃止10` int(2) NOT NULL,
  `廃止11` int(2) NOT NULL,
  `廃止12` int(2) NOT NULL,
  `廃止01` int(2) NOT NULL,
  `廃止02` int(2) NOT NULL,
  `廃止03` int(2) NOT NULL,
  `廃止計` int(2) NOT NULL,
  `選任04` int(2) NOT NULL,
  `選任05` int(2) NOT NULL,
  `選任06` int(2) NOT NULL,
  `選任07` int(2) NOT NULL,
  `選任08` int(2) NOT NULL,
  `選任09` int(2) NOT NULL,
  `選任10` int(2) NOT NULL,
  `選任11` int(2) NOT NULL,
  `選任12` int(2) NOT NULL,
  `選任01` int(2) NOT NULL,
  `選任02` int(2) NOT NULL,
  `選任03` int(2) NOT NULL,
  `選任計` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- テーブルのデータのダンプ `s_count_city`
--

--
ALTER TABLE `s_count_city_month`
  ADD PRIMARY KEY (`市町村CD`);
COMMIT;

/*!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 */;
