· 7 years ago · Jan 28, 2019, 06:20 PM
1DROP TABLE IF EXISTS `logs`;
2CREATE TABLE `logs` (
3 `log_id` int(11) NOT NULL AUTO_INCREMENT,
4 `log_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
5 `playerid` varchar(50) DEFAULT NULL,
6 `action` enum('login','logout','killed','killedby','vehicle_buy','vehicle_rental','item_buy','zitem_buy','license_buy','house_buy','vehicle_sale','house_sale','item_sale','zitem_sale','zitem_drop','einbruch','bank_heist','fuel_heist','jail_ausbruch','confiscate','repair','revive','revivedby','trade','tradedby','withdraw_money','deposit_money','transfer_money','transfered_money_by','respawn','unknown') DEFAULT NULL,
7 `destinationid` varchar(50) DEFAULT NULL,
8 `class` varchar(100) DEFAULT NULL,
9 `info` text,
10 PRIMARY KEY (`log_id`)
11) ENGINE=InnoDB AUTO_INCREMENT=880522 DEFAULT CHARSET=utf8;