puWSJChq

1-- phpMyAdmin SQL Dump
2-- 
3-- Database: `b3`
4-- 
5
6-- --------------------------------------------------------
7
8-- 
9-- Table structure for table `aliases`
10-- 
11
12CREATE TABLE IF NOT EXISTS aliases (
13  id int(10) unsigned NOT NULL auto_increment,
14  num_used int(10) unsigned NOT NULL default '0',
15  alias varchar(32) NOT NULL default '',
16  client_id int(10) unsigned NOT NULL default '0',
17  time_add int(10) unsigned NOT NULL default '0',
18  time_edit int(10) unsigned NOT NULL default '0',
19  PRIMARY KEY  (id),
20  UNIQUE KEY alias (alias,client_id),
21  KEY client_id (client_id)
22) ENGINE=MyISAM DEFAULT CHARSET=utf8;
23
24-- --------------------------------------------------------
25
26-- 
27-- Table structure for table `ipaliases`
28-- 
29
30CREATE TABLE IF NOT EXISTS ipaliases (
31  id int(10) unsigned NOT NULL auto_increment,
32  num_used int(10) unsigned NOT NULL default '0',
33  ip varchar(16) NOT NULL,
34  client_id int(10) unsigned NOT NULL default '0',
35  time_add int(10) unsigned NOT NULL default '0',
36  time_edit int(10) unsigned NOT NULL default '0',
37  PRIMARY KEY  (id),
38  UNIQUE KEY ipalias (ip,client_id),
39  KEY client_id (client_id)
40) ENGINE=MyISAM DEFAULT CHARSET=utf8;
41
42-- --------------------------------------------------------
43
44-- 
45-- Table structure for table `clients`
46-- 
47
48CREATE TABLE IF NOT EXISTS clients (
49  id int(11) unsigned NOT NULL auto_increment,
50  ip varchar(16) NOT NULL default '',
51  connections int(11) unsigned NOT NULL default '0',
52  guid varchar(36) NOT NULL default '',
53  pbid varchar(32) NOT NULL default '',
54  name varchar(32) NOT NULL default '',
55  auto_login tinyint(1) unsigned NOT NULL default '0',
56  mask_level tinyint(1) unsigned NOT NULL default '0',
57  group_bits mediumint(8) unsigned NOT NULL default '0',
58  greeting varchar(128) NOT NULL default '',
59  time_add int(11) unsigned NOT NULL default '0',
60  time_edit int(11) unsigned NOT NULL default '0',
61  password varchar(32) default NULL,
62  login varchar(16) default NULL,
63  PRIMARY KEY  (id),
64  UNIQUE KEY guid (guid),
65  KEY group_bits (group_bits),
66  KEY name (name)
67) ENGINE=MyISAM DEFAULT CHARSET=utf8;
68
69-- --------------------------------------------------------
70
71-- 
72-- Table structure for table `groups`
73-- 
74
75CREATE TABLE IF NOT EXISTS groups (
76  id int(10) unsigned NOT NULL,
77  name varchar(32) NOT NULL default '',
78  keyword varchar(32) NOT NULL default '',
79  level int(10) unsigned NOT NULL default '0',
80  time_edit int(10) unsigned NOT NULL default '0',
81  time_add int(10) unsigned NOT NULL default '0',
82  PRIMARY KEY  (id),
83  UNIQUE KEY keyword (keyword),
84  KEY level (level)
85) ENGINE=MyISAM DEFAULT CHARSET=utf8;
86
87-- 
88-- Dumping data for table `groups`
89-- 
90
91INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (128, 0, 'Super Admin', 'superadmin', UNIX_TIMESTAMP(), 100);
92INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (64, 0, 'Senior Admin', 'senioradmin', UNIX_TIMESTAMP(), 80);
93INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (32, 0, 'Full Admin', 'fulladmin', UNIX_TIMESTAMP(), 60);
94INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (16, 0, 'Admin', 'admin', UNIX_TIMESTAMP(), 40);
95INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (8, 0, 'Moderator', 'mod', UNIX_TIMESTAMP(), 20);
96INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (2, 0, 'Regular', 'reg', UNIX_TIMESTAMP(), 2);
97INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (1, 0, 'User', 'user', UNIX_TIMESTAMP(), 1);
98INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (0, 0, 'Guest', 'guest', UNIX_TIMESTAMP(), 0);
99
100-- --------------------------------------------------------
101
102-- 
103-- Table structure for table `penalties`
104-- 
105
106CREATE TABLE IF NOT EXISTS penalties (
107  id int(10) unsigned NOT NULL auto_increment,
108  type enum('Ban','TempBan','Kick','Warning','Notice') NOT NULL default 'Ban',
109  client_id int(10) unsigned NOT NULL default '0',
110  admin_id int(10) unsigned NOT NULL default '0',
111  duration int(10) unsigned NOT NULL default '0',
112  inactive tinyint(1) unsigned NOT NULL default '0',
113  keyword varchar(16) NOT NULL default '',
114  reason varchar(255) NOT NULL default '',
115  data varchar(255) NOT NULL default '',
116  time_add int(11) unsigned NOT NULL default '0',
117  time_edit int(11) unsigned NOT NULL default '0',
118  time_expire int(11) NOT NULL default '0',
119  PRIMARY KEY  (id),
120  KEY keyword (keyword),
121  KEY type (type),
122  KEY time_expire (time_expire),
123  KEY time_add (time_add),
124  KEY admin_id (admin_id),
125  KEY inactive (inactive),
126  KEY client_id (client_id)
127) ENGINE=MyISAM DEFAULT CHARSET=utf8;
128
129-- --------------------------------------------------------
130
131--
132-- Table structure for table `data`
133--
134
135CREATE TABLE IF NOT EXISTS `data` (
136  `data_key` varchar(255) NOT NULL,
137  `data_value` varchar(255) NOT NULL,
138  PRIMARY KEY  (`data_key`)
139) ENGINE=MyISAM DEFAULT CHARSET=utf8;