what i mean is :
When using SchemaExport Tool it only generate sql like :
[schemaexport] create table TBL_ATTACHMENT (
[schemaexport] PK_ATTACH_ID bigint not null auto_increment,
[schemaexport] FK_NEWS_ID bigint,
[schemaexport] VC_FILENAME varchar(50) not null,
[schemaexport] VC_PATH varchar(80) not null,
[schemaexport] VC_SIZE bigint,
[schemaexport] VC_TYPE varchar(40),
[schemaexport] LAST_MODIFIED date not null,
[schemaexport] CREATE_DATE date not null,
[schemaexport] CREATE_ID varchar(40) not null,
[schemaexport] primary key (PK_ATTACH_ID)
[schemaexport] )
How to make it become
[schemaexport] create table TBL_ATTACHMENT (
[schemaexport] PK_ATTACH_ID bigint not null auto_increment,
[schemaexport] FK_NEWS_ID bigint,
[schemaexport] VC_FILENAME varchar(50) not null,
[schemaexport] VC_PATH varchar(80) not null,
[schemaexport] VC_SIZE bigint,
[schemaexport] VC_TYPE varchar(40),
[schemaexport] LAST_MODIFIED date not null,
[schemaexport] CREATE_DATE date not null,
[schemaexport] CREATE_ID varchar(40) not null,
[schemaexport] primary key (PK_ATTACH_ID)
[schemaexport] ) CHARACTER SET UTF-8 COLLATE UTF-8_BIN
|