summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2006-01-16 18:33:30 +0000
committerDries Buytaert <dries@buytaert.net>2006-01-16 18:33:30 +0000
commitda4f856ad8e275b51ddd44966f40d0cab91ef3f1 (patch)
tree33411b4cf8b8b8d185d9ccd3fc1a3d47c3c22747 /database
parentefd634ac1546c45cd299ec9040997f7663deddd7 (diff)
downloadbrdo-da4f856ad8e275b51ddd44966f40d0cab91ef3f1.tar.gz
brdo-da4f856ad8e275b51ddd44966f40d0cab91ef3f1.tar.bz2
- Patch #44964 by Eaton: remove comment moderation tables.
Diffstat (limited to 'database')
-rw-r--r--database/database.mysql34
-rw-r--r--database/database.pgsql33
2 files changed, 0 insertions, 67 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 131b43940..635ae5046 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -391,40 +391,6 @@ CREATE TABLE menu (
) TYPE=MyISAM;
--
--- Table structure for table 'moderation_filters'
---
-
-CREATE TABLE moderation_filters (
- fid int(10) unsigned NOT NULL auto_increment,
- filter varchar(255) NOT NULL default '',
- minimum smallint(6) NOT NULL default '0',
- PRIMARY KEY (fid)
-) TYPE=MyISAM;
-
---
--- Table structure for table 'moderation_roles'
---
-
-CREATE TABLE moderation_roles (
- rid int(10) unsigned NOT NULL default '0',
- mid int(10) unsigned NOT NULL default '0',
- value tinyint(4) NOT NULL default '0',
- KEY idx_rid (rid),
- KEY idx_mid (mid)
-) TYPE=MyISAM;
-
---
--- Table structure for table 'moderation_votes'
---
-
-CREATE TABLE moderation_votes (
- mid int(10) unsigned NOT NULL auto_increment,
- vote varchar(255) default NULL,
- weight tinyint(4) NOT NULL default '0',
- PRIMARY KEY (mid)
-) TYPE=MyISAM;
-
---
-- Table structure for table 'node'
--
diff --git a/database/database.pgsql b/database/database.pgsql
index 2bb1095d0..728f99962 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -389,39 +389,6 @@ CREATE TABLE menu (
type smallint NOT NULL default '0',
PRIMARY KEY (mid)
);
---
--- Table structure for table 'moderation_filters'
---
-
-CREATE TABLE moderation_filters (
- fid SERIAL,
- filter varchar(255) NOT NULL default '',
- minimum smallint NOT NULL default '0',
- PRIMARY KEY (fid)
-);
-
---
--- Table structure for table 'moderation_roles'
---
-
-CREATE TABLE moderation_roles (
- rid integer NOT NULL default '0',
- mid integer NOT NULL default '0',
- value smallint NOT NULL default '0'
-);
-CREATE INDEX moderation_roles_rid_idx ON moderation_roles(rid);
-CREATE INDEX moderation_roles_mid_idx ON moderation_roles(mid);
-
---
--- Table structure for table 'moderation_votes'
---
-
-CREATE TABLE moderation_votes (
- mid SERIAL,
- vote varchar(255) default NULL,
- weight smallint NOT NULL default '0',
- PRIMARY KEY (mid)
-);
--
-- Table structure for node