daily pastebin goal
6%
SHARE
TWEET

Untitled

a guest Jan 18th, 2018 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE 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 ;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top