// Create tables
$inf_newtable[] = DB_FIGURE_CATS." (
figure_cat_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_cat_name varchar(100) NOT NULL DEFAULT '',
figure_cat_description text NOT NULL,
figure_cat_sorting varchar(50) NOT NULL DEFAULT '',
figure_cat_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_cat_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_ITEMS." (
figure_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_freigabe tinyint(1) unsigned NOT NULL DEFAULT '0',
figure_submitter varchar(200) NOT NULL DEFAULT '',
figure_cat mediumint(8) unsigned NOT NULL DEFAULT '0',
figure_title varchar(200) NOT NULL DEFAULT '',
figure_variant varchar(200) NOT NULL DEFAULT '',
figure_manufacturer varchar(200) NOT NULL DEFAULT '',
figure_artists varchar(400) NOT NULL DEFAULT '',
figure_country varchar(200) NOT NULL DEFAULT '',
figure_brand varchar(200) NOT NULL DEFAULT '',
figure_series varchar(200) NOT NULL DEFAULT '',
figure_scale varchar(200) NOT NULL DEFAULT '',
figure_weight varchar(200) NOT NULL DEFAULT '',
figure_height varchar(200) NOT NULL DEFAULT '',
figure_width varchar(200) NOT NULL DEFAULT '',
figure_depth varchar(200) NOT NULL DEFAULT '',
figure_material varchar(200) NOT NULL DEFAULT '',
figure_poa varchar(200) NOT NULL DEFAULT '',
figure_packaging varchar(200) NOT NULL DEFAULT '',
figure_pubdate varchar(200) NOT NULL DEFAULT '',
figure_retailprice decimal(8,2) NOT NULL,
figure_usedprice decimal(8,2) NOT NULL,
figure_limitation varchar(200) NOT NULL DEFAULT '',
figure_editionsize decimal(8) NOT NULL,
figure_forum_url varchar(200) NOT NULL DEFAULT '',
figure_affiliate_1 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_2 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_3 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_4 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_5 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_6 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_7 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_8 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_9 varchar(500) NOT NULL DEFAULT '',
figure_affiliate_10 varchar(500) NOT NULL DEFAULT '',
figure_eshop varchar(400) NOT NULL DEFAULT '',
figure_amazon_de varchar(400) NOT NULL DEFAULT '',
figure_amazon_uk varchar(400) NOT NULL DEFAULT '',
figure_amazon_fr varchar(400) NOT NULL DEFAULT '',
figure_amazon_es varchar(400) NOT NULL DEFAULT '',
figure_amazon_it varchar(400) NOT NULL DEFAULT '',
figure_amazon_jp varchar(400) NOT NULL DEFAULT '',
figure_amazon_com varchar(400) NOT NULL DEFAULT '',
figure_amazon_ca varchar(400) NOT NULL DEFAULT '',
figure_accessories text NOT NULL,
figure_description text NOT NULL,
figure_datestamp int(10) unsigned NOT NULL DEFAULT '0',
figure_clickcount int(10) unsigned NOT NULL DEFAULT '0',
figure_allow_comments tinyint(1) unsigned NOT NULL DEFAULT '1',
figure_allow_ratings tinyint(1) unsigned NOT NULL DEFAULT '1',
figure_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
KEY figure_datestamp (figure_datestamp),
KEY figure_clickcount (figure_clickcount),
PRIMARY KEY (figure_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_SETTINGS." (
figure_settings_name varchar(200) NOT NULL DEFAULT '',
figure_settings_value text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_MANUFACTURERS." (
figure_manufacturer_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_manufacturer_name varchar(100) NOT NULL DEFAULT '',
figure_manufacturer_description text NOT NULL,
figure_manufacturer_sorting varchar(50) NOT NULL DEFAULT '',
figure_manufacturer_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_manufacturer_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[7] = DB_FIGURE_BRANDS." (
figure_brand_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_brand_name varchar(100) NOT NULL DEFAULT '',
figure_brand_description text NOT NULL,
figure_brand_sorting varchar(50) NOT NULL DEFAULT '',
figure_brand_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_brand_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_MATERIALS." (
figure_material_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_material_name varchar(100) NOT NULL DEFAULT '',
figure_material_description text NOT NULL,
figure_material_sorting varchar(50) NOT NULL DEFAULT '',
figure_material_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_material_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_SCALES." (
figure_scale_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_scale_name varchar(100) NOT NULL DEFAULT '',
figure_scale_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_scale_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_POAS." (
figure_poa_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_poa_name varchar(100) NOT NULL DEFAULT '',
figure_poa_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_poa_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_PACKAGINGS." (
figure_packaging_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_packaging_name varchar(100) NOT NULL DEFAULT '',
figure_packaging_description text NOT NULL,
figure_packaging_sorting varchar(50) NOT NULL DEFAULT '',
figure_packaging_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_packaging_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_LIMITATIONS." (
figure_limitation_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_limitation_name varchar(100) NOT NULL DEFAULT '',
figure_limitation_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_limitation_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_MEASUREMENTS." (
figure_measurements_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_measurements_inch varchar(100) NOT NULL DEFAULT '',
figure_measurements_cm varchar(100) NOT NULL DEFAULT '',
figure_measurements_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_measurements_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_USERFIGURES." (
figure_userfigures_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_userfigures_figure_id varchar(100) NOT NULL DEFAULT '',
figure_userfigures_user_id varchar(100) NOT NULL DEFAULT '',
figure_userfigures_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_userfigures_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_IMAGES." (
figure_images_image_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_images_figure_id varchar(100) NOT NULL DEFAULT '',
figure_images_image varchar(100) NOT NULL DEFAULT '',
figure_images_thumb varchar(100) NOT NULL DEFAULT '',
figure_images_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_images_image_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
/////////////////////////////////////////////////////////////////////////////////
$inf_newtable[] = DB_FIGURE_YEARS." (
figure_year_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_year varchar(100) NOT NULL DEFAULT '',
figure_year_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_year_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";