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