MySQL Forums
Forum List  »  MySQL Workbench

MySQLWorkbench Updates
Posted by: Bob Paris
Date: April 29, 2008 12:12PM

I recently purchased the MySQL Workbench SE(5.0.19) and have been happy with it until today.
1) Tried to forward engineer a MySQL database and it repeatedly choked. Data below.
2) Checked for update and it recognized the OSS version rather than the SE version that I paid for. I began the installation and was able to halt it. Unable to verify corruption of commercial version.

=====================================================================
DATA
======================================================================
While forward engineering (TO the database) and on running this script, I get an error code 1063.

CREATE TABLE IF NOT EXISTS stocktracker.users (
loginID VARCHAR(20) NOT NULL DEFAULT NULL ,
lastName VARCHAR(45) NOT NULL ,
firstName VARCHAR(45) NOT NULL ,
pswd VARCHAR(10) NOT NULL ,
admin TINYINT(1) NULL DEFAULT NULL ,
PRIMARY KEY (loginID) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1
INSERT INTO users (loginID, lastName, firstName, pswd, admin) VALUES ('admin01', 'Admin', 'Default', 'admin', -1);
INSERT INTO users (loginID, lastName, firstName, pswd, admin) VALUES ('user01', 'Buyout', 'Bill', 'money', 0);
INSERT INTO users (loginID, lastName, firstName, pswd, admin) VALUES ('user02', 'Futures', 'Fran', 'wallstreet', -1);

CREATE TABLE IF NOT EXISTS stocktracker.stocks (
symbol VARCHAR(8) NOT NULL ,
name VARCHAR(45) NOT NULL ,
PRIMARY KEY (symbol) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1

insert into stocks (symbol, name) values ('DELL', 'Dell Computer Corporation')
insert into stocks (symbol, name) values ('MSFT', 'Microsoft Corporation')
insert into stocks (symbol, name) values ('ORCL', 'Oracle Corporation')

CREATE TABLE IF NOT EXISTS stocktracker.userstocks (
userID VARCHAR(45) NOT NULL ,
symbol VARCHAR(45) NOT NULL ,
INDEX fk_userstocks_stocks (symbol ASC) ,
INDEX fk_userstocks_users (userID ASC) ,
PRIMARY KEY (userID, symbol) ,
CONSTRAINT fk_userstocks_stocks
FOREIGN KEY (symbol )
REFERENCES stocktracker.stocks (symbol )
ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT fk_userstocks_users
FOREIGN KEY (userID )
REFERENCES stocktracker.users (loginID )
ON DELETE NO ACTION ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1

insert into userstocks (userID, symbol) values ('Admin01','DELL')
insert into userstocks (userID, symbol) values ('Admin01','MSFT')
insert into userstocks (userID, symbol) values ('Admin01','ORCL')
insert into userstocks (userID, symbol) values ('user01','DELL')
insert into userstocks (userID, symbol) values ('user01','MSFT')
insert into userstocks (userID, symbol) values ('user02','MSFT')
insert into userstocks (userID, symbol) values ('user02','DELL')

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQLWorkbench Updates
4082
April 29, 2008 12:12PM
2597
April 30, 2008 03:53PM
2513
May 07, 2008 03:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.