[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)
drop the DB:
ReplyDeleterake db:drop
create DB:
rake db:create
create table:
rake db:migrate