· 9 years ago · Dec 02, 2016, 08:18 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.10
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Dec 02, 2016 at 09:16 PM
7-- Server version: 5.5.42
8-- PHP Version: 5.6.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `main`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `notification`
21--
22
23DROP TABLE IF EXISTS `notification`;
24CREATE TABLE `notification` (
25 `id` int(11) NOT NULL,
26 `notificationTypeId` int(10) unsigned NOT NULL,
27 `questionId` int(11) NOT NULL DEFAULT '0',
28 `answerId` int(11) NOT NULL DEFAULT '0',
29 `reactionId` int(11) unsigned NOT NULL,
30 `replyId` int(11) unsigned NOT NULL,
31 `userId` int(10) unsigned NOT NULL,
32 `askedBy` int(11) NOT NULL,
33 `status` int(11) DEFAULT '0',
34 `dateCreated` datetime DEFAULT NULL
35) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
36
37--
38-- Dumping data for table `notification`
39--
40
41INSERT INTO `notification` (`id`, `notificationTypeId`, `questionId`, `answerId`, `reactionId`, `replyId`, `userId`, `askedBy`, `status`, `dateCreated`) VALUES
42(4, 1, 1, 1, 0, 0, 1, 0, 0, '2016-12-02 16:02:00'),
43(5, 2, 1, 1, 1, 0, 1, 0, 0, '2016-12-14 00:00:00'),
44(6, 3, 1, 0, 1, 1, 1, 0, 0, '2016-12-28 00:00:00'),
45(7, 4, 1, 0, 0, 0, 1, 2, 0, '2016-12-20 00:00:00'),
46(8, 5, 0, 1, 0, 0, 1, 0, 0, '2016-12-13 00:00:00'),
47(9, 6, 0, 0, 1, 0, 1, 0, 0, '2016-12-11 00:00:00'),
48(10, 7, 1, 0, 0, 0, 1, 0, 0, '2016-12-25 00:00:00'),
49(11, 8, 0, 0, 0, 1, 1, 0, 0, '2016-12-04 00:00:00');
50
51-- --------------------------------------------------------
52
53--
54-- Table structure for table `notificationType`
55--
56
57DROP TABLE IF EXISTS `notificationType`;
58CREATE TABLE `notificationType` (
59 `id` int(10) unsigned NOT NULL,
60 `key` varchar(25) NOT NULL,
61 `value` varchar(255) NOT NULL
62) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
63
64--
65-- Dumping data for table `notificationType`
66--
67
68INSERT INTO `notificationType` (`id`, `key`, `value`) VALUES
69(1, 'newAnswer', 'heeft uw vraag beantwoord.'),
70(2, 'newCommentAnswer', 'heeft gereageerd op uw antwoord.'),
71(3, 'newReplyComment', 'heeft gereageerd op uw reactie.'),
72(4, 'newRequest', 'heeft u gevraagd om een vraag te beantwoorden.'),
73(5, 'deletedAnswer', 'Uw antwoord is door de community verwijderd.'),
74(6, 'deletedComment', 'Uw reactie is door de community verwijderd.'),
75(7, 'deletedQuestion', 'Uw vraag is door de community verwijderd.'),
76(8, 'deletedReply', 'Uw reactie is door de community verwijderd.');
77
78--
79-- Indexes for dumped tables
80--
81
82--
83-- Indexes for table `notification`
84--
85ALTER TABLE `notification`
86 ADD PRIMARY KEY (`id`),
87 ADD KEY `fk_notification1_idx` (`notificationTypeId`),
88 ADD KEY `fk_notification2_idx` (`userId`),
89 ADD KEY `fk_notification3_idx` (`questionId`),
90 ADD KEY `fk_notification4_idx` (`answerId`);
91
92--
93-- Indexes for table `notificationType`
94--
95ALTER TABLE `notificationType`
96 ADD PRIMARY KEY (`id`);
97
98--
99-- AUTO_INCREMENT for dumped tables
100--
101
102--
103-- AUTO_INCREMENT for table `notification`
104--
105ALTER TABLE `notification`
106 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
107--
108-- AUTO_INCREMENT for table `notificationType`
109--
110ALTER TABLE `notificationType`
111 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;