#
# Anpassung in der Tabelle `cc_reg`
#

UPDATE cc_reg SET vsn = 4.2.6;

#
# Tabellenstruktur für Tabelle `cc_banner_banners`
#

CREATE TABLE cc_banner_banners (
  banner_id int(10) unsigned NOT NULL auto_increment,
  cat_id tinyint(3) unsigned NOT NULL default '0',
  user_id smallint(5) unsigned NOT NULL default '0',
  size_id tinyint(3) unsigned NOT NULL default '0',
  banner_img varchar(255) NOT NULL default '',
  banner_url varchar(255) NOT NULL default '',
  banner_views int(10) unsigned NOT NULL default '0',
  banner_clicks int(10) unsigned NOT NULL default '0',
  banner_time int(10) unsigned NOT NULL default '0',
  banner_max_views int(10) unsigned NOT NULL default '0',
  banner_max_clicks int(10) unsigned NOT NULL default '0',
  banner_max_time int(10) unsigned NOT NULL default '0',
  banner_status char(1) NOT NULL default '1',
  PRIMARY KEY  (banner_id)
) TYPE=MyISAM;

#
# Daten für Tabelle `cc_banner_banners`
#

INSERT INTO cc_banner_banners (banner_id, cat_id, user_id, size_id, banner_img, banner_url, banner_views, banner_clicks, banner_time, banner_max_views, banner_max_clicks, banner_max_time, banner_status) VALUES (1, 2, 1, 2, 'http://www.mmag3.de/banner/bannergrafiken/easyins-149x60-orange.gif', 'http://www.mmag3.de/index.php?site=werbung', 15, 1, 1097662390, 0, 0, 0, '1');
INSERT INTO cc_banner_banners (banner_id, cat_id, user_id, size_id, banner_img, banner_url, banner_views, banner_clicks, banner_time, banner_max_views, banner_max_clicks, banner_max_time, banner_status) VALUES (2, 1, 1, 1, 'http://www.mmag3.de/banner/bannergrafiken/easyins-468x60-orange.gif', 'http://www.mmag3.de/index.php?site=werbung', 5, 0, 1097666181, 0, 0, 0, '1');
INSERT INTO cc_banner_banners (banner_id, cat_id, user_id, size_id, banner_img, banner_url, banner_views, banner_clicks, banner_time, banner_max_views, banner_max_clicks, banner_max_time, banner_status) VALUES (3, 3, 1, 3, 'http://www.mmag3.de/banner/bannergrafiken/easyins-234x60-orange.gif', 'http://www.mmag3.de/banner/bannergrafiken/easyins-234x60-orange.gif', 5, 0, 1097666286, 0, 0, 0, '1');
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `cc_banner_categories`
#

CREATE TABLE cc_banner_categories (
  cat_id tinyint(3) unsigned NOT NULL auto_increment,
  cat_name varchar(64) NOT NULL default '',
  cat_text tinytext NOT NULL,
  PRIMARY KEY  (cat_id)
) TYPE=MyISAM;

#
# Daten für Tabelle `cc_banner_categories`
#

INSERT INTO cc_banner_categories (cat_id, cat_name, cat_text) VALUES (1, '1. Startseite', 'Kategorie entw. nur start.php oder index.php');
INSERT INTO cc_banner_categories (cat_id, cat_name, cat_text) VALUES (2, '2. Gewerbeverzeichnis', 'Kleiner Banner im Gewerbeverzeichnis Wirtschaft A-Z');
INSERT INTO cc_banner_categories (cat_id, cat_name, cat_text) VALUES (3, '3. Zimmerverzeichnis', 'Halber Banner im Zimmernachweis');
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `cc_banner_config`
#

CREATE TABLE cc_banner_config (
  cfg_name varchar(255) NOT NULL default '',
  cfg_value varchar(255) NOT NULL default '',
  PRIMARY KEY  (cfg_name)
) TYPE=MyISAM;

#
# Daten für Tabelle `cc_banner_config`
#

INSERT INTO cc_banner_config (cfg_name, cfg_value) VALUES ('email_admin', 'Ihre@eamiladresse-eingeben.de');
INSERT INTO cc_banner_config (cfg_name, cfg_value) VALUES ('language', 'german');
INSERT INTO cc_banner_config (cfg_name, cfg_value) VALUES ('signature_admin', 'Das Online Team\r\nBannerverwaltung');
INSERT INTO cc_banner_config (cfg_name, cfg_value) VALUES ('time_zone', '1');
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `cc_banner_probability`
#

CREATE TABLE cc_banner_probability (
  banner_id int(10) unsigned NOT NULL default '0',
  banner_probability int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (banner_id)
) TYPE=MyISAM;

#
# Daten für Tabelle `cc_banner_probability`
#

INSERT INTO cc_banner_probability (banner_id, banner_probability) VALUES (1, 5);
INSERT INTO cc_banner_probability (banner_id, banner_probability) VALUES (2, 5);
INSERT INTO cc_banner_probability (banner_id, banner_probability) VALUES (3, 5);
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `cc_banner_sizes`
#

CREATE TABLE cc_banner_sizes (
  size_id tinyint(3) unsigned NOT NULL auto_increment,
  size_name tinytext NOT NULL,
  banner_width varchar(5) NOT NULL default '',
  banner_height varchar(5) NOT NULL default '',
  PRIMARY KEY  (size_id)
) TYPE=MyISAM;

#
# Daten für Tabelle `cc_banner_sizes`
#

INSERT INTO cc_banner_sizes (size_id, size_name, banner_width, banner_height) VALUES (1, '1. Vollbanner 468x60', '468', '60');
INSERT INTO cc_banner_sizes (size_id, size_name, banner_width, banner_height) VALUES (2, '2. Kleiner Banner 149x60', '149', '60');
INSERT INTO cc_banner_sizes (size_id, size_name, banner_width, banner_height) VALUES (3, '3. Halber Banner 234x60', '234', '60');
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `cc_banner_users`
#

CREATE TABLE cc_banner_users (
  user_id smallint(5) unsigned NOT NULL auto_increment,
  user_name varchar(64) NOT NULL default '',
  user_password varchar(31) NOT NULL default '',
  user_mail varchar(127) NOT NULL default '',
  user_telephone varchar(31) NOT NULL default '',
  user_fax varchar(31) NOT NULL default '',
  user_street varchar(31) NOT NULL default '',
  user_postal_code varchar(6) NOT NULL default '',
  user_residence varchar(31) NOT NULL default '',
  user_language varchar(30) NOT NULL default '',
  user_rank char(1) NOT NULL default '0',
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;

#
# Daten für Tabelle `cc_banner_users`
#

INSERT INTO cc_banner_users (user_id, user_name, user_password, user_mail, user_telephone, user_fax, user_street, user_postal_code, user_residence, user_language, user_rank) VALUES (1, 'admin', 'admin', 'muss-noch@eingegeben-werden.de', '00000-00000', '', 'Adminweg 22', '00000', 'Irgendwo', 'german', '1');