zRqwzu00

1use cars_federated;
2SELECT DISTINCT * 
3FROM user 
4INTO OUTFILE '/tmp/test.dump';
5
6DROP TABLE IF EXISTS `user`;
7CREATE TABLE `user` (
8  `service_user_id`             int(11)     unsigned     NOT NULL,
9  `user_cash`                   int(11)     unsigned     NOT NULL    DEFAULT 0,
10  `user_points`                 int(11)     unsigned     NOT NULL    DEFAULT 0,
11  `current_user_car_id`         int(11)     unsigned, 
12  `user_last_show_judging`      DATE                     NOT NULL    DEFAULT '0000-00-00',
13  `user_judgement_count`        TINYINT(11) unsigned     NOT NULL    DEFAULT 0,
14  PRIMARY KEY (`service_user_id`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8;
16
17LOCK TABLES `user` WRITE;
18
19LOAD DATA 
20INFILE '/tmp/test.dump' 
21INTO TABLE cars_federated.user;
22
23UNLOCK TABLES;