added model Comment.

comments can now be added on news.

git-svn-id: http://redmine.rubyforge.org/svn/trunk@81 e93f8b46-1217-0410-a6f0-8f06a7374b81

3 files changed, 36 insertions, 0 deletions

diff --git a/db/migrate/010_create_comments.rb b/db/migrate/010_create_comments.rb
new file mode 100644
index 000000000..322a019bc
--- /dev/null
+++ b/db/migrate/010_create_comments.rb
@@ -0,0 +1,16 @@
+class CreateComments < ActiveRecord::Migration
+  def self.up
+    create_table :comments do |t|
+      t.column :commented_type, :string, :limit => 30, :default => "", :null => false
+      t.column :commented_id, :integer, :default => 0, :null => false
+      t.column :author_id, :integer, :default => 0, :null => false
+      t.column :comment, :text, :default => "", :null => false
+      t.column :created_on, :datetime, :null => false
+      t.column :updated_on, :datetime, :null => false
+    end
+  end
+
+  def self.down
+    drop_table :comments
+  end
+end
diff --git a/db/migrate/011_add_news_comments_count.rb b/db/migrate/011_add_news_comments_count.rb
new file mode 100644
index 000000000..a24743999
--- /dev/null
+++ b/db/migrate/011_add_news_comments_count.rb
@@ -0,0 +1,9 @@
+class AddNewsCommentsCount < ActiveRecord::Migration
+  def self.up
+    add_column :news, :comments_count, :integer, :default => 0, :null => false
+  end
+
+  def self.down
+    remove_column :news, :comments_count
+  end
+end
diff --git a/db/migrate/012_add_comments_permissions.rb b/db/migrate/012_add_comments_permissions.rb
new file mode 100644
index 000000000..37f075082
--- /dev/null
+++ b/db/migrate/012_add_comments_permissions.rb
@@ -0,0 +1,11 @@
+class AddCommentsPermissions < ActiveRecord::Migration
+  def self.up
+    Permission.create :controller => "news", :action => "add_comment", :description => "label_comment_add", :sort => 1130, :is_public => false, :mail_option => 0, :mail_enabled => 0
+    Permission.create :controller => "news", :action => "destroy_comment", :description => "label_comment_delete", :sort => 1133, :is_public => false, :mail_option => 0, :mail_enabled => 0
+  end
+
+  def self.down
+    Permission.find(:first, :conditions => ["controller=? and action=?", 'news', 'add_comment']).destroy
+    Permission.find(:first, :conditions => ["controller=? and action=?", 'news', 'destroy_comment']).destroy
+  end
+end