-
Notifications
You must be signed in to change notification settings - Fork 1
/
sdsusite.sql
121 lines (99 loc) · 7.22 KB
/
sdsusite.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
-- phpMyAdmin SQL Dump
-- version 4.6.5.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 06, 2017 at 03:09 PM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 5.6.30
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: `sdsusite`
--
-- --------------------------------------------------------
--
-- Table structure for table `answers`
--
CREATE TABLE `answers` (
`questionid` int(11) NOT NULL,
`text` text COLLATE utf32_unicode_ci NOT NULL,
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `questions`
--
CREATE TABLE `questions` (
`id` int(11) NOT NULL,
`question` text COLLATE utf32_unicode_ci NOT NULL,
`choices` blob NOT NULL,
`date` datetime NOT NULL,
`author` varchar(50) COLLATE utf32_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
--
-- Dumping data for table `questions`
--
INSERT INTO `questions` (`id`, `question`, `choices`, `date`, `author`) VALUES
(5, 'Civil liberties are', 0x613a343a7b693a303b733a33353a226c696d69746174696f6e73206f6e20676f7665726e6d656e747320616374696f6e732e223b693a313b733a32333a2266726565646f6d73206f662065787072657373696f6e2e223b693a323b733a34333a22756e7772697474656e2067756172616e74656573206f6620696e646976696475616c206c6962657274792e223b693a333b733a33343a22636f6e6365726e65642077697468206c696d6974696e672064656d6f63726163792e223b7d, '2017-06-06 14:28:25', '1'),
(6, '"Fighting words" fall outside constitutional protection because they', 0x613a343a7b693a303b733a32353a226469726563746c7920696e636974652076696f6c656e63652e223b693a313b733a31373a226f6666656e64206c697374656e6572732e223b693a323b733a31383a22617265207361696420696e2068617374652e223b693a333b733a31383a22746172676574206d696e6f7269746965732e223b7d, '2017-06-06 14:29:43', '1'),
(7, 'Eminent domain in the power of government to ', 0x613a343a7b693a303b733a33373a2274616b6520707269766174652070726f706572747920666f72207075626c6963207573652e223b693a313b733a34353a2273656172636820696e646976696475616c26233033393b7320686f6d65207769746820612077617272616e742e223b693a323b733a33373a227265636f676e697a65206e6577207465727269746f7269657320616e64207374617465732e223b693a333b733a35343a2267756172616e74656520746f20636974697a656e20612072657075626c6963616e20666f726d206f6620676f7665726e6d656e74732e223b7d, '2017-06-06 14:34:39', '1'),
(8, 'In 2008, the U.S. Supreme Court declared that the Second Amendment protects', 0x613a343a7b693a303b733a36343a22616e20696e646976696475616c26233033393b7320726967687420746f20706f737365732061206669726561726d20666f722073656c662d646566656e73652e223b693a313b733a33333a22612073746174652070726f6869626974696f6e73206f6e206669726561726d732e223b693a323b733a33363a2267756e20636f6c6c656374696f6e7320617320707269766174652070726f70657274792e223b693a333b733a33353a22636974697a656e732070617274696369706174696f6e20696e206d696c69746961732e223b7d, '2017-06-06 14:37:01', '1'),
(9, 'The Supreme Court ruled in Lawrence v. Texas that the right to privacy', 0x613a343a7b693a303b733a33353a22657874656e6420746f2067617920616e64206c65736269616e20636974697a656e732e223b693a313b733a32343a2270726f7465637473206c6567616c2061626f7274696f6e2e223b693a323b733a32383a22646f6573206e6f7420636f76657220726967687420746f206469652e223b693a333b733a35343a226c696d6974732074686520616374696f6e73206f6620736f6369616c206e6574776f726b696e67206c696b652046616365626f6f6b2e223b7d, '2017-06-06 14:38:50', '1'),
(10, 'The Bill of Rights consist of', 0x613a343a7b693a303b733a34393a227468652066697273742074656e20616d656e646d656e7473206f662074686520552e532e20636f6e7369747574696f6e2e223b693a313b733a34393a227468652066726565646f6d73206f66207370656563682c2065787072657373696f6e2c20616e6420617373656d626c792e223b693a323b733a32353a2274686520436976696c2057617220416d656e646d656e74732e223b693a333b733a35323a22616c6c20746865207269676874732070726f74656374696f6e7320696e2074686520552e532e20636f6e737469747574696f6e2e223b7d, '2017-06-06 14:40:28', '1'),
(13, 'The right of the people "to keep and bear Arms" is based on', 0x613a343a7b693a303b733a33323a2270617274696369706174696f6e20696e207374617465206d696c69746961732e223b693a313b733a35343a22746865206e65656420666f72206665646572616c20676f7665726e6d656e7420746f2063616c6c20757020766f6c756e74656572732e223b693a323b733a36323a22746865206f75746461746564206e65656420666f72206d6f737420696e646976696475616c7320746f2068756e74207468656972206f776e20666f6f642e223b693a333b733a35323a22746865206e65656420666f7220696e646976696475616c7320746f2070726f746563742074686569722070726f70657274792e20223b7d, '2017-06-06 14:48:15', '1');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`Username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`Hashed_password` text COLLATE utf8_unicode_ci NOT NULL,
`Email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`RED_ID` varchar(9) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `Username`, `Hashed_password`, `Email`, `RED_ID`) VALUES
(2, 'Erekle', '5bad08e5d7e5704c03b48c3e5a6c42231ae249eafd006426f64c6ce00e2625751b080ec0d1f2c2dbbc27561fdb23693e8a4f147a813c688f020d5e64f00cb73a', 'erekle', '11223344'),
(3, 'Erekle', 'e54ee7e285fbb0275279143abc4c554e5314e7b417ecac83a5984a964facbaad68866a2841c3e83ddf125a2985566261c4014f9f960ec60253aebcda9513a9b4', 'erekle', '11223344'),
(4, 'asd', 'e54ee7e285fbb0275279143abc4c554e5314e7b417ecac83a5984a964facbaad68866a2841c3e83ddf125a2985566261c4014f9f960ec60253aebcda9513a9b4', 'asd', '123'),
(5, 'Erekle', 'e54ee7e285fbb0275279143abc4c554e5314e7b417ecac83a5984a964facbaad68866a2841c3e83ddf125a2985566261c4014f9f960ec60253aebcda9513a9b4', 'erekle', '11223344'),
(6, 'Erekle', '51fef8efb142cff14c3f6f2aa0dda57cd25d1e748dab38b36c8695ed9848eb38b9a2b01a2d3bf5b448a043ee75665fdd78e61630ae9077b38a050746bddd7b02', 'erekle', '11223344'),
(7, 'asdf', '401b09eab3c013d4ca54922bb802bec8fd5318192b0a75f201d8b3727429080fb337591abd3e44453b954555b7a0812e1081c39b740293f765eae731f5a65ed1', 'asdf', '1234'),
(8, 'Ekaterine', '3a369eaa493f5e5a9aa0d6d97852bc0d10fa8b62f515c42552c1440e4b6c723599ff6bd933c02689b9da22119e26ef71840e562aa16bc6f43444a1bbb207edcf', 'ekaterinekvaghinidze@gmail.com', '820944547');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `questions`
--
ALTER TABLE `questions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
/*!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 */;