spd-dev/codetest
015
1SQLite format 3 @ -��
� � &�
���
�}i�J���u �
�tablelocationslocationsCREATE TABLE `locations` (2 `LOCATION_ID` decimal(4,0) NOT NULL DEFAULT '0',3 `STREET_ADDRESS` varchar(40) DEFAULT NULL,4 `POSTAL_CODE` varchar(12) DEFAULT NULL,5 `CITY` varchar(30) NOT NULL,6 `STATE_PROVINCE` varchar(25) DEFAULT NULL,7 `COUNTRY_ID` varchar(2) DEFAULT NULL,8 PRIMARY KEY (`LOCATION_ID`),9 FOREIGN KEY (`COUNTRY_ID`) REFERENCES countries(`COUNTRY_ID`)10)1E indexsqlite_autoindex_locations_1locations�[##�}tablejob_historyjob_historyCREATE TABLE `job_history` (11 `EMPLOYEE_ID` decimal(6,0) NOT NULL,12 `START_DATE` date NOT NULL,13 `END_DATE` date NOT NULL,14 `JOB_ID` varchar(10) NOT NULL,15 `DEPARTMENT_ID` decimal(4,0) DEFAULT NULL,16 PRIMARY KEY (`EMPLOYEE_ID`,`START_DATE`),17 FOREIGN KEY (`EMPLOYEE_ID`) REFERENCES employees(`EMPLOYEE_ID`),18 FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES departments(`DEPARTMENT_ID`),19 FOREIGN KEY (`JOB_ID`) REFERENCES jobs(`JOB_ID`)20)5I# indexsqlite_autoindex_job_history_1job_history�21 �ctableemployeesemployees22CREATE TABLE `employees` (23 `EMPLOYEE_ID` decimal(6,0) NOT NULL DEFAULT '0',24 `FIRST_NAME` varchar(20) DEFAULT NULL,25 `LAST_NAME` varchar(25) NOT NULL,26 `EMAIL` varchar(25) NOT NULL,27 `PHONE_NUMBER` varchar(20) DEFAULT NULL,28 `HIRE_DATE` date NOT NULL,29 `JOB_ID` varchar(10) NOT NULL,30 `SALARY` decimal(8,2) DEFAULT NULL,31 `COMMISSION_PCT` decimal(2,2) DEFAULT NULL,32 `MANAGER_ID` decimal(6,0) DEFAULT NULL,33 `DEPARTMENT_ID` decimal(4,0) DEFAULT NULL,34 PRIMARY KEY (`EMPLOYEE_ID`),35 FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES departments(`DEPARTMENT_ID`),36 FOREIGN KEY (`JOB_ID`) REFERENCES jobs(`JOB_ID`)37)138E indexsqlite_autoindex_employees_1employees�i�5tablejobsjobsCREATE TABLE `jobs` (39 `JOB_ID` varchar(10) NOT NULL DEFAULT '',40 `JOB_TITLE` varchar(35) NOT NULL,41 `MIN_SALARY` decimal(6,0) DEFAULT NULL,42 `MAX_SALARY` decimal(6,0) DEFAULT NULL,43 PRIMARY KEY (`JOB_ID`)44)'; indexsqlite_autoindex_jobs_1jobs �##�qtabledepartmentsdepartmentsCREATE TABLE `departments` (45 `DEPARTMENT_ID` decimal(4,0) NOT NULL DEFAULT '0',46 `DEPARTMENT_NAME` varchar(30) NOT NULL,47 `MANAGER_ID` decimal(6,0) DEFAULT NULL,48 `LOCATION_ID` decimal(4,0) DEFAULT NULL,49 PRIMARY KEY (`DEPARTMENT_ID`)50)5I# indexsqlite_autoindex_departments_1departments��mtablecountriescountriesCREATE TABLE `countries` (51 `COUNTRY_ID` varchar(2) NOT NULL,52 `COUNTRY_NAME` varchar(40) DEFAULT NULL,53 `REGION_ID` decimal(10,0) DEFAULT NULL,54 PRIMARY KEY (`COUNTRY_ID`),55 FOREIGN KEY (`REGION_ID`) REFERENCES regions (`REGION_ID`)56)1E indexsqlite_autoindex_countries_1countries� �tableregionsregionsCREATE TABLE `regions` (57 `REGION_ID` decimal(5,0) NOT NULL,58 `REGION_NAME` varchar(25) DEFAULT NULL,59 PRIMARY KEY (`REGION_ID`)60)-A indexsqlite_autoindex_regions_1regions
� ���� =Middle East and Africa\r61Asia\r!Americas\r Europe\r62