- Code/Resource
- Windows Develop
- Linux-Unix program
- Internet-Socket-Network
- Web Server
- Browser Client
- Ftp Server
- Ftp Client
- Browser Plugins
- Proxy Server
- Email Server
- Email Client
- WEB Mail
- Firewall-Security
- Telnet Server
- Telnet Client
- ICQ-IM-Chat
- Search Engine
- Sniffer Package capture
- Remote Control
- xml-soap-webservice
- P2P
- WEB(ASP,PHP,...)
- TCP/IP Stack
- SNMP
- Grid Computing
- SilverLight
- DNS
- Cluster Service
- Network Security
- Communication-Mobile
- Game Program
- Editor
- Multimedia program
- Graph program
- Compiler program
- Compress-Decompress algrithms
- Crypt_Decrypt algrithms
- Mathimatics-Numerical algorithms
- MultiLanguage
- Disk/Storage
- Java Develop
- assembly language
- Applications
- Other systems
- Database system
- Embeded-SCM Develop
- FlashMX/Flex
- source in ebook
- Delphi VCL
- OS Develop
- MiddleWare
- MPI
- MacOS develop
- LabView
- ELanguage
- Software/Tools
- E-Books
- Artical/Document
create_tbl_useritem.sql
Package: LegendOfMir2_Server020418.zip [view]
Upload User: szopptop
Upload Date: 2013-04-23
Package Size: 1047k
Code Size: 1k
Category:
Game Server Simulator
Development Platform:
Visual C++
- /* **************************************************************************
- Create Database for Legend of Mir 2
- All written by Euy-heon, Jeong
- Copyright (C) 2001 Wemade Entertainment. All rights reserved.
- *************************************************************************** */
- USE LEGENDOFMIR
- GO
- DROP TABLE TBL_USERITEM
- GO
- /*
- User Item
- */
- CREATE TABLE TBL_USERITEM
- (
- FLD_CHARNAME NCHAR(20) NOT NULL,
- FLD_STDTYPE NCHAR(1) NOT NULL,
- FLD_MAKEDATE NCHAR(6) NOT NULL,
- FLD_MAKEINDEX NCHAR(5) NOT NULL,
- FLD_STDINDEX INT NOT NULL,
- FLD_DURA INT NOT NULL,
- FLD_DURAMAX INT NOT NULL,
- FLD_VALUE1 TINYINT NOT NULL,
- FLD_VALUE2 TINYINT NOT NULL,
- FLD_VALUE3 TINYINT NOT NULL,
- FLD_VALUE4 TINYINT NOT NULL,
- FLD_VALUE5 TINYINT NOT NULL,
- FLD_VALUE6 TINYINT NOT NULL,
- FLD_VALUE7 TINYINT NOT NULL,
- FLD_VALUE8 TINYINT NOT NULL,
- FLD_VALUE9 TINYINT NOT NULL,
- FLD_VALUE10 TINYINT NOT NULL,
- FLD_VALUE11 TINYINT NOT NULL,
- FLD_VALUE12 TINYINT NOT NULL,
- FLD_VALUE13 TINYINT NOT NULL,
- FLD_VALUE14 TINYINT NOT NULL,
- )
- GO
- ALTER TABLE TBL_USERITEM ADD CONSTRAINT PK_USERITEM PRIMARY KEY (FLD_MAKEINDEX)
- GO