-- phpMyAdmin SQL Dump
-- version 5.0.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Creato il: Gen 05, 2021 alle 17:19
-- Versione del server: 10.4.14-MariaDB
-- Versione PHP: 7.4.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `aaaa`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `weapons`
--

CREATE TABLE `weapons` (
  `Name` varchar(50) NOT NULL,
  `Label` varchar(50) NOT NULL,
  `Description` mediumtext NOT NULL DEFAULT 'No description.',
  `Weight` float NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dump dei dati per la tabella `weapons`
--

INSERT INTO `weapons` (`Name`, `Label`, `Description`, `Weight`) VALUES
('weapon_assaultsmg', 'assault smg', 'No description.', 1),
('weapon_autoshotgun', 'autoshotgun', 'No description.', 1),
('weapon_bat', 'Baseball bat', 'No description.', 1),
('weapon_battleaxe', 'Battle axe', 'No description.', 1),
('weapon_bottle', 'bottle', 'No description.', 1),
('weapon_bullpuprifle', 'Bullpup rifle', 'No description.', 1),
('weapon_bullpuprifle_mk2', 'bullpuprifle mk2', 'No description.', 1),
('weapon_bullpupshotgun', 'bullpup shotgun', 'No description.', 1),
('weapon_bzgas', 'bzgas', 'No description.', 1),
('weapon_carbinerifle', 'carbine rifle', 'No description.', 1),
('weapon_carbinerifle_mk2', 'carbinerifle mk2', 'No description.', 1),
('weapon_ceramicpistol', 'ceramic pistol', 'No description.', 1),
('weapon_combatmg', 'combat mg', 'No description.', 1),
('weapon_combatmg_mk2', 'combat mg mk2', 'No description.', 1),
('weapon_combatpdw', 'combat pdw', 'No description.', 1),
('weapon_combatpistol', 'combat pistol', 'No description.', 1),
('weapon_compactlauncher', 'compact launcher', 'No description.', 1),
('weapon_compactrifle', 'compact rifle', 'No description.', 1),
('weapon_crowbar', 'crowbar', 'No description.', 1),
('weapon_dagger', 'dagger', 'No description.', 1),
('weapon_dbshotgun', 'double shotgun', 'No description.', 1),
('weapon_doubleaction', 'revolver doubleaction', 'No description.', 1),
('weapon_fireextinguisher', 'fire extinguisher', 'No description.', 1),
('weapon_firework', 'firework', 'No description.', 1),
('weapon_flare', 'flare', 'No description.', 1),
('weapon_flaregun', 'flaregun', 'No description.', 1),
('weapon_flashlight', 'flashlight', 'No description.', 1),
('weapon_golfclub', 'golfclub', 'No description.', 1),
('weapon_grenade', 'grenade', 'No description.', 1),
('weapon_grenadelauncher', 'grenade launcher', 'No description.', 1),
('weapon_grenadelauncher_smoke', 'grenadelauncher smoke', 'No description.', 1),
('weapon_gusenberg', 'gusenberg', 'No description.', 1),
('weapon_hammer', 'hammer', 'No description.', 1),
('weapon_hatchet', 'hatchet', 'No description.', 1),
('weapon_hazardcan', 'hazard can', 'No description.', 1),
('weapon_heavypistol', 'heavy pistol', 'No description.', 1),
('weapon_heavyshotgun', 'heavyshotgun', 'No description.', 1),
('weapon_heavysniper', 'heavysniper', 'No description.', 1),
('weapon_heavysniper_mk2', 'heavy sniper mk2', 'No description.', 1),
('weapon_hominglauncher', 'homing launcher', 'No description.', 1),
('weapon_knife', 'knife', 'No description.', 1),
('weapon_knuckle', 'knuckle', 'No description.', 1),
('weapon_machete', 'machete', 'No description.', 1),
('weapon_machinepistol', 'machine pistol', 'No description.', 1),
('weapon_marksmanpistol', 'marksman pistol', 'No description.', 1),
('weapon_marksmanrifle', 'marksman rifle', 'No description.', 1),
('weapon_marksmanrifle_mk2', 'marksman rifle mk2', 'No description.', 1),
('weapon_mg', 'mg', 'No description.', 1),
('weapon_microsmg', 'microsmg', 'No description.', 1),
('weapon_minigun', 'minigun', 'No description.', 1),
('weapon_minismg', 'minismg', 'No description.', 1),
('weapon_molotov', 'molotov', 'No description.', 1),
('weapon_musket', 'musket', 'No description.', 1),
('weapon_navyrevolver', 'navy revolver', 'No description.', 1),
('weapon_nightstick', 'nightstick', 'No description.', 1),
('weapon_petrolcan', 'petrol can', 'No description.', 1),
('weapon_pipebomb', 'pipe bomb', 'No description.', 1),
('weapon_pistol', 'pistol 9mm', 'No description.', 1),
('weapon_pistol50', 'pistol 50', 'No description.', 1),
('weapon_pistol_mk2', 'pistol 9mm mk2', 'No description.', 1),
('weapon_poolcue', 'poolcue', 'No description.', 1),
('weapon_proxmine', 'proxmine', 'No description.', 1),
('weapon_pumpshotgun', 'pump shotgun', 'No description.', 1),
('weapon_pumpshotgun_mk2', 'pump shotgun mk2', 'No description.', 1),
('weapon_railgun', 'railgun', 'No description.', 1),
('weapon_raycarbine', 'ray carbine', 'No description.', 1),
('weapon_rayminigun', 'ray minigun', 'No description.', 1),
('weapon_raypistol', 'ray pistol', 'No description.', 1),
('weapon_revolver', 'revolver', 'No description.', 1),
('weapon_revolver_mk2', 'revolver mk2', 'No description.', 1),
('weapon_rpg', 'rpg', 'No description.', 1),
('weapon_sawnoffshotgun', 'sawnoffshotgun', 'No description.', 1),
('weapon_smg', 'smg', 'No description.', 1),
('weapon_smg_mk2', 'smg mk2', 'No description.', 1),
('weapon_smokegrenade', 'smoke grenade', 'No description.', 1),
('weapon_sniperrifle', 'sniper rifle', 'No description.', 1),
('weapon_snowball', 'snowball', 'No description.', 1),
('weapon_snspistol', 'sns pistol', 'No description.', 1),
('weapon_snspistol_mk2', 'sns pistol mk2', 'No description.', 1),
('weapon_specialcarbine', 'special carbine', 'No description.', 1),
('weapon_specialcarbine_mk2', 'special carbine mk2', 'No description.', 1),
('weapon_stickybomb', 'sticky bomb', 'No description.', 1),
('weapon_stone_hatchet', 'stone hatchet', 'No description.', 1),
('weapon_stungun', 'stun gun', 'No description.', 1),
('weapon_switchblade', 'switchblade', 'No description.', 1),
('weapon_vintagepistol', 'vintage pistol', 'No description.', 1),
('weapon_wrench', 'wrench', 'No description.', 1);

--
-- Indici per le tabelle scaricate
--

--
-- Indici per le tabelle `weapons`
--
ALTER TABLE `weapons`
  ADD PRIMARY KEY (`Name`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
