class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0015_auto_20200516_0635'),
]
operations = [
migrations.CreateModel(
name='Membresia',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nombre', models.CharField(max_length=10)),
('limitePerfiles', models.PositiveSmallIntegerField()),
('limiteSesionesActivas', models.PositiveSmallIntegerField()),
('precio', models.DecimalField(decimal_places=2, max_digits=10)),
],
),
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')),
('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),
('username', models.EmailField(error_messages={'unique': 'Ya existe un usuario registrado con ese email. Por favor, ingrese uno diferente.'}, help_text='Ingrese un email', max_length=150, unique=True, verbose_name='email address')),
('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')),
('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')),
('credit_Card', creditcards.models.CardNumberField(max_length=25, null=True, unique=True, verbose_name='Número de tarjeta')),
('expired_Card', creditcards.models.CardExpiryField(null=True, verbose_name='Fecha de vencimiento')),
('secCode_Card', creditcards.models.SecurityCodeField(max_length=4, null=True, verbose_name='Código de seguridad')),
('tipo_tarjeta', models.CharField(max_length=60, null=True, verbose_name='Tipo de tarjeta')),
('titular', models.CharField(max_length=60, null=True, verbose_name='Nombre del titular de la tarjeta')),
('dni', models.IntegerField(null=True, verbose_name='DNI del titular de la tarjeta')),
('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')),
('subscription', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='users.Membresia')),
('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', django.contrib.auth.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='PaymentMode',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('name', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='PaymentStatus',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('name', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='PaymentOption',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('name', models.CharField(max_length=255)),
('cc_number', creditcards.models.CardNumberField(max_length=25, verbose_name='card number')),
('cc_expiry', creditcards.models.CardExpiryField(verbose_name='expiration date')),
('cc_code', creditcards.models.SecurityCodeField(max_length=4, verbose_name='security code')),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now_add=True)),
('insertedby', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Payment',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('payment_mode_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='payments.PaymentMode')),
('payment_option_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='payments.PaymentOption')),
('payment_status_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='payments.PaymentStatus')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Available_Slots',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('date', models.DateField()),
('created_at', models.DateTimeField(auto_now=True)),
('updated_at', models.DateTimeField(auto_now_add=True)),
('active', models.BooleanField(default=True)),
],
),
migrations.CreateModel(
name='BookSeat',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('booking_price_currency', djmoney.models.fields.CurrencyField(choices=[('XUA', 'ADB Unit of Account'), ('AFN', 'Afghani'), ('DZD', 'Algerian Dinar'), ('ARS', 'Argentine Peso'), ('AMD', 'Armenian Dram'), ('AWG', 'Aruban Guilder'), ('AUD', 'Australian Dollar'), ('AZN', 'Azerbaijanian Manat'), ('BSD', 'Bahamian Dollar'), ('BHD', 'Bahraini Dinar'), ('THB', 'Baht'), ('PAB', 'Balboa'), ('BBD', 'Barbados Dollar'), ('BYN', 'Belarussian Ruble'), ('BYR', 'Belarussian Ruble'), ('BZD', 'Belize Dollar'), ('BMD', 'Bermudian Dollar (customarily known as Bermuda Dollar)'), ('BTN', 'Bhutanese ngultrum'), ('VEF', 'Bolivar Fuerte'), ('BOB', 'Boliviano'), ('XBA', 'Bond Markets Units European Composite Unit (EURCO)'), ('BRL', 'Brazilian Real'), ('BND', 'Brunei Dollar'), ('BGN', 'Bulgarian Lev'), ('BIF', 'Burundi Franc'), ('XOF', 'CFA Franc BCEAO'), ('XAF', 'CFA franc BEAC'), ('XPF', 'CFP Franc'), ('CAD', 'Canadian Dollar'), ('CVE', 'Cape Verde Escudo'), ('KYD', 'Cayman Islands Dollar'), ('CLP', 'Chilean peso'), ('XTS', 'Codes specifically reserved for testing purposes'), ('COP', 'Colombian peso'), ('KMF', 'Comoro Franc'), ('CDF', 'Congolese franc'), ('BAM', 'Convertible Marks'), ('NIO', 'Cordoba Oro'), ('CRC', 'Costa Rican Colon'), ('HRK', 'Croatian Kuna'), ('CUP', 'Cuban Peso'), ('CUC', 'Cuban convertible peso'), ('CZK', 'Czech Koruna'), ('GMD', 'Dalasi'), ('DKK', 'Danish Krone'), ('MKD', 'Denar'), ('DJF', 'Djibouti Franc'), ('STD', 'Dobra'), ('DOP', 'Dominican Peso'), ('VND', 'Dong'), ('XCD', 'East Caribbean Dollar'), ('EGP', 'Egyptian Pound'), ('SVC', 'El Salvador Colon'), ('ETB', 'Ethiopian Birr'), ('EUR', 'Euro'), ('XBB', 'European Monetary Unit (E.M.U.-6)'), ('XBD', 'European Unit of Account 17(E.U.A.-17)'), ('XBC', 'European Unit of Account 9(E.U.A.-9)'), ('FKP', 'Falkland Islands Pound'), ('FJD', 'Fiji Dollar'), ('HUF', 'Forint'), ('GHS', 'Ghana Cedi'), ('GIP', 'Gibraltar Pound'), ('XAU', 'Gold'), ('XFO', 'Gold-Franc'), ('PYG', 'Guarani'), ('GNF', 'Guinea Franc'), ('GYD', 'Guyana Dollar'), ('HTG', 'Haitian gourde'), ('HKD', 'Hong Kong Dollar'), ('UAH', 'Hryvnia'), ('ISK', 'Iceland Krona'), ('INR', 'Indian Rupee'), ('IRR', 'Iranian Rial'), ('IQD', 'Iraqi Dinar'), ('IMP', 'Isle of Man Pound'), ('JMD', 'Jamaican Dollar'), ('JOD', 'Jordanian Dinar'), ('KES', 'Kenyan Shilling'), ('PGK', 'Kina'), ('LAK', 'Kip'), ('KWD', 'Kuwaiti Dinar'), ('AOA', 'Kwanza'), ('MMK', 'Kyat'), ('GEL', 'Lari'), ('LVL', 'Latvian Lats'), ('LBP', 'Lebanese Pound'), ('ALL', 'Lek'), ('HNL', 'Lempira'), ('SLL', 'Leone'), ('LSL', 'Lesotho loti'), ('LRD', 'Liberian Dollar'), ('LYD', 'Libyan Dinar'), ('SZL', 'Lilangeni'), ('LTL', 'Lithuanian Litas'), ('MGA', 'Malagasy Ariary'), ('MWK', 'Malawian Kwacha'), ('MYR', 'Malaysian Ringgit'), ('TMM', 'Manat'), ('MUR', 'Mauritius Rupee'), ('MZN', 'Metical'), ('MXV', 'Mexican Unidad de Inversion (UDI)'), ('MXN', 'Mexican peso'), ('MDL', 'Moldovan Leu'), ('MAD', 'Moroccan Dirham'), ('BOV', 'Mvdol'), ('NGN', 'Naira'), ('ERN', 'Nakfa'), ('NAD', 'Namibian Dollar'), ('NPR', 'Nepalese Rupee'), ('ANG', 'Netherlands Antillian Guilder'), ('ILS', 'New Israeli Sheqel'), ('RON', 'New Leu'), ('TWD', 'New Taiwan Dollar'), ('NZD', 'New Zealand Dollar'), ('KPW', 'North Korean Won'), ('NOK', 'Norwegian Krone'), ('PEN', 'Nuevo Sol'), ('MRO', 'Ouguiya'), ('TOP', 'Paanga'), ('PKR', 'Pakistan Rupee'), ('XPD', 'Palladium'), ('MOP', 'Pataca'), ('PHP', 'Philippine Peso'), ('XPT', 'Platinum'), ('GBP', 'Pound Sterling'), ('BWP', 'Pula'), ('QAR', 'Qatari Rial'), ('GTQ', 'Quetzal'), ('ZAR', 'Rand'), ('OMR', 'Rial Omani'), ('KHR', 'Riel'), ('MVR', 'Rufiyaa'), ('IDR', 'Rupiah'), ('RUB', 'Russian Ruble'), ('RWF', 'Rwanda Franc'), ('XDR', 'SDR'), ('SHP', 'Saint Helena Pound'), ('SAR', 'Saudi Riyal'), ('RSD', 'Serbian Dinar'), ('SCR', 'Seychelles Rupee'), ('XAG', 'Silver'), ('SGD', 'Singapore Dollar'), ('SBD', 'Solomon Islands Dollar'), ('KGS', 'Som'), ('SOS', 'Somali Shilling'), ('TJS', 'Somoni'), ('SSP', 'South Sudanese Pound'), ('LKR', 'Sri Lanka Rupee'), ('XSU', 'Sucre'), ('SDG', 'Sudanese Pound'), ('SRD', 'Surinam Dollar'), ('SEK', 'Swedish Krona'), ('CHF', 'Swiss Franc'), ('SYP', 'Syrian Pound'), ('BDT', 'Taka'), ('WST', 'Tala'), ('TZS', 'Tanzanian Shilling'), ('KZT', 'Tenge'), ('XXX', 'The codes assigned for transactions where no currency is involved'), ('TTD', 'Trinidad and Tobago Dollar'), ('MNT', 'Tugrik'), ('TND', 'Tunisian Dinar'), ('TRY', 'Turkish Lira'), ('TMT', 'Turkmenistan New Manat'), ('TVD', 'Tuvalu dollar'), ('AED', 'UAE Dirham'), ('XFU', 'UIC-Franc'), ('USD', 'US Dollar'), ('USN', 'US Dollar (Next day)'), ('UGX', 'Uganda Shilling'), ('CLF', 'Unidad de Fomento'), ('COU', 'Unidad de Valor Real'), ('UYI', 'Uruguay Peso en Unidades Indexadas (URUIURUI)'), ('UYU', 'Uruguayan peso'), ('UZS', 'Uzbekistan Sum'), ('VUV', 'Vatu'), ('CHE', 'WIR Euro'), ('CHW', 'WIR Franc'), ('KRW', 'Won'), ('YER', 'Yemeni Rial'), ('JPY', 'Yen'), ('CNY', 'Yuan Renminbi'), ('ZMK', 'Zambian Kwacha'), ('ZMW', 'Zambian Kwacha'), ('ZWD', 'Zimbabwe Dollar A/06'), ('ZWN', 'Zimbabwe dollar A/08'), ('ZWL', 'Zimbabwe dollar A/09'), ('PLN', 'Zloty')], default='INR', editable=False, max_length=3)),
('booking_price', djmoney.models.fields.MoneyField(blank=True, decimal_places=2, default=Decimal('0'), default_currency='INR', max_digits=11, null=True)),
('name_on_card', models.CharField(max_length=150)),
('cc_number', creditcards.models.CardNumberField(max_length=25, verbose_name='card number')),
('cc_expiry', creditcards.models.CardExpiryField(verbose_name='expiration date')),
('cc_code', creditcards.models.SecurityCodeField(max_length=4, verbose_name='security code')),
('created_at', models.DateTimeField(auto_now=True)),
('updated_at', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='seat_manager',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(max_length=1, unique=True)),
('created_at', models.DateTimeField(auto_now=True)),
('updated_at', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Seat',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.IntegerField()),
('date', models.DateField()),
('created_at', models.DateTimeField(auto_now=True)),
('updated_at', models.DateTimeField(auto_now_add=True)),
('active', models.BooleanField(default=True)),
('book', models.BooleanField(default=False)),
('available_slot', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cinema_booking.available_slots')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Customer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cust_first_name', models.CharField(max_length=50)),
('cust_last_name', models.CharField(max_length=50)),
('cust_email', models.EmailField(max_length=100)),
('cust_id', models.IntegerField()),
('address', models.CharField(max_length=200)),
('city', models.CharField(max_length=50)),
('state', models.CharField(max_length=50)),
('zipcode', models.CharField(max_length=10)),
('phone_number', models.CharField(max_length=50)),
('cust_bill_card',
creditcards.models.CardNumberField(
max_length=25, verbose_name='card number')),
('cust_bill_expiry',
creditcards.models.CardExpiryField(
verbose_name='expiration date')),
('cust_bill_code',
creditcards.models.SecurityCodeField(
max_length=4, verbose_name='security code')),
('created_date',
models.DateTimeField(default=django.utils.timezone.now)),
('updated_date', models.DateTimeField(auto_now_add=True)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Account',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('card_number', creditcards.models.CardNumberField(max_length=25, null=True)),
('cvc', creditcards.models.SecurityCodeField(max_length=4, null=True)),
('expiry', creditcards.models.CardExpiryField(null=True)),
('brand', models.CharField(blank=True, max_length=10)),
('last4', models.CharField(blank=True, max_length=5)),
('customer_id', models.CharField(blank=True, max_length=70)),
('stripe_id', models.CharField(blank=True, max_length=50)),
('token', models.CharField(blank=True, max_length=100)),
],
),
migrations.CreateModel(
name='CompanionInvite',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('email', models.EmailField(max_length=254)),
('status', django_enumfield.db.fields.EnumField(default=0, enum=apps.account.enums.CompanionInviteStatus)),
('invite_code', models.CharField(max_length=50)),
('invited', models.DateTimeField(auto_now_add=True)),
('accessed', models.DateTimeField(blank=True, null=True)),
('signed_up', models.DateTimeField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='DealWatch',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('destination', django.contrib.postgres.fields.jsonb.JSONField()),
('max_price', models.DecimalField(decimal_places=2, max_digits=10)),
('airlines', django.contrib.postgres.fields.ArrayField(base_field=models.CharField(max_length=10), size=None)),
],
),
migrations.CreateModel(
name='FrequentFlyer',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('american_airlines', models.CharField(blank=True, max_length=30)),
('united_airlines', models.CharField(blank=True, max_length=30)),
('southwest_airlines', models.CharField(blank=True, max_length=30)),
('sun_country_airlines', models.CharField(blank=True, max_length=30)),
('frontier_airlines', models.CharField(blank=True, max_length=30)),
('delta_airlines', models.CharField(blank=True, max_length=30)),
('alaska_airlines', models.CharField(blank=True, max_length=30)),
('jetBlue', models.CharField(blank=True, max_length=30)),
('spirit_airlines', models.CharField(blank=True, max_length=30)),
('allegiant_air', models.CharField(blank=True, max_length=30)),
('hawaiian_airlines', models.CharField(blank=True, max_length=30)),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('users', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Cart',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('check_out', models.BooleanField()),
('date_created',
models.DateTimeField(default=django.utils.timezone.now)),
('profileID',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='users.Profile')),
],
),
migrations.CreateModel(
name='PaymentInformation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=255)),
('last_name', models.CharField(max_length=255)),
('card_number',
creditcards.models.CardNumberField(max_length=25)),
('expiration_date', creditcards.models.CardExpiryField()),
('cvv', creditcards.models.SecurityCodeField(max_length=4)),
],
),
migrations.CreateModel(
name='ShippingInformation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=255)),
('last_name', models.CharField(max_length=255)),
('address_1', models.CharField(max_length=255)),
('address_2', models.CharField(max_length=255)),
('city', models.CharField(max_length=255)),
('postcode', models.IntegerField()),
('country',
django_countries.fields.CountryField(max_length=2)),
],
),
migrations.CreateModel(
name='Order',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('datetime',
models.DateTimeField(default=django.utils.timezone.now)),
('cartID',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='users.Cart')),
('payment_information_id',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='users.PaymentInformation')),
('shipping_information_id',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='users.ShippingInformation')),
],
),
migrations.AlterField(
model_name='orderhistory',
name='orderId',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, to='users.Order'),
),
migrations.AlterField(
model_name='profile',
name='payment_information_id',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='users.PaymentInformation'),
),
migrations.AlterField(
model_name='profile',
name='shipping_information_id',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='users.ShippingInformation'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('rental_location', models.CharField(max_length=200)),
('rental_location_address', models.CharField(max_length=200)),
('vehicle_capacity', models.IntegerField()),
('no_of_vehicles', models.IntegerField(default=10)),
],
),
migrations.CreateModel(
name='Reservation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user', models.CharField(max_length=200)),
('vin_no', models.CharField(max_length=200)),
('reservation_datetime', models.DateTimeField()),
('rental_location', models.CharField(max_length=200)),
('return_datetime', models.DateTimeField()),
('rental_charge', models.CharField(max_length=100)),
('actual_returntime', models.DateTimeField()),
('reservation_status',
models.CharField(choices=[('BKD', 'BOOKED'),
('RNT', 'RENTED'),
('RTD', 'RETURNED')],
default='BKD',
max_length=3)),
],
),
migrations.CreateModel(
name='Vehicle',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('vehicle_type',
models.CharField(choices=[('SC', 'Small Car'),
('FSC', 'Full Size Car'),
('TR', 'Truck'),
('LC', 'Luxury Car')],
default='SC',
max_length=3)),
('make_model', models.CharField(max_length=200)),
('year', models.IntegerField()),
('vin_no', models.CharField(max_length=50)),
('registration_tag', models.CharField(max_length=20)),
('current_mileage', models.IntegerField()),
('last_service_time', models.DateField()),
('basic_fee', models.IntegerField()),
('advanced_fee', models.IntegerField()),
('late_fee', models.IntegerField()),
('vehicle_condition',
models.CharField(choices=[('GD', 'Good'),
('NC', 'Needs Cleaning'),
('NM', 'Needs Maintenance')],
default='GD',
max_length=2)),
('rental_location',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='zip.Location')),
],
),
migrations.CreateModel(
name='Suggestion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('suggestion', models.TextField(max_length=200)),
('vehicle_condition',
models.CharField(choices=[('GD', 'Good'),
('NC', 'Needs Cleaning'),
('NM', 'Needs Maintenance')],
default='GD',
max_length=2)),
('reservation_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='zip.Reservation')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Customer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=200)),
('last_name', models.CharField(max_length=200)),
('email_id', models.EmailField(max_length=200)),
('driver_license_state', models.CharField(max_length=10)),
('driving_license_no', models.CharField(max_length=200)),
('date_of_birth', models.DateField()),
('residence_address', models.CharField(max_length=500)),
('cc_holder_name', models.CharField(max_length=200)),
('cc_number',
creditcards.models.CardNumberField(
max_length=25, verbose_name='Card Number')),
('cc_expiry',
creditcards.models.CardExpiryField(
verbose_name='Expiration Date')),
('cc_code',
creditcards.models.SecurityCodeField(
max_length=4, verbose_name='Security Code')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_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')),
('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')),
('phone_number', phonenumber_field.modelfields.PhoneNumberField(blank=True, max_length=128, null=True, region=None, verbose_name='phone number')),
('gender', models.CharField(choices=[('M', 'Male'), ('F', 'Female')], default='F', max_length=1, verbose_name='gender')),
('date_of_birth', models.DateField(blank=True, null=True, verbose_name='date of birth')),
('is_taker', models.BooleanField(default=False, verbose_name='taker status')),
('is_provider', models.BooleanField(default=False, verbose_name='provider status')),
('is_guardian', models.BooleanField(default=False, verbose_name='guardian status')),
('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', 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', models.CharField(max_length=128, verbose_name='address')),
('city', models.CharField(default='College Station', max_length=64, verbose_name='city')),
('state', django_localflavor_us.models.USStateField(choices=[('AL', 'Alabama'), ('AK', 'Alaska'), ('AS', 'American Samoa'), ('AZ', 'Arizona'), ('AR', 'Arkansas'), ('AA', 'Armed Forces Americas'), ('AE', 'Armed Forces Europe'), ('AP', 'Armed Forces Pacific'), ('CA', 'California'), ('CO', 'Colorado'), ('CT', 'Connecticut'), ('DE', 'Delaware'), ('DC', 'District of Columbia'), ('FL', 'Florida'), ('GA', 'Georgia'), ('GU', 'Guam'), ('HI', 'Hawaii'), ('ID', 'Idaho'), ('IL', 'Illinois'), ('IN', 'Indiana'), ('IA', 'Iowa'), ('KS', 'Kansas'), ('KY', 'Kentucky'), ('LA', 'Louisiana'), ('ME', 'Maine'), ('MD', 'Maryland'), ('MA', 'Massachusetts'), ('MI', 'Michigan'), ('MN', 'Minnesota'), ('MS', 'Mississippi'), ('MO', 'Missouri'), ('MT', 'Montana'), ('NE', 'Nebraska'), ('NV', 'Nevada'), ('NH', 'New Hampshire'), ('NJ', 'New Jersey'), ('NM', 'New Mexico'), ('NY', 'New York'), ('NC', 'North Carolina'), ('ND', 'North Dakota'), ('MP', 'Northern Mariana Islands'), ('OH', 'Ohio'), ('OK', 'Oklahoma'), ('OR', 'Oregon'), ('PA', 'Pennsylvania'), ('PR', 'Puerto Rico'), ('RI', 'Rhode Island'), ('SC', 'South Carolina'), ('SD', 'South Dakota'), ('TN', 'Tennessee'), ('TX', 'Texas'), ('UT', 'Utah'), ('VT', 'Vermont'), ('VI', 'Virgin Islands'), ('VA', 'Virginia'), ('WA', 'Washington'), ('WV', 'West Virginia'), ('WI', 'Wisconsin'), ('WY', 'Wyoming')], default='TX', max_length=2, verbose_name='state')),
('zip_code', models.CharField(default='77840', max_length=5, verbose_name='zip code')),
('country', django_countries.fields.CountryField(default='US', max_length=2, verbose_name='country')),
('latitude', models.FloatField(blank=True, null=True, verbose_name='latitude')),
('longitude', models.FloatField(blank=True, null=True, verbose_name='longitude')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Payment',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('card_number', creditcards.models.CardNumberField(max_length=25, verbose_name='card number')),
('card_expiry', creditcards.models.CardExpiryField(verbose_name='expiration date')),
('card_code', creditcards.models.SecurityCodeField(max_length=4, verbose_name='security code')),
('user', models.ForeignKey(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='MyUser',
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(
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')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='CreditCard',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cc_type',
models.CharField(choices=[('Master', 'Master'),
('Visa', 'Visa')],
default='Master',
max_length=256,
verbose_name='Credit Card Type')),
('cc_number',
creditcards.models.CardNumberField(
max_length=25, verbose_name='card number')),
('cc_expiry',
creditcards.models.CardExpiryField(
verbose_name='expiration date')),
('cc_code',
creditcards.models.SecurityCodeField(
max_length=4, verbose_name='security code')),
],
),
migrations.CreateModel(
name='DeliveryAddress',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('x',
models.IntegerField(
default=0,
verbose_name='X Coordinate of Delivery Address')),
('y',
models.IntegerField(
default=0,
verbose_name='Y Coordinate of Delivery Address')),
],
),
migrations.CreateModel(
name='Order',
fields=[
('order_id', models.AutoField(primary_key=True,
serialize=False)),
('amount', models.IntegerField(default=0,
verbose_name='Amount')),
],
),
migrations.CreateModel(
name='WareHouse',
fields=[
('warehouse_id',
models.AutoField(primary_key=True, serialize=False)),
('x',
models.IntegerField(
default=0, verbose_name='X Coordinate of Ware House')),
('y',
models.IntegerField(
default=0, verbose_name='Y Coordinate of Ware House')),
],
),
migrations.CreateModel(
name='Product',
fields=[
('product_id',
models.AutoField(primary_key=True, serialize=False)),
('name',
models.CharField(choices=[('apple', 'apple'),
('orange', 'orange'),
('banana', 'banana'),
('strawberry', 'strawberry'),
('pineapple', 'pineapple')],
default='apple',
max_length=256,
verbose_name='Product Name')),
('description',
models.TextField(blank=True, verbose_name='Description')),
('price', models.FloatField(blank=True, default=0, null=True)),
('storage',
models.IntegerField(
default=0,
validators=[django.core.validators.MinValueValidator(0)],
verbose_name='Storage')),
('order',
models.ManyToManyField(blank=True,
null=True,
related_name='order',
to='miniamazon_app.Order')),
('warehouse',
models.ManyToManyField(related_name='warehouse',
to='miniamazon_app.WareHouse')),
],
),
migrations.CreateModel(
name='OrderCollection',
fields=[
('order_collection_id',
models.AutoField(primary_key=True, serialize=False)),
('status', models.CharField(default='', max_length=256)),
('truck_id',
models.IntegerField(null=True, verbose_name='Truck ID')),
('owner',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='ordercollection',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='order',
name='order_collection',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='order',
to='miniamazon_app.OrderCollection'),
),
migrations.AddField(
model_name='order',
name='owner',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='order',
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='order',
name='warehouse',
field=models.ManyToManyField(related_name='warehouse_order',
to='miniamazon_app.WareHouse'),
),
migrations.CreateModel(
name='LocalStorage',
fields=[
('local_storage_id',
models.AutoField(primary_key=True, serialize=False)),
('storage',
models.IntegerField(default=0, verbose_name='Storage')),
('product',
models.ManyToManyField(related_name='product_local',
to='miniamazon_app.Product')),
('warehouse',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='localstorage',
to='miniamazon_app.WareHouse')),
],
),
migrations.CreateModel(
name='Cart',
fields=[
('cart_id', models.AutoField(primary_key=True,
serialize=False)),
('amount',
models.IntegerField(
default=0,
validators=[django.core.validators.MinValueValidator(0)],
verbose_name='Amount')),
('order',
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='cart',
to='miniamazon_app.Order')),
('owner',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='owner_cart',
to=settings.AUTH_USER_MODEL)),
('product',
models.ManyToManyField(related_name='product_cart',
to='miniamazon_app.Product')),
('warehouse',
models.ManyToManyField(related_name='warehouse_cart',
to='miniamazon_app.WareHouse')),
],
),
migrations.AddField(
model_name='myuser',
name='credit_card',
field=models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='myuser',
to='miniamazon_app.CreditCard'),
),
migrations.AddField(
model_name='myuser',
name='delivery_address',
field=models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='myuser',
to='miniamazon_app.DeliveryAddress'),
),
migrations.AddField(
model_name='myuser',
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='myuser',
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 = []
operations = [
migrations.CreateModel(
name='Admin',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('email', models.CharField(max_length=255)),
('password', models.CharField(max_length=255)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Billing',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=255)),
('last_name', models.CharField(max_length=255)),
('street', models.TextField()),
('city', models.TextField()),
('state', models.TextField()),
('zipcode', models.TextField()),
('cc_number',
creditcards.models.CardNumberField(max_length=25)),
('cc_expiry', creditcards.models.CardExpiryField()),
('cc_code',
creditcards.models.SecurityCodeField(max_length=4)),
],
),
migrations.CreateModel(
name='Item',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('category', models.CharField(max_length=255)),
('Name', models.CharField(max_length=255)),
('Desc', models.TextField()),
('Front_pic', models.URLField()),
('Back_pic', models.URLField()),
('price', models.DecimalField(decimal_places=2, max_digits=8)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Order',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('total_price',
models.DecimalField(decimal_places=2, max_digits=8)),
('status', models.CharField(max_length=255)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('billing',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='orders',
to='ecommerceApp.billing')),
],
),
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=255)),
('last_name', models.CharField(max_length=255)),
('email', models.CharField(max_length=255)),
('password', models.CharField(max_length=255)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Shipping',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=255)),
('last_name', models.CharField(max_length=255)),
('street', models.TextField()),
('city', models.TextField()),
('state', models.TextField()),
('zipcode', models.TextField()),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='shipping_info',
to='ecommerceApp.user')),
],
),
migrations.CreateModel(
name='Order_item',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity', models.IntegerField()),
('sub_total',
models.DecimalField(decimal_places=2, max_digits=8)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('item',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='order_items',
to='ecommerceApp.item')),
('order',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='order_items',
to='ecommerceApp.order')),
],
),
migrations.AddField(
model_name='order',
name='shipping',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='orders',
to='ecommerceApp.shipping'),
),
migrations.AddField(
model_name='order',
name='user',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='orders',
to='ecommerceApp.user'),
),
migrations.AddField(
model_name='billing',
name='user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='billing_info',
to='ecommerceApp.user'),
),
]