Beiträge von GaNja

CREATE TABLE IF NOT EXISTS `locker` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `uid` varchar(17) NOT NULL,
    `active` tinyint(1) NOT NULL DEFAULT '1',
    `side` char(50) NOT NULL,
    `level` int(11) NOT NULL DEFAULT '1',
    `open` tinyint(1) NOT NULL DEFAULT '0',
    `locker_dbprimary` text NOT NULL,
    `locker_dbhandgun` text NOT NULL,
    `locker_dbattach` text NOT NULL,
    `locker_clothing` text NOT NULL,
    `locker_vests` text NOT NULL,
    `locker_backpack` text NOT NULL,
    `locker_other` text NOT NULL,
    `locker_items` text NOT NULL,
    `locker_virtitems` text NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;