modules/topic/topic.mysql

CREATE TABLE topic (
  nid           int(10) NOT NULL default '0',
  num_answers   int(2)  NOT NULL default '0',
  num_days      int(2)  NOT NULL default '0',
  answer_status int(1)  NOT NULL default '0',
  processed     int(1)  NOT NULL default '0',
  PRIMARY KEY (nid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE topic_answer (
  aid          int(2)  NOT NULL default '0',
  uid          int(10) NOT NULL default '0',
  nid          int(10) NOT NULL default '0',
  answer       text default '',
  PRIMARY KEY (aid, uid, nid),
  KEY key_uid (uid),
  KEY key_nid (nid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
1	CREATE TABLE topic (
2	nid int(10) NOT NULL default '0',
3	num_answers int(2) NOT NULL default '0',
4	num_days int(2) NOT NULL default '0',
5	answer_status int(1) NOT NULL default '0',
6	processed int(1) NOT NULL default '0',
7	PRIMARY KEY (nid)
8	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
9
10	CREATE TABLE topic_answer (
11	aid int(2) NOT NULL default '0',
12	uid int(10) NOT NULL default '0',
13	nid int(10) NOT NULL default '0',
14	answer text default '',
15	PRIMARY KEY (aid, uid, nid),
16	KEY key_uid (uid),
17	KEY key_nid (nid)
18	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;