Beiträge: 453
Themen: 114
Registriert seit: 20.11.2006
MyBB-Version: 1.2.9
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 ]
Beiträge: 18.383
Themen: 257
Registriert seit: 09.02.2005
17.02.2008, 23:24
(Dieser Beitrag wurde zuletzt bearbeitet: 18.02.2008, 15:22 von Michael.)
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/i...aints.html
Kurz: Es liegt an den FOREIGN KEYS in den Queries. Womit hattest du das denn exportiert?
Gruß,
Michael
Support erfolgt NUR im Forum!
Bitte gelöste Themen als "erledigt" markieren.
Beiträge mit mangelhafter Rechtschreibung/Grammatik werden kommentarlos gelöscht.
Beiträge: 453
Themen: 114
Registriert seit: 20.11.2006
MyBB-Version: 1.2.9
18.02.2008, 04:09
(Dieser Beitrag wurde zuletzt bearbeitet: 18.02.2008, 04:15 von Sunny Boy 13.)
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?
Beiträge: 453
Themen: 114
Registriert seit: 20.11.2006
MyBB-Version: 1.2.9
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.
|