--
-- Table structure for table `xoopsheadline`
--
CREATE TABLE xoopsheadline (
  headline_id           serial          NOT NULL,
  headline_name         varchar(255)    NOT NULL default '',
  headline_url          varchar(255)    NOT NULL default '',
  headline_rssurl       varchar(255)    NOT NULL default '',
  headline_encoding     varchar(15)     NOT NULL default '',
  headline_cachetime    integer         NOT NULL default '3600',
  headline_asblock      smallint        NOT NULL default '0',
  headline_display      smallint        NOT NULL default '0',
  headline_weight       smallint        NOT NULL default '0',
  headline_mainfull     smallint        NOT NULL default '1',
  headline_mainimg      smallint        NOT NULL default '1',
  headline_mainmax      smallint        NOT NULL default '10',
  headline_blockimg     smallint        NOT NULL default '0',
  headline_blockmax     smallint        NOT NULL default '10',
  headline_xml          text            NOT NULL default '',
  headline_updated      integer         NOT NULL default '0',
  PRIMARY KEY (headline_id)
);

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

INSERT INTO xoopsheadline VALUES (1, 'XOOPS Official Website', 'http://www.xoops.org/', 'http://www.xoops.org/backend.php', 'ISO-8859-1', 86400, 0, 1, 0, 1, 1, 10, 0, 10, '', 0);
