mysimulation/server/FSO.Server.Database/DatabaseScripts/changes/0020_email_confirm.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

10 lines
No EOL
351 B
SQL
Executable file

CREATE TABLE `fso_email_confirm` (
`type` ENUM('email','password') NOT NULL DEFAULT 'email',
`email` VARCHAR(50) NULL DEFAULT NULL,
`token` VARCHAR(50) NULL DEFAULT NULL,
`expires` INT(11) NULL DEFAULT NULL
)
COMMENT='Table to control necessary email confirmation for registration or password reset.'
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;