--source include/have_innodb.inc

--disable_query_log
CREATE TABLE `scj_tt_ships` (
`scj_ships_id` int(11) NOT NULL auto_increment primary key,
`id_product` smallint(5) unsigned NOT NULL,
`amount` decimal(12,6) NOT NULL DEFAULT '0.000000',
`price` decimal(12,6) NOT NULL DEFAULT '0.000000',
`id_client_tt` int(11) NOT NULL,
`id_ta` mediumint(8) unsigned NOT NULL DEFAULT '0',
`money` decimal(16,6) NOT NULL DEFAULT '0.000000',
KEY `scj_ships_id` (`scj_ships_id`),
KEY `id_client_tt` (`id_client_tt`),
KEY `id_product` (`id_product`)
) ENGINE=InnoDB;

--disable_warnings
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) values (rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128);
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select rand()*10000%1024, rand()*10000%2048, rand()*10000%256, rand()*10000%1024, rand()*10000%1024, rand()*10000%128 from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select id_product, amount, price, id_client_tt, id_ta, `money` from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select id_product, amount, price, id_client_tt, id_ta, `money` from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select id_product, amount, price, id_client_tt, id_ta, `money` from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select id_product, amount, price, id_client_tt, id_ta, `money` from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select id_product, amount, price, id_client_tt, id_ta, `money` from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select id_product, amount, price, id_client_tt, id_ta, `money` from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select id_product, amount, price, id_client_tt, id_ta, `money` from scj_tt_ships;
insert into scj_tt_ships (id_product, amount, price, id_client_tt, id_ta, `money`) select id_product, amount, price, id_client_tt, id_ta, `money` from scj_tt_ships;
--enable_warnings
--enable_query_log

select now();
create temporary table norepl_t1 engine=myisam select amount, price, money, id_product from scj_tt_ships;
#where scj_ships_id between 200000 and 400000; 
select now();