Wtf?

[tree36]

# MySQL-Front 3.2 (Build 1.26)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET 'utf8' */;


# Host: 10.1.1.61 Database: oracle
# ------------------------------------------------------
# Server version 4.1.9-nt

#
# Table structure for table countries
#

CREATE TABLE `countries` (
`country_id` char(2) NOT NULL default '',
`country_name` varchar(40) default NULL,
`region_id` int(7) default NULL,
PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table countries
#

/*!40101 SET CHARACTER SET 'latin1' */;

INSERT INTO `countries` VALUES ('CA','Canada',2);
INSERT INTO `countries` VALUES ('DE','Germany',1);
INSERT INTO `countries` VALUES ('UK','United Kingdom',1);
INSERT INTO `countries` VALUES ('US','United States of America',1);

#
# Table structure for table departments
#

CREATE TABLE `departments` (
`department_id` int(4) NOT NULL default '0',
`department_name` varchar(30) NOT NULL default '',
`manager_id` int(6) default NULL,
`location_id` int(4) default NULL,
PRIMARY KEY (`department_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table departments
#

INSERT INTO `departments` VALUES (10,'Administration',200,1700);
INSERT INTO `departments` VALUES (20,'Marketing',201,1800);
INSERT INTO `departments` VALUES (50,'Shipping',124,1500);
INSERT INTO `departments` VALUES (60,'IT',103,1400);
INSERT INTO `departments` VALUES (80,'Sales',149,2500);
INSERT INTO `departments` VALUES (90,'Executive',100,1700);
INSERT INTO `departments` VALUES (110,'Accounting',205,1700);
INSERT INTO `departments` VALUES (190,'Contracting',NULL,1700);

#
# Table structure for table employees
#

CREATE TABLE `employees` (
`employee_id` int(6) NOT NULL default '0',
`first_name` varchar(20) default NULL,
`last_name` varchar(25) NOT NULL default '',
`email` varchar(25) NOT NULL default '',
`phone_number` varchar(20) default NULL,
`hire_date` date NOT NULL default '0000-00-00',
`job_id` varchar(20) NOT NULL default '',
`salary` decimal(8,2) default NULL,
`commission_pct` decimal(3,2) default NULL,
`manager_id` int(6) default NULL,
`department_id` int(4) default NULL,
PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table employees
#

INSERT INTO `employees` VALUES (100,'Steven','King','sking','515.123.4567','1987-06-17','ad_pres',24000,NULL,NULL,90);
INSERT INTO `employees` VALUES (101,'Neena','Kochlar','nkochlar','515.123.4568',' 1989-09-21','ad_vp',17000,NULL,100,90);
INSERT INTO `employees` VALUES (102,'Lex','De Haan','ldehann','515.123.4569','1993-01-13','AD_VP',17000,NULL,100,90);
INSERT INTO `employees` VALUES (103,'Alexander','Hunold','ahunold','590.423.4567' ,'1990-01-03','IT_PROG',9000,NULL,102,60);
INSERT INTO `employees` VALUES (104,'Bruce','Ernst','bernst','590.423.4568','1991-05-21','IT_PROG',6000,NULL,103,60);
INSERT INTO `employees` VALUES (107,'Diana','Lorentz','dlorentz','590.423.5567',' 1999-02-07','IT_PROG',4200,NULL,103,60);
INSERT INTO `employees` VALUES (124,'Kevin','Mourgos','kmourgos','650.123.5234',' 1999-11-16','ST_MAN',5800,NULL,100,50);
INSERT INTO `employees` VALUES (141,'Trenna','Rajs','trajs','650.121.8009','1995-10-17','ST_CLERK',3500,NULL,124,50);
INSERT INTO `employees` VALUES (142,'Curtis','Davies','cdavies','650.121.2994','1 997-01-29','ST_CLERK',3100,NULL,124,50);
INSERT INTO `employees` VALUES (143,'Randall','Matos','rmatos','650.121.2874','19 98-03-15','ST_CLERK',2600,NULL,124,50);
INSERT INTO `employees` VALUES (144,'Peter','Vargas','pvargas','650.121.2004','19 98-07-09','ST_CLERK',2500,NULL,124,50);
INSERT INTO `employees` VALUES (149,'Eleni','Zlotkey','ezlotkey','011.44.1344.429 018','2000-01-29','SA_MAN',10500,0.2,100,80);
INSERT INTO `employees` VALUES (174,'Ellen','Abel','eabel','011.44.1644.429267',' 1996-05-11','SA_REP',11000,0.3,149,80);
INSERT INTO `employees` VALUES (176,'Jonathan','Taylor','jtaylor','011.44.1644.42 9265','1998-03-24','SA_REP',8600,0.2,149,80);
INSERT INTO `employees` VALUES (178,'Kimberely','Grant','kgrant','011.44.16444292 63','1999-05-24','SA_REP',7000,0.15,149,NULL);
INSERT INTO `employees` VALUES (200,'Jennifer','Whalen','jwhalen','515.123.4444', '1987-09-17','AD_ASST',4400,NULL,101,10);
INSERT INTO `employees` VALUES (201,'Michael','Hartstein','mhartstein','515.123.5 555','1996-02-17','MK_MAN',13000,NULL,100,20);
INSERT INTO `employees` VALUES (202,'Pat','Fay','pfay','603.123.6666','1997-08-17','MK_REP',6000,NULL,201,20);
INSERT INTO `employees` VALUES (205,'Shelley','Higgins','shiggins','515.123.8080' ,'1994-06-07','AC_MGR',12000,NULL,101,110);
INSERT INTO `employees` VALUES (206,'William','Gietz','wgietz','515.123.8181','19 94-06-07','AC_ACCOUNT',8300,NULL,205,110);

#
# Table structure for table job_grades
#

CREATE TABLE `job_grades` (
`grade_level` char(3) NOT NULL default '',
`lowest_sal` int(6) default NULL,
`highest_sal` int(6) default NULL,
PRIMARY KEY (`grade_level`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table job_grades
#

INSERT INTO `job_grades` VALUES ('A',1000,2999);
INSERT INTO `job_grades` VALUES ('B',3000,5999);
INSERT INTO `job_grades` VALUES ('C',6000,9999);
INSERT INTO `job_grades` VALUES ('D',10000,14999);
INSERT INTO `job_grades` VALUES ('E',15000,24999);
INSERT INTO `job_grades` VALUES ('F',25000,40000);

#
# Table structure for table job_history
#

CREATE TABLE `job_history` (
`employee_id` int(6) NOT NULL default '0',
`start_date` date NOT NULL default '0000-00-00',
`end_date` date NOT NULL default '0000-00-00',
`job_id` varchar(10) NOT NULL default '',
`department_id` int(4) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table job_history
#

INSERT INTO `job_history` VALUES (101,'1989-09-21','1993-10-27','ac_account',110);
INSERT INTO `job_history` VALUES (102,'1993-01-13','1998-07-24','it_prog',60);
INSERT INTO `job_history` VALUES (101,'1993-10-28','1997-03-15','ac_mgr',110);
INSERT INTO `job_history` VALUES (201,'1996-02-17','1999-12-19','mk_rep',20);
INSERT INTO `job_history` VALUES (114,'1998-03-24','1999-12-31','st_clerk',50);
INSERT INTO `job_history` VALUES (122,'1999-01-01','1999-12-31','st_clerk',50);
INSERT INTO `job_history` VALUES (200,'1987-09-17','1993-06-17','ad_asst',90);
INSERT INTO `job_history` VALUES (176,'1998-03-24','1998-12-31','sa_rep',80);
INSERT INTO `job_history` VALUES (176,'1999-01-01','1999-12-31','sa_man',80);
INSERT INTO `job_history` VALUES (200,'1994-06-01','1998-12-31','ac_account',90);

#
# Table structure for table jobs
#

CREATE TABLE `jobs` (
`job_id` varchar(10) NOT NULL default '',
`job_title` varchar(35) NOT NULL default '',
`min_salary` int(6) default '0',
`max_salary` int(6) NOT NULL default '0',
PRIMARY KEY (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table jobs
#

INSERT INTO `jobs` VALUES ('ac_account','Public Accountant',4200,9000);
INSERT INTO `jobs` VALUES ('ac_mgr','Accounting Manager',8200,16000);
INSERT INTO `jobs` VALUES ('ad_asst','Administration Assistant',3000,6000);
INSERT INTO `jobs` VALUES ('ad_pres','President',20000,40000);
INSERT INTO `jobs` VALUES ('ad_vp','Administration Vice President',15000,30000);
INSERT INTO `jobs` VALUES ('it_prog','Programmer',4000,10000);
INSERT INTO `jobs` VALUES ('mk_man','Marketing Manager',9000,15000);
INSERT INTO `jobs` VALUES ('mk_rep','Marketing Representative',4000,9000);
INSERT INTO `jobs` VALUES ('sa_man','Sales Manager',10000,20000);
INSERT INTO `jobs` VALUES ('sa_rep','Sales Representative',6000,12000);
INSERT INTO `jobs` VALUES ('st_clerk','Stock Clerk',2000,5000);
INSERT INTO `jobs` VALUES ('st_man','Stock Manager',5500,8500);

#
# Table structure for table locations
#

CREATE TABLE `locations` (
`location_id` int(4) NOT NULL default '0',
`street_address` varchar(40) default NULL,
`postal_code` varchar(12) default NULL,
`city` varchar(30) NOT NULL default '',
`state_province` varchar(25) default NULL,
`country_id` char(2) default NULL,
PRIMARY KEY (`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table locations
#

INSERT INTO `locations` VALUES (1400,'2014 Jabberwocky Rd','26192','Southlake','Texas','US');
INSERT INTO `locations` VALUES (1500,'2011 Interiors Blvd','99236','South San Francisco','California','US');
INSERT INTO `locations` VALUES (1700,'2004 Charade Rd','98199','Seattle','Washington','US');
INSERT INTO `locations` VALUES (1800,'460 Bloor St. W.','ON M5S 1X8','Toronto','Ontario','CA');
INSERT INTO `locations` VALUES (2500,'Magdalen Centre, The Oxford Science Park','OX9 9ZB','Oxford','Oxford','UK');

#
# Table structure for table regions
#

CREATE TABLE `regions` (
`region_id` int(1) NOT NULL default '0',
`region_name` varchar(25) default NULL,
PRIMARY KEY (`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table regions
#

INSERT INTO `regions` VALUES (1,'Europe');
INSERT INTO `regions` VALUES (2,'Americas');
INSERT INTO `regions` VALUES (3,'Asia');
INSERT INTO `regions` VALUES (4,'Middle East and Africa');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[motorwerks]

what the hell is all of that?

[tree36]

ha its a programing code.