--
-- Table structure for table `stories`
--

CREATE TABLE stories (
  storyid       serial          NOT NULL PRIMARY KEY,
  uid           integer         NOT NULL default 0,
  title         varchar(255)    NOT NULL default '',
  created       integer         NOT NULL default 0,
  published     integer         NOT NULL default 0,
  expired       integer         NOT NULL default 0,
  hostname      varchar(20)     NOT NULL default '',
  nohtml        smallint        NOT NULL default 0,
  nosmiley      smallint        NOT NULL default 0,
  hometext      text            NOT NULL,
  bodytext      text            NOT NULL,
  counter       integer         NOT NULL default 0,
  topicid       smallint        NOT NULL default 1,
  ihome         smallint        NOT NULL default 0,
  notifypub     smallint        NOT NULL default 0,
  story_type    varchar(5)      NOT NULL default '',
  topicdisplay  smallint        NOT NULL default 0,
  topicalign    char(1)         NOT NULL default 'R',
  comments      smallint        NOT NULL default 0 
);

--GRANT all on stories to %s;
-- --------------------------------------------------------
--
-- Table structure for table `topics`
--

CREATE TABLE topics (
  topic_id      serial          NOT NULL PRIMARY KEY,
  topic_pid     smallint        NOT NULL default 0,
  topic_imgurl  varchar(20)     NOT NULL default '',
  topic_title   varchar(50)     NOT NULL default ''
);

--GRANT all on topics to %s;
-- --------------------------------------------------------

INSERT INTO topics VALUES (1,0,'xoops.gif','XOOPS');
