--
-- Table structure for table `poll_option`
--
CREATE TABLE xoopspoll_option (
  option_id         serial          NOT NULL,
  poll_id           integer         NOT NULL default '0',
  option_text       varchar(255)    NOT NULL default '',
  option_count      integer         NOT NULL default '0',
  option_color      varchar(25)     NOT NULL default '',
  PRIMARY KEY (option_id)
);

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

--
-- Table structure for table `poll_desc`
--
CREATE TABLE xoopspoll_desc (
  poll_id           serial          NOT NULL,
  question          varchar(255)    NOT NULL default '',
  description       varchar(255)    NOT NULL default '',
  user_id           integer         NOT NULL default '0',
  start_time        integer         NOT NULL default '0',
  end_time          integer         NOT NULL default '0',
  votes             integer         NOT NULL default '0',
  voters            integer         NOT NULL default '0',
  multiple          smallint        NOT NULL default '0',
  display           smallint        NOT NULL default '0',
  weight            integer         NOT NULL default '0',
  mail_status       smallint        NOT NULL default '0',
  PRIMARY KEY (poll_id)
);
-- --------------------------------------------------------

--
-- Table structure for table `poll_log`
--
CREATE TABLE xoopspoll_log (
  log_id        serial          NOT NULL,
  poll_id       integer         NOT NULL default '0',
  option_id     integer         NOT NULL default '0',
  ip            char(15)        NOT NULL default '',
  user_id       integer         NOT NULL default '0',
  time          integer         NOT NULL default '0',
  PRIMARY KEY (log_id)
);
-- --------------------------------------------------------

INSERT INTO xoopspoll_desc VALUES (1, 'What do you think about XOOPS?', 'A simple survey about the content management script used on this site.', 1, 1020447898, 1051983686, 0, 0, 0, 1, 0, 0);
INSERT INTO xoopspoll_option VALUES (1, 1, 'Excellent!', 0, 'aqua.gif');
INSERT INTO xoopspoll_option VALUES (2, 1, 'Cool', 0, 'blue.gif');
INSERT INTO xoopspoll_option VALUES (3, 1, 'Hmm..not bad', 0, 'brown.gif');
INSERT INTO xoopspoll_option VALUES (4, 1, 'What the hell is this?', 0, 'darkgreen.gif');
