# -*- coding: utf-8 -*-
# Generated by Django 1.11.4 on 2017-09-22 11:46
from __future__ import unicode_literals

import datetime
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('ac_site', '0014_auto_20170922_2028'),
    ]

    operations = [
        migrations.CreateModel(
            name='City',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('city_id', models.IntegerField(default=0)),
                ('city', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='Consumption',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('csm_id', models.IntegerField(default=0)),
                ('prefecture_id', models.IntegerField(default=0)),
                ('num_of_answers', models.IntegerField(default=0)),
                ('consumption', models.IntegerField(default=0)),
            ],
        ),
        migrations.CreateModel(
            name='ForeignGuest',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('num_of_foreign_id', models.IntegerField(default=0)),
                ('guest_2011', models.IntegerField(default=0)),
                ('guest_2012', models.IntegerField(default=0)),
                ('guest_2013', models.IntegerField(default=0)),
                ('guest_2014', models.IntegerField(default=0)),
                ('guest_2015', models.IntegerField(default=0)),
                ('guest_2016', models.IntegerField(default=0)),
            ],
        ),
        migrations.CreateModel(
            name='ForeignGuestM',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('num_of_foreign_month_id', models.IntegerField(default=0)),
                ('guest_201101', models.IntegerField(default=0)),
                ('guest_201102', models.IntegerField(default=0)),
                ('guest_201103', models.IntegerField(default=0)),
                ('guest_201104', models.IntegerField(default=0)),
                ('guest_201105', models.IntegerField(default=0)),
                ('guest_201106', models.IntegerField(default=0)),
                ('guest_201107', models.IntegerField(default=0)),
                ('guest_201108', models.IntegerField(default=0)),
                ('guest_201109', models.IntegerField(default=0)),
                ('guest_201110', models.IntegerField(default=0)),
                ('guest_201111', models.IntegerField(default=0)),
                ('guest_201112', models.IntegerField(default=0)),
                ('guest_201201', models.IntegerField(default=0)),
                ('guest_201202', models.IntegerField(default=0)),
                ('guest_201203', models.IntegerField(default=0)),
                ('guest_201204', models.IntegerField(default=0)),
                ('guest_201205', models.IntegerField(default=0)),
                ('guest_201206', models.IntegerField(default=0)),
                ('guest_201207', models.IntegerField(default=0)),
                ('guest_201208', models.IntegerField(default=0)),
                ('guest_201209', models.IntegerField(default=0)),
                ('guest_201210', models.IntegerField(default=0)),
                ('guest_201211', models.IntegerField(default=0)),
                ('guest_201212', models.IntegerField(default=0)),
                ('guest_201301', models.IntegerField(default=0)),
                ('guest_201302', models.IntegerField(default=0)),
                ('guest_201303', models.IntegerField(default=0)),
                ('guest_201304', models.IntegerField(default=0)),
                ('guest_201305', models.IntegerField(default=0)),
                ('guest_201306', models.IntegerField(default=0)),
                ('guest_201307', models.IntegerField(default=0)),
                ('guest_201308', models.IntegerField(default=0)),
                ('guest_201309', models.IntegerField(default=0)),
                ('guest_201310', models.IntegerField(default=0)),
                ('guest_201311', models.IntegerField(default=0)),
                ('guest_201312', models.IntegerField(default=0)),
                ('guest_201401', models.IntegerField(default=0)),
                ('guest_201402', models.IntegerField(default=0)),
                ('guest_201403', models.IntegerField(default=0)),
                ('guest_201404', models.IntegerField(default=0)),
                ('guest_201405', models.IntegerField(default=0)),
                ('guest_201406', models.IntegerField(default=0)),
                ('guest_201407', models.IntegerField(default=0)),
                ('guest_201408', models.IntegerField(default=0)),
                ('guest_201409', models.IntegerField(default=0)),
                ('guest_201410', models.IntegerField(default=0)),
                ('guest_201411', models.IntegerField(default=0)),
                ('guest_201412', models.IntegerField(default=0)),
                ('guest_201501', models.IntegerField(default=0)),
                ('guest_201502', models.IntegerField(default=0)),
                ('guest_201503', models.IntegerField(default=0)),
                ('guest_201504', models.IntegerField(default=0)),
                ('guest_201505', models.IntegerField(default=0)),
                ('guest_201506', models.IntegerField(default=0)),
                ('guest_201507', models.IntegerField(default=0)),
                ('guest_201508', models.IntegerField(default=0)),
                ('guest_201509', models.IntegerField(default=0)),
                ('guest_201510', models.IntegerField(default=0)),
                ('guest_201511', models.IntegerField(default=0)),
                ('guest_201512', models.IntegerField(default=0)),
                ('guest_201601', models.IntegerField(default=0)),
                ('guest_201602', models.IntegerField(default=0)),
                ('guest_201603', models.IntegerField(default=0)),
                ('guest_201604', models.IntegerField(default=0)),
                ('guest_201605', models.IntegerField(default=0)),
            ],
        ),
        migrations.CreateModel(
            name='HotelType',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('hotel_id', models.IntegerField(default=0)),
                ('prefecture_id', models.IntegerField(default=0)),
                ('hotel', models.IntegerField(default=0)),
                ('ryokan', models.IntegerField(default=0)),
                ('condominium', models.IntegerField(default=0)),
                ('dorm', models.IntegerField(default=0)),
                ('house', models.IntegerField(default=0)),
                ('youth_hostel', models.IntegerField(default=0)),
                ('other', models.IntegerField(default=0)),
            ],
        ),
        migrations.CreateModel(
            name='PriceofLand',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('priceofland_id', models.IntegerField(default=0)),
                ('prefecture_id', models.IntegerField(default=0)),
                ('city_id', models.IntegerField(default=0, null=True)),
                ('properties', models.IntegerField(default=0)),
                ('average_price', models.IntegerField(default=0)),
                ('upper_price', models.IntegerField(default=0)),
                ('lower_price', models.IntegerField(default=0)),
            ],
        ),
        migrations.CreateModel(
            name='TourResource',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('scr_id', models.IntegerField(default=0)),
                ('prefecture_id', models.IntegerField(default=0)),
                ('city_id', models.IntegerField(default=0, null=True)),
                ('scr_type1', models.CharField(max_length=20)),
                ('scr_type2', models.CharField(max_length=20)),
                ('scr_name', models.CharField(max_length=50)),
                ('scr_rank', models.CharField(max_length=5)),
                ('scr_score', models.IntegerField(default=0)),
            ],
        ),
        migrations.CreateModel(
            name='WebSite',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('web_id', models.IntegerField(default=0)),
                ('prefecture_id', models.IntegerField(default=0)),
                ('city_id', models.IntegerField(default=0, null=True)),
                ('website', models.IntegerField(default=0)),
            ],
        ),
        migrations.AlterField(
            model_name='listingtrend',
            name='created_at',
            field=models.DateTimeField(default=datetime.datetime(2017, 9, 22, 11, 46, 15, 437623)),
        ),
        migrations.AlterField(
            model_name='summaryarticlebreakdown',
            name='created_at',
            field=models.DateTimeField(default=datetime.datetime(2017, 9, 22, 11, 46, 15, 436207)),
        ),
        migrations.AlterField(
            model_name='summarysizebreakdown',
            name='created_at',
            field=models.DateTimeField(default=datetime.datetime(2017, 9, 22, 11, 46, 15, 435583)),
        ),
    ]
