diff options
-rw-r--r-- | database/database.mysql | 34 | ||||
-rw-r--r-- | database/database.pgsql | 33 |
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 |