加粗样式
拷贝过来的Django文件在pycharm中打开时,执行python manage.py makemigrations和python manage.py migrate时出现报错:django.db.utils.OperationalError: (1050, “Table nanme ’ already exists”)
使用网上的方法:python manage.py migrate app名字 --fake
发现如果在model里面再新增字段的时候执行python manage.py migrate的时候再次报错:No migrations to apply.
表明在migrations里面有存在变更跟新的py文件,但是migrate依然无法执行。
使用网络此方法依然不可取:(但是delete这不是必不可少的)
原因是:发现使用delete并未能正真删除数据库里面的表。
最后的解决思路:
1.使用cmd进入Msql
2.使用sql语句drop table删除已经存在的表
3.删除migrations里的所有变更记录的py文件,只保留_int_.py
4.再次执行python manage.py makemigrations和migrate
Mysql里面的操作:
mysql -u root -p
mysql> show databases;
mysql> use containerterminaldb;
mysql> show tables;
+-------------------------------+
| Tables_in_containerterminaldb |
+-------------------------------+
| auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| berth_berth_draught |
| berth_berthinfo |
| berth_doordefine |
| django_admin_log |
| django_content_type |
| django_migrations |
| django_session |
| door_doordefine |
| qc_qc_load_task |
| qc_qc_struct_info |
| qc_qc_unload_task |
| qc_qc_work_plan |
| qc_qc_workbay_plan |
| qc_quary_info |
| vessel_cargclas_code |
| vessel_cargnam_code |
| vessel_con_stowage_export |
| vessel_cont_info |
| vessel_ctnowner_code |
| vessel_ctntyp_code |
| vessel_dangerclas_code |
| vessel_expvoy_ctnwegt_lev |
| vessel_expvoy_weigportclass |
| vessel_gforce_code |
| vessel_import_manifest |
| vessel_import_manifest_detail |
| vessel_loand_unload_task |
| vessel_mothcoty_code |
| vessel_owner_code |
| vessel_port_code |
| vessel_pre_vessel_map |
| vessel_ves_bay_lay_struct |
| vessel_ves_slot |
| vessel_ves_struct |
| vessel_vessel_map_import |
| vessel_vessel_voy_info |
| vessel_voyloadportser |
| vessel_voyunlportser |
| yard_agvdefi |
| yard_agvkind |
| yard_blockdefine |
| yard_blockposdefine |
| yard_evacuationplandetail |
| yard_externaltruck |
| yard_gathertingstorageplan |
| yard_innerdefi |
| yard_movectnplan |
| yard_outsidecardefi |
| yard_outsidedefi |
| yard_pickuptable |
| yard_prestorageplan |
| yard_unloadstorageplan |
| yard_yardcellinfo |
| yard_ycinfo |
| yard_ycstructinfo |
+-------------------------------+
61 rows in set (0.00 sec)
mysql> DROP TABLE yard_agvkind;
Query OK, 0 rows affected (0.02 sec)
mysql> drop table yard_blockdefine;
Query OK, 0 rows affected (0.02 sec)
————这里尚未使用批量删除,而是笨办法逐一的删除数据表qwq…——————————————————————