Convert .SQL file into .RB rails migration file
$100-500 USD
Bezahlt bei Lieferung
We are looking for someone to convert a mysql .SQL file into a .RB file that can be used within our migrations environment
## Deliverables
Below - we've included a small example. The final sql file contains between 5-8 tables to convert. This should provide you with an idea of what to do
CREATE TABLE IF NOT EXISTS `nav_header_note` (
`nav_header_note_id` int(11) unsigned NOT NULL auto_increment,
`nav_header_idx` int(11) NOT NULL,
`editedBy` varchar(20) NOT NULL,
`modified` datetime NOT NULL,
`navText` text NOT NULL,
`sortby` int(11) NOT NULL,
`ai_flag` enum('A','I') NOT NULL default 'A',
PRIMARY KEY (`nav_header_note_id`),
KEY `nav_header_idx` (`nav_header_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Dumping data for table `nav_header_note`
--
INSERT INTO `nav_header_note` (`nav_header_note_id`, `nav_header_idx`, `editedBy`, `modified`, `navText`, `sortby`, `ai_flag`) VALUES
(2, 1, 'user', '2009-07-06 10:57:23', 'this is my month info text', 1, 'A'),
(31, 2, 'user', '2009-07-08 14:02:25', 'std claims text', 1, 'A'),
(20, 3, 'user', '2009-07-08 13:48:52', 'This report is the number of claims made on a camera type phone', 1, 'A'),
(19, 78, 'user', '2009-07-03 14:51:47', 'refunds', 1, 'A');
Projekt-ID: #2804700