class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Member',
fields=[
('guid',
models.CharField(default=uuid.uuid4,
max_length=255,
primary_key=True,
serialize=False)),
('student_id', models.CharField(max_length=9)),
('avatar', models.URLField(blank=True)),
('year',
models.CharField(blank=True,
choices=[(73, 73), (74, 74), (75, 75),
(76, 76), (77, 77), (78, 78),
(79, 79), (80, 80), (81, 81),
(82, 82), (83, 83), (84, 84),
(85, 85), (86, 86), (87, 87),
(88, 88), (89, 89), (90, 90),
(91, 91), (92, 92), (93, 93),
(94, 94), (95, 95), (96, 96),
(97, 97), (98, 98), (99, 99),
(100, 100), (101, 101), (102, 102),
(103, 103), (104, 104), (105, 105),
(106, 106), (107, 107), (108, 108),
(109, 109)],
default=109,
max_length=3)),
('name', models.CharField(max_length=31)),
('foreign_name',
models.CharField(blank=True, max_length=31, null=True)),
('hobby', models.CharField(max_length=127)),
('expertise', models.CharField(max_length=127)),
('constellation', models.CharField(max_length=31)),
('link', models.URLField(blank=True)),
('email', models.EmailField(blank=True, max_length=254)),
('education',
models.CharField(choices=[('Master', 'Master'),
('Ph.D.', 'Ph.D.'),
('EMBA', 'EMBA'), ('EDBA', 'EDBA'),
('Professor', 'Professor')],
default='Master',
max_length=15)),
('is_graduated',
models.BooleanField(choices=[(True, True), (False, False)],
default=False)),
],
bases=(common.models.BaseSheet, models.Model),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
('media_upload', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Account',
fields=[
('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')),
('id', common.models.ULIDField(default=ulid.api.new, editable=False, max_length=26, primary_key=True, serialize=False, unique=True)),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('email', models.EmailField(error_messages={'unique': 'A user with that email already exists.'}, max_length=254, unique=True, verbose_name='email address')),
('display_name', models.CharField(blank=True, max_length=30, null=True, verbose_name='display name')),
('is_staff', models.BooleanField(default=False, verbose_name='staff status')),
('is_active', models.BooleanField(default=True, verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('balance', models.IntegerField(default=0, verbose_name='balance')),
('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')),
('icon', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='media_upload.Image', verbose_name='icon')),
('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',
},
),
migrations.CreateModel(
name='Idm',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('idm', models.CharField(error_messages={'unique': 'This card is already registered'}, max_length=16, unique=True, verbose_name='IDm Number')),
('name', models.CharField(blank=True, max_length=255, null=True, verbose_name='card name')),
('account', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='account')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
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')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=30, 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')),
('email', models.EmailField(max_length=254, unique=True, verbose_name='email address')),
('birthday', models.DateField(blank=True, null=True)),
('country', models.CharField(blank=True, max_length=16)),
('city', models.CharField(blank=True, max_length=16)),
('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',
'abstract': False,
'verbose_name_plural': 'users',
},
managers=[
('objects', common.models.CustomUserManager()),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [("auth", "0011_update_proxy_permissions")]
operations = [
migrations.CreateModel(
name="User",
fields=[
(
"id",
models.UUIDField(
default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False,
),
),
(
"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", models.EmailField(max_length=255, unique=True)),
(
"name",
models.CharField(blank=True, max_length=255, null=True),
),
("is_active", models.BooleanField(default=True)),
("is_staff", models.BooleanField(default=False)),
("date_joined", models.DateTimeField(auto_now_add=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={"abstract": False},
bases=(common.models.UUIDMixin, models.Model),
)
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('accounts', '0001_initial'),
('cases', '0001_initial'),
]
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')),
('username', models.CharField(max_length=100, unique=True)),
('first_name', models.CharField(blank=True, max_length=150)),
('last_name', models.CharField(blank=True, max_length=150)),
('email', models.EmailField(max_length=255, unique=True)),
('is_active', models.BooleanField(default=True)),
('is_admin', models.BooleanField(default=False)),
('is_staff', models.BooleanField(default=False)),
('date_joined',
models.DateTimeField(auto_now_add=True,
verbose_name='date joined')),
('role',
models.CharField(choices=[('ADMIN', 'ADMIN'),
('USER', 'USER'),
('SALES', 'SALES'),
('MANAGER', 'MANAGER'),
('SALES MANAGER', 'SALES MANAGER')],
max_length=50)),
('profile_pic',
models.FileField(blank=True,
max_length=1000,
null=True,
upload_to=common.models.img_url)),
('has_sales_access', models.BooleanField(default=False)),
('has_marketing_access', models.BooleanField(default=False)),
],
options={
'ordering': ['-is_active'],
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Address',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('address_line',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='Address')),
('street',
models.CharField(blank=True,
max_length=55,
null=True,
verbose_name='Street')),
('city',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='City')),
('state',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='State')),
('postcode',
models.CharField(blank=True,
max_length=64,
null=True,
verbose_name='Post/Zip-code')),
('country',
models.CharField(
blank=True,
choices=[('GB', 'United Kingdom'), ('AF', 'Afghanistan'),
('AX', 'Aland Islands'), ('AL', 'Albania'),
('DZ', 'Algeria'), ('AS', 'American Samoa'),
('AD', 'Andorra'), ('AO', 'Angola'),
('AI', 'Anguilla'), ('AQ', 'Antarctica'),
('AG', 'Antigua and Barbuda'),
('AR', 'Argentina'), ('AM', 'Armenia'),
('AW', 'Aruba'), ('AU', 'Australia'),
('AT', 'Austria'), ('AZ', 'Azerbaijan'),
('BS', 'Bahamas'), ('BH', 'Bahrain'),
('BD', 'Bangladesh'), ('BB', 'Barbados'),
('BY', 'Belarus'), ('BE', 'Belgium'),
('BZ', 'Belize'), ('BJ', 'Benin'),
('BM', 'Bermuda'), ('BT', 'Bhutan'),
('BO', 'Bolivia'),
('BA', 'Bosnia and Herzegovina'),
('BW', 'Botswana'), ('BV', 'Bouvet Island'),
('BR', 'Brazil'),
('IO', 'British Indian Ocean Territory'),
('BN', 'Brunei Darussalam'), ('BG', 'Bulgaria'),
('BF', 'Burkina Faso'), ('BI', 'Burundi'),
('KH', 'Cambodia'), ('CM', 'Cameroon'),
('CA', 'Canada'), ('CV', 'Cape Verde'),
('KY', 'Cayman Islands'),
('CF', 'Central African Republic'),
('TD', 'Chad'), ('CL', 'Chile'), ('CN', 'China'),
('CX', 'Christmas Island'),
('CC', 'Cocos (Keeling) Islands'),
('CO', 'Colombia'), ('KM', 'Comoros'),
('CG', 'Congo'),
('CD', 'Congo, The Democratic Republic of the'),
('CK', 'Cook Islands'), ('CR', 'Costa Rica'),
('CI', "Cote d'Ivoire"), ('HR', 'Croatia'),
('CU', 'Cuba'), ('CY', 'Cyprus'),
('CZ', 'Czech Republic'), ('DK', 'Denmark'),
('DJ', 'Djibouti'), ('DM', 'Dominica'),
('DO', 'Dominican Republic'), ('EC', 'Ecuador'),
('EG', 'Egypt'), ('SV', 'El Salvador'),
('GQ', 'Equatorial Guinea'), ('ER', 'Eritrea'),
('EE', 'Estonia'), ('ET', 'Ethiopia'),
('FK', 'Falkland Islands (Malvinas)'),
('FO', 'Faroe Islands'), ('FJ', 'Fiji'),
('FI', 'Finland'), ('FR', 'France'),
('GF', 'French Guiana'),
('PF', 'French Polynesia'),
('TF', 'French Southern Territories'),
('GA', 'Gabon'), ('GM', 'Gambia'),
('GE', 'Georgia'), ('DE', 'Germany'),
('GH', 'Ghana'), ('GI', 'Gibraltar'),
('GR', 'Greece'), ('GL', 'Greenland'),
('GD', 'Grenada'), ('GP', 'Guadeloupe'),
('GU', 'Guam'), ('GT', 'Guatemala'),
('GG', 'Guernsey'), ('GN', 'Guinea'),
('GW', 'Guinea-Bissau'), ('GY', 'Guyana'),
('HT', 'Haiti'),
('HM', 'Heard Island and McDonald Islands'),
('VA', 'Holy See (Vatican City State)'),
('HN', 'Honduras'), ('HK', 'Hong Kong'),
('HU', 'Hungary'), ('IS', 'Iceland'),
('IN', 'India'), ('ID', 'Indonesia'),
('IR', 'Iran, Islamic Republic of'),
('IQ', 'Iraq'), ('IE', 'Ireland'),
('IM', 'Isle of Man'), ('IL', 'Israel'),
('IT', 'Italy'), ('JM', 'Jamaica'),
('JP', 'Japan'), ('JE', 'Jersey'),
('JO', 'Jordan'), ('KZ', 'Kazakhstan'),
('KE', 'Kenya'), ('KI', 'Kiribati'),
('KP', "Korea, Democratic People's Republic of"),
('KR', 'Korea, Republic of'), ('KW', 'Kuwait'),
('KG', 'Kyrgyzstan'),
('LA', "Lao People's Democratic Republic"),
('LV', 'Latvia'), ('LB', 'Lebanon'),
('LS', 'Lesotho'), ('LR', 'Liberia'),
('LY', 'Libyan Arab Jamahiriya'),
('LI', 'Liechtenstein'), ('LT', 'Lithuania'),
('LU', 'Luxembourg'), ('MO', 'Macao'),
('MK',
'Macedonia, The Former Yugoslav Republic of'),
('MG', 'Madagascar'), ('MW', 'Malawi'),
('MY', 'Malaysia'), ('MV', 'Maldives'),
('ML', 'Mali'), ('MT', 'Malta'),
('MH', 'Marshall Islands'), ('MQ', 'Martinique'),
('MR', 'Mauritania'), ('MU', 'Mauritius'),
('YT', 'Mayotte'), ('MX', 'Mexico'),
('FM', 'Micronesia, Federated States of'),
('MD', 'Moldova'), ('MC', 'Monaco'),
('MN', 'Mongolia'), ('ME', 'Montenegro'),
('MS', 'Montserrat'), ('MA', 'Morocco'),
('MZ', 'Mozambique'), ('MM', 'Myanmar'),
('NA', 'Namibia'), ('NR', 'Nauru'),
('NP', 'Nepal'), ('NL', 'Netherlands'),
('AN', 'Netherlands Antilles'),
('NC', 'New Caledonia'), ('NZ', 'New Zealand'),
('NI', 'Nicaragua'), ('NE', 'Niger'),
('NG', 'Nigeria'), ('NU', 'Niue'),
('NF', 'Norfolk Island'),
('MP', 'Northern Mariana Islands'),
('NO', 'Norway'), ('OM', 'Oman'),
('PK', 'Pakistan'), ('PW', 'Palau'),
('PS', 'Palestinian Territory, Occupied'),
('PA', 'Panama'), ('PG', 'Papua New Guinea'),
('PY', 'Paraguay'), ('PE', 'Peru'),
('PH', 'Philippines'), ('PN', 'Pitcairn'),
('PL', 'Poland'), ('PT', 'Portugal'),
('PR', 'Puerto Rico'), ('QA', 'Qatar'),
('RE', 'Reunion'), ('RO', 'Romania'),
('RU', 'Russian Federation'), ('RW', 'Rwanda'),
('BL', 'Saint Barthelemy'),
('SH', 'Saint Helena'),
('KN', 'Saint Kitts and Nevis'),
('LC', 'Saint Lucia'), ('MF', 'Saint Martin'),
('PM', 'Saint Pierre and Miquelon'),
('VC', 'Saint Vincent and the Grenadines'),
('WS', 'Samoa'), ('SM', 'San Marino'),
('ST', 'Sao Tome and Principe'),
('SA', 'Saudi Arabia'), ('SN', 'Senegal'),
('RS', 'Serbia'), ('SC', 'Seychelles'),
('SL', 'Sierra Leone'), ('SG', 'Singapore'),
('SK', 'Slovakia'), ('SI', 'Slovenia'),
('SB', 'Solomon Islands'), ('SO', 'Somalia'),
('ZA', 'South Africa'),
('GS',
'South Georgia and the South Sandwich Islands'),
('ES', 'Spain'), ('LK', 'Sri Lanka'),
('SD', 'Sudan'), ('SR', 'Suriname'),
('SJ', 'Svalbard and Jan Mayen'),
('SZ', 'Swaziland'), ('SE', 'Sweden'),
('CH', 'Switzerland'),
('SY', 'Syrian Arab Republic'),
('TW', 'Taiwan, Province of China'),
('TJ', 'Tajikistan'),
('TZ', 'Tanzania, United Republic of'),
('TH', 'Thailand'), ('TL', 'Timor-Leste'),
('TG', 'Togo'), ('TK', 'Tokelau'),
('TO', 'Tonga'), ('TT', 'Trinidad and Tobago'),
('TN', 'Tunisia'), ('TR', 'Turkey'),
('TM', 'Turkmenistan'),
('TC', 'Turks and Caicos Islands'),
('TV', 'Tuvalu'), ('UG', 'Uganda'),
('UA', 'Ukraine'), ('AE',
'United Arab Emirates'),
('US', 'United States'),
('UM', 'United States Minor Outlying Islands'),
('UY', 'Uruguay'), ('UZ', 'Uzbekistan'),
('VU', 'Vanuatu'), ('VE', 'Venezuela'),
('VN', 'Viet Nam'),
('VG', 'Virgin Islands, British'),
('VI', 'Virgin Islands, U.S.'),
('WF', 'Wallis and Futuna'),
('EH', 'Western Sahara'), ('YE', 'Yemen'),
('ZM', 'Zambia'), ('ZW', 'Zimbabwe')],
max_length=3,
null=True)),
],
),
migrations.CreateModel(
name='APISettings',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=1000)),
('apikey', models.CharField(blank=True, max_length=16)),
('website', models.URLField(default='', max_length=255)),
('created_on', models.DateTimeField(auto_now_add=True)),
],
options={
'ordering': ('-created_on', ),
},
),
migrations.CreateModel(
name='Attachments',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('file_name', models.CharField(max_length=60)),
('created_on',
models.DateTimeField(auto_now_add=True,
verbose_name='Created on')),
('attachment',
models.FileField(max_length=1001,
upload_to='attachments/%Y/%m/')),
],
),
migrations.CreateModel(
name='Comment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('comment', models.CharField(max_length=255)),
('commented_on', models.DateTimeField(auto_now_add=True)),
('account',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='accounts_comments',
to='accounts.Account')),
('case',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='cases',
to='cases.Case')),
('commented_by',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('activation_key', models.CharField(max_length=50)),
('key_expires', models.DateTimeField()),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='profile',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Google',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('google_id', models.CharField(default='', max_length=200)),
('google_url', models.CharField(default='', max_length=1000)),
('verified_email', models.CharField(default='',
max_length=200)),
('family_name', models.CharField(default='', max_length=200)),
('name', models.CharField(default='', max_length=200)),
('gender', models.CharField(default='', max_length=10)),
('dob', models.CharField(default='', max_length=50)),
('given_name', models.CharField(default='', max_length=200)),
('email',
models.CharField(db_index=True, default='', max_length=200)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='google',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Document',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title',
models.CharField(blank=True, max_length=1000, null=True)),
('document_file',
models.FileField(max_length=5000,
upload_to=common.models.document_path)),
('created_on', models.DateTimeField(auto_now_add=True)),
('status',
models.CharField(choices=[('active', 'active'),
('inactive', 'inactive')],
default='active',
max_length=64)),
('created_by',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='document_uploaded',
to=settings.AUTH_USER_MODEL)),
('shared_to',
models.ManyToManyField(related_name='document_shared_to',
to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ('-created_on', ),
},
),
migrations.CreateModel(
name='Comment_Files',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('updated_on', models.DateTimeField(auto_now_add=True)),
('comment_file',
models.FileField(default='',
upload_to='comment_files',
verbose_name='File')),
('comment',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='common.Comment')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('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')),
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('email', models.EmailField(max_length=254, unique=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',
'abstract': False,
},
),
migrations.CreateModel(
name='UserAction',
fields=[
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('url', models.URLField(max_length=2083)),
('method', models.CharField(max_length=64)),
('url_name', models.CharField(max_length=256, null=True)),
('status_code', models.IntegerField()),
('user_agent', models.TextField(null=True)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='user_actions',
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('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')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
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')),
('id', models.BigAutoField(primary_key=True, serialize=False)),
('created',
models.DateTimeField(default=django.utils.timezone.now)),
('updated',
models.DateTimeField(default=django.utils.timezone.now)),
('enabled', 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={
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Application',
fields=[
('id', models.BigAutoField(primary_key=True, serialize=False)),
('created',
models.DateTimeField(default=django.utils.timezone.now)),
('updated',
models.DateTimeField(default=django.utils.timezone.now)),
('enabled', models.BooleanField(default=True)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Token',
fields=[
('id', models.BigAutoField(primary_key=True, serialize=False)),
('created',
models.DateTimeField(default=django.utils.timezone.now)),
('updated',
models.DateTimeField(default=django.utils.timezone.now)),
('enabled', models.BooleanField(default=True)),
('expires',
models.DateTimeField(default=common.models.get_expiration)),
('value', models.CharField(max_length=255)),
('application',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='common.Application')),
('owner',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
("accounts", "0001_initial"),
("cases", "0001_initial"),
]
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",
),
),
("username", models.CharField(max_length=100, unique=True)),
("first_name", models.CharField(blank=True, max_length=150)),
("last_name", models.CharField(blank=True, max_length=150)),
("email", models.EmailField(max_length=255, unique=True)),
("is_active", models.BooleanField(default=True)),
("is_admin", models.BooleanField(default=False)),
("is_staff", models.BooleanField(default=False)),
(
"date_joined",
models.DateTimeField(auto_now_add=True,
verbose_name="date joined"),
),
(
"role",
models.CharField(choices=[("ADMIN", "ADMIN"),
("USER", "USER")],
max_length=50),
),
(
"profile_pic",
models.FileField(
blank=True,
max_length=1000,
null=True,
upload_to=common.models.img_url,
),
),
],
options={
"abstract": False,
},
managers=[
("objects", django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name="Address",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"address_line",
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name="Address"),
),
(
"street",
models.CharField(blank=True,
max_length=55,
null=True,
verbose_name="Street"),
),
(
"city",
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name="City"),
),
(
"state",
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name="State"),
),
(
"postcode",
models.CharField(
blank=True,
max_length=64,
null=True,
verbose_name="Post/Zip-code",
),
),
(
"country",
models.CharField(
blank=True,
choices=[
("GB", "United Kingdom"),
("AF", "Afghanistan"),
("AX", "Aland Islands"),
("AL", "Albania"),
("DZ", "Algeria"),
("AS", "American Samoa"),
("AD", "Andorra"),
("AO", "Angola"),
("AI", "Anguilla"),
("AQ", "Antarctica"),
("AG", "Antigua and Barbuda"),
("AR", "Argentina"),
("AM", "Armenia"),
("AW", "Aruba"),
("AU", "Australia"),
("AT", "Austria"),
("AZ", "Azerbaijan"),
("BS", "Bahamas"),
("BH", "Bahrain"),
("BD", "Bangladesh"),
("BB", "Barbados"),
("BY", "Belarus"),
("BE", "Belgium"),
("BZ", "Belize"),
("BJ", "Benin"),
("BM", "Bermuda"),
("BT", "Bhutan"),
("BO", "Bolivia"),
("BA", "Bosnia and Herzegovina"),
("BW", "Botswana"),
("BV", "Bouvet Island"),
("BR", "Brazil"),
("IO", "British Indian Ocean Territory"),
("BN", "Brunei Darussalam"),
("BG", "Bulgaria"),
("BF", "Burkina Faso"),
("BI", "Burundi"),
("KH", "Cambodia"),
("CM", "Cameroon"),
("CA", "Canada"),
("CV", "Cape Verde"),
("KY", "Cayman Islands"),
("CF", "Central African Republic"),
("TD", "Chad"),
("CL", "Chile"),
("CN", "China"),
("CX", "Christmas Island"),
("CC", "Cocos (Keeling) Islands"),
("CO", "Colombia"),
("KM", "Comoros"),
("CG", "Congo"),
("CD", "Congo, The Democratic Republic of the"),
("CK", "Cook Islands"),
("CR", "Costa Rica"),
("CI", "Cote d'Ivoire"),
("HR", "Croatia"),
("CU", "Cuba"),
("CY", "Cyprus"),
("CZ", "Czech Republic"),
("DK", "Denmark"),
("DJ", "Djibouti"),
("DM", "Dominica"),
("DO", "Dominican Republic"),
("EC", "Ecuador"),
("EG", "Egypt"),
("SV", "El Salvador"),
("GQ", "Equatorial Guinea"),
("ER", "Eritrea"),
("EE", "Estonia"),
("ET", "Ethiopia"),
("FK", "Falkland Islands (Malvinas)"),
("FO", "Faroe Islands"),
("FJ", "Fiji"),
("FI", "Finland"),
("FR", "France"),
("GF", "French Guiana"),
("PF", "French Polynesia"),
("TF", "French Southern Territories"),
("GA", "Gabon"),
("GM", "Gambia"),
("GE", "Georgia"),
("DE", "Germany"),
("GH", "Ghana"),
("GI", "Gibraltar"),
("GR", "Greece"),
("GL", "Greenland"),
("GD", "Grenada"),
("GP", "Guadeloupe"),
("GU", "Guam"),
("GT", "Guatemala"),
("GG", "Guernsey"),
("GN", "Guinea"),
("GW", "Guinea-Bissau"),
("GY", "Guyana"),
("HT", "Haiti"),
("HM", "Heard Island and McDonald Islands"),
("VA", "Holy See (Vatican City State)"),
("HN", "Honduras"),
("HK", "Hong Kong"),
("HU", "Hungary"),
("IS", "Iceland"),
("IN", "India"),
("ID", "Indonesia"),
("IR", "Iran, Islamic Republic of"),
("IQ", "Iraq"),
("IE", "Ireland"),
("IM", "Isle of Man"),
("IL", "Israel"),
("IT", "Italy"),
("JM", "Jamaica"),
("JP", "Japan"),
("JE", "Jersey"),
("JO", "Jordan"),
("KZ", "Kazakhstan"),
("KE", "Kenya"),
("KI", "Kiribati"),
("KP", "Korea, Democratic People's Republic of"),
("KR", "Korea, Republic of"),
("KW", "Kuwait"),
("KG", "Kyrgyzstan"),
("LA", "Lao People's Democratic Republic"),
("LV", "Latvia"),
("LB", "Lebanon"),
("LS", "Lesotho"),
("LR", "Liberia"),
("LY", "Libyan Arab Jamahiriya"),
("LI", "Liechtenstein"),
("LT", "Lithuania"),
("LU", "Luxembourg"),
("MO", "Macao"),
("MK",
"Macedonia, The Former Yugoslav Republic of"),
("MG", "Madagascar"),
("MW", "Malawi"),
("MY", "Malaysia"),
("MV", "Maldives"),
("ML", "Mali"),
("MT", "Malta"),
("MH", "Marshall Islands"),
("MQ", "Martinique"),
("MR", "Mauritania"),
("MU", "Mauritius"),
("YT", "Mayotte"),
("MX", "Mexico"),
("FM", "Micronesia, Federated States of"),
("MD", "Moldova"),
("MC", "Monaco"),
("MN", "Mongolia"),
("ME", "Montenegro"),
("MS", "Montserrat"),
("MA", "Morocco"),
("MZ", "Mozambique"),
("MM", "Myanmar"),
("NA", "Namibia"),
("NR", "Nauru"),
("NP", "Nepal"),
("NL", "Netherlands"),
("AN", "Netherlands Antilles"),
("NC", "New Caledonia"),
("NZ", "New Zealand"),
("NI", "Nicaragua"),
("NE", "Niger"),
("NG", "Nigeria"),
("NU", "Niue"),
("NF", "Norfolk Island"),
("MP", "Northern Mariana Islands"),
("NO", "Norway"),
("OM", "Oman"),
("PK", "Pakistan"),
("PW", "Palau"),
("PS", "Palestinian Territory, Occupied"),
("PA", "Panama"),
("PG", "Papua New Guinea"),
("PY", "Paraguay"),
("PE", "Peru"),
("PH", "Philippines"),
("PN", "Pitcairn"),
("PL", "Poland"),
("PT", "Portugal"),
("PR", "Puerto Rico"),
("QA", "Qatar"),
("RE", "Reunion"),
("RO", "Romania"),
("RU", "Russian Federation"),
("RW", "Rwanda"),
("BL", "Saint Barthelemy"),
("SH", "Saint Helena"),
("KN", "Saint Kitts and Nevis"),
("LC", "Saint Lucia"),
("MF", "Saint Martin"),
("PM", "Saint Pierre and Miquelon"),
("VC", "Saint Vincent and the Grenadines"),
("WS", "Samoa"),
("SM", "San Marino"),
("ST", "Sao Tome and Principe"),
("SA", "Saudi Arabia"),
("SN", "Senegal"),
("RS", "Serbia"),
("SC", "Seychelles"),
("SL", "Sierra Leone"),
("SG", "Singapore"),
("SK", "Slovakia"),
("SI", "Slovenia"),
("SB", "Solomon Islands"),
("SO", "Somalia"),
("ZA", "South Africa"),
("GS",
"South Georgia and the South Sandwich Islands"),
("ES", "Spain"),
("LK", "Sri Lanka"),
("SD", "Sudan"),
("SR", "Suriname"),
("SJ", "Svalbard and Jan Mayen"),
("SZ", "Swaziland"),
("SE", "Sweden"),
("CH", "Switzerland"),
("SY", "Syrian Arab Republic"),
("TW", "Taiwan, Province of China"),
("TJ", "Tajikistan"),
("TZ", "Tanzania, United Republic of"),
("TH", "Thailand"),
("TL", "Timor-Leste"),
("TG", "Togo"),
("TK", "Tokelau"),
("TO", "Tonga"),
("TT", "Trinidad and Tobago"),
("TN", "Tunisia"),
("TR", "Turkey"),
("TM", "Turkmenistan"),
("TC", "Turks and Caicos Islands"),
("TV", "Tuvalu"),
("UG", "Uganda"),
("UA", "Ukraine"),
("AE", "United Arab Emirates"),
("US", "United States"),
("UM", "United States Minor Outlying Islands"),
("UY", "Uruguay"),
("UZ", "Uzbekistan"),
("VU", "Vanuatu"),
("VE", "Venezuela"),
("VN", "Viet Nam"),
("VG", "Virgin Islands, British"),
("VI", "Virgin Islands, U.S."),
("WF", "Wallis and Futuna"),
("EH", "Western Sahara"),
("YE", "Yemen"),
("ZM", "Zambia"),
("ZW", "Zimbabwe"),
],
max_length=3,
null=True,
),
),
],
),
migrations.CreateModel(
name="Attachments",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("file_name", models.CharField(max_length=60)),
(
"created_on",
models.DateTimeField(auto_now_add=True,
verbose_name="Created on"),
),
(
"attachment",
models.FileField(max_length=1001,
upload_to="attachments/%Y/%m/"),
),
],
),
migrations.CreateModel(
name="Comment",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("comment", models.CharField(max_length=255)),
("commented_on", models.DateTimeField(auto_now_add=True)),
(
"account",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="accounts_comments",
to="accounts.Account",
),
),
(
"case",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="cases",
to="cases.Case",
),
),
(
"commented_by",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
),
),
],
),
migrations.CreateModel(
name="Comment_Files",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("updated_on", models.DateTimeField(auto_now_add=True)),
(
"comment_file",
models.FileField(default="",
upload_to="comment_files",
verbose_name="File"),
),
(
"comment",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="common.Comment"),
),
],
),
migrations.CreateModel(
name="Team",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("name", models.CharField(max_length=55)),
("members",
models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='Consumer',
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')),
('open_code',
models.CharField(default='admin',
help_text='如手机号、邮箱等',
max_length=128,
unique=True,
verbose_name='登录账号')),
('category',
models.CharField(choices=[('mangage', '管理角色'),
('maintain', '运维人员')],
default='maintain',
max_length=32,
verbose_name='账号类别')),
('name', models.CharField(max_length=128,
verbose_name='用户姓名')),
('mobile',
models.CharField(blank=True,
default='',
max_length=128,
null=True,
verbose_name='联系电话')),
('sex',
models.CharField(choices=[('male', '男'), ('female', '女'),
('other', '未知')],
default='other',
max_length=32,
verbose_name='性别')),
('email',
models.EmailField(blank=True,
max_length=255,
null=True,
unique=True,
verbose_name='邮箱')),
('avator',
models.CharField(blank=True,
max_length=128,
null=True,
verbose_name='用户头像')),
('is_delete',
models.BooleanField(default=False, verbose_name='是否删除')),
('status',
models.BooleanField(default=True, verbose_name='是否启用')),
('is_active',
models.BooleanField(default=True, verbose_name='是否激活')),
('is_staff',
models.BooleanField(default=False, verbose_name='工作人权限')),
('is_admin',
models.BooleanField(default=False, verbose_name='超级用户权限')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='创建日期')),
('read_fault',
models.TextField(blank=True,
default='[]',
null=True,
verbose_name='用户阅读故障数量')),
],
options={
'verbose_name_plural': '用户信息表',
},
),
migrations.CreateModel(
name='Deportment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('modified_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('name',
models.CharField(blank=True,
max_length=64,
null=True,
verbose_name='组织名称')),
('organization_type',
models.CharField(blank=True,
choices=[('admin', '管理'),
('maintain', '运维')],
max_length=18,
null=True,
verbose_name='组织类型')),
('belong_dept',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='dep_department_data',
to='accounts.Deportment',
verbose_name='数据权限部门')),
('create_by',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='dep_create_by_msg',
to=settings.AUTH_USER_MODEL,
verbose_name='创建人')),
('parent',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='department_children',
to='accounts.Deportment',
verbose_name='所属父级组织')),
('update_by',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='dep_update_by_msg',
to=settings.AUTH_USER_MODEL,
verbose_name='编辑人')),
],
options={
'verbose_name': '用户组织表',
'verbose_name_plural': '用户组织表',
},
bases=(models.Model, common.models.DictMixin),
),
migrations.CreateModel(
name='Role',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('code',
models.CharField(blank=True,
max_length=255,
null=True,
unique=True,
verbose_name='角色唯一CODE代码')),
('name', models.CharField(max_length=64, verbose_name='角色名称')),
('intro',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='角色介绍')),
('datas',
models.CharField(choices=[('全部', '全部'), ('同级及以下', '同级及以下'),
('本级及以下', '本级及以下'), ('本级', '本级'),
('仅本人', '仅本人')],
default='本级及以下',
max_length=50,
verbose_name='数据权限')),
('role_permission_list',
models.CharField(blank=True,
max_length=1024,
null=True,
verbose_name='角色权限信息')),
('status',
models.BooleanField(default=True, verbose_name='当前状态')),
('creator',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name='role_creator',
to=settings.AUTH_USER_MODEL,
verbose_name='创建人')),
('depts',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='accounts.Deportment',
verbose_name='所属组织')),
('modifier',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name='role_modifier',
to=settings.AUTH_USER_MODEL,
verbose_name='修改人')),
('parent',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name='children',
to='accounts.Role',
verbose_name='所属父级角色')),
],
options={
'verbose_name_plural': '角色表 ',
},
),
migrations.CreateModel(
name='RoleMenu',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('modified_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('content', models.TextField(verbose_name='角色菜单内容')),
],
options={
'verbose_name': '角色菜单表',
'verbose_name_plural': '角色菜单表',
},
bases=(models.Model, common.models.DictMixin),
),
migrations.CreateModel(
name='WechatUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('modified_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('nickname',
models.CharField(blank=True,
max_length=64,
null=True,
verbose_name='用户名称')),
('headimgurl',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='用户头像')),
('openid',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='用户openid')),
('unionid',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='用户unionid')),
('city',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='用户所在城市')),
('country',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='用户所在国家')),
('province',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='用户所在省份')),
('balance',
models.DecimalField(decimal_places=2,
default=0,
max_digits=7,
verbose_name='账户余额')),
('status',
models.BooleanField(default=True, verbose_name='用户当前状态')),
],
options={
'verbose_name_plural': '微信用户信息表',
},
bases=(models.Model, common.models.DictMixin),
),
migrations.CreateModel(
name='RoleButton',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('modified_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('name',
models.CharField(blank=True,
max_length=32,
null=True,
verbose_name='权限名称')),
('code',
models.CharField(blank=True,
max_length=32,
null=True,
verbose_name='code码')),
('describe',
models.CharField(blank=True,
max_length=256,
null=True,
verbose_name='描述')),
('belong_menu',
models.CharField(blank=True,
max_length=18,
null=True,
verbose_name='所属菜单')),
('status',
models.BooleanField(default=False, verbose_name='按钮状态')),
('role',
models.ManyToManyField(blank=True,
related_name='role_button',
to='accounts.Role',
verbose_name='所属角色')),
],
options={
'verbose_name': '角色按钮表',
'verbose_name_plural': '角色按钮表',
},
bases=(models.Model, common.models.DictMixin),
),
migrations.CreateModel(
name='Operational',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('create_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('modified_at',
models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('order',
models.CharField(blank=True,
max_length=32,
null=True,
verbose_name='工单编号')),
('operational_type',
models.CharField(choices=[('weixiugongdan', '维修工单'),
('chakangongdan', '巡检工单')],
max_length=32,
verbose_name='工单类型')),
('operational_state',
models.CharField(choices=[('urgency', '紧急'),
('common', '一般')],
max_length=32,
verbose_name='状态属性')),
('dispose_time',
models.DateTimeField(blank=True,
default=django.utils.timezone.now,
null=True,
verbose_name='处理时间')),
('status',
models.CharField(blank=True,
choices=[('not_send_order', '尚未派单'),
('send_order', '派单完成'),
('not_dispose', '未处理'),
('dispose', '处理')],
default='not_send_order',
max_length=16,
null=True,
verbose_name='处理状态')),
('cause',
models.TextField(blank=True, null=True, verbose_name='故障原因')),
('process',
models.CharField(blank=True,
max_length=128,
null=True,
verbose_name='处理过程')),
('resault',
models.CharField(blank=True,
max_length=128,
null=True,
verbose_name='处理结果')),
('creator',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='fault_submit_creator',
to=settings.AUTH_USER_MODEL,
verbose_name='维修人员')),
('send_user',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='send_user_fault',
to=settings.AUTH_USER_MODEL,
verbose_name='派单人员')),
],
options={
'verbose_name': '工单管理',
'verbose_name_plural': '工单管理',
},
bases=(models.Model, common.models.DictMixin),
),
migrations.AddField(
model_name='consumer',
name='dept',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='user_deps',
to='accounts.Deportment',
verbose_name='组织'),
),
migrations.AddField(
model_name='consumer',
name='groups',
field=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'),
),
migrations.AddField(
model_name='consumer',
name='role',
field=models.ManyToManyField(blank=True,
related_name='role_consumer',
to='accounts.Role',
verbose_name='用户角色'),
),
migrations.AddField(
model_name='consumer',
name='user_permissions',
field=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'),
),
migrations.AddField(
model_name='consumer',
name='wechat_user',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='wechat_consumer',
to='accounts.WechatUser',
verbose_name='微信用户信息'),
),
]
class Migration(migrations.Migration):
dependencies = [
('common', '0013_auto_20191107_1247'),
]
operations = [
migrations.AlterModelOptions(
name='category',
options={
'verbose_name': 'category',
'verbose_name_plural': 'categories'
},
),
migrations.AlterModelOptions(
name='issue',
options={
'verbose_name': 'issue',
'verbose_name_plural': 'issues'
},
),
migrations.AddField(
model_name='issue',
name='status',
field=models.IntegerField(
choices=[(1, 'SUBMITTED'), (2, 'WIP'), (3, 'SOLVED'),
(4, 'IMPOSSIBLE'), (5, 'DUBLICATE')],
default=common.models.StatusTypes(1),
help_text='Stage of progress for the solution.',
verbose_name='status'),
),
migrations.AlterField(
model_name='category',
name='name',
field=models.CharField(help_text='Short label of this category.',
max_length=50,
verbose_name='name'),
),
migrations.AlterField(
model_name='category',
name='parent',
field=mptt.fields.TreeForeignKey(
blank=True,
help_text='Parent category within the hierachy.',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='children',
to='common.Category',
verbose_name='parent'),
),
migrations.AlterField(
model_name='issue',
name='assigned',
field=models.ForeignKey(
help_text=
'Responsible (internal) department, which processes the issue currently.',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='assignedIssues',
to='auth.Group',
verbose_name='assigned group'),
),
migrations.AlterField(
model_name='issue',
name='authorEmail',
field=models.EmailField(help_text='eMail alias of the author.',
max_length=254,
null=True,
verbose_name='author'),
),
migrations.AlterField(
model_name='issue',
name='category',
field=mptt.fields.TreeForeignKey(
help_text=
'Multi-level selection of which kind of note this issue comes closest.',
on_delete=django.db.models.deletion.CASCADE,
to='common.Category',
verbose_name='category'),
),
migrations.AlterField(
model_name='issue',
name='created_at',
field=models.DateTimeField(default=django.utils.timezone.now,
help_text='Date of submission.',
verbose_name='creation date'),
),
migrations.AlterField(
model_name='issue',
name='delegated',
field=models.ForeignKey(
help_text=
'Responsible (external) organisation, which becomes involved in solving this issue.',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='delegatedIssues',
to='auth.Group',
verbose_name='delegated group'),
),
migrations.AlterField(
model_name='issue',
name='description',
field=models.TextField(
help_text='Notes describing further details.',
max_length=500,
verbose_name='description'),
),
migrations.AlterField(
model_name='issue',
name='id',
field=models.AutoField(primary_key=True,
serialize=False,
verbose_name='ID'),
),
migrations.AlterField(
model_name='issue',
name='landowner',
field=models.CharField(
help_text=
'Operrator that manages the area of the position. (usually landowner, might be inaccurate)',
max_length=250,
null=True,
verbose_name='landowner'),
),
migrations.AlterField(
model_name='issue',
name='location',
field=models.CharField(
help_text='Human readable description of the position.',
max_length=150,
null=True,
verbose_name='location'),
),
migrations.AlterField(
model_name='issue',
name='photo',
field=models.ImageField(
blank=True,
help_text=
'Photo that show the spot. (unprocessed, might include metadata)',
null=True,
upload_to='',
verbose_name='photo'),
),
migrations.AlterField(
model_name='issue',
name='position',
field=django.contrib.gis.db.models.fields.PointField(
help_text='Georeference for this issue. (might be inaccurate)',
srid=25833,
verbose_name='position'),
),
migrations.AlterField(
model_name='issue',
name='priority',
field=models.IntegerField(
choices=[(1, 'LOW'), (2, 'NORMAL'), (3, 'HIGH')],
default=common.models.PriorityTypes(2),
help_text='Importance of the note for responsibles.',
verbose_name='priority'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
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')),
('username', models.CharField(max_length=100, unique=True)),
('first_name', models.CharField(blank=True, max_length=150)),
('last_name', models.CharField(blank=True, max_length=150)),
('email', models.EmailField(max_length=255, unique=True)),
('is_active', models.BooleanField(default=True)),
('is_admin', models.BooleanField(default=False)),
('is_staff', models.BooleanField(default=False)),
('date_joined',
models.DateTimeField(auto_now_add=True,
verbose_name='date joined')),
('role',
models.CharField(choices=[('ADMIN', 'ADMIN'),
('CONSULTANT', 'CONSULTANT'),
('USER', 'USER')],
max_length=50)),
('profile_pic',
models.FileField(blank=True,
max_length=1000,
null=True,
upload_to=common.models.img_url)),
('has_sales_access', models.BooleanField(default=False)),
('has_marketing_access', models.BooleanField(default=False)),
],
options={
'ordering': ['-is_active'],
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Address',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('address_line',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='Address')),
('street',
models.CharField(blank=True,
max_length=55,
null=True,
verbose_name='Street')),
('city',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='City')),
('state',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='State')),
('postcode',
models.CharField(blank=True,
max_length=64,
null=True,
verbose_name='Post/Zip-code')),
('country',
models.CharField(blank=True,
choices=[('Botswana', 'Botswana')],
max_length=20,
null=True)),
],
),
migrations.CreateModel(
name='APISettings',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=1000)),
('apikey', models.CharField(blank=True, max_length=16)),
('website', models.URLField(default='', max_length=255)),
('created_on', models.DateTimeField(auto_now_add=True)),
],
options={
'ordering': ('-created_on', ),
},
),
migrations.CreateModel(
name='Attachments',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('file_name', models.CharField(max_length=60)),
('created_on',
models.DateTimeField(auto_now_add=True,
verbose_name='Created on')),
('attachment',
models.FileField(max_length=1001,
upload_to='attachments/%Y/%m/')),
],
),
migrations.CreateModel(
name='Comment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('comment', models.CharField(max_length=255)),
('commented_on', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Comment_Files',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('updated_on', models.DateTimeField(auto_now_add=True)),
('comment_file',
models.FileField(default='',
upload_to='comment_files',
verbose_name='File')),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('activation_key', models.CharField(max_length=50)),
('key_expires', models.DateTimeField()),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='profile',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Google',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('google_id', models.CharField(default='', max_length=200)),
('google_url', models.CharField(default='', max_length=1000)),
('verified_email', models.CharField(default='',
max_length=200)),
('family_name', models.CharField(default='', max_length=200)),
('name', models.CharField(default='', max_length=200)),
('gender', models.CharField(default='', max_length=10)),
('dob', models.CharField(default='', max_length=50)),
('given_name', models.CharField(default='', max_length=200)),
('email',
models.CharField(db_index=True, default='', max_length=200)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='google',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Document',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title',
models.CharField(blank=True, max_length=1000, null=True)),
('document_file',
models.FileField(max_length=5000,
upload_to=common.models.document_path)),
('created_on', models.DateTimeField(auto_now_add=True)),
('status',
models.CharField(choices=[('active', 'active'),
('inactive', 'inactive')],
default='active',
max_length=64)),
('created_by',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='document_uploaded',
to=settings.AUTH_USER_MODEL)),
('shared_to',
models.ManyToManyField(related_name='document_shared_to',
to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ('-created_on', ),
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('created',
django_extensions.db.fields.CreationDateTimeField(
auto_now_add=True, verbose_name='created')),
('modified',
django_extensions.db.fields.ModificationDateTimeField(
auto_now=True, verbose_name='modified')),
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('first_name',
models.CharField(max_length=64, verbose_name='first name')),
('last_name',
models.CharField(max_length=64, verbose_name='last name')),
('username',
models.CharField(max_length=255,
unique=True,
verbose_name='username')),
('email',
models.EmailField(blank=True,
max_length=255,
verbose_name='email address')),
('mobile',
models.CharField(blank=True,
max_length=255,
validators=[crm.validators.validate_mobile],
verbose_name='mobile')),
('user_type',
common.models.EnumField(choices=[
(crm.models.UserType('site_inactive'), 'site_inactive'),
(crm.models.UserType('site_superuser'), 'site_superuser'),
(crm.models.UserType('site_support'), 'site_support'),
(crm.models.UserType('organization_inactive'),
'organization_inactive'),
(crm.models.UserType('organization_administrator'),
'organization_administrator'),
(crm.models.UserType('organization_member'),
'organization_member')
],
max_length=64)),
('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')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Organization',
fields=[
('created',
django_extensions.db.fields.CreationDateTimeField(
auto_now_add=True, verbose_name='created')),
('modified',
django_extensions.db.fields.ModificationDateTimeField(
auto_now=True, verbose_name='modified')),
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('name', models.CharField(max_length=64)),
('slug',
django_extensions.db.fields.AutoSlugField(
blank=True, editable=False, populate_from=['name'])),
('use_email_id', models.BooleanField(default=True)),
],
options={
'ordering': ['created'],
'abstract': False,
},
),
migrations.AddField(
model_name='user',
name='organization',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='crm.Organization',
verbose_name='organization'),
),
migrations.AddField(
model_name='user',
name='user_permissions',
field=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'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name',
models.CharField(blank=True, max_length=50, null=True)),
('last_name',
models.CharField(blank=True, max_length=50, null=True)),
('email',
models.EmailField(blank=True, max_length=254, null=True)),
('avatar',
models.ImageField(
blank=True,
height_field='height_field',
null=True,
upload_to=common.models.profile_img_upload_location,
width_field='width_field')),
('height_field',
models.IntegerField(blank=True, default=0, null=True)),
('width_field',
models.IntegerField(blank=True, default=0, null=True)),
('language',
models.CharField(
blank=True,
choices=[('af', 'Afrikaans'), ('ar', 'Arabic'),
('ast', 'Asturian'), ('az', 'Azerbaijani'),
('bg', 'Bulgarian'), ('be', 'Belarusian'),
('bn', 'Bengali'), ('br', 'Breton'),
('bs', 'Bosnian'), ('ca', 'Catalan'),
('cs', 'Czech'), ('cy', 'Welsh'),
('da', 'Danish'), ('de', 'German'),
('el', 'Greek'), ('en', 'English'),
('en-au', 'Australian English'),
('en-gb', 'British English'),
('eo', 'Esperanto'), ('es', 'Spanish'),
('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'),
('et', 'Estonian'), ('eu', 'Basque'),
('fa', 'Persian'), ('fi', 'Finnish'),
('fr', 'French'), ('fy', 'Frisian'),
('ga', 'Irish'), ('gd', 'Scottish Gaelic'),
('gl', 'Galician'), ('he', 'Hebrew'),
('hi', 'Hindi'), ('hr', 'Croatian'),
('hu', 'Hungarian'), ('ia', 'Interlingua'),
('id', 'Indonesian'), ('io', 'Ido'),
('is', 'Icelandic'), ('it', 'Italian'),
('ja', 'Japanese'), ('ka', 'Georgian'),
('kk', 'Kazakh'), ('km', 'Khmer'),
('kn', 'Kannada'), ('ko', 'Korean'),
('lb', 'Luxembourgish'), ('lt', 'Lithuanian'),
('lv', 'Latvian'), ('mk', 'Macedonian'),
('ml', 'Malayalam'), ('mn', 'Mongolian'),
('mr', 'Marathi'), ('my', 'Burmese'),
('nb', 'Norwegian Bokmal'), ('ne', 'Nepali'),
('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'), ('pa', 'Punjabi'),
('pl', 'Polish'), ('pt', 'Portuguese'),
('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'), ('ru', 'Russian'),
('sk', 'Slovak'), ('sl', 'Slovenian'),
('sq', 'Albanian'), ('sr', 'Serbian'),
('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'),
('sw', 'Swahili'), ('ta', 'Tamil'),
('te', 'Telugu'), ('th', 'Thai'),
('tr', 'Turkish'), ('tt', 'Tatar'),
('udm', 'Udmurt'), ('uk', 'Ukrainian'),
('ur', 'Urdu'), ('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')],
default='ru',
max_length=10,
null=True)),
('phone', models.CharField(blank=True,
max_length=25,
null=True)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
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')),
('phone_number',
models.CharField(blank=True, max_length=30, null=True)),
('first_name', models.CharField(blank=True, max_length=130)),
('last_name', models.CharField(blank=True, max_length=130)),
('image',
models.ImageField(
blank=True,
help_text=
'The Aspect Ratio should be 1:1. Image will be cropped/resized otherwise',
null=True,
upload_to=common.models.AbstractContactModel.get_file_path
)),
('email',
models.EmailField(db_index=True,
max_length=254,
unique=True,
verbose_name='email address')),
('title',
models.CharField(blank=True, max_length=127, null=True)),
('is_staff',
models.BooleanField(
default=False,
help_text='May user log into this admin site?',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text='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={
'abstract': False,
},
),
]
