khai báo như sau :
CREATE TABLE IF NOT EXISTS `alliance` (
`allianceId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公会ID ',
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '帮会名字',
`playerId` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者(帮主)',
`state` int(5) NOT NULL COMMENT '工会的状态',
`camp` int(5) NOT NULL DEFAULT '0' COMMENT '帮派所属阵营',
`notice` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '公告信息',
`level` int(5) NOT NULL DEFAULT '0' COMMENT '工会等级',
`prestige` int(5) NOT NULL DEFAULT '0' COMMENT '威望值',
`silver` bigint(20) NOT NULL DEFAULT '0' COMMENT '资金',
`tokenPropsCount` int(5) NOT NULL DEFAULT '0' COMMENT '捐献的令牌',
`prolawNum` int(5) NOT NULL DEFAULT '0' COMMENT ' 护法人数',
`elderNum` int(5) NOT NULL COMMENT '长老人数',
`deputymasterNum` int(5) NOT NULL DEFAULT '0' COMMENT '副帮主',
`vilidaState` int(5) NOT NULL DEFAULT '0' COMMENT '帮派设置验证状态',
`masterName` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '帮主的名字',
`booksLevel` int(5) NOT NULL DEFAULT '0' COMMENT '藏经阁等级',
`shopLevel` int(5) NOT NULL DEFAULT '0' COMMENT '商店等级',
`daisLevel` int(5) NOT NULL DEFAULT '0' COMMENT '祭台等级',
`arenaLevel` int(5) NOT NULL DEFAULT '0' COMMENT '演舞台等级',
`skills` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '帮派研究所获得技能',
`levelupRecord` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '帮派升级记录',
`levelActive` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '冲级活动,帮主已领取的奖励列表',
PRIMARY KEY (`allianceId`),
KEY `IDX_ALLIANCE_STATE` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
Ai coi thử sai chỗ nào chỉ vs ..................
[You must be registered and logged in to see this link.]
CREATE TABLE IF NOT EXISTS `alliance` (
`allianceId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公会ID ',
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '帮会名字',
`playerId` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者(帮主)',
`state` int(5) NOT NULL COMMENT '工会的状态',
`camp` int(5) NOT NULL DEFAULT '0' COMMENT '帮派所属阵营',
`notice` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '公告信息',
`level` int(5) NOT NULL DEFAULT '0' COMMENT '工会等级',
`prestige` int(5) NOT NULL DEFAULT '0' COMMENT '威望值',
`silver` bigint(20) NOT NULL DEFAULT '0' COMMENT '资金',
`tokenPropsCount` int(5) NOT NULL DEFAULT '0' COMMENT '捐献的令牌',
`prolawNum` int(5) NOT NULL DEFAULT '0' COMMENT ' 护法人数',
`elderNum` int(5) NOT NULL COMMENT '长老人数',
`deputymasterNum` int(5) NOT NULL DEFAULT '0' COMMENT '副帮主',
`vilidaState` int(5) NOT NULL DEFAULT '0' COMMENT '帮派设置验证状态',
`masterName` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '帮主的名字',
`booksLevel` int(5) NOT NULL DEFAULT '0' COMMENT '藏经阁等级',
`shopLevel` int(5) NOT NULL DEFAULT '0' COMMENT '商店等级',
`daisLevel` int(5) NOT NULL DEFAULT '0' COMMENT '祭台等级',
`arenaLevel` int(5) NOT NULL DEFAULT '0' COMMENT '演舞台等级',
`skills` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '帮派研究所获得技能',
`levelupRecord` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '帮派升级记录',
`levelActive` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '冲级活动,帮主已领取的奖励列表',
PRIMARY KEY (`allianceId`),
KEY `IDX_ALLIANCE_STATE` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
Ai coi thử sai chỗ nào chỉ vs ..................
[You must be registered and logged in to see this link.]