Project Build Order

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
phpwalter
Posts: 4
Joined: Wed 10 Sep 2014 16:38

Project Build Order

Post by phpwalter » Fri 17 Jan 2020 01:11

I have searched by as many different words as I could think of.

The forum search does NOT search by a set of words, just individual words.

I need help.


I had all 87 table definitions is a single file that made the DB just fine.

I created a project, made individual files in TABLES for each table definition and hit BUILD (DEPLOY has the same issue)

" Table `user` is used before it is declared in the project. Check the file position in build order in the project options."

Well, yes.

COMPANY has a FK to COMPANY TYPE

Both COMPANY and COMPANY TYPE have a FK to USER (created_by_id)

OK, simple, place USER before COMPANY TYPE.

But USER has a FK to CONTACT

AND CONTACT has a FK to COMPANY

See my problem?

There must be a setting somewhere that say IGNORE table order, just build the damn thing, and give me a report at the end of any tables that are missing

Please help.

This is my "PreDeployment" file:

Code: Select all

-- 
-- Disable foreign keys
-- 
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

-- 
-- Set SQL mode
-- 
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT = @@CHARACTER_SET_CLIENT */;
/*!40101 SET @CHARACTER_SET_RESULTS = @@CHARACTER_SET_RESULTS */;
/*!40101 SET @COLLATION_CONNECTION = @@COLLATION_CONNECTION */;

-- 
-- Set character set the client will use to send SQL statements to the server
--
SET NAMES 'utf8';

--
-- OK, set it up! 
--
DROP DATABASE IF EXISTS `xrms2`;

CREATE DATABASE IF NOT EXISTS `xrms2`
CHARACTER SET `utf8`
COLLATE `utf8_general_ci`;

--
-- Set default database
--
USE `xrms2`;

alexa
Devart Team
Posts: 2886
Joined: Fri 24 Jun 2011 14:17

Re: Project Build Order

Post by alexa » Mon 03 Feb 2020 12:26

There is no such an option. Though, you can add a suggestion on the UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/77293-dbforge-studio-for-mysql

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.

Post Reply