/* 이 SQL DDL 스크립트는 Microsoft Visual Studio(릴리스 날짜: LOCAL BUILD)에서 생성했습니다. */ /* 사용된 드라이브 : Microsoft Visual Studio - Microsoft SQL Server 드라이버 */ /* 문서 : E:\Work\여러가지문서들\VISIO FILE\공성전테이블구조.vsd */ /* 만든 시간: 2004년4월8일 4:22 오후 */ /* 작업 : Visio 데이터베이스 업데이트 마법사에서 수행 */ /* 연결된 데이터 원본 : JunDBServer */ /* 연결된 서버 : STATIONRYL */ /* 연결된 데이터베이스 : Gama_Test */ /* 새 테이블 "TblPatrolInCampInfo"을(를) 만듭니다. */ /* "TblPatrolInCampInfo" : Table of TblPatrolInCampInfo */ /* "nPatrolID" : nPatrolID identifies TblPatrolInCampInfo */ /* "nCampID" : nCampID is of TblPatrolInCampInfo */ /* "nHP" : nHP is of TblPatrolInCampInfo */ /* "tnState" : 상태 */ /* "nX" : nX is of TblPatrolInCampInfo */ /* "nY" : nY is of TblPatrolInCampInfo */ /* "nZ" : nZ is of TblPatrolInCampInfo */ create table "TblPatrolInCampInfo" ( "nCampID" int not null, "nHP" int not null, "tnState" tinyint not null, "nX" int not null, "nY" int not null, "nZ" int not null) go alter table "TblPatrolInCampInfo" add constraint "TblPatrolInCampInfo_PK" primary key (nCampID,nX,nY,nZ) go /* 새 테이블 "TblCampInfo"을(를) 만듭니다. */ /* "TblCampInfo" : Table of TblCampInfo */ /* "nCampID" : nCampID identifies TblCampInfo */ /* "nGuildID" : nGuildID is of TblCampInfo */ /* "nHP" : nHP is of TblCampInfo */ /* "tnState" : 구축,완료 */ /* "nEnCampingTime" : 캠프구축시간 */ /* "nX" : nX is of TblCampInfo */ /* "nY" : nY is of TblCampInfo */ /* "nZ" : nZ is of TblCampInfo */ create table "TblCampInfo" ( "nCampID" int not null, "nGuildID" int not null, "nHP" int not null, "tnState" tinyint not null, "nEnCampingTime" int not null, "nX" int not null, "nY" int not null, "nZ" int not null) go alter table "TblCampInfo" add constraint "TblCampInfo_PK" primary key ("nCampID") go /* 새 테이블 "TblWeaponInCastleInfo"을(를) 만듭니다. */ /* "TblWeaponInCastleInfo" : Table of TblWeaponInCastleInfo */ /* "nCastleID" : nCastleID is of TblWeaponInCastleInfo */ /* "tnType" : 병기종류(가드,근거리,원거리) */ /* "nHP" : 체력 */ /* "tnState" : 개발,수리,완료,업그레이드중 */ /* "tnUpgradeStep" : 업그레이드단계 */ /* "nRemainUpTime" : 업그레이드남은 시간 */ /* "nX" : nX is of TblWeaponInCastleInfo */ /* "nY" : nY is of TblWeaponInCastleInfo */ /* "nZ" : nZ is of TblWeaponInCastleInfo */ create table "TblWeaponInCastleInfo" ( "nCastleID" int not null, "tnType" tinyint not null, "nHP" int not null, "tnState" tinyint not null, "tnUpgradeStep" tinyint not null, "nRemainUpTime" int not null, "nX" int not null, "nY" int not null, "nZ" int not null) go alter table "TblWeaponInCastleInfo" add constraint "TblWeaponInCastleInfo_PK" primary key (nCastleID,nX,nY,nZ) go /* 새 테이블 "TblCastleGateInfo"을(를) 만듭니다. */ /* "TblCastleGateInfo" : Table of TblCastleGateInfo */ /* "nCastleID" : 성아이디 */ /* "nHP" : HP */ /* "tnState" : 성문상태(수리,복구,업그레이드중) */ /* "tnOpenClose" : 성문 OPEN 또는 Close 여부 */ /* "tnUpgradeStep" : tnUpgradeStep is of TblCastleGateInfo */ /* "nRemainUpTime" : 업그레이드 남은시간 */ /* "nX" : nX is of TblCastleGateInfo */ /* "nY" : nY is of TblCastleGateInfo */ /* "nZ" : nZ is of TblCastleGateInfo */ create table "TblCastleGateInfo" ( "nCastleID" int not null, "nHP" int not null, "tnState" tinyint not null, "tnOpenClose" tinyint not null, "tnUpgradeStep" tinyint not null, "nRemainUpTime" int not null, "nX" int not null, "nY" int not null, "nZ" int not null) go alter table "TblCastleGateInfo" add constraint "TblCastleGateInfo_PK" primary key ("nCastleID") go /* 새 테이블 "TblEmblemInCastleInfo"을(를) 만듭니다. */ /* "TblEmblemInCastleInfo" : Table of TblEmblemInCastleInfo */ /* "nCastleID" : 성아이디 */ /* "nHP" : HP */ /* "tnUpgradeStep" : 업그레이드 단계 */ /* "tnUpgradeType" : 업그레이드 종류(보석종류) */ /* "nRemainUpTime" : 업그레이드남은시간 */ /* "nX" : 좌표값 */ /* "nY" : 좌표값 */ /* "nZ" : 좌표값 */ create table "TblEmblemInCastleInfo" ( "nCastleID" int not null, "nHP" int not null, "tnUpgradeStep" tinyint not null, "tnUpgradeType" tinyint not null, "nRemainUpTime" int not null, "nX" int not null, "nY" int not null, "nZ" int not null) go alter table "TblEmblemInCastleInfo" add constraint "TblEmblemInCastleInfo_PK" primary key ("nCastleID") go /* 새 테이블 "TblCastleInfo"을(를) 만듭니다. */ /* "TblCastleInfo" : Table of TblCastleInfo */ /* "nCastleID" : 성아이디 */ /* "nGuildID" : 소유길드ID */ /* "snTax" : 세율 */ /* "nTaxMoney" : 세금저장소 */ /* "tnAttackCount" : 공성횟수 */ /* "bRight" : 관리권한 */ /* "tnInvincibleCount" : 무적횟수 */ create table "TblCastleInfo" ( "nCastleID" int not null, "nGuildID" int not null, "snTax" smallint not null, "nTaxMoney" int not null, "tnAttackCount" tinyint not null, "bRight" binary(10) not null, "tnInvincibleCount" tinyint not null) go alter table "TblCastleInfo" add constraint "TblCastleInfo_PK" primary key ("nCastleID") go /* "TblPatrolInCampInfo" 테이블에 외래 키 제약 조건을 추가합니다. */ alter table "TblPatrolInCampInfo" add constraint "TblCampInfo_TblPatrolInCampInfo_FK1" foreign key ( "nCampID") references "TblCampInfo" ( "nCampID") on update no action on delete no action go /* "TblWeaponInCastleInfo" 테이블에 외래 키 제약 조건을 추가합니다. */ alter table "TblWeaponInCastleInfo" add constraint "TblCastleInfo_TblWeaponInCastleInfo_FK1" foreign key ( "nCastleID") references "TblCastleInfo" ( "nCastleID") on update no action on delete no action go /* "TblCastleGateInfo" 테이블에 외래 키 제약 조건을 추가합니다. */ alter table "TblCastleGateInfo" add constraint "TblCastleInfo_TblCastleGateInfo_FK1" foreign key ( "nCastleID") references "TblCastleInfo" ( "nCastleID") on update no action on delete no action go /* "TblEmblemInCastleInfo" 테이블에 외래 키 제약 조건을 추가합니다. */ alter table "TblEmblemInCastleInfo" add constraint "TblCastleInfo_TblEmblemInCastleInfo_FK1" foreign key ( "nCastleID") references "TblCastleInfo" ( "nCastleID") on update no action on delete no action go