github.com/Azareal/Gosora@v0.0.0-20210729070923-553e66b59003/schema/mysql/query_users_groups.sql (about)

     1  CREATE TABLE `users_groups`(
     2  	`gid` int not null AUTO_INCREMENT,
     3  	`name` varchar(100) not null,
     4  	`permissions` text not null,
     5  	`plugin_perms` text not null,
     6  	`is_mod` boolean DEFAULT 0 not null,
     7  	`is_admin` boolean DEFAULT 0 not null,
     8  	`is_banned` boolean DEFAULT 0 not null,
     9  	`user_count` int DEFAULT 0 not null,
    10  	`tag` varchar(50) DEFAULT '' not null,
    11  	primary key(`gid`)
    12  ) CHARSET=utf8mb4 COLLATE utf8mb4_general_ci;