-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 30, 2009 at 05:07 PM
-- Server version: 5.0.38
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `matrixtest`
-- 

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

-- 
-- Table structure for table `features`
-- 

CREATE TABLE IF NOT EXISTS `features` (
  `id_sample` mediumint(8) unsigned NOT NULL,
  `id_class` mediumint(8) unsigned NOT NULL,
  `score` float NOT NULL,
  KEY `id1` (`id_sample`),
  KEY `id2` (`id_class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `features`
-- 

INSERT INTO `features` (`id_sample`, `id_class`, `score`) VALUES 
(1, 1, 0.51787),
(2, 1, 0.59987),
(3, 1, 0.61628),
(4, 1, 0.50059),
(5, 1, 0.58126),
(6, 1, 0.58482),
(7, 1, 0.5317),
(8, 1, 0.6054),
(9, 1, 0.53674),
(10, 1, 0.50336),
(11, 1, 0.51166),
(12, 1, 0.59974),
(13, 1, 0.58893),
(14, 1, 0.59793),
(15, 1, 0.57799),
(16, 1, 0.60318),
(17, 1, 0.50438),
(18, 1, 0.55068),
(19, 1, 0.53121),
(20, 1, 0.56011),
(21, 1, 0.6101),
(22, 1, 0.53509),
(23, 1, 0.57489),
(24, 1, 0.50328),
(25, 1, 0.5194),
(26, 1, 0.60424),
(27, 1, 0.52436),
(28, 1, 0.60372),
(29, 1, 0.54226),
(30, 1, 0.58389),
(31, 1, 0.50655),
(32, 1, 0.59179),
(33, 1, 0.56244),
(34, 1, 0.23582),
(35, 1, 0.072443),
(36, 1, 0.09414),
(37, 1, 0.028439),
(38, 1, 0.24121),
(39, 1, 0.10813),
(40, 1, 0.021141),
(41, 1, 0.17917),
(42, 1, 0.1267),
(43, 1, 0.082022),
(44, 1, 0.18838),
(45, 1, 0.209),
(46, 1, 0.063429),
(47, 1, 0.13361),
(48, 1, 0.10879),
(49, 1, 0.039426),
(50, 1, 0.15012),
(51, 1, 0.23436),
(52, 1, 0.02694),
(53, 1, 0.225),
(54, 1, 0.13762),
(55, 1, 0.10684),
(56, 1, 0.038095),
(57, 1, 0.061887),
(58, 1, 0.11184),
(59, 1, 0.1332),
(60, 1, 0.088663),
(61, 1, 0.19328),
(62, 1, 0.22042),
(63, 1, 0.18352),
(64, 1, 0.10161),
(65, 1, 0.15104),
(66, 1, 0.16028),
(67, 1, 0.031867),
(68, 1, 0.12405),
(69, 1, 0.077617),
(70, 1, 0.14464),
(71, 1, 0.2359),
(72, 1, 0.10673),
(73, 1, 0.0082821),
(74, 1, 0.23236),
(75, 1, 0.23125),
(76, 1, 0.089577),
(77, 1, 0.064997),
(78, 1, 0.19671),
(79, 1, 0.1279),
(80, 1, 0.14063),
(81, 1, 0.1712),
(82, 1, 0.023099),
(83, 1, 0.21814),
(84, 1, 0.23573),
(85, 1, 0.024149),
(86, 1, 0.21147),
(87, 1, 0.22735),
(88, 1, 0.0028353),
(89, 1, 0.13092),
(90, 1, 0.16259),
(91, 1, 0.096286),
(92, 1, 0.16233),
(93, 1, 0.19071),
(94, 1, 0.14392),
(95, 1, 0.15798),
(96, 1, 0.069551),
(97, 1, 0.20996),
(98, 1, 0.10671),
(99, 1, 0.15791),
(1, 2, 0.20837),
(2, 2, 0.067546),
(3, 2, 0.1002),
(4, 2, 0.13856),
(5, 2, 0.11097),
(6, 2, 0.022596),
(7, 2, 0.1861),
(8, 2, 0.0081539),
(9, 2, 0.10744),
(10, 2, 0.0093156),
(11, 2, 0.24395),
(12, 2, 0.13058),
(13, 2, 0.22741),
(14, 2, 0.095812),
(15, 2, 0.22111),
(16, 2, 0.063754),
(17, 2, 0.22726),
(18, 2, 0.22364),
(19, 2, 0.099629),
(20, 2, 0.15626),
(21, 2, 0.1419),
(22, 2, 0.22363),
(23, 2, 0.053541),
(24, 2, 0.00096479),
(25, 2, 0.22015),
(26, 2, 0.05878),
(27, 2, 0.061216),
(28, 2, 0.16023),
(29, 2, 0.076131),
(30, 2, 0.20641),
(31, 2, 0.22092),
(32, 2, 0.23634),
(33, 2, 0.097699),
(34, 2, 0.60017),
(35, 2, 0.51964),
(36, 2, 0.57815),
(37, 2, 0.58737),
(38, 2, 0.51073),
(39, 2, 0.5664),
(40, 2, 0.61107),
(41, 2, 0.53296),
(42, 2, 0.52935),
(43, 2, 0.60496),
(44, 2, 0.56194),
(45, 2, 0.51905),
(46, 2, 0.52885),
(47, 2, 0.58224),
(48, 2, 0.57037),
(49, 2, 0.53648),
(50, 2, 0.57779),
(51, 2, 0.58949),
(52, 2, 0.53509),
(53, 2, 0.55153),
(54, 2, 0.54528),
(55, 2, 0.59767),
(56, 2, 0.51694),
(57, 2, 0.61276),
(58, 2, 0.5362),
(59, 2, 0.56244),
(60, 2, 0.59795),
(61, 2, 0.58463),
(62, 2, 0.51873),
(63, 2, 0.58708),
(64, 2, 0.51613),
(65, 2, 0.61824),
(66, 2, 0.6108),
(67, 2, 0.12875),
(68, 2, 0.16985),
(69, 2, 0.2442),
(70, 2, 0.031365),
(71, 2, 0.18806),
(72, 2, 0.20676),
(73, 2, 0.19536),
(74, 2, 0.047721),
(75, 2, 0.10716),
(76, 2, 0.0036142),
(77, 2, 0.081321),
(78, 2, 0.033676),
(79, 2, 0.11263),
(80, 2, 0.14307),
(81, 2, 0.19801),
(82, 2, 0.10493),
(83, 2, 0.13313),
(84, 2, 0.23143),
(85, 2, 0.22477),
(86, 2, 0.13621),
(87, 2, 0.22528),
(88, 2, 0.012957),
(89, 2, 0.20215),
(90, 2, 0.083726),
(91, 2, 0.057171),
(92, 2, 0.2056),
(93, 2, 0.087059),
(94, 2, 0.041368),
(95, 2, 0.0070334),
(96, 2, 0.23884),
(97, 2, 0.17007),
(98, 2, 0.21514),
(99, 2, 0.23477),
(1, 3, 0.17005),
(2, 3, 0.22936),
(3, 3, 0.064173),
(4, 3, 0.2214),
(5, 3, 0.23001),
(6, 3, 0.075016),
(7, 3, 0.018348),
(8, 3, 0.19185),
(9, 3, 0.021238),
(10, 3, 0.18219),
(11, 3, 0.11197),
(12, 3, 0.16281),
(13, 3, 0.042375),
(14, 3, 0.13286),
(15, 3, 0.15845),
(16, 3, 0.003524),
(17, 3, 0.11759),
(18, 3, 0.22158),
(19, 3, 0.028507),
(20, 3, 0.11064),
(21, 3, 0.16489),
(22, 3, 0.073693),
(23, 3, 0.23759),
(24, 3, 0.17357),
(25, 3, 0.051702),
(26, 3, 0.13869),
(27, 3, 0.21982),
(28, 3, 0.13946),
(29, 3, 0.18808),
(30, 3, 0.22373),
(31, 3, 0.21046),
(32, 3, 0.032714),
(33, 3, 0.047288),
(34, 3, 0.03841),
(35, 3, 0.0072255),
(36, 3, 0.0022712),
(37, 3, 0.14911),
(38, 3, 0.15226),
(39, 3, 0.22973),
(40, 3, 0.18339),
(41, 3, 0.075287),
(42, 3, 0.12389),
(43, 3, 0.064541),
(44, 3, 0.18321),
(45, 3, 0.02919),
(46, 3, 0.18651),
(47, 3, 0.20245),
(48, 3, 0.18631),
(49, 3, 0.084286),
(50, 3, 0.14608),
(51, 3, 0.11724),
(52, 3, 0.021816),
(53, 3, 0.20718),
(54, 3, 0.17149),
(55, 3, 0.066831),
(56, 3, 0.24237),
(57, 3, 0.045944),
(58, 3, 0.074985),
(59, 3, 0.1028),
(60, 3, 0.059122),
(61, 3, 0.048764),
(62, 3, 0.17634),
(63, 3, 0.045137),
(64, 3, 0.13058),
(65, 3, 0.074043),
(66, 3, 0.1157),
(67, 3, 0.61565),
(68, 3, 0.52699),
(69, 3, 0.50013),
(70, 3, 0.61333),
(71, 3, 0.58501),
(72, 3, 0.56437),
(73, 3, 0.56526),
(74, 3, 0.51286),
(75, 3, 0.62461),
(76, 3, 0.54487),
(77, 3, 0.57816),
(78, 3, 0.54917),
(79, 3, 0.50096),
(80, 3, 0.56816),
(81, 3, 0.56364),
(82, 3, 0.53085),
(83, 3, 0.50567),
(84, 3, 0.60522),
(85, 3, 0.50603),
(86, 3, 0.53954),
(87, 3, 0.59793),
(88, 3, 0.62155),
(89, 3, 0.57331),
(90, 3, 0.59726),
(91, 3, 0.59096),
(92, 3, 0.58137),
(93, 3, 0.58308),
(94, 3, 0.61735),
(95, 3, 0.56689),
(96, 3, 0.54981),
(97, 3, 0.58381),
(98, 3, 0.55507),
(99, 3, 0.51661);

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

-- 
-- Table structure for table `projections`
-- 

CREATE TABLE IF NOT EXISTS `projections` (
  `id_class` mediumint(8) unsigned NOT NULL,
  `dimension` mediumint(8) unsigned NOT NULL,
  `position` float NOT NULL,
  KEY `id_class` (`id_class`),
  KEY `dimension` (`dimension`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `projections`
-- 

INSERT INTO `projections` (`id_class`, `dimension`, `position`) VALUES 
(1, 1, -1),
(1, 2, -1),
(2, 1, 0),
(2, 2, 1),
(3, 1, 1),
(3, 2, 0);