Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS lk_transaction (
- id int(11) NOT NULL AUTO_INCREMENT,
- name varchar(30) COLLATE utf8_unicode_ci NOT NULL,
- money int(11) NOT NULL,
- date int(15) NOT NULL,
- ik_inv_st varchar(20) COLLATE utf8_unicode_ci NOT NULL,
- PRIMARY KEY (id)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;
- ALTER TABLE dle_users
- ADD group INT NOT NULL DEFAULT '0',
- ADD duration INT(15) NOT NULL DEFAULT '0',
- ADD money INT NOT NULL DEFAULT '0',
- ADD ban_count INT NOT NULL DEFAULT '0'
- CREATE TABLE IF NOT EXISTS banlist (
- name varchar(32) NOT NULL,
- reason text NOT NULL,
- admin varchar(32) NOT NULL,
- time bigint(20) NOT NULL,
- temptime bigint(20) NOT NULL DEFAULT '0',
- type int(11) NOT NULL DEFAULT '0',
- id int(11) NOT NULL AUTO_INCREMENT,
- ip varchar(16) DEFAULT NULL,
- PRIMARY KEY (id) USING BTREE
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=0 ;
- CREATE TABLE IF NOT EXISTS permissions_entity (
- id int(11) NOT NULL AUTO_INCREMENT,
- name varchar(50) NOT NULL,
- type tinyint(1) NOT NULL,
- prefix varchar(255) NOT NULL,
- suffix varchar(255) NOT NULL,
- default tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (id),
- UNIQUE KEY name (name),
- KEY default (default)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
- CREATE TABLE IF NOT EXISTS permissions_inheritance (
- id int(11) NOT NULL AUTO_INCREMENT,
- child varchar(50) NOT NULL,
- parent varchar(50) NOT NULL,
- type tinyint(1) NOT NULL,
- world varchar(50) DEFAULT NULL,
- PRIMARY KEY (id),
- UNIQUE KEY child (child)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement