user_info table
Closed this issue · 1 comments
Nighoo commented
The sql table creation statement for the user_info
table is missing in the given .sql file.
Seems like the table looks rudimentary like:
CREATE TABLE `user_info` (
`userid` smallint(6) NOT NULL AUTO_INCREMENT,
`username` varchar(25) NOT NULL,
`lastlogin` timestamp NULL DEFAULT NULL,
`userhash` varchar(50) DEFAULT NULL,
`email` varchar(320) NOT NULL DEFAULT 'none',
`TYPE` enum('ADMIN','USER') NOT NULL DEFAULT 'USER',
`timeout` smallint(5) unsigned NOT NULL DEFAULT '5000',
PRIMARY KEY (`userid`,`username`)
)
fygrave commented
squert uses sguil database schema so in my opinion you don't need to carry this around (to prevent future compatibility problems if sguil schema would change at one point).