The reason for this is, in class Meta, you have set, managed=False. That's causing the issue.
When you set managed=False, then there is no table creation happens for that model when you run migrate command after make migrations. So, if you want a table to be created for that model, just remove managed=False and it should work fine. Refer the django docs for more details: https://docs.djangoproject.com/en/2.2/ref/models/options/ On Friday, June 19, 2020 at 12:10:57 PM UTC+5:30, Mohsen Pahlevanzadeh wrote: > > I run : > ./manage makemigrations and ./manage migrate with the following output: > > """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" > (django_sql) mohsen@debian:~/Documents/django_sql/django_sql$ ./manage.py > makemigrations > Migrations for 'sql': > > sql/migrations/0006_customertbl_employeepaytbl_employeetbl_orderstbl_productstbl.py > - Create model CustomerTbl > - Create model EmployeeTbl > - Create model OrdersTbl > - Create model ProductsTbl > - Create model EmployeePayTbl > (django_sql) mohsen@debian:~/Documents/django_sql/django_sql$ ./manage.py > migrate > Operations to perform: > Apply all migrations: admin, auth, contenttypes, sessions, sql > Running migrations: > Applying > sql.0006_customertbl_employeepaytbl_employeetbl_orderstbl_productstbl... OK > > """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" > My models.py is: > > > """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" > from django.db import models > > # This is an auto-generated Django model module. > # You'll have to do the following manually to clean this up: > # * Rearrange models' order > # * Make sure each model has one field with primary_key=True > # * Make sure each ForeignKey and OneToOneField has `on_delete` set to > the desired behavior > # * Remove `managed = False` lines if you wish to allow Django to > create, modify, and delete the table > # Feel free to rename the models, but don't rename db_table values or > field names. > > > class CustomerTbl(models.Model): > cust_id = models.CharField(db_column='CUST_ID', primary_key=True, > max_length=10) # Field name made lowercase. > cust_name = models.CharField(db_column='CUST_NAME', max_length=30) # > Field name made lowercase. > cust_address = models.CharField(db_column='CUST_ADDRESS', > max_length=20) # Field name made lowercase. > cust_city = models.CharField(db_column='CUST_CITY', max_length=15) # > Field name made lowercase. > cust_state = models.CharField(db_column='CUST_STATE', max_length=2) # > Field name made lowercase. > cust_zip = models.IntegerField(db_column='CUST_ZIP') # Field name > made lowercase. > cust_phone = models.CharField(db_column='CUST_PHONE', max_length=10, > blank=True, null=True) # Field name made lowercase. > cust_fax = models.CharField(db_column='CUST_FAX', max_length=10, > blank=True, null=True) # Field name made lowercase. > > class Meta: > managed = False > db_table = 'CUSTOMER_TBL' > > > class EmployeePayTbl(models.Model): > emp = models.OneToOneField('EmployeeTbl', models.DO_NOTHING, > db_column='EMP_ID', primary_key=True) # Field name made lowercase. > position = models.CharField(db_column='POSITION', max_length=15) # > Field name made lowercase. > date_hire = models.DateField(db_column='DATE_HIRE', blank=True, > null=True) # Field name made lowercase. > pay_rate = models.DecimalField(db_column='PAY_RATE', max_digits=4, > decimal_places=2, blank=True, null=True) # Field name made lowercase. > date_last_raise = models.DateField(db_column='DATE_LAST_RAISE', > blank=True, null=True) # Field name made lowercase. > salary = models.DecimalField(db_column='SALARY', max_digits=8, > decimal_places=2, blank=True, null=True) # Field name made lowercase. > bonus = models.DecimalField(db_column='BONUS', max_digits=6, > decimal_places=2, blank=True, null=True) # Field name made lowercase. > > class Meta: > managed = False > db_table = 'EMPLOYEE_PAY_TBL' > > > class EmployeeTbl(models.Model): > emp_id = models.CharField(db_column='EMP_ID', primary_key=True, > max_length=9) # Field name made lowercase. > last_name = models.CharField(db_column='LAST_NAME', max_length=15) # > Field name made lowercase. > first_name = models.CharField(db_column='FIRST_NAME', max_length=15) > # Field name made lowercase. > middle_name = models.CharField(db_column='MIDDLE_NAME', max_length=15, > blank=True, null=True) # Field name made lowercase. > address = models.CharField(db_column='ADDRESS', max_length=30) # > Field name made lowercase. > city = models.CharField(db_column='CITY', max_length=15) # Field name > made lowercase. > state = models.CharField(db_column='STATE', max_length=2) # Field > name made lowercase. > zip = models.IntegerField(db_column='ZIP') # Field name made > lowercase. > phone = models.CharField(db_column='PHONE', max_length=10, blank=True, > null=True) # Field name made lowercase. > pager = models.CharField(db_column='PAGER', max_length=10, blank=True, > null=True) # Field name made lowercase. > > class Meta: > managed = False > db_table = 'EMPLOYEE_TBL' > > > class OrdersTbl(models.Model): > ord_num = models.CharField(db_column='ORD_NUM', primary_key=True, > max_length=10) # Field name made lowercase. > cust_id = models.CharField(db_column='CUST_ID', max_length=10) # > Field name made lowercase. > prod_id = models.CharField(db_column='PROD_ID', max_length=10) # > Field name made lowercase. > qty = models.IntegerField(db_column='QTY') # Field name made > lowercase. > ord_date = models.DateField(db_column='ORD_DATE', blank=True, > null=True) # Field name made lowercase. > > class Meta: > managed = False > db_table = 'ORDERS_TBL' > > > class ProductsTbl(models.Model): > prod_id = models.CharField(db_column='PROD_ID', primary_key=True, > max_length=10) # Field name made lowercase. > prod_desc = models.CharField(db_column='PROD_DESC', max_length=40) # > Field name made lowercase. > cost = models.DecimalField(db_column='COST', max_digits=6, > decimal_places=2) # Field name made lowercase. > > class Meta: > managed = False > db_table = 'PRODUCTS_TBL' > """""""""""""""""""""""""""""""""""""""""""""""""""""""""" > > But When I use the following command in mysql shell: > """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" > use esql; > show tables; > +----------------------------+ > | Tables_in_esql | > +----------------------------+ > | auth_group | > | auth_group_permissions | > | auth_permission | > | auth_user | > | auth_user_groups | > | auth_user_user_permissions | > | django_admin_log | > | django_content_type | > | django_migrations | > | django_session | > +----------------------------+ > > > I don't see my tables. > > What happen? > > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/fbbb1b9c-2b6a-4cdc-8b59-a16bd4e60370o%40googlegroups.com.
