--1.001--
create table hy_crop(
	cid int primary key,
	seedid int,
	cName text(255),
  free int,
  type int,
  addcharm int,
  charm int,
  flowerPrice int,
	seedPrice int,
	seedPriceQPoint int,
  times text(255),
	maxOutput int,
	minOutput int,
	exp int,
	clevel int,
	growthCycle int
)
/
create table hy_soil(
        buyTime int,
        cId int,
        soilno int,
        rosestate int,
        gaincount int,
        stealcount int,
        leftcount int,
        isnofood int,
        isnoshine int,
        isclutter int,
        userid int,
        sftq00 int default 0,
        qq text(50)
)
/
create table hy_friends(
	qq text(20),
	userId int,
  userName text(255),
	face text(255),
	vip int,
	exp int,
	rank int,
	sjjy00 int,
	money0 int,
  photo text(255),
	sfbmd0 int default 1,
	zhgxsj int default 0
)
/
create table hy_friends_hmd(
qq text(20),
userid int
)
/
create table xtbm00(
        bmlb00 text(255),
        bmmc00 text(255)
)
/
create table xhnum(
	qq text(50)
)
/
create table qkxhnum(
uid int,
jqm000 text(255),
sqrq00 int,
sqly00 text(255),
shrq00 int,
shzt00 text(255),
shyy00 text(255),
shr000 text(255)
)
/
--1.002--
create table hy_mycrop(
xuanz int,
userid int,
cId int,
cName text(255),
amount int,
price int,
cssl00 int,
zt0000 text(50)
)
/
--1.003--
alter table hy_crop add combineid text(255)
/
--1.004--
alter table hy_friends add jyz000 text(255)
/
--1.005--
alter   table   qq   add   id   Counter
/
--1.006--
ALTER TABLE hy_friends ALTER COLUMN userId Text(255)
/
--1.007--
ALTER TABLE hy_soil ALTER COLUMN userId Text(255)
/
ALTER TABLE hy_friends_hmd ALTER COLUMN userId Text(255)
/
--1.008--
ALTER TABLE hy_mycrop ALTER COLUMN userId Text(255)
/
--1.009--
ALTER TABLE hy_crop add potlevel int default 0
/
--1.01--
ALTER TABLE hy_soil add speed int default 0
/
ALTER TABLE hy_soil add season int default 1
/
--1.011--
ALTER TABLE hy_crop add multigrowthCycle int default 0  
/
--1.012--
ALTER TABLE hy_soil add soiltype int default 0
/
--1.013--
CREATE INDEX hy_soil_INDEX ON hy_soil(userid,qq);
/
CREATE INDEX hy_friends_INDEX ON hy_friends(userid,qq);
/
CREATE INDEX hy_friends_hmd_INDEX ON hy_friends_hmd(userid,qq);
/
CREATE INDEX hy_mycrop_INDEX ON hy_mycrop(userid);
/