Изгнанные
Регистрация: 06.04.2008
Сообщений: 64
Отблагодарили 3 раз(а)
Рейтинг мнений:
|
Ответ: Перенос БД, как правельно осуществить?
Старая БД, таблица characters:
Код:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: s1
Target Host: localhost
Target Database: s1
Date: 27.04.2008 22:41:11
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
`account_name` varchar(45) default NULL,
`obj_Id` decimal(11,0) NOT NULL default '0',
`char_name` varchar(35) NOT NULL,
`level` decimal(11,0) default NULL,
`maxHp` decimal(11,0) default NULL,
`curHp` decimal(18,0) default NULL,
`maxCp` decimal(11,0) default NULL,
`curCp` decimal(18,0) default NULL,
`maxMp` decimal(11,0) default NULL,
`curMp` decimal(18,0) default NULL,
`acc` decimal(11,0) default NULL,
`crit` decimal(10,0) default NULL,
`evasion` decimal(11,0) default NULL,
`mAtk` decimal(11,0) default NULL,
`mDef` decimal(11,0) default NULL,
`mSpd` decimal(11,0) default NULL,
`pAtk` decimal(11,0) default NULL,
`pDef` decimal(11,0) default NULL,
`pSpd` decimal(11,0) default NULL,
`runSpd` decimal(11,0) default NULL,
`walkSpd` decimal(11,0) default NULL,
`str` decimal(11,0) default NULL,
`con` decimal(11,0) default NULL,
`dex` decimal(11,0) default NULL,
`_int` decimal(11,0) default NULL,
`men` decimal(11,0) default NULL,
`wit` decimal(11,0) default NULL,
`face` decimal(11,0) default NULL,
`hairStyle` decimal(11,0) default NULL,
`hairColor` decimal(11,0) default NULL,
`sex` decimal(11,0) default NULL,
`heading` decimal(11,0) default NULL,
`x` decimal(11,0) default NULL,
`y` decimal(11,0) default NULL,
`z` decimal(11,0) default NULL,
`movement_multiplier` decimal(9,8) default NULL,
`attack_speed_multiplier` decimal(10,9) default NULL,
`colRad` decimal(10,3) default NULL,
`colHeight` decimal(10,3) default NULL,
`exp` decimal(20,0) default NULL,
`expBeforeDeath` decimal(20,0) default '0',
`sp` decimal(11,0) default NULL,
`karma` decimal(11,0) default NULL,
`pvpkills` decimal(11,0) default NULL,
`pkkills` decimal(11,0) default NULL,
`clanid` decimal(11,0) default NULL,
`maxload` decimal(11,0) default NULL,
`race` decimal(11,0) default NULL,
`classid` decimal(11,0) default NULL,
`base_class` int(2) NOT NULL default '0',
`deletetime` decimal(20,0) default NULL,
`cancraft` decimal(11,0) default NULL,
`title` varchar(16) default NULL,
`rec_have` int(3) NOT NULL default '0',
`rec_left` int(3) NOT NULL default '0',
`accesslevel` decimal(4,0) default NULL,
`online` decimal(1,0) default NULL,
`onlinetime` decimal(20,0) default NULL,
`char_slot` decimal(1,0) default NULL,
`newbie` decimal(1,0) default '1',
`lastAccess` decimal(20,0) default NULL,
`clan_privs` int(11) default '0',
`wantspeace` decimal(1,0) default '0',
`isin7sdungeon` decimal(1,0) NOT NULL default '0',
`in_jail` decimal(1,0) default '0',
`jail_timer` decimal(20,0) default '0',
`power_grade` decimal(11,0) default NULL,
`nobless` decimal(1,0) NOT NULL default '0',
`subpledge` int(1) NOT NULL default '0',
`last_recom_date` decimal(20,0) NOT NULL default '0',
`lvl_joined_academy` int(1) NOT NULL default '0',
`apprentice` int(1) NOT NULL default '0',
`sponsor` int(1) NOT NULL default '0',
`varka_ketra_ally` int(1) NOT NULL default '0',
`clan_join_expiry_time` decimal(20,0) NOT NULL default '0',
`clan_create_expiry_time` decimal(20,0) NOT NULL default '0',
`death_penalty_level` int(2) NOT NULL default '0',
`chatban_timer` decimal(20,0) default '0',
`chatban_reason` varchar(255) NOT NULL default '',
PRIMARY KEY (`obj_Id`),
KEY `clanid` (`clanid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `characters` VALUES ('maqwecka', '268478691', 'Kornnwern', '4', '200', '200', '139', '139', '61', '61', '33', '40', '33', '3', '48', '203', '4', '72', '327', '125', '87', '39', '45', '29', '20', '27', '10', '2', '0', '2', '0', '51384', '108549', '-174082', '-415', '1.00000000', '1.000000000', '9.000', '18.000', '1450', '0', '300', '0', '0', '0', '0', '115291', '4', '53', '53', '0', '0', '', '0', '0', '0', '0', '273', null, '1', '1207927439601', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `characters` VALUES ('leon', '268478712', '[GM]KeMn', '76', '4587', '4587', '2750', '2750', '1527', '1527', '33', '40', '33', '3', '47', '213', '4', '72', '330', '126', '88', '40', '43', '30', '21', '25', '11', '0', '0', '0', '0', '21221', '-84075', '243348', '-3730', '1.00000000', '1.000000000', '9.000', '23.000', '931275828', '6845505', '13671036', '0', '0', '0', '0', '108674', '0', '6', '6', '0', '0', '', '0', '9', '200', '0', '80818', null, '1', '1208677160156', '0', '0', '0', '0', '0', '1', '0', '0', '1208596164421', '0', '0', '0', '0', '0', '0', '0', '0', '');
Новая БД, таблица characters:
Код:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: tls10
Target Host: localhost
Target Database: tls10
Date: 27.04.2008 22:43:29
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
`account_name` varchar(45) default NULL,
`obj_Id` decimal(11,0) NOT NULL default '0',
`char_name` varchar(35) NOT NULL default '',
`level` decimal(11,0) default NULL,
`maxHp` decimal(11,0) default NULL,
`curHp` decimal(18,0) default NULL,
`maxCp` decimal(11,0) default NULL,
`curCp` decimal(18,0) default NULL,
`maxMp` decimal(11,0) default NULL,
`curMp` decimal(18,0) default NULL,
`acc` decimal(11,0) default NULL,
`crit` decimal(10,0) default NULL,
`evasion` decimal(11,0) default NULL,
`mAtk` decimal(11,0) default NULL,
`mDef` decimal(11,0) default NULL,
`mSpd` decimal(11,0) default NULL,
`pAtk` decimal(11,0) default NULL,
`pDef` decimal(11,0) default NULL,
`pSpd` decimal(11,0) default NULL,
`runSpd` decimal(11,0) default NULL,
`walkSpd` decimal(11,0) default NULL,
`str` decimal(11,0) default NULL,
`con` decimal(11,0) default NULL,
`dex` decimal(11,0) default NULL,
`_int` decimal(11,0) default NULL,
`men` decimal(11,0) default NULL,
`wit` decimal(11,0) default NULL,
`face` decimal(11,0) default NULL,
`hairStyle` decimal(11,0) default NULL,
`hairColor` decimal(11,0) default NULL,
`sex` decimal(11,0) default NULL,
`heading` decimal(11,0) default NULL,
`x` decimal(11,0) default NULL,
`y` decimal(11,0) default NULL,
`z` decimal(11,0) default NULL,
`movement_multiplier` decimal(9,8) default NULL,
`attack_speed_multiplier` decimal(10,9) default NULL,
`colRad` decimal(10,3) default NULL,
`colHeight` decimal(10,3) default NULL,
`exp` decimal(20,0) default NULL,
`expBeforeDeath` decimal(20,0) default '0',
`sp` decimal(11,0) default NULL,
`karma` decimal(11,0) default NULL,
`pvpkills` decimal(11,0) default NULL,
`pkkills` decimal(11,0) default NULL,
`clanid` decimal(11,0) default NULL,
`maxload` decimal(11,0) default NULL,
`race` decimal(11,0) default NULL,
`classid` decimal(11,0) default NULL,
`deletetime` decimal(20,0) default NULL,
`cancraft` decimal(11,0) default NULL,
`title` varchar(16) default NULL,
`rec_have` int(3) NOT NULL default '0',
`rec_left` int(3) NOT NULL default '0',
`accesslevel` decimal(4,0) default NULL,
`online` decimal(1,0) default NULL,
`char_slot` decimal(1,0) default NULL,
`lastAccess` decimal(20,0) default NULL,
`clan_privs` int(11) default '0',
`wantspeace` decimal(1,0) default '0',
`base_class` int(4) NOT NULL default '0',
`onlinetime` decimal(20,0) NOT NULL default '0',
`newbie` decimal(1,0) default '1',
`isin7sdungeon` decimal(1,0) default '0',
`in_jail` decimal(1,0) default '0',
`jail_timer` decimal(20,0) default '0',
`hero` decimal(1,0) NOT NULL default '0',
`nobless` decimal(2,0) NOT NULL default '0',
`varka_ketra_ally` int(1) NOT NULL default '0',
`pledge_rank` int(11) NOT NULL default '0',
`lvl_joined_academy` int(2) NOT NULL default '0',
`apprentice` int(1) NOT NULL default '0',
`sponsor` int(1) NOT NULL default '0',
`last_recom_date` decimal(20,0) NOT NULL default '0',
`banchat_timer` decimal(20,0) default '0',
`clan_join_expiry_time` decimal(20,0) NOT NULL default '0',
`clan_create_expiry_time` decimal(20,0) NOT NULL default '0',
`subpledge` int(1) NOT NULL default '0',
`charViP` decimal(1,0) NOT NULL default '0',
`is_donator` decimal(1,0) NOT NULL default '0',
`chatban_timer` decimal(20,0) default '0',
`chatban_reason` varchar(255) NOT NULL default '',
`autoloot_herbs` int(1) NOT NULL default '0',
`death_penalty_level` int(2) NOT NULL default '0',
`event_points` decimal(11,0) default NULL,
PRIMARY KEY (`obj_Id`),
KEY `clanid` (`clanid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
Как пример, что тут нужно сделать?
|