Convert .SQL file into .RB rails migration file

Fertiggestellt Veröffentlicht Jul 16, 2009 Bezahlt bei Lieferung
Fertiggestellt 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');

Ingenieurwesen MySQL PHP Projektmanagement Softwarearchitektur Testen von Software

Projekt-ID: #2804700

Über das Projekt

1 Vorschlag Remote Projekt Aktiv Jul 17, 2009

Vergeben an:

dzsk

See private message.

$85 USD in 1 Tag
(11 Bewertungen)
3.6