[DiscordArchive] is it being re-ran?
[DiscordArchive] is it being re-ran?
Original source
```sql
-- --------------------------------------------------------
-- Värd: 127.0.0.1
-- Serverversion: 8.0.28 - MySQL Community Server - GPL
-- Server-OS: Win64
-- HeidiSQL Version: 11.3.0.6295
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumpar struktur för tabell acore_characters.character_homebind
DROP TABLE IF EXISTS `character_homebind`;
CREATE TABLE IF NOT EXISTS `character_homebind` (
`guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
`posX` float NOT NULL DEFAULT '0',
`posY` float NOT NULL DEFAULT '0',
`posZ` float NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System';
-- Dumpar data för tabell acore_characters.character_homebind: ~0 rows (ungefär)
DELETE FROM `character_homebind`;
/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
```this is the file which should've run when auto populating
rektbyfaith
01-08-2023, 12:48 AM #11Archived author: Veltrix • Posted: 2023-01-08T00:48:38.858000+00:00
Original source
```sql
-- --------------------------------------------------------
-- Värd: 127.0.0.1
-- Serverversion: 8.0.28 - MySQL Community Server - GPL
-- Server-OS: Win64
-- HeidiSQL Version: 11.3.0.6295
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumpar struktur för tabell acore_characters.character_homebind
DROP TABLE IF EXISTS `character_homebind`;
CREATE TABLE IF NOT EXISTS `character_homebind` (
`guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
`posX` float NOT NULL DEFAULT '0',
`posY` float NOT NULL DEFAULT '0',
`posZ` float NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System';
-- Dumpar data för tabell acore_characters.character_homebind: ~0 rows (ungefär)
DELETE FROM `character_homebind`;
/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
```this is the file which should've run when auto populating
Original source
i know that update has been a issue with a few people in the past. the next squash should fix it. but let me see something.
rektbyfaith
01-08-2023, 12:49 AM #12Archived author: M'Dic • Posted: 2023-01-08T00:49:41.839000+00:00
Original source
i know that update has been a issue with a few people in the past. the next squash should fix it. but let me see something.
Original source
```cpp
DROP TABLE IF EXISTS `character_homebind`;
CREATE TABLE IF NOT EXISTS `character_homebind` (
`guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
`posX` float NOT NULL DEFAULT '0',
`posY` float NOT NULL DEFAULT '0',
`posZ` float NOT NULL DEFAULT '0',
`posO` float NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System';
```
rektbyfaith
01-08-2023, 12:50 AM #13Archived author: M'Dic • Posted: 2023-01-08T00:50:11.128000+00:00
Original source
```cpp
DROP TABLE IF EXISTS `character_homebind`;
CREATE TABLE IF NOT EXISTS `character_homebind` (
`guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
`posX` float NOT NULL DEFAULT '0',
`posY` float NOT NULL DEFAULT '0',
`posZ` float NOT NULL DEFAULT '0',
`posO` float NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System';
```
Original source
do that and see if that helps it pass thru
rektbyfaith
01-08-2023, 12:50 AM #14Archived author: M'Dic • Posted: 2023-01-08T00:50:26.959000+00:00
Original source
do that and see if that helps it pass thru
1 Guest(s)
1 Guest(s)