ext_tables.sql

CREATE TABLE pages (
	tx_sgnews_author int(11) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_related_news varchar(255) DEFAULT '' NOT NULL,
	tx_sgnews_highlighted tinyint(4) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_never_highlighted tinyint(4) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_teaser1_image int(11) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_teaser2_image int(11) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_teaser1_header_color int(11) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_teaser2_header_color int(11) unsigned DEFAULT '0' NOT NULL,

	KEY author (tx_sgnews_author)
);

CREATE TABLE pages_language_overlay (
	tx_sgnews_teaser1_image int(11) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_teaser2_image int(11) unsigned DEFAULT '0' NOT NULL
);