Hi all,
I want to create a mysql table, where it is important that a table-field should be created with a default value.
The sql-statement to be realized using xdoclet at the EntityBean is like this:
CREATE TABLE usertable (
deviceID VARCHAR(250) BINARY NOT NULL,
...,
...,
...,
enabled TINYINT DEFAULT 1 NOT NULL,
...,
...,
...,
CONSTRAINT pk_usertable PRIMARY KEY (deviceID)
)
the table-field enabled should have a default value of 1 at creation time of the table.
Any Idea??
Best regards
nouqrat
I want to create a mysql table, where it is important that a table-field should be created with a default value.
The sql-statement to be realized using xdoclet at the EntityBean is like this:
CREATE TABLE usertable (
deviceID VARCHAR(250) BINARY NOT NULL,
...,
...,
...,
enabled TINYINT DEFAULT 1 NOT NULL,
...,
...,
...,
CONSTRAINT pk_usertable PRIMARY KEY (deviceID)
)
the table-field enabled should have a default value of 1 at creation time of the table.
Any Idea??
Best regards
nouqrat
Comment