· 6 years ago · Apr 02, 2019, 04:36 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 02, 2019 at 06:29 PM
7-- Server version: 5.7.19-log
8-- PHP Version: 5.6.3
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: `mailserver`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `encrypted`
27--
28
29CREATE TABLE IF NOT EXISTS `encrypted` (
30`idencrypted` int(11) NOT NULL,
31 `emap` varchar(1000) DEFAULT NULL,
32 `idfilemap` varchar(1000) DEFAULT NULL,
33 `fileidmap` longblob,
34 `token` longblob
35) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
36
37--
38-- Dumping data for table `encrypted`
39--
40
41INSERT INTO `encrypted` (`idencrypted`, `emap`, `idfilemap`, `fileidmap`, `token`) VALUES
42(1, NULL, '{1=This is the contetnt to be encrypted bro ! , 2=awais}', NULL, NULL),
43(2, '{\0½\0˜\0ÂŒ=1, \0Ã\0¢\0ÂŒ=1, \0Ä\0¦\0ÂŒ=1, \0¼\0ª\0¼\0„\0†\0b=2, \0¾\0¢\0É\0Â\0x\0Â¥\0‘\0—\0ÂŽ=1, \0½\0Â¥\0Ê\0L=1, \0Ã\0›\0À\0L=1, \0|\0d=1, \0À\0¡\0¾\0Â\0ÂŒ\0¡\0—\0ˆ\0Ã\0U=1, \0¯\0›\0Ä\0ÂŽ\0D=1}', '{1=This is the contetnt to be encrypted bro ! , 2=awais}', NULL, NULL);
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `login_info`
49--
50
51CREATE TABLE IF NOT EXISTS `login_info` (
52`userId` int(11) NOT NULL,
53 `username` varchar(45) DEFAULT NULL,
54 `password` varchar(45) DEFAULT NULL,
55 `Name` varchar(45) DEFAULT NULL,
56 `email` varchar(45) DEFAULT NULL
57) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
58
59--
60-- Dumping data for table `login_info`
61--
62
63INSERT INTO `login_info` (`userId`, `username`, `password`, `Name`, `email`) VALUES
64(1, 'Awais003', 'Awais12345', 'Awais Arshad', 'awais@sebps.com'),
65(2, 'Admin', 'Admin12345', 'Administrator', 'admin@sebps.com'),
66(3, 'Hamza', 'Hamza12345', 'Hamza Arshad', 'hamza@sebps.com'),
67(4, 'AbdullahBro', 'Abdullah12345', 'Abdullah Bro', 'abdullah@sebps.com'),
68(29, 'Furc', 'Furc12345', 'Furc Rawalpindi', 'furc@sebps.com');
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `mail_content`
74--
75
76CREATE TABLE IF NOT EXISTS `mail_content` (
77`mail_id` int(11) NOT NULL,
78 `title` varchar(450) DEFAULT NULL,
79 `mail_content` varchar(4500) DEFAULT NULL,
80 `mail_attachment` varchar(450) DEFAULT NULL,
81 `reciver_id` int(11) DEFAULT NULL,
82 `sender_id` int(11) DEFAULT NULL,
83 `date` varchar(45) DEFAULT NULL
84) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;
85
86--
87-- Dumping data for table `mail_content`
88--
89
90INSERT INTO `mail_content` (`mail_id`, `title`, `mail_content`, `mail_attachment`, `reciver_id`, `sender_id`, `date`) VALUES
91(25, 'testing', '„ Ê À ® i  ¹ 3 ¢ | ª › ¤ * © — › ¶ '' œ ~ ® { k ˆ ^ Š l © m \\ ª ¤ ¯ ¬ ž £ «    M ‡ i ¼ Ó \\ ’ w  ¬ D j ¹ t i { › ƒ ! ', NULL, 3, 1, '03:25 PM'),
92(26, 'testing', 'x Ç Ã § ¸ y § u ¢ | © š Œ r e b G É o   a n  k Å « ‘ » º t  ³ ª l Ÿ ’ ”  „ ?  • t u s É ¯ N x ž ´ ’ k j u ® p  . u Ê j ¦ Ä ’ ] ', NULL, 4, 2, '03:37 PM'),
93(27, 'THis is subject', 'x Ç Ã § ¸ y f ? ^ { ¥ — ž s ¸ V Œ  h  ‰ a n :  ½ ¬ • l ¼ o \\ ¸ › º ® E ¬ ¦  ? W M Œ p È € ³ — ‚ ¥ k † i j f ¸ k š u !  ¼ Ž É = ', NULL, 1, 1, '03:46 PM'),
94(28, 'Come to office', 'x Ç Ã § ¸ y º { § z ] — ž * ² › š È h › ‚ a k Œ º É ^ A  ¿ a ¥ ¸ V µ Z †  W  ˆ • ™ | o º € °  6 œ º ’ x « e ½ " ¥ } v { «  Ä ’ ± * » | e « x t µ ¤ j Ò Î E 9 ; µ u „ § ž ¢ 1 Ì n Î y •  Æ '' ˆ Ç ƒ µ ~ ]  § t Ö µ à p h © ¿ 7 ‘  ¸ ˜ | • ® ¾ | ', NULL, 29, 1, '03:49 PM'),
95(29, 'Greetings Bro', 'q Ñ ¸ [ ‹ Ë µ ‡ ¦ l ¯ N W *  ¥ ž u h ¦ ‚ a ~ ‰ À | § A l © m \\ « Ÿ º Ÿ E a W ', NULL, 3, 1, '03:50 PM'),
96(30, 'This is my subject', '„ Ê À ® i  ¹ 3 « € ] ›  } ¸ — Ž º '' b = © j † · Ë ^ ˜ ´ © t \\ ¦ ¨ ± Z ž ¢ ¬ 8 ƒ ˜ –  h s Ÿ \\ ', NULL, 29, 1, '12:25 AM'),
97(31, 'This is my subject', '„ Ê À ® i  ¹ 3 « € ] ›  } ¸ — Ž º '' b = © j † · Ë ^ ˜ ´ © t \\ ¦ ¨ ± Z ž ¢ ¬ 8 ƒ ˜ –  h s Ÿ \\ ', NULL, 29, 1, '12:27 AM'),
98(32, 'Come to my office', '˜ Ç Ã ª i … f v  t ¢ N Ÿ y e £  u v š ƒ ª h k Å ² ” l ½ r £ ª ¤ À Z S S ° ‡ ” I • t w ¸ € n b 6 ¡ º ™ v ½ " ½ q L „ j Î ³ ¡ u Š ¶ * ½ r «  | t ± Q ', NULL, 1, 29, '12:30 AM'),
99(33, 'Come to my office', '˜ Ç Ã ª i … f v  t ¢ N Ÿ y e £  u v š ƒ ª h k Å ² ” l ½ r £ ª ¤ À Z S S ° ‡ ” I • t w ¸ € n b 6 ¡ º ™ v ½ " ½ q L „ j Î ³ ¡ u Š ¶ * ½ r «  | t ± Q ', NULL, 1, 29, '12:33 AM'),
100(34, 'Come to my office', '˜ Ç Ã ª i … f v  t ¢ N Ÿ y e £  u v š ƒ ª h k Å ² ” l ½ r £ ª ¤ À Z S S ° ‡ ” I • t w ¸ € n b 6 ¡ º ™ v ½ " ½ q L „ j Î ³ ¡ u Š ¶ * ½ r «  | t ± Q ', NULL, 1, 29, '12:33 AM'),
101(35, 'Come to my office', '˜ Ç Ã ª i … f v  t ¢ N Ÿ y e £  u v š ƒ ª h k Å ² ” l ½ r £ ª ¤ À Z S S ° ‡ ” I • t w ¸ € n b 6 ¡ º ™ v ½ " ½ q L „ j Î ³ ¡ u Š ¶ * ½ r «  | t ± Q ', NULL, 1, 29, '12:34 AM'),
102(36, 'Holiday News', 'x Û w g i  f Š  | © ’ K | ª — “ à € T ‰ ° { k à  A µ ¶ f « · £ l ³ ” ¨ W y  ˜ ¢ ‡ ! Ç È ¡ N ~ ¨ ·  h « { ¼ " ', NULL, 1, 1, '01:22 AM'),
103(37, 'fake news', '¤ Ê À ® i  ¹ 3 « € ] ¢  } ¹ V ‰ Ç v T K ', NULL, 1, 1, '01:29 AM'),
104(38, 'fake news', '¤ Ê À ® i  ¹ 3 « € ] ¢  } ¹ V ‰ Ç v T K ', NULL, 1, 1, '01:35 AM'),
105(39, 'fake news', '¤ Ê À ® i  ¹ 3 « € ] ¢  } ¹ V ‰ Ç v T K ', NULL, 1, 1, '01:38 AM'),
106(40, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '01:42 AM'),
107(41, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '01:47 AM'),
108(42, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '01:51 AM'),
109(43, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '01:54 AM'),
110(44, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:01 AM'),
111(45, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:06 AM'),
112(46, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:10 AM'),
113(47, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:11 AM'),
114(48, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:18 AM'),
115(49, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:20 AM'),
116(50, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:29 AM'),
117(51, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:30 AM'),
118(52, 'Testing enc', '¤ Ê À ® i  ¹ 3 « € ] “ ž } ¦  ™ u z ™ ‹ µ % Ž k Ë · A » ½ a ¯ ª œ ¶ › ˜ › › 8 Š Š — † e » € ¢ ¡ ', NULL, 1, 1, '02:31 AM'),
119(53, 'Come to my office', 'x Ç Ã § ¸ y r 3 § '' ž › K  ´ ¤ ‹ º y  ‹ ¨ % “ º Ñ ^ „  ¶ Ÿ ´ £ ± Z ™ ¢ W … ˜ I œ y g ¼ à ¡ N D g k R r ¶ c i d š z b { ', NULL, 3, 1, '10:00 AM'),
120(54, 'Come to my office', 'x Ç Ã § ¸ y r 3 § '' ž › K  ´ ¤ ‹ º y  ‹ ¨ % “ º Ñ ^ „  ¶ Ÿ ´ £ ± Z ™ ¢ W … ˜ I œ y g ¼ à ¡ N D g k R r ¶ c i d š z b { ', NULL, 3, 1, '10:01 AM'),
121(55, 'Come to my office', 'x Ç Ã § ¸ y r 3 § '' ž › K  ´ ¤ ‹ º y  ‹ ¨ % “ º Ñ ^ „  ¶ Ÿ ´ £ ± Z ™ ¢ W … ˜ I œ y g ¼ à ¡ N D g k R r ¶ c i d š z b { ', NULL, 3, 1, '10:01 AM'),
122(56, 'fake news', 'x Ç Ã § ¸ y ¯ 3 Ÿ t ] –  | ª V › Ä '' — Œ ¯ y { ® à ^ š » ½ j s V z Z ', NULL, 29, 1, '10:40 AM'),
123(57, 'test', '¤ Ê À ® i  ¹ 3 ² € ¢ ¦ Ÿ * ¦ © ‹ » q •  ¥ q € ¶ | Ÿ ” ¶ ® ', NULL, 1, 1, '12:17 PM');
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `security`
129--
130
131CREATE TABLE IF NOT EXISTS `security` (
132`id` int(11) NOT NULL,
133 `key` longblob,
134 `emap` longblob
135) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
136
137--
138-- Dumping data for table `security`
139--
140
141INSERT INTO `security` (`id`, `key`, `emap`) VALUES
142(1, 0x746573742e4b657947656e403338376337303362, NULL),
143(2, 0x746573742e4b657947656e403830353033, NULL),
144(3, 0x746573742e4b657947656e403830353033, NULL),
145(4, 0x746573742e4b657947656e403830353033, NULL),
146(5, 0x746573742e4b657947656e403830353033, NULL),
147(6, 0x746573742e4b657947656e403830353033, NULL),
148(7, 0x746573742e4b657947656e403830353033, NULL),
149(8, 0x5b42403531653261646337, NULL),
150(9, 0x5b42403531653261646337, NULL),
151(10, 0x5b42403531653261646337, NULL),
152(11, 0x5b42403531653261646337, NULL),
153(12, 0x5b42403531653261646337, NULL),
154(13, 0x5b42403531653261646337, NULL),
155(14, 0x5b42403531653261646337, NULL),
156(15, 0x5b42403531653261646337, NULL),
157(16, 0x5b42403531653261646337, NULL),
158(17, 0x5b42403531653261646337, NULL),
159(18, 0x5b42403365636637326664, NULL),
160(19, 0x5b42403365636637326664, NULL),
161(20, 0x5b42403365636637326664, NULL),
162(21, 0x5b2d38342c202d31392c20302c20352c203131352c203131342c20302c2031312c203131362c203130312c203131352c203131362c2034362c2037352c203130312c203132312c2037312c203130312c203131302c20302c20302c20302c20302c20302c20302c20302c20312c20322c20302c20322c2037362c20302c20342c203130372c203130312c203132312c2034392c203131362c20302c2032342c2037362c203130362c2039372c203131382c2039372c203132302c2034372c2039392c203131342c203132312c203131322c203131362c203131312c2034372c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2035392c2037362c20302c20342c203130372c203130312c203132312c2035302c203131332c20302c203132362c20302c20312c203132302c203131322c203131352c203131342c20302c2033312c203130362c2039372c203131382c2039372c203132302c2034362c2039392c203131342c203132312c203131322c203131362c203131312c2034362c203131352c203131322c203130312c2039392c2034362c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2038332c203131322c203130312c2039392c2039312c2037312c2031312c203130322c202d33302c2034382c2039372c2037372c20322c20302c20322c2037362c20302c20392c2039372c203130382c203130332c203131312c203131342c203130352c203131362c203130342c203130392c203131362c20302c2031382c2037362c203130362c2039372c203131382c2039372c2034372c203130382c2039372c203131302c203130332c2034372c2038332c203131362c203131342c203130352c203131302c203130332c2035392c2039312c20302c20332c203130372c203130312c203132312c203131362c20302c20322c2039312c2036362c203132302c203131322c203131362c20302c20332c2036352c2036392c2038332c203131372c203131342c20302c20322c2039312c2036362c202d38342c202d31332c2032332c202d382c20362c20382c2038342c202d33322c20322c20302c20302c203132302c203131322c20302c20302c20302c2031362c202d3130302c203130302c203132342c2031392c202d3131362c202d39312c2039312c2031322c202d32312c202d31302c203131392c202d3130312c2037342c202d33352c20302c2039332c203131352c203131332c20302c203132362c20302c20332c203131332c20302c203132362c20302c20372c203131372c203131332c20302c203132362c20302c20382c20302c20302c20302c2031362c203130332c202d34312c2033392c2036302c203130372c202d3131342c202d35342c2038332c2038352c202d32352c2035322c2035312c202d342c2033332c2039312c2037345d, NULL),
163(22, 0x5b2d38342c202d31392c20302c20352c203131352c203131342c20302c2031312c203131362c203130312c203131352c203131362c2034362c2037352c203130312c203132312c2037312c203130312c203131302c20302c20302c20302c20302c20302c20302c20302c20312c20322c20302c20322c2037362c20302c20342c203130372c203130312c203132312c2034392c203131362c20302c2032342c2037362c203130362c2039372c203131382c2039372c203132302c2034372c2039392c203131342c203132312c203131322c203131362c203131312c2034372c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2035392c2037362c20302c20342c203130372c203130312c203132312c2035302c203131332c20302c203132362c20302c20312c203132302c203131322c203131352c203131342c20302c2033312c203130362c2039372c203131382c2039372c203132302c2034362c2039392c203131342c203132312c203131322c203131362c203131312c2034362c203131352c203131322c203130312c2039392c2034362c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2038332c203131322c203130312c2039392c2039312c2037312c2031312c203130322c202d33302c2034382c2039372c2037372c20322c20302c20322c2037362c20302c20392c2039372c203130382c203130332c203131312c203131342c203130352c203131362c203130342c203130392c203131362c20302c2031382c2037362c203130362c2039372c203131382c2039372c2034372c203130382c2039372c203131302c203130332c2034372c2038332c203131362c203131342c203130352c203131302c203130332c2035392c2039312c20302c20332c203130372c203130312c203132312c203131362c20302c20322c2039312c2036362c203132302c203131322c203131362c20302c20332c2036352c2036392c2038332c203131372c203131342c20302c20322c2039312c2036362c202d38342c202d31332c2032332c202d382c20362c20382c2038342c202d33322c20322c20302c20302c203132302c203131322c20302c20302c20302c2031362c2038352c202d3131372c202d36372c202d34342c202d33302c203132322c203132322c202d35352c202d3130392c202d36312c2039372c203131322c203130342c20362c202d332c2034322c203131352c203131332c20302c203132362c20302c20332c203131332c20302c203132362c20302c20372c203131372c203131332c20302c203132362c20302c20382c20302c20302c20302c2031362c2032352c202d3132322c2035382c2039382c2036352c202d34302c2032332c2032392c2035372c202d37392c2037312c202d31302c2034352c202d36362c202d382c2031355d, NULL),
164(23, 0x5b2d38342c202d31392c20302c20352c203131352c203131342c20302c2031312c203131362c203130312c203131352c203131362c2034362c2037352c203130312c203132312c2037312c203130312c203131302c20302c20302c20302c20302c20302c20302c20302c20312c20322c20302c20322c2037362c20302c20342c203130372c203130312c203132312c2034392c203131362c20302c2032342c2037362c203130362c2039372c203131382c2039372c203132302c2034372c2039392c203131342c203132312c203131322c203131362c203131312c2034372c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2035392c2037362c20302c20342c203130372c203130312c203132312c2035302c203131332c20302c203132362c20302c20312c203132302c203131322c203131352c203131342c20302c2033312c203130362c2039372c203131382c2039372c203132302c2034362c2039392c203131342c203132312c203131322c203131362c203131312c2034362c203131352c203131322c203130312c2039392c2034362c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2038332c203131322c203130312c2039392c2039312c2037312c2031312c203130322c202d33302c2034382c2039372c2037372c20322c20302c20322c2037362c20302c20392c2039372c203130382c203130332c203131312c203131342c203130352c203131362c203130342c203130392c203131362c20302c2031382c2037362c203130362c2039372c203131382c2039372c2034372c203130382c2039372c203131302c203130332c2034372c2038332c203131362c203131342c203130352c203131302c203130332c2035392c2039312c20302c20332c203130372c203130312c203132312c203131362c20302c20322c2039312c2036362c203132302c203131322c203131362c20302c20332c2036352c2036392c2038332c203131372c203131342c20302c20322c2039312c2036362c202d38342c202d31332c2032332c202d382c20362c20382c2038342c202d33322c20322c20302c20302c203132302c203131322c20302c20302c20302c2031362c202d37362c202d31342c2035342c202d33322c2032352c2033382c2039372c2039392c203131322c202d37362c202d37302c2036382c202d35322c202d36322c20312c202d38332c203131352c203131332c20302c203132362c20302c20332c203131332c20302c203132362c20302c20372c203131372c203131332c20302c203132362c20302c20382c20302c20302c20302c2031362c202d38332c2035382c202d32322c2036362c2032312c203130322c202d34342c202d3130342c2038302c202d34352c2035372c202d37332c2033362c202d3130302c2031312c202d3130325d, NULL),
165(24, 0x5b2d38342c202d31392c20302c20352c203131352c203131342c20302c2031312c203131362c203130312c203131352c203131362c2034362c2037352c203130312c203132312c2037312c203130312c203131302c20302c20302c20302c20302c20302c20302c20302c20312c20322c20302c20322c2037362c20302c20342c203130372c203130312c203132312c2034392c203131362c20302c2032342c2037362c203130362c2039372c203131382c2039372c203132302c2034372c2039392c203131342c203132312c203131322c203131362c203131312c2034372c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2035392c2037362c20302c20342c203130372c203130312c203132312c2035302c203131332c20302c203132362c20302c20312c203132302c203131322c203131352c203131342c20302c2033312c203130362c2039372c203131382c2039372c203132302c2034362c2039392c203131342c203132312c203131322c203131362c203131312c2034362c203131352c203131322c203130312c2039392c2034362c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2038332c203131322c203130312c2039392c2039312c2037312c2031312c203130322c202d33302c2034382c2039372c2037372c20322c20302c20322c2037362c20302c20392c2039372c203130382c203130332c203131312c203131342c203130352c203131362c203130342c203130392c203131362c20302c2031382c2037362c203130362c2039372c203131382c2039372c2034372c203130382c2039372c203131302c203130332c2034372c2038332c203131362c203131342c203130352c203131302c203130332c2035392c2039312c20302c20332c203130372c203130312c203132312c203131362c20302c20322c2039312c2036362c203132302c203131322c203131362c20302c20332c2036352c2036392c2038332c203131372c203131342c20302c20322c2039312c2036362c202d38342c202d31332c2032332c202d382c20362c20382c2038342c202d33322c20322c20302c20302c203132302c203131322c20302c20302c20302c2031362c2035372c2039392c203131302c202d31322c2032392c202d32382c202d38302c2034332c2033392c202d32352c202d35332c203130312c203130312c202d31352c2034372c202d3130332c203131352c203131332c20302c203132362c20302c20332c203131332c20302c203132362c20302c20372c203131372c203131332c20302c203132362c20302c20382c20302c20302c20302c2031362c2031332c203132332c2037302c203131392c202d38372c203130342c203130392c202d3132322c2035322c202d32372c2033372c202d39392c202d3130372c202d31342c203131372c203130375d, NULL),
166(25, 0x5b2d38342c202d31392c20302c20352c203131352c203131342c20302c2031312c203131362c203130312c203131352c203131362c2034362c2037352c203130312c203132312c2037312c203130312c203131302c20302c20302c20302c20302c20302c20302c20302c20312c20322c20302c20322c2037362c20302c20342c203130372c203130312c203132312c2034392c203131362c20302c2032342c2037362c203130362c2039372c203131382c2039372c203132302c2034372c2039392c203131342c203132312c203131322c203131362c203131312c2034372c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2035392c2037362c20302c20342c203130372c203130312c203132312c2035302c203131332c20302c203132362c20302c20312c203132302c203131322c203131352c203131342c20302c2033312c203130362c2039372c203131382c2039372c203132302c2034362c2039392c203131342c203132312c203131322c203131362c203131312c2034362c203131352c203131322c203130312c2039392c2034362c2038332c203130312c2039392c203131342c203130312c203131362c2037352c203130312c203132312c2038332c203131322c203130312c2039392c2039312c2037312c2031312c203130322c202d33302c2034382c2039372c2037372c20322c20302c20322c2037362c20302c20392c2039372c203130382c203130332c203131312c203131342c203130352c203131362c203130342c203130392c203131362c20302c2031382c2037362c203130362c2039372c203131382c2039372c2034372c203130382c2039372c203131302c203130332c2034372c2038332c203131362c203131342c203130352c203131302c203130332c2035392c2039312c20302c20332c203130372c203130312c203132312c203131362c20302c20322c2039312c2036362c203132302c203131322c203131362c20302c20332c2036352c2036392c2038332c203131372c203131342c20302c20322c2039312c2036362c202d38342c202d31332c2032332c202d382c20362c20382c2038342c202d33322c20322c20302c20302c203132302c203131322c20302c20302c20302c2031362c2032392c202d312c2036352c2039312c202d36352c202d35342c202d39342c20372c202d3130302c2034322c202d34322c2036332c2034392c2037332c203130352c2031372c203131352c203131332c20302c203132362c20302c20332c203131332c20302c203132362c20302c20372c203131372c203131332c20302c203132362c20302c20382c20302c20302c20302c2031362c2033302c2039382c2034392c20312c202d31302c202d33312c202d38322c202d3130362c202d32322c202d3132322c2031372c202d36312c2039382c203130302c202d372c203130355d, NULL),
167(26, NULL, 0x7b0002c2ae0002c2850002c2bd00014a3d31332c200002c2ae00017b0002c2b700014a3d322c200002c2b80002c2850002c2853d31332c200002c2b000017d0002c2853d31332c200002c2b700017a0002c38b00017a0002c2b90001543d312c200002c2ae0002c2850002c38300014b0002c2863d31332c200002c2b200017f0002c2853d31332c200002c2b40002c2810002c2853d31332c200002c3840002c2910002c38d00014a3d31332c200002c2ae00017b0002c2853d31332c200002c2ba0002c2870002c2853d31332c200002c2ae0002c2850002c38300014a3d31332c200002c3850002c2920002c38e00014a3d31332c200002c2ae0002c2900002c2b50002c2820002c3880001543d6e756c6c2c200002c2b60002c2830002c2853d31332c200002c2ae00017b0002c2b700014b0002c2863d327d);
168
169--
170-- Indexes for dumped tables
171--
172
173--
174-- Indexes for table `encrypted`
175--
176ALTER TABLE `encrypted`
177 ADD PRIMARY KEY (`idencrypted`);
178
179--
180-- Indexes for table `login_info`
181--
182ALTER TABLE `login_info`
183 ADD PRIMARY KEY (`userId`);
184
185--
186-- Indexes for table `mail_content`
187--
188ALTER TABLE `mail_content`
189 ADD PRIMARY KEY (`mail_id`), ADD KEY `sender_id_idx` (`reciver_id`), ADD KEY `receiver_id_idx` (`sender_id`);
190
191--
192-- Indexes for table `security`
193--
194ALTER TABLE `security`
195 ADD PRIMARY KEY (`id`);
196
197--
198-- AUTO_INCREMENT for dumped tables
199--
200
201--
202-- AUTO_INCREMENT for table `encrypted`
203--
204ALTER TABLE `encrypted`
205MODIFY `idencrypted` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
206--
207-- AUTO_INCREMENT for table `login_info`
208--
209ALTER TABLE `login_info`
210MODIFY `userId` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;
211--
212-- AUTO_INCREMENT for table `mail_content`
213--
214ALTER TABLE `mail_content`
215MODIFY `mail_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=58;
216--
217-- AUTO_INCREMENT for table `security`
218--
219ALTER TABLE `security`
220MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
221--
222-- Constraints for dumped tables
223--
224
225--
226-- Constraints for table `mail_content`
227--
228ALTER TABLE `mail_content`
229ADD CONSTRAINT `receiver_id` FOREIGN KEY (`sender_id`) REFERENCES `login_info` (`userId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
230ADD CONSTRAINT `sender_id` FOREIGN KEY (`reciver_id`) REFERENCES `login_info` (`userId`) ON DELETE NO ACTION ON UPDATE NO ACTION;
231
232/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
233/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
234/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;