create_tbl_movemapevnt.sql
Upload User: szopptop
Upload Date: 2013-04-23
Package Size: 1047k
Code Size: 1k
Development Platform:

Visual C++

  1. /* **************************************************************************
  2. Create Database for Legend of Mir 2
  3. All written by Euy-heon, Jeong
  4. Copyright (C) 2001 Wemade Entertainment. All rights reserved.
  5.    *************************************************************************** */
  6. USE LEGENDOFMIR
  7. GO
  8. DROP TABLE TBL_MOVEMAPEVENT
  9. GO
  10. /* 
  11. Move Map Event Information
  12. */
  13. CREATE TABLE TBL_MOVEMAPEVENT
  14. (
  15. FLD_INDEX INT NOT NULL,
  16. FLD_SMAPFILENAME CHAR(14) NOT NULL,
  17. FLD_SX INT NOT NULL,
  18. FLD_SY INT NOT NULL,
  19. FLD_DMAPFILENAME CHAR(14) NOT NULL,
  20. FLD_DX INT NOT NULL,
  21. FLD_DY INT NOT NULL,
  22. FLD_DESCRIPTION VARCHAR(100) NULL,
  23. )
  24. GO
  25. ALTER TABLE TBL_MOVEMAPEVENT ADD CONSTRAINT PK_MOVEMAPEVENT PRIMARY KEY (FLD_INDEX)
  26. GO