DROP TABLE IF EXISTS `jobsjobs`;
CREATE TABLE `jobsjobs`(`ID` INT NOT NULL AUTO_INCREMENT,`City` VARCHAR(50) ,`Company` VARCHAR(50) ,`Country` VARCHAR(50) ,`DateAdded` DATE ,`Description` LONGTEXT ,`HowToApply` LONGTEXT ,`LogoURL` VARCHAR(100) ,`state` VARCHAR(50) ,`Title` VARCHAR(50) ,`TypeID` INT ,`Website` VARCHAR(100) ,`Zip` VARCHAR(50) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `jobsjobtype`;
CREATE TABLE `jobsjobtype`(`ID` INT AUTO_INCREMENT,`sType` VARCHAR(100) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `jobsusers`;
CREATE TABLE `jobsusers`(`Email` VARCHAR(50) ,`Group` VARCHAR(50) ,`ID` INT AUTO_INCREMENT,`Password` VARCHAR(50) ,`Username` VARCHAR(50) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `jobsstate`;
CREATE TABLE `jobsstate`(`ID` INT AUTO_INCREMENT,`state` VARCHAR(10) ,PRIMARY KEY (`ID`));
INSERT INTO `jobsjobs`(`ID`,`Company`,`Title`,`TypeID`,`Description`,`HowToApply`,`Zip`,`City`,`state`,`Country`,`Website`,`LogoURL`,`DateAdded`) VALUES(1,'CHRobinson','Financial Analyst',55,'Job Duties :rPrepare Feasibility and Profitability AnalysisrPrepare Long-Term Corporate ProjectionsrReview Proposals for New ProjectsrVerify Financial ProjectionsrrPurpose: To Assist the National Accounts finance/contracts and Sales finance organizations to generate reporting and provide analytics to Finance and Sales management.rrSummary of responsibilities: Organize and structure business information to identify specific risks and opportunities. Generate, analyze, communicate and resolve financial & contractual information/issues which impact operating performance. Provide financial & contractual business support to the field sales organization. Develop & communicate various customer reporting issues and obligations. Apply quantitative and qualitative factors, skills and business experience to arrive at meaningful business plan conclusions and recommendations. Utilize Business Objects, Microsoft excel and word to generate and communicate information.rrRequirements:r- 5-8 or more years of accounting and finance experience in various capacities/functionsr- Systems experience with SAP, CognosrPrimary Skills: Business Objects; Reporting; AnalyticsrrDegree Type: BArDegree Area: Finance or RelatedrExperience Minimum: 5 YearsrCertificates/Licenses:','To submit a resume for this position, you must place PR55431/MB/TM34225MF1 in the subject line of your e-mail. Send your resumes to: Professional.jobs@manpower.com in text format. Do not send e-mail attachments.','55432','Minneapolis','MN','USA','www.chrobinson.com','http://chrobinson.com/spashimages/tcl\_top\_head.jpg','2007-1-21 11:58:19');
INSERT INTO `jobsjobs`(`ID`,`Company`,`Title`,`TypeID`,`Description`,`HowToApply`,`Zip`,`City`,`state`,`Country`,`Website`,`LogoURL`,`DateAdded`) VALUES(2,'BestBuy','Project Manager',48,'RESPONSIBILITIES-The Project Manager will be required to lead assigned IT projects and be responsible for delivering all required project management deliverables. As well as Project Management documentation (status report, executive summary, issue/risk logs, etc.) and all Project Methodology artifacts as required.rrrrRequirements:rProject Management experience a must.rIT Project Management is preferred. rExcellent organizational skills required, must be a self-starter with good problem solving abilities, excellent interpersonal communication skills. rrExperience with Merchandising Business is desired.rrVOLT is an equal opportunity employer offering competitive pay and enhanced benefits.rContact us today!!','Email us at jobs@bestbuy.com','55345','Bloomington','MN','USA','http://careers.bestbuy.com','http://images.bestbuy.com/BestBuy\_US/en\_US/images/global/hf/bby2/gl\_hdr\_bbylogo.gif','2007-3-27 12:26:47');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(1,'Accounting/Auditing');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(2,'Administrative and Support Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(3,'Advertising/Marketing/Public Relations');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(4,'Aerospace/Aviation/Defense');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(5,'Agriculture, Forestry, & Fishing');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(6,'Airlines');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(7,'Architectural Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(8,'Arts, Entertainment, and Media');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(9,'Automotive/Motor Vehicle/Parts');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(10,'Banking');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(11,'Biotechnology and Pharmaceutical');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(12,'Building and Grounds Maintenance');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(13,'Business Opportunity/Investment Required');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(14,'Career Fairs');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(15,'Computer Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(16,'Computers, Hardware');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(17,'Computers, Software');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(18,'Construction, Mining and Trades');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(19,'Consulting Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(20,'Consumer Products');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(21,'Customer Service and Call Center');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(22,'Education, Training, and Library');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(23,'Electronics');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(24,'Employment Placement Agencies');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(25,'Energy/Utilities');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(26,'Engineering');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(27,'Environmental Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(28,'Executive Management');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(29,'Finance/Economics');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(30,'Financial Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(31,'Government and Policy');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(32,'Healthcare - Business Office & Finance');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(33,'Healthcare - CNAs/Aides/MAs/Home Health');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(34,'Healthcare - Laboratory/Pathology Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(35,'Healthcare - LPNs & LVNs');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(36,'Healthcare - Medical & Dental Practitioners');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(37,'Healthcare - Medical Records, Health IT & Informatics');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(38,'Healthcare - Optical');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(39,'Healthcare - Other');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(40,'Healthcare - Pharmacy');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(41,'Healthcare - Radiology/Imaging');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(42,'Healthcare - RNs & Nurse Management');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(43,'Healthcare - Social Services/Mental Health');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(44,'Healthcare - Support Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(45,'Healthcare - Therapy/Rehab Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(46,'Hospitality/Tourism');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(47,'Human Resources/Recruiting');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(48,'Information Technology');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(49,'Installation, Maintenance, and Repair');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(50,'Insurance');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(51,'Internet/E-Commerce');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(52,'Law Enforcement/Security Srvs');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(53,'Legal');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(54,'Manufacturing and Production');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(55,'Military');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(56,'Nonprofit');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(57,'Operations Management');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(58,'Other');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(59,'Personal Care and Service');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(60,'Product Management');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(61,'Project/Program Management');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(62,'Publishing/Printing');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(63,'Purchasing');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(64,'Real Estate/Mortgage');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(65,'Research & Development');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(66,'Restaurant and Food Service');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(67,'Retail/Wholesale');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(68,'Sales');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(69,'Sales - Account Management');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(70,'Sales - Telemarketing');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(71,'Sales - Work at Home/Commission Only');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(72,'Science');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(73,'Sports and Recreation/Fitness');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(74,'Supply Chain/Logistics');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(75,'Telecommunications');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(76,'Textiles');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(77,'Transportation and Warehousing');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(78,'Veterinary Services');
INSERT INTO `jobsjobtype`(`ID`,`sType`) VALUES(79,'Waste Management Services ');
INSERT INTO `jobsusers`(`ID`,`Username`,`Password`,`Group`,`Email`) VALUES(1,'admin','admin','admin',NULL);
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(1,'AL');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(2,'AK');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(3,'AZ');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(4,'AR');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(5,'CA');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(6,'CO');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(7,'CT');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(8,'DE');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(9,'FL');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(10,'GA');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(11,'HI');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(12,'ID');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(13,'IL');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(14,'IN');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(15,'IA');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(16,'KS');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(17,'KY');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(18,'LA');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(19,'ME');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(20,'MD');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(21,'MA');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(22,'MI');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(23,'MN');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(24,'MS');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(25,'MO');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(26,'MT');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(27,'NE');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(28,'NV');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(29,'NH');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(30,'NJ');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(31,'NM');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(32,'NY');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(33,'NC');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(34,'ND');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(35,'OH');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(36,'OK');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(37,'OR');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(38,'PA');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(39,'RI');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(40,'SC');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(41,'SD');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(42,'TN');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(43,'TX');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(44,'UT');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(45,'VT');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(46,'VA');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(47,'WA');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(48,'WV');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(49,'WI');
INSERT INTO `jobsstate`(`ID`,`state`) VALUES(50,'WY');