Created
July 18, 2013 06:54
-
-
Save SankySyS/6027215 to your computer and use it in GitHub Desktop.
This gist exceeds the recommended number of files (~10).
To access all files, please clone this gist.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
kontur1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="Encoding" useUTFGuessing="true" native2AsciiForPropertiesFiles="false" /> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<module type="WEB_MODULE" version="4"> | |
<component name="NewModuleRootManager"> | |
<content url="file://$MODULE_DIR$" /> | |
<orderEntry type="inheritedJdk" /> | |
<orderEntry type="sourceFolder" forTests="false" /> | |
</component> | |
</module> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="ProjectRootManager" version="2" /> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="ProjectModuleManager"> | |
<modules> | |
<module fileurl="file://$PROJECT_DIR$/.idea/kontur1.iml" filepath="$PROJECT_DIR$/.idea/kontur1.iml" /> | |
</modules> | |
</component> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="DependencyValidationManager"> | |
<state> | |
<option name="SKIP_IMPORT_STATEMENTS" value="false" /> | |
</state> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="VcsDirectoryMappings"> | |
<mapping directory="" vcs="" /> | |
</component> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- phpMyAdmin SQL Dump | |
-- version 3.5.6 | |
-- http://www.phpmyadmin.net | |
-- | |
-- Хост: 127.0.0.1:3306 | |
-- Время создания: Фев 19 2013 г., 23:04 | |
-- Версия сервера: 5.5.30-log | |
-- Версия PHP: 5.4.11 | |
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 */; | |
-- | |
-- База данных: `kontur` | |
-- | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `bankaccounts` | |
-- | |
CREATE TABLE IF NOT EXISTS `bankaccounts` ( | |
`id` int(11) NOT NULL AUTO_INCREMENT, | |
`idOrganization` int(11) NOT NULL, | |
`bank` varchar(200) NOT NULL, | |
`bik` varchar(9) NOT NULL, | |
`rs` varchar(20) NOT NULL, | |
`ks` varchar(20) NOT NULL, | |
`name` varchar(50) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ; | |
-- | |
-- Дамп данных таблицы `bankaccounts` | |
-- | |
INSERT INTO `bankaccounts` (`id`, `idOrganization`, `bank`, `bik`, `rs`, `ks`, `name`) VALUES | |
(1, 0, 'Филиал ОАО ВТБ в г. Йошкар-Ола', '048860717', '40702810318000004245', '30101810100000000717', 'Контур 1'), | |
(2, 0, 'Филиал ОАО ВТБ в г. Йошкар-Ола', '048860717', '40702810318000004245', '30101810100000000717', 'Контур 2'), | |
(3, 0, '', '', '', '', 'Протон'), | |
(4, 0, '', '', '', '', 'Проект'), | |
(50, 2, 'asd', '', '', '', 'asd'), | |
(51, 4, 'wer', '', '', '', 'ewr'), | |
(53, 6, 'а', 'а', 'а', 'а', 'а'); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `ci_sessions` | |
-- | |
CREATE TABLE IF NOT EXISTS `ci_sessions` ( | |
`session_id` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '0', | |
`ip_address` varchar(45) COLLATE utf8_bin NOT NULL DEFAULT '0', | |
`user_agent` varchar(120) COLLATE utf8_bin NOT NULL, | |
`last_activity` int(10) unsigned NOT NULL DEFAULT '0', | |
`user_data` text COLLATE utf8_bin NOT NULL, | |
PRIMARY KEY (`session_id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | |
-- | |
-- Дамп данных таблицы `ci_sessions` | |
-- | |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES | |
('029eaddd1714466e56c83938549cda0c', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361170249, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361169942";}'), | |
('0fd46dcfd6e581cf570b04c6ef1f6cbe', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361169937, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361131137";}'), | |
('1804525b4dcdd86a248f393cd9f0f65e', '127.0.0.1', 'Opera/9.80 (Windows NT 6.2; Win64; x64) Presto/2.12.388 Version/12.14', 1361171121, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361170616";}'), | |
('2a3738cfdc4ad6c3714fc3dc34778aab', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361170249, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361169938";}'), | |
('2f411bc374379065c351f53f54dd8153', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361171195, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361171196";}'), | |
('50da627d16e367e08b80b01073674457', '127.0.0.1', 'Opera/9.80 (Windows NT 6.2; Win64; x64) Presto/2.12.388 Version/12.14', 1361171121, ''), | |
('8b8644e0124a1f496b36e3d6a8867e89', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361169937, ''), | |
('9890ba4dbc0da393829006b16136fa8f', '127.0.0.1', 'Opera/9.80 (Windows NT 6.2; Win64; x64) Presto/2.12.388 Version/12.14', 1361171121, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361171122";}'), | |
('a25d1905a3d5b1ce9c12e899887aae0d', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361170612, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361170250";}'), | |
('c43827a93df4d51ab0e31b055c1f8f9f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361171195, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361170612";}'), | |
('cfe653a39ace7d4b47cebab9461ce71f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361170612, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361170253";}'), | |
('dd49bd0bed9b08160b0a3fcae0e1994f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', 1361171195, 'a:5:{s:8:"identity";s:8:"sankysys";s:8:"username";s:8:"sankysys";s:5:"login";s:8:"sankysys";s:7:"user_id";s:1:"2";s:14:"old_last_login";s:10:"1361171140";}'); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `companies` | |
-- | |
CREATE TABLE IF NOT EXISTS `companies` ( | |
`id` tinyint(1) NOT NULL AUTO_INCREMENT, | |
`nameShort` varchar(50) NOT NULL, | |
`nameFull` varchar(150) NOT NULL, | |
`legalAddress` varchar(200) NOT NULL, | |
`postAddress` varchar(200) NOT NULL, | |
`directorName` varchar(70) NOT NULL, | |
`directorTelNo` varchar(30) NOT NULL, | |
`information` text NOT NULL, | |
`INN` varchar(10) NOT NULL, | |
`KPP` varchar(9) NOT NULL, | |
`license` varchar(120) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; | |
-- | |
-- Дамп данных таблицы `companies` | |
-- | |
INSERT INTO `companies` (`id`, `nameShort`, `nameFull`, `legalAddress`, `postAddress`, `directorName`, `directorTelNo`, `information`, `INN`, `KPP`, `license`) VALUES | |
(2, 'Контур', 'ООО «ПКФ «Контур»', '424031, РМЭ, г. Йошкар-Ола, ул. Чехова д.74', '424031, РМЭ, г. Йошкар-Ола, ул. Чехова д.74', 'Тарасенко Олег Вячеславович', '', 'тел/факс. (8362) 42-21-80, 43-01-31', '1215034192', '121501001', '№ 3-2/00012 от 14 апреля 2009 года'), | |
(3, 'Протон', '', '', '', '', '', '2', '', '', ''), | |
(4, 'Проект', '', '', '', '', '', '3', '', '', ''); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `contracts` | |
-- | |
CREATE TABLE IF NOT EXISTS `contracts` ( | |
`id` smallint(11) NOT NULL AUTO_INCREMENT, | |
`idOrganization` smallint(11) NOT NULL, | |
`idObject` smallint(11) NOT NULL, | |
`current` bit(1) NOT NULL, | |
`nc1` smallint(6) NOT NULL, | |
`nc2` smallint(6) NOT NULL, | |
`dateContract` date NOT NULL, | |
`dateBeginContract` date NOT NULL, | |
`dateEndContract` date NOT NULL, | |
`info` text NOT NULL, | |
`sum` decimal(10,2) NOT NULL, | |
PRIMARY KEY (`id`), | |
UNIQUE KEY `id` (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `failures` | |
-- | |
CREATE TABLE IF NOT EXISTS `failures` ( | |
`id` int(11) NOT NULL AUTO_INCREMENT, | |
`idObject` int(11) NOT NULL, | |
`description` text NOT NULL, | |
`callDate` int(11) NOT NULL, | |
`answer` text NOT NULL, | |
`fix` tinyint(1) NOT NULL, | |
`correctDate` int(11) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Информация о неисправностях на объектах' AUTO_INCREMENT=15 ; | |
-- | |
-- Дамп данных таблицы `failures` | |
-- | |
INSERT INTO `failures` (`id`, `idObject`, `description`, `callDate`, `answer`, `fix`, `correctDate`) VALUES | |
(7, 4, 'sdgfdsgdfg', 0, '', 0, 0), | |
(8, 4, 'dfhdfbcvb', 0, '', 0, 0), | |
(9, 4, 'dfnzdndfbhe', 0, '', 0, 0), | |
(10, 4, '5', 0, '', 0, 0), | |
(11, 4, '6', 0, '', 0, 0), | |
(12, 4, '7', 0, '', 0, 0), | |
(13, 4, '8', 0, '', 0, 0), | |
(14, 4, 'сломалось беленькая штучка которая висит у потолка. пиликает и дымится', 1360921020, 'Заменили на другую белую штучку. которая не дымится и не пикает.', 1, 1360921020); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `groups` | |
-- | |
CREATE TABLE IF NOT EXISTS `groups` ( | |
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, | |
`name` varchar(20) NOT NULL, | |
`description` varchar(100) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; | |
-- | |
-- Дамп данных таблицы `groups` | |
-- | |
INSERT INTO `groups` (`id`, `name`, `description`) VALUES | |
(1, 'admin', 'Администратор'), | |
(2, 'engineer', 'Инженер'), | |
(3, 'electrician', 'Монтер'), | |
(4, 'operator', 'Оператор'); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `login_attempts` | |
-- | |
CREATE TABLE IF NOT EXISTS `login_attempts` ( | |
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, | |
`ip_address` varbinary(16) NOT NULL, | |
`login` varchar(100) NOT NULL, | |
`time` int(11) unsigned DEFAULT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `objectelctricians` | |
-- | |
CREATE TABLE IF NOT EXISTS `objectelctricians` ( | |
`id` int(11) NOT NULL AUTO_INCREMENT, | |
`idUser` int(11) NOT NULL, | |
`idObject` int(11) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ; | |
-- | |
-- Дамп данных таблицы `objectelctricians` | |
-- | |
INSERT INTO `objectelctricians` (`id`, `idUser`, `idObject`) VALUES | |
(5, 5, 2), | |
(6, 7, 2), | |
(8, 6, 2), | |
(26, 5, 3), | |
(27, 5, 4); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `objects` | |
-- | |
CREATE TABLE IF NOT EXISTS `objects` ( | |
`id` int(11) NOT NULL AUTO_INCREMENT, | |
`idOrganization` int(11) NOT NULL, | |
`nameShort` varchar(100) NOT NULL, | |
`address` varchar(250) NOT NULL, | |
`contactName` varchar(100) NOT NULL, | |
`contactTelNo` varchar(50) NOT NULL, | |
`information` text NOT NULL, | |
`idEngineer` int(11) NOT NULL, | |
PRIMARY KEY (`id`), | |
KEY `id` (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; | |
-- | |
-- Дамп данных таблицы `objects` | |
-- | |
INSERT INTO `objects` (`id`, `idOrganization`, `nameShort`, `address`, `contactName`, `contactTelNo`, `information`, `idEngineer`) VALUES | |
(2, 1, 'вф', 'ыфв', 'ыфв', 'ыфв', 'ыфв', 3), | |
(3, 1, '2', '22', '2', '2', '2', 2), | |
(4, 1, '5', '5', '5', '5', '2', 3); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `organizations` | |
-- | |
CREATE TABLE IF NOT EXISTS `organizations` ( | |
`id` int(11) NOT NULL AUTO_INCREMENT, | |
`idOverhead` int(11) NOT NULL, | |
`nameShort` varchar(100) NOT NULL, | |
`nameFull` varchar(200) NOT NULL, | |
`legalAddress` varchar(200) NOT NULL, | |
`postAddress` varchar(200) NOT NULL, | |
`directorName` varchar(70) NOT NULL, | |
`directorTelNo` varchar(30) NOT NULL, | |
`employeeName` varchar(70) NOT NULL, | |
`employeeTelNo` varchar(30) NOT NULL, | |
`information` text NOT NULL, | |
`INN` varchar(9) NOT NULL, | |
`KPP` varchar(9) NOT NULL, | |
`passport` varchar(10) NOT NULL, | |
`issued` varchar(150) NOT NULL, | |
`DOB` date NOT NULL, | |
`typeOrg` tinyint(1) NOT NULL DEFAULT '0', | |
`address` varchar(200) NOT NULL COMMENT 'адрес прописки физ.лица', | |
`idBankAccount` int(11) NOT NULL, | |
`actingUnder` varchar(250) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; | |
-- | |
-- Дамп данных таблицы `organizations` | |
-- | |
INSERT INTO `organizations` (`id`, `idOverhead`, `nameShort`, `nameFull`, `legalAddress`, `postAddress`, `directorName`, `directorTelNo`, `employeeName`, `employeeTelNo`, `information`, `INN`, `KPP`, `passport`, `issued`, `DOB`, `typeOrg`, `address`, `idBankAccount`, `actingUnder`) VALUES | |
(1, 0, 'ООО фИРМА 142', '18rt3', '1', '14668', '1', '1', '1', '1', '', '3', '3', '', '', '0000-00-00', 0, '', 0, ''), | |
(2, 0, 'ИП предприниматель', 'ИП предприниматель', '', 'г. Йошкар-Ола 1', 'sdf', 'sdf', 'sdf', 'sdf', 'sdf47', '111111111', '', '1111111111', '8585 ewfwegf 1', '2029-02-20', 1, '', 0, ''), | |
(3, 0, 'Короткое наименование', 'Полное наименование', 'Юридический адрес', 'Физический(почтовый) адрес', 'ФИО руководителя', 'Телефон', 'ФИО отвественного', 'Телефон', 'Информация', '232342342', '324324234', '', '', '0000-00-00', 0, '', 0, 'yf jcyjdfybb ljdthtyyjcnb'), | |
(4, 0, '5', '5', '5', '5', '5', '5', '5', '5', '5', '5', '5', '', '', '0000-00-00', 0, '', 0, '5'), | |
(6, 1, 'филиал фирмы 142', 'полный филиал фирмы 142', 'там', 'тут', 'а', 'а', 'а', 'а', 'нет', 'а', 'а', '', '', '0000-00-00', 0, '', 0, 'а'); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `users` | |
-- | |
CREATE TABLE IF NOT EXISTS `users` ( | |
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, | |
`ip_address` varbinary(16) NOT NULL, | |
`username` varchar(100) NOT NULL, | |
`password` varchar(80) NOT NULL, | |
`salt` varchar(40) DEFAULT NULL, | |
`login` varchar(100) NOT NULL, | |
`activation_code` varchar(40) DEFAULT NULL, | |
`forgotten_password_code` varchar(40) DEFAULT NULL, | |
`forgotten_password_time` int(11) unsigned DEFAULT NULL, | |
`remember_code` varchar(40) DEFAULT NULL, | |
`created_on` int(11) unsigned NOT NULL, | |
`last_login` int(11) unsigned DEFAULT NULL, | |
`active` tinyint(1) unsigned DEFAULT NULL, | |
`first_name` varchar(50) DEFAULT NULL, | |
`last_name` varchar(50) DEFAULT NULL, | |
`phone` varchar(20) DEFAULT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; | |
-- | |
-- Дамп данных таблицы `users` | |
-- | |
INSERT INTO `users` (`id`, `ip_address`, `username`, `password`, `salt`, `login`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `phone`) VALUES | |
(1, '\0\0', 'administrator', '59beecdf7fc966e2f17fd8f65a4a9aeb09d4a3d4', '9462e8eee0', 'admin', '', NULL, NULL, '9d029802e28cd9c768e8e62277c0df49ec65c48c', 1268889823, 1360931555, 1, 'Admin', 'istrator', '0'), | |
(2, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 'sankysys', '9799b8c4003f0ab031848d604dc76d5fab4cfd13', NULL, 'sankysys', NULL, NULL, NULL, '4b1a109f2531a6a926c4991dedaa0363e20f70f8', 1359277200, 1361286124, 1, 'Александр', 'Леонтьев', '+79177042173'), | |
(3, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 'Инженер 1', '145ea04bf3048251c1beaf8b781413557d3b4609', NULL, 'qwerty', NULL, NULL, NULL, '1602aa2dfa66a3bff15346a236201f13843b1638', 1359629765, 1361218384, 1, 'Инженер', '1', '1232466634'), | |
(4, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 'Инженер 2', '6e4d0c4c8cda2d8f9a12b60056d83294d6e12b8b', NULL, 'sasasa', NULL, NULL, NULL, NULL, 1359630056, 1359630056, 1, 'Инженер', '2', '332'), | |
(5, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 'Работник 1', '38c7f4ff3e592a4c8d4e63d91c1f708b74d583de', NULL, 'rabot1', NULL, NULL, NULL, 'fb3febec38420220714f7b527131c1cbf2eadd2f', 1359631479, 1361282479, 1, 'Работник', '1', '1'), | |
(6, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 'rabot 2', '5117de84dfcce64b1f3367d7a7176a481e0afc9f', NULL, 'rabor2', NULL, NULL, NULL, NULL, 1359631506, 1359631506, 1, 'rabot', '2', '2'), | |
(7, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 'rabot 3', 'a93fd003ae5a3dfd70d6571bb8a9f4f84e83fff0', NULL, 'rabot3', NULL, NULL, NULL, NULL, 1359631543, 1359631543, 1, 'rabot', '3', '3'), | |
(8, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 'rabot 4', '7959cfdfd5198f2ac215940a5cc5ff27daa0b545', NULL, 'rabot4', NULL, NULL, NULL, NULL, 1359631574, 1359631574, 1, 'rabot', '4', '4'); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `users_groups` | |
-- | |
CREATE TABLE IF NOT EXISTS `users_groups` ( | |
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, | |
`user_id` mediumint(8) unsigned NOT NULL, | |
`group_id` mediumint(8) unsigned NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ; | |
-- | |
-- Дамп данных таблицы `users_groups` | |
-- | |
INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES | |
(11, 1, 1), | |
(13, 4, 2), | |
(15, 6, 3), | |
(16, 7, 3), | |
(17, 8, 3), | |
(18, 2, 1), | |
(19, 3, 2), | |
(20, 5, 3); | |
-- -------------------------------------------------------- | |
-- | |
-- Структура таблицы `сompaniesBA` | |
-- | |
CREATE TABLE IF NOT EXISTS `сompaniesBA` ( | |
`id` tinyint(4) NOT NULL AUTO_INCREMENT, | |
`idCompany` tinyint(4) NOT NULL, | |
`bank` varchar(200) NOT NULL, | |
`bik` varchar(9) NOT NULL, | |
`rs` varchar(20) NOT NULL, | |
`ks` varchar(20) NOT NULL, | |
`name` varchar(50) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; | |
-- | |
-- Дамп данных таблицы `сompaniesBA` | |
-- | |
INSERT INTO `сompaniesBA` (`id`, `idCompany`, `bank`, `bik`, `rs`, `ks`, `name`) VALUES | |
(1, 2, 'Филиал ОАО ВТБ в г. Йошкар-Ола', '048860717', '40702810318000004245', '30101810100000000717', 'Контур 1'), | |
(2, 2, 'Филиал ОАО ВТБ в г. Йошкар-Ола', '048860717', '40702810318000004245', '30101810100000000717', 'Контур 2'), | |
(3, 3, '', '', '', '', 'Протон'), | |
(4, 4, '', '', '', '', 'Проект'); | |
/*!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 */; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PK ��0B cache/PK P:HA!�j cache/.htaccessKIͫTH+��UH�� PK �>v?�W'�[ r cache/index.html5�A | |
� ��us�9A�f��tB�Rԍ�/����瑫w` '�2LT} �۲��魕����PtF���>��17��H)�^8�J��ῼ�PK �jRB config/PK l PB�`�� a config/autoload.php�W�n7}��bj�ث�I��mZ�� T[H�AQ�Ҳ�.�$ײ�||ϐ+u}ɥ��-i�Μ��_�&=�m�r5Օʷ{�ޝ��oz;;�nu��[ʵS2��Nׁ���{�ع�{;?n��=ۤgtls5�U:(�%�*������IE����"h[A�2�.Uh�D���]��:�ӫ� {IXTj�B;�������{���i�*�rj�\9 | |
����*��3��� �(�Y���y+zYh���TE�l&���~j{p6b��b�6��1ס�>�j!���U�b�L¸S���@�;;·���� | |
/{K�Fh#&�^(�mfE�����&�[D��ߎY��>������̺Y�����^� ��� XΩ�����7`���d�Q[+H��I8_�Y�� `�����Rm� �WQ�*a X,��jv����fҖ`�$q8 | |
�-�[�T�A�E�ry�:{c�n ґhBa���)c�ĄN� ]*Q��2�ӳ"@��m�Cϟ�@{���KK�]V2��ֻ���w"\먍��#�K��bV�+@ �t����p����� �O��x����o"Q7?�����������bpr���0c6�4���z��,�B˂��U"7� �&�G��k��K4I�CT���k��v��"8�@��\E������C�Vf�ǁ"&ޚ&(*u�Ka�ɍ>��C�t�Z�nE�� k�Ex�y%mU��@wCH��P��.(҇C��oʚ$@ WB�τˑp�������9��u��<����IT�j�=��y����+�bC�v�8�w�|�ߧ!zX���v���B9�jX͒�\Aش�n?�B��S��dH��N�勌N�澁�ˌ�(S��1���*����ɝ����FT��k�r��~C�|o>q2� v�E;�< ���`âV�]�-�U��k���I��v'ۃ�LJ���.,z���7������ CqnH~�< ���U]����uP�3�{��i�)��Z�z*�QCp뺣҃�)������|Ǎ�e5b2b���ҸZ2���D��[#=�&�S��$%��!�C����f��W<K��ٺE�7��j�S�-�7t�#' | |
��ʅ�#U������N����x | |
`����z�߯�Z�m=k+�: | |
U�GET�5�q1��4?�O���~�J)����d��I��kn�ُ�?R���o���4h` -yFI�҈o<�\��>�Ò;o!�N�<��W��-1�\�P3�^�bpahbDu�=l.��q���� �*�r�{� ���É��%�G���l]�-���o��M���sgH�V�!������ip�c'ʔ�`���̣��H�r�Z;1%+�2�x�_�mp��2o�-E��3>�}�������*4�y<O^'<����M��y�OM ��Yc��o���?S�x��ݗl)�S<(3� �<�Q��G�{dS�;����)'��$�PK �jRB��= j= config/config.php�[ms�F��,��IU.�R)�ٽ�|�D�(�kZҒT��=jID �� ����oߧ� H�Y_��u���%`�����?,f�LԾ�J�f�d&�~:v�OF���2�I�\Z'�� | |
�<YJG�qN�4�K��u�����V�����YR�ғ�Lمɔ�e��4�t���Ljs�j��Y��VMl��/���/��)�e ��j�;?s�ǿ�î�O"�9�2�M���Q'���<��ynL�@ݙ���#�u4K\E�$I��?��t������>�9�]`A��t,�b�瀵�ѭ�lư�S���$m���l<�]�&`=� | |
.;���NR=y�,��t�����p��Ռ�`�7��1����!���6�v<&���՛��-!�Xe�P��I� -��J� c���b�s^AV�q�q�� X�'���р��Ȕ��T @�z�M4i�8��9$��*�b�DTz����ĉ.L�j{Y�虽�����G]3���u v_�ՙ�S#������tV`��M�G�������<�R�֖�eQ[�{�6��08Ϩ��/�?�/3��F8]"�#�� ����g���E�?��1n��yC}��������:)�vO��bϛ�E��m5Z-�L�t%z�L�T���]���_z��M�Cݠa | |
�r�cBPq���9���Ȉ{����"�!ۂk��%�BR�Enٴ�b;'{�� �B�+�gH2W�`v�m �H��l6I��������kx�R�ά+�W;^��^�CG�\r�'��ж)�z��IRb"��:��b�r ���0 7�:Ӯ�� rjn�07˜������ y^���'u���k���:������@v"��AO]�FW�WOo<���9B-�u��A̒h���j�ڱN���~zL㙇E��'��I6m+�5�-�2e�(H����* ��8�ϡ��k�I��ɕ9؈7,����E��Lq,~�����PS}gsǖ����yR���F ;8��� �O�\�u8�~��&?�}"�x� p���J Pػ<'[�֯>��A�/7��(��m����s�>���7(�x�aK�< +#�Ͽ��#�L��ݨ�]p���#[=)���x��7�qjj2�#�C?WM�K*u�j�Sv1�%����Pi(z�D���ڡe!/�ƴ_�ڳb�� ��HC�s�����Φ%|�n$�_(��R�է�������[���5��rҌ����:s�� 'YAD[�tj��F(#̦H�f۾��G?/�Kt�S���t�#��CS��8IX��Z_y[����l�o���V�D��x�=�������� ~����CJ�&JtJ��kxj�������d���n[@��������H��%G�,q�eÕ��va�{r�4cɪ�&��R]r*��pjbt;����2R!��(w��s�:� ��ফ����Ye��� %�M= � | |
b��I�˟��H����T����s������f\�7{"�;�C�A���rC��`5@e�;wT��sp�8pw��"��2>`�v�P"P� w�1�rj��w��`'B?����+t�z | |
��f4YI�DçM�T�-��X����"`A^��w@� | |
/�y&e�/3n?� %���:V�r�M�B'd�1���p(�+_�ڰ�y�UhBH�z�(y1��b�W�U^�(DJwu���!e��lʩ�B��u4\�Yn�Щ���a�8�O�`@�*G��B�҇�����o��P��7��E�Ϭ����C5.=�d]`�^ՙ?��������囮]������u~��o.Ϻ������jн�No�����𫯶T�\H�-�Q����p7.�D�4�9�\�<�~7��l���;��hv��)��@1��wf�Q���Q�����������^��C$a�U [���:|�A��^A��(А� |���#�/�17)Z�V�62��qmyԶ�d�>6�Bg��c��^��ϟ�����|CG~]�����_�Fw�h�!Kpř��u��.��+)ذ�����Q��a�s,� �dw��72��EnӔ 5����"�e[nu����z�7�����Z�jc#h��UA<3�p-m\3���D�K]g�:�Wg&�U�Cn�#�PNCv/�d��C^�\g��q;�ւ{�Љ��$+��P8�����Ț+!VM�&��? | |
�*n5�Кys�\WX�ۀ�T����Yq0�rn;�_��2:�.�M�C!�v:%����g6�w�����{�+øS�����P/� �o��"~]�(2;�|�P�W�m[��a���7�RS%ú��R��-��z�z�Q})�>�A�|��֧�nP3�\v����96<�y�Nb�S�|�/��(d�7�rZ��×x�['�Ъ�����T�Q�U|������⓫ˣ�)ݓI�2C��IP͕��E�Zx�{����"[�"�o����b*㨇J}X\���6�^���y~�KK��x�e�H���S�<��iB?�ݿ��D��V�o�a}dvG�vn�g��P�=�-J��������F�{+��)nuD�R�{���oO;`�� r�1*uCY B��[�|� ��q���i�{Y`7�1�������6�����7R�lj�B�ǸJ����;�/e�V{��s90��sٮF�����l���眍n���ٮ}%�D�)�VH?\% �v��K%��*�;iE(+���燱�8N��N��6��}DD'X;����`H���,�Wr7�֬v�U-�6n�(+�#C�k����n��:_Z�5��w�����FR��鬡y#i�� �6�C�-b\�ɯ���_~7�n��_�o������w��?�gÓ��b�Ͼ!���* N�q��&���B`3�dM���1|��M���g����>9���-�q���|�+켂D}�ݝN��#u��q��_�mU��d�s(s�I�Q!�*¹��>Ag��马�7��Ir��>qV�Ǡ��{zuy6\C������ʔj�8T,���_Q��f1r�biRJ��l)�g�2���7I4!t0J���^SN|�E����A�l��]J�y����/-�v�x#�)Av���9�U�s������>�Q�CqGS���MZi!��T���Sp�%Jr%R_�7A�� | |
o�����,L��A���O�T�t�ڥ��X�6�l���(�"��b� -�B� | |
찰a����̣�e��U�BcS, �� oB�?���C����7���$�}��h�$� %���¦�IC!J�J��mX/&�xtMC�?<l�<���l�/�P?���i���^��G�m���N�%nZ��h'%ܩ��I9��a�:�/\/�||�<3���w�=�4H�n �q� | |