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_tags int(11) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_likes int(11) unsigned DEFAULT '0' NOT NULL,
	tx_sgnews_location mediumtext,

	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,
	tx_sgnews_location mediumtext
);