MyBB.de Forum
BackUp Problem. =( - Druckversion

+- MyBB.de Forum (https://www.mybb.de/forum)
+-- Forum: Archiv (https://www.mybb.de/forum/forum-57.html)
+--- Forum: MyBB 1.2.x und älter (https://www.mybb.de/forum/forum-27.html)
+---- Forum: Allgemeiner Support (https://www.mybb.de/forum/forum-36.html)
+---- Thema: BackUp Problem. =( (/thread-8688.html)

BackUp Problem. =( - Sunny Boy 13 - 17.02.2008

Hey Leute wenn ich mein Backup raufladen möchte kommt immer diese Fehlermeldung.
SQL-Befehl:

-- MyBB Database Backup
-- Generated: 15th February 2008 at 17:31
-- -------------------------------------
CREATE TABLE `adm_announcements` (

`ann_id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`ann_org_shortname` varchar( 10 ) NOT NULL ,
`ann_global` tinyint( 1 ) unsigned NOT NULL default '0',
`ann_headline` varchar( 50 ) NOT NULL ,
`ann_description` text,
`ann_usr_id` int( 11 ) unsigned default NULL ,
`ann_timestamp` datetime NOT NULL ,
`ann_last_change` datetime default NULL ,
`ann_usr_id_change` int( 11 ) unsigned default NULL ,
PRIMARY KEY ( `ann_id` ) ,
KEY `ANN_ORG_FK` ( `ann_org_shortname` ) ,
KEY `ANN_USR_FK` ( `ann_usr_id` ) ,
KEY `ANN_USR_CHANGE_FK` ( `ann_usr_id_change` ) ,
CONSTRAINT `adm_FK_ANN_ORG` FOREIGN KEY ( `ann_org_shortname` ) REFERENCES `adm_organizations` ( `org_shortname` ) ,
CONSTRAINT `adm_FK_ANN_USR` FOREIGN KEY ( `ann_usr_id` ) REFERENCES `adm_users` ( `usr_id` ) ,
CONSTRAINT `adm_FK_ANN_USR_CHANGE` FOREIGN KEY ( `ann_usr_id_change` ) REFERENCES `adm_users` ( `usr_id` ) ON DELETE SET NULL
) ENGINE = InnoDB DEFAULT CHARSET = latin1;



MySQL meldet:

#1005 - Can't create table './usr_web586_1/adm_announcements.frm' (errno: 150)

[ Zurück ]

RE: BackUp Problem. =( - Michael - 17.02.2008

Zitat:If MySQL reports an error number 1005 from a CREATE TABLE statement, and the error message refers to errno 150, table creation failed because a foreign key constraint was not correctly formed. Similarly, if an ALTER TABLE fails and it refers to errno 150, that means a foreign key definition would be incorrectly formed for the altered table. You can use SHOW ENGINE INNODB STATUS to display a detailed explanation of the most recent InnoDB foreign key error in the server.
Quelle: http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

Kurz: Es liegt an den FOREIGN KEYS in den Queries. Womit hattest du das denn exportiert?

RE: BackUp Problem. =( - Sunny Boy 13 - 18.02.2008

Was meinst du mit exortiert?.

Und was kann ich jetzt machen das die Datenbank das BackUp annimmt?
Naja bin nicht der größte in Englisch ;(.
Kannst du mir vl weiter helfen?

RE: BackUp Problem. =( - Sunny Boy 13 - 18.02.2008

Hab es geschaft.
Habe
Code:
CREATE TABLE `adm_announcements` (
  `ann_id` int(11) unsigned NOT NULL auto_increment,
  `ann_org_shortname` varchar(10) NOT NULL,
  `ann_global` tinyint(1) unsigned NOT NULL default '0',
  `ann_headline` varchar(50) NOT NULL,
  `ann_description` text,
  `ann_usr_id` int(11) unsigned default NULL,
  `ann_timestamp` datetime NOT NULL,
  `ann_last_change` datetime default NULL,
  `ann_usr_id_change` int(11) unsigned default NULL,
  PRIMARY KEY  (`ann_id`),
  KEY `ANN_ORG_FK` (`ann_org_shortname`),
  KEY `ANN_USR_FK` (`ann_usr_id`),
  KEY `ANN_USR_CHANGE_FK` (`ann_usr_id_change`),
  CONSTRAINT `adm_FK_ANN_ORG` FOREIGN KEY (`ann_org_shortname`) REFERENCES `adm_organizations` (`org_shortname`),
  CONSTRAINT `adm_FK_ANN_USR` FOREIGN KEY (`ann_usr_id`) REFERENCES `adm_users` (`usr_id`),
  CONSTRAINT `adm_FK_ANN_USR_CHANGE` FOREIGN KEY (`ann_usr_id_change`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_categories` (
  `cat_id` int(11) unsigned NOT NULL auto_increment,
  `cat_org_id` tinyint(4) NOT NULL,
  `cat_type` varchar(10) NOT NULL,
  `cat_name` varchar(30) NOT NULL,
  `cat_hidden` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `CAT_ORG_FK` (`cat_org_id`),
  CONSTRAINT `adm_FK_CAT_ORG` FOREIGN KEY (`cat_org_id`) REFERENCES `adm_organizations` (`org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO adm_categories (cat_id,cat_org_id,cat_type,cat_name,cat_hidden) VALUES ('1','1','ROL','Allgemein','1');
INSERT INTO adm_categories (cat_id,cat_org_id,cat_type,cat_name,cat_hidden) VALUES ('2','1','ROL','Gruppen','1');
INSERT INTO adm_categories (cat_id,cat_org_id,cat_type,cat_name,cat_hidden) VALUES ('3','1','ROL','Kurse','1');
INSERT INTO adm_categories (cat_id,cat_org_id,cat_type,cat_name,cat_hidden) VALUES ('4','1','ROL','Mannschaften','1');
INSERT INTO adm_categories (cat_id,cat_org_id,cat_type,cat_name,cat_hidden) VALUES ('5','1','LNK','Allgemein','0');
CREATE TABLE `adm_dates` (
  `dat_id` int(11) unsigned NOT NULL auto_increment,
  `dat_org_shortname` varchar(10) NOT NULL,
  `dat_global` tinyint(1) unsigned NOT NULL default '0',
  `dat_begin` datetime NOT NULL,
  `dat_end` datetime default NULL,
  `dat_description` text,
  `dat_location` varchar(100) default NULL,
  `dat_headline` varchar(50) NOT NULL,
  `dat_usr_id` int(11) unsigned default NULL,
  `dat_timestamp` datetime NOT NULL,
  `dat_last_change` datetime default NULL,
  `dat_usr_id_change` int(11) unsigned default NULL,
  PRIMARY KEY  (`dat_id`),
  KEY `DAT_ORG_FK` (`dat_org_shortname`),
  KEY `DAT_USR_FK` (`dat_usr_id`),
  KEY `DAT_USR_CHANGE_FK` (`dat_usr_id_change`),
  CONSTRAINT `adm_FK_DAT_ORG` FOREIGN KEY (`dat_org_shortname`) REFERENCES `adm_organizations` (`org_shortname`),
  CONSTRAINT `adm_FK_DAT_USR` FOREIGN KEY (`dat_usr_id`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL,
  CONSTRAINT `adm_FK_DAT_USR_CHANGE` FOREIGN KEY (`dat_usr_id_change`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_guestbook` (
  `gbo_id` int(11) unsigned NOT NULL auto_increment,
  `gbo_org_id` tinyint(4) NOT NULL,
  `gbo_usr_id` int(11) unsigned default NULL,
  `gbo_name` varchar(60) NOT NULL,
  `gbo_text` text NOT NULL,
  `gbo_email` varchar(50) default NULL,
  `gbo_homepage` varchar(50) default NULL,
  `gbo_timestamp` datetime NOT NULL,
  `gbo_ip_address` varchar(15) NOT NULL,
  `gbo_last_change` datetime default NULL,
  `gbo_usr_id_change` int(11) unsigned default NULL,
  PRIMARY KEY  (`gbo_id`),
  KEY `GBO_ORG_FK` (`gbo_org_id`),
  KEY `GBO_USR_FK` (`gbo_usr_id`),
  KEY `GBO_USR_CHANGE_FK` (`gbo_usr_id_change`),
  CONSTRAINT `adm_FK_GBO_ORG` FOREIGN KEY (`gbo_org_id`) REFERENCES `adm_organizations` (`org_id`),
  CONSTRAINT `adm_FK_GBO_USR` FOREIGN KEY (`gbo_usr_id`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL,
  CONSTRAINT `adm_FK_GBO_USR_CHANGE` FOREIGN KEY (`gbo_usr_id_change`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_guestbook_comments` (
  `gbc_id` int(11) unsigned NOT NULL auto_increment,
  `gbc_gbo_id` int(11) unsigned NOT NULL,
  `gbc_usr_id` int(11) unsigned default NULL,
  `gbc_name` varchar(60) NOT NULL,
  `gbc_text` text NOT NULL,
  `gbc_email` varchar(50) default NULL,
  `gbc_timestamp` datetime NOT NULL,
  `gbc_ip_address` varchar(15) NOT NULL,
  `gbc_last_change` datetime default NULL,
  `gbc_usr_id_change` int(11) unsigned default NULL,
  PRIMARY KEY  (`gbc_id`),
  KEY `GBC_GBO_FK` (`gbc_gbo_id`),
  KEY `GBC_USR_FK` (`gbc_usr_id`),
  KEY `GBC_USR_CHANGE_FK` (`gbc_usr_id_change`),
  CONSTRAINT `adm_FK_GBC_GBO` FOREIGN KEY (`gbc_gbo_id`) REFERENCES `adm_guestbook` (`gbo_id`),
  CONSTRAINT `adm_FK_GBC_USR` FOREIGN KEY (`gbc_usr_id`) REFERENCES `adm_users` (`usr_id`),
  CONSTRAINT `adm_FK_GBC_USR_CHANGE` FOREIGN KEY (`gbc_usr_id_change`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_links` (
  `lnk_id` int(11) unsigned NOT NULL auto_increment,
  `lnk_org_id` tinyint(4) NOT NULL,
  `lnk_cat_id` int(11) unsigned NOT NULL,
  `lnk_name` varchar(255) NOT NULL,
  `lnk_description` text,
  `lnk_url` varchar(255) NOT NULL,
  `lnk_usr_id` int(11) unsigned default NULL,
  `lnk_timestamp` datetime NOT NULL,
  `lnk_usr_id_change` int(11) unsigned default NULL,
  `lnk_last_change` datetime default NULL,
  PRIMARY KEY  (`lnk_id`),
  KEY `LNK_ORG_FK` (`lnk_org_id`),
  KEY `LNK_USR_FK` (`lnk_usr_id`),
  KEY `LNK_CAT_FK` (`lnk_cat_id`),
  KEY `LNK_USR_CHANGE_FK` (`lnk_usr_id_change`),
  CONSTRAINT `adm_FK_LNK_CAT` FOREIGN KEY (`lnk_cat_id`) REFERENCES `adm_categories` (`cat_id`),
  CONSTRAINT `adm_FK_LNK_ORG` FOREIGN KEY (`lnk_org_id`) REFERENCES `adm_organizations` (`org_id`),
  CONSTRAINT `adm_FK_LNK_USR` FOREIGN KEY (`lnk_usr_id`) REFERENCES `adm_users` (`usr_id`),
  CONSTRAINT `adm_FK_LNK_USR_CHANGE` FOREIGN KEY (`lnk_usr_id_change`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_members` (
  `mem_id` int(11) NOT NULL auto_increment,
  `mem_rol_id` int(11) unsigned NOT NULL,
  `mem_usr_id` int(11) unsigned NOT NULL,
  `mem_begin` date NOT NULL,
  `mem_end` date default NULL,
  `mem_valid` tinyint(1) unsigned NOT NULL default '1',
  `mem_leader` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`mem_id`),
  UNIQUE KEY `ak_rol_usr_id` (`mem_rol_id`,`mem_usr_id`),
  KEY `MEM_ROL_FK` (`mem_rol_id`),
  KEY `MEM_USR_FK` (`mem_usr_id`),
  CONSTRAINT `adm_FK_MEM_ROL` FOREIGN KEY (`mem_rol_id`) REFERENCES `adm_roles` (`rol_id`),
  CONSTRAINT `adm_FK_MEM_USR` FOREIGN KEY (`mem_usr_id`) REFERENCES `adm_users` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO adm_members (mem_id,mem_rol_id,mem_usr_id,mem_begin,mem_end,mem_valid,mem_leader) VALUES ('1','1','1','2008-02-10','','1','0');
INSERT INTO adm_members (mem_id,mem_rol_id,mem_usr_id,mem_begin,mem_end,mem_valid,mem_leader) VALUES ('2','2','1','2008-02-10','','1','0');
CREATE TABLE `adm_organizations` (
  `org_id` tinyint(4) NOT NULL auto_increment,
  `org_longname` varchar(60) NOT NULL,
  `org_shortname` varchar(10) NOT NULL,
  `org_org_id_parent` tinyint(4) default NULL,
  `org_homepage` varchar(30) NOT NULL,
  PRIMARY KEY  (`org_id`),
  UNIQUE KEY `ak_shortname` (`org_shortname`),
  KEY `ORG_ORG_PARENT_FK` (`org_org_id_parent`),
  CONSTRAINT `adm_FK_ORG_ORG_PARENT` FOREIGN KEY (`org_org_id_parent`) REFERENCES `adm_organizations` (`org_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO adm_organizations (org_id,org_longname,org_shortname,org_org_id_parent,org_homepage) VALUES ('1','K-Deluxe','K-Deluxe','','www.k-deluxe.de');
CREATE TABLE `adm_photos` (
  `pho_id` int(11) unsigned NOT NULL auto_increment,
  `pho_org_shortname` varchar(10) NOT NULL,
  `pho_quantity` int(11) unsigned NOT NULL default '0',
  `pho_name` varchar(50) NOT NULL,
  `pho_begin` date NOT NULL default '0000-00-00',
  `pho_end` date NOT NULL default '0000-00-00',
  `pho_photographers` varchar(100) default NULL,
  `pho_usr_id` int(11) unsigned default NULL,
  `pho_timestamp` datetime NOT NULL,
  `pho_locked` tinyint(1) unsigned NOT NULL default '0',
  `pho_pho_id_parent` int(11) unsigned default NULL,
  `pho_last_change` datetime default NULL,
  `pho_usr_id_change` int(11) unsigned default NULL,
  PRIMARY KEY  (`pho_id`),
  KEY `PHO_ORG_FK` (`pho_org_shortname`),
  KEY `PHO_USR_FK` (`pho_usr_id`),
  KEY `PHO_USR_CHANGE_FK` (`pho_usr_id_change`),
  KEY `FK_PHO_PHO_PARENT_FK` (`pho_pho_id_parent`),
  CONSTRAINT `adm_FK_PHO_ORG` FOREIGN KEY (`pho_org_shortname`) REFERENCES `adm_organizations` (`org_shortname`),
  CONSTRAINT `adm_FK_PHO_PHO_PARENT` FOREIGN KEY (`pho_pho_id_parent`) REFERENCES `adm_photos` (`pho_id`) ON DELETE SET NULL,
  CONSTRAINT `adm_FK_PHO_USR` FOREIGN KEY (`pho_usr_id`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL,
  CONSTRAINT `adm_FK_PHO_USR_CHANGE` FOREIGN KEY (`pho_usr_id_change`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_preferences` (
  `prf_id` int(11) unsigned NOT NULL auto_increment,
  `prf_org_id` tinyint(4) NOT NULL,
  `prf_name` varchar(30) NOT NULL,
  `prf_value` varchar(255) default NULL,
  PRIMARY KEY  (`prf_id`),
  KEY `PRF_ORG_FK` (`prf_org_id`),
  CONSTRAINT `adm_FK_PRF_ORG` FOREIGN KEY (`prf_org_id`) REFERENCES `adm_organizations` (`org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('1','1','enable_rss','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('2','1','enable_bbcode','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('3','1','logout_minutes','20');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('4','1','enable_system_mails','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('5','1','email_administrator','webmaster@www.k-deluxe.de');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('6','1','registration_mode','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('7','1','enable_registration_captcha','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('8','1','enable_registration_admin_mail','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('9','1','enable_mail_module','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('10','1','max_email_attachment_size','1024');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('11','1','enable_mail_captcha','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('12','1','enable_photo_module','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('13','1','photo_save_scale','640');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('14','1','photo_thumbs_column','5');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('15','1','photo_thumbs_row','5');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('16','1','photo_thumbs_scale','100');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('17','1','photo_show_width','500');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('18','1','photo_show_height','380');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('19','1','photo_image_text','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('20','1','photo_preview_scale','100');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('21','1','enable_guestbook_module','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('22','1','enable_guestbook_captcha','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('23','1','flooding_protection_time','180');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('24','1','enable_gbook_comments4all','0');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('25','1','enable_weblinks_module','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('26','1','enable_download_module','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('27','1','max_file_upload_size','3072');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('28','1','enable_announcements_module','1');
INSERT INTO adm_preferences (prf_id,prf_org_id,prf_name,prf_value) VALUES ('29','1','enable_dates_module','1');
CREATE TABLE `adm_role_dependencies` (
  `rld_rol_id_parent` int(11) unsigned NOT NULL,
  `rld_rol_id_child` int(11) unsigned NOT NULL,
  `rld_comment` text,
  `rld_usr_id` int(11) unsigned default NULL,
  `rld_timestamp` datetime NOT NULL,
  PRIMARY KEY  (`rld_rol_id_parent`,`rld_rol_id_child`),
  KEY `RLD_USR_FK` (`rld_usr_id`),
  KEY `RLD_ROL_PARENT_FK` (`rld_rol_id_parent`),
  KEY `RLD_ROL_CHILD_FK` (`rld_rol_id_child`),
  CONSTRAINT `adm_FK_RLD_ROL_CHILD` FOREIGN KEY (`rld_rol_id_child`) REFERENCES `adm_roles` (`rol_id`),
  CONSTRAINT `adm_FK_RLD_ROL_PARENT` FOREIGN KEY (`rld_rol_id_parent`) REFERENCES `adm_roles` (`rol_id`),
  CONSTRAINT `adm_FK_RLD_USR` FOREIGN KEY (`rld_usr_id`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_roles` (
  `rol_id` int(11) unsigned NOT NULL auto_increment,
  `rol_org_shortname` varchar(10) NOT NULL,
  `rol_cat_id` int(11) unsigned NOT NULL,
  `rol_name` varchar(30) NOT NULL,
  `rol_description` varchar(255) default NULL,
  `rol_moderation` tinyint(1) unsigned NOT NULL default '0',
  `rol_announcements` tinyint(1) unsigned NOT NULL default '0',
  `rol_dates` tinyint(1) unsigned NOT NULL default '0',
  `rol_download` tinyint(1) unsigned NOT NULL default '0',
  `rol_edit_user` tinyint(1) unsigned NOT NULL default '0',
  `rol_guestbook` tinyint(1) unsigned NOT NULL default '0',
  `rol_guestbook_comments` tinyint(1) unsigned NOT NULL default '0',
  `rol_mail_logout` tinyint(1) unsigned NOT NULL default '0',
  `rol_mail_login` tinyint(1) unsigned NOT NULL default '0',
  `rol_photo` tinyint(1) unsigned NOT NULL default '0',
  `rol_profile` tinyint(1) unsigned NOT NULL default '0',
  `rol_weblinks` tinyint(1) unsigned NOT NULL default '0',
  `rol_locked` tinyint(1) unsigned NOT NULL default '0',
  `rol_start_date` date default NULL,
  `rol_start_time` time default NULL,
  `rol_end_date` date default NULL,
  `rol_end_time` time default NULL,
  `rol_weekday` tinyint(1) default NULL,
  `rol_location` varchar(30) default NULL,
  `rol_max_members` smallint(3) unsigned default NULL,
  `rol_cost` float unsigned default NULL,
  `rol_last_change` datetime default NULL,
  `rol_usr_id_change` int(7) unsigned default NULL,
  `rol_valid` tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`rol_id`),
  KEY `ROL_ORG_FK` (`rol_org_shortname`),
  KEY `ROL_CAT_FK` (`rol_cat_id`),
  KEY `ROL_USR_FK` (`rol_usr_id_change`),
  CONSTRAINT `adm_FK_ROL_CAT` FOREIGN KEY (`rol_cat_id`) REFERENCES `adm_categories` (`cat_id`),
  CONSTRAINT `adm_FK_ROL_ORG` FOREIGN KEY (`rol_org_shortname`) REFERENCES `adm_organizations` (`org_shortname`),
  CONSTRAINT `adm_FK_ROL_USR` FOREIGN KEY (`rol_usr_id_change`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO adm_roles (rol_id,rol_org_shortname,rol_cat_id,rol_name,rol_description,rol_moderation,rol_announcements,rol_dates,rol_download,rol_edit_user,rol_guestbook,rol_guestbook_comments,rol_mail_logout,rol_mail_login,rol_photo,rol_profile,rol_weblinks,rol_locked,rol_start_date,rol_start_time,rol_end_date,rol_end_time,rol_weekday,rol_location,rol_max_members,rol_cost,rol_last_change,rol_usr_id_change,rol_valid) VALUES ('1','K-Deluxe','1','Webmaster','Gruppe der Administratoren des Systems','1','1','1','1','1','1','1','1','1','1','1','1','0','','','','','','','','','','','1');
INSERT INTO adm_roles (rol_id,rol_org_shortname,rol_cat_id,rol_name,rol_description,rol_moderation,rol_announcements,rol_dates,rol_download,rol_edit_user,rol_guestbook,rol_guestbook_comments,rol_mail_logout,rol_mail_login,rol_photo,rol_profile,rol_weblinks,rol_locked,rol_start_date,rol_start_time,rol_end_date,rol_end_time,rol_weekday,rol_location,rol_max_members,rol_cost,rol_last_change,rol_usr_id_change,rol_valid) VALUES ('2','K-Deluxe','1','Mitglied','Alle Mitglieder der Organisation','0','0','0','0','0','0','0','0','1','0','1','0','0','','','','','','','','','','','1');
INSERT INTO adm_roles (rol_id,rol_org_shortname,rol_cat_id,rol_name,rol_description,rol_moderation,rol_announcements,rol_dates,rol_download,rol_edit_user,rol_guestbook,rol_guestbook_comments,rol_mail_logout,rol_mail_login,rol_photo,rol_profile,rol_weblinks,rol_locked,rol_start_date,rol_start_time,rol_end_date,rol_end_time,rol_weekday,rol_location,rol_max_members,rol_cost,rol_last_change,rol_usr_id_change,rol_valid) VALUES ('3','K-Deluxe','1','Vorstand','Vorstand des Vereins','0','1','1','0','1','0','0','1','1','0','1','1','0','','','','','','','','','','','1');
CREATE TABLE `adm_sessions` (
  `ses_id` int(11) unsigned NOT NULL auto_increment,
  `ses_usr_id` int(11) unsigned NOT NULL,
  `ses_org_shortname` varchar(10) NOT NULL,
  `ses_session` varchar(35) NOT NULL,
  `ses_timestamp` datetime NOT NULL,
  `ses_ip_address` varchar(15) default NULL,
  `ses_blob` blob,
  PRIMARY KEY  (`ses_id`),
  KEY `ak_session` (`ses_session`),
  KEY `SES_USR_FK` (`ses_usr_id`),
  KEY `SES_ORG_FK` (`ses_org_shortname`),
  CONSTRAINT `adm_FK_SES_ORG` FOREIGN KEY (`ses_org_shortname`) REFERENCES `adm_organizations` (`org_shortname`),
  CONSTRAINT `adm_FK_SES_USR` FOREIGN KEY (`ses_usr_id`) REFERENCES `adm_users` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_texts` (
  `txt_id` int(11) unsigned NOT NULL,
  `txt_org_id` tinyint(4) NOT NULL,
  `txt_name` varchar(30) NOT NULL,
  `txt_text` text,
  PRIMARY KEY  (`txt_id`),
  KEY `TXT_ORG_FK` (`txt_org_id`),
  CONSTRAINT `adm_FK_TXT_ORG` FOREIGN KEY (`txt_org_id`) REFERENCES `adm_organizations` (`org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_user_data` (
  `usd_id` int(11) unsigned NOT NULL auto_increment,
  `usd_usr_id` int(11) unsigned NOT NULL,
  `usd_usf_id` int(11) unsigned NOT NULL,
  `usd_value` varchar(255) default NULL,
  PRIMARY KEY  (`usd_id`),
  UNIQUE KEY `ak_usr_usf_id` (`usd_usr_id`,`usd_usf_id`),
  KEY `USD_USF_FK` (`usd_usf_id`),
  KEY `USD_USR_FK` (`usd_usr_id`),
  CONSTRAINT `adm_FK_USD_USF` FOREIGN KEY (`usd_usf_id`) REFERENCES `adm_user_fields` (`usf_id`),
  CONSTRAINT `adm_FK_USD_USR` FOREIGN KEY (`usd_usr_id`) REFERENCES `adm_users` (`usr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_user_fields` (
  `usf_id` int(11) unsigned NOT NULL auto_increment,
  `usf_org_shortname` varchar(10) default NULL,
  `usf_type` varchar(10) NOT NULL,
  `usf_name` varchar(100) NOT NULL,
  `usf_description` varchar(255) default NULL,
  `usf_locked` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`usf_id`),
  KEY `USF_ORG_FK` (`usf_org_shortname`),
  CONSTRAINT `adm_FK_USF_ORG` FOREIGN KEY (`usf_org_shortname`) REFERENCES `adm_organizations` (`org_shortname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO adm_user_fields (usf_id,usf_org_shortname,usf_type,usf_name,usf_description,usf_locked) VALUES ('1','','MESSENGER','AIM','AOL Instant Messenger','0');
INSERT INTO adm_user_fields (usf_id,usf_org_shortname,usf_type,usf_name,usf_description,usf_locked) VALUES ('2','','MESSENGER','ICQ','ICQ','0');
INSERT INTO adm_user_fields (usf_id,usf_org_shortname,usf_type,usf_name,usf_description,usf_locked) VALUES ('3','','MESSENGER','MSN','MSN Messenger','0');
INSERT INTO adm_user_fields (usf_id,usf_org_shortname,usf_type,usf_name,usf_description,usf_locked) VALUES ('4','','MESSENGER','Yahoo','Yahoo! Messenger','0');
INSERT INTO adm_user_fields (usf_id,usf_org_shortname,usf_type,usf_name,usf_description,usf_locked) VALUES ('5','','MESSENGER','Skype','Skype','0');
INSERT INTO adm_user_fields (usf_id,usf_org_shortname,usf_type,usf_name,usf_description,usf_locked) VALUES ('6','','MESSENGER','Google Talk','Google Talk','0');
CREATE TABLE `adm_users` (
  `usr_id` int(11) unsigned NOT NULL auto_increment,
  `usr_last_name` varchar(30) NOT NULL,
  `usr_first_name` varchar(30) NOT NULL,
  `usr_address` varchar(50) default NULL,
  `usr_zip_code` varchar(10) default NULL,
  `usr_city` varchar(30) default NULL,
  `usr_country` varchar(30) default NULL,
  `usr_phone` varchar(20) default NULL,
  `usr_mobile` varchar(20) default NULL,
  `usr_fax` varchar(20) default NULL,
  `usr_birthday` date default NULL,
  `usr_gender` tinyint(1) unsigned default NULL,
  `usr_email` varchar(50) default NULL,
  `usr_homepage` varchar(50) default NULL,
  `usr_login_name` varchar(20) default NULL,
  `usr_password` varchar(35) default NULL,
  `usr_photo` blob,
  `usr_last_login` datetime default NULL,
  `usr_actual_login` datetime default NULL,
  `usr_number_login` smallint(5) unsigned NOT NULL default '0',
  `usr_date_invalid` datetime default NULL,
  `usr_number_invalid` tinyint(3) unsigned NOT NULL default '0',
  `usr_last_change` datetime default NULL,
  `usr_usr_id_change` int(11) unsigned default NULL,
  `usr_valid` tinyint(1) unsigned NOT NULL default '0',
  `usr_reg_org_shortname` varchar(10) default NULL,
  PRIMARY KEY  (`usr_id`),
  UNIQUE KEY `ak_usr_login_name` (`usr_login_name`),
  KEY `USR_USR_CHANGE_FK` (`usr_usr_id_change`),
  KEY `USR_ORG_REG_FK` (`usr_reg_org_shortname`),
  CONSTRAINT `adm_FK_USR_ORG_REG` FOREIGN KEY (`usr_reg_org_shortname`) REFERENCES `adm_organizations` (`org_shortname`),
  CONSTRAINT `adm_FK_USR_USR_CHANGE` FOREIGN KEY (`usr_usr_id_change`) REFERENCES `adm_users` (`usr_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO adm_users (usr_id,usr_last_name,usr_first_name,usr_address,usr_zip_code,usr_city,usr_country,usr_phone,usr_mobile,usr_fax,usr_birthday,usr_gender,usr_email,usr_homepage,usr_login_name,usr_password,usr_photo,usr_last_login,usr_actual_login,usr_number_login,usr_date_invalid,usr_number_invalid,usr_last_change,usr_usr_id_change,usr_valid,usr_reg_org_shortname) VALUES ('1','Renee','Steiner','','','','','','','','','','renee.steiner33@chello.at','','Sunny Boy 13','9591f5935d7df48f5484bd6619ff8c33','','','','0','','0','','','1','');
Gelöscht weil die Tabellen von verschiedernen Scripte waren.