| 1 | CREATE TABLE xoopsheadline ( |
|---|
| 2 | headline_id smallint(3) unsigned NOT NULL auto_increment, |
|---|
| 3 | headline_name varchar(255) NOT NULL default '', |
|---|
| 4 | headline_url varchar(255) NOT NULL default '', |
|---|
| 5 | headline_rssurl varchar(255) NOT NULL default '', |
|---|
| 6 | headline_encoding varchar(15) NOT NULL default '', |
|---|
| 7 | headline_cachetime mediumint(8) unsigned NOT NULL default '3600', |
|---|
| 8 | headline_asblock tinyint(1) unsigned NOT NULL default '0', |
|---|
| 9 | headline_display tinyint(1) unsigned NOT NULL default '0', |
|---|
| 10 | headline_weight smallint(3) unsigned NOT NULL default '0', |
|---|
| 11 | headline_mainfull tinyint(1) unsigned NOT NULL default '1', |
|---|
| 12 | headline_mainimg tinyint(1) unsigned NOT NULL default '1', |
|---|
| 13 | headline_mainmax tinyint(2) unsigned NOT NULL default '10', |
|---|
| 14 | headline_blockimg tinyint(1) unsigned NOT NULL default '0', |
|---|
| 15 | headline_blockmax tinyint(2) unsigned NOT NULL default '10', |
|---|
| 16 | headline_xml text NOT NULL default '', |
|---|
| 17 | headline_updated int(10) NOT NULL default'0', |
|---|
| 18 | PRIMARY KEY (headline_id) |
|---|
| 19 | ) TYPE=MyISAM; |
|---|
| 20 | |
|---|
| 21 | |
|---|
| 22 | |
|---|
| 23 | 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); |
|---|
