--1.001--
create table xtbm00(
        bmlb00 text(255),
        bmmc00 text(255)
)
/
create table xhnum(
	qq text(50)
)
/
alter   table   qq   add   id   Counter
/
create table jlapp(
id  AUTOINCREMENT primary key,
serverid text(20),
appname text(255),
username text(255),
uid int,
bbh double,
bbbs text(100),
dqsj text(20),
sm memo,
zyybs text(100),
yybs text(100),
hslx int default 0,
yyxz int default 0,
yys int default 0,
fl1 int default 0,
fl2 int default 0,
lx int default 0,
xzcs int default 0,
dqrq00 text(255),
sfxz int default 1,
sm1 text(255),
sm2 text(255),
sm3 text(255) 
)
/
--1.002--
ALTER TABLE jlapp add fz Text(255)
/
ALTER TABLE jlapp add yzz memo
/
--1.003--
ALTER TABLE jlapp add sm4 text(255)
/
--1.004--
ALTER TABLE jlapp add gnjs memo
/
--1.005--
ALTER TABLE jlapp add serverbbh double
/
--1.006--
ALTER TABLE jlapp add px int default 0
/
ALTER TABLE jlapp add sm5 text(150)
/
ALTER TABLE jlapp add sm6 text(150)
/
ALTER TABLE jlapp add sm7 text(150)
/
update jlapp set px=id;
/
--1.007--
ALTER TABLE jlapp add sm8 text(150)
/
--1.008--
ALTER TABLE jlapp add sm9 text(150)
/
ALTER TABLE jlapp add usesl int default 0
/
--1.009--
ALTER TABLE jlapp add bz text(255)
/
--1.01--
ALTER TABLE jlapp add xgdz text(255)
/
--1.011--
ALTER TABLE jlapp add sm10 text(200)
/
--1.012--
ALTER TABLE jlapp Alter COLUMN sm7 text(255)
/
ALTER TABLE jlapp Alter COLUMN sm6 text(255)
/
ALTER TABLE jlapp Alter COLUMN sm5 text(255)
/
ALTER TABLE jlapp Alter COLUMN sm8 text(255)
/
ALTER TABLE jlapp Alter COLUMN sm9 text(255)
/