Here's what I did:
Edited the file arms/sql/arms_mysql.sql
And deleted things in red:
Quote:
# ==============================================================================
# Table arms_categories added in ArMS 0.3
# ==============================================================================
CREATE TABLE arms_categories (
cat_id smallint(3) unsigned default "0" NOT NULL auto_increment,
cat_title varchar(100) default "" NOT NULL,
cat_desc text default "" NOT NULL,
cat_order smallint(3) unsigned default "" NOT NULL,
PRIMARY KEY (cat_id)
) TYPE = MyISAM;
# ==============================================================================
# ArMS 0.3 addons
# ---------------
# cat_id - category id
# sec_image - section image
# ==============================================================================
CREATE TABLE arms_sections (
sec_id smallint(3) unsigned default "0" NOT NULL auto_increment,
cat_id smallint(3) unsigned default "0" NOT NULL,
sec_order smallint(3) unsigned default "1" NOT NULL,
sec_title varchar(100) default "" NOT NULL,
sec_desc text default "" NOT NULL,
sec_image varchar(255) default "" NOT NULL,
PRIMARY KEY (sec_id)
) TYPE = MyISAM;
CREATE TABLE arms_articals_levels (
level_id smallint(3) unsigned default "" NOT NULL auto_increment,
level_name varchar(100) default "" NOT NULL,
level_desc text default "" NOT NULL,
level_image varchar(100) default "" NOT NULL,
PRIMARY KEY (level_id)
) TYPE = MyISAM;
# ==============================================================================
# ArMS 0.3 Addons
# ---------------
# art_onhold - while art_onhold is 1 only admin and author can see this artical
# ==============================================================================
CREATE TABLE arms_articals (
art_id int(5) unsigned default "0" NOT NULL auto_increment,
sec_id smallint(3) unsigned default "0" NOT NULL,
level_id smallint(3) unsigned default "0" NOT NULL,
uid int(5) unsigned default "0" NOT NULL,
uip varchar(15) default "" NOT NULL,
art_title varchar(255) default "" NOT NULL,
art_desc text default "" NOT NULL,
art_updatecount smallint(3) unsigned default "0" NOT NULL,
art_posttime int(11) unsigned default "0" NOT NULL,
art_lastupdate int(11) unsigned default "0" NOT NULL,
art_lastupdateby int(5) unsigned default "0" NOT NULL,
art_lastupdatebyip varchar(15) default "" NOT NULL,
art_ratetotal mediumint(8) unsigned default "0" NOT NULL,
art_ratecount mediumint(8) unsigned default "1" NOT NULL,
art_views int(11) unsigned default "0" NOT NULL,
art_activated tinyint(1) default "0" NOT NULL,
art_onhold tinyint(1) default "1" NOT NULL,
PRIMARY KEY (art_id)
) TYPE = MyISAM;
CREATE TABLE arms_pages (
page_id int(6) unsigned default "0" NOT NULL auto_increment,
page_order smallint(3) unsigned default "1" NOT NULL,
art_id int(5) unsigned default "0" NOT NULL,
level_id smallint(3) unsigned default "0" NOT NULL,
uid int(5) unsigned default "0" NOT NULL,
uip varchar(15) default "" NOT NULL,
page_title varchar(255) default "" NOT NULL,
page_desc text default "" NOT NULL,
page_text text default "" NOT NULL,
page_allow_html tinyint(1) default "0" NOT NULL,
page_allow_emotions tinyint(1) default "0" NOT NULL,
page_allow_bbcode tinyint(1) default "1" NOT NULL,
page_updatecount smallint(3) unsigned default "0" NOT NULL,
page_posttime int(11) unsigned default "0" NOT NULL,
page_lastupdate int(11) unsigned default "0" NOT NULL,
page_lastupdateby int(5) unsigned default "0" NOT NULL,
page_lastupdatebyip varchar(15) default "" NOT NULL,
page_views int(11) unsigned default "0" NOT NULL,
PRIMARY KEY (page_id)
) TYPE = MyISAM;
CREATE TABLE arms_votelog (
vote_id int(5) unsigned default "0" NOT NULL auto_increment,
vote_time int(11) unsigned default "0" NOT NULL,
art_id int(5) unsigned default "0" NOT NULL,
uid int(5) unsigned default "0" NOT NULL,
uip varchar(15) default "" NOT NULL,
PRIMARY KEY (vote_id)
) TYPE = MyISAM;
CREATE TABLE arms_moderators(
mod_id smallint(3) unsigned default "0" NOT NULL auto_increment,
uid int(5) unsigned default "0" NOT NULL,
sec_id smallint(3) unsigned default "0" NOT NULL,
PRIMARY KEY (mod_id)
) TYPE = MyISAM;
# ==============================================================================
# Table arms_permissions added in ArMS 0.3
# Note: fiels can_add_files and can_delete_files not implemented in ArMS 0.3
# please wait ArMS 0.4 for file attachments...
# ==============================================================================
CREATE TABLE arms_permissions(
p_id int(6) unsigned default "0" NOT NULL auto_increment,
art_id int(6) unsigned default "0" NOT NULL,
uid int(5) unsigned default "0" NOT NULL,
added_by int(5) unsigned default "0" NOT NULL,
can_edit_pages tinyint(1) default "1" NOT NULL,
can_add_pages tinyint(1) default "0" NOT NULL,
can_delete_pages tinyint(1) default "0" NOT NULL,
can_add_files tinyint(1) default "0" NOT NULL,
can_delete_files tinyint(1) default "0" NOT NULL,
PRIMARY KEY (p_id)
) TYPE = MyISAM;
# ==============================================================================
# Table arms_cross_section added in ArMS 0.3
# ==============================================================================
CREATE TABLE arms_cross_section (
cs_id int(9) unsigned default "0" NOT NULL auto_increment,
art_id int(6) unsigned default "0" NOT NULL,
sec_id smallint(3) unsigned default "0" NOT NULL,
PRIMARY KEY (cs_id)
) TYPE = MyISAM;
Warning: My knowledge about sql stuff is absolutely NONE, so I can't even say what my changes did.
But the module has installed successfully. All options seem to work fine as for now.