韩国网游数码宝贝RPG（数码宝贝ol）模拟服务端部分源码

-- MySQL Script generated by MySQL Workbench -- 11/23/15 02:50:10 -- Model: New Model Version: 1.0 -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; -- ----------------------------------------------------- -- Schema digimonrpg -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema digimonrpg -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `digimonrpg` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; USE `digimonrpg` ; -- ----------------------------------------------------- -- Table `digimonrpg`.`users` -- ----------------------------------------------------- DROP TABLE IF EXISTS `digimonrpg`.`users` ; CREATE TABLE IF NOT EXISTS `digimonrpg`.`users` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '', `username` VARCHAR(20) NOT NULL COMMENT '', `password` VARCHAR(32) NOT NULL COMMENT '', `trade_password` VARCHAR(32) NOT NULL COMMENT '', `email` VARCHAR(255) NOT NULL COMMENT '', `is_online` TINYINT(1) NULL DEFAULT 0 COMMENT '', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '', `activated_at` TIMESTAMP NULL COMMENT '', `last_active_at` TIMESTAMP NULL COMMENT '', `sign_in_count` INT NOT NULL DEFAULT 0 COMMENT '', PRIMARY KEY (`id`) COMMENT '') ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `digimonrpg`.`tamers` -- ----------------------------------------------------- DROP TABLE IF EXISTS `digimonrpg`.`tamers` ; CREATE TABLE IF NOT EXISTS `digimonrpg`.`tamers` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '', `owner_id` INT UNSIGNED NOT NULL COMMENT '', `slot` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT '', `name` VARCHAR(20) NOT NULL COMMENT '', `model_id` TINYINT NOT NULL DEFAULT 1 COMMENT '', `level` SMALLINT UNSIGNED NOT NULL DEFAULT 1 COMMENT '', `map_id` TINYINT NOT NULL DEFAULT 0 COMMENT '', `location_x` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '', `location_y` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '', `battles` INT NOT NULL DEFAULT 0 COMMENT '', `wins` INT NOT NULL DEFAULT 0 COMMENT '', `is_deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '', `deleted_at` TIMESTAMP NULL COMMENT '', `last_active_at` TIMESTAMP NULL COMMENT '', PRIMARY KEY (`id`, `owner_id`) COMMENT '', INDEX `fk_tamers_users_idx` (`owner_id` ASC) COMMENT '', CONSTRAINT `fk_tamers_users` FOREIGN KEY (`owner_id`) REFERENCES `digimonrpg`.`users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `digimonrpg`.`digimons` -- ----------------------------------------------------- DROP TABLE IF EXISTS `digimonrpg`.`digimons` ; CREATE TABLE IF NOT EXISTS `digimonrpg`.`digimons` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '', `tamer_id` INT UNSIGNED NOT NULL COMMENT '', `slot` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '', `name` VARCHAR(20) NOT NULL COMMENT '', `model_id` SMALLINT NOT NULL DEFAULT 10 COMMENT '', `level` SMALLINT UNSIGNED NOT NULL DEFAULT 1 COMMENT '', `strength` SMALLINT NOT NULL DEFAULT 10 COMMENT '', `dexterity` SMALLINT NOT NULL DEFAULT 10 COMMENT '', `constitution` SMALLINT NULL DEFAULT 10 COMMENT '', `intelligence` SMALLINT NULL DEFAULT 10 COMMENT '', `is_deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '', `deleted_at` TIMESTAMP NULL COMMENT '', PRIMARY KEY (`id`, `tamer_id`) COMMENT '', INDEX `fk_digimons_tamers1_idx` (`tamer_id` ASC) COMMENT '', UNIQUE INDEX `unique_per_tamer` (`slot` ASC, `tamer_id` ASC) COMMENT '', CONSTRAINT `fk_digimons_tamers1` FOREIGN KEY (`tamer_id`) REFERENCES `digimonrpg`.`tamers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; -- ----------------------------------------------------- -- Data for table `digimonrpg`.`users` -- ----------------------------------------------------- START TRANSACTION; USE `digimonrpg`; INSERT INTO `digimonrpg`.`users` (`id`, `username`, `password`, `trade_password`, `email`, `is_online`, `created_at`, `activated_at`, `last_active_at`, `sign_in_count`) VALUES (1, 'test', '', DEFAULT, 'developer@localhost', 0, DEFAULT, NULL, NULL, 0); COMMIT;