建表语句.txt

java程序五子棋源代码。 java程序五子棋源代码。

create table gobang_userinfo(
	userid varchar(20) primary key,
	integral number default 0,
	wincount number default 0,
	equalcount number default 0,
	failcount number default 0,
	allcount number default 0,
	roomid varchar(3) default '0',
	tableid varchar(2) default '0',
	tableseq varchar(1),
	queuenum number,
	ctrlmsg varchar(64),
	status varchar(2) default '01',
	
);
insert into gobang_userinfo(userid,integral,wincount,equalcount,failcount,allcount) values(102,-5,10,0,10,20);
insert into gobang_userinfo(userid,integral,wincount,equalcount,failcount,allcount) values(103,50,10,0,10,20);
insert into gobang_userinfo(userid,integral,wincount,equalcount,failcount,allcount) values(104,10,10,0,10,20);
insert into gobang_userinfo(userid,integral,wincount,equalcount,failcount,allcount) values(105,100,10,0,10,20);



create table gobang_roominfo(
	roomid varchar(3) primary key,
	capacity number,
	usernum number default 0;
);

create table gobang_hallinfo(
	userid varchar(20) primary key,
	roomid varchar(3) default '0',
	tableid varchar(3) default '0',
	tableseq varchar(1),
	status varchar(2) default '00'
	olineflag number default 0
);

Create table gobang_robotinfo(
	Userid   varchar(20)  primary key,
	Grade  number default  1,
	Roomid varchar(3) default ‘0’,
	Tableid varchar(3) default ‘0’,
	Talbeseq varchar(1) default ‘0’,
	content varchar(500) default ‘0’,
	colorflag number default 1,
	status number default 0,
	oppuserid varchar(20)  default ‘0’,
	oppstatus number default 0
);


insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(103,2,1,20,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(104,3,2,20,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(105,4,3,20,1,2);

insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(106,2,1,1,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(107,3,1,1,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(108,4,1,2,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(109,2,1,1,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(110,3,1,1,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(111,4,1,2,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(112,2,1,2,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(113,3,1,3,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(114,4,1,3,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(115,2,1,4,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(116,3,1,4,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(117,4,1,5,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(118,2,1,5,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(119,3,1,6,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(120,4,1,6,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(121,2,1,7,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(122,3,1,7,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(123,4,1,8,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(124,2,1,8,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(125,3,1,9,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(126,4,1,9,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(127,2,1,10,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(128,3,1,10,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(129,4,1,11,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(130,2,1,11,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(131,3,1,12,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(132,4,1,12,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(133,3,1,13,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(134,4,1,13,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(135,2,1,14,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(136,3,1,14,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(137,4,1,15,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(138,2,1,15,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(139,3,1,16,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(140,4,1,16,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(141,2,1,17,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(142,3,1,17,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(143,4,1,18,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(144,2,1,18,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(145,3,1,19,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(146,4,1,19,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(147,4,1,20,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(148,2,1,20,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(149,3,1,21,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(150,4,1,21,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(151,2,1,22,1,2);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(152,3,1,23,0,1);
insert into gobang_robotinfo(userid,grade,roomid,tableid,tableseq,colorflag) values(153,4,1,24,1,2);
Create table gobang_gameinfo(
	seqid varchar(20) primary key,
	stepnum number default 0,
	content varchar(500),
	prestep varchar(20),
	prefun varchar(2) default '00'
)