Class: ColumnFixes

Inherits:
ActiveRecord::Migration
  • Object
show all
Includes:
Goldberg::Migration
Defined in:
lib/six-updater-web/vendor/plugins/goldberg/db/migrate/004_column_fixes.rb

Class Method Summary collapse

Methods included from Goldberg::Migration

dump_bootstrap, dump_for_class, goldberg_classes, included, load_bootstrap, load_for_class

Class Method Details

.down ⇒ Object 



61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
 
# File 'lib/six-updater-web/vendor/plugins/goldberg/db/migrate/004_column_fixes.rb', line 61

def self.down
  change_column("#{prefix}users", 'name', :string,
                :default => '', :null => false)
  change_column("#{prefix}users", 'password', :string,
                :default => '', :null => false)
  change_column("#{prefix}users", 'role_id', :integer,
                :default => 0, :null => false)
  
  change_column("#{prefix}system_settings", 'site_name', :string,
                :default => '', :null => false)
  change_column("#{prefix}system_settings", 'public_role_id', :integer,
                :default => 0, :null => false)
  add_column("#{prefix}system_settings", 'default_markup_style_id', :integer,
             :default => 0)
  change_column("#{prefix}system_settings", 'site_default_page_id', :integer,
                :default => 0, :null => false)
  change_column("#{prefix}system_settings", 'not_found_page_id', :integer,
                :default => 0, :null => false)
  change_column("#{prefix}system_settings", 'permission_denied_page_id',
                :integer, :default => 0, :null => false)
  change_column("#{prefix}system_settings", 'session_expired_page_id',
                :integer, :default => 0, :null => false)

  change_column("#{prefix}roles_permissions", 'role_id', :integer,
                :default => 0, :null => false)
  change_column("#{prefix}roles_permissions", 'permission_id', :integer,
                :default => 0, :null => false)
  
  change_column("#{prefix}roles", 'name', :string,
                :default => '', :null => false)
  
  change_column("#{prefix}menu_items", 'name', :string,
                :default => '', :null => false)
  change_column("#{prefix}menu_items", 'label', :string,
                :default => '', :null => false)

  change_column("#{prefix}controller_actions", 'site_controller_id', :integer,
                :default => 0, :null => false)
  change_column("#{prefix}controller_actions", 'name', :string,
                :default => '', :null => false)

  change_column("#{prefix}content_pages", 'name', :string,
                :default => '', :null => false)
  change_column("#{prefix}content_pages", 'permission_id', :integer,
                :default => 0, :null => false)

  change_column("#{prefix}site_controllers", 'name', :string,
                :default => '', :null => false)
  change_column("#{prefix}site_controllers", 'permission_id', :integer,
                :default => 0, :null => false)
  
  change_column("#{prefix}permissions", 'name', :string,
                :default => '', :null => false)
  
  create_table "#{prefix}markup_styles", :force => false do |t|
    t.column "name", :string, :default => "", :null => false
  end
end

.up ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 
# File 'lib/six-updater-web/vendor/plugins/goldberg/db/migrate/004_column_fixes.rb', line 4

def self.up
  # Remove defaults from many compulsory columns, and drop obsolete
  # references to markup_styles
  drop_table "#{prefix}markup_styles"
  
  change_column("#{prefix}permissions", 'name', :string)
  
  change_column("#{prefix}site_controllers", 'name', :string,
                :default => nil)
  change_column("#{prefix}site_controllers", 'permission_id', :integer,
                :default => nil)
  
  change_column("#{prefix}content_pages", 'name', :string,
                :default => nil)
  change_column("#{prefix}content_pages", 'permission_id', :integer,
                :default => nil)

  change_column("#{prefix}controller_actions", 'site_controller_id', :integer,
                :default => nil)
  change_column("#{prefix}controller_actions", 'name', :string,
                :default => nil)

  change_column("#{prefix}menu_items", 'name', :string,
                :default => nil)
  change_column("#{prefix}menu_items", 'label', :string,
                :default => nil)

  change_column("#{prefix}roles", 'name', :string,
                :default => nil)
  
  change_column("#{prefix}roles_permissions", 'role_id', :integer,
                :default => nil)
  change_column("#{prefix}roles_permissions", 'permission_id', :integer,
                :default => nil)

  change_column("#{prefix}system_settings", 'site_name', :string,
                :default => nil)
  change_column("#{prefix}system_settings", 'public_role_id', :integer,
                :default => nil)
  remove_column("#{prefix}system_settings", 'default_markup_style_id')
  change_column("#{prefix}system_settings", 'site_default_page_id', :integer,
                :default => nil)
  change_column("#{prefix}system_settings", 'not_found_page_id', :integer,
                :default => nil)
  change_column("#{prefix}system_settings", 'permission_denied_page_id',
                :integer, :default => nil)
  change_column("#{prefix}system_settings", 'session_expired_page_id',
                :integer, :default => nil)

  change_column("#{prefix}users", 'name', :string,
                :default => nil)
  change_column("#{prefix}users", 'password', :string,
                :default => nil)
  change_column("#{prefix}users", 'role_id', :integer,
                :default => nil)
end