class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Post',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('create_date', models.DateField(auto_now_add=True)),
('text_book', models.CharField(max_length=255)),
('type',
models.CharField(choices=[('1', 'sell'), ('2', 'buy')],
max_length=1)),
('price', models.FloatField()),
('picture',
models.ImageField(upload_to=book.models.user_directory_path)),
('status',
models.CharField(choices=[('1', 'open'), ('2', 'closed')],
max_length=1)),
('create_by',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Book',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('book_name', models.CharField(max_length=20)),
('isbn', models.CharField(max_length=20)),
('pur_date', models.DateField()),
('book_code', models.CharField(max_length=20)),
('status', models.IntegerField(validators=[book.models.is_posititve])),
],
),
migrations.CreateModel(
name='BookCategory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=20)),
],
),
migrations.AddField(
model_name='book',
name='category',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='book.BookCategory'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('first_name', models.CharField(max_length=30)),
('last_name', models.CharField(blank=True, max_length=30)),
('age', models.PositiveIntegerField(blank=True)),
('email', models.EmailField(max_length=254, unique=True)),
('birth_date', models.DateTimeField()),
('image', models.ImageField(blank=True, upload_to='')),
('is_staff', models.BooleanField(default=False)),
('is_active', models.BooleanField(default=True)),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
},
managers=[
('objects', book.models.UserManager()),
],
),
migrations.CreateModel(
name='Author',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=256, unique=True)),
('bio', models.TextField(blank=True)),
('date_of_birth', models.DateField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Book',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=256, unique=True)),
('description', models.TextField(blank=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='books', to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='author',
name='books',
field=models.ManyToManyField(related_name='authors', to='book.Book'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('shop', '0001_initial'),
('customer', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Order',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('metafield', jsonfield.fields.JSONField(default=dict)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('category',
models.CharField(choices=[('room', '订房')],
default='room',
max_length=255)),
('order_number',
models.CharField(default=order.models.make_order_number,
help_text='订单号',
max_length=255)),
('price', models.FloatField(help_text='订单总价 单位元')),
('status',
models.CharField(choices=[('pending', '待支付'), ('paid', '已支付'),
('refunding', '退款中'),
('refund', '已退款'),
('cancel', '已取消')],
default='pending',
max_length=255)),
('full_name',
models.CharField(blank=True, help_text='姓名', max_length=255)),
('mobile',
models.CharField(blank=True, help_text='手机', max_length=255)),
('remark', models.TextField(blank=True, help_text='备注')),
('use_balance', models.FloatField(default=0)),
('use_wx', models.FloatField(default=0)),
('starts_at', models.DateField(blank=True, null=True)),
('ends_at', models.DateField(blank=True, null=True)),
('arrive',
models.CharField(blank=True, help_text='到店时间',
max_length=255)),
('shop',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='shop.Shop')),
('use_coupon',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='customer.CouponCode')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='OrderRoom',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('metafield', jsonfield.fields.JSONField(default=dict)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('quantity', models.IntegerField(default=1)),
('order',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='book.Order')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Room',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('metafield', jsonfield.fields.JSONField(default=dict)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('name', models.CharField(blank=True, max_length=255)),
('description', models.TextField(blank=True)),
('pic', models.ImageField(upload_to='room_pic')),
('area',
models.CharField(blank=True, help_text='面积', max_length=255)),
('bed_type',
models.CharField(blank=True, help_text='床型', max_length=255)),
('window',
models.CharField(blank=True, help_text='窗户', max_length=255)),
('bed_width',
models.CharField(blank=True, help_text='床宽', max_length=255)),
('capacity',
models.CharField(blank=True, help_text='入住人数',
max_length=255)),
('floor',
models.CharField(blank=True, help_text='所在楼层',
max_length=255)),
('price', models.FloatField(default=100)),
('shop',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='shop.Shop')),
],
options={
'abstract': False,
},
),
migrations.AddField(
model_name='orderroom',
name='room',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='book.Room'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Book',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('isbn10',
models.CharField(blank=True,
default='',
max_length=10,
verbose_name='ISBN10')),
('isbn13',
models.CharField(
max_length=13,
validators=[book.models.BookEditValidator.isbn13],
verbose_name='ISBN13')),
('face_l',
models.URLField(blank=True,
default='',
max_length=255,
verbose_name='Face_L')),
('face_m',
models.URLField(blank=True,
default='',
max_length=255,
verbose_name='Face_M')),
('face_s',
models.URLField(blank=True,
default='',
max_length=255,
verbose_name='Face_S')),
('title', models.CharField(max_length=128,
verbose_name='Title')),
('subtitle',
models.CharField(blank=True,
default='',
max_length=128,
verbose_name='Subtitle')),
('pages',
models.PositiveSmallIntegerField(blank=0,
default=0,
null=0,
verbose_name='Pages')),
('author',
models.CharField(blank=True,
default='',
max_length=256,
verbose_name='Author')),
('translator',
models.CharField(blank=True,
default='',
max_length=256,
verbose_name='Translator')),
('publisher',
models.CharField(blank=True,
default='',
max_length=256,
verbose_name='Publisher')),
('price',
models.DecimalField(blank=True,
decimal_places=2,
default=0,
max_digits=5,
null=True,
verbose_name='Price')),
('binding',
models.CharField(blank=True,
default='',
max_length=128,
verbose_name='Binding')),
('pubdate',
models.DateField(blank=True,
help_text='(.etc 2017-11-13)',
null=True,
verbose_name='Date Published')),
('authorDesc',
models.TextField(blank=True,
default='',
verbose_name='Author Desc')),
('summary',
models.TextField(blank=True,
default='',
verbose_name='Summary')),
('rating',
models.DecimalField(blank=True,
decimal_places=2,
default=0,
max_digits=5,
null=True,
verbose_name='Rating')),
],
),
migrations.CreateModel(
name='Category',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=64, verbose_name='Category')),
],
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('zone',
models.CharField(help_text='The name of zone',
max_length=128,
verbose_name='Zone')),
('shelf',
models.PositiveSmallIntegerField(
help_text='The number of shelf', verbose_name='Shelf')),
('row', models.PositiveSmallIntegerField(verbose_name='Row')),
('col', models.PositiveSmallIntegerField(verbose_name='Col')),
],
),
migrations.CreateModel(
name='Reader',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('readPages',
models.PositiveSmallIntegerField(blank=0,
default=0,
help_text='(Pages Be Read)',
null=0,
verbose_name='Read Pages')),
('readStart',
models.DateField(blank=True,
help_text='(.etc 2017-11-13)',
null=True,
verbose_name='Reading Start')),
('readEnd',
models.DateField(blank=True,
help_text='(.etc 2017-11-13)',
null=True,
verbose_name='Reading Finished')),
('readTags',
models.TextField(blank=True,
default='',
verbose_name='Reading Tags')),
('readNote',
models.TextField(blank=True,
default='',
verbose_name='Reading Note')),
('boughtDate',
models.DateField(blank=True,
help_text='(.etc 2017-11-13)',
null=True,
verbose_name='Date Bought')),
('boughtPrice',
models.DecimalField(blank=True,
decimal_places=2,
default=0,
max_digits=5,
null=True,
verbose_name='Price Bought')),
('book',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='reader',
to='book.Book',
verbose_name='Book')),
('name',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='read',
to=settings.AUTH_USER_MODEL,
verbose_name='Name of Reader')),
],
),
migrations.AddField(
model_name='book',
name='category',
field=models.ForeignKey(
blank=True,
default='',
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='book.Category',
verbose_name='Category'),
),
migrations.AddField(
model_name='book',
name='location',
field=models.ForeignKey(
blank=True,
default='',
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='book.Location',
verbose_name='Location'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Author',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100, unique=True)),
('age', models.IntegerField()),
],
),
migrations.CreateModel(
name='Book',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=150)),
('slug', models.SlugField(blank=True, unique=True)),
('isbn', models.CharField(max_length=140, unique=True)),
('pub_date', models.DateField()),
('no_of_actual_copy', models.IntegerField()),
('no_of_copy_left', models.IntegerField()),
('image',
models.ImageField(upload_to=book.models.upload_image_path)),
('authors', models.ManyToManyField(to='book.Author')),
],
),
migrations.CreateModel(
name='Category',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=150, unique=True)),
],
),
migrations.CreateModel(
name='Publisher',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=200, unique=True)),
],
),
migrations.CreateModel(
name='review',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('rating', models.IntegerField()),
('review', models.TextField(blank=True)),
],
),
migrations.AddField(
model_name='book',
name='category',
field=models.ManyToManyField(related_name='books',
to='book.Category'),
),
migrations.AddField(
model_name='book',
name='publisher',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='book.Publisher'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name="SearchFdsnStationModel",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("network_code", models.CharField(blank=True, max_length=256)),
("station_code", models.CharField(blank=True, max_length=256)),
("site_name", models.CharField(blank=True, max_length=256)),
(
"network_class",
models.CharField(
blank=True,
choices=[
("all", "All"),
("permanent", "Permanent"),
("temporary", "Temporary"),
],
default="",
max_length=256,
),
),
(
"network_access",
models.CharField(
blank=True,
choices=[
("all", "All"),
("unrestricted", "Unrestricted"),
("restricted", "Restricted"),
],
default="",
max_length=256,
),
),
(
"station_status",
models.CharField(
blank=True,
choices=[
("all", "All"),
("open", "Open"),
("closed", "Closed"),
],
default="",
max_length=256,
),
),
(
"station_access",
models.CharField(
blank=True,
choices=[
("all", "All"),
("unrestricted", "Unrestricted"),
("restricted", "Restricted"),
],
default="",
max_length=256,
),
),
(
"sensor_unit",
models.CharField(
blank=True,
choices=[
("all", "All"),
("m", "M"),
("ms", "M/S"),
("mss", "M/S^2"),
("pa", "PA"),
("c", "C"),
("deg", "DEG"),
("undefined", "Undefined"),
],
default="",
max_length=256,
),
),
(
"sensor_type",
models.CharField(
blank=True,
choices=[
("all", "All"),
("vbb", "VBB"),
("bb", "BB"),
("sp", "SP"),
("sm", "SM"),
("obs", "OBS"),
("undefined", "Undefined"),
],
default="",
max_length=256,
),
),
(
"latitude_min",
models.DecimalField(blank=True, decimal_places=6, max_digits=9),
),
(
"latitude_max",
models.DecimalField(blank=True, decimal_places=6, max_digits=9),
),
(
"longitude_min",
models.DecimalField(blank=True, decimal_places=6, max_digits=9),
),
(
"longitude_max",
models.DecimalField(blank=True, decimal_places=6, max_digits=9),
),
("start_year_from", models.IntegerField(blank=True)),
("start_year_to", models.IntegerField(blank=True)),
("end_year_from", models.IntegerField(blank=True)),
("end_year_to", models.IntegerField(blank=True)),
(
"geological_unit",
models.CharField(
blank=True,
choices=[
("unknown", "Unknown"),
("alluvial_deposits", "Alluvial deposits"),
("ancient_alluvialterraces", "Ancient alluvial terraces"),
("argillite", "Argillite"),
("breccias", "Breccias"),
("clay", "Clay"),
("conglomerate", "Conglomerate"),
("debris", "Debris"),
("diabase", "Diabase"),
("dolomite", "Dolomite"),
("fillade", "Fillade"),
("fluvial_deposits", "Fluvial deposits"),
("gneiss", "Gneiss"),
("granite", "Granite"),
("jasper", "Jasper"),
("lacustrine_deposits", "Lacustrine deposits"),
("limestone", "Limestone"),
("marls", "Marls"),
("metamorphic_rock", "Metamorphic rock"),
("micaschist", "Micaschist"),
("morainic_deposits", "Morainic deposits"),
("ophiolite", "Ophiolite"),
("rhyolitic_ignimbrite", "Rhyolitic ignimbrite"),
("sand_deposits", "Sand deposits"),
("sandstone", "Sandstone"),
("schist", "Schist"),
("torbidite", "Torbidite"),
("volcanic_deposits", "Volcanic deposits"),
("volcanic_rocks", "Volcanic rocks"),
],
default="",
max_length=256,
),
),
(
"morphology_class",
models.CharField(
blank=True,
choices=[
("unknown", "Unknown"),
("t1", "T1"),
("t2", "T2"),
("t3", "T3"),
("t4", "T4"),
],
default="",
max_length=256,
),
),
(
"ground_type_ec8",
models.CharField(
blank=True,
choices=[
("unknown", "Unknown"),
("a", "A"),
("b", "B"),
("c", "C"),
("d", "D"),
("e", "E"),
("s1", "S1"),
("s2", "S2"),
],
default="",
max_length=256,
),
),
("basin_flag", models.BooleanField(default=False)),
(
"vs30_from",
models.DecimalField(blank=True, decimal_places=6, max_digits=12),
),
(
"vs30_to",
models.DecimalField(blank=True, decimal_places=6, max_digits=12),
),
(
"f0_from",
models.DecimalField(blank=True, decimal_places=6, max_digits=12),
),
(
"f0_to",
models.DecimalField(blank=True, decimal_places=6, max_digits=12),
),
],
options={"managed": False,},
),
migrations.CreateModel(
name="ExtEntityBase",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"ext_network_code",
models.TextField(blank=True, default="", max_length=16384),
),
(
"ext_network_start_year",
models.TextField(blank=True, default="", max_length=16384),
),
(
"ext_station_code",
models.TextField(blank=True, default="", max_length=16384),
),
(
"ext_station_start_year",
models.TextField(blank=True, default="", max_length=16384),
),
("entity_removed", models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name="FdsnNetwork",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("code", models.CharField(max_length=256)),
(
"description",
models.CharField(blank=True, default="", max_length=256),
),
(
"start_date",
models.DateTimeField(blank=True, default="", max_length=256),
),
(
"restricted_status",
models.CharField(blank=True, default="", max_length=256),
),
],
options={"ordering": ["code"],},
),
migrations.CreateModel(
name="FdsnNode",
fields=[
(
"code",
models.CharField(
max_length=256, primary_key=True, serialize=False, unique=True
),
),
(
"description",
models.CharField(blank=True, default="", max_length=256),
),
(
"url_dataselect",
models.CharField(blank=True, default="", max_length=1024),
),
(
"url_station",
models.CharField(blank=True, default="", max_length=1024),
),
(
"url_routing",
models.CharField(blank=True, default="", max_length=1024),
),
(
"url_wfcatalog",
models.CharField(blank=True, default="", max_length=1024),
),
],
),
migrations.CreateModel(
name="FdsnStation",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("code", models.CharField(max_length=256)),
("site_name", models.CharField(blank=True, max_length=256)),
(
"latitude",
models.DecimalField(blank=True, decimal_places=6, max_digits=9),
),
(
"longitude",
models.DecimalField(blank=True, decimal_places=6, max_digits=9),
),
(
"elevation",
models.DecimalField(blank=True, decimal_places=2, max_digits=6),
),
("restricted_status", models.CharField(blank=True, max_length=256)),
("start_date", models.DateTimeField(blank=True, max_length=256)),
(
"end_date",
models.DateTimeField(blank=True, max_length=256, null=True),
),
(
"creation_date",
models.DateTimeField(blank=True, max_length=256, null=True),
),
(
"fdsn_network",
models.ForeignKey(
default=None,
on_delete=django.db.models.deletion.CASCADE,
related_name="fdsn_stations",
to="book.FdsnNetwork",
),
),
],
options={
"ordering": [
"fdsn_network__fdsn_node__code",
"fdsn_network__code",
"code",
],
},
),
migrations.CreateModel(
name="Link",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("url", models.CharField(blank=True, max_length=1024, null=True)),
("category", models.CharField(blank=True, max_length=1024, null=True)),
(
"description",
models.CharField(blank=True, max_length=1024, null=True),
),
],
),
migrations.CreateModel(
name="Profile",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("about", models.CharField(blank=True, max_length=1024)),
("location", models.CharField(blank=True, max_length=1024)),
("agency", models.CharField(blank=True, max_length=1024)),
("department", models.CharField(blank=True, max_length=1024)),
("telephone", models.CharField(blank=True, max_length=1024)),
("skype", models.CharField(blank=True, max_length=1024)),
(
"fdsn_networks",
models.ManyToManyField(
blank=True, related_name="editors", to="book.FdsnNetwork"
),
),
(
"user",
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name="profile",
to=settings.AUTH_USER_MODEL,
),
),
],
),
migrations.CreateModel(
name="ExtAccessData",
fields=[
(
"extentitybase_ptr",
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to="book.ExtEntityBase",
),
),
("updated_at", models.DateTimeField(null=True)),
(
"description",
models.CharField(blank=True, default="Change", max_length=256),
),
],
options={"ordering": ["-updated_at"],},
bases=("book.extentitybase",),
),
migrations.CreateModel(
name="ExtBasicData",
fields=[
(
"extentitybase_ptr",
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to="book.ExtEntityBase",
),
),
(
"description",
models.TextField(blank=True, default="", max_length=16384),
),
("start", models.DateField(blank=True, null=True)),
("end", models.DateField(blank=True, null=True)),
(
"imported_from_fdsn",
models.DateTimeField(default=django.utils.timezone.now),
),
(
"last_synced",
models.DateTimeField(default=django.utils.timezone.now),
),
],
bases=("book.extentitybase",),
),
migrations.CreateModel(
name="ExtBoreholeData",
fields=[
(
"extentitybase_ptr",
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to="book.ExtEntityBase",
),
),
("depth", models.IntegerField(default=0)),
],
bases=("book.extentitybase",),
),
migrations.CreateModel(
name="ExtBoreholeLayerData",
fields=[
(
"extentitybase_ptr",
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to="book.ExtEntityBase",
),
),
(
"description",
models.CharField(blank=True, default="", max_length=256),
),
("depth_top", models.IntegerField(default=0)),
("depth_bottom", models.IntegerField(default=0)),
(
"borehole_data",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="borehole_layers",
to="book.ExtBoreholeData",
),
),
],
bases=("book.extentitybase",),
),
migrations.CreateModel(
name="ExtHousingData",
fields=[
(
"extentitybase_ptr",
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to="book.ExtEntityBase",
),
),
(
"description",
models.TextField(blank=True, default="", max_length=16384),
),
(
"housing_class",
models.CharField(
blank=True,
choices=[
("borehole", "Borehole"),
("bridge", "Bridge"),
("building", "Building"),
("cave", "Cave"),
("dam", "Dam"),
("free_field", "Free field"),
("other_structure", "Other structure"),
("tunnel", "Tunnel"),
("underground_shelter", "Underground shelter"),
("urban_free_field", "Urban free field"),
],
default="",
max_length=256,
),
),
("in_building", models.BooleanField(default=True)),
("numer_of_storeys", models.IntegerField(default=0)),
("distance_to_building", models.IntegerField(default=0)),
],
bases=("book.extentitybase",),
),
migrations.CreateModel(
name="ExtMorphologyData",
fields=[
(
"extentitybase_ptr",
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to="book.ExtEntityBase",
),
),
(
"description",
models.TextField(blank=True, default="", max_length=16384),
),
(
"geological_unit",
models.CharField(
blank=True,
choices=[
("unknown", "Unknown"),
("alluvial_deposits", "Alluvial deposits"),
("ancient_alluvialterraces", "Ancient alluvial terraces"),
("argillite", "Argillite"),
("breccias", "Breccias"),
("clay", "Clay"),
("conglomerate", "Conglomerate"),
("debris", "Debris"),
("diabase", "Diabase"),
("dolomite", "Dolomite"),
("fillade", "Fillade"),
("fluvial_deposits", "Fluvial deposits"),
("gneiss", "Gneiss"),
("granite", "Granite"),
("jasper", "Jasper"),
("lacustrine_deposits", "Lacustrine deposits"),
("limestone", "Limestone"),
("marls", "Marls"),
("metamorphic_rock", "Metamorphic rock"),
("micaschist", "Micaschist"),
("morainic_deposits", "Morainic deposits"),
("ophiolite", "Ophiolite"),
("rhyolitic_ignimbrite", "Rhyolitic ignimbrite"),
("sand_deposits", "Sand deposits"),
("sandstone", "Sandstone"),
("schist", "Schist"),
("torbidite", "Torbidite"),
("volcanic_deposits", "Volcanic deposits"),
("volcanic_rocks", "Volcanic rocks"),
],
default="",
max_length=256,
),
),
(
"morphology_class",
models.CharField(
blank=True,
choices=[
("unknown", "Unknown"),
("t1", "T1"),
("t2", "T2"),
("t3", "T3"),
("t4", "T4"),
],
default="",
max_length=256,
),
),
(
"ground_type_ec8",
models.CharField(
blank=True,
choices=[
("unknown", "Unknown"),
("a", "A"),
("b", "B"),
("c", "C"),
("d", "D"),
("e", "E"),
("s1", "S1"),
("s2", "S2"),
],
default="",
max_length=256,
),
),
("groundwater_depth", models.IntegerField(default=0)),
("vs_30", models.IntegerField(default=0)),
("f0", models.IntegerField(default=0)),
("amp_f0", models.IntegerField(default=0)),
("basin_flag", models.BooleanField(default=False)),
("bedrock_depth", models.IntegerField(default=0)),
],
bases=("book.extentitybase",),
),
migrations.CreateModel(
name="ExtOwnerData",
fields=[
(
"extentitybase_ptr",
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to="book.ExtEntityBase",
),
),
(
"name_first",
models.CharField(blank=True, default="n/a", max_length=256),
),
(
"name_last",
models.CharField(blank=True, default="n/a", max_length=256),
),
(
"department",
models.CharField(blank=True, default="n/a", max_length=256),
),
("agency", models.CharField(blank=True, default="n/a", max_length=256)),
("city", models.CharField(blank=True, default="n/a", max_length=256)),
("street", models.CharField(blank=True, default="n/a", max_length=256)),
(
"country",
models.CharField(blank=True, default="n/a", max_length=256),
),
("phone", models.CharField(blank=True, default="n/a", max_length=256)),
("email", models.CharField(blank=True, default="n/a", max_length=256)),
],
bases=("book.extentitybase",),
),
migrations.CreateModel(
name="Photo",
fields=[
(
"extentitybase_ptr",
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to="book.ExtEntityBase",
),
),
("description", models.CharField(blank=True, max_length=1024)),
(
"image",
models.ImageField(upload_to=book.models.Photo.path_file_name),
),
("uploaded_at", models.DateTimeField(auto_now_add=True)),
(
"fdsn_station",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="photos",
to="book.FdsnStation",
),
),
],
options={"ordering": ["uploaded_at"],},
bases=("book.extentitybase",),
),
migrations.AddField(
model_name="fdsnnetwork",
name="fdsn_node",
field=models.ForeignKey(
default=None,
on_delete=django.db.models.deletion.CASCADE,
related_name="fdsn_networks",
to="book.FdsnNode",
),
),
migrations.AddField(
model_name="fdsnstation",
name="ext_basic_data",
field=models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="station",
to="book.ExtBasicData",
),
),
migrations.AddField(
model_name="fdsnstation",
name="ext_borehole_data",
field=models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="station",
to="book.ExtBoreholeData",
),
),
migrations.AddField(
model_name="fdsnstation",
name="ext_housing_data",
field=models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="station",
to="book.ExtHousingData",
),
),
migrations.AddField(
model_name="fdsnstation",
name="ext_morphology_data",
field=models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="station",
to="book.ExtMorphologyData",
),
),
migrations.AddField(
model_name="fdsnstation",
name="ext_owner_data",
field=models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="station",
to="book.ExtOwnerData",
),
),
migrations.AlterUniqueTogether(
name="fdsnnetwork", unique_together={("fdsn_node", "code", "start_date")},
),
migrations.AddField(
model_name="extaccessdata",
name="fdsn_station",
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="access_data",
to="book.FdsnStation",
),
),
migrations.AddField(
model_name="extaccessdata",
name="updated_by",
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="+",
to=settings.AUTH_USER_MODEL,
),
),
migrations.AlterUniqueTogether(
name="fdsnstation",
unique_together={("fdsn_network", "code", "start_date")},
),
]