MySql_AddonLanguage.sql 1.19 KB


-- DROP TABLE IF EXISTS losp_Addon_Language_BE_date;
CREATE TABLE losp_Addon_Language_BE_date (
	MTextID int(11) UNSIGNED NOT NULL,
	Subject varchar(512),
	Text text NOT NULL,
	LanguageCode varchar(3)
) ENGINE=MyISAM;

-- DROP TABLE IF EXISTS losp_Addon_Language_BE_topic;
CREATE TABLE losp_Addon_Language_BE_topic (
	MTextID int(11) UNSIGNED NOT NULL,
	Subject varchar(512),
	Text text NOT NULL,
	Name varchar(20),
	LanguageCode varchar(3)
) ENGINE=MyISAM;

CREATE TABLE losp_Addon_Language_BE_profile (
	MTextID int(11) UNSIGNED NOT NULL,
	Subject varchar(512),
	Text text NOT NULL,
	Url varchar(2048),
	Signature text(2048),
	LanguageCode varchar(3)
) ENGINE=MyISAM;

CREATE TABLE losp_Addon_Language_BE_treepart (
	MTextID int(11) UNSIGNED NOT NULL,
	Name varchar(20),
	Subject varchar(512),
	Text text NOT NULL,
	LanguageCode varchar(3)
) ENGINE=MyISAM;

CREATE TABLE losp_Addon_Language_BE_file (
	MTextID int(11) UNSIGNED NOT NULL,
	Subject varchar(512),
	Text text NOT NULL,
	LanguageCode varchar(3)
) ENGINE=MyISAM;

CREATE TABLE losp_Addon_Language_BE_url (
	MTextID int(11) UNSIGNED NOT NULL,
	Url varchar(2048),
	Subject varchar(512),
	Text text NOT NULL,
	LanguageCode varchar(3)
) ENGINE=MyISAM;