![]() enrolled ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, id_customer INT UNSIGNED NOT NULL, id_class INT UNSIGNED NOT NULL, PRIMARY KEY ( id, id_customer, id_class), UNIQUE INDEX id_UNIQUE ( id ASC), UNIQUE INDEX id_customer_UNIQUE ( id_customer ASC), UNIQUE INDEX id_class_UNIQUE ( id_class ASC), INDEX id_class ( id_class ASC), INDEX id_customer ( id_customer ASC), CONSTRAINT id_class FOREIGN KEY ( id_class ) REFERENCES logans. Select the ones you want to reverse engineer. When successfully connected wizard will show you list of available schemas on the server. Wait for the connection and click Next again. Provide connection details to your database and click Next. enrolled-CREATE TABLE IF NOT EXISTS logans. Posted by developer: Fixed as of the upcoming MySQL Workbench 8.0. To reverse engineer database go to menu Database and choose Reverse Engineer. I created the schema in MySQL workbench EER and when I choose Database->Forward Engineer the schema is created apart from one table (enrolled) and I get the following error from the logs.Įxecuting SQL script in serverERROR: Error 1022: Can't write duplicate key in table 'enrolled'- Table logans. reverse and forward engineer between a schema and a live database. ![]() With a model selected and its model tab open click File, Import, and then Reverse Engineer MySQL Create Script from the menu. The MySQL Workbench provides a graphical user interface for working with SQL servers. ![]() Rather new to this but taking a stab at a database for tracking class schedules, lesson location, teacher and students. On the home screen, select the model view from the sidebar, click ( >) next to Models, and then click Reverse Engineer MySQL Create Script. ![]()
0 Comments
Leave a Reply. |