ALTER TABLE `TABLE 12` CHANGE `COL 1` `id` INT( 1 ) NULL DEFAULT NULL ;
ALTER TABLE `TABLE 12` CHANGE `COL 2` `position` INT( 1 ) NULL DEFAULT NULL ;
ALTER TABLE `TABLE 12` CHANGE `COL 3` `num_data` INT( 2 ) NULL DEFAULT NULL ;
ALTER TABLE `TABLE 12` CHANGE `COL 4` `name` VARCHAR( 12 ) CHARACTER SET utf8 COLLATE;
ALTER TABLE `TABLE 13` CHANGE `COL 1` `id` INT( 2 ) NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 2` `catID` INT( 1 ) NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 3` `year` INT( 4 ) NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 4` `month` INT( 1 ) NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 5` `day` INT( 2 ) NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 11` `author` VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 12` `title` VARCHAR( 103 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `TABLE 13` CHANGE `COL 13` `brief` VARCHAR( 1107 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 14` `message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 29` `sbscr` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
ALTER TABLE `TABLE 13` CHANGE `COL 22` `tegs` VARCHAR( 87 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
delete from wp_terms;
INSERT INTO `wp_terms`(`term_id`, `name`, `slug`) select id, name, name from `TABLE 12`;
delete from wp_term_taxonomy;
INSERT INTO `wp_term_taxonomy`( `term_id`, `taxonomy`) select id, 'category' from `TABLE 12`
delete from wp_posts;
INSERT INTO `wp_posts` ( `ID` , `post_author` , post_title, post_date, `post_content` , `post_status`,post_name )
SELECT id, 1, title, date( year *10000 + MONTH *100 + DAY ) , message, 'draft', `sbscr` FROM `TABLE 13`
DELETE FROM `wp_term_relationships` ;
INSERT INTO `wp_term_relationships`(`object_id`, `term_taxonomy_id`)
SELECT b.id, term_taxonomy_id FROM `wp_term_taxonomy` as tt
left join `TABLE 13` as b on tt.term_id = b.catid
Дорогой Гость, Не упустите супер шанс!
Ошеломительное снижение на ПОЖИЗНЕННЫЙ статус "СВОЙ"
по цене 1 месяца за 499 руб.
Это доступ ко всем:
Цена всего для 1000 человек. Осталось 14 мест.
Позже цена уже удвоиться!
Не тяните и успейте получить доступ к всему по выгодной цене!