summaryrefslogtreecommitdiff
path: root/modules/comment
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2007-10-05 14:43:26 +0000
committerDries Buytaert <dries@buytaert.net>2007-10-05 14:43:26 +0000
commit39706e3c51cf206ca6669bbb7a090d2f7d394591 (patch)
tree9286ccd302d526ea8a1de799081356fcc77c28a3 /modules/comment
parentd568128b9f7a0181b31e9baa087022e892352ea7 (diff)
downloadbrdo-39706e3c51cf206ca6669bbb7a090d2f7d394591.tar.gz
brdo-39706e3c51cf206ca6669bbb7a090d2f7d394591.tar.bz2
- Patch #150245 by webchick, bjaspan, ralf, Arancaytar et al: move the .schema files into .install files to prevent mistakes.
Diffstat (limited to 'modules/comment')
-rw-r--r--modules/comment/comment.install44
-rw-r--r--modules/comment/comment.schema42
2 files changed, 44 insertions, 42 deletions
diff --git a/modules/comment/comment.install b/modules/comment/comment.install
index 4c30b6c60..898016050 100644
--- a/modules/comment/comment.install
+++ b/modules/comment/comment.install
@@ -30,3 +30,47 @@ function comment_update_6001() {
$ret[] = update_sql("ALTER TABLE {comments} DROP users");
return $ret;
}
+
+/**
+ * Implementation of hook_schema().
+ */
+function comment_schema() {
+ $schema['comments'] = array(
+ 'fields' => array(
+ 'cid' => array('type' => 'serial', 'not null' => TRUE),
+ 'pid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
+ 'nid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
+ 'uid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
+ 'subject' => array('type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => ''),
+ 'comment' => array('type' => 'text', 'not null' => TRUE, 'size' => 'big'),
+ 'hostname' => array('type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => ''),
+ 'timestamp' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
+ 'status' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'size' => 'tiny'),
+ 'format' => array('type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0),
+ 'thread' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE),
+ 'name' => array('type' => 'varchar', 'length' => 60, 'not null' => FALSE),
+ 'mail' => array('type' => 'varchar', 'length' => 64, 'not null' => FALSE),
+ 'homepage' => array('type' => 'varchar', 'length' => 255, 'not null' => FALSE)
+ ),
+ 'indexes' => array(
+ 'nid' => array('nid'),
+ 'status' => array('status')
+ ),
+ 'primary key' => array('cid'),
+ );
+
+ $schema['node_comment_statistics'] = array(
+ 'fields' => array(
+ 'nid' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0),
+ 'last_comment_timestamp' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
+ 'last_comment_name' => array('type' => 'varchar', 'length' => 60, 'not null' => FALSE),
+ 'last_comment_uid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
+ 'comment_count' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)
+ ),
+ 'indexes' => array('node_comment_timestamp' => array('last_comment_timestamp')),
+ 'primary key' => array('nid'),
+ );
+
+ return $schema;
+}
+
diff --git a/modules/comment/comment.schema b/modules/comment/comment.schema
deleted file mode 100644
index 057e55d96..000000000
--- a/modules/comment/comment.schema
+++ /dev/null
@@ -1,42 +0,0 @@
-<?php
-// $Id$
-
-function comment_schema() {
- $schema['comments'] = array(
- 'fields' => array(
- 'cid' => array('type' => 'serial', 'not null' => TRUE),
- 'pid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
- 'nid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
- 'uid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
- 'subject' => array('type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => ''),
- 'comment' => array('type' => 'text', 'not null' => TRUE, 'size' => 'big'),
- 'hostname' => array('type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => ''),
- 'timestamp' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
- 'status' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'size' => 'tiny'),
- 'format' => array('type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0),
- 'thread' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE),
- 'name' => array('type' => 'varchar', 'length' => 60, 'not null' => FALSE),
- 'mail' => array('type' => 'varchar', 'length' => 64, 'not null' => FALSE),
- 'homepage' => array('type' => 'varchar', 'length' => 255, 'not null' => FALSE)
- ),
- 'indexes' => array(
- 'nid' => array('nid'),
- 'status' => array('status')
- ),
- 'primary key' => array('cid'),
- );
-
- $schema['node_comment_statistics'] = array(
- 'fields' => array(
- 'nid' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0),
- 'last_comment_timestamp' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
- 'last_comment_name' => array('type' => 'varchar', 'length' => 60, 'not null' => FALSE),
- 'last_comment_uid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
- 'comment_count' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)
- ),
- 'indexes' => array('node_comment_timestamp' => array('last_comment_timestamp')),
- 'primary key' => array('nid'),
- );
-
- return $schema;
-}