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

     1  CREATE TABLE "users_groups" (
     2  	`gid` serial not null,
     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  );