Project

General

Profile

RE: Export/Import MySQL project » table_from_to.sql

script to create temporary tables - Bruno Medeiros, 2010-12-20 18:33

 
1
CREATE TABLE  `redmine_migrate`.`attachment_from_to` (
2
  `id_from` int(11) NOT NULL,
3
  `id_to` int(11) NOT NULL,
4
  PRIMARY KEY (`id_from`)
5
) ENGINE=MyISAM DEFAULT CHARSET=latin1
6

    
7
CREATE TABLE  `redmine_migrate`.`issue_from_to` (
8
  `id_from` int(11) NOT NULL,
9
  `id_to` int(11) NOT NULL,
10
  PRIMARY KEY (`id_from`)
11
) ENGINE=MyISAM DEFAULT CHARSET=latin1
12

    
13
CREATE TABLE  `redmine_migrate`.`journal_from_to` (
14
  `id_from` int(11) NOT NULL,
15
  `id_to` int(11) NOT NULL,
16
  PRIMARY KEY (`id_from`)
17
) ENGINE=MyISAM DEFAULT CHARSET=latin1
18

    
19
CREATE TABLE  `redmine_migrate`.`user_from_to` (
20
  `id_from` int(11) NOT NULL,
21
  `id_to` int(11) NOT NULL,
22
  PRIMARY KEY (`id_from`)
23
) ENGINE=MyISAM DEFAULT CHARSET=latin1
(4-4/8)