posted 18 years ago
DROP TABLE IF EXISTS jforum_topics_watch;
CREATE TABLE jforum_topics_watch (
topic_id INT NOT NULL
user_id INT NOT NULL
is_read tinyint(1) DEFAULT 1
INDEX idx_topic (topic_id),
INDEX idx_user (user_id)
) TYPE=InnoDB;
and it should be
DROP TABLE IF EXISTS jforum_topics_watch;
CREATE TABLE jforum_topics_watch (
topic_id INT NOT NULL,
user_id INT NOT NULL,
is_read tinyint(1) DEFAULT 1,
INDEX idx_topic (topic_id),
INDEX idx_user (user_id)
) TYPE=InnoDB;
[originally posted on jforum.net by Anonymous]