· 5 years ago · Feb 07, 2020, 04:44 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
3 `chat` INT UNSIGNED NOT NULL,
4 `user` INT UNSIGNED NOT NULL,
5 `nick` VARCHAR(30),
6 `options` TINYINT UNSIGNED NOT NULL,
7 `staff` TINYINT UNSIGNED NOT NULL,
8 `registered` INT UNSIGNED NOT NULL,
9 `spam_time` INT UNSIGNED NOT NULL,
10 `spam_count` INT UNSIGNED NOT NULL,
11 `recently` INT UNSIGNED NOT NULL
12);
13
14INSERT INTO `users`
15(`chat`, `user`, `options`)
16VALUES
17(123, 3, Globals|0, NOW());