Файл: tyde/www/note.sql
Строк: 279
-- phpMyAdmin SQL Dump
-- version 4.5.3.1
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 27,
2016 at 10:06 PM
-- Server version: 10.1.10-MariaDB-log
-- PHP Version:
7.0.2
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
utf8mb4 */;
--
-- Database: `note`
--
--
--------------------------------------------------------
--
-- Table
structure for table `codes`
--
CREATE TABLE `codes` (
`id` int(255) NOT
NULL,
`user` int(255) NOT NULL,
`time` int(50) NOT NULL,
`code`
longtext NOT NULL,
`lang` varchar(50) NOT NULL,
`comment` varchar(255)
DEFAULT NULL,
`password` varchar(256) DEFAULT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
--
-- Dumping data for table `codes`
--
INSERT INTO
`codes` (`id`, `user`, `time`, `code`, `lang`, `comment`, `password`)
VALUES
(2, 2, 1453928243, '<?php\r\ndefined(\'BASEPATH\') OR
exit(\'No direct script access allowed\');\r\n\r\n/*\r\n|
-------------------------------------------------------------------------\r\n|
URI ROUTING\r\n|
-------------------------------------------------------------------------\r\n|
This file lets you re-map URI requests to specific controller
functions.\r\n|\r\n| Typically there is a one-to-one relationship between a
URL string\r\n| and its corresponding controller class/method. The segments
in a\r\n| URL normally follow this pattern:\r\n|\r\n|
example.com/class/method/id/\r\n|\r\n| In some instances, however, you may
want to remap this relationship\r\n| so that a different class/function is
called than the one\r\n| corresponding to the URL.\r\n|\r\n| Please see the
user guide for complete details:\r\n|\r\n|
https://codeigniter.com/user_guide/general/routing.html\r\n|\r\n|
-------------------------------------------------------------------------\r\n|
RESERVED ROUTES\r\n|
-------------------------------------------------------------------------\r\n|\r\n|
There are three reserved routes:\r\n|\r\n| $route[\'default_controller\'] =
\'welcome\';\r\n|\r\n| This route indicates which controller class should
be loaded if the\r\n| URI contains no data. In the above example, the
"welcome" class\r\n| would be loaded.\r\n|\r\n|
$route[\'404_override\'] = \'errors/page_missing\';\r\n|\r\n| This route
will tell the Router which controller/method to use if those\r\n| provided
in the URL cannot be matched to a valid route.\r\n|\r\n|
$route[\'translate_uri_dashes\'] = FALSE;\r\n|\r\n| This is not exactly a
route, but allows you to automatically route\r\n| controller and method
names that contain dashes. \'-\' isn\'t a valid\r\n| class or method name
character, so it requires translation.\r\n| When you set this option to
TRUE, it will replace ALL dashes in the\r\n| controller and method URI
segments.\r\n|\r\n| Examples: my-controller/index ->
my_controller/index\r\n| my-controller/my-method ->
my_controller/my_method\r\n*/\r\n$route[\'default_controller\'] =
\'main\';\r\n$route[\'404_override\'] =
\'\';\r\n$route[\'translate_uri_dashes\'] = FALSE;\r\n$route[\'(:num)\'] =
\'code/view/$1\';\r\n', 'Plain', '', NULL),
(3, 2, 1453930538,
'shCoreEclipse.css', 'Plain', '', NULL),
(4, 2, 1453930544, '
\r\n\r\n <!-- View code {{ -->\r\n
<div class="uk-container-center
ui-margins">\r\n [removed][removed]\r\n
[removed][removed]\r\n
[removed]SyntaxHighlighter.all();[removed]\r\n\r\n <pre
class="brush: &lt;?php echo xss_clean(strtolower($lang))
?&gt;">&lt;?php echo $code;
?&gt;</pre>\r\n </div>\r\n
&lt;!-- }} View code --&gt;', 'Plain', '', NULL),
(5, 2,
1453930577, '&lt;?php \r\n echo \'lol\';\r\n?&gt;', 'Php',
'', NULL),
(6, 2, 1453930736, ' \r\n\r\n <!-- View code {{
-->\r\n <div class="uk-container-center
ui-margins">\r\n <script
type="text/javascript" src="<?php echo
base_url(\'web/js/scripts/shCore.js\') ?>"></script>\r\n
<script type="text/javascript" src="<?php
echo base_url(\'web/js/scripts/shBrush\'.$lang.\'.js\')
?>"></script>\r\n <script
type="text/javascript">SyntaxHighlighter.all();</script>\r\n\r\n
<pre class="brush: <?php echo
xss_clean(strtolower($lang)) ?>"><?php echo $code;
?></pre>\r\n </div>\r\n <!-- }} View code
-->', 'Xml', '', NULL),
(7, 2, 1453930757, ' \r\n\r\n
<!-- View code {{ -->\r\n <div
class="uk-container-center ui-margins">\r\n
<script type="text/javascript" src="<?php echo
base_url(\'web/js/scripts/shCore.js\') ?>"></script>\r\n
<script type="text/javascript" src="<?php
echo base_url(\'web/js/scripts/shBrush\'.$lang.\'.js\')
?>"></script>\r\n <script
type="text/javascript">SyntaxHighlighter.all();</script>\r\n\r\n
<pre class="brush: <?php echo
xss_clean(strtolower($lang)) ?>"><?php echo $code;
?></pre>\r\n </div>\r\n <!-- }} View code
-->', 'Plain', '', NULL),
(8, 2, 1453930818, '<?php\r\n\r\nclass Main
extends CI_Controller\r\n{\r\n public function index
()\r\n {\r\n $this->load->view(\'header\', [\'title\' =>
\'Главная
страница\']);\r\n $this->load->view(\'main/index\');\r\n $this->load->view(\'footer\');\r\n }\r\n\r\n public
function signout ()\r\n {\r\n setcookie(\'user_id\', \'\', -1,
\'/\');\r\n setcookie(\'sid\', \'\', -1,
\'/\');\r\n\r\n header(\'location: /\');\r\n }\r\n}', 'Php', '',
NULL),
(9, 2, 1453931514, '<?php\r\n\r\nclass Main extends
CI_Controller\r\n{\r\n public function index
()\r\n {\r\n $this->load->view(\'header\', [\'title\' =>
\'Главная
страница\']);\r\n $this->load->view(\'main/index\');\r\n $this->load->view(\'footer\');\r\n }\r\n\r\n public
function signout ()\r\n {\r\n setcookie(\'user_id\', \'\', -1,
\'/\');\r\n setcookie(\'sid\', \'\', -1,
\'/\');\r\n\r\n header(\'location: /\');\r\n }\r\n}', 'Php', 'Когда
рассеется туман, больше не будет никого',
NULL);
-- --------------------------------------------------------
--
--
Table structure for table `users`
--
CREATE TABLE `users` (
`id`
int(255) NOT NULL,
`login` varchar(12) NOT NULL,
`password`
varchar(256) NOT NULL,
`hash` varchar(256) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
INSERT INTO
`users` (`id`, `login`, `password`, `hash`) VALUES
(1, 'dokuro',
'552aa35f1a0e3d2f4b90686e24eff300099aa5b5',
'e8b23e7ea0c146d18588cfd50f8d6ce7');
--
-- Indexes for dumped
tables
--
--
-- Indexes for table `codes`
--
ALTER TABLE `codes`
ADD
PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE
`users`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped
tables
--
--
-- AUTO_INCREMENT for table `codes`
--
ALTER TABLE `codes`
MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
--
AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id`
int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
/*!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 */;