int13h/squert

user_info table

Closed this issue · 1 comments

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`)
)

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).