class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
CITextExtension(),
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')),
('email', django.contrib.postgres.fields.citext.CIEmailField(max_length=60, unique=True, verbose_name='email')),
('first_name', models.CharField(blank=True, max_length=64, null=True)),
('last_name', models.CharField(blank=True, max_length=64, null=True)),
('date_joined', models.DateTimeField(auto_now_add=True, verbose_name='date joined')),
('last_login', models.DateTimeField(auto_now=True, verbose_name='last login')),
('is_active', models.BooleanField(default=True)),
('is_staff', models.BooleanField(default=False)),
('is_superuser', models.BooleanField(default=False)),
('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={
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
dependencies = [
("core", "0007_ltree"),
]
operations = [CITextExtension()]
class Migration(migrations.Migration):
initial = True
dependencies = [
('localization', '0002_country'),
]
operations = [
CITextExtension(),
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)),
('email', models.EmailField(max_length=254, unique=True)),
('first_name', models.CharField(blank=True, max_length=30)),
('last_name', models.CharField(blank=True, max_length=30)),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now)),
('username', django.contrib.postgres.fields.citext.CICharField(blank=True, error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 30 characters or fewer. Letters, digits and ./_ only.', max_length=30, null=True, unique=True, validators=[django.core.validators.RegexValidator(code='invalid', message='Enter a valid username. This value may contain at most one consecutive separator( . or _ characters).', regex='^((?![_.]{2,}).)*$'), django.core.validators.RegexValidator(code='invalid', message='Enter a valid username. This value may contain only letters,numbers and separators ( . or _ characters).', regex='^[\\w.]+$'), django.core.validators.RegexValidator(code='invalid', message='Enter a valid username. This value may not start with a separator ( . or _ characters).', regex='^[^._]'), django.core.validators.RegexValidator(code='invalid', message='Enter a valid username. This value may not end with a separator ( . or _ characters).', regex='[^._]$')])),
('locale_language', models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='localization.Language')),
],
options={
'abstract': False,
},
managers=[
('objects', dbribeapp.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('internationalization', '0001_initial'),
('companies', '0002_auto_20191216_2143'),
]
operations = [
CITextExtension(),
migrations.AlterField(
model_name='company',
name='name',
field=django.contrib.postgres.fields.citext.CICharField(
max_length=120, unique=True),
),
migrations.AlterField(
model_name='headquarter',
name='name',
field=django.contrib.postgres.fields.citext.CICharField(
max_length=120),
),
migrations.AlterUniqueTogether(
name='headquarter',
unique_together={('name', 'company'), ('name', 'city')},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
CITextExtension(),
migrations.CreateModel(
name="ImagingModality",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"modality",
django.contrib.postgres.fields.citext.CICharField(
max_length=16, unique=True),
),
],
options={"ordering": ("modality", )},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
CITextExtension(),
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(blank=True, max_length=100, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=100, verbose_name='last name')),
('email', django.contrib.postgres.fields.citext.CIEmailField(blank=True, max_length=254, unique=True, verbose_name='email address')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('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', django.contrib.auth.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('core', '0042_auto_20200825_1051'),
]
operations = [CITextExtension()]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [CITextExtension()]
class Migration(migrations.Migration):
dependencies = [
('mission_control', '0016_auto_20190801_0117'),
]
operations = [
CITextExtension(),
migrations.CreateModel(
name='Tag',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', django.contrib.postgres.fields.citext.CICharField(max_length=30)),
],
),
migrations.AddField(
model_name='blockdiagram',
name='admin_tags',
field=models.ManyToManyField(blank=True, related_name='admin_block_diagrams', to='mission_control.Tag'),
),
migrations.AddField(
model_name='blockdiagram',
name='owner_tags',
field=models.ManyToManyField(blank=True, related_name='owner_block_diagrams', to='mission_control.Tag'),
),
]
class Migration(migrations.Migration):
dependencies = [
('accounts', '0001_initial'),
]
operations = [
CITextExtension(),
migrations.AlterField(
model_name='user',
name='email',
field=django.contrib.postgres.fields.citext.CIEmailField(max_length=254, unique=True, verbose_name='email address'),
),
migrations.AlterModelManagers(
name='user',
managers=[
('objects', accounts.managers.UserManager()),
],
),
migrations.RemoveField(
model_name='user',
name='username',
),
migrations.AddField(
model_name='user',
name='address',
field=models.TextField(blank=True, verbose_name='Work address'),
),
migrations.AddField(
model_name='user',
name='is_email_confirmed',
field=models.BooleanField(default=False),
),
migrations.AddField(
model_name='user',
name='phone',
field=models.CharField(blank=True, max_length=32),
),
migrations.AddField(
model_name='user',
name='photo',
field=sorl.thumbnail.fields.ImageField(blank=True, upload_to='uploads/accounts/images/%Y/%m/%d', verbose_name='Profile picture'),
),
migrations.AlterField(
model_name='user',
name='email',
field=django.contrib.postgres.fields.citext.CIEmailField(max_length=254, unique=True, verbose_name='email address'),
),
migrations.AlterField(
model_name='user',
name='first_name',
field=models.CharField(max_length=30, verbose_name='first name'),
),
migrations.AlterField(
model_name='user',
name='last_name',
field=models.CharField(max_length=30, verbose_name='last name'),
),
]
class Migration(migrations.Migration):
dependencies = [
('works', '0006_auto_20190915_1352'),
]
operations = [
CITextExtension(),
]
class Migration(migrations.Migration):
dependencies = [
('blacklist', '0003_create_new_custom_permission'),
]
operations = [
CITextExtension(),
]
class Migration(migrations.Migration):
"""ref1. https://docs.djangoproject.com/en/2.0/ref/contrib/postgres/operations/
`ref1` PostgreSQL extension 을 생성할 수 있다.
근데 선언하는 위치가 정확한지는 모르겠다.
"""
operations = [
HStoreExtension(),
CITextExtension()
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
CITextExtension(),
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(blank=True, max_length=150, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('created_at', models.DateTimeField(auto_now_add=True)),
('email', django.contrib.postgres.fields.citext.CIEmailField(max_length=255, unique=True)),
('slug', models.SlugField(max_length=32, unique=True)),
('username', django.contrib.postgres.fields.citext.CICharField(max_length=32, unique=True)),
('last_notification_read_time', models.DateTimeField(default=django.utils.timezone.now)),
('following', models.ManyToManyField(related_name='followers', to=settings.AUTH_USER_MODEL)),
('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',
'abstract': False,
},
managers=[
('objects', users.managers.UserManager()),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('banner', models.ImageField(blank=True, upload_to='images/%Y/%m/%d/')),
('bio', models.TextField(blank=True, max_length=500)),
('image', models.ImageField(blank=True, upload_to='images/%Y/%m/%d/')),
('location', models.CharField(blank=True, max_length=100)),
('notification_last_read_time', models.DateTimeField(auto_now_add=True)),
('website', models.URLField(blank=True)),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
operations = [
BtreeGinExtension(),
# Ensure CreateExtension quotes extension names by creating one with a
# dash in its name.
CreateExtension('uuid-ossp'),
HStoreExtension(),
TrigramExtension(),
UnaccentExtension(),
CITextExtension(),
]
class Migration(migrations.Migration):
dependencies = [
('island', '0002_island_created_by'),
]
operations = [
CITextExtension(),
migrations.AlterField(
model_name='island',
name='name',
field=django.contrib.postgres.fields.citext.CICharField(max_length=20, unique=True),
),
]
class Migration(migrations.Migration):
dependencies = [
('users', '0002_user_type'),
]
operations = [
CITextExtension(),
migrations.AlterField(
model_name='user',
name='email',
field=django.contrib.postgres.fields.citext.CIEmailField(max_length=511, unique=True, verbose_name='Email address'),
),
]
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):
dependencies = [
('flow', '0018_process_is_active'),
]
operations = [
CITextExtension(),
migrations.AlterField(
model_name='relation',
name='category',
field=django.contrib.postgres.fields.citext.CICharField(
max_length=100),
),
]
class Migration(migrations.Migration):
dependencies = [
('desecapi', '0006_cname_exclusivity'),
]
operations = [
CITextExtension(),
migrations.AlterField(
model_name='user',
name='email',
field=django.contrib.postgres.fields.citext.CIEmailField(
max_length=254, unique=True, verbose_name='email address'),
),
]
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):
dependencies = [("users", "0001_initial")]
operations = [
CITextExtension(),
migrations.AlterField(
model_name="user",
name="email",
field=django.contrib.postgres.fields.citext.CIEmailField(
db_index=True,
max_length=254,
unique=True,
verbose_name="email address"),
),
]
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 = [("services", "0009_sentryissue_sentryissuestats")]
operations = [
CITextExtension(),
migrations.AlterField(
model_name="service",
name="name",
field=django.contrib.postgres.fields.citext.CICharField(max_length=100),
),
migrations.AlterField(
model_name="service",
name="owner",
field=django.contrib.postgres.fields.citext.CICharField(max_length=100),
),
]
def _operations():
if CIEmailField:
yield CITextExtension()
yield migrations.AlterField(
model_name="emailuser",
name="email",
field=CIEmailField(db_index=True,
max_length=254,
unique=True,
verbose_name="email address"),
)
else:
yield migrations.RunSQL(
sql=("CREATE UNIQUE INDEX mailauth_user_emailuser_email_upper_idx"
' ON mailauth_user_emailuser (UPPER("email"));', ),
reverse_sql=(
"DROP INDEX mailauth_user_emailuser_email_upper_idx;", ),
)
class Migration(migrations.Migration):
dependencies = [
('marketplace', '0079_auto_20181010_1536'),
]
operations = [
CITextExtension(),
migrations.AlterField(
model_name='user',
name='email',
field=django.contrib.postgres.fields.citext.CIEmailField(
error_messages={
'unique': 'That email address is already in use.'
},
max_length=254,
unique=True,
verbose_name='email address'),
),
]
class Migration(migrations.Migration):
dependencies = [
('review', '0019_auto_20190207_2129'),
]
operations = [
CITextExtension(),
migrations.AlterField(
model_name='reviewer',
name='email',
field=django.contrib.postgres.fields.citext.CIEmailField(
error_messages={
'unique': 'A reviewer with that email already exists.'
},
max_length=254,
unique=True,
verbose_name='email address'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
CITextExtension(),
migrations.CreateModel(
name='CustomUser',
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')),
('email', django.contrib.postgres.fields.citext.CIEmailField(max_length=254, unique=True)),
('first_name', models.CharField(max_length=30)),
('last_name', models.CharField(max_length=30)),
('is_active', models.BooleanField(default=True, help_text='\n Designates whether this user account should be considered active.<br/>\n <strong>NOTE:</strong> Recommended that you set this flag to False instead of deleting accounts; \n that way, if any applications store foreign keys to users, the foreign keys won’t break.\n ')),
('is_staff', models.BooleanField(default=False, help_text='\n Designates whether this user can access the admin site.\n ')),
('date_joined', models.DateTimeField(auto_now_add=True, verbose_name='Date Joined (UTC)')),
('company_name', models.CharField(blank=True, max_length=50, verbose_name='Company')),
('business_phone', models.CharField(blank=True, max_length=30, verbose_name='Phone')),
('country_iso', models.CharField(choices=[('CAN', 'Canada'), ('USA', 'United States')], default='CAN', max_length=3, verbose_name='Country')),
('province_iso', models.CharField(choices=[('AB', 'Alberta'), ('BC', 'British Columbia'), ('MB', 'Manitoba'), ('NB', 'New Brunswick'), ('NL', 'Newfoundland and Labrador'), ('NS', 'Nova Scotia'), ('NT', 'Northwest Territories'), ('NU', 'Nunavut'), ('ON', 'Ontario'), ('PE', 'Prince Edward Island'), ('QC', 'Quebec'), ('SK', 'Saskatchewan'), ('YT', 'Yukon')], default='ON', max_length=2, verbose_name='Province')),
('city', models.CharField(blank=True, max_length=30)),
('address', models.CharField(blank=True, max_length=30)),
('postal_code', models.CharField(blank=True, max_length=30)),
('hst_number', models.CharField(blank=True, max_length=30, verbose_name='HST Number')),
('discount_ratio', models.DecimalField(decimal_places=2, default=0, help_text='\n Designates whether this user can access the admin site.\n ', max_digits=4, validators=[django.core.validators.MinValueValidator(0), django.core.validators.MaxValueValidator(1)], verbose_name='Discount')),
('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',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
CITextExtension(),
migrations.CreateModel(
name='Category',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('created', models.DateTimeField(auto_now_add=True)),
('modified', models.DateTimeField(auto_now=True)),
('name', django.contrib.postgres.fields.citext.CICharField(max_length=30, unique=True)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='FavoriteThing',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('created', models.DateTimeField(auto_now_add=True)),
('modified', models.DateTimeField(auto_now=True)),
('title', models.CharField(max_length=30)),
('description', models.TextField(blank=True, null=True)),
('ranking', models.IntegerField(null=True)),
('metadata', django.contrib.postgres.fields.jsonb.JSONField(blank=True, null=True)),
('category', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='favorite_things', to='api.Category')),
],
options={
'ordering': ('ranking',),
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
("auth", "0012_alter_user_first_name_max_length"),
]
operations = [
CITextExtension(),
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")),
(
"first_name",
models.CharField(blank=True,
max_length=100,
verbose_name="first name"),
),
(
"last_name",
models.CharField(blank=True,
max_length=100,
verbose_name="last name"),
),
(
"email",
django.contrib.postgres.fields.citext.CIEmailField(
db_index=True,
help_text="User's main email address",
max_length=254,
unique=True,
verbose_name="email",
),
),
(
"is_active",
models.BooleanField(default=True,
verbose_name="is active"),
),
("is_staff", models.BooleanField(default=False)),
("is_superuser", models.BooleanField(default=False)),
(
"last_login",
models.DateTimeField(default=django.utils.timezone.now,
verbose_name="last login"),
),
(
"date_joined",
models.DateTimeField(default=django.utils.timezone.now,
verbose_name="date joined"),
),
("groups", models.ManyToManyField(blank=True,
to="auth.Group")),
(
"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",
},
),
]