· 9 years ago · Nov 01, 2016, 12:58 PM
1
2--
3-- Database: `dbidref`
4--
5
6-- --------------------------------------------------------
7
8--
9-- Table structure for table `people`
10--
11
12CREATE TABLE IF NOT EXISTS `people` (
13 `id` int(11) NOT NULL AUTO_INCREMENT,
14 `username` varchar(255) NOT NULL,
15 `email` varchar(255) NOT NULL,
16 `password` text NOT NULL,
17 PRIMARY KEY (`id`),
18 UNIQUE KEY `username` (`username`,`email`)
19) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=383 ;
20
21--
22-- Dumping data for table `people`
23--
24
25INSERT INTO `people` (`id`, `username`, `email`, `password`) VALUES
26(1, 'user1', 'user1@example.com', 'moqta_parola'),
27(382, 'admin', 'admin@example.com', 'tainata_parola_na_admina');
28
29
30
31
32--
33-- Database: `xss_user`
34--
35
36-- --------------------------------------------------------
37
38--
39-- Table structure for table `comments`
40--
41
42CREATE TABLE IF NOT EXISTS `comments` (
43 `id` int(11) NOT NULL AUTO_INCREMENT,
44 `author` varchar(255) NOT NULL,
45 `message` text NOT NULL,
46 PRIMARY KEY (`id`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
48
49--
50-- Dumping data for table `comments`
51--
52
53INSERT INTO `comments` (`id`, `author`, `message`) VALUES
54(1, 'asd', 'asd');