· 6 years ago · Jun 15, 2019, 08:12 PM
1
2██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
3██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
4██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
5██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
6██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
7╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
8
9███╗ ██╗███████╗██╗ ██╗███████╗███████╗ ██████╗
10████╗ ██║██╔════╝██║ ██║██╔════╝██╔════╝██╔════╝
11██╔██╗ ██║█████╗ ██║ █╗ ██║███████╗█████╗ ██║
12██║╚██╗██║██╔══╝ ██║███╗██║╚════██║██╔══╝ ██║
13██║ ╚████║███████╗╚███╔███╔╝███████║███████╗╚██████╗
14╚═╝ ╚═══╝╚══════╝ ╚══╝╚══╝ ╚══════╝╚══════╝ ╚═════╝
15
16--------------------------------------------------------------------------------------
17
18Target : https://www.state.gov/ ( Departamento de Estado dos Estados Unidos )
19
20Salve Pros Manos: Cyr0x, NedLock, Kami, S1x3r, S1Lv3R
21
22"#OpUSA"
23--------------------------------------------------------------------------------------
24Database: stateus_db
25
26/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
27/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
28/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
29/*!40101 SET NAMES utf8 */;
30/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
31/*!40103 SET TIME_ZONE='+00:00' */;
32/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
33/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
34/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
35/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
36
37--
38-- Table structure for table `department`
39--
40
41DROP TABLE IF EXISTS `department`;
42CREATE TABLE `department` (
43 `Dname` char(10) DEFAULT NULL,
44 `Dnumber` int(11) DEFAULT NULL,
45 `Mgr_ssn` int(11) DEFAULT NULL,
46 `Mgr_start_date` char(10) DEFAULT NULL
47) ENGINE=MyISAM DEFAULT CHARSET=latin1;
48
49--
50-- Dumping data for table `department`
51--
52
53
54/*!40000 ALTER TABLE `department` DISABLE KEYS */;
55LOCK TABLES `department` WRITE;
56INSERT INTO `department` VALUES ('Research',5,333445555,'1988-05-22'),('Administra',4,987654321,'1995-01-01'),('Headquarte',1,888665555,'1981-06-19');
57UNLOCK TABLES;
58/*!40000 ALTER TABLE `department` ENABLE KEYS */;
59
60--
61-- Table structure for table `dependent`
62--
63
64DROP TABLE IF EXISTS `dependent`;
65CREATE TABLE `dependent` (
66 `Ssn` int(11) DEFAULT NULL,
67 `Dep_name` char(10) DEFAULT NULL,
68 `Sex` enum('M','F') DEFAULT NULL,
69 `Bdate` char(10) DEFAULT NULL,
70 `Relation` char(10) DEFAULT NULL
71) ENGINE=MyISAM DEFAULT CHARSET=latin1;
72
73--
74-- Dumping data for table `dependent`
75--
76
77
78/*!40000 ALTER TABLE `dependent` DISABLE KEYS */;
79LOCK TABLES `dependent` WRITE;
80INSERT INTO `dependent` VALUES (333445555,'Alice','F','1986-04-05','Daughter'),(333445555,'Theodore','M','1983-10-25','Son'),(333445555,'Joy','F','1958-05-03','Spouse'),(987654321,'Abner','M','1942-02-28','Spouse'),(123456789,'Michael','M','1988-01-04','Son'),(123456789,'Alice','F','1988-12-30','Daughter'),(123456789,'Elizabeth','F','1967-05-05','Spouse');
81UNLOCK TABLES;
82/*!40000 ALTER TABLE `dependent` ENABLE KEYS */;
83
84--
85-- Table structure for table `dept_locations`
86--
87
88DROP TABLE IF EXISTS `dept_locations`;
89CREATE TABLE `dept_locations` (
90 `Dnumber` int(11) DEFAULT NULL,
91 `Dlocation` char(10) DEFAULT NULL
92) ENGINE=MyISAM DEFAULT CHARSET=latin1;
93
94--
95-- Dumping data for table `dept_locations`
96--
97
98
99/*!40000 ALTER TABLE `dept_locations` DISABLE KEYS */;
100LOCK TABLES `dept_locations` WRITE;
101INSERT INTO `dept_locations` VALUES (1,'Houston'),(4,'Stafford'),(5,'Bellaire'),(5,'Sugarland'),(5,'Houston');
102UNLOCK TABLES;
103/*!40000 ALTER TABLE `dept_locations` ENABLE KEYS */;
104
105--
106-- Table structure for table `employee`
107--
108
109DROP TABLE IF EXISTS `employee`;
110CREATE TABLE `employee` (
111 `Fname` char(10) NOT NULL,
112 `Minit` char(1) DEFAULT NULL,
113 `Lname` char(10) DEFAULT NULL,
114 `Ssn` int(11) DEFAULT NULL,
115 `Bdate` char(10) DEFAULT NULL,
116 `Address` char(20) DEFAULT NULL,
117 `Sex` enum('M','F') DEFAULT NULL,
118 `Salary` int(11) DEFAULT NULL,
119 `Super_ssn` int(11) DEFAULT NULL,
120 `Dno` int(11) DEFAULT NULL
121) ENGINE=MyISAM DEFAULT CHARSET=latin1;
122
123--
124-- Dumping data for table `employee`
125--
126
127
128/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
129LOCK TABLES `employee` WRITE;
130INSERT INTO `employee` VALUES ('John','B','Smith',123456789,'1965-01-09','731 Fondern, Houston','M',30000,333445555,5),('Franklin','T','Wong',333445555,'1955-12-08','638 Voss, Houston, T','M',40000,888665555,5),('Alicia','J','Zelaya',999887777,'1968-01-19','3321 Castle, Spring,','F',25000,987654321,4),('Jennifer','S','Wallace',987654321,'1941-06-20','291 Berry, Bellaire,','F',43000,888665555,4),('Ramesh','K','Narayan',666884444,'1962-09-15','975 Fire Oak, Humble','M',38000,333445555,5),('Joyce','A','English',453453453,'1972-07-31','5631 Rice, Houston,','F',25000,333445555,5),('Ahmad','V','Jabbar',987987987,'1969-03-29','980 Dallas, Houston,','M',25000,987654321,4),('James','E','Borg',888665555,'1937-11-10','450 Stone, Houston,','M',55000,0,1);
131UNLOCK TABLES;
132/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
133
134--
135-- Table structure for table `femp`
136--
137
138DROP TABLE IF EXISTS `femp`;
139/*!50001 DROP VIEW IF EXISTS `femp`*/;
140/*!50001 DROP TABLE IF EXISTS `femp`*/;
141/*!50001 CREATE TABLE `femp` (
142 `Fname` char(10),
143 `Lname` char(10),
144 `Ssn` int(11)
145) */;
146
147--
148-- Table structure for table `project`
149--
150
151DROP TABLE IF EXISTS `project`;
152CREATE TABLE `project` (
153 `Pname` char(10) DEFAULT NULL,
154 `Pnumber` int(11) DEFAULT NULL,
155 `Plocation` char(10) DEFAULT NULL,
156 `Dnum` int(11) DEFAULT NULL
157) ENGINE=MyISAM DEFAULT CHARSET=latin1;
158
159--
160-- Dumping data for table `project`
161--
162
163
164/*!40000 ALTER TABLE `project` DISABLE KEYS */;
165LOCK TABLES `project` WRITE;
166INSERT INTO `project` VALUES ('ProductX',1,'Bellaire',5),('ProductY',2,'Sugarland',5),('ProductZ',3,'Houston',5),('Computeriz',10,'Stafford',4),('Reorganiza',20,'Houston',1),('Newbenefit',30,'Stafford',4);
167UNLOCK TABLES;
168/*!40000 ALTER TABLE `project` ENABLE KEYS */;
169
170--
171-- Table structure for table `works_on`
172--
173
174DROP TABLE IF EXISTS `works_on`;
175CREATE TABLE `works_on` (
176 `Essn` int(11) DEFAULT NULL,
177 `Pno` int(11) DEFAULT NULL,
178 `hours` float DEFAULT NULL
179) ENGINE=MyISAM DEFAULT CHARSET=latin1;
180
181--
182-- Dumping data for table `works_on`
183--
184
185
186/*!40000 ALTER TABLE `works_on` DISABLE KEYS */;
187LOCK TABLES `works_on` WRITE;
188INSERT INTO `works_on` VALUES (123456789,1,32.5),(123456789,2,7.5),(666884444,3,40),(453453453,1,20),(453453453,2,20),(333445555,2,10),(333445555,3,10),(333445555,10,10),(999887777,30,30),(999887777,10,10),(987987987,10,35),(987987987,30,5),(987654321,30,20),(987654321,20,15),(888665555,20,0);
189UNLOCK TABLES;
190/*!40000 ALTER TABLE `works_on` ENABLE KEYS */;
191
192--
193-- View structure for view `femp`
194--
195
196/*!50001 DROP TABLE IF EXISTS `femp`*/;
197/*!50001 DROP VIEW IF EXISTS `femp`*/;
198/*!50001 CREATE ALGORITHM=UNDEFINED */
199/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
200/*!50001 VIEW `femp` AS select `employee`.`Fname` AS `Fname`,`employee`.`Lname` AS `Lname`,`employee`.`Ssn` AS `Ssn` from `employee` where (`employee`.`Sex` = _latin1'F') */;
201/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
202
203/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
204/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
205/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
206/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
207/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
208/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
209/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;