· 6 years ago · Jan 26, 2020, 07:26 AM
1[SQL] Query SqlDB start
2[ERR] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
3[ERR] /*
4SQLyog Ultimate v12.09 (64 bit)
5MySQL - 5.7.28-log : Database - conquer3
6*********************************************************************
7*/
8
9
10/*!40101 SET NAMES utf8 */;
11
12/*!40101 SET SQL_MODE=''*/;
13
14/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18CREATE DATABASE /*!32312 IF NOT EXISTS*/`conquer3` /*!40100 DEFAULT CHARACTER SET latin1 */;
19
20USE `conquer3`;
21
22/*Table structure for table `__efmigrationshistory` */
23
24DROP TABLE IF EXISTS `__efmigrationshistory`;
25
26CREATE TABLE `__efmigrationshistory` (
27 `MigrationId` varchar(95) NOT NULL,
28 `ProductVersion` varchar(32) NOT NULL,
29 PRIMARY KEY (`MigrationId`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31
32/*Data for the table `__efmigrationshistory` */
33
34insert into `__efmigrationshistory`(`MigrationId`,`ProductVersion`) values ('20200112182344_InitialCreate','3.1.0'),('20200112182626_AccountTable','3.1.0'),('20200114132520_PlayerTable','3.1.0'),('20200114133739_PlayerTableAccountId','3.1.0'),('20200114140517_PlayerTableProfession','3.1.0'),('20200115170610_MapDataTable','3.1.0'),('20200115172956_PasswaysPortals','3.1.0'),('20200115173856_Npcs','3.1.0'),('20200116141634_MonsterAndGenTable','3.1.0'),('20200120103919_LevelExpTable','3.1.0'),('20200120104646_PlayerItemsTable','3.1.0'),('20200120104742_ItemTypeTable','3.1.0'),('20200120111505_PlayerItemsTableStack','3.1.0'),('20200121130345_AllotPointsTable','3.1.0'),('20200121132921_ItemAdditionTable','3.1.0'),('20200121172837_MagicTypeTable','3.1.0'),('20200121174008_PlayerSkillTable','3.1.0'),('20200122144312_GoodsTable','3.1.0'),('20200123185044_AssociatesTable','3.1.0'),('20200123193718_ActionsTable','3.1.0'),('20200123201516_PlayerActionStateTable','3.1.0');
35
36/*Table structure for table `accounts` */
37
38DROP TABLE IF EXISTS `accounts`;
39
40CREATE TABLE `accounts` (
41 `Id` int(11) NOT NULL AUTO_INCREMENT,
42 `Username` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL,
43 `Password` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL,
44 `Banned` datetime(6) NOT NULL,
45 `Vip` int(11) NOT NULL,
46 PRIMARY KEY (`Id`)
47) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
48
49/*Data for the table `accounts` */
50
51insert into `accounts`(`Id`,`Username`,`Password`,`Banned`,`Vip`) values (1,'test','test','2019-12-31 19:35:58.000000',0),(2,'test2','test2','2020-01-06 15:34:21.000000',0),(3,'test1234','test1234','2020-01-06 20:22:22.000000',0);
52
53/*Table structure for table `allotpoints` */
54
55DROP TABLE IF EXISTS `allotpoints`;
56
57CREATE TABLE `allotpoints` (
58 `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
59 `Profession` int(10) unsigned NOT NULL,
60 `Level` int(10) unsigned NOT NULL,
61 `Force` int(10) unsigned NOT NULL,
62 `Speed` int(10) unsigned NOT NULL,
63 `Health` int(10) unsigned NOT NULL,
64 `Soul` int(10) unsigned NOT NULL,
65 PRIMARY KEY (`Id`)
66) ENGINE=InnoDB AUTO_INCREMENT=963 DEFAULT CHARSET=latin1;
67
68/*Data for the table `allotpoints` */
69
70insert into `allotpoints`(`Id`,`Profession`,`Level`,`Force`,`Speed`,`Health`,`Soul`) values (2,1,2,7,2,4,0),(3,1,3,8,3,5,0),(4,1,4,10,4,5,0),(5,1,5,11,5,6,0),(6,1,6,13,5,7,0),(7,1,7,14,6,8,0),(8,1,8,16,6,9,0),(9,1,9,17,7,10,0),(10,1,10,19,7,11,0),(11,1,11,20,8,12,0),(12,1,12,22,8,13,0),(13,1,13,23,9,14,0),(14,1,14,25,10,14,0),(15,1,15,28,10,14,0),(16,1,16,28,11,16,0),(17,1,17,29,12,17,0),(18,1,18,31,12,18,0),(19,1,19,32,13,19,0),(20,1,20,34,13,20,0),(21,1,21,35,14,21,0),(22,1,22,37,14,22,0),(23,1,23,38,15,23,0),(24,1,24,40,15,24,0),(25,1,25,41,16,25,0),(26,1,26,43,17,25,0),(27,1,27,44,18,26,0),(28,1,28,46,18,27,0),(29,1,29,47,19,28,0),(30,1,30,49,19,29,0),(31,1,31,50,20,30,0),(32,1,32,52,20,31,0),(33,1,33,53,21,32,0),(34,1,34,55,21,33,0),(35,1,35,56,22,34,0),(36,1,36,58,23,34,0),(37,1,37,59,24,35,0),(38,1,38,61,24,36,0),(39,1,39,62,25,37,0),(40,1,40,65,25,37,0),(41,1,41,65,26,39,0),(42,1,42,67,26,40,0),(43
71[SQL] Finished with error