search

GrowthVVork / colorflow-habits

ColorFlow Habits is a visual task tracking app that turns your daily activities into a vivid color spectrum, offering a captivating and motivating way to monitor your progress and habits throughout the year.
4 stars 0 forks source link

MySQL Error Code: 3780. Referencing & referred column difference! #29

Closed tejas-k3 closed 9 months ago

tejas-k3 commented 9 months ago

Following error would come at execution -

23:49:39    CREATE TABLE IF NOT EXISTS colorflow.task_activity(  create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,  task_id INT,     PRIMARY KEY (task_id, create_time),     FOREIGN KEY (task_id) REFERENCES colorflow.task(task_id)     ON DELETE NO ACTION ON UPDATE NO ACTION )  Error Code: 3780. Referencing column 'task_id' and referenced column 'task_id' in foreign key constraint 'task_activity_ibfk_1' are incompatible.   0.000 sec