mysimulation/server/FSO.Server.Database/DatabaseScripts/changes/0012_fso_bans.sql
Tony Bark 22191ce648 Removed NioTSO client and server
- NioTSO client isn't needed because we're using RayLib
- Added FreeSO's API server to handle most backend operations
2024-05-01 02:55:43 -04:00

11 lines
No EOL
355 B
SQL
Executable file

CREATE TABLE IF NOT EXISTS `fso_ip_ban` (
`user_id` INT UNSIGNED NOT NULL,
`ip_address` VARCHAR(100) NULL,
`banreason` VARCHAR(500) NULL,
`end_date` INT(10) NOT NULL DEFAULT 0,
PRIMARY KEY (`user_id`),
CONSTRAINT `fso_ban_user`
FOREIGN KEY (`user_id`)
REFERENCES `fso_users` (`user_id`)
ON DELETE CASCADE
ON UPDATE CASCADE);