Просмотр файла ICQ_distribution/SQL.sql

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `uin` (
  `id` int(11) NOT NULL auto_increment,
  `icq` varchar(10) NOT NULL,
  `pas` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `uin_book` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(250) NOT NULL,
  `text` text NOT NULL,
  `data` varchar(50) NOT NULL,
  `time` varchar(50) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `ua` varchar(50) NOT NULL,
  `admin` varchar(2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `uin_konf` (
  `id` int(1) NOT NULL,
  `log` varchar(50) NOT NULL,
  `sk` varchar(50) NOT NULL,
  `site` varchar(50) NOT NULL,
  `mail` varchar(50) NOT NULL,
  `title` varchar(100) NOT NULL,
  `baza` varchar(50) NOT NULL,
  `baza2` varchar(50) NOT NULL,
  `baza3` varchar(50) NOT NULL,
  `gl` varchar(50) NOT NULL,
  `book` varchar(50) NOT NULL,
  `off` varchar(2) NOT NULL,
  `maxlog` varchar(50) NOT NULL,
  `minlog` varchar(50) NOT NULL,
  `maxpost` varchar(50) NOT NULL,
  `minpost` varchar(50) NOT NULL,
  `flud` varchar(50) NOT NULL,
  `count` varchar(50) NOT NULL,
  `boff` varchar(2) NOT NULL,
  `poff` varchar(2) NOT NULL,
  `plink` varchar(100) NOT NULL,
  `ptext` varchar(500) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO `uin_konf` (`id`, `log`, `sk`, `site`, `mail`, `title`, `baza`, `baza2`, `baza3`, `gl`, `book`, `off`, `maxlog`, `minlog`, `maxpost`, `minpost`, `flud`, `count`, `boff`, `poff`, `plink`, `ptext`) VALUES
(1, 'lugaro', 'wphp.ru', 'wphp.ru', '[email protected]', 'Раздача ICQ от wPHP.ru', '10', '10', '10', '10', '10', '0', '100', '1', '500', '1', '40', '0', '0', '1', 'http://wphp.ru', 'Пароль и номер высланны вам на email, приносим свою благодарность за использование нашего сервиса, заходите к нам на сайт wPHP.ru по чаще');
CREATE TABLE IF NOT EXISTS `uin_mail` (
  `id` int(11) NOT NULL auto_increment,
  `icq` varchar(10) NOT NULL,
  `pas` varchar(50) NOT NULL,
  `mail` varchar(50) NOT NULL,
  `kod` varchar(50) NOT NULL,
  `date` varchar(250) NOT NULL,
  `dat` varchar(250) NOT NULL,
  `id_uin` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `uin_maildb` (
  `id` int(11) NOT NULL auto_increment,
  `mail` varchar(50) NOT NULL,
  `date` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;