qHRgH3e1

1
2
3CREATE DATABASE IF NOT EXISTS `signuplogindisplayuserphp` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
4USE `signuplogindisplayuserphp`;
5
6DROP TABLE IF EXISTS `signuplogindisplayuserphp`;
7CREATE TABLE `signuplogindisplayuserphp` (
8  `id` int(11) NOT NULL,
9  `filename` varchar(200) NOT NULL,
10  `username` varchar(200) NOT NULL,
11  `uploadedtextname` varchar(255) NOT NULL
12) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
13
14INSERT INTO `signuplogindisplayuserphp` (`id`, `filename`, `username`, `uploadedtextname`) VALUES(2, 'New Text Document - Copy.txt', 'FGDFG', '');
15INSERT INTO `signuplogindisplayuserphp` (`id`, `filename`, `username`, `uploadedtextname`) VALUES(3, 'New Text Document.txt', 'FGDFG', '');
16INSERT INTO `signuplogindisplayuserphp` (`id`, `filename`, `username`, `uploadedtextname`) VALUES(4, 'New Text Document - Copy - Copy.txt', 'FGDFG', 'Copy Copy');
17INSERT INTO `signuplogindisplayuserphp` (`id`, `filename`, `username`, `uploadedtextname`) VALUES(5, 'New Text Document - Copy (2).txt', 'FGDFG', 'copy 2');
18
19DROP TABLE IF EXISTS `signuplogindisplayuserphpusers`;
20CREATE TABLE `signuplogindisplayuserphpusers` (
21  `id` int(11) NOT NULL,
22  `username` varchar(255) NOT NULL,
23  `email` varchar(255) NOT NULL,
24  `password` varchar(255) NOT NULL
25) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
26
27INSERT INTO `signuplogindisplayuserphpusers` (`id`, `username`, `email`, `password`) VALUES(0, 'FGDFG', 'fgd@gsf.com', 'DGFG');
28INSERT INTO `signuplogindisplayuserphpusers` (`id`, `username`, `email`, `password`) VALUES(0, 'rhhgh', 'fghgfhdggd@gsf.com', 'gdhgdg');
29
30
31ALTER TABLE `signuplogindisplayuserphp`
32  ADD PRIMARY KEY (`id`);
33
34ALTER TABLE `signuplogindisplayuserphpusers`
35  ADD UNIQUE KEY `username` (`username`),
36  ADD UNIQUE KEY `email` (`email`);
37
38
39ALTER TABLE `signuplogindisplayuserphp`
40  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
41
42