Tuesday, December 4, 2012

ruby - create a resource / table

[cg@centos63 virusdepot]$ rails generate scaffold Viursdb id:integer docid:integer severity:string vname:string vtype:string discovered:string vlink:string vendor:string summary:text details:text






[cg@centos63 virusdepot]$ rake db:migrate
==  CreateViursdbs: migrating =================================================
-- create_table(:viursdbs)
   -> 0.1339s
==  CreateViursdbs: migrated (0.1342s) ========================================


mysql> desc viursdbs;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| id         | int(11)      | NO   | PRI | NULL    | auto_increment |
| docid      | int(11)      | YES  |     | NULL    |                |
| severity   | varchar(255) | YES  |     | NULL    |                |
| vname      | varchar(255) | YES  |     | NULL    |                |
| vtype      | varchar(255) | YES  |     | NULL    |                |
| discovered | varchar(255) | YES  |     | NULL    |                |
| vlink      | varchar(255) | YES  |     | NULL    |                |
| vendor     | varchar(255) | YES  |     | NULL    |                |
| summary    | text         | YES  |     | NULL    |                |
| details    | text         | YES  |     | NULL    |                |
| created_at | datetime     | NO   |     | NULL    |                |
| updated_at | datetime     | NO   |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)

1 comment:

  1. drop the DB:
    rake db:drop

    create DB:
    rake db:create

    create table:
    rake db:migrate

    ReplyDelete