· 8 years ago · Apr 24, 2018, 12:00 PM
1## Migration
2class CreateDrivers < ActiveRecord::Migration
3 def self.up
4 create_table :drivers do |t|
5 t.column :login, :string
6 t.column :email, :string
7 t.column :crypted_password, :string, :limit => 40
8 t.column :salt, :string, :limit => 40
9 t.column :created_at, :datetime
10 t.column :updated_at, :datetime
11 t.column :remember_token, :string
12 t.column :remember_token_expires_at, :datetime
13 t.column :first_name, :string
14 t.column :last_name, :string
15 t.column :city, :string
16 t.column :state, :string
17 t.column :zip, :integer
18 end
19
20 driver = Driver.new(:login => "collink", :email => "collin@slidenation.com", :password => "collin", :first_name => "Collin", :last_name => "Klopfenstein", :state => "AL", :city => "Huntsville", :zip => 35824)
21 if driver.save
22 puts "-- create_driver(:collink)"
23 else
24 puts "-- create_driver(:collink) - error: unable to create driver"
25 end
26 end
27
28 def self.down
29 drop_table "drivers"
30 end
31end
32
33## Log (plain_text)
34WARNING: You're using the Ruby-based MySQL library that ships with Rails. This library is not suited for production. Please install the C-based MySQL library instead (gem install mysql).
35 SQL (0.000194) SET NAMES 'utf8'
36 SQL (0.000186) SET SQL_AUTO_IS_NULL=0
37 SQL (0.000000) Mysql::Error: #42S01Table 'schema_info' already exists: CREATE TABLE `schema_info` (version int(11))
38 SQL (0.000000) Mysql::Error: #42S01Table 'schema_info' already exists: CREATE TABLE `schema_info` (version int(11))
39 SQL (0.000548) SELECT version FROM schema_info
40Migrating to CreateDrivers (1)
41 SQL (0.003485) CREATE TABLE `drivers` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `login` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `crypted_password` varchar(40) DEFAULT NULL, `salt` varchar(40) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `remember_token` varchar(255) DEFAULT NULL, `remember_token_expires_at` datetime DEFAULT NULL, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `zip` int(11) DEFAULT NULL) ENGINE=InnoDB
42 Driver Columns (0.003369) SHOW FIELDS FROM `drivers`
43 SQL (0.000210) BEGIN
44 Driver Load (0.001084) SELECT * FROM `drivers` WHERE (LOWER(drivers.login) = 'collink') LIMIT 1
45 Driver Load (0.000975) SELECT * FROM `drivers` WHERE (LOWER(drivers.email) = 'collin@slidenation.com') LIMIT 1
46 SQL (0.000400) COMMIT
47 SQL (0.000853) UPDATE schema_info SET version = 1
48 SQL (0.000823) SELECT version FROM schema_info
49Migrating to CreateVehicles (2)
50 SQL (0.016784) CREATE TABLE `vehicles` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `driver_id` int(11) DEFAULT NULL, `year` int(11) DEFAULT NULL, `make` varchar(255) DEFAULT NULL, `model` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL) ENGINE=InnoDB
51 Vehicle Columns (0.002992) SHOW FIELDS FROM `vehicles`
52 SQL (0.000261) BEGIN
53 Vehicle Create (0.000488) INSERT INTO `vehicles` (`driver_id`, `updated_at`, `make`, `year`, `model`, `created_at`) VALUES(1, '2008-04-07 18:24:21', 'Toyota', 1987, 'Supra (Turbo)', '2008-04-07 18:24:21')
54 SQL (0.000885) COMMIT
55 SQL (0.000568) UPDATE schema_info SET version = 2
56 SQL (0.000921) SELECT * FROM schema_info
57 SQL (0.000728) SHOW TABLES
58 SQL (0.003230) SHOW FIELDS FROM `drivers`
59 SQL (0.004152) describe `drivers`
60 SQL (0.004926) SHOW KEYS FROM `drivers`
61 SQL (0.003729) SHOW FIELDS FROM `vehicles`
62 SQL (0.017211) describe `vehicles`
63 SQL (0.001154) SHOW KEYS FROM `vehicles`