summaryrefslogtreecommitdiff
path: root/db/migrate/20111104141001_create_complete.rb
diff options
context:
space:
mode:
authorStefan Wintermeyer <stefan.wintermeyer@amooma.de>2012-12-17 12:01:45 +0100
committerStefan Wintermeyer <stefan.wintermeyer@amooma.de>2012-12-17 12:01:45 +0100
commitb80bd744ad873f6fc43018bc4bfb90677de167bd (patch)
tree072c4b0e33d442528555b82c415f5e7a1712b2b0 /db/migrate/20111104141001_create_complete.rb
parent3e706c2025ecc5523e81ad649639ef2ff75e7bac (diff)
Start of GS5.
Diffstat (limited to 'db/migrate/20111104141001_create_complete.rb')
-rw-r--r--db/migrate/20111104141001_create_complete.rb33
1 files changed, 33 insertions, 0 deletions
diff --git a/db/migrate/20111104141001_create_complete.rb b/db/migrate/20111104141001_create_complete.rb
new file mode 100644
index 0000000..e5f0a63
--- /dev/null
+++ b/db/migrate/20111104141001_create_complete.rb
@@ -0,0 +1,33 @@
+class CreateComplete < ActiveRecord::Migration
+ def self.up
+ create_table :complete, :id => false do |t|
+ t.integer :sticky
+ t.string :a1, :limit=>'128'
+ t.string :a2, :limit=>'128'
+ t.string :a3, :limit=>'128'
+ t.string :a4, :limit=>'128'
+ t.string :a5, :limit=>'128'
+ t.string :a6, :limit=>'128'
+ t.string :a7, :limit=>'128'
+ t.string :a8, :limit=>'128'
+ t.string :a9, :limit=>'128'
+ t.string :a10, :limit=>'128'
+ t.string :hostname, :limit=>'256'
+ end
+ add_index :complete, [ :a1, :hostname ], :unique => false, :name => 'complete1'
+ add_index :complete, [ :a2, :hostname ], :unique => false, :name => 'complete2'
+ add_index :complete, [ :a3, :hostname ], :unique => false, :name => 'complete3'
+ add_index :complete, [ :a4, :hostname ], :unique => false, :name => 'complete4'
+ add_index :complete, [ :a5, :hostname ], :unique => false, :name => 'complete5'
+ add_index :complete, [ :a6, :hostname ], :unique => false, :name => 'complete6'
+ add_index :complete, [ :a7, :hostname ], :unique => false, :name => 'complete7'
+ add_index :complete, [ :a8, :hostname ], :unique => false, :name => 'complete8'
+ add_index :complete, [ :a9, :hostname ], :unique => false, :name => 'complete9'
+ add_index :complete, [ :a10, :hostname ], :unique => false, :name => 'complete10'
+ add_index :complete, [ :a1, :a2, :a3, :a4, :a5, :a6, :a7, :a8, :a9, :a10, :hostname ], :unique => false, :name => 'complete11'
+ end
+
+ def self.down
+ drop_table :complete
+ end
+end