Umt5FTAY

1CREATE TABLE IF NOT EXISTS lk_transaction (
2          id int(11) NOT NULL AUTO_INCREMENT,
3          name varchar(30) COLLATE utf8_unicode_ci NOT NULL,
4          money int(11) NOT NULL,
5          date int(15) NOT NULL,
6          ik_inv_st varchar(20) COLLATE utf8_unicode_ci NOT NULL,
7          PRIMARY KEY (id)
8        ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;
9
10        ALTER TABLE  dle_users 
11            ADD  group INT NOT NULL DEFAULT  '0',
12            ADD  duration INT(15) NOT NULL DEFAULT  '0',
13            ADD  money INT NOT NULL DEFAULT  '0',
14            ADD  ban_count INT NOT NULL DEFAULT  '0'
15
16        CREATE TABLE IF NOT EXISTS banlist (
17          name varchar(32) NOT NULL,
18          reason text NOT NULL,
19          admin varchar(32) NOT NULL,
20          time bigint(20) NOT NULL,
21          temptime bigint(20) NOT NULL DEFAULT '0',
22          type int(11) NOT NULL DEFAULT '0',
23          id int(11) NOT NULL AUTO_INCREMENT,
24          ip varchar(16) DEFAULT NULL,
25          PRIMARY KEY (id) USING BTREE
26        ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=0 ;
27
28        CREATE TABLE IF NOT EXISTS permissions_entity (
29          id int(11) NOT NULL AUTO_INCREMENT,
30          name varchar(50) NOT NULL,
31          type tinyint(1) NOT NULL,
32          prefix varchar(255) NOT NULL,
33          suffix varchar(255) NOT NULL,
34          default tinyint(1) NOT NULL DEFAULT '0',
35          PRIMARY KEY (id),
36          UNIQUE KEY name (name),
37          KEY default (default)
38        ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
39
40        CREATE TABLE IF NOT EXISTS permissions_inheritance (
41          id int(11) NOT NULL AUTO_INCREMENT,
42          child varchar(50) NOT NULL,
43          parent varchar(50) NOT NULL,
44          type tinyint(1) NOT NULL,
45          world varchar(50) DEFAULT NULL,
46          PRIMARY KEY (id),
47          UNIQUE KEY child (child)
48        ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;