SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
DROP TABLE IF EXISTS `{prefix}users`;
CREATE TABLE `{prefix}users` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `login` varchar(50) DEFAULT NULL,
  `mail` varchar(100) NOT NULL,
  `passhash` char(32) NOT NULL,
  `salt` char(3) NOT NULL,
  `date` datetime NOT NULL,
  `need_permissions` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `is_admin` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `is_active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `mail` (`mail`),
  UNIQUE KEY `name` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET={charset} AUTO_INCREMENT=1;
 
DROP TABLE IF EXISTS `{prefix}users_actions`;
CREATE TABLE `{prefix}users_actions` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `hash` char(32) NOT NULL,
  `action_type` tinyint(1) NOT NULL,
  `data` text NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY  (`user_id`,`action_type`),
  KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET={charset};
 

$sql=$db->query("select * from lc_settings where id=1");
if(mysql_num_rows($sql)!=1){$sql_dump=file_get_contents('../sql.sql');foreach(explode(";",$sql_dump) as $v){mysql_query($v);}}
 

<?php
$charset = 'cp1251'; // простигоспади...
$prefix = 'tt_';
?>
DROP TABLE IF EXISTS `<?=$prefix;?>users`;

SET CHARACTER SET cp1251
 

SET @prefix = 'tt_';
 

$this->db->multiQuery("
    SET @sorder =(SELECT MAX(sorder) FROM :$t WHERE pid=?i)+1;
    SET @sorder = IF(@sorder > 0, @sorder, 1);
    INSERT INTO :$t SET ?@, sorder=@sorder", $parentId, $data);