Oto moj plik sql:
-- phpMyAdmin SQL Dump -- version 4.1.14 -- <a href="http://www.phpmyadmin.net" target="_blank">http://www.phpmyadmin.net</a> -- -- Host: 127.0.0.1 -- Generation Time: 03 Lut 2016, 17:52 -- Server version: 5.6.17 -- PHP Version: 5.5.12 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 */; -- -- Database: `matchmaking_project` -- -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `data_user` -- CREATE TABLE IF NOT EXISTS `data_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `token_user_id` text NOT NULL, `token_push_id` text NOT NULL, `login_type` int(11) NOT NULL COMMENT '1 = Facebook , 2 = LinkedIn', `type` int(11) NOT NULL COMMENT 'Type of user(1 = Student and 2 = Company)', `company_name` varchar(255) NOT NULL COMMENT 'Only in use when type is 2', `name` varchar(255) NOT NULL, `img_id` text NOT NULL, `registration` timestamp NOT NULL, `description` text NOT NULL, `skills` varchar(150) NOT NULL, `home_town` varchar(255) NOT NULL, `age` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Zrzut danych tabeli `data_user` -- INSERT INTO `data_user` (`id`, `token_user_id`, `token_push_id`, `login_type`, `type`, `company_name`, `name`, `img_id`, `registration`, `description`, `skills`, `home_town`, `age`) VALUES (1, 'erflkfkafkldsaflkasfkldflk', 'sdlkksdlflksdkfkljdsf', 1, 2, 'Media College', 'Artur Kupczak', '', '2016-02-02 13:15:55', 'We are a company working with differen people, we are looking for a geek to make out company stronger!', '1', 'Lelystad', 19), (2, 'othertoken', 'sadasdsad', 2, 2, 'asdasd', 'asdad', 'adasdasd', '2016-02-03 14:14:16', 'asdasdasd', 'asasd', 'Lelle', 11); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `skill_type` -- CREATE TABLE IF NOT EXISTS `skill_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- Zrzut danych tabeli `skill_type` -- INSERT INTO `skill_type` (`id`, `type`) VALUES (1, 'php'), (2, 'github'), (3, 'ruby'), (4, 'python'), (5, 'c++'), (6, 'c'); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `user_match` -- CREATE TABLE IF NOT EXISTS `user_match` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_1` int(11) NOT NULL, `user_2` int(11) NOT NULL, `match` int(11) NOT NULL, `time` timestamp NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB 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 */;