Witam do zlecania mam przekopiowanie blisko 2500 tyś. użytkowników z ich hasłami i adresami e-mail z bazy portalu do bazy forum phpbb3.
Poniżej przedstawiam strukturę obydwu tabel:
--
-- Struktura tabeli dla `pm_users`
--
CREATE TABLE `pm_users` (
`id` int(5) NOT NULL auto_increment,
`username` varchar(100) NOT NULL default \'\',
`password` varchar(100) NOT NULL default \'\',
`name` varchar(150) NOT NULL default \'\',
`gender` varchar(10) NOT NULL default \'\',
`country` varchar(50) NOT NULL default \'\',
`reg_ip` varchar(20) NOT NULL default \'\',
`reg_date` varchar(12) NOT NULL default \'\',
`last_signin` varchar(12) NOT NULL default \'\',
`email` varchar(150) NOT NULL default \'\',
`favorite` enum(\'0\',\'1\') NOT NULL default \'1\',
`power` enum(\'0\',\'1\',\'2\') NOT NULL default \'0\',
`about` text NOT NULL,
`avatar` varchar(255) NOT NULL default \'[login to view URL]\',
`activation_key` varchar(20) NOT NULL default \'\',
`new_password` varchar(32) NOT NULL default \'\',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=2430 ;
--
-- Zrzut danych tabeli `pm_users`
--
INSERT INTO `pm_users` VALUES (1, \'sLAm\', \'9a12a6fc1772f75b025d90f5d5dc0a59\', \'Administrator\', \'male\', \'500\', \'\', \'1191150508\', \'1234295698\', \'kontakt@[login to view URL]\', \'1\', \'1\', \'\', \'[login to view URL]\', \'\', \'\');
W tej tabeli jest blisko 2500 tys. rekordów z użytkownikami, przedstawilem tylko 1 rekord z zmienionymi danymi.
Dane z powyższej tabeli nalezy przenieśc do tabeli poniższej:
--
-- Baza danych: `pawel_video`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `phpbb_users`
--
CREATE TABLE `phpbb_users` (
`user_id` mediumint(8) unsigned NOT NULL auto_increment,
`user_type` tinyint(2) NOT NULL default \'0\',
`group_id` mediumint(8) unsigned NOT NULL default \'3\',
`user_permissions` mediumblob NOT NULL,
`user_perm_from` mediumint(8) unsigned NOT NULL default \'0\',
`user_ip` varchar(40) binary NOT NULL default \'\',
`user_regdate` int(11) unsigned NOT NULL default \'0\',
`username` blob NOT NULL,
`username_clean` blob NOT NULL,
`user_password` varchar(120) binary NOT NULL default \'\',
`user_passchg` int(11) unsigned NOT NULL default \'0\',
`user_pass_convert` tinyint(1) unsigned NOT NULL default \'0\',
`user_email` blob NOT NULL,
`user_email_hash` bigint(20) NOT NULL default \'0\',
`user_birthday` varchar(10) binary NOT NULL default \'\',
`user_lastvisit` int(11) unsigned NOT NULL default \'0\',
`user_lastmark` int(11) unsigned NOT NULL default \'0\',
`user_lastpost_time` int(11) unsigned NOT NULL default \'0\',
`user_lastpage` blob NOT NULL,
`user_last_confirm_key` varchar(10) binary NOT NULL default \'\',
`user_last_search` int(11) unsigned NOT NULL default \'0\',
`user_warnings` tinyint(4) NOT NULL default \'0\',
`user_last_warning` int(11) unsigned NOT NULL default \'0\',
`user_login_attempts` tinyint(4) NOT NULL default \'0\',
`user_inactive_reason` tinyint(2) NOT NULL default \'0\',
`user_inactive_time` int(11) unsigned NOT NULL default \'0\',
`user_posts` mediumint(8) unsigned NOT NULL default \'0\',
`user_lang` varchar(30) binary NOT NULL default \'\',
`user_timezone` decimal(5,2) NOT NULL default \'0.00\',
`user_dst` tinyint(1) unsigned NOT NULL default \'0\',
`user_dateformat` varchar(90) binary NOT NULL default \'d M Y H:i\',
`user_style` mediumint(8) unsigned NOT NULL default \'0\',
`user_rank` mediumint(8) unsigned NOT NULL default \'0\',
`user_colour` varchar(6) binary NOT NULL default \'\',
`user_new_privmsg` int(4) NOT NULL default \'0\',
`user_unread_privmsg` int(4) NOT NULL default \'0\',
`user_last_privmsg` int(11) unsigned NOT NULL default \'0\',
`user_message_rules` tinyint(1) unsigned NOT NULL default \'0\',
`user_full_folder` int(11) NOT NULL default \'-3\',
`user_emailtime` int(11) unsigned NOT NULL default \'0\',
`user_topic_show_days` smallint(4) unsigned NOT NULL default \'0\',
`user_topic_sortby_type` char(1) binary NOT NULL default \'t\',
`user_topic_sortby_dir` char(1) binary NOT NULL default \'d\',
`user_post_show_days` smallint(4) unsigned NOT NULL default \'0\',
`user_post_sortby_type` char(1) binary NOT NULL default \'t\',
`user_post_sortby_dir` char(1) binary NOT NULL default \'a\',
`user_notify` tinyint(1) unsigned NOT NULL default \'0\',
`user_notify_pm` tinyint(1) unsigned NOT NULL default \'1\',
`user_notify_type` tinyint(4) NOT NULL default \'0\',
`user_allow_pm` tinyint(1) unsigned NOT NULL default \'1\',
`user_allow_viewonline` tinyint(1) unsigned NOT NULL default \'1\',
`user_allow_viewemail` tinyint(1) unsigned NOT NULL default \'1\',
`user_allow_massemail` tinyint(1) unsigned NOT NULL default \'1\',
`user_options` int(11) unsigned NOT NULL default \'895\',
`user_avatar` varchar(255) binary NOT NULL default \'\',
`user_avatar_type` tinyint(2) NOT NULL default \'0\',
`user_avatar_width` smallint(4) unsigned NOT NULL default \'0\',
`user_avatar_height` smallint(4) unsigned NOT NULL default \'0\',
`user_sig` mediumblob NOT NULL,
`user_sig_bbcode_uid` varchar(8) binary NOT NULL default \'\',
`user_sig_bbcode_bitfield` varchar(255) binary NOT NULL default \'\',
`user_from` blob NOT NULL,
`user_icq` varchar(15) binary NOT NULL default \'\',
`user_aim` blob NOT NULL,
`user_yim` blob NOT NULL,
`user_msnm` blob NOT NULL,
`user_jabber` blob NOT NULL,
`user_website` blob NOT NULL,
`user_occ` blob NOT NULL,
`user_interests` blob NOT NULL,
`user_actkey` varchar(32) binary NOT NULL default \'\',
`user_newpasswd` varchar(120) binary NOT NULL default \'\',
`user_form_salt` varchar(96) binary NOT NULL default \'\',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username_clean` (`username_clean`(255)),
KEY `user_birthday` (`user_birthday`),
KEY `user_email_hash` (`user_email_hash`),
KEY `user_type` (`user_type`)
) TYPE=MyISAM AUTO_INCREMENT=58 ;
--
-- Zrzut danych tabeli `phpbb_users`
--
INSERT INTO `phpbb_users` VALUES (37, 2, 6, \'\', 0, \'\', 1239190794, 0x53454f536561726368205b437261776c65725d, 0x73656f736561726368205b637261776c65725d, \'\', 1239190794, 0, \'\', 0, \'\', 0, 1239190794, 0, \'\', \'\', 0, 0, 0, 0, 0, 0, 0, 0x706c, 0.00, 0, 0x44204d20642c205920673a692061, 1, 0, 0x394538444137, 0, 0, 0, 0, -3, 0, 0, 0x74, 0x64, 0, 0x74, 0x61, 0, 1, 0, 1, 1, 1, 0, 895, \'\', 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', 0x30643832306135633436656164313436);
Tu nazwa użytkownika jak i inne dane są kodowana w czymś tam (ja się nie znam), w obydwu przypadkach hasła są kodowane w md5, zależy mi na przeniesieniu takich danych jak: login, hasło, e-mail, data rejestracji. reszta mnie nie interesuje...
Prosze składać oferty wraz z okresleniem terminu wykonania. Wyłoniony zwycięzca otrzyma zrzut całej tabeli do przeniesienia.