CREATE TABLE IF NOT EXISTS #__kunena_keywords
( id
int(11) NOT NULL auto_increment, name
varchar(40) NOT NULL, public_count
int(11) NOT NULL, total_count
int(11) NOT NULL, PRIMARY KEY (id), UNIQUE KEY name
(name), KEY public_count
(public_count), KEY total_count
(total_count) ) DEFAULT CHARACTER SET utf8;
CREATE TABLE IF NOT EXISTS #__kunena_keywords_map
( keyword_id
int(11) NOT NULL, user_id
int(11) NOT NULL, topic_id
int(11) NOT NULL, UNIQUE KEY keyword_user_topic
(keyword_id,user_id,topic_id), KEY user_id
(user_id), KEY topic_user
(topic_id,user_id) ) DEFAULT CHARACTER SET utf8;
CREATE TABLE IF NOT EXISTS #__kunena_users
( aim
varchar(50) NULL; )
CREATE TABLE IF NOT EXISTS #__kunena_attachments
( inline
tinyint(4) NOT NULL default ‘0’; )
CREATE TABLE IF NOT EXISTS #__kunena_categories
( topictemplate
text NOT NULL; )
CREATE TABLE IF NOT EXISTS #__kunena_users
( whatsapp
varchar(25) NULL; )
ALTER TABLE #__kunena_users
ADD AIM
varchar(50) NULL AFTER ICQ
;
#__ is your database prefix