gS7FHe5k

1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 29, 2016 at 03:47 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `web_portfolio`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `icons`
27--
28
29CREATE TABLE IF NOT EXISTS `icons` (
30  `icon_category` tinyint(4) NOT NULL,
31  `icon_name` varchar(255) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33
34-- --------------------------------------------------------
35
36--
37-- Table structure for table `profile`
38--
39
40CREATE TABLE IF NOT EXISTS `profile` (
41  `profile_education` varchar(255) NOT NULL,
42  `profile_specialty` varchar(255) NOT NULL COMMENT ' ',
43  `profile_college` varchar(255) NOT NULL COMMENT 'College or school',
44  `profile_por` varchar(255) NOT NULL COMMENT 'Place of residency, where owner of profile lives',
45  `profile_about` text NOT NULL COMMENT 'Some context of the profile'
46) ENGINE=InnoDB DEFAULT CHARSET=latin1;
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `texts`
52--
53
54CREATE TABLE IF NOT EXISTS `texts` (
55  `text_website_title` varchar(255) NOT NULL COMMENT 'Text displayed as the title of the website',
56  `text_slide1_title` varchar(255) NOT NULL COMMENT 'Title of slide 1',
57  `text_slide2_title` varchar(255) NOT NULL COMMENT 'Title of slide 2',
58  `text_slide3_title` varchar(255) NOT NULL COMMENT 'Title of slide 3',
59  `text_slide1_caption` varchar(255) NOT NULL COMMENT 'Caption of slide 1',
60  `text_slide2_caption` varchar(255) NOT NULL COMMENT 'Caption of slide 2',
61  `text_slide3_caption` varchar(255) NOT NULL COMMENT 'Caption of slide 3',
62  `text_card1_title` varchar(255) NOT NULL COMMENT 'Title of card 1',
63  `text_card2_title` varchar(255) NOT NULL COMMENT 'Title of card 2',
64  `text_card3_title` varchar(255) NOT NULL COMMENT 'Title of card 3',
65  `text_card1_caption` varchar(255) NOT NULL COMMENT 'Caption of card 1',
66  `text_card2_caption` varchar(255) NOT NULL COMMENT 'Caption of card 2'
67) ENGINE=InnoDB DEFAULT CHARSET=latin1;
68
69--
70-- Dumping data for table `texts`
71--
72
73INSERT INTO `texts` (`text_website_title`, `text_slide1_title`, `text_slide2_title`, `text_slide3_title`, `text_slide1_caption`, `text_slide2_caption`, `text_slide3_caption`, `text_card1_title`, `text_card2_title`, `text_card3_title`, `text_card1_caption`, `text_card2_caption`) VALUES
74('Portfolio - Dirk Verkoelen', 'Welkom', 'Hier vindt u', 'En kunt u', 'Op het portfolio van Dirk Verkoelen', 'Informatie over mij en mijn projecten', 'Contact opnemen met mij', 'Over mij', 'Projecten', 'Contact opnemen', '', '');
75
76-- --------------------------------------------------------
77
78--
79-- Table structure for table `users`
80--
81
82CREATE TABLE IF NOT EXISTS `users` (
83  `user_name` varchar(255) NOT NULL COMMENT 'The user name, used to log in with',
84  `user_password` varchar(255) NOT NULL COMMENT 'The user''s encrypted password, used to log in with'
85) ENGINE=InnoDB DEFAULT CHARSET=latin1;
86
87--
88-- Dumping data for table `users`
89--
90
91INSERT INTO `users` (`user_name`, `user_password`) VALUES
92('dirk', 'dirk');
93
94/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
95/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
96/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;