-- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 20, 2011 at 06:43 PM -- Server version: 5.1.36 -- PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 */; -- -- Database: `ci_notes` -- -- -------------------------------------------------------- -- -- Table structure for table `ci_sessions` -- DROP TABLE IF EXISTS `ci_sessions`; CREATE TABLE IF NOT EXISTS `ci_sessions` ( `session_id` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '0', `ip_address` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '0', `user_agent` varchar(150) 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; -- -- Dumping data for table `ci_sessions` -- INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('a4bea248e8be77141cdd4189dc85b296', '127.0.0.1', 'Opera/9.80 (Windows NT 6.1; U; en) Presto/2.7.62 V', 1298213427, ''), ('bebbfa6a18dbdff05b7fdded3e3667fa', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) Ap', 1298218713, 'a:3:{s:7:"user_id";s:1:"1";s:8:"username";s:0:"";s:6:"status";s:1:"1";}'); -- -------------------------------------------------------- -- -- Table structure for table `login_attempts` -- DROP TABLE IF EXISTS `login_attempts`; CREATE TABLE IF NOT EXISTS `login_attempts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip_address` varchar(40) COLLATE utf8_bin NOT NULL, `login` varchar(50) COLLATE utf8_bin NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=13 ; -- -- Dumping data for table `login_attempts` -- INSERT INTO `login_attempts` (`id`, `ip_address`, `login`, `time`) VALUES (7, '127.0.0.1', 'safdsaf', '2011-02-20 02:31:45'), (8, '127.0.0.1', 'safdsaf', '2011-02-20 02:32:02'), (9, '127.0.0.1', 'safdsaf', '2011-02-20 02:32:03'), (11, '127.0.0.1', 'dsfdsafd', '2011-02-20 16:07:05'), (12, '127.0.0.1', 'sdaf', '2011-02-20 16:34:57'); -- -------------------------------------------------------- -- -- Table structure for table `notes` -- DROP TABLE IF EXISTS `notes`; CREATE TABLE IF NOT EXISTS `notes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `text` text NOT NULL, `time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ; -- -- Dumping data for table `notes` -- INSERT INTO `notes` (`id`, `user_id`, `text`, `time`) VALUES (35, 0, 'It’s a mechanical bull at number one\nYou’ll take a ride from anyone\nEveryone wants a ride\nPulls away, ooh\nFrom you', '2010-12-11 01:00:48'), (36, 0, 'I’ll send you my love on a wire\nLift you up every time\nEveryone, ooh\nPulls away, ooh', '2010-12-11 01:00:56'), (37, 0, 'Got balls of steel\nGot an automobile for a minimum wage\nGot real estate, I’m buying it all up in outer space\nNow that the truth is just a rule that you can bend\nYou crack the whip\nShape-shift and trick\nThe past again', '2010-12-11 01:01:01'), (38, 0, 'I’ll send you my love on a wire\nLight you up every time\nEveryone, ooh\nPulls away, ooh\nFrom you', '2010-12-11 01:01:06'), (39, 0, 'Hello again, friend of a friend\nI knew you when\nOur common goal was waiting for the world to end\nNow that the truth is just a rule that you can bend\nYou crack the whip\nShape-shift and trick\nThe past again', '2010-12-11 01:01:10'), (40, 0, 'Black sheep, come home\nBlack sheep, come home\nBlack sheep, come home', '2010-12-11 01:01:15'), (41, 0, 'awesome stuff', '2010-12-11 16:22:55'), (51, 0, 'hahahahhaAHAAHHAAHAHAAAAAAA', '2010-12-29 15:08:21'), (45, 0, 'bla bla bla dris''t bla', '2010-12-28 17:15:17'), (55, 0, 'reactor POWAH!', '2011-02-07 13:36:01'), (57, 1, 'uhuhuhuuuuuu', '2011-02-20 17:15:26'), (58, 5, 'HELLO!!!!', '2011-02-20 17:18:30'), (59, 1, 'nevidim hello :(', '2011-02-20 17:18:42'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) COLLATE utf8_bin NOT NULL, `password` varchar(255) COLLATE utf8_bin NOT NULL, `email` varchar(100) COLLATE utf8_bin NOT NULL, `activated` tinyint(1) NOT NULL DEFAULT '1', `banned` tinyint(1) NOT NULL DEFAULT '0', `ban_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL, `new_password_key` varchar(50) COLLATE utf8_bin DEFAULT NULL, `new_password_requested` datetime DEFAULT NULL, `new_email` varchar(100) COLLATE utf8_bin DEFAULT NULL, `new_email_key` varchar(50) COLLATE utf8_bin DEFAULT NULL, `last_ip` varchar(40) COLLATE utf8_bin NOT NULL, `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=14 ; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `password`, `email`, `activated`, `banned`, `ban_reason`, `new_password_key`, `new_password_requested`, `new_email`, `new_email_key`, `last_ip`, `last_login`, `created`, `modified`) VALUES (1, '', '$2a$08$W3b42bCJpvTFtR8qwhKN1ukY9.12i/KUg9VDt9YpQEJ/zCjhHLADW', 'yablko@brm.sk', 1, 0, NULL, NULL, NULL, NULL, NULL, '127.0.0.1', '2011-02-20 16:18:36', '2011-02-20 14:49:25', '2011-02-20 17:18:36'), (5, '', '$2a$08$CDNf57XxoRqiRsu5sI0gAu.K/Jozu0GkeUwOVv3Q.o627ef1kb1ne', 'bill@cosby.com', 1, 0, NULL, NULL, NULL, NULL, NULL, '127.0.0.1', '2011-02-20 16:18:16', '2010-12-17 19:14:34', '2011-02-20 17:18:16'); -- -------------------------------------------------------- -- -- Table structure for table `user_autologin` -- DROP TABLE IF EXISTS `user_autologin`; CREATE TABLE IF NOT EXISTS `user_autologin` ( `key_id` char(32) COLLATE utf8_bin NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `user_agent` varchar(150) COLLATE utf8_bin NOT NULL, `last_ip` varchar(40) COLLATE utf8_bin NOT NULL, `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`key_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `user_autologin` -- INSERT INTO `user_autologin` (`key_id`, `user_id`, `user_agent`, `last_ip`, `last_login`) VALUES ('0d70e930345eff86bb497c07e36cf926', 1, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.13 (KHTML, like Gecko) Chrome/9.0.597.98 Safari/534.13', '127.0.0.1', '2011-02-20 17:18:36'); -- -------------------------------------------------------- -- -- Table structure for table `user_profiles` -- DROP TABLE IF EXISTS `user_profiles`; CREATE TABLE IF NOT EXISTS `user_profiles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `roles` enum('admin','moderator','user') COLLATE utf8_bin NOT NULL DEFAULT 'user', `meno` varchar(255) COLLATE utf8_bin DEFAULT NULL, `priezvisko` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=20 ; -- -- Dumping data for table `user_profiles` -- INSERT INTO `user_profiles` (`id`, `user_id`, `roles`, `meno`, `priezvisko`) VALUES (11, 5, 'user', 'Bill', 'Cosby'), (19, 1, 'admin', 'Roman', 'Hraška');