having some problems with znotes mysql

[fernando1027]

well i been having the same problem for days here is a pic

if you could help me...

 

[Limos]

Import the right schema, the one from your server.
Or if you already have players in this database, you can use it as example and run queries for the missing parts.

 

[fernando1027]

well how do you know which is the correct schema ...

 

[Limos]

In your server folder, depense on which server you use, which you forgot to mention.
But it's probable something like schema.sql or in the folder schemas and then mysql.sql.

 

[fernando1027]

oo ok that it did not come with it i just got it from other server and the server it says

 

[Limos]

CREATE TABLE `house_auctions`
(
   `house_id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `player_id` INT NOT NULL,
   `bid` INT UNSIGNED NOT NULL DEFAULT 0,
   `limit` INT UNSIGNED NOT NULL DEFAULT 0,
   `endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
   UNIQUE (`house_id`, `world_id`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,
   FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

DROP TABLE IF EXISTS `houses`;

CREATE TABLE `houses`
(
   `id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `owner` INT NOT NULL,
   `paid` INT UNSIGNED NOT NULL DEFAULT 0,
   `warnings` INT NOT NULL DEFAULT 0,
   `lastwarning` INT UNSIGNED NOT NULL DEFAULT 0,
   `name` VARCHAR(255) NOT NULL,
   `town` INT UNSIGNED NOT NULL DEFAULT 0,
   `size` INT UNSIGNED NOT NULL DEFAULT 0,
   `price` INT UNSIGNED NOT NULL DEFAULT 0,
   `rent` INT UNSIGNED NOT NULL DEFAULT 0,
   `doors` INT UNSIGNED NOT NULL DEFAULT 0,
   `beds` INT UNSIGNED NOT NULL DEFAULT 0,
   `tiles` INT UNSIGNED NOT NULL DEFAULT 0,
   `guild` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
   `clear` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
   UNIQUE (`id`, `world_id`)
) ENGINE = InnoDB;

ALTER TABLE `accounts` ADD `warnings` INT NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD `online` TINYINT(1) NOT NULL DEFAULT 0;