need help DB

-- phpMyAdmin SQL Dump
-- version 4.9.2
-- [Only registered and activated users can see links. Click Here To Register...]
--
-- Host: 127.0.0.1
-- Generation Time: Jan 25, 2020 at 10:17 AM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.3.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @[Only registered and activated users can see links. Click Here To Register...]CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @[Only registered and activated users can see links. Click Here To Register...]CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @[Only registered and activated users can see links. Click Here To Register...]COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ts2_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `avatarinfo`
--

CREATE TABLE `avatarinfo` (
`aInsertTime` datetime DEFAULT NULL,
`uID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`aVisibleState` int(11) DEFAULT 1,
`aSpecialState` int(11) DEFAULT 0,
`aPlayTime1` int(11) DEFAULT 0,
`aPlayTime2` int(11) DEFAULT 0,
`aKillOtherTribe` int(11) DEFAULT 0,
`aName` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
`aTribe` int(11) DEFAULT 0,
`aPreviousTribe` int(11) DEFAULT 0,
`aGender` int(11) DEFAULT 0,
`aHeadType` int(11) DEFAULT 0,
`aFaceType` int(11) DEFAULT 0,
`aLevel1` int(11) DEFAULT 1,
`aLevel2` int(11) DEFAULT 0,
`aGeneralExperience1` int(11) DEFAULT 0,
`aGeneralExperience2` int(11) DEFAULT 0,
`aVit` int(11) DEFAULT 1,
`aStr` int(11) DEFAULT 1,
`aInt` int(11) DEFAULT 1,
`aDex` int(11) DEFAULT 1,
`aEquip` varchar(325) COLLATE utf8_unicode_ci DEFAULT '',
`aLogoutInfo01` int(11) DEFAULT 0,
`aLogoutInfo02` int(11) DEFAULT 0,
`aLogoutInfo03` int(11) DEFAULT 0,
`aLogoutInfo04` int(11) DEFAULT 0,
`aLogoutInfo05` int(11) DEFAULT 0,
`aLogoutInfo06` int(11) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bonusinfo`
--

CREATE TABLE `bonusinfo` (
`uID` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`aName` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`aLevel` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `definemaxusernum`
--

CREATE TABLE `definemaxusernum` (
`mMaxUserNum` int(11) DEFAULT NULL,
`mAddPlayerNum` int(11) DEFAULT NULL,
`mGageUserNum` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `definemaxusernum`
--

INSERT INTO `definemaxusernum` (`mMaxUserNum`, `mAddPlayerNum`, `mGageUserNum`) VALUES
(1000, 1, 50);

-- --------------------------------------------------------

--
-- Table structure for table `guildeventinfo`
--

CREATE TABLE `guildeventinfo` (
`gName` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`Gscore` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `masterinfo`
--

CREATE TABLE `masterinfo` (
`uLoginState` int(1) DEFAULT 0,
`uIP` varchar(15) COLLATE utf8_unicode_ci DEFAULT '',
`uID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`uSaveMoney` int(11) NOT NULL DEFAULT 0,
`uSaveMoney2` int(11) NOT NULL DEFAULT 0,
`uSaveItem` varchar(700) COLLATE utf8_unicode_ci DEFAULT '',
`aName01` varchar(12) COLLATE utf8_unicode_ci DEFAULT '',
`aName02` varchar(12) COLLATE utf8_unicode_ci DEFAULT '',
`aName03` varchar(12) COLLATE utf8_unicode_ci DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `masterinfo`
--

INSERT INTO `masterinfo` (`uLoginState`, `uIP`, `uID`, `uSaveMoney`, `uSaveMoney2`, `uSaveItem`, `aName01`, `aName02`, `aName03`) VALUES
(0, '127.0.0.1', 'test1', 0, 0, '0000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `memberinfo`
--

CREATE TABLE `memberinfo` (
`uID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`uPassword` varchar(30) COLLATE utf8_unicode_ci DEFAULT '',
`uMousePassword` varchar(4) COLLATE utf8_unicode_ci DEFAULT '',
`uBlockInfo` int(11) DEFAULT 0,
`uUserSort` int(1) DEFAULT 0,
`uTraceState` int(1) DEFAULT 0,
`uCash` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `memberinfo`
--

INSERT INTO `memberinfo` (`uID`, `uPassword`, `uMousePassword`, `uBlockInfo`, `uUserSort`, `uTraceState`, `uCash`) VALUES
('test1', '1234', '0000', 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `rank`
--

CREATE TABLE `rank` (
`uUpdateTime` date NOT NULL,
`uID` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`aName` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`aTribe` int(11) NOT NULL,
`aLevel` int(11) NOT NULL,
`aGeneralExperience` int(11) NOT NULL,
`aGuildName` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`aKillOtherTribe` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `worldinfo`
--

CREATE TABLE `worldinfo` (
`mZone38WinTribeDate` datetime NOT NULL,
`nZone38WinTribe` int(11) NOT NULL,
`mTribe1SymbolDate` datetime NOT NULL,
`mTribe1Symbol` int(11) NOT NULL,
`mTribe2SymbolDate` datetime NOT NULL,
`mTribe2Symbol` int(11) NOT NULL,
`mTribe3SymbolDate` datetime NOT NULL,
`mTribe3Symbol` int(11) NOT NULL,
`mMonsterSymbolDate` datetime NOT NULL,
`mMonsterSymbol` int(11) NOT NULL,
`mTribe1Point` int(11) NOT NULL,
`mTribe2Point` int(11) NOT NULL,
`mTribe3Point` int(11) NOT NULL,
`mCloseTime` int(11) NOT NULL,
`mCloseTribe` int(11) NOT NULL,
`mFormationCount` varchar(96) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mGetStoneCount` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mLostStoneCount` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mYongokCount` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe01Master` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe01SubMaster` varchar(144) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe2Master` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe2SubMaster` varchar(144) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe3Master` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe3SubMaster` varchar(144) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`tNotice01` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`tNotice02` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`tNotoce03` varchar(2000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `avatarinfo`
--
ALTER TABLE `avatarinfo`
ADD PRIMARY KEY (`aName`);

--
-- Indexes for table `masterinfo`
--
ALTER TABLE `masterinfo`
ADD PRIMARY KEY (`uID`);

--
-- Indexes for table `memberinfo`
--
ALTER TABLE `memberinfo`
ADD PRIMARY KEY (`uID`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT @[Only registered and activated users can see links. Click Here To Register...]CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS @[Only registered and activated users can see links. Click Here To Register...]CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION @[Only registered and activated users can see links. Click Here To Register...]COLLATION_CONNECTION */;