Hallo Liebe Leser....
Ich versuche seit paar tage schon eine sql zu erseten nur kommt immer der selbe fehler....
[Err] 1304 - PROCEDURE deleteDeadVehicles already exists
[Err] --
-- Database: `arma3life`
--
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
BEGIN
DELETE FROM `vehicles` WHERE `alive` = 0;
END;
[Err] 1304 - PROCEDURE deleteOldGangs already exists
[Err] CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
BEGIN
DELETE FROM `gangs` WHERE `active` = 0;
END;
[Err] 1304 - PROCEDURE deleteOldHouses already exists
[Err] CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
BEGIN
DELETE FROM `houses` WHERE `owned` = 0;
END;
[Err] 1304 - PROCEDURE resetLifeVehicles already exists
[Err] CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE vehicles SET `active`= 0;
END;
[Err] 1068 - Multiple primary key defined
[Err] --
-- Dumping data for table `vehicles`
--
--
-- Indexes for dumped tables
--
--
-- Indexes for table `gangs`
--
ALTER TABLE `gangs`
ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`);
[Err] 1068 - Multiple primary key defined
[Err] --
-- Indexes for table `houses`
--
ALTER TABLE `houses`
ADD PRIMARY KEY (`id`,`pid`);
[Err] 1068 - Multiple primary key defined
[Err] --
-- Indexes for table `players`
--
ALTER TABLE `players`
ADD PRIMARY KEY (`uid`), ADD UNIQUE KEY `playerid` (`playerid`), ADD KEY `name` (`name`), ADD KEY `blacklist` (`blacklist`);
[Err] 1068 - Multiple primary key defined
[Err] --
-- Indexes for table `vehicles`
--
ALTER TABLE `vehicles`
ADD PRIMARY KEY (`id`), ADD KEY `side` (`side`), ADD KEY `pid` (`pid`), ADD KEY `type` (`type`);
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Währe echt cool wenn sich hier wer finden lassen tut der mir da eine lösung vorschlagen kann...
Lg. Dibo
?
