Файл: install/coolcms.sql
Строк: 227
-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
--
http://www.phpmyadmin.net
--
-- Xost: localhost
-- Tuzilgan sana : 02
Apr 2014 y., 19:27
-- Server versiyasi: 5.5.35
-- PHP versiyasm:
5.3.10-1ubuntu3.10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET
time_zone = "+00:00";
/*!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 */;
--
-- Ma`lumotlar bazasi: `test`
--
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`userid_by`
int(11) NOT NULL,
`reason` varchar(250) NOT NULL,
`time` int(10) NOT
NULL,
`exp` int(10) NOT NULL,
`active` int(1) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `blogs_categs`
--
CREATE TABLE IF NOT EXISTS `blogs_categs`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `blogs_content`
--
CREATE TABLE IF NOT EXISTS `blogs_content`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`categid` int(11) NOT NULL,
`postid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `blogs_posts`
--
CREATE TABLE IF NOT EXISTS `blogs_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`subject` varchar(50) NOT NULL,
`message` text NOT NULL,
`time`
int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `configuration`
--
CREATE TABLE IF NOT EXISTS `configuration`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT
NULL,
`value` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
--
-- Jadval
ma`lumotlarini damp qilish `configuration`
--
INSERT INTO
`configuration` (`id`, `name`, `value`) VALUES
(1, 'title',
'coolcms'),
(15, 'allowed_ext', 'zip'),
(3, 'timeshift', '0'),
(4,
'keypass', 'dg45e7u'),
(5, 'ipp', '10'),
(6, 'webtheme',
'mobile_default'),
(7, 'mobtheme', 'mobile_default'),
(8, 'language',
'uzbek'),
(9, 'editmin', '5'),
(10, 'wait_time', '1'),
(11, 'msglength',
'500'),
(12, 'online_updmin', '8'),
(14, 'max_filesize', '5'),
(16,
'description', 'keywordshgj'),
(17, 'keywords', 'keywordshgj'),
(18,
'bbpanel', '10');
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `downloads_categs`
--
CREATE TABLE IF NOT EXISTS
`downloads_categs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parentid`
int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`foldername`
varchar(150) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `downloads_posts`
--
CREATE TABLE IF NOT EXISTS
`downloads_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`categid`
int(11) NOT NULL,
`userid` int(11) NOT NULL,
`name` varchar(50) NOT
NULL,
`filename` varchar(150) NOT NULL,
`message` text NOT NULL,
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `emoticons`
--
CREATE TABLE IF NOT EXISTS `emoticons` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`file` varchar(20) NOT
NULL,
`code` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
KEY
`smiles_code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=44 ;
--
-- Jadval ma`lumotlarini damp qilish
`emoticons`
--
INSERT INTO `emoticons` (`id`, `file`, `code`)
VALUES
(1, ').gif', ':)'),
(2, '(.gif', ':('),
(3, 'winked_at.gif',
':w'),
(4, 'boasting.gif', ':P'),
(5, '0).gif', ':0)'),
(6, '8).gif',
':8)'),
(7, 'D.gif', ':D'),
(8, 'ah.gif', ':['),
(9, 'o_O.gif',
':o_O'),
(10, 'kiss.gif', ':kiss'),
(11, 'cry.gif', ':cry'),
(12,
'x.gif', ':x'),
(13, 'angry.gif', ':angry'),
(14, 'n.gif', ':n'),
(15,
'ao.gif', ':-/'),
(16, 'joke.gif', ':joke'),
(17, 'diablo.gif',
':]'),
(18, 'music.gif', ':music'),
(19, 'kissed.gif', ':kissed'),
(20,
'at.gif', ':-'),
(21, 'tired.gif', ':tired'),
(22, 'stop.gif',
':stop'),
(23, 'kissing.gif', ':kissing'),
(24, 'rose.gif',
':rose'),
(25, 'thumbsup.gif', ':thumbsup'),
(26, 'drink.gif',
':drink'),
(27, 'heart.gif', ':heart'),
(28, 'bomb.gif', ':bomb'),
(29,
'sos.gif', ':sos'),
(30, 'm.gif', ':m'),
(31, 'be.gif', ':s'),
(32,
'ok.gif', ':ok'),
(33, 'wassup.gif', ':wassup'),
(34, 'sorry.gif',
':sorry'),
(35, 'bravo.gif', ':bravo'),
(36, 'rofl.gif', ':rofl'),
(37,
'pardon.gif', ':pardon'),
(38, 'no.gif', ':no'),
(39, 'crazy.gif',
':crazy'),
(40, 'dont_know.gif', ':dont_know'),
(41, 'dance.gif',
':dance'),
(42, 'yahoo.gif', ':yahoo'),
(43, 'no-no.gif',
':no-no');
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `forum_categs`
--
CREATE TABLE IF NOT EXISTS `forum_categs`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`parentid` int(11) NOT
NULL,
`name` varchar(50) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Jadval tuzilishi `forum_posts`
--
CREATE TABLE IF NOT EXISTS
`forum_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`categid`
int(11) NOT NULL,
`threadid` int(5) NOT NULL,
`userid` int(11) NOT
NULL,
`message` text NOT NULL,
`time` int(10) NOT NULL,
`edit_by`
int(11) NOT NULL,
`edit_time` int(10) NOT NULL,
`edit_count` int(10)
NOT NULL,
`rating` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `forum_threads`
--
CREATE TABLE IF NOT EXISTS `forum_threads`
(
`id` int(5) NOT NULL AUTO_INCREMENT,
`categid` int(3) NOT NULL,
`subject` varchar(50) DEFAULT NULL,
`userid` int(11) NOT NULL,
`time`
int(10) NOT NULL,
`lastuserid` int(11) NOT NULL,
`updtime` int(10)
NOT NULL,
`sticky` int(1) NOT NULL,
`closed` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Jadval tuzilishi `forum_threads_visits`
--
CREATE TABLE IF NOT EXISTS
`forum_threads_visits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`threadid` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`time`
int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `guestbook`
--
CREATE TABLE IF NOT EXISTS `guestbook` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`message` text NOT NULL,
`time` int(10) NOT NULL,
`edit_by` int(11)
NOT NULL,
`edit_time` int(10) NOT NULL,
`edit_count` int(5) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `language`
--
CREATE TABLE IF NOT EXISTS `language` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`file` varchar(10) NOT NULL,
`name`
varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Jadval ma`lumotlarini damp qilish
`language`
--
INSERT INTO `language` (`id`, `file`, `name`) VALUES
(1,
'english', 'English'),
(2, 'russian', 'Русский - Russian'),
(3,
'uzbek', 'O''zbekcha - Uzbek'),
(4, 'ukrainian', 'Українська -
Ukrainian'),
(5, 'lithuanian', 'Lietuvių - Lithuanian');
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`subject`
varchar(50) NOT NULL,
`message` text,
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Jadval tuzilishi `news_comments`
--
CREATE TABLE IF NOT EXISTS
`news_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`newsid`
int(11) NOT NULL,
`userid` int(11) NOT NULL,
`message` varchar(250)
NOT NULL,
`time` int(10) NOT NULL,
`edit_by` int(11) NOT NULL,
`edit_time` int(10) NOT NULL,
`edit_count` int(5) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`ip`
varchar(50) NOT NULL,
`browser` varchar(50) NOT NULL,
`location`
varchar(50) NOT NULL,
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `pm`
--
CREATE TABLE IF NOT EXISTS `pm` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`recipientid` int(11) NOT NULL,
`senderid`
int(11) NOT NULL,
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `pm_posts`
--
CREATE TABLE IF NOT EXISTS `pm_posts` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`pmid` int(11) NOT NULL,
`recipientid` int(11) NOT NULL,
`senderid` int(11) NOT NULL,
`message` text NOT NULL,
`time` int(10) NOT NULL,
`read` int(1) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `referers`
--
CREATE TABLE IF NOT EXISTS `referers` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`url` text NOT NULL,
`url_short`
varchar(250) NOT NULL,
`ip` varchar(50) NOT NULL,
`amount` int(11)
NOT NULL,
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `sitehelp`
--
CREATE TABLE IF NOT EXISTS `sitehelp` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`language` varchar(10) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Jadval ma`lumotlarini damp qilish
`sitehelp`
--
INSERT INTO `sitehelp` (`id`, `language`, `value`)
VALUES
(1, 'english', 'sitehelp'),
(2, 'russian', 'sitehelp'),
(3,
'ukrainian', 'sitehelp'),
(4, 'uzbek', 'sitehelp');
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `terms`
--
CREATE TABLE IF NOT EXISTS `terms` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`language` varchar(10) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Jadval ma`lumotlarini damp qilish
`terms`
--
INSERT INTO `terms` (`id`, `language`, `value`) VALUES
(1,
'english', 'terms'),
(2, 'russian', 'terms'),
(3, 'ukrainian',
'terms'),
(4, 'uzbek', 'terms');
--
--------------------------------------------------------
--
-- Jadval
tuzilishi `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT NULL,
`password` text,
`email` varchar(50) NOT NULL,
`verified` varchar(12)
NOT NULL,
`access` text NOT NULL,
`regtime` int(10) DEFAULT NULL,
`lastseen` int(10) NOT NULL,
`name` varchar(20) NOT NULL,
`gender`
int(1) NOT NULL,
`location` varchar(50) NOT NULL,
`skype` varchar(15)
NOT NULL,
`icq` int(9) NOT NULL,
`jabber` varchar(15) NOT NULL,
`website` varchar(30) NOT NULL,
`theme` varchar(50) NOT NULL,
`language` varchar(10) NOT NULL,
`ipp` int(2) NOT NULL,
`bbpanel`
int(1) NOT NULL,
`browser` varchar(50) NOT NULL,
`ip` varchar(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
/*!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 */;