121207 16:22:04 20 Connect root@127.0.0.1 on
20 Query SET CHARACTER SET 'utf8'
20 Query SET collation_connection = 'utf8_general_ci'
21 Connect root@127.0.0.1 on
21 Query SET CHARACTER SET 'utf8'
21 Query SET collation_connection = 'utf8_general_ci'
21 Query SHOW DATABASES
20 Query SELECT `db_name`, `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE `column_name` = '(db_comment)'
21 Query SHOW TABLE STATUS FROM `dle.loc`
21 Query SHOW TABLES FROM `dle.loc`
20 Query SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'dle.loc'
AND table_name = ''
AND column_name = '(db_comment)'
21 Quit
20 Quit
121207 16:22:06 22 Connect root@127.0.0.1 on
22 Query SET CHARACTER SET 'utf8'
22 Query SET collation_connection = 'utf8_general_ci'
23 Connect root@127.0.0.1 on
23 Query SET CHARACTER SET 'utf8'
23 Query SET collation_connection = 'utf8_general_ci'
23 Quit
22 Quit
121207 16:22:11 24 Connect root@127.0.0.1 on
24 Query SET CHARACTER SET 'utf8'
24 Query SET collation_connection = 'utf8_general_ci'
25 Connect root@127.0.0.1 on
25 Query SET CHARACTER SET 'utf8'
25 Query SET collation_connection = 'utf8_general_ci'
24 Query SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'dle.loc'
AND table_name = ''
AND column_name = '(db_comment)'
25 Init DB mysql
25 Query SHOW MASTER LOGS
25 Query SHOW TABLES FROM `dle.loc`
25 Query SHOW TABLE STATUS FROM `dle.loc`
25 Query SELECT CURRENT_USER()
25 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''%''' AND PRIVILEGE_TYPE='EVENT'
25 Query SELECT CURRENT_USER()
25 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''%''' AND PRIVILEGE_TYPE='TRIGGER'
25 Query (SELECT `User`, `Host`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `Index_priv`, `Alter_priv`, `References_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`, `Db` FROM `mysql`.`db` WHERE 'dle.loc' LIKE `Db` AND NOT (`Select_priv` = 'N' AND `Insert_priv` = 'N' AND `Update_priv` = 'N' AND `Delete_priv` = 'N' AND `Create_priv` = 'N' AND `Drop_priv` = 'N' AND `Grant_priv` = 'N' AND `References_priv` = 'N' AND `Create_tmp_table_priv` = 'N' AND `Lock_tables_priv` = 'N' AND `Create_view_priv` = 'N' AND `Show_view_priv` = 'N' AND `Create_routine_priv` = 'N' AND `Alter_routine_priv` = 'N' AND `Execute_priv` = 'N' AND `Event_priv` = 'N' AND `Trigger_priv` = 'N')) UNION (SELECT `User`, `Host`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `Index_priv`, `Alter_priv`, `References_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`, '*' AS `Db` FROM `mysql`.`user` WHERE NOT (`Select_priv` = 'N' AND `Insert_priv` = 'N' AND `Update_priv` = 'N' AND `Delete_priv` = 'N' AND `Create_priv` = 'N' AND `Drop_priv` = 'N' AND `Grant_priv` = 'N' AND `References_priv` = 'N' AND `Create_tmp_table_priv` = 'N' AND `Lock_tables_priv` = 'N' AND `Create_view_priv` = 'N' AND `Show_view_priv` = 'N' AND `Create_routine_priv` = 'N' AND `Alter_routine_priv` = 'N' AND `Execute_priv` = 'N' AND `Event_priv` = 'N' AND `Trigger_priv` = 'N')) ORDER BY `User` ASC, `Host` ASC, `Db` ASC
25 Quit
24 Quit
121207 16:22:12 26 Connect root@127.0.0.1 on
26 Query SET CHARACTER SET 'utf8'
26 Query SET collation_connection = 'utf8_general_ci'
27 Connect root@127.0.0.1 on
27 Query SET CHARACTER SET 'utf8'
27 Query SET collation_connection = 'utf8_general_ci'
121207 16:22:13 27 Quit
26 Quit
121207 16:22:50 28 Connect root@127.0.0.1 on cpe.loc
121207 16:23:39 29 Connect root@127.0.0.1 on dle.loc
29 Query SHOW DATABASE LIKEdle.loc
29 Query set names utf8
29 Query SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0
29 Query SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
29 Query SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'
29 Query CREATE SCHEMA IF NOT EXISTSdle.locDEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
29 Query CREATE TABLE IF NOT EXISTS dle.loc.`users` (
`idusers` INT NOT NULL AUTO_INCREMENT COMMENT 'id - Зарегистрированного' ,
`login` VARCHAR(85) NOT NULL COMMENT 'Логин юзера, должен быть уникальный и состоять только из латинских букв и цифр , так же должен быть не более 20 символов' ,
`email` VARCHAR(85) NOT NULL COMMENT 'На него приходит уведомление о регистрации, так же нужен для авторизации, должен быть уникальным и реально существующим. не более 25 символов' ,
`password` VARCHAR(45) NOT NULL COMMENT 'Пароль пользователя, должен содержать не менее 7 символов и не более 20. Должен быть закодирован в мд5+соль. При потере, генерация нового пароля и перезаписывание старого' ,
`role` TINYINT NOT NULL DEFAULT 0 COMMENT '(роль пользователя 0 - Просто гость, 1 - Авторированный юзер, 2 - Автор, 3 Админ)
По умалчанию после авторизации, записуется 1, дефолт = 0, первому юзеру, авторизированному при инсталяции по умолчанию записывается 3 ' ,
PRIMARY KEY (`idusers`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
29 Query CREATE TABLE IF NOT EXISTS dle.loc.`articles` (
`idarticles` INT NOT NULL AUTO_INCREMENT COMMENT 'id - Уникальный (для статей)' ,
`title` VARCHAR(45) NOT NULL COMMENT 'Заголовок статьи' ,
`description` VARCHAR(85) NOT NULL COMMENT 'Описание статьи' ,
`keywords` VARCHAR(85) NOT NULL COMMENT 'Ключевые слова статьи' ,
`text` TEXT NOT NULL COMMENT 'Текст статьи' ,
`state` TINYINT NOT NULL COMMENT '0-черновик,1-опубликованна' ,
`date_create` VARCHAR(45) NOT NULL COMMENT 'Дата создания' ,
`date_edit` VARCHAR(45) NULL COMMENT 'Дата последнего изминения' ,
`users_idusers` INT NOT NULL ,
PRIMARY KEY (`idarticles`) ,
INDEX `fk_articles_users1` (`users_idusers` ASC) ,
CONSTRAINT `fk_articles_users1`
FOREIGN KEY (`users_idusers` )
REFERENCES dle.loc.`users` (`idusers` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
29 Query CREATE TABLE IF NOT EXISTS dle.loc.`rols` (
`idrols` INT NOT NULL AUTO_INCREMENT ,
`roleid` INT NOT NULL COMMENT '(роль юзера 0,1,2,3) ' ,
`textrole` VARCHAR(45) NOT NULL DEFAULT 'Гость' COMMENT 'В зависимости от роли пользователя: (0- Гость,1-Участник,2-Автор,3-Админ)' ,
`users_idusers` INT NOT NULL ,
PRIMARY KEY (`idrols`, `users_idusers`) ,
INDEX `fk_rols_users` (`users_idusers` ASC) ,
CONSTRAINT `fk_rols_users`
FOREIGN KEY (`users_idusers` )
REFERENCES dle.loc.`users` (`idusers` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
29 Query CREATE TABLE IF NOT EXISTS dle.loc.`settings` (
`idsettings` INT NOT NULL ,
`access` TINYINT NOT NULL COMMENT '( 0 Запрещать, 1 разрешать, 2 запрещать гостям => просмотр раздела)' ,
`offline` TINYINT NOT NULL DEFAULT 1 COMMENT 'Сайт (0 - закрыт, 1 -открыт)' ,
`editor` TINYINT NOT NULL DEFAULT 1 COMMENT 'Добавление статей (0- без редактора, 1 - с редактором) ' ,
`modules` TINYINT NOT NULL DEFAULT 1 COMMENT 'Модули (0 - не использовать, 1 использовать)' ,
PRIMARY KEY (`idsettings`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
29 Query CREATE TABLE IF NOT EXISTS dle.loc.`files` (
`idfiles` INT NOT NULL AUTO_INCREMENT ,
`path` VARCHAR(45) NOT NULL COMMENT 'Путь к файлу' ,
`extension` VARCHAR(45) NULL COMMENT 'Расширение файла, например .gif или .jpg' ,
`type` VARCHAR(45) NOT NULL COMMENT 'mime тип файла, например image/gif или text/html' ,
`users_idusers` INT NOT NULL ,
PRIMARY KEY (`idfiles`) ,
INDEX `fk_files_users1` (`users_idusers` ASC) ,
CONSTRAINT `fk_files_users1`
FOREIGN KEY (`users_idusers` )
REFERENCES dle.loc.`users` (`idusers` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
29 Query CREATE TABLE IF NOT EXISTS dle.loc.`widgets` (
`idwidgets` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(55) NOT NULL COMMENT 'РРјСЏ модуля' ,
`head` VARCHAR(255) NOT NULL COMMENT 'Заголовок модуля' ,
`template` VARCHAR(105) NOT NULL COMMENT '(имя шаблона или путь к нему) пример admin_autorization.php' ,
PRIMARY KEY (`idwidgets`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
29 Query CREATE TABLE IF NOT EXISTS dle.loc.`errors` (
`iderrors` INT NOT NULL AUTO_INCREMENT ,
`module` VARCHAR(45) NOT NULL COMMENT 'Модуль(виджет) в котором произошла ошибка' ,
`message` TEXT NOT NULL COMMENT 'Текст ошибки сообщения' ,
PRIMARY KEY (`iderrors`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
29 Query SET SQL_MODE=@OLD_SQL_MODE
29 Query SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS
29 Query SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS
29 Quit
121207 16:23:49 30 Connect root@127.0.0.1 on
30 Query SET CHARACTER SET 'utf8'
30 Query SET collation_connection = 'utf8_general_ci'
31 Connect root@127.0.0.1 on
31 Query SET CHARACTER SET 'utf8'
31 Query SET collation_connection = 'utf8_general_ci'
31 Init DB dle.loc
30 Query SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'dle.loc'
AND table_name = ''
AND column_name = '(db_comment)'
31 Query SHOW TABLES FROM `dle.loc`
31 Query SHOW TABLE STATUS FROM `dle.loc`
31 Query SELECT CURRENT_USER()
31 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''%''' AND PRIVILEGE_TYPE='EVENT'
31 Query SELECT CURRENT_USER()
31 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''%''' AND PRIVILEGE_TYPE='TRIGGER'
31 Query SHOW MASTER STATUS
31 Query SHOW SLAVE STATUS
31 Init DB dle.loc
31 Query SHOW VARIABLES LIKE 'collation_database'
31 Quit
30 Quit
121207 16:23:51 32 Connect root@127.0.0.1 on
32 Query SET CHARACTER SET 'utf8'
32 Query SET collation_connection = 'utf8_general_ci'
33 Connect root@127.0.0.1 on
33 Query SET CHARACTER SET 'utf8'
33 Query SET collation_connection = 'utf8_general_ci'
33 Quit
32 Quit
