firmware/tbl_user_info.def

17 lines
287 B
Modula-2

set TABLE=20
set TABLESPACE=1000
create table TBL_USER_INFO
(
acct_id long,
user_no char(21),
user_type char[2],
user_nm char[81],
user_addr char[161],
user_phone char[31]
);
-- Create indexes
create unique index (user_no, user_type);
create index (acct_id);