--
-- Table structure for table `xoopsfaq_categories`
--
CREATE TABLE xoopsfaq_categories (
  category_id       serial          NOT NULL,
  category_title    varchar(255)    NOT NULL default '',
  category_order    smallint        NOT NULL default '0',
  PRIMARY KEY (category_id)
);

-- --------------------------------------------------------

--
-- Table structure for table `xoopsfaq_contents`
--
CREATE TABLE xoopsfaq_contents (
  contents_id           serial          NOT NULL,
  category_id           smallint        NOT NULL default '0',
  contents_title        varchar(255)    NOT NULL default '',
  contents_contents     text            NOT NULL,
  contents_time         integer         NOT NULL default '0',
  contents_order        smallint        NOT NULL default '0',
  contents_visible      smallint        NOT NULL default '1',
  contents_nohtml       smallint        NOT NULL default '0',
  contents_nosmiley     smallint        NOT NULL default '0',
  contents_noxcode      smallint        NOT NULL default '0',
  PRIMARY KEY (contents_id)
);

