Ruby on Rails equivalent code for mysql

Rails
1

Sometimes ago I created database and a table in MySQL with these
statements :

CREATE DATABASE amiref;
USE amiref;
CREATE TABLE refoo
(
f1 VARCHAR(20) ,
f2 VARCHAR(30) NOT NULL ,
f3 INT ,
PRIMARY KEY(f1)
);
CREATE TABLE IF NOT EXISTS users
(
user_id1 VARCHAR(20) NOT NULL ,
user_id2 VARCHAR(50) ,
password VARCHAR(30) ,
email VARCHAR(50) ,
PRIMARY KEY(user_id1,user_id2)
);
now I want to create those database and tables in ruby on rail with
model. how can I do it? please help me. thanks

2

On Mon, Jan 9, 2012 at 1:41 PM, amir a. [email protected] wrote:

PRIMARY KEY(f1)
model. how can I do it? please help me. thanks

google for “rails guide migrations”

Peter

3

amir a. wrote in post #1040065:

CREATE DATABASE amiref;
USE amiref;
CREATE TABLE refoo
(
f1 VARCHAR(20) ,
f2 VARCHAR(30) NOT NULL ,
f3 INT ,
PRIMARY KEY(f1)
);
CREATE TABLE IF NOT EXISTS users
(
user_id1 VARCHAR(20) NOT NULL ,
user_id2 VARCHAR(50) ,
password VARCHAR(30) ,
email VARCHAR(50) ,
PRIMARY KEY(user_id1,user_id2)
);
now I want to create those database and tables in ruby on rail with
model. how can I do it? please help me. thanks

First I’ll reiterate to read the Rails guide. It explains everything you
need to know:

However, I just wanted to add my strong suggestion that you DO NOT
recreate these tables as you show them here. They are really poorly
designed for use with Rails.

You’ll learn about the right way to do it by reading the Rails guides.

4

you want to create a database in ruby on rails…
You must first know that you dont need to create database anymore. just
create tables and by default the rails will place your table in a
developtment.yml I think.

well this is the code on how to generate a table

you type this in your cmd inside the project directory you’ve created

cmd> rails generate scaffold table_name field_name:string
field_name2:integer field_name3:float

after it runs type this command

cmd> rake db:migration

then
cmd >rails server

then you have a model for your table table_name with a fields of
field_name1 field_name2 field_name3 id created_at and updated_at

hope this helped…