And felt that with few minor tweaks we can use it for the
most of client’s requirements. Installation steps
are already documented in article.

NOTE: As this solution posted based on portal version 6,
this doesn’t work out of the box in portal version 7 and require the
modifications to make it work (Same with sample installers also , these doesn’t
work in the newer versions).

To insert a record in to database table “A” (where auto
generated sequence number is primary key) and retrieve that sequence no and
insert a record into table B ( where foreign key is referring to table “A”
primary key) .

Ex:

CREATE TABLE A (

priColumn
INT NOT NULL,

genColumn
VARCHAR(20),

PRIMARY KEY(priColumn)

);

CREATE TABLE B (

priColumn
INT NOT NULL,

genColumn
VARCHAR(30),

FOREIGN KEY (priColumn) REFERENCES
A(priColumn)

);

To handle this
scenario in MySQL

1.To generate the sequence number in MySQL , you no
need to execute separate DDL’s like “create sequence” ..etc, instead you can
use “AUTO_INCREMENT” on table ddl

CREATE
TABLE A (

priColumn INT NOT NULL AUTO_INCREMENT,

genColumn VARCHAR(20),

PRIMARY KEY(priColumn)

);

2.Every time you insert record into table A,
priColumn is filled automatically.

Along with installation of the MySQL community server ,
MySQL workbench also got installed and it found it much useful to administer
the DB , data modeling and also for the development purposes (DDL’s , DML’s)

Easy to start/stop the MySQL
server now from server administration

By default there are few schemas and tables has already
created as part of the installation