Closed JustZerooo closed 11 months ago
whats wrong with this ?
``CREATE TABLE IF NOT EXISTS
loadout(
idint(11) NOT NULL AUTO_INCREMENT,
identifierVARCHAR(50) NOT NULL COLLATE 'utf8mb4_bin',
charidentifierint(11) DEFAULT NULL,
namevarchar(50) DEFAULT NULL,
ammovarchar(255) NOT NULL DEFAULT '{}',
componentsvarchar(255) NOT NULL DEFAULT '{}',
dirtleveldouble DEFAULT 0,
mudleveldouble DEFAULT 0,
conditionleveldouble DEFAULT 0,
rustleveldouble DEFAULT 0,
usedtinyint(4) DEFAULT 0,
used2tinyint(4) DEFAULT 0,
droppedint(11) NOT NULL DEFAULT 0,
compslongtext NOT NULL DEFAULT '{}',
labelvarchar(50) DEFAULT NULL,
curr_invvarchar(100) NOT NULL DEFAULT 'default',
serial_numberVARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
custom_labelVARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
custom_descVARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', PRIMARY KEY (
id), KEY
id(
id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4
serial number column is there
note that this is for new servers that dont have `loadout` table as the sql says create if not exists. so if it does exist it wont add the changes.
Basic MySQL.sql Fix
Fixes :