mirror of
https://github.com/riperiperi/FreeSO
synced 2026-08-13 20:26:13 -04:00
11 lines
355 B
MySQL
11 lines
355 B
MySQL
|
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);
|