Дополнен 4 года назад
-- Export de données de la table gta5.server_biz : ~9 rows (environ)
/*!40000 ALTER TABLE `server_biz` DISABLE KEYS */;
INSERT INTO `server_biz` (`id`, `type`, `name`, `posx`, `posy`, `posz`, `dimension`) VALUES
(1, 2, '~r~Ammunation', 252.651, -48.0221, 69.9411, 0),
(2, 1, '~b~24/7', 374.52, 327.459, 103.566, 0),
(3, 1, '~b~24/7', 1163.1, -323.41, 69.2051, 0),
(4, 1, '~b~24/7', -1487.59, -379.596, 40.1634, 0),
(5, 1, '~b~24/7', -1223.64, -906.625, 12.3264, 0),
(6, 1, '~b~24/7', -708.631, -914.254, 19.2156, 0),
(7, 1, '~b~24/7', 26.3306, -1346.84, 29.497, 0),
(8, 1, '~b~24/7', -49.0595, -1757.06, 29.421, 0),
(9, 2, '~r~Ammunation', 20.2415, -1107.18, 29.797, 0),
(10, 2, '~r~Ammunation', 844.076, -1033, 28.1949, 0),
(11, 2, '~r~Ammunation', -1306.08, -392.258, 36.6958, 0);
/*!40000 ALTER TABLE `server_biz` ENABLE KEYS */;
-- Export de la structure de la table gta5. server_factions
CREATE TABLE IF NOT EXISTS `server_factions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(24) NOT NULL,
`restricted` int(11) NOT NULL DEFAULT '0',
`leader` varchar(128) NOT NULL DEFAULT 'NoOne',
`desc` varchar(128) NOT NULL DEFAULT 'A new gang ins in town baby',
`cop` int(11) NOT NULL DEFAULT '0',
`default_car` varchar(50) NOT NULL DEFAULT 'exemplar',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-- Export de données de la table gta5.server_factions : ~4 rows (environ)
/*!40000 ALTER TABLE `server_factions` DISABLE KEYS */;
INSERT INTO `server_factions` (`id`, `name`, `restricted`, `leader`, `desc`, `cop`, `default_car`) VALUES
(1, 'Civil', 0, 'NoOne', 'Be a good or a bag boy', 0, 'exemplar'),
(2, 'LSPD', 1, 'NoOne', 'be a cop', 1, 'police2'),
(3, 'FIB', 1, 'NoOne', 'Better than cops, worse tha
Дополнен 4 года назад
При загрузке ошибка : Ошибка
SQL запрос:
INSERT INTO `server_admins` (`id`, `default`, `name`, `upgraded`, `see`, `blame`, `edit`) VALUES
(1, 0, 'Alexandre_Lasque', '2018-06-15 17:32:04', 0, 0, 9)
Ответ MySQL:Документация
#1062 - Дублирующаяся запись '1' по ключу 'PRIMARY'
-- Hôte : 127.0.0.1
-- Version du serveur: 10.1.30-MariaDB - mariadb.org binary distribution
-- SE du serveur: Win32
-- HeidiSQL Version: 9.5.0.5196
-- --------------------------------------------------------
/*!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' */;
-- Export de la structure de la base pour gta5
CREATE DATABASE IF NOT EXISTS `gta5` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `gta5`;
-- Export de la structure de la table gta5. logs
CREATE TABLE IF NOT EXISTS `logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` varchar(1024) NOT NULL,
`type` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=610 DEFAULT CHARSET=latin1;
/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
-- Export de la structure de la table gta5. server_access
CREATE TABLE IF NOT EXISTS `server_access` (
`player_id` int(11) NOT NULL,
`faction_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Export de données de la table gta5.server_access : ~0 rows (environ)
/*!40000 ALTER TABLE `server_access` DISABLE KEYS */;
/*!40000 ALTER TABLE `server_access` ENABLE KEYS */;
-- Export de la structure de la table gta5. server_admins
CREATE TABLE IF NOT EXISTS `server_admins` (
`id` int(11) NOT NULL,
`default` int(11) NOT NULL,
`name` varchar(24) NOT NULL,
`upgraded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`see` int(3) NOT NULL,
`blame` int(3) NOT NULL,
`edit` int(3) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- Export de données de la table gta5.server_admins : ~1 rows (environ)
/*!40000 ALTER TABLE `server_admins` DISABLE KEYS */;
INSERT INTO `server_admins` (`id`, `default`, `name`, `upgraded`, `see`, `blame`, `edit`) VALUES
(1, 0, 'Alexandre_Lasque', '2018-06-15 17:32:04', 0, 0, 9);
/*!40000 ALTER TABLE `server_admins` ENABLE KEYS */;
-- Export de la structure de la table gta5. server_biz
CREATE TABLE IF NOT EXISTS `server_biz` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`posx` float NOT NULL,
`posy` float NOT NULL,
`posz` float NOT NULL,
`dimension` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;