workshop.sql

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 07, 2014 at 01:16 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 NAMES utf8 */;

--
-- Database: `skills`
--

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `IdUser` int(11) NOT NULL,
  `Role` tinyint(4) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `IdUser` (`IdUser`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`Id`, `IdUser`, `Role`) VALUES
(1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `skills`
--

CREATE TABLE IF NOT EXISTS `skills` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `IdCat` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=211 ;

--
-- Dumping data for table `skills`
--

INSERT INTO `skills` (`id`, `name`, `IdCat`) VALUES
(1, 'MS Visio', 36),
(2, 'Booch', 36),
(3, 'HOOD', 36),
(4, 'Jackson', 36),
(5, 'Merise', 36),
(6, 'OMT', 36),
(7, 'Power AMC', 36),
(8, 'Rational Rose', 36),
(9, 'SADT', 36),
(10, 'TortoiseSVN', 36),
(11, 'HP Quality Center', 36),
(12, 'SART', 36),
(13, 'NIAM', 36),
(14, 'Z', 36),
(15, 'CVS', 36),
(16, 'Power Designer', 36),
(17, 'Ant', 36),
(18, 'xDoclet', 36),
(19, 'Rational Unified Process', 36),
(20, 'Junit', 36),
(21, 'Visual Source Safe', 36),
(22, 'Rational - Functional', 36),
(23, 'Rational ClearCase', 36),
(24, 'MEGA', 36),
(25, 'MEGA Designer', 36),
(26, 'WinDesign', 36),
(27, 'Rational TestManager', 36),
(28, 'Rational XDE', 36),
(29, 'ClearCase', 36),
(30, 'Rational Test Manager', 36),
(31, 'JIRA', 36),
(32, 'Cruise Control', 36),
(33, 'Poseidon', 36),
(34, 'Bugzilla', 36),
(35, 'Jcoverage', 36),
(36, 'Mock', 36),
(37, 'Subversion (svn)', 36),
(38, 'Apache Maven', 36),
(39, 'utPL/SQL', 36),
(40, 'Rational Functional Tester', 36),
(41, 'Jdepend', 36),
(42, 'Cobertura', 36),
(43, 'Mercury Quality Center', 36),
(44, 'TestNG', 36),
(45, 'Mantis Bug Tracker', 36),
(46, 'Expect', 36),
(47, 'QTP ', 36),
(48, 'CppUnit', 36),
(49, 'Agile', 36),
(50, 'FogBugz', 36),
(51, 'TestTrack', 36),
(52, 'xUnit', 36),
(53, 'Gradle', 36),
(54, 'JWebUnit', 36),
(55, 'CMVC', 36),
(56, 'DUnit', 36),
(57, 'iMake', 36),
(58, 'GreenPepper', 36),
(59, 'SCADE Suite', 36),
(60, 'NCover', 36),
(61, 'XMLUnit', 36),
(62, 'BuildBot', 36),
(63, 'MbUnit', 36),
(64, 'DDTUnit', 36),
(65, 'Ranorex', 36),
(66, 'JMUnit', 36),
(67, 'DBUnit SVN', 36),
(68, 'QF-Test', 36),
(69, 'CUnit', 36),
(70, 'Testlink', 36),
(71, 'Trac', 36),
(72, 'QuickTest', 36),
(73, 'Selenium', 36),
(74, 'Business Objects', 23),
(75, 'Datastage', 23),
(76, 'ArcGIS', 23),
(77, 'AB Initio', 23),
(78, 'SAS', 23),
(79, 'Crystal Reports', 23),
(80, 'StatGraphicsPlus', 23),
(81, 'StatLab', 23),
(82, 'Sunopsis', 23),
(83, 'Brio Technology', 23),
(84, 'ReportMaker', 23),
(85, 'Cognos Impromptu', 23),
(86, 'SQL Server Business Intelligence Development Studi', 23),
(87, 'OLAP', 23),
(88, 'SPSS', 23),
(89, 'SAP Business Information Warehouse', 23),
(90, 'Jasper Reports', 23),
(91, 'StatBox', 23),
(92, 'Cognos Power Play', 23),
(93, 'Cognos', 23),
(94, 'Unica NetTracker', 23),
(95, 'Wonderware Historian', 23),
(96, 'Oracle Data Integrator', 23),
(97, 'Hyperion Essbase', 23),
(98, 'Hyperion Planning', 23),
(99, 'Hyperion Analyzer', 23),
(100, 'Hyperion Reports', 23),
(101, 'Hyperion Application Link', 23),
(102, 'Informatica PowerCenter', 23),
(103, 'Informatica PowerMart', 23),
(104, 'Oracle Warehouse Builder', 23),
(105, 'SQL Server Report Builder', 23),
(106, 'Hyperion Intelligence', 23),
(107, 'IBM Cognos TM-1 Turbo Integrator', 23),
(108, 'Genio', 23),
(109, 'Hyperion Performance Suite', 23),
(110, 'Spago BI', 23),
(111, 'Talend', 23),
(112, 'Oracle Reports', 23),
(113, 'SQL Server Reporting Services', 23),
(114, 'Eviews', 23),
(115, 'Systat', 23),
(116, 'Netezza', 23),
(117, 'SEM', 23),
(118, 'NX (Unigraphics)', 39),
(119, 'AutoCAD', 39),
(120, 'P-CAD', 39),
(121, 'SolidWorks', 39),
(122, 'PowerMill', 39),
(123, 'Autodesk Inventor Mechanical Desktop', 39),
(124, 'ANSA', 39),
(125, 'CADDS5', 39),
(126, 'OrCAD', 39),
(127, 'Autodesk Inventor', 39),
(128, 'Catia', 39),
(129, 'Architectural Desktop', 39),
(130, 'Freelance 2000', 39),
(131, 'SIEMENS Step 7', 39),
(132, 'SIMATIC', 39),
(133, 'STEP 7 Micro/WIN32', 39),
(134, 'Crouzet Millenium', 39),
(135, 'LabView', 39),
(136, 'PCB', 39),
(137, 'ArchiCAD', 39),
(138, 'CANoe', 39),
(139, 'TargetLink', 39),
(140, 'DataCAD', 39),
(141, 'VectorWorks', 39),
(142, 'Cadelec', 39),
(143, 'FoxPro', 42),
(144, 'PostGreSQL', 42),
(145, 'SQL Server', 42),
(146, 'Sybase', 42),
(147, 'Lotus Approach', 42),
(148, 'Interbase', 42),
(149, 'MS Access', 42),
(150, 'MySQL', 42),
(151, 'Oracle', 42),
(152, 'Paradox', 42),
(153, 'Progress OpenEdge Database', 42),
(154, 'MongoDB', 42),
(155, 'BDE', 42),
(156, 'Dbase', 42),
(157, 'FireBirdSQL', 42),
(158, 'Oracle Spatial', 42),
(159, 'Informix', 42),
(160, 'TOAD', 42),
(161, 'ADO.NET', 42),
(162, 'IBM DB2', 42),
(163, 'Transact-SQL', 42),
(164, 'DBVisualizer', 42),
(165, 'DBArtisan', 42),
(166, 'PHPMyAdmin', 42),
(167, 'OpenBase', 42),
(168, 'SQLite', 42),
(169, 'SQL Server Replication', 42),
(170, 'RapidSQL', 42),
(171, 'SQuirrel SQL', 42),
(172, 'CAST SQLBuilder', 42),
(173, 'Gembase', 42),
(174, 'CSQL', 42),
(175, 'FrontBase', 42),
(176, 'Oracle Recovery Manager (RMAN)', 42),
(177, 'Genesis', 37),
(178, 'Open Text Content Server', 37),
(179, 'FOP', 37),
(180, 'Cobra Image Router', 37),
(181, 'Joomla', 37),
(182, 'DSpace', 37),
(183, 'Symantec Enterprise Vault', 37),
(184, 'Jetspeed', 37),
(185, 'Hyland OnBase', 37),
(186, 'Drupal', 37),
(187, 'Cassiope', 35),
(188, 'SAGE', 35),
(189, 'Alienor', 35),
(190, 'Ciel', 35),
(191, 'JD Edwards', 35),
(192, 'OneWorld', 35),
(193, 'SAP', 35),
(194, 'Qualiac', 35),
(195, 'Coda', 35),
(196, 'Etafi', 35),
(197, 'PeopleSoft', 35),
(198, 'Genesys', 35),
(199, 'Arbor', 35),
(200, 'Adonix', 35),
(201, 'WinMentor', 35),
(202, 'Hamor Soft', 35),
(203, 'SanCont', 35),
(204, 'Contab SQL', 35),
(205, '1C', 35),
(206, 'Abel', 35),
(207, 'TinyERP', 35),
(208, 'PeopleSoft Enterprise Service Automation', 35),
(209, 'ERP GENERIX', 35),
(210, 'Sage ERP X3', 35);

-- --------------------------------------------------------

--
-- Table structure for table `skills_cat`
--

CREATE TABLE IF NOT EXISTS `skills_cat` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;

--
-- Dumping data for table `skills_cat`
--

INSERT INTO `skills_cat` (`id`, `name`) VALUES
(23, 'Business'),
(24, 'Intelligence'),
(25, 'Office Automation'),
(26, 'IDE'),
(27, 'Languages'),
(28, 'Multimedia Editors'),
(29, 'DBMS'),
(30, 'IT Infrastructure'),
(31, 'Protocols'),
(32, 'Other'),
(33, 'Exploitation'),
(34, 'Industrial automation'),
(35, 'ERP&CRM'),
(36, 'ALM'),
(37, 'ECM'),
(38, 'Middleware'),
(39, 'CAD&CAM'),
(40, 'Multimedia'),
(41, 'Industrial Automation'),
(42, 'Baze de date'),
(43, 'Frameworks'),
(44, 'Mobile Apps');

-- --------------------------------------------------------

--
-- Table structure for table `skills_weight`
--

CREATE TABLE IF NOT EXISTS `skills_weight` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `id_skill` int(10) DEFAULT NULL,
  `id_tech` int(10) DEFAULT NULL,
  `weight` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_skills_tech_skills` (`id_skill`),
  KEY `FK_skills_tech_tech` (`id_tech`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `firstname` char(50) DEFAULT NULL,
  `lastname` char(50) DEFAULT NULL,
  `location` varchar(50) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(500) DEFAULT NULL,
  `role` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `firstname`, `lastname`, `location`, `username`, `password`, `role`) VALUES
(1, 'Gere', 'Arpad', 'Cluj Napoca', 'arpi', '12345', 0),
(2, 'Pavel', 'Stratan', 'Alba Iulia', 'pavelescu', '12345', 0);

-- --------------------------------------------------------

--
-- Table structure for table `users_skills`
--

CREATE TABLE IF NOT EXISTS `users_skills` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `IdUser` int(11) NOT NULL,
  `IdSkill` int(11) NOT NULL,
  `Weight` tinyint(4) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `users_skills`
--

INSERT INTO `users_skills` (`Id`, `IdUser`, `IdSkill`, `Weight`) VALUES
(1, 1, 12, 3),
(2, 1, 15, 4),
(3, 1, 20, 2),
(4, 1, 31, 5);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `skills_weight`
--
ALTER TABLE `skills_weight`
  ADD CONSTRAINT `FK_skills_tech_skills` FOREIGN KEY (`id_skill`) REFERENCES `skills_cat` (`id`),
  ADD CONSTRAINT `FK_skills_tech_tech` FOREIGN KEY (`id_tech`) REFERENCES `skills` (`id`);

/*!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 */;