-- Adminer 4.7.0 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF EXISTS `albums`; CREATE TABLE `albums` ( `id` int(12) NOT NULL AUTO_INCREMENT, `url` char(30) NOT NULL, `time` int(12) NOT NULL, `name` char(30) NOT NULL, `user_id` int(12) NOT NULL, `guest_hash` char(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `category_gifts`; CREATE TABLE `category_gifts` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `type` int(12) NOT NULL, `name` char(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `chat`; CREATE TABLE `chat` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `user_id` int(12) NOT NULL, `message` mediumtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dialogs`; CREATE TABLE `dialogs` ( `id` int(12) NOT NULL AUTO_INCREMENT, `name` char(100) NOT NULL, `avatar` char(100) NOT NULL, `last_time` int(12) NOT NULL, `author_id` int(12) NOT NULL, `contact_id` int(12) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dialog_users`; CREATE TABLE `dialog_users` ( `id` int(12) NOT NULL AUTO_INCREMENT, `access` int(1) NOT NULL, `user_id` int(12) NOT NULL, `dialog_id` int(12) NOT NULL, `date_add` int(12) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `forgot`; CREATE TABLE `forgot` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `hash` char(70) NOT NULL, `user_id` int(12) NOT NULL, `pincode` int(12) NOT NULL, `recovered` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `friends`; CREATE TABLE `friends` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `status` int(1) NOT NULL, `user_id` int(12) NOT NULL, `message` char(100) NOT NULL, `subscriber_id` int(12) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `gift`; CREATE TABLE `gift` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `price` int(12) NOT NULL, `name` char(100) COLLATE utf8_unicode_ci NOT NULL, `image` char(50) COLLATE utf8_unicode_ci NOT NULL, `cat_id` int(12) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `messages`; CREATE TABLE `messages` ( `id` int(12) NOT NULL AUTO_INCREMENT, `read` int(1) NOT NULL, `time` int(12) NOT NULL, `user_id` int(12) NOT NULL, `dialog_id` int(12) NOT NULL, `message` tinytext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `read` int(12) NOT NULL, `user_id` int(12) NOT NULL, `message` text CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `news_files`; CREATE TABLE `news_files` ( `id` int(12) NOT NULL AUTO_INCREMENT, `url` char(100) NOT NULL, `time` int(12) NOT NULL, `user_id` int(12) NOT NULL, `news_id` int(12) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `news_likes`; CREATE TABLE `news_likes` ( `id` int(12) NOT NULL AUTO_INCREMENT, `type` int(1) NOT NULL, `time` int(12) NOT NULL, `user_id` int(12) NOT NULL, `news_id` int(12) NOT NULL, PRIMARY KEY (`id`), KEY `news_id` (`news_id`), CONSTRAINT `news_likes_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `news_views`; CREATE TABLE `news_views` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `user_id` int(12) NOT NULL, `news_id` int(12) NOT NULL, PRIMARY KEY (`id`), KEY `news_id` (`news_id`), CONSTRAINT `news_views_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `notifications`; CREATE TABLE `notifications` ( `id` int(12) NOT NULL, `time` int(12) NOT NULL, `type` int(1) NOT NULL, `who` int(12) NOT NULL, `read` tinytext NOT NULL, `whom` int(12) NOT NULL, `message` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `photos`; CREATE TABLE `photos` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `name` char(100) NOT NULL, `user_id` int(12) NOT NULL, `album_id` int(12) NOT NULL, `guest_hash` char(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `quotes`; CREATE TABLE `quotes` ( `id` int(12) NOT NULL AUTO_INCREMENT, `text` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `id` int(12) NOT NULL AUTO_INCREMENT, `site_url` char(100) NOT NULL, `site_name` char(100) NOT NULL, `site_description` text NOT NULL, `adver_price_day` decimal(11,2) NOT NULL, `adver_price_year` decimal(11,2) NOT NULL, `adver_price_month` decimal(11,2) NOT NULL, `max_files_to_download` int(3) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `settings` (`id`, `site_url`, `site_name`, `site_description`, `adver_price_day`, `adver_price_year`, `adver_price_month`, `max_files_to_download`) VALUES (1, 'a0235280.xsph.ru', 'Фотохостинг ThePix', 'ThePix - это бесплатный хостинг изображений', 0.00, 0.00, 0.00, 100); DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(1) NOT NULL AUTO_INCREMENT, `login` varchar(20) NOT NULL, `number` varchar(25) NOT NULL, `token` varchar(60) NOT NULL, `password` varchar(30) NOT NULL, `name` varchar(20) NOT NULL, `last_name` varchar(30) NOT NULL, `avatar` varchar(100) NOT NULL, `fon_avatar` varchar(100) NOT NULL, `country` varchar(40) NOT NULL, `city` varchar(40) NOT NULL, `date_reg` int(12) NOT NULL, `date_last` int(20) NOT NULL, `online` int(12) NOT NULL, `access` int(1) NOT NULL, `email` varchar(50) NOT NULL, `status` varchar(60) NOT NULL, `gender` int(1) NOT NULL, `money` decimal(11,2) NOT NULL DEFAULT '0.00', `vip` int(1) NOT NULL, `age` int(3) NOT NULL, `cache_file` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `user_gifts`; CREATE TABLE `user_gifts` ( `id` int(12) NOT NULL AUTO_INCREMENT, `time` int(12) NOT NULL, `gift_id` int(12) NOT NULL, `who_id` int(12) NOT NULL, `user_id` int(12) NOT NULL, `message` char(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `worldkassa`; CREATE TABLE `worldkassa` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID платежа (Внутренний ID)', `user_id` int(11) unsigned NOT NULL COMMENT 'ID пользователя', `pay_id` int(11) unsigned NOT NULL COMMENT 'ID платежа в Worldkassa', `time` int(11) unsigned NOT NULL COMMENT 'Время инициализации платежа', `pay_time` int(11) unsigned DEFAULT '0' COMMENT 'Время оплаты', `amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT 'Сумма', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Статистика платежей через WorldKassa'; -- 2019-02-25 11:59:51