aggregation spike with flags associated to pages

Page has now a named_scope :with_flags which 
accepts an array of flag names and returns 
corresponding pages. Can be chained with order and
limit

2 files changed, 28 insertions, 0 deletions

diff --git a/db/migrate/20090201211159_create_flags.rb b/db/migrate/20090201211159_create_flags.rb
new file mode 100644
index 0000000..3b9da43
--- /dev/null
+++ b/db/migrate/20090201211159_create_flags.rb
@@ -0,0 +1,13 @@
+class CreateFlags < ActiveRecord::Migration
+  def self.up
+    create_table :flags do |t|
+      t.string :name
+
+      t.timestamps
+    end
+  end
+
+  def self.down
+    drop_table :flags
+  end
+end
diff --git a/db/migrate/20090201211523_add_join_table_for_flags_pages.rb b/db/migrate/20090201211523_add_join_table_for_flags_pages.rb
new file mode 100644
index 0000000..99eb9c9
--- /dev/null
+++ b/db/migrate/20090201211523_add_join_table_for_flags_pages.rb
@@ -0,0 +1,15 @@
+class AddJoinTableForFlagsPages < ActiveRecord::Migration
+  def self.up
+    create_table :flags_pages, :id => false do |t|
+      t.integer :flag_id
+      t.integer :page_id
+    end
+    add_index :flags_pages, [:flag_id]
+    add_index :flags_pages, [:page_id]
+  end
+  
+  def self.down
+    remove_table :flags_pages
+  end
+  
+end