100128_mensch.coop_repairDB.sql
3.41 KB
update losp_be_account set Password=SHA1('test') where ID=2;
update losp_be_account set Password=SHA1('test') where ID=3;
update losp_be_account set Password=SHA1('test') where ID=4;
update losp_be_account set Password=SHA1('test') where ID=5;
-- fuer das testsystem
INSERT INTO `losp_BE_profile` (`MTextID`, `NickName`, `EMail`, `Fingerprint`, `Jabber`, `Url`, `OnlineState`, `OnlineSince`, `Avatar`, `Signature`) VALUES (3, 'test2', 'test2@mensch.coop', 'ddddd', 'dddddd', 'dddddd', '1', 1264522148, 'dddddd', 'ddddddd ');
INSERT INTO `losp_BasisElement` (`ID`, `Author_ProfileID`, `Subject`, `Text`, `CreateDate`, `TagListID`, `BECategoryListID`, `BECategoryChoiceBEID`, `BasisElementDesignID`, `AuthReadListID`, `AuthWriteListID`, `ClassID`, `LanguageCode`) VALUES (3, 3, 'Paul Testing. Profile Subject2 2', 'Paul bla bal bla Beschreibungstext', '2009-12-31 11:26:58', 309, NULL, 9, 71, 0, 3, 23, 'deu');
insert into losp_BasisElement_writeauthorisation (ListID, ProfileID) values (3,3);
ALTER TABLE `losp_BasisClipboard` ADD INDEX ( `LinkerProfileID` ) ;
ALTER TABLE `losp_BasisClipboard` ADD FOREIGN KEY ( `LinkerProfileID` ) REFERENCES losp_BE_profile ( `MTextID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BasisClipboard` ADD FOREIGN KEY ( `PartOfID` ) REFERENCES losp_BasisElement ( `ID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BasisClipboard` ADD FOREIGN KEY ( `PartOfObjVarID` ) REFERENCES losp_BasisClipboard_objvar ( `PartOfObjVarID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BasisClipboard` ADD FOREIGN KEY ( `AttachID` ) REFERENCES losp_BasisElement ( `ID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BasisClipboard` ADD FOREIGN KEY ( `AttachStateID` ) REFERENCES losp_BasisClipboard_state ( `StateID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BasisClipboard` ADD FOREIGN KEY ( `CategoryID` ) REFERENCES losp_BasisClipboard_category ( `CategoryID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BE_topic` ADD FOREIGN KEY ( `MTextID` ) REFERENCES losp_BasisElement ( `ID` ) ON DELETE CASCADE ;
ALTER TABLE `losp_BE_location` ADD FOREIGN KEY ( `MTextID` ) REFERENCES losp_BasisElement ( `ID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BE_profile` ADD FOREIGN KEY ( `MTextID` ) REFERENCES losp_BasisElement ( `ID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BasisElementDesign` ADD INDEX ( `Author_ProfileID` ) ;
ALTER TABLE `losp_BasisElementDesign` ADD FOREIGN KEY ( `Author_ProfileID` ) REFERENCES losp_BE_profile ( `MTextID` ) ON DELETE SET NULL ON UPDATE CASCADE ;
ALTER TABLE `losp_BasisElementDesign_values` ADD FOREIGN KEY ( `ID` ) REFERENCES losp_BasisElementDesign ( `ID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_BasisElement_categorynamelist` ADD INDEX ( `BECategoryGroupID` ) ;
ALTER TABLE `losp_BasisElement_categorynamelist` ADD FOREIGN KEY ( `BECategoryGroupID` ) REFERENCES losp_BasisElement_categorynamelist (`BECategoryID`) ON DELETE CASCADE ON UPDATE CASCADE ;
ALTER TABLE `losp_be_account` ADD INDEX ( `ProfileID` ) ;
ALTER TABLE `losp_be_account` ADD FOREIGN KEY ( `ProfileID` ) REFERENCES losp_BE_profile ( `MTextID` ) ON DELETE SET NULL ON UPDATE CASCADE ;
ALTER TABLE `losp_BE_treepart` DROP FOREIGN KEY `losp_BE_treepart_ibfk_1` ;
ALTER TABLE `losp_BE_treepart` ADD FOREIGN KEY ( `MTextID` ) REFERENCES losp_BasisElement ( `ID` ) ON DELETE CASCADE ON UPDATE CASCADE ;