-- MySQL dump 10.19 Distrib 10.3.32-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: tes285_host
-- ------------------------------------------------------
-- Server version 10.3.32-MariaDB-cll-lve
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `bill`
--
DROP TABLE IF EXISTS `bill`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bill` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` varchar(90) NOT NULL,
`time` int(11) NOT NULL,
`type` enum('0','1') NOT NULL,
`amount` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bill`
--
LOCK TABLES `bill` WRITE;
/*!40000 ALTER TABLE `bill` DISABLE KEYS */;
/*!40000 ALTER TABLE `bill` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chat`
--
DROP TABLE IF EXISTS `chat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` varchar(500) NOT NULL,
`user` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat`
--
LOCK TABLES `chat` WRITE;
/*!40000 ALTER TABLE `chat` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `hosting`
--
DROP TABLE IF EXISTS `hosting`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hosting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) NOT NULL,
`rom` int(11) NOT NULL,
`ftp` int(11) NOT NULL,
`domain` int(11) NOT NULL,
`db` int(11) NOT NULL,
`price` decimal(11,2) NOT NULL,
`price2` decimal(11,2) NOT NULL,
`mail` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `hosting`
--
LOCK TABLES `hosting` WRITE;
/*!40000 ALTER TABLE `hosting` DISABLE KEYS */;
INSERT INTO `hosting` VALUES (5,'HDD - 1GB',1000,10,10,10,1.00,30.00,10),(6,'HDD - 3GB',3000,30,30,30,3.00,90.00,30),(7,'HDD - 5GB',5000,50,50,50,4.00,120.00,50),(8,'TEST',50,1,1,1,0.00,0.00,1),(9,'test',100,5,5,1,0.00,0.00,5),(10,'Tarif',1000,10,10,10,1.93,0.00,10);
/*!40000 ALTER TABLE `hosting` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT NULL,
`name` varchar(80) NOT NULL,
`text` varchar(5000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news`
--
LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news_com`
--
DROP TABLE IF EXISTS `news_com`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_com` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT NULL,
`user` int(11) NOT NULL,
`news` int(11) NOT NULL,
`text` varchar(400) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news_com`
--
LOCK TABLES `news_com` WRITE;
/*!40000 ALTER TABLE `news_com` DISABLE KEYS */;
/*!40000 ALTER TABLE `news_com` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `order`
--
DROP TABLE IF EXISTS `order`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`host` int(11) NOT NULL,
`time` int(11) NOT NULL,
`login` varchar(80) NOT NULL,
`password` varchar(80) NOT NULL,
`notice` enum('0','1') NOT NULL DEFAULT '0',
`domain` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `order`
--
LOCK TABLES `order` WRITE;
/*!40000 ALTER TABLE `order` DISABLE KEYS */;
/*!40000 ALTER TABLE `order` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `payments`
--
DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`money` decimal(11,2) NOT NULL,
`method` set('webmoney','qiwi','yandex','payeer','card') NOT NULL,
`pay` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `payments`
--
LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
INSERT INTO `payments` VALUES (1,1,50.00,'qiwi','0'),(2,2,50.00,'qiwi','0'),(3,2,1.00,'qiwi','0'),(4,2,50.00,'','0'),(5,2,50.00,'','0'),(6,2,50.00,'','0'),(7,2,50.00,'qiwi','0'),(8,1,50.00,'qiwi','0'),(9,2,50.00,'qiwi','0'),(10,2,50.00,'qiwi','0'),(11,2,50.00,'qiwi','0'),(12,2,50.00,'qiwi','1'),(13,2,50.00,'qiwi','0'),(14,2,50.00,'payeer','0'),(15,1,50.00,'qiwi','0'),(16,3,50.00,'qiwi','0'),(17,3,50.00,'qiwi','0'),(18,6,50.00,'qiwi','0'),(19,12,50.00,'payeer','0'),(20,2,50.00,'qiwi','0'),(21,1,50.00,'qiwi','0'),(22,1,50.00,'qiwi','0'),(23,2,1.00,'yandex','0'),(24,2,2.00,'yandex','0'),(25,1,50.00,'qiwi','0'),(26,33,50.00,'qiwi','0'),(27,2,50.00,'','0'),(28,2,50.00,'','0'),(29,2,50.00,'','0');
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `promo`
--
DROP TABLE IF EXISTS `promo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `promo` (
`promo` varchar(40) NOT NULL,
`bonus` int(11) NOT NULL,
PRIMARY KEY (`promo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `promo`
--
LOCK TABLES `promo` WRITE;
/*!40000 ALTER TABLE `promo` DISABLE KEYS */;
INSERT INTO `promo` VALUES ('Test',50),('TEST1234',10),('vvv',50);
/*!40000 ALTER TABLE `promo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `servers`
--
DROP TABLE IF EXISTS `servers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `servers` (
`name` varchar(30) NOT NULL,
`proc` varchar(90) NOT NULL,
`ram` varchar(90) NOT NULL,
`disk` varchar(90) NOT NULL,
`panel` varchar(90) NOT NULL,
`dns` varchar(90) NOT NULL,
`phpinfo` varchar(90) NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `servers`
--
LOCK TABLES `servers` WRITE;
/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
INSERT INTO `servers` VALUES ('srv1','Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz','40 GB','2 x 320GB','ISP 5 LITE','ns1.ekeo.ru ns2.ekeo.ru','phpinfo');
/*!40000 ALTER TABLE `servers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `setting`
--
DROP TABLE IF EXISTS `setting`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `setting` (
`isp_login` varchar(50) NOT NULL,
`isp_password` varchar(50) NOT NULL,
`ip` varchar(50) NOT NULL,
`port` int(11) NOT NULL,
`email` varchar(80) NOT NULL,
`secret_key` varchar(90) NOT NULL,
`public_key` varchar(90) NOT NULL,
`shop` int(11) NOT NULL,
`email_password` varchar(70) NOT NULL,
`smtp` varchar(80) NOT NULL,
PRIMARY KEY (`isp_login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `setting`
--
LOCK TABLES `setting` WRITE;
/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
INSERT INTO `setting` VALUES ('root','PB3G305wu0Q1','62.109.6.83',1500,'mail@paysoo.su','LdPkJU9byQofZqi','oiUQ2RSOLF8nzPC',81,'ab05du09','mail.paysoo.su');
/*!40000 ALTER TABLE `setting` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `support`
--
DROP TABLE IF EXISTS `support`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `support` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`text` varchar(400) NOT NULL,
`time` int(11) NOT NULL,
`view` set('0','1') NOT NULL DEFAULT '0',
`adm` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `support`
--
LOCK TABLES `support` WRITE;
/*!40000 ALTER TABLE `support` DISABLE KEYS */;
INSERT INTO `support` VALUES (1,1,'wad',1597771867,'1',0),(2,1,'wadwa',1597771881,'1',1),(3,2,'Привет',1597913659,'1',0),(4,2,'Как дела?',1597913668,'1',0),(5,3,'Амир ты тут?',1598517301,'1',0),(6,3,'Привет',1598517310,'1',0),(7,3,'Привет',1598601017,'1',2),(8,3,'Да, слушаю',1598601030,'1',2),(9,3,'можно админку?))))',1598618055,'1',0),(10,3,'хочу посмотреть что тут как',1598618130,'1',0),(11,3,'Чуть по позже',1598619476,'1',2),(12,3,'ок ну дай 30 рублей на баланс) хочу заказать хостинг 1гб))',1598619502,'1',0),(13,3,'Ок',1598621097,'1',2),(14,27,'Привет',1598621233,'1',0),(15,27,'Привет',1598621298,'1',2),(16,3,'ну где?',1598678363,'1',0),(17,3,'ну ладно если не хочешь дать',1598806275,'1',0),(18,3,'Дал же',1598820938,'1',2),(19,3,'эмм я когда написал у меня не было :)',1598861435,'1',0),(20,3,'спасибо)',1598861443,'1',0),(21,3,'как тебе мой сайт? я сделал)) tiko.ekeo.ru',1598862146,'1',0),(22,3,'дизайн конечно не мой). но код мой 5.6 версия php.',1598862205,'1',0),(23,3,'еще и он не полностью написан',1598862219,'1',0),(24,3,'ты можешь понизить версию своего mysql? она у тебя mysql-5.7.31. просто это версия еще как бы не актуально. надо бы 5.6 версия. и еще в моём сайте не идёт запись в бд из за этого',1598862902,'1',0),(25,3,'если можешь то плис смени версию',1598862918,'1',0),(26,3,'ну как там?',1598951903,'1',0),(27,3,'ну как там?',1598951905,'1',0),(28,3,'то есть исправишь mysql? ну то есть сменишь версию?',1598951924,'1',0),(29,2,'Ggg',1641764165,'1',33);
/*!40000 ALTER TABLE `support` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`user_id` int(10) NOT NULL AUTO_INCREMENT,
`password` varchar(255) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`nick` varchar(20) NOT NULL DEFAULT '',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`money` decimal(11,2) NOT NULL DEFAULT 0.00,
`role` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_sessions`
--
DROP TABLE IF EXISTS `users_sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_sessions` (
`user_id` int(10) NOT NULL DEFAULT 0,
`token` char(32) NOT NULL DEFAULT '',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_sessions`
--
LOCK TABLES `users_sessions` WRITE;
/*!40000 ALTER TABLE `users_sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_sessions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-02-01 22:20:17