Hi,
Try:
create table lgr(lgr_code int not null identity(1, 1) primary
key,lgr_user_code varchar(13) not null unique , lgr_name varchar(50)
not null unique,lgr_description varchar(125) default null,lgr_grp_code
int not null, status char(1) default 'D' constraint status_type
check(status in ('C','D')), opening_balance double default 0.00,active
char(1) not null default 'Y' constraint acct_check check(active
in('Y','N')), lgr_grp_head_code char(3) not null constraint
lgrgrouphead check(lgr_grp_head_code in
('CSH','PUR','DIN','DT','IIN','IEC','DTT','TCR','DEX','PLA','BNK','CPA','DEP','LNS','PVS','TAS','SDL','INV','UDL','GNR','OCL','ADV','MIS','IAS'))
,transaction_dr double default 0.00,transaction_cr double default
0.00,transaction_balance double default 0.00)
See also http://www.h2database.com/html/grammar.html#create_table
P.S. You didn't send the email to me, you sent it the the non-existing
addresses with the dots ([email protected]). The dots are
used by Google to protect from spam.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
