#
# Table structure for table 'tx_cnews_domain_model_news'
#
CREATE TABLE tx_cnews_domain_model_news (

	title varchar(255) DEFAULT '' NOT NULL,
	shortdescription text,
	description text,
	image int(11) unsigned NOT NULL default '0',
	description2 text,
	image2 int(11) unsigned NOT NULL default '0',
	slug varchar(255) DEFAULT '' NOT NULL,
	class int(11) DEFAULT '0' NOT NULL,
	ndate int(11) unsigned NOT NULL default '0',
	categories int(11) DEFAULT '0' NOT NULL,
	relatedcategories int(11) DEFAULT '0' NOT NULL,
	editor int(11) DEFAULT '0' NOT NULL,

	linkedin varchar(255) DEFAULT '' NOT NULL,
	email varchar(255) DEFAULT '' NOT NULL,

	linkedin_chartered varchar(255) DEFAULT '' NOT NULL,
	email_chartered varchar(255) DEFAULT '' NOT NULL,

	linkedin_opus varchar(255) DEFAULT '' NOT NULL,
	email_opus varchar(255) DEFAULT '' NOT NULL,

	linkedin_job varchar(255) DEFAULT '' NOT NULL,
	email_job varchar(255) DEFAULT '' NOT NULL,
	
	relatedarticletitle varchar(255) DEFAULT '' NOT NULL,

	label varchar(255) DEFAULT '' NOT NULL,
	link varchar(255) DEFAULT '' NOT NULL,

	morelinklabel varchar(255) DEFAULT '' NOT NULL,
	morelink varchar(255) DEFAULT '' NOT NULL,
	home int(11) unsigned NOT NULL default '0',

	tx_yoastseo_snippetpreview tinyint(3) DEFAULT '0' NOT NULL,
	tx_yoastseo_readability_analysis tinyint(3) DEFAULT '0' NOT NULL,
	tx_yoastseo_focuskeyword_analysis tinyint(3) DEFAULT '0' NOT NULL,
	tx_yoastseo_focuskeyword varchar(100) DEFAULT '' NOT NULL

);

#
# Table structure for table 'tx_cnews_domain_model_category'
#
CREATE TABLE tx_cnews_domain_model_category (

	name varchar(255) DEFAULT '' NOT NULL,

);

#
# Table structure for table 'tx_cnews_domain_model_relatedcategory'
#
CREATE TABLE tx_cnews_domain_model_relatedcategory (

	name varchar(255) DEFAULT '' NOT NULL,

);



#
# Table structure for table 'tx_cnews_domain_model_editor'
#
CREATE TABLE tx_cnews_domain_model_editor (

	name varchar(255) DEFAULT '' NOT NULL,

);


#
# Table structure for table 'tx_cnews_news_editor_mm'
#
CREATE TABLE tx_cnews_news_editor_mm (
	uid_local int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid_local,uid_foreign),
	KEY uid_local (uid_local),
	KEY uid_foreign (uid_foreign)
);

#
# Table structure for table 'tx_cnews_news_relatedcategory_mm'
#
CREATE TABLE tx_cnews_news_relatedcategory_mm (
	uid_local int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid_local,uid_foreign),
	KEY uid_local (uid_local),
	KEY uid_foreign (uid_foreign)
);


## EXTENSION BUILDER DEFAULTS END TOKEN - Everything BEFORE this line is overwritten with the defaults of the extension builder