class Migration(migrations.Migration):
dependencies = [
('ascertain', '0002_auto_20201107_1929'),
]
operations = [
BtreeGistExtension(),
migrations.AlterField(
model_name='telephonenumbersmodel',
name='abc_or_def',
field=models.PositiveSmallIntegerField(verbose_name='АВС/DEF'),
),
migrations.AlterUniqueTogether(
name='telephonenumbersmodel',
unique_together=set(),
),
migrations.AddIndex(
model_name='telephonenumbersmodel',
index=django.contrib.postgres.indexes.GistIndex(
fields=['abc_or_def', 'numbers_range'],
fillfactor=100,
name='ascertain_t_abc_or__f3800c_gist'),
),
]
class Migration(migrations.Migration):
dependencies = [
('narrations', '0006_playlist_playlist_url'),
]
operations = [
BtreeGistExtension(),
TrigramExtension(),
migrations.AlterModelOptions(
name='narration',
options={'ordering': ['-id']},
),
migrations.AddField(
model_name='narration',
name='search_vector',
field=django.contrib.postgres.search.SearchVectorField(blank=True,
null=True),
),
migrations.AlterField(
model_name='narration',
name='featured_image',
field=models.ImageField(
blank=True,
max_length=255,
null=True,
upload_to=apps.narrations.models.customer_image_path,
verbose_name='Featured Image'),
),
migrations.AddIndex(
model_name='narration',
index=django.contrib.postgres.indexes.GinIndex(
fields=['search_vector'], name='title_index'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
BtreeGistExtension(),
migrations.CreateModel(
name='Room',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('floor', models.IntegerField()),
('no', models.IntegerField()),
],
options={
'unique_together': {('floor', 'no')},
},
),
migrations.CreateModel(
name='Booking',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('time', django.contrib.postgres.fields.ranges.DateRangeField()),
('room', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='booking.Room')),
],
),
migrations.AddConstraint(
model_name='booking',
constraint=django.contrib.postgres.constraints.ExclusionConstraint(expressions=[('time', '&&'), ('room', '=')], name='hotel_room_excl_constraint'),
),
]
class Migration(migrations.Migration):
dependencies = [
("program", "0084_auto_20200229_1801"),
]
operations = [
BtreeGistExtension(),
]
class Migration(migrations.Migration):
dependencies = [
('desecapi', '0005_subname_validation'),
]
operations = [
BtreeGistExtension(),
migrations.AddConstraint(
model_name='rrset',
constraint=django.contrib.postgres.constraints.ExclusionConstraint(expressions=[('domain', '='), ('subname', '='), (django.db.models.expressions.RawSQL("int4(type = 'CNAME')", ()), '<>')], name='cname_exclusivity'),
),
]
class Migration(migrations.Migration):
operations = [
BtreeGinExtension(),
BtreeGistExtension(),
CITextExtension(),
# Ensure CreateExtension quotes extension names by creating one with a
# dash in its name.
CreateExtension('uuid-ossp'),
CryptoExtension(),
HStoreExtension(),
TrigramExtension(),
UnaccentExtension(),
]
class Migration(migrations.Migration):
"""
This migration has been added a posteriori to the list of existing
migrations.
It isn't possible to add this migration at the end of the list because its
goal is to ensure the features provided by the extensions are already
installed before there are used by the other migrations (gist index, etc).
The 'users' app has been chosen as entry point because it's central
dependency on the application and its migrations are processed early in the
chain.
-- 2021-03-04 -- To remove in one month.
On startup (excepted from the WSGI callable or if disabled), Django checks the
consistency of the migrations in the database to ensure the graph of
dependencies has been applied in the same order than indicated in
django_migrations table. To make it happy, you can run this SQL query:
insert into django_migrations (app, name, applied)
select 'users', '0001bis_create_extensions', applied + interval '00:00:00.00001'
from django_migrations
where app = 'users' and name = '0001_initial';
Note: this query wouldn't be necessary if this migration had been merged with
users.0001_initial.
"""
dependencies = [("users", "0001_initial")]
operations = [
BtreeGistExtension(),
CITextExtension(),
TrigramExtension(),
CreateExtension("postgis"),
UnaccentExtension(),
migrations.RunSQL(
"DROP TEXT SEARCH CONFIGURATION IF EXISTS french_unaccent"),
migrations.RunSQL(
"CREATE TEXT SEARCH CONFIGURATION french_unaccent (COPY = french)"
),
migrations.RunSQL("""
ALTER TEXT SEARCH CONFIGURATION french_unaccent
ALTER MAPPING FOR hword, hword_part, word
WITH unaccent, french_stem
"""),
]
class Migration(migrations.Migration):
operations = [
BloomExtension(),
BtreeGinExtension(),
BtreeGistExtension(),
CITextExtension(),
# Ensure CreateExtension quotes extension names by creating one with a
# dash in its name.
CreateExtension("uuid-ossp"),
# CryptoExtension is required for RandomUUID() on PostgreSQL < 13.
CryptoExtension() if needs_crypto_extension else mock.Mock(),
HStoreExtension(),
TrigramExtension(),
UnaccentExtension(),
]
class Migration(migrations.Migration):
operations = [
(BloomExtension() if getattr(connection.features, 'has_bloom_index',
False) else mock.Mock()),
BtreeGinExtension(),
BtreeGistExtension(),
CITextExtension(),
# Ensure CreateExtension quotes extension names by creating one with a
# dash in its name.
CreateExtension('uuid-ossp'),
CryptoExtension(),
HStoreExtension(),
TrigramExtension(),
UnaccentExtension(),
]
class Migration(migrations.Migration):
dependencies = [
('terra', '0017_auto_20181114_0806'),
]
operations = [
BtreeGistExtension(),
migrations.AddIndex(
model_name='feature',
index=models.Index(fields=['identifier'],
name='terra_featu_identif_212b28_idx'),
),
migrations.AddIndex(
model_name='feature',
index=django.contrib.postgres.indexes.GistIndex(
fields=['layer', 'geom'],
name='terra_featu_layer_i_3dcdde_gist'),
),
]
class Migration(migrations.Migration):
dependencies = [
("retail_app", "0016_auto_20200928_1745"),
]
operations = [
migrations.AlterModelManagers(
name="product",
managers=[
("products_fully_loaded", django.db.models.manager.Manager()),
],
),
BtreeGistExtension(),
migrations.AddIndex(
model_name="searchproductkeywords",
index=django.contrib.postgres.indexes.GistIndex(
fields=["keywords"], name="retail_app__keyword_7fc412_gist"
),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
BtreeGistExtension(),
migrations.CreateModel(
name='Bike',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('model_name', models.CharField(max_length=128)),
('reserved', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='BikeStations',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('street_name', models.CharField(max_length=128)),
],
),
migrations.CreateModel(
name='CarParking',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('number', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Rating',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('rate', models.IntegerField(choices=[(1, '1'), (2, '2'), (3, '3'), (4, '4'), (5, '5')])),
('comments', models.TextField()),
('date_created', models.DateTimeField(default=django.utils.datetime_safe.datetime.now)),
('bike', models.ManyToManyField(to='transport.Bike')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='CarParkingReservation',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('dates_range', django.contrib.postgres.fields.ranges.DateTimeRangeField()),
('disabled_space', models.BooleanField(default=False)),
('date_created', models.DateTimeField(default=django.utils.datetime_safe.datetime.now)),
('place', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='transport.carparking')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='BikeReservation',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('bike', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='transport.bike')),
('start_point', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='transport.bikestations')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='bike',
name='station',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='transport.bikestations'),
),
migrations.AddConstraint(
model_name='carparkingreservation',
constraint=django.contrib.postgres.constraints.ExclusionConstraint(expressions=[('dates_range', '&&'), ('place', '=')], name='exclude_overlapping_reservations'),
),
]
class Migration(migrations.Migration):
dependencies = [migrations.swappable_dependency(settings.AUTH_USER_MODEL)]
operations = [
BtreeGistExtension(),
CreateExtension("postgis"),
migrations.CreateModel(
name="Camp",
fields=[
("created", models.DateTimeField(auto_now_add=True)),
("updated", models.DateTimeField(auto_now=True)),
(
"uuid",
models.UUIDField(
default=uuid.uuid4,
serialize=False,
editable=False,
primary_key=True,
),
),
(
"name",
models.CharField(
max_length=255,
help_text="Name of the camp, ie. Bornhack.",
verbose_name="Name",
),
),
(
"start",
models.DateTimeField(
help_text="When the camp starts.",
unique=True,
verbose_name="Start date",
),
),
(
"end",
models.DateTimeField(
help_text="When the camp ends.",
unique=True,
verbose_name="End date",
),
),
],
options={
"verbose_name_plural": "Camps",
"verbose_name": "Camp"
},
),
migrations.CreateModel(
name="Day",
fields=[
("created", models.DateTimeField(auto_now_add=True)),
("updated", models.DateTimeField(auto_now=True)),
(
"uuid",
models.UUIDField(
default=uuid.uuid4,
serialize=False,
editable=False,
primary_key=True,
),
),
("date",
models.DateField(help_text="What date?",
verbose_name="Date")),
(
"camp",
models.ForeignKey(
on_delete=models.PROTECT,
to="camps.Camp",
help_text="Which camp does this day belong to.",
verbose_name="Camp",
),
),
],
options={
"verbose_name_plural": "Days",
"verbose_name": "Day"
},
),
migrations.CreateModel(
name="Expense",
fields=[
("created", models.DateTimeField(auto_now_add=True)),
("updated", models.DateTimeField(auto_now=True)),
(
"uuid",
models.UUIDField(
default=uuid.uuid4,
serialize=False,
editable=False,
primary_key=True,
),
),
(
"description",
models.CharField(
max_length=255,
help_text="What this expense covers.",
verbose_name="Description",
),
),
(
"amount",
models.DecimalField(
max_digits=7,
help_text="The amount of the expense.",
verbose_name="Amount",
decimal_places=2,
),
),
(
"currency",
models.CharField(
max_length=3,
choices=[
("btc", "BTC"),
("dkk", "DKK"),
("eur", "EUR"),
("sek", "SEK"),
],
help_text="What currency the amount is in.",
verbose_name="Currency",
),
),
(
"camp",
models.ForeignKey(
on_delete=models.PROTECT,
to="camps.Camp",
help_text="The camp to which this expense relates to.",
verbose_name="Camp",
),
),
(
"covered_by",
models.ForeignKey(
on_delete=models.PROTECT,
to=settings.AUTH_USER_MODEL,
blank=True,
help_text="Which user, if any, covered this expense.",
verbose_name="Covered by",
null=True,
),
),
],
options={
"verbose_name_plural": "Expenses",
"verbose_name": "Expense"
},
),
migrations.CreateModel(
name="Signup",
fields=[
("created", models.DateTimeField(auto_now_add=True)),
("updated", models.DateTimeField(auto_now=True)),
(
"uuid",
models.UUIDField(
default=uuid.uuid4,
serialize=False,
editable=False,
primary_key=True,
),
),
(
"cost",
models.DecimalField(
default=1500.0,
decimal_places=2,
help_text=
"What the user should/is willing to pay for this signup.",
verbose_name="Cost",
max_digits=7,
),
),
(
"paid",
models.BooleanField(
help_text="Whether the user has paid.",
verbose_name="Paid?",
default=False,
),
),
(
"camp",
models.ForeignKey(
on_delete=models.PROTECT,
to="camps.Camp",
help_text="The camp that has been signed up for.",
verbose_name="Camp",
),
),
(
"user",
models.ForeignKey(
on_delete=models.PROTECT,
to=settings.AUTH_USER_MODEL,
help_text="The user that has signed up.",
verbose_name="User",
),
),
],
options={
"verbose_name_plural": "Signups",
"verbose_name": "Signup"
},
),
]
