CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(32) NOT NULL,
  `passwd` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `name` tinytext NOT NULL,
  `post` tinytext NOT NULL,
  `privil` mediumtext NOT NULL,
  `usr_grps` varchar(1024) NOT NULL,
  `tunes` mediumtext NOT NULL,
  `ext` varchar(4) NOT NULL,
  `balance` float(8,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin` (`login`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

CREATE TABLE `auth_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` int(10) unsigned NOT NULL DEFAULT '0',
  `start` int(10) unsigned NOT NULL DEFAULT '0',
  `end` int(10) unsigned NOT NULL DEFAULT '0',
  `properties` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `start` (`start`),
  KEY `last` (`end`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `auth_now` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) NOT NULL,
  `start` int(10) unsigned NOT NULL DEFAULT '0',
  `last` int(10) unsigned NOT NULL DEFAULT '0',
  `properties` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip` (`ip`),
  KEY `start` (`start`),
  KEY `last` (`last`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


CREATE TABLE `cards` (
  `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cod` text NOT NULL,
  `money` float(6,2) NOT NULL DEFAULT '0.00',
  `tm_create` int(11) unsigned NOT NULL DEFAULT '0',
  `tm_end` int(11) unsigned NOT NULL DEFAULT '0',
  `tm_activate` int(11) unsigned NOT NULL DEFAULT '0',
  `adm_create` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `alive` enum('good','bad','stock','activated') NOT NULL DEFAULT 'good',
  `uid_activate` int(10) unsigned NOT NULL DEFAULT '0',
  `adm_owner` mediumint(9) NOT NULL DEFAULT '0',
  `adm_move` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `r` (`adm_owner`),
  KEY `uid_activate` (`uid_activate`),
  KEY `adm_move` (`adm_move`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `changes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tbl` char(16) NOT NULL,
  `act` enum('create','edit','delete') NOT NULL DEFAULT 'create',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `fid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `adm` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `old_data` longtext NOT NULL,
  `new_data` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl` (`tbl`,`act`,`fid`),
  KEY `time` (`time`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` int(11) NOT NULL DEFAULT '0',
  `data` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `data0` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE `datasetup` (
  `id` smallint(8) unsigned NOT NULL AUTO_INCREMENT,
  `template` tinyint(3) unsigned NOT NULL,
  `type` tinyint(3) unsigned NOT NULL,
  `title` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `flags` varchar(32) NOT NULL,
  `param` text NOT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `dictionary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` text NOT NULL,
  `k` text NOT NULL,
  `v` text NOT NULL,
  UNIQUE KEY `type` (`type`(16),`k`(16)),
  KEY `street` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `ip_pool` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` int(10) unsigned NOT NULL DEFAULT '0',
  `type` enum('static','dynamic','reserved') NOT NULL,
  `realip` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `release` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` bigint(20) unsigned NOT NULL,
  `tags` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip` (`ip`),
  KEY `type` (`type`),
  KEY `release` (`release`),
  KEY `uid` (`uid`),
  KEY `realip` (`realip`),
  KEY `tags` (`tags`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ip_mac` (
  `ip` bigint(20) NOT NULL default '0',
  `mac` char(12) NOT NULL,
  PRIMARY KEY  (`ip`),
  KEY `mac` (`mac`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `links` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `name` TINYTEXT NOT NULL ,
  `start_p_id` INT UNSIGNED NOT NULL ,
  `end_p_id` INT UNSIGNED NOT NULL ,
  `type` TINYINT UNSIGNED NOT NULL ,
  `fibers` TINYINT UNSIGNED NOT NULL ,
  `state` TINYINT UNSIGNED NOT NULL ,
  `joints` MEDIUMTEXT NOT NULL
) ENGINE = InnoDB;

CREATE TABLE `nets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `preset` smallint(6) NOT NULL,
  `priority` int(11) NOT NULL,
  `class` tinyint(4) NOT NULL,
  `net` text NOT NULL,
  `port` smallint(5) unsigned NOT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `pays` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mid` mediumint(9) NOT NULL DEFAULT '0',
  `cash` float(8,2) NOT NULL DEFAULT '0.00',
  `time` int(11) NOT NULL,
  `creator` enum('other','admin','user','kernel') NOT NULL DEFAULT 'other',
  `creator_id` mediumint(9) NOT NULL,
  `creator_ip` int(10) unsigned NOT NULL,
  `reason` text NOT NULL,
  `comment` mediumtext NOT NULL,
  `category` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mid` (`mid`),
  KEY `time` (`time`),
  KEY `category` (`category`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `places` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gpsX` float NOT NULL,
  `gpsY` float NOT NULL,
  `descr` text NOT NULL,
  `location` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `places_events` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `time` int(10) unsigned NOT NULL default '0',
  `when_remove` int(10) unsigned NOT NULL default '0',
  `place` int(10) unsigned NOT NULL,
  `descr` mediumtext NOT NULL,
  `metadata` varchar(255) NOT NULL default '',
  `errorlevel` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `place` (`place`),
  KEY `time` (`time`),
  KEY `metadata` (`metadata`),
  KEY `errorlevel` (`errorlevel`),
  KEY `when_remove` (`when_remove`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `ports` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `uid` bigint(20) unsigned NOT NULL,
  `port` int(10) unsigned NOT NULL,
  `descr` varchar(127) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE `services` (
  `service_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(64) NOT NULL,
  `category` varchar(64) NOT NULL,
  `title` varchar(64) NOT NULL,
  `description` varchar(512) NOT NULL,
  `grp_list` longtext NOT NULL,
  `price` float NOT NULL DEFAULT '0',
  `auto_renew` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `no_renew` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `param` longtext NOT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `traflost` (
  `time` int(11) unsigned NOT NULL DEFAULT '0',
  `traf` int(10) unsigned NOT NULL DEFAULT '0',
  `collector` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `ip1` int(10) unsigned NOT NULL DEFAULT '0',
  `ip2` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `user_grp` (
  `grp_id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `grp_name` text NOT NULL,
  `grp_property` text NOT NULL,
  `grp_maxflow` int(11) NOT NULL,
  `grp_maxregflow` int(11) NOT NULL,
  `grp_nets` mediumtext NOT NULL,
  `grp_block_limit` float NOT NULL,
  PRIMARY KEY (`grp_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8 NOT NULL,
  `passwd` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `grp` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `contract` tinytext CHARACTER SET utf8 NOT NULL,
  `contract_date` int(10) unsigned NOT NULL,
  `state` enum('off','on') CHARACTER SET utf8 NOT NULL DEFAULT 'on',
  `balance` float(10,2) NOT NULL DEFAULT '0.00',
  `limit_balance` float(6,2) NOT NULL DEFAULT '0.00',
  `block_if_limit` tinyint(4) NOT NULL DEFAULT '0',
  `modify_time` int(11) NOT NULL DEFAULT '0',
  `fio` tinytext CHARACTER SET utf8 NOT NULL,
  `discount` tinyint(4) NOT NULL DEFAULT '0',
  `cstate` int(11) NOT NULL DEFAULT '0',
  `cstate_time` int(10) unsigned NOT NULL,
  `comment` text CHARACTER SET utf8 NOT NULL,
  `lstate` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `state` (`state`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `users_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) unsigned NOT NULL,
  `pay_id` bigint(20) unsigned NOT NULL,
  `service_id` int(10) unsigned NOT NULL,
  `tm_start` int(10) unsigned NOT NULL,
  `tm_end` int(10) unsigned NOT NULL,
  `next_service_id` int(10) unsigned NOT NULL DEFAULT '0',
  `tags` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tm_end` (`tm_end`),
  KEY `uid` (`uid`),
  KEY `tags` (`tags`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `users_trf` (
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `submoney` float NOT NULL DEFAULT '0',
  `in1` bigint(20) NOT NULL DEFAULT '0',
  `out1` bigint(20) NOT NULL DEFAULT '0',
  `in2` bigint(20) NOT NULL DEFAULT '0',
  `out2` bigint(20) NOT NULL DEFAULT '0',
  `in3` bigint(20) NOT NULL DEFAULT '0',
  `out3` bigint(20) NOT NULL DEFAULT '0',
  `in4` bigint(20) NOT NULL DEFAULT '0',
  `out4` bigint(20) NOT NULL DEFAULT '0',
  `in5` bigint(20) NOT NULL DEFAULT '0',
  `out5` bigint(20) NOT NULL DEFAULT '0',
  `in6` bigint(20) NOT NULL DEFAULT '0',
  `out6` bigint(20) NOT NULL DEFAULT '0',
  `in7` bigint(20) NOT NULL DEFAULT '0',
  `out7` bigint(20) NOT NULL DEFAULT '0',
  `in8` bigint(20) NOT NULL DEFAULT '0',
  `out8` bigint(20) NOT NULL DEFAULT '0',
  `traf1` bigint(20) NOT NULL DEFAULT '0',
  `traf2` bigint(20) NOT NULL DEFAULT '0',
  `traf3` bigint(20) NOT NULL DEFAULT '0',
  `traf4` bigint(20) NOT NULL DEFAULT '0',
  `test` tinyint(4) NOT NULL DEFAULT '0',
  `actual` tinyint(4) NOT NULL DEFAULT '0',
  UNIQUE KEY `uid` (`uid`),
  KEY `changed` (`actual`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `users_limit` (
  `uid` int(10) unsigned NOT NULL,
  `traf1` bigint(20) unsigned NOT NULL default '0',
  `traf2` bigint(20) unsigned NOT NULL default '0',
  `traf3` bigint(20) unsigned NOT NULL default '0',
  `traf4` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `webses_data` (
  `role` varchar(32) NOT NULL,
  `aid` mediumint(8) unsigned NOT NULL,
  `unikey` varchar(200) NOT NULL,
  `module` varchar(32) NOT NULL,
  `data` longtext NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `expire` int(10) unsigned NOT NULL,
  UNIQUE KEY `unikey` (`unikey`),
  KEY `aid` (`aid`),
  KEY `expire` (`expire`),
  KEY `role` (`role`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `websessions` (
  `ses` varchar(200) NOT NULL,
  `uid` int(11) NOT NULL,
  `role` varchar(32) NOT NULL,
  `trust` tinyint(4) NOT NULL DEFAULT '1',
  `expire` int(10) unsigned NOT NULL,
  UNIQUE KEY `ses` (`ses`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;