localhost_copy.sql

-- Adminer 4.2.5 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

CREATE DATABASE `crawler` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `crawler`;

DROP TABLE IF EXISTS `domain`;
CREATE TABLE `domain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(999) CHARACTER SET utf8 NOT NULL,
  `location` varchar(250) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `domain` (`id`, `path`, `location`) VALUES
(1,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex',	'jablonec'),
(3,	'c:\\\\Users\\Lubos\\Documents',	'testLocation');

DROP TABLE IF EXISTS `keywords`;
CREATE TABLE `keywords` (
  `keywordId` int(11) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(250) NOT NULL,
  PRIMARY KEY (`keywordId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `keywords` (`keywordId`, `keyword`) VALUES
(1,	'Changing'),
(2,	'CAD'),
(3,	'import'),
(4,	'reader'),
(5,	'in'),
(6,	'DesignModeler'),
(7,	'WB13.docx'),
(8,	'TS'),
(9,	'CAE'),
(10,	'NVH'),
(11,	'B10'),
(12,	'Bracket'),
(13,	'Deflection'),
(14,	'Re1.1'),
(15,	'20130321.docx'),
(16,	''),
(17,	'sjabcz'),
(18,	'vyv'),
(19,	'fs2'),
(20,	'04'),
(21,	'Knowledge'),
(22,	'base'),
(23,	'testReindex'),
(24,	'docx'),
(25,	'No'),
(26,	'content'),
(27,	'to'),
(28,	'read'),
(29,	'pad'),
(30,	'sensitivy'),
(31,	'hgi'),
(32,	'extract.pdf'),
(33,	'1'),
(34,	'lining'),
(35,	'mat'),
(36,	'model'),
(37,	'etek'),
(38,	'measurements.pdf'),
(39,	'2'),
(40,	'LiningStiffness'),
(41,	'dyanmicl'),
(42,	'trw.pdf'),
(43,	'alexandria.pdf'),
(44,	'testPdf.pdf'),
(45,	'pdf'),
(46,	'Property'),
(47,	'Identification\r\n\r\nExtract'),
(48,	'from'),
(49,	'Identification'),
(50,	'Frequency'),
(51,	'Sensitivity\r\nHans'),
(52,	'Giese'),
(53,	'Koblenz,'),
(54,	'2010,'),
(55,	'January'),
(56,	'update,'),
(57,	'February'),
(58,	'Last'),
(59,	'update'),
(60,	'March'),
(61,	'Extract,'),
(62,	'April'),
(63,	'01\r\nHans'),
(64,	'Giese,'),
(65,	'Dr.'),
(66,	'Ing'),
(67,	'Specialist'),
(68,	'CAE\r\nTRW'),
(69,	'Automotive'),
(70,	'Lucas'),
(71,	'Varity'),
(72,	'GmbH'),
(73,	'Carl'),
(74,	'Spaeter'),
(75,	'Straße'),
(76,	'3'),
(77,	'D'),
(78,	'Koblenz'),
(79,	'+49(0)261895'),
(80,	'5'),
(81,	'hans'),
(82,	'martin.giese@trw.com\r\n\r\n©'),
(83,	'TRW'),
(84,	'Holdings'),
(85,	'Corp.'),
(86,	'2009\r\n\r\nLining'),
(87,	'Identification\r\nStandard'),
(88,	'Approach'),
(89,	'for'),
(90,	'Material'),
(91,	'frf\r\n\r\n'),
(92,	'calculate'),
(93,	'eigenfrequencies'),
(94,	'(or'),
(95,	'response'),
(96,	'functions)'),
(97,	'using'),
(98,	'assumed'),
(99,	'properties'),
(100,	'measure'),
(101,	'(frequency'),
(102,	'responses'),
(103,	'most'),
(104,	'cases)'),
(105,	'determine'),
(106,	'achieving'),
(107,	'best'),
(108,	'match'),
(109,	'of'),
(110,	'calculated'),
(111,	'vs.'),
(112,	'measured'),
(113,	'single'),
(114,	'property:'),
(115,	'updated'),
(116,	'directly'),
(117,	'shift'),
(118,	'factor'),
(119,	'multiple'),
(120,	'properties:'),
(121,	'solve'),
(122,	'optimization'),
(123,	'problem'),
(124,	'minimizing'),
(125,	'the'),
(126,	'deviation'),
(127,	'(e.g.'),
(128,	'least'),
(129,	'error'),
(130,	'squares)\r\n\r\n©'),
(131,	'2009\r\n\r\n2\r\n\r\nLining'),
(132,	'Identification\r\n\r\nInverse'),
(133,	'Updating'),
(134,	'with'),
(135,	'Eigenfrequencies\r\nThe'),
(136,	'„Standard'),
(137,	'Approach“'),
(138,	'Parameter'),
(139,	'parametric'),
(140,	'NASTRAN'),
(141,	'SOL'),
(142,	'200\r\n\r\nObjective\r\n\r\n'),
(143,	'f'),
(144,	'i'),
(145,	'FE'),
(146,	''),
(147,	'Min('),
(148,	'(cij'),
(149,	','),
(150,	'ρ'),
(151,	'l'),
(152,	')'),
(153,	'='),
(154,	'∑'),
(155,	'wi'),
(156,	''),
(157,	'1'),
(158,	'−'),
(159,	'Meas'),
(160,	''),
(161,	''),
(162,	'\r\n\r\n2\r\n\r\nwi'),
(163,	'weight'),
(164,	'factors,'),
(165,	'fFEi'),
(166,	'eigenfrequency,'),
(167,	'fmeasi'),
(168,	'eigenfrequency\r\n\r\nConstraints:\r\n\r\nMlow'),
(169,	'≤'),
(170,	'M(ρl)'),
(171,	'Mupper;\r\n\r\nflow,k'),
(172,	'fk'),
(173,	'fupper,k\r\n\r\nused'),
(174,	'estimate'),
(175,	'density'),
(176,	'ρl'),
(177,	'material\r\n\r\n©'),
(178,	'2009\r\n\r\n3\r\n\r\nLining'),
(179,	'„Alternative'),
(180,	'properties:\r\n2'),
(181,	'Objective'),
(182,	'('),
(183,	'(M'),
(184,	'M'),
(185,	'meas\r\n\r\nMin('),
(186,	'Weight\r\n\r\nused'),
(187,	'or'),
(188,	'„dummy'),
(189,	'function“'),
(190,	'if'),
(191,	'mass'),
(192,	'is'),
(193,	'correlated'),
(194,	'Constraints:\r\n\r\nfi\r\n\r\nmeas\r\n\r\n−'),
(195,	'∆f'),
(196,	'(cik'),
(197,	'i\r\n\r\nFE\r\n\r\nmeas\r\n\r\n+'),
(198,	'∆f\r\n\r\nminimize'),
(199,	'constraint'),
(200,	'violation'),
(201,	'sensitivity'),
(202,	'respsonses'),
(203,	'=>'),
(204,	'each'),
(205,	'available'),
(206,	'this'),
(207,	'formulation\r\n\r\n©'),
(208,	'2009\r\n\r\n4\r\n\r\nLining'),
(209,	'Identification\r\nthe'),
(210,	'a'),
(211,	'identified'),
(212,	'inversily'),
(213,	'related'),
(214,	'can'),
(215,	'only'),
(216,	'be'),
(217,	'these'),
(218,	'are'),
(219,	'sensitive'),
(220,	'property\r\n\r\n=>'),
(221,	'„sensitivities“'),
(222,	'known'),
(223,	'before'),
(224,	'SOL200)\r\n\r\nSensitivity'),
(225,	'fj'),
(226,	'Cik'),
(227,	':'),
(228,	'normalized:\r\n\r\ndfj'),
(229,	'dCik'),
(230,	'(dfj'),
(231,	'fj)'),
(232,	'(dCik'),
(233,	'Cik)\r\n\r\n=>'),
(234,	'dfj'),
(235,	'influenced'),
(236,	'by'),
(237,	'geometry'),
(238,	'and'),
(239,	'!\r\n\r\n©'),
(240,	'2009\r\n\r\n5\r\n\r\nLining'),
(241,	'Identification\r\nMethods'),
(242,	'Calculation'),
(243,	'SOL200:'),
(244,	'dCik\r\n'),
(245,	'may'),
(246,	'done'),
(247,	'one'),
(248,	'analysis:'),
(249,	'DSAPRT(END=SENS)'),
(250,	'ALL'),
(251,	'DSAPRT(START'),
(252,	'FIRST,BY'),
(253,	'1,END'),
(254,	'LAST)'),
(255,	'ALL\r\n\r\n'),
(256,	'writes'),
(257,	'tables'),
(258,	'sensitivities'),
(259,	'(DRESPi)'),
(260,	'design'),
(261,	'variables'),
(262,	'(DESVARj):\r\n\r\nSolver'),
(263,	'Independent:\r\n\r\n“numerical'),
(264,	'differentiation”\r\n\r\n'),
(265,	'needs'),
(266,	'6'),
(267,	'+'),
(268,	'7'),
(269,	'runs:'),
(270,	'reference'),
(271,	'runs'),
(272,	'modified'),
(273,	'Templates'),
(274,	'(see'),
(275,	'8'),
(276,	'freq'),
(277,	'template.ppt)\r\n\r\n©'),
(278,	'2009\r\n\r\n6\r\n\r\nLining'),
(279,	'Identification\r\nLining'),
(280,	'–'),
(281,	'Procedure'),
(282,	'Verification:\r\n(example'),
(283,	'Daimler'),
(284,	'MFA'),
(285,	'16inch'),
(286,	'front'),
(287,	'w'),
(288,	'template)\r\n\r\n„pad'),
(289,	'(numerical'),
(290,	'differentiation)\r\nEigenfrequency'),
(291,	'Sensitivity\r\n0.25\r\n\r\n0.2\r\n\r\n0.15\r\n\r\n0.1\r\n\r\ndf'),
(292,	'dc11'),
(293,	'df'),
(294,	'dc13'),
(295,	'dc33'),
(296,	'dc44'),
(297,	'dc55\r\n\r\nSol'),
(298,	'200:'),
(299,	'„normalized“(dfj'),
(300,	'dCik)\r\n(dfi'),
(301,	'fi)'),
(302,	'(Cjk'),
(303,	'dCjk)\r\n0.25\r\n\r\n0.05\r\n\r\n0.2'),
(304,	'9'),
(305,	'10'),
(306,	'11'),
(307,	'12'),
(308,	'13'),
(309,	'14'),
(310,	'15'),
(311,	'17'),
(312,	'18'),
(313,	'0.15'),
(314,	'0.05'),
(315,	'dC'),
(316,	'0.1'),
(317,	'C11'),
(318,	'C13'),
(319,	'C33'),
(320,	'C44'),
(321,	'C55\r\n\r\n0.05\r\n\r\n0'),
(322,	'3131.6'),
(323,	'4472.9'),
(324,	'6605.6'),
(325,	'8321.4'),
(326,	'9936.4'),
(327,	'19'),
(328,	'20'),
(329,	'21'),
(330,	'13372\r\n\r\n'),
(331,	'[Hz]\r\n\r\n©'),
(332,	'2009\r\n\r\n7\r\n\r\nLining'),
(333,	'Identification\r\nElastic'),
(334,	'Law'),
(335,	'Checks:\r\nThe'),
(336,	'work'),
(337,	'stresses'),
(338,	'σ'),
(339,	'on'),
(340,	'strains'),
(341,	'ε'),
(342,	'an'),
(343,	'elastic'),
(344,	'body'),
(345,	'positive'),
(346,	'number'),
(347,	'!\r\n1'),
(348,	'T'),
(349,	'σV'),
(350,	'≥'),
(351,	'2\r\n\r\nσ'),
(352,	'k\r\n\r\n1'),
(353,	'V'),
(354,	'(ε'),
(355,	'k'),
(356,	'Vε'),
(357,	'Cε'),
(358,	'22'),
(359,	'2\r\n\r\nε'),
(360,	'0\r\n\r\nTest'),
(361,	'Case'),
(362,	'hydrostatic'),
(363,	'pressure'),
(364,	'state'),
(365,	'(no'),
(366,	'shear)\r\nσdV'),
(367,	'dV'),
(368,	'A1ε'),
(369,	'1l1'),
(370,	'A2ε'),
(371,	'2l2'),
(372,	'A3ε'),
(373,	'3l3'),
(374,	'23'),
(375,	'1σ'),
(376,	'2σ'),
(377,	'3σ'),
(378,	')V'),
(379,	'0\r\nσ'),
(380,	'C11ε1'),
(381,	'C12ε'),
(382,	'C13ε'),
(383,	'C21ε1'),
(384,	'C22ε'),
(385,	'C23ε'),
(386,	'C31ε1'),
(387,	'C32ε'),
(388,	'C33ε'),
(389,	'3\r\nC11'),
(390,	'C22'),
(391,	'C23'),
(392,	'Cki'),
(393,	'C'),
(394,	'24'),
(395,	'25'),
(396,	'26'),
(397,	')ε'),
(398,	')ε\r\n\r\nε3'),
(399,	'=\r\n\r\n('),
(400,	')\r\n\r\nσ'),
(401,	'33\r\n\r\n('),
(402,	')('),
(403,	'2ε'),
(404,	'ε)'),
(405,	'>'),
(406,	')\r\n2\r\n\r\n=>'),
(407,	'Example'),
(408,	'EU'),
(409,	'template:\r\n\r\n2'),
(410,	'27'),
(411,	'13\r\n\r\nε1'),
(412,	'2\r\nC'),
(413,	'28'),
(414,	'MPa'),
(415,	';'),
(416,	'29'),
(417,	'30'),
(418,	'31'),
(419,	'.'),
(420,	'32'),
(421,	'13\r\n\r\n=>'),
(422,	'physical'),
(423,	'limitations'),
(424,	'!\r\n©'),
(425,	'2009\r\n\r\n8\r\n\r\nLining'),
(426,	'Identification\r\nA'),
(427,	'typical'),
(428,	'european'),
(429,	'brake'),
(430,	'normal.'),
(431,	'Cik):\r\nProject\r\nCustomer'),
(432,	'Vehicle'),
(433,	'Axle'),
(434,	'BMW'),
(435,	'PL3'),
(436,	'CII'),
(437,	'54\r\n\r\nFinite'),
(438,	'Element'),
(439,	'Model\r\nModel'),
(440,	'Mass(FE)'),
(441,	'setup'),
(442,	'411.5'),
(443,	'g'),
(444,	'template'),
(445,	't20p5'),
(446,	'shim'),
(447,	'iso'),
(448,	'14k\r\n\r\ndf'),
(449,	'dc11\r\n0.25\r\n\r\ndf'),
(450,	'dc13\r\n\r\ndf'),
(451,	'dc33\r\n\r\ndf'),
(452,	'dc44\r\n\r\ndf'),
(453,	'dc55\r\n\r\n0.2\r\n\r\n0.15\r\n\r\n0.1\r\n\r\n0.05\r\n\r\n0'),
(454,	'34'),
(455,	'35'),
(456,	'36'),
(457,	'37'),
(458,	'38'),
(459,	'39'),
(460,	'40'),
(461,	'41'),
(462,	'42'),
(463,	'43'),
(464,	'44'),
(465,	'45'),
(466,	'46'),
(467,	'17612\r\n\r\n'),
(468,	'0.05\r\n\r\n'),
(469,	'sufficient'),
(470,	'C11,'),
(471,	'C55'),
(472,	'very'),
(473,	'low\r\n\r\n©'),
(474,	'2009\r\n\r\n9\r\n\r\nLining'),
(475,	'Cik)'),
(476,	'without'),
(477,	'radial'),
(478,	'center'),
(479,	'slot\r\n\r\nProject\r\nCustomer'),
(480,	'PL2'),
(481,	'cut'),
(482,	'close'),
(483,	'359.8'),
(484,	'jurid'),
(485,	'47'),
(486,	'comment'),
(487,	'\"w'),
(488,	'close\"'),
(489,	'14k\r\n\r\nProject\r\nCustomer'),
(490,	'pada'),
(491,	'wshm'),
(492,	'358.5'),
(493,	'radiak'),
(494,	'cut\"'),
(495,	'dc55\r\n0.3\r\n\r\ndf'),
(496,	'dc11\r\n\r\ndf'),
(497,	'dc55\r\n\r\n0.2\r\n\r\n0.25\r\n\r\n0.2\r\n0.15\r\n\r\n0.15\r\n0.1\r\n\r\n0.1\r\n0.05\r\n\r\n0.05\r\n\r\n0'),
(498,	'48'),
(499,	'50'),
(500,	'9526\r\n\r\n10'),
(501,	'kHz\r\n\r\n10015\r\n\r\n10864\r\n\r\n12358\r\n\r\n13216\r\n\r\n14355\r\n\r\n15098\r\n\r\n16299\r\n\r\n17303\r\n\r\n18630\r\n\r\n19109\r\n\r\n0'),
(502,	'51'),
(503,	'52'),
(504,	'53'),
(505,	'55'),
(506,	'10512\r\n\r\n10'),
(507,	'kHz\r\n\r\n11907\r\n\r\n13149\r\n\r\n13438\r\n\r\n14807\r\n\r\n15420\r\n\r\n16438\r\n\r\n16758\r\n\r\n18736\r\n\r\n'),
(508,	'0.05\r\n\r\n©'),
(509,	'2009\r\n\r\n10\r\n\r\n'),
(510,	'56'),
(511,	'Model\r\n\r\nBrake'),
(512,	'Identification\r\nHans'),
(513,	'2011,'),
(514,	'November'),
(515,	'4\r\nHans'),
(516,	'Model\r\nCoordinate'),
(517,	'definitions'),
(518,	'diskbrake'),
(519,	'pad\r\nY,'),
(520,	'direction'),
(521,	'X,'),
(522,	'direction\r\n\r\n3'),
(523,	'(z)'),
(524,	'„axial“'),
(525,	'(y)'),
(526,	'(x)\r\n\r\nZ,'),
(527,	'direction\r\n\r\nAssumption:'),
(528,	'Transversal'),
(529,	'isotropic\r\n'),
(530,	'different'),
(531,	'thickness'),
(532,	'„3“'),
(533,	'direction\r\n\r\n'),
(534,	'interchangeable\r\n\r\n©'),
(535,	'model\r\nTransversal'),
(536,	'isotropic'),
(537,	'Materiallaw'),
(538,	'(NASTRAN'),
(539,	'MAT9'),
(540,	'definitions)'),
(541,	'Orientation'),
(542,	'axis'),
(543,	'influence:'),
(544,	'•'),
(545,	'interchangeable:'),
(546,	'C66,'),
(547,	'C13\r\n\r\n•'),
(548,	'invariant'),
(549,	'rotation'),
(550,	'about'),
(551,	'z'),
(552,	'axis:'),
(553,	'C12)\r\nxx'),
(554,	'yy'),
(555,	'zz'),
(556,	'xy'),
(557,	'yz'),
(558,	'zx'),
(559,	'C12'),
(560,	'C33\r\n1\r\n\r\ncij,low\r\n\r\nxx'),
(561,	'yy'),
(562,	'zz'),
(563,	'xy+yx\r\n\r\n'),
(564,	'2(C11'),
(565,	'C12)'),
(566,	'C55\r\n\r\nyz+zy'),
(567,	'zx+xz\r\n\r\n=>'),
(568,	'independent'),
(569,	'parameters\r\n©'),
(570,	'Engineering'),
(571,	'Constants'),
(572,	'(ANSYS)'),
(573,	'(1)\r\n\r\nOrientation'),
(574,	'1,2'),
(575,	'influence:\r\n•'),
(576,	'interchangeable:\r\nxx'),
(577,	'xy+yx'),
(578,	'yz+zy'),
(579,	'zx+xz\r\n\r\n\r\n=>'),
(580,	'parameters\r\nxx'),
(581,	'Gxy'),
(582,	'Gyz'),
(583,	'Gzx'),
(584,	'zx\r\n\r\n•'),
(585,	'normal'),
(586,	'E'),
(587,	'2(1+'),
(588,	')\r\n1'),
(589,	'Ex'),
(590,	'xy'),
(591,	'xz'),
(592,	'yz'),
(593,	'Ey'),
(594,	'yx'),
(595,	'Ey\r\n\r\n'),
(596,	'zx'),
(597,	'Ez'),
(598,	'zy'),
(599,	'Ez\r\n\r\n'),
(600,	'yx\r\nEy\r\n\r\n\r\n\r\n'),
(601,	'xy\r\nEx\r\n\r\nE'),
(602,	'y'),
(603,	''),
(604,	''),
(605,	''),
(606,	'yx'),
(607,	'xy\r\n\r\n\r\n\r\n'),
(608,	'zx\r\nEz\r\n\r\n\r\n\r\n'),
(609,	'xz\r\nEx\r\n\r\nEz'),
(610,	''),
(611,	'zx'),
(612,	'xz\r\n\r\n©'),
(613,	'(2)\r\n\r\nOrientation'),
(614,	'parameters'),
(615,	')\r\n\r\n•'),
(616,	'Symmetriecondition'),
(617,	'leads'),
(618,	'definition'),
(619,	'minor'),
(620,	'major'),
(621,	'poisson'),
(622,	'ratios\r\n\r\n\r\n\r\n'),
(623,	'yx\r\nEy\r\n\r\n\r\n\r\n\r\n'),
(624,	'xy\r\nEx\r\nEx\r\n\r\nE'),
(625,	'xy\r\nEz'),
(626,	'xz\r\n\r\nin'),
(627,	'plane'),
(628,	'ratios'),
(629,	'equal'),
(630,	'ratios\r\n\r\n'),
(631,	'zx\r\nEz\r\n\r\n'),
(632,	'xz\r\n\r\n\r\n\r\n'),
(633,	'zy\r\nEz\r\n\r\n\r\n\r\n'),
(634,	'yz\r\nEy\r\n\r\nEz'),
(635,	'zy'),
(636,	'yz\r\n\r\n©'),
(637,	'model\r\n\r\nFEA\r\n\r\nTransversal'),
(638,	'Identify'),
(639,	'?\r\nParameter'),
(640,	'Identificatin'),
(641,	'200,'),
(642,	'ANSYS)\r\nObjective:'),
(643,	'Min'),
(644,	'F(cij,'),
(645,	'l)'),
(646,	'wi(1'),
(647,	'(fci'),
(648,	'fmi))2\r\n\r\nwi'),
(649,	'fci'),
(650,	'fmi'),
(651,	'eigenfrequency\r\nConstraints:'),
(652,	'mlow'),
(653,	'm(l)'),
(654,	'mupper;'),
(655,	'densitiy\r\n\r\nfk,low,'),
(656,	'fk,upper\r\ncij,low'),
(657,	'cij'),
(658,	'cij,upper'),
(659,	'cons.\r\n\r\nAt'),
(660,	'necessary'),
(661,	'stiffness'),
(662,	'parameters!\r\n\r\n©'),
(663,	'?\r\n\r\n©'),
(664,	'?\r\nExample'),
(665,	'frf'),
(666,	'current'),
(667,	'project'),
(668,	'BR205\r\n\r\n©'),
(669,	'?\r\nUpdating'),
(670,	'VW'),
(671,	'PQ35\r\nEigenfrequenzen'),
(672,	'Beläge'),
(673,	'Kolbenseite'),
(674,	'PQ35GP'),
(675,	'VA'),
(676,	'C57\r\nB2'),
(677,	'KS'),
(678,	'[g'),
(679,	'N]'),
(680,	'wo'),
(681,	'shm'),
(682,	'fer'),
(683,	'c13p1k\r\n2058'),
(684,	'4570\r\n\r\nSensitivity'),
(685,	'Eigenfrequencies:'),
(686,	'(+56%)\r\n8418'),
(687,	'9611\r\n\r\n70\r\n\r\nB4'),
(688,	'c33p1k\r\n5990'),
(689,	'7283\r\n\r\n60\r\n\r\nC13'),
(690,	'(+490%)\r\n\r\n2021\r\n\r\n2847\r\n\r\n4530\r\n\r\n5977\r\n\r\n7238\r\n\r\n8386\r\n\r\n8829'),
(691,	'8912\r\n\r\n9508\r\n\r\n50\r\n\r\nOriginaldatensatz'),
(692,	'von'),
(693,	'Ferodo\r\n(FER5432)'),
(694,	'„dynamic'),
(695,	'Compressibility“'),
(696,	'C13:'),
(697,	'Couplingstiffness'),
(698,	'axial'),
(699,	'„in'),
(700,	'plane“\r\n\r\n2081'),
(701,	'2056\r\n\r\n2849\r\n\r\n4559'),
(702,	'4559\r\n\r\n5986\r\n\r\n7234'),
(703,	'7253\r\n\r\n8416\r\n\r\n8837'),
(704,	'9009\r\n\r\nAmplitude'),
(705,	'[g(N]\r\n\r\n40\r\n\r\n30\r\n\r\n10\r\n\r\n0\r\n\r\n'),
(706,	'Frequenz'),
(707,	'[Hz]'),
(708,	'10000\r\n\r\nEigenfrequencies'),
(709,	'fi'),
(710,	'not'),
(711,	'even'),
(712,	'severe'),
(713,	'changes'),
(714,	'C13\r\n\r\n=>'),
(715,	'don‘t'),
(716,	'tell'),
(717,	'full'),
(718,	'story'),
(719,	'.\r\n©'),
(720,	'2009\r\n\r\n2869'),
(721,	'3009\r\n\r\n5909\r\n\r\n5966'),
(722,	'6072\r\n\r\n20\r\n\r\n9431\r\n\r\n9694\r\n\r\n7178\r\n\r\n8778'),
(723,	'9025\r\n\r\n9580\r\n\r\n9\r\n\r\nLining'),
(724,	'?\r\nProject\r\nCustomer'),
(725,	'Brake\r\n\r\nFinite'),
(726,	'Model\r\nBMW'),
(727,	'R60'),
(728,	'high'),
(729,	'401.1'),
(730,	'dc11\r\n0.3\r\n\r\ndf'),
(731,	'dc55\r\n\r\n0.25\r\n\r\n0.2\r\n\r\n0.15\r\n\r\n0.1\r\n\r\n0.05\r\n\r\n0'),
(732,	'18055\r\n\r\n'),
(733,	'0.1\r\n\r\n©'),
(734,	'2009\r\n\r\n10\r\n\r\nLining'),
(735,	'?'),
(736,	'Audi'),
(737,	'B8\r\nMode'),
(738,	'Hz\r\n40.00%\r\n\r\nD'),
(739,	'(dfi'),
(740,	'(dCjk'),
(741,	'Cjk)\r\nC11'),
(742,	'C55\r\n\r\n30.00%\r\n\r\n20.00%\r\n\r\nMode'),
(743,	'2451Hz\r\n10.00%\r\n\r\nD\r\n0.00%\r\n\r\n1199\r\n\r\n2451\r\n\r\n2711\r\n\r\n3754\r\n\r\n5467\r\n\r\n5815\r\n\r\n7125\r\n\r\n7291\r\n\r\n7670\r\n\r\n8322\r\n\r\n8505\r\n\r\n10067\r\n\r\n10108\r\n\r\n'),
(744,	'10.00%\r\n\r\nMode'),
(745,	'2711Hz\r\n\r\n'),
(746,	'20.00%\r\n\r\n'),
(747,	'30.00%'),
(748,	'[Hz]\r\n\r\nsensitivity'),
(749,	'at'),
(750,	'low'),
(751,	'frequencies'),
(752,	'surprisingly'),
(753,	'2009\r\n\r\n11\r\n\r\n10442\r\n\r\nLining'),
(754,	'model\r\nUltrasoundwave:'),
(755,	'travelling'),
(756,	'displacement'),
(757,	'measurements'),
(758,	'cubic'),
(759,	'test'),
(760,	'specimen\r\nin'),
(761,	'out'),
(762,	'v32'),
(763,	'=v31'),
(764,	'=C66\r\n\r\nFEA\r\n\r\nv22'),
(765,	'=v11'),
(766,	'v21'),
(767,	'v12'),
(768,	'C44\r\n\r\nv33'),
(769,	'C33\r\n\r\n=>'),
(770,	'2C44\r\n©'),
(771,	'2009\r\n\r\nC13'),
(772,	'??\r\n12\r\n\r\nLining'),
(773,	'model\r\n\r\nFEA\r\n\r\nUltrasoundwave:'),
(774,	'Measurement'),
(775,	'special'),
(776,	'specimen'),
(777,	'shape'),
(778,	'Stiffnesses'),
(779,	'ultrasoundvelocities\r\nPlane'),
(780,	'waves'),
(781,	'material:'),
(782,	'compressionwave'),
(783,	'45°'),
(784,	'inclination'),
(785,	'x'),
(786,	'plane:'),
(787,	'dT'),
(788,	'u0,'),
(789,	'v0,'),
(790,	'w0)'),
(791,	'mit'),
(792,	'dTx'),
(793,	'0\r\n\r\nassumption:\r\n\r\nu(t,x,z)'),
(794,	'w(t,x,z)\r\n\r\n='),
(795,	'=\r\n\r\nu0'),
(796,	'sin('),
(797,	''),
(798,	'kux'),
(799,	'kuz'),
(800,	'z)'),
(801,	'w0'),
(802,	'kwx'),
(803,	'kwz'),
(804,	'z)\r\n\r\n'),
(805,	'2'),
(806,	'u0'),
(807,	'u0C11'),
(808,	'kux2'),
(809,	'w0C13'),
(810,	'u0C66'),
(811,	'kuz2'),
(812,	'w0C66'),
(813,	''),
(814,	'C66'),
(815,	'C31'),
(816,	'kwz2'),
(817,	'wave:'),
(818,	'('),
(819,	'kux)'),
(820,	'kwx)'),
(821,	'kwz)'),
(822,	'k\r\n\r\nwith'),
(823,	'c2'),
(824,	'cux2'),
(825,	'cwx2'),
(826,	'=\r\n\r\n('),
(827,	'kux)2'),
(828,	'kwx)2'),
(829,	'k)2\r\n\r\n©'),
(830,	'2009\r\n\r\n13\r\n\r\nLining'),
(831,	'model\r\n“ETEK”:'),
(832,	'definition\r\n\r\n©'),
(833,	'2009\r\n\r\n14\r\n\r\nLining'),
(834,	'–”intact'),
(835,	'measurement”\r\nwaves'),
(836,	'direction:'),
(837,	'p'),
(838,	'wave'),
(839,	's'),
(840,	'(1)'),
(841,	'(2)\r\n\r\nSuccession'),
(842,	'layers'),
(843,	'Transit'),
(844,	'time:'),
(845,	'Tbackplate'),
(846,	'Tlining\r\n©'),
(847,	'2009\r\n\r\n15\r\n\r\nLining'),
(848,	'(ETEK'),
(849,	'Don'),
(850,	'Yuhas'),
(851,	'definitions)\r\n\r\nOrientation'),
(852,	'C44,'),
(853,	'C55\r\n1\r\n\r\nxx'),
(854,	'xz+zx'),
(855,	'yx+xy\r\n\r\n=>'),
(856,	'2009\r\n\r\n16\r\n\r\nLining'),
(857,	'model\r\nTRW'),
(858,	'Noise'),
(859,	'Matrix'),
(860,	'Computer'),
(861,	'Test\r\n\r\nNVH'),
(862,	'Test\r\n\r\nComputer'),
(863,	'Test\r\nComplex'),
(864,	'Eigenvalue'),
(865,	'Analysis'),
(866,	'CEA'),
(867,	'several'),
(868,	'levels'),
(869,	'temperature'),
(870,	'levels\r\n\r\n10%'),
(871,	'9%'),
(872,	'8%'),
(873,	'CMT'),
(874,	'C16'),
(875,	'15\r\n\r\nNegative'),
(876,	'damping\r\n\r\n7%'),
(877,	'6%'),
(878,	'5%'),
(879,	'4%'),
(880,	'3%'),
(881,	'2%'),
(882,	'1%'),
(883,	'0%'),
(884,	'1000\r\n\r\n2000\r\n\r\n3000\r\n\r\n4000\r\n\r\n5000\r\n\r\n6000\r\n\r\n7000\r\n\r\n8000\r\n\r\n9000\r\n\r\n10000\r\n\r\nFrequency'),
(885,	'2009\r\n\r\n17\r\n\r\nLining'),
(886,	'Test\r\n\r\n©'),
(887,	'2009\r\n\r\n18\r\n\r\nLining'),
(888,	'(Livonia'),
(889,	'Rig)'),
(890,	'Draft'),
(891,	'Specification:'),
(892,	'„Die'),
(893,	'Messung'),
(894,	'erfolgt'),
(895,	'auf'),
(896,	'mindestens'),
(897,	'vier'),
(898,	'Temperaturniveaus,'),
(899,	'die'),
(900,	'Raumtemperatur'),
(901,	'20o'),
(902,	'C,'),
(903,	'100o'),
(904,	'200o'),
(905,	'und'),
(906,	'300o'),
(907,	'drei'),
(908,	'Druckstufen'),
(909,	'bar,'),
(910,	'bar'),
(911,	'enthalten.“'),
(912,	'Proposal'),
(913,	'Enhancement'),
(914,	'(Draft):'),
(915,	'Data'),
(916,	'specified'),
(917,	'gained'),
(918,	'interpolation'),
(919,	'(!)'),
(920,	'arbitrary'),
(921,	'„NVH'),
(922,	'intervall“'),
(923,	'replaced'),
(924,	'„one'),
(925,	'direction“'),
(926,	'measurements,\r\n\r\nCubic'),
(927,	'sample'),
(928,	'(all'),
(929,	'Cij)'),
(930,	'Intact'),
(931,	'Pads'),
(932,	'(C13'),
(933,	'av.)\r\n\r\n©'),
(934,	'2009\r\n\r\n19\r\n\r\nLining'),
(935,	'model\r\nTransfer'),
(936,	'(1'),
(937,	'MHz)'),
(938,	'range'),
(939,	'(10'),
(940,	'kHz)'),
(941,	'Correlation'),
(942,	'Verification'),
(943,	'Recorrelation\r\nPad'),
(944,	'Data:'),
(945,	'some'),
(946,	'cases'),
(947,	'up'),
(948,	'30%'),
(949,	'overestimate'),
(950,	'lining'),
(951,	'dependent'),
(952,	'(viscoelastic)\r\n\r\nRecorrelation:\r\n1.'),
(953,	'„stiffness'),
(954,	'correction'),
(955,	'factor“'),
(956,	'2.'),
(957,	'(Optimisation)'),
(958,	'startv.\r\n\r\n©'),
(959,	'2009\r\n\r\n20\r\n\r\nLining'),
(960,	'model\r\nETEK'),
(961,	'Measurements:'),
(962,	'Consequences'),
(963,	'loss'),
(964,	't300p5\r\nRenault'),
(965,	'Colette'),
(966,	'Galfer'),
(967,	'A1'),
(968,	'Room'),
(969,	'Mode'),
(970,	'nor'),
(971,	'10.67'),
(972,	'3.48'),
(973,	'2.26'),
(974,	'4.36'),
(975,	'1.96'),
(976,	'0.94'),
(977,	'3.30'),
(978,	'2.14'),
(979,	'0.93'),
(980,	'1.00'),
(981,	'10.56'),
(982,	'2.91'),
(983,	'2.02'),
(984,	'1.85'),
(985,	'0.68'),
(986,	'50°C'),
(987,	'9.86'),
(988,	'2.17'),
(989,	'4.27'),
(990,	'1.32'),
(991,	'0.91'),
(992,	'10.17'),
(993,	'3.06'),
(994,	'2.04'),
(995,	'4.19'),
(996,	'1.79'),
(997,	'0.89'),
(998,	'2.71'),
(999,	'1.92'),
(1000,	'1.63'),
(1001,	'0.66'),
(1002,	'100°C'),
(1003,	'9.29'),
(1004,	'2.98'),
(1005,	'2.08'),
(1006,	'4.02'),
(1007,	'1.25'),
(1008,	'0.87'),
(1009,	'2.65'),
(1010,	'0.85'),
(1011,	'2.37'),
(1012,	'1.74'),
(1013,	'0.61'),
(1014,	'200°C'),
(1015,	'8.28'),
(1016,	'1.81'),
(1017,	'3.73'),
(1018,	'0.82'),
(1019,	'0.78'),
(1020,	'8.52'),
(1021,	'2.31'),
(1022,	'1.78'),
(1023,	'3.66'),
(1024,	'1.20'),
(1025,	'1.65'),
(1026,	'0.56'),
(1027,	'300°C'),
(1028,	'8.05'),
(1029,	'2.47'),
(1030,	'1.62'),
(1031,	'3.46'),
(1032,	'1.13'),
(1033,	'0.71'),
(1034,	'1.59'),
(1035,	'3.40'),
(1036,	'7.84'),
(1037,	'1.89'),
(1038,	'3.34'),
(1039,	'1.16'),
(1040,	'0.48\r\n\r\nC22'),
(1041,	'normalization'),
(1042,	'scaling'),
(1043,	'factors\r\n\r\n10.56'),
(1044,	'Put'),
(1045,	'ambient'),
(1046,	'value'),
(1047,	'specific'),
(1048,	'used'),
(1049,	'elevated'),
(1050,	'run'),
(1051,	'1.00\r\n\r\n0.04'),
(1052,	'0.02'),
(1053,	'0.03\r\n\r\n0.05'),
(1054,	'0.04'),
(1055,	'0.04\r\n\r\n0.05'),
(1056,	'0.04\r\n\r\n0.04'),
(1057,	'0.06'),
(1058,	'0.05\r\n\r\n0.06'),
(1059,	'0.05\r\n\r\n0.09'),
(1060,	'0.08\r\n\r\n0.13'),
(1061,	'0.07'),
(1062,	'0.10\r\n\r\n0.07'),
(1063,	'0.09'),
(1064,	'0.08\r\n\r\n0.05'),
(1065,	'0.07\r\n\r\n0.10'),
(1066,	'0.09\r\n\r\n0.11'),
(1067,	'0.09\r\n\r\n0.20'),
(1068,	'0.14\r\n\r\n©'),
(1069,	'2009\r\n\r\n21\r\n\r\nLining'),
(1070,	'model\r\nTypical'),
(1071,	'Matrix\r\nExtrapolation'),
(1072,	't300p5'),
(1073,	'Observations'),
(1074,	'(C11,'),
(1075,	'C33,'),
(1076,	'C13,'),
(1077,	'C66)'),
(1078,	'other'),
(1079,	'combination\r\nC33'),
(1080,	'5000.0'),
(1081,	'4000.0'),
(1082,	'3000.0'),
(1083,	'2000.0'),
(1084,	'1000.0'),
(1085,	'0.0'),
(1086,	'bar\r\n4500.0'),
(1087,	'3500.0'),
(1088,	'2500.0'),
(1089,	'1500.0'),
(1090,	'500.0'),
(1091,	'C33\r\n\r\nT20'),
(1092,	'T100'),
(1093,	'T200'),
(1094,	'T300\r\n\r\n'),
(1095,	'points'),
(1096,	'extrapolation'),
(1097,	'p5'),
(1098,	'curve\r\n'),
(1099,	'<'),
(1100,	'curves'),
(1101,	'C33(T)'),
(1102,	'(?)\r\n\r\n'),
(1103,	't300'),
(1104,	'C33(p)'),
(1105,	'curve'),
(1106,	'curvature'),
(1107,	'over'),
(1108,	'!\r\n\r\nExample:'),
(1109,	'Renault'),
(1110,	'A2\r\n©'),
(1111,	'2009\r\n\r\n22\r\n\r\nLining'),
(1112,	'Matrix\r\n'),
(1113,	'12pt'),
(1114,	'general'),
(1115,	'ANSYS'),
(1116,	'20110418.xls\r\n\r\n©'),
(1117,	'2009\r\n\r\n23\r\n\r\nETEK'),
(1118,	'Sources\r\nConstraints'),
(1119,	'original'),
(1120,	'expensive'),
(1121,	'enhanced'),
(1122,	'(interpolation)'),
(1123,	'feasible'),
(1124,	'rigs'),
(1125,	'reduce'),
(1126,	'cost'),
(1127,	'but'),
(1128,	'do'),
(1129,	'deliver'),
(1130,	'C13\r\n\r\nData'),
(1131,	'Sources\r\nTRW'),
(1132,	'testrig'),
(1133,	'Livonia'),
(1134,	'Cij(p)'),
(1135,	'only,'),
(1136,	'Cij(p,T)'),
(1137,	'Suppliers:'),
(1138,	'request'),
(1139,	'as'),
(1140,	'part'),
(1141,	'sheet'),
(1142,	'FERODO,'),
(1143,	'GALFER:'),
(1144,	'IMS'),
(1145,	'JURID:'),
(1146,	'„Hybrid“'),
(1147,	'estimates'),
(1148,	'!)'),
(1149,	'TMD:'),
(1150,	'outsorcing'),
(1151,	'(Don'),
(1152,	'Yuhas)\r\n©'),
(1153,	'2009\r\n\r\n24\r\n\r\n'),
(1154,	'Benchmark'),
(1155,	'Inverse'),
(1156,	'Alco\r\n\r\nKoblenz,'),
(1157,	'28.6.2013'),
(1158,	'04.09.2013\r\nHans'),
(1159,	'2012\r\n\r\nInsert'),
(1160,	'Presentation'),
(1161,	'Name'),
(1162,	'&'),
(1163,	'Date'),
(1164,	'Here\r\n\r\n1\r\n\r\nScope\r\n'),
(1165,	'Characterization'),
(1166,	'materials'),
(1167,	'methodologies'),
(1168,	''),
(1169,	'Linings:\r\n\r\nECE:'),
(1170,	'NAO:'),
(1171,	'Ceramic:\r\n\r\nGalfer'),
(1172,	'NCF050'),
(1173,	'Pagid'),
(1174,	'P40'),
(1175,	'3W\r\n\r\n'),
(1176,	'approaches\r\n\r\nEigenfrequencies'),
(1177,	'Compress'),
(1178,	'ALCO'),
(1179,	'ETEK\r\n•'),
(1180,	'SAE'),
(1181,	'standard'),
(1182,	'40x40'),
(1183,	'mm'),
(1184,	'specimen\r\n\r\nDCTR'),
(1185,	'DCSTR\r\n\r\n©'),
(1186,	'2012\r\n\r\nCompress'),
(1187,	'Setup\r\n\r\nECE'),
(1188,	'(Galfer'),
(1189,	'8)\r\nDensity:'),
(1190,	'2.52'),
(1191,	'2.55'),
(1192,	'cm³'),
(1193,	'Porosity:'),
(1194,	'22%\r\n\r\nNAO'),
(1195,	'NCF050)\r\nDensity:'),
(1196,	'2.40'),
(1197,	'2.41'),
(1198,	'19.4%'),
(1199,	'20%\r\n\r\nCeramic'),
(1200,	'Application'),
(1201,	'(Pagid'),
(1202,	'3W)\r\nDensity:'),
(1203,	'3,06g'),
(1204,	'???%\r\n\r\n©'),
(1205,	'2012\r\n\r\nCompressibility'),
(1206,	'measurement\r\n\r\n3\r\n\r\nFRF'),
(1207,	'Measurement\r\nFile:'),
(1208,	'Damp'),
(1209,	'dyn'),
(1210,	'summary.xlsx\r\n\r\nECE'),
(1211,	'22%\r\nPad'),
(1212,	'ECE'),
(1213,	'Bending'),
(1214,	'Torsional'),
(1215,	'Damping'),
(1216,	'[%]'),
(1217,	'1.02'),
(1218,	'1.39'),
(1219,	'1.38'),
(1220,	'1.1'),
(1221,	'1.31'),
(1222,	'1.35'),
(1223,	'1.44'),
(1224,	'1.18'),
(1225,	'1.3'),
(1226,	'0.95'),
(1227,	'1.28'),
(1228,	'1.07'),
(1229,	'1.19'),
(1230,	'1.41'),
(1231,	'1.34'),
(1232,	'1.22'),
(1233,	'1.26'),
(1234,	'1.09'),
(1235,	'1.12'),
(1236,	'1.49'),
(1237,	'1.42'),
(1238,	'1.04'),
(1239,	'1.37'),
(1240,	'1.24'),
(1241,	'1.27'),
(1242,	'57'),
(1243,	'58'),
(1244,	'59'),
(1245,	'1.51'),
(1246,	'60'),
(1247,	'61'),
(1248,	'62'),
(1249,	'63'),
(1250,	'1.47'),
(1251,	'64'),
(1252,	'65'),
(1253,	'66'),
(1254,	'1.58'),
(1255,	'67'),
(1256,	'1.29'),
(1257,	'68'),
(1258,	'69'),
(1259,	'1.52'),
(1260,	'70'),
(1261,	'71'),
(1262,	'1.46'),
(1263,	'72'),
(1264,	'1.43'),
(1265,	'1.44\r\n\r\n©'),
(1266,	'measurement\r\n\r\n4\r\n\r\nFRF'),
(1267,	'22%\r\n\r\nCorrelation\r\nmax'),
(1268,	'dev'),
(1269,	'0.54'),
(1270,	'73'),
(1271,	'74'),
(1272,	'75'),
(1273,	'76'),
(1274,	'77'),
(1275,	'78'),
(1276,	'79'),
(1277,	'80'),
(1278,	'81'),
(1279,	'82'),
(1280,	'83'),
(1281,	'84'),
(1282,	'85'),
(1283,	'86'),
(1284,	'87'),
(1285,	'88'),
(1286,	'89'),
(1287,	'90'),
(1288,	'18396\r\n©'),
(1289,	'2012\r\n\r\n%'),
(1290,	'%'),
(1291,	'91'),
(1292,	'dev.'),
(1293,	'0.09%'),
(1294,	'0.15%'),
(1295,	'0.00%'),
(1296,	'0.26%'),
(1297,	'0.54%'),
(1298,	'100.00%'),
(1299,	'0.22%'),
(1300,	'100.00%\r\n\r\n!'),
(1301,	't20'),
(1302,	'generic'),
(1303,	'MAT2'),
(1304,	'MP,'),
(1305,	'EX,'),
(1306,	'2,'),
(1307,	'16940.'),
(1308,	'EY,'),
(1309,	'EZ,'),
(1310,	'3654.7'),
(1311,	'!'),
(1312,	'GXY=EX'),
(1313,	'(1+PRXY)'),
(1314,	'GXY,'),
(1315,	'5844.3'),
(1316,	'GYZ,'),
(1317,	'4483.3'),
(1318,	'GXZ,'),
(1319,	'DENS,2,'),
(1320,	'3.172E'),
(1321,	'92'),
(1322,	'PRXY,2,'),
(1323,	'0.44928'),
(1324,	'PRYZ,2,'),
(1325,	'0.89140E'),
(1326,	'01'),
(1327,	'PRXZ,2,'),
(1328,	'0.08914'),
(1329,	'!\r\n\r\nCompressibility'),
(1330,	'measurement\r\n\r\n5\r\n\r\nFRF'),
(1331,	'22%\r\n\r\nStartvector'),
(1332,	'1\r\nWith'),
(1333,	'93'),
(1334,	'MPa\r\nCorrelation'),
(1335,	'ECE168'),
(1336,	'Opt3'),
(1337,	'94'),
(1338,	'95'),
(1339,	'0.22%\r\nCorrelation'),
(1340,	'ez4600'),
(1341,	'4600.0'),
(1342,	'max'),
(1343,	'0.17'),
(1344,	'0.30'),
(1345,	'96'),
(1346,	'0.05%'),
(1347,	'97'),
(1348,	'0.17%'),
(1349,	'98'),
(1350,	'0.13%'),
(1351,	'99'),
(1352,	'0.18%'),
(1353,	'0.30%'),
(1354,	'101'),
(1355,	'102'),
(1356,	'103'),
(1357,	'0.51%\r\n\r\nStartvector'),
(1358,	'2\r\nWith'),
(1359,	'Ez=2500'),
(1360,	'Opt4'),
(1361,	'104'),
(1362,	'105'),
(1363,	'0.12'),
(1364,	'106'),
(1365,	'0.12%'),
(1366,	'107'),
(1367,	'0.03%'),
(1368,	'108'),
(1369,	'0.25%'),
(1370,	'109'),
(1371,	'110'),
(1372,	'111'),
(1373,	'112'),
(1374,	'0.18%\r\n\r\n=>'),
(1375,	'stable'),
(1376,	'startvectors\r\n\r\n©'),
(1377,	'measurement\r\n\r\n6\r\n\r\nFRF'),
(1378,	'(opt'),
(1379,	'3)\r\n\r\nStartvector'),
(1380,	'6)\r\n\r\nStartvector'),
(1381,	'4)\r\n\r\nStartvector'),
(1382,	'113'),
(1383,	'7)\r\n\r\nStartvector'),
(1384,	'5)'),
(1385,	'~'),
(1386,	'114'),
(1387,	'MPa\r\n\r\n©'),
(1388,	'measurement\r\n\r\n7\r\n\r\nFRF'),
(1389,	'Measurement\r\nNAO'),
(1390,	'20%\r\nPad'),
(1391,	'NAO'),
(1392,	'115'),
(1393,	'116'),
(1394,	'117'),
(1395,	'118'),
(1396,	'119'),
(1397,	'120'),
(1398,	'121'),
(1399,	'122'),
(1400,	'123'),
(1401,	'124'),
(1402,	'125'),
(1403,	'1.21'),
(1404,	'126'),
(1405,	'1.95'),
(1406,	'127'),
(1407,	'2.22'),
(1408,	'128'),
(1409,	'129'),
(1410,	'1.83'),
(1411,	'130'),
(1412,	'2.16'),
(1413,	'131'),
(1414,	'132'),
(1415,	'2.09'),
(1416,	'133'),
(1417,	'134'),
(1418,	'135'),
(1419,	'2.13'),
(1420,	'136'),
(1421,	'1.2'),
(1422,	'1.97'),
(1423,	'137'),
(1424,	'2.18'),
(1425,	'138'),
(1426,	'1.99'),
(1427,	'139'),
(1428,	'140'),
(1429,	'141'),
(1430,	'1.98'),
(1431,	'142'),
(1432,	'2.12'),
(1433,	'143'),
(1434,	'144'),
(1435,	'1.77'),
(1436,	'145'),
(1437,	'2.03'),
(1438,	'146'),
(1439,	'1.84'),
(1440,	'147'),
(1441,	'2.07'),
(1442,	'148'),
(1443,	'1.75'),
(1444,	'149'),
(1445,	'1.91'),
(1446,	'150'),
(1447,	'2.2'),
(1448,	'151'),
(1449,	'1.93'),
(1450,	'152'),
(1451,	'153'),
(1452,	'1.15'),
(1453,	'1.88'),
(1454,	'2.11'),
(1455,	'154'),
(1456,	'155'),
(1457,	'1.23'),
(1458,	'156'),
(1459,	'157'),
(1460,	'2.19'),
(1461,	'1.9'),
(1462,	'158'),
(1463,	'159'),
(1464,	'1.82'),
(1465,	'160'),
(1466,	'1.72'),
(1467,	'161'),
(1468,	'162'),
(1469,	'2.06\r\n\r\nNAO77'),
(1470,	'NAO78'),
(1471,	'10279\r\n\r\n©'),
(1472,	'measurement\r\n\r\n8\r\n\r\nFRF'),
(1473,	'20%\r\n\r\nStartvector'),
(1474,	'1\r\nCorrelation'),
(1475,	'163'),
(1476,	'164'),
(1477,	'0.69'),
(1478,	'0.64'),
(1479,	'165'),
(1480,	'0.23%'),
(1481,	'166'),
(1482,	'167'),
(1483,	'0.69%'),
(1484,	'168'),
(1485,	'0.59%'),
(1486,	'169'),
(1487,	'0.64%'),
(1488,	'170'),
(1489,	'171'),
(1490,	'172'),
(1491,	'173'),
(1492,	'174'),
(1493,	'0.77%\r\n\r\nStartvector'),
(1494,	'2\r\nCorrelation'),
(1495,	'175'),
(1496,	'176'),
(1497,	'0.72'),
(1498,	'0.65'),
(1499,	'177'),
(1500,	'178'),
(1501,	'0.72%'),
(1502,	'179'),
(1503,	'0.50%'),
(1504,	'180'),
(1505,	'0.65%'),
(1506,	'181'),
(1507,	'182'),
(1508,	'183'),
(1509,	'184'),
(1510,	'0.97%\r\n\r\n=>'),
(1511,	'measurement\r\n\r\n9\r\n\r\nFRF'),
(1512,	'8)\r\n\r\nStartvector'),
(1513,	'5)\r\n\r\nStartvector'),
(1514,	'6)\r\n\r\n©'),
(1515,	'measurement\r\n\r\n10\r\n\r\nThe'),
(1516,	'Global'),
(1517,	'Leader'),
(1518,	'Safety'),
(1519,	'Systems\r\n\r\n©'),
(1520,	'2012\r\n\r\n11\r\n\r\n'),
(1521,	'185'),
(1522,	'CK'),
(1523,	'ALEXANDRIA'),
(1524,	'nabídka'),
(1525,	'slev'),
(1526,	'pro'),
(1527,	'zaměstnance'),
(1528,	'Czech'),
(1529,	's.r.o\r\nVyužijte'),
(1530,	'momentální'),
(1531,	'zaměstnanecké'),
(1532,	'slevy'),
(1533,	'u'),
(1534,	'cestovní'),
(1535,	'kanceláře'),
(1536,	'ALEXANDRIA.'),
(1537,	'Všem'),
(1538,	'zaměstnancům'),
(1539,	's.r.o.;'),
(1540,	'Jablonec'),
(1541,	'nad'),
(1542,	'Nisou'),
(1543,	'(kmenovým'),
(1544,	'agenturním)'),
(1545,	'nabízí'),
(1546,	'tyto'),
(1547,	'uvedené'),
(1548,	'slevy:'),
(1549,	'Sleva'),
(1550,	'12%'),
(1551,	'na'),
(1552,	'letecké'),
(1553,	'zájezdy'),
(1554,	'10%'),
(1555,	'vlastní'),
(1556,	'autobusovou'),
(1557,	'dopravou'),
(1558,	'MINUTE'),
(1559,	'slevu'),
(1560,	'mají'),
(1561,	'nárok'),
(1562,	'také'),
(1563,	'rodinní'),
(1564,	'příslušníci'),
(1565,	'zaměstnanců'),
(1566,	'případní'),
(1567,	'spolucestující.'),
(1568,	'uplatnění'),
(1569,	'je'),
(1570,	'třeba'),
(1571,	'identifikace'),
(1572,	'firemní'),
(1573,	'kartou'),
(1574,	'zaměstnance.'),
(1575,	'Kompletní'),
(1576,	'nabídku'),
(1577,	'zájezdů'),
(1578,	'naleznete'),
(1579,	'www.alexandria.cz;'),
(1580,	'případně'),
(1581,	'tištěném'),
(1582,	'katalogu'),
(1583,	'pobočce'),
(1584,	'ALEXANDRIA.\r\n\r\nCK'),
(1585,	'ALEXANDRIA\r\nKomenského'),
(1586,	'7;'),
(1587,	'Nisou\r\n\r\nwww.alexandria.cz\r\ntelefon'),
(1588,	'jablonec.@alexandria.cz\r\n\r\n'),
(1589,	'Windchill'),
(1590,	'Download'),
(1591,	'Data\r\n\r\nZF'),
(1592,	'Friedrichshafen'),
(1593,	'AG\r\n\r\n1\r\n\r\n©'),
(1594,	'ZF'),
(1595,	'AG,'),
(1596,	'2015\r\n\r\n'),
(1597,	'JimBeam'),
(1598,	'Coupling'),
(1599,	'evaluation.ppt'),
(1600,	'evaluation'),
(1601,	'results.ppt'),
(1602,	'test.bat'),
(1603,	'ppt'),
(1604,	'summary'),
(1605,	'meeting.pptx'),
(1606,	'How'),
(1607,	'post'),
(1608,	'processing'),
(1609,	'EF.pptx'),
(1610,	'windchill.pptx'),
(1611,	'Simulation'),
(1612,	'Plzen.pptx'),
(1613,	'set'),
(1614,	'it.pptx'),
(1615,	'Topology'),
(1616,	'Analysis.pptx'),
(1617,	'generate'),
(1618,	'smooth'),
(1619,	'GIFs'),
(1620,	'HV13.pptx'),
(1621,	'pptx'),
(1622,	'subdir'),
(1623,	'output.txt'),
(1624,	'send'),
(1625,	'mail'),
(1626,	'newDir'),
(1627,	'runAsCommand.TXT'),
(1628,	'l:'),
(1629,	'>runas'),
(1630,	'profile'),
(1631,	'user:ad.trw.com'),
(1632,	'jbccae'),
(1633,	'\"CSCRIPT'),
(1634,	'bck'),
(1635,	'ppt2txt.vbs'),
(1636,	'pp3.ppt'),
(1637,	'out.pdf\"'),
(1638,	'What'),
(1639,	'mess'),
(1640,	'file'),
(1641,	'name!'),
(1642,	'important'),
(1643,	'important.txt'),
(1644,	'newDir2'),
(1645,	'SUK');

DROP TABLE IF EXISTS `link`;
CREATE TABLE `link` (
  `linkId` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(999) NOT NULL,
  `title` varchar(999) NOT NULL,
  `linkContent` longtext NOT NULL,
  `indexdate` date NOT NULL,
  `size` float NOT NULL,
  `md5sum` varchar(32) NOT NULL,
  `level` int(11) NOT NULL,
  `type` varchar(90) NOT NULL,
  `domainId` int(11) NOT NULL,
  PRIMARY KEY (`linkId`),
  KEY `domainId` (`domainId`),
  CONSTRAINT `link_ibfk_1` FOREIGN KEY (`domainId`) REFERENCES `domain` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `link` (`linkId`, `path`, `title`, `linkContent`, `indexdate`, `size`, `md5sum`, `level`, `type`, `domainId`) VALUES
(1,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\docx',	'docx',	'Changing CAD_import-reader in DesignModeler WB13.docx TS_CAE-NVH-B10_Bracket_Deflection_Re1.1_20130321.docx ',	'2016-07-25',	0,	'f9fdd1868d409f6afffe684f2c2812c3',	1,	'dir',	1),
(2,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\docx\\Changing CAD_import-reader in DesignModeler WB13.docx',	'Changing CAD_import-reader in DesignModeler WB13',	'No content to read',	'2016-07-25',	0,	'c678e29e4b45da253ff35a1e6cf71c08',	2,	'file',	1),
(3,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\docx\\TS_CAE-NVH-B10_Bracket_Deflection_Re1.1_20130321.docx',	'TS_CAE-NVH-B10_Bracket_Deflection_Re1.1_20130321',	'No content to read',	'2016-07-25',	0,	'7bf1de2da4126feedd332edbad9e6457',	2,	'file',	1),
(4,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pdf',	'pdf',	'20100401-pad-sensitivy-hgi-extract.pdf 20111104-lining-mat-model-etek-measurements.pdf 20130904-LiningStiffness-dyanmicl-trw.pdf alexandria.pdf testPdf.pdf ',	'2016-07-25',	0,	'e83135d827fba53888336d6a8506de82',	1,	'dir',	1),
(5,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pdf\\20100401-pad-sensitivy-hgi-extract.pdf',	'20100401-pad-sensitivy-hgi-extract',	'Lining Property Identification\r\n\r\nExtract from Lining Property Identification - Pad-Frequency-Sensitivity\r\nHans Giese Koblenz, 2010, January 12 update, February 15 Last update March 26 Extract, April 01\r\nHans Giese, Dr.-Ing Specialist CAE\r\nTRW Automotive - Lucas Varity GmbH Carl-Spaeter-Straße 8 D-56070 Koblenz +49(0)261895-2075 hans-martin.giese@trw.com\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\nLining Property Identification\r\nStandard Approach for Material-Property-Identification from frf\r\n\r\n- calculate eigenfrequencies (or frequency response functions) using assumed material properties - measure eigenfrequencies (frequency responses in most cases) - determine material properties achieving best match of calculated vs. measured eigenfrequencies - single material property: calculate updated properties directly from frequency shift factor - multiple material properties: solve optimization problem for material properties minimizing the frequency deviation (e.g. least-error-squares)\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n2\r\n\r\nLining Property Identification\r\n\r\nInverse Identification - Updating with measured Eigenfrequencies\r\nThe „Standard Approach“ for multiple properties: Parameter Identification using parametric optimization - NASTRAN SOL 200\r\n\r\nObjective\r\n\r\n f i FE  Min( F (cij , ρ l ) = ∑ wi  1 − f Meas   i i  \r\n\r\n2\r\n\r\nwi = weight factors, fFEi = calculated eigenfrequency, fmeasi = measured eigenfrequency\r\n\r\nConstraints:\r\n\r\nMlow ≤ M(ρl) ≤ Mupper;\r\n\r\nflow,k ≤ fk ≤ fupper,k\r\n\r\nused to estimate density ρl of lining material\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n3\r\n\r\nLining Property Identification\r\n\r\nInverse Identification - Updating with measured Eigenfrequencies\r\nThe „Alternative Approach“ for multiple properties:\r\n2 Objective Min( F ( ρ ) = (M ( ρ ) − M ) l l meas\r\n\r\nMin( F ) = Weight\r\n\r\nused to estimate density ρl of lining material or „dummy function“ if mass is correlated Constraints:\r\n\r\nfi\r\n\r\nmeas\r\n\r\n− ∆f ≤ f i (cik , ρ l ) ≤ f i\r\n\r\nFE\r\n\r\nmeas\r\n\r\n+ ∆f\r\n\r\nminimize constraint violation sensitivity ís calculated for respsonses => sensitivity for each frequency available in this formulation\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n4\r\n\r\nLining Property Identification\r\nthe error in a parameter identified from responses is inversily related to the sensitivity of the responses to the parameter => material properties can only be identified from measured eigenfrequencies if these are sensitive for the property\r\n\r\n=> „sensitivities“ to be known before optimization (e.g. SOL200)\r\n\r\nSensitivity of frequency fj to parameter Cik : normalized:\r\n\r\ndfj/dCik (dfj/fj) / (dCik/Cik)\r\n\r\n=> dfj/dCik is influenced by pad-geometry and lining-material !\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n5\r\n\r\nLining Property Identification\r\nMethods for Calculation of Lining Sensitivity dfj/dCik NASTRAN-SOL200: dfj/dCik\r\n- may be done in one analysis: DSAPRT(END=SENS) = ALL DSAPRT(START = FIRST,BY = 1,END = LAST) = ALL\r\n\r\n- writes tables of sensitivities of responses (DRESPi) for design variables (DESVARj):\r\n\r\nSolver Independent:\r\n\r\n“numerical differentiation”\r\n\r\n- needs of 1 + 5 runs: reference and 5 runs with one property modified - Templates for NASTRAN-available (see 20090822-pad-freq-sensitivity-template.ppt)\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n6\r\n\r\nLining Property Identification\r\nLining-sensitivity dfj/dCik – Procedure Verification:\r\n(example Daimler MFA 16inch front pad w lining-template)\r\n\r\n„pad-sensitivities (numerical differentiation)\r\nEigenfrequency Sensitivity\r\n0.25\r\n\r\n0.2\r\n\r\n0.15\r\n\r\n0.1\r\n\r\ndf/dc11 df/dc13 df/dc33 df/dc44 df/dc55\r\n\r\nSol 200: „normalized“(dfj/fj)/(Cik/dCik)\r\n(dfi/fi) (Cjk/dCjk)\r\n0.25\r\n\r\n0.05\r\n\r\n0.2 0 3129 4465 6595 8303 9914 10783 11410 12549 13334 0.15 -0.05 df/dC 0.1 C11 C13 C33 C44 C55\r\n\r\n0.05\r\n\r\n0 3131.6 4472.9 6605.6 8321.4 9936.4 10819 11417 12585 13372\r\n\r\n-0.05 [Hz]\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n7\r\n\r\nLining Property Identification\r\nElastic Material Law - Checks:\r\nThe work of stresses σ on the strains ε in an elastic body is a positive number !\r\n1 T ε σV ≥ 0 2\r\n\r\nσ i = Cik ε k\r\n\r\n1 1 V (ε i Cik ε k ) = Vε T Cε ≥ 0 2 2\r\n\r\nε T Cε ≥ 0\r\n\r\nTest-Case – hydrostatic pressure state (no shear)\r\nσdV ≥ 0 dV = A1ε 1l1 + A2ε 2l2 + A3ε 3l3 = Vε 1 + Vε 2 + Vε 3 (ε 1σ + ε 2σ + ε 3σ )V ≥ 0\r\nσ = C11ε1 + C12ε 2 + C13ε 3 σ = C21ε1 + C22ε 2 + C23ε 3 σ = C31ε1 + C32ε 2 + C33ε 3\r\nC11 = C22 C13 = C23 Cik = Cki 2 C 13 ε + C 33 ε 3 = ( C 11 + C 12 )ε + C 13 ε 3 ( C 33 − C 13 )ε 3 = ( C 11 + C 12 − 2 C 13 )ε\r\n\r\nε3 =\r\n\r\n( C 11 + C 12 − 2 C 13 ) ε ( C 33 − C 13 )\r\n\r\nσ T ε = ( 2 C 13 ε + C 33\r\n\r\n( C 11 + C 12 − 2 C 13 ) ( C + C 12 − 2 C 13 ) ε )( 2ε + 11 ε) > 0 ( C 33 − C 13 ) ( C 33 − C 13 )\r\n2\r\n\r\n=> C 33 ( C 11 + C 12 ) > 2 C 13 and Example – EU-lining template:\r\n\r\n2 C 33 + C 11 + C 12 > 4 C 13\r\n\r\nε1 = ε 2\r\nC 33 ( C 11 + C 12 ) ( 2 C 33 + C 11 + C 12 ) > C 13 > C 13 2 4 ( C 11 = 10880 MPa ; C 12 = 300 MPa ; C 33 = 3245 MPa ) 4259 . 1 > C 13 and 4417 . 5 > C 13\r\n\r\n=> physical limitations for C13 !\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n8\r\n\r\nLining Property Identification\r\nA typical european front-brake pad – normal. sensitivities (dfj/fj)/(dCik/Cik):\r\nProject\r\nCustomer Vehicle Axle Brake BMW PL3 front CII-54\r\n\r\nFinite-Element-Model\r\nModel Mass(FE) lining setup model-4-12102005 411.5 g template t20p5 shim setup template iso-14k\r\n\r\ndf/dc11\r\n0.25\r\n\r\ndf/dc13\r\n\r\ndf/dc33\r\n\r\ndf/dc44\r\n\r\ndf/dc55\r\n\r\n0.2\r\n\r\n0.15\r\n\r\n0.1\r\n\r\n0.05\r\n\r\n0 3447 4257 6545 8403 9526 9962 10797 12311 12429 13410 15194 15878 17433 17612\r\n\r\n-0.05\r\n\r\n- sufficient sensitivity of eigenfrequencies for C11, C44 and C55 - sensitivity for C13 and C33 is very low\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n9\r\n\r\nLining Property Identification\r\nA typical european front-brake pad – normal. sensitivities (dfj/fj)/(dCik/Cik) - sensitivities with and without radial center-slot\r\n\r\nProject\r\nCustomer Vehicle Axle Brake BMW PL2 front CII-54\r\n\r\nFinite-Element-Model\r\nModel Mass(FE) lining setup w-cut-close 359.8 g jurid-422 t20p5 comment shim setup \"w-cut-close\" template iso-14k\r\n\r\nProject\r\nCustomer Vehicle Axle Brake BMW PL2 front CII-54\r\n\r\nFinite-Element-Model\r\nModel Mass(FE) lining setup pl2-front-pada-wshm 358.5 g jurid-422 t20p5 comment shim setup \"w-radiak-cut\" template iso-14k\r\n\r\ndf/dc11\r\n0.25\r\n\r\ndf/dc13\r\n\r\ndf/dc33\r\n\r\ndf/dc44\r\n\r\ndf/dc55\r\n0.3\r\n\r\ndf/dc11\r\n\r\ndf/dc13\r\n\r\ndf/dc33\r\n\r\ndf/dc44\r\n\r\ndf/dc55\r\n\r\n0.2\r\n\r\n0.25\r\n\r\n0.2\r\n0.15\r\n\r\n0.15\r\n0.1\r\n\r\n0.1\r\n0.05\r\n\r\n0.05\r\n\r\n0 3235 4601 6638 9526\r\n\r\n10 kHz\r\n\r\n10015\r\n\r\n10864\r\n\r\n12358\r\n\r\n13216\r\n\r\n14355\r\n\r\n15098\r\n\r\n16299\r\n\r\n17303\r\n\r\n18630\r\n\r\n19109\r\n\r\n0 2077 3791 6415 9226 9414 10512\r\n\r\n10 kHz\r\n\r\n11907\r\n\r\n13149\r\n\r\n13438\r\n\r\n14807\r\n\r\n15420\r\n\r\n16438\r\n\r\n16758\r\n\r\n18736\r\n\r\n-0.05\r\n\r\n-0.05\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n10\r\n\r\n',	'2016-07-25',	0,	'cb2221ed0d1a5ffc8895c7523df80e8d',	2,	'pdf',	1),
(6,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pdf\\20111104-lining-mat-model-etek-measurements.pdf',	'20111104-lining-mat-model-etek-measurements',	'Lining Material Model\r\n\r\nBrake Pad Lining Material Model – Parameter Identification\r\nHans Giese Koblenz, 2011, November 4\r\nHans Giese, Dr.-Ing Specialist CAE\r\nTRW Automotive - Lucas Varity GmbH Carl-Spaeter-Straße 8 D-56070 Koblenz +49(0)261895-2075 hans-martin.giese@trw.com\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\nLining Model\r\nCoordinate definitions for a diskbrake pad\r\nY, 2-direction X, 1-direction\r\n\r\n3 (z) „axial“ 2 (y) 1 (x)\r\n\r\nZ, 3-direction\r\n\r\nAssumption: Transversal isotropic\r\n different properties in thickness „3“ direction\r\n\r\n 1 and 2 direction interchangeable\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n2\r\n\r\nLining model\r\nTransversal isotropic Materiallaw (NASTRAN MAT9 definitions) Orientation of 1 and 2-axis without influence: • 1-2 direction interchangeable: C11 = C22 , C55 = C66, C23 = C13\r\n\r\n• C invariant vs. rotation about z-axis: C44 = 1/2 ( C11 - C12)\r\nxx yy = zz xy yz zx C11 C12 C13 C12 C11 C13 C13 C13 C33\r\n1\r\n\r\ncij,low\r\n\r\nxx yy zz xy+yx\r\n\r\n/2(C11- C12) C55 C55\r\n\r\nyz+zy zx+xz\r\n\r\n=> 5 independent material parameters\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n3\r\n\r\nLining model\r\nTransversal Isotropic Materiallaw with Engineering Constants (ANSYS) (1)\r\n\r\nOrientation of 1,2 and 3-axis without influence:\r\n• 1-2-3 direction interchangeable:\r\nxx yy zz xy+yx yz+zy zx+xz\r\n\r\n\r\n=> 5 independent material parameters\r\nxx yy zz 1/Gxy 1/Gyz 1/Gzx xy yz zx\r\n\r\n• G invariant vs. rotation about normal-axis: Gxy = E/2(1+ )\r\n1/Ex = -xy/Ex -xz/Ex -yz/Ey -yx/Ey 1/Ey\r\n\r\n-zx/Ez -zy/Ez 1/Ez\r\n\r\n yx\r\nEy\r\n\r\n\r\n\r\n xy\r\nEx\r\n\r\nE y  Ex   yx   xy\r\n\r\n\r\n\r\n zx\r\nEz\r\n\r\n\r\n\r\n xz\r\nEx\r\n\r\nEz  Ex   zx   xz\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n4\r\n\r\nLining model\r\nTransversal Isotropic Materiallaw with Engineering Constants (ANSYS) (2)\r\n\r\nOrientation of 1,2 and 3-axis without influence:\r\n• 1-2-3 direction interchangeable: => 5 independent material parameters • G invariant vs. rotation about normal-axis: Gxy = E/2(1+ )\r\n\r\n• Symmetriecondition leads to definition of minor and major poisson ratios\r\n\r\n\r\n\r\n yx\r\nEy\r\n\r\n\r\n\r\n\r\n xy\r\nEx\r\nEx\r\n\r\nE y  Ex   yx   xy\r\nEz  Ex   zx   xz\r\n\r\nin-plane Poisson ratios are equal => minor and major Poisson ratios => minor and major Poisson ratios\r\n\r\n zx\r\nEz\r\n\r\n xz\r\n\r\n\r\n\r\n zy\r\nEz\r\n\r\n\r\n\r\n yz\r\nEy\r\n\r\nEz  E y   zy   yz\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n5\r\n\r\nLining model\r\n\r\nFEA\r\n\r\nTransversal isotropic Materiallaw - Identify in Pad-Eigenfrequencies ?\r\nParameter Identificatin using parametric optimization (e.g. NASTRAN SOL 200, ANSYS)\r\nObjective: Min F(cij, l) = Σ wi(1 – (fci/ fmi))2\r\n\r\nwi = weight factors, fci = calculated eigenfrequency, fmi = measured eigenfrequency\r\nConstraints: mlow ≤ m(l) ≤ mupper; => lining densitiy\r\n\r\nfk,low, ≤ fk ≤ fk,upper\r\ncij,low ≤ cij ≤ cij,upper => limitations from physical cons.\r\n\r\nAt least 5 eigenfrequencies are necessary to identify the 5 independent stiffness parameters!\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n6\r\n\r\nLining model\r\n\r\nFEA\r\n\r\nTransversal isotropic Materiallaw - Identify in Pad-Eigenfrequencies ?\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n7\r\n\r\nLining model\r\n\r\nFEA\r\n\r\nTransversal isotropic Materiallaw - Identify in Pad-Eigenfrequencies ?\r\nExample frf from a current project BR205\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n8\r\n\r\nLining model\r\n\r\nFEA\r\n\r\nTransversal isotropic Materiallaw - Identify in Pad-Eigenfrequencies ?\r\nUpdating with measured Eigenfrequencies – Example 4 VW PQ35\r\nEigenfrequenzen Beläge Kolbenseite VW PQ35GP VA C57\r\nB2_KS_C [g/N] B10_KS_C [g/N] model-3-pad-i-wo-shm-fer-c13p1k\r\n2058 2851 4570\r\n\r\nSensitivity of Eigenfrequencies: C33 + 1000 MPa (+56%)\r\n8418 8864 9027 9611\r\n\r\n70\r\n\r\nB4_KS_C [g/N] model-3-pad-i-wo-shm-fer model-3-pad-i-wo-shm-fer-c33p1k\r\n5990 7283\r\n\r\n60\r\n\r\nC13 + 1000 MPa (+490%)\r\n\r\n2021\r\n\r\n2847\r\n\r\n4530\r\n\r\n5977\r\n\r\n7238\r\n\r\n8386\r\n\r\n8829 8912\r\n\r\n9508\r\n\r\n50\r\n\r\nOriginaldatensatz von Ferodo\r\n(FER5432) C33 : „dynamic Compressibility“ C13: Couplingstiffness axial / „in-plane“\r\n\r\n2081 2203 2056\r\n\r\n2849\r\n\r\n4559 4678 4559\r\n\r\n5986\r\n\r\n7234 7341 7253\r\n\r\n8416\r\n\r\n8837 9009\r\n\r\nAmplitude [g(N]\r\n\r\n40\r\n\r\n30\r\n\r\n10\r\n\r\n0\r\n\r\n-10 0 1000 2000 3000 4000 5000 Frequenz [Hz] 6000 7000 8000 9000 10000\r\n\r\nEigenfrequencies fi not sensitive for even severe changes in C33 and C13\r\n\r\n=> Eigenfrequencies fi don‘t tell the full story . .\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n2869 3009\r\n\r\n5909\r\n\r\n5966 6072\r\n\r\n20\r\n\r\n9431\r\n\r\n9694\r\n\r\n7178\r\n\r\n8778 9025\r\n\r\n9580\r\n\r\n9\r\n\r\nLining model\r\n\r\nFEA\r\n\r\nTransversal isotropic Materiallaw - Identify in Pad-Eigenfrequencies ?\r\nProject\r\nCustomer Vehicle Axle Brake\r\n\r\nFinite-Element-Model\r\nBMW Model PL3-R60 Mass(FE) front 16inch-high lining CII-54 setup 32337166_a_67 401.1 g template t20p5 shim setup no iso-14k\r\n\r\ndf/dc11\r\n0.3\r\n\r\ndf/dc13\r\n\r\ndf/dc33\r\n\r\ndf/dc44\r\n\r\ndf/dc55\r\n\r\n0.25\r\n\r\n0.2\r\n\r\n0.15\r\n\r\n0.1\r\n\r\n0.05\r\n\r\n0 3361 -0.05 4229 6802 8937 9761 11190 11239 12392 12464 13654 15975 16838 17862 18055\r\n\r\n-0.1\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n10\r\n\r\nLining model\r\n\r\nFEA\r\n\r\nTransversal isotropic Materiallaw - Identify in Pad-Eigenfrequencies ? Updating with measured Eigenfrequencies – Example 5 Audi B8\r\nMode 7 1199 Hz\r\n40.00%\r\n\r\nD = (dfi/fi) / (dCjk/Cjk)\r\nC11 C23 C33 C44 C55\r\n\r\n30.00%\r\n\r\n20.00%\r\n\r\nMode 8 2451Hz\r\n10.00%\r\n\r\nD\r\n0.00%\r\n\r\n1199\r\n\r\n2451\r\n\r\n2711\r\n\r\n3754\r\n\r\n5467\r\n\r\n5815\r\n\r\n7125\r\n\r\n7291\r\n\r\n7670\r\n\r\n8322\r\n\r\n8505\r\n\r\n10067\r\n\r\n10108\r\n\r\n-10.00%\r\n\r\nMode 9 2711Hz\r\n\r\n-20.00%\r\n\r\n-30.00% f [Hz]\r\n\r\nsensitivity for C33 and C13 at low frequencies surprisingly high . .\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n11\r\n\r\n10442\r\n\r\nLining model\r\nUltrasoundwave: travelling and displacement direction for measurements at cubic test specimen\r\nin-plane out-of-plane v32 =v31 => C55 =C66\r\n\r\nFEA\r\n\r\nv22 =v11 => C22 = C11 v21 = v12 => C44\r\n\r\nv33 => C33\r\n\r\n=> C12 = C11-2C44\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\nC13 = C23 = ??\r\n12\r\n\r\nLining model\r\n\r\nFEA\r\n\r\nUltrasoundwave: Measurement of C13 with special specimen shape Stiffnesses from measurements of ultrasoundvelocities\r\nPlane waves in a transversal-isotropic material: compressionwave with 45° inclination in x-z-plane: dT = ( u0, v0, w0) mit dTx k = 0\r\n\r\nassumption:\r\n\r\nu(t,x,z) w(t,x,z)\r\n\r\n= =\r\n\r\nu0 sin(  t – kux x – kuz z) w0 sin(  t – kwx x – kwz z)\r\n\r\n 2 u0 = u0C11 kux2 + w0C13 kwz kwx + u0C66 kuz2 + w0C66 kwz kwx  2 w0 = u0 C66 kuz kux + w0 C66 kux2 + u0 C31 kuz kux + w0 C33 kwz2 plane wave: c = /k (/kux) = (/kwx) = (/kwx) = (/kwz) kux = kwx = kwx = kwz = k\r\n\r\nwith c2 = cux2 + cwx2 = cux2 + cwx2 =\r\n\r\n(/kux)2 + (/kwx)2 = 2 (/k)2\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n13\r\n\r\nLining model\r\n“ETEK”: Measurement of Cik - specimen shape definition\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n14\r\n\r\nLining model\r\n“ETEK”: Measurement of Cik –”intact pad measurement”\r\nwaves travelling in thickness direction: p-wave => C33 s-wave => C55 = C66 waves travelling in-plane: p-wave => C11 = C22 s-wave => C44 (1) s-wave => C55 (2)\r\n\r\nSuccession of layers for waves travelling in thickness direction Transit time: T = Tbackplate + Tlining\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n15\r\n\r\nLining model\r\nTransversal isotropic Materiallaw (ETEK Don Yuhas definitions)\r\n\r\nOrientation of 1 and 2-axis without influence:\r\n• 1-2 direction interchangeable: C11 = C22 , C55 = C44, C23 = C13\r\n\r\n• C invariant vs. rotation about z-axis: C66 = 1/2 ( C11 - C12)\r\nxx yy = zz xy yz zx C11 C12 C13 C12 C11 C13 C13 C13 C33 C44 C55\r\n1\r\n\r\nxx yy zz xz+zx yz+zy /2(C11- C12) yx+xy\r\n\r\n=> 5 independent material parameters\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n16\r\n\r\nLining model\r\nTRW Noise Matrix Test vs. Computer Matrix Test\r\n\r\nNVH-Matrix Test\r\n\r\nComputer Matrix Test\r\nComplex Eigenvalue Analysis CEA several pressure-levels several temperature-levels\r\n\r\n10% 9% 8% CMT-C16-15\r\n\r\nNegative damping\r\n\r\n7% 6% 5% 4% 3% 2% 1% 0% 1000\r\n\r\n2000\r\n\r\n3000\r\n\r\n4000\r\n\r\n5000\r\n\r\n6000\r\n\r\n7000\r\n\r\n8000\r\n\r\n9000\r\n\r\n10000\r\n\r\nFrequency [Hz]\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n17\r\n\r\nLining model\r\nTRW Noise Matrix Test vs. Computer Matrix Test\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n18\r\n\r\nLining model\r\nTRW Noise Matrix Test vs. Computer Matrix Test TRW-Procedure (Livonia Rig) and Draft-Specification: „Die Messung erfolgt auf mindestens vier Temperaturniveaus, die die Raumtemperatur 20o C, 100o C, 200o C und 300o C und mindestens drei Druckstufen 5 bar, 15 bar und 30 bar enthalten.“ TRW-Proposal for Procedure Enhancement (Draft): - Data at specified Temperature / Pressure levels are gained from interpolation (!) , - => Measurements are done at arbitrary levels in „NVH-intervall“ -Matrix is replaced by „one-direction“ measurements,\r\n\r\nCubic-Specimen + 45°-sample (all 5 Cij) vs. Intact Pads (C13 not av.)\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n19\r\n\r\nLining model\r\nTransfer from ETEK-Data (1 MHz) to NVH range (10 kHz) - Correlation Verification / Recorrelation\r\nPad Eigenfrequencies / frf with ETEK-Data: = in some cases up to 30% stiffness overestimate lining stiffness is frequency dependent (viscoelastic)\r\n\r\nRecorrelation:\r\n1. „stiffness correction factor“ for all Cij 2. Identification (Optimisation) with ETEK data startv.\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n20\r\n\r\nLining model\r\nETEK-Measurements: Consequences of data loss at t300p5\r\nRenault Colette I Galfer G 4505-10 - A1 Room Temperature Mode 30 Bar 15 Bar 5 Bar C11 C11 nor C33 C44 C44 nor C66 C12 C13 10.67 10.67 3.48 2.26 2.26 4.36 1.96 0.94 10.67 10.67 3.30 2.14 2.14 4.36 1.96 0.93 10.67 1.00 2.14 1.00 10.56 10.56 2.91 2.02 2.02 4.36 1.85 0.68 50°C 30 Bar 9.86 9.86 3.30 2.17 2.17 4.27 1.32 0.91 15 Bar 10.17 10.17 3.06 2.04 2.04 4.19 1.79 0.89 5 Bar 10.17 10.17 2.71 1.92 1.92 4.27 1.63 0.66 100°C 30 Bar 9.29 9.29 2.98 2.08 2.08 4.02 1.25 0.87 15 Bar 9.29 9.29 2.65 1.92 1.92 4.02 1.25 0.85 5 Bar 9.29 9.29 2.37 1.74 1.74 4.02 1.25 0.61 200°C 30 Bar 8.28 8.28 2.65 1.81 1.81 3.73 0.82 0.78 15 Bar 8.52 8.52 2.31 1.78 1.78 3.66 1.20 0.78 5 Bar 8.52 8.52 2.08 1.65 1.65 3.66 1.20 0.56 300°C 30 Bar 8.05 8.05 2.47 1.62 1.62 3.46 1.13 0.71 15 Bar 8.05 8.05 2.04 1.59 1.59 3.40 1.25 0.71 5 Bar 7.84 7.84 1.89 1.32 1.32 3.34 1.16 0.48\r\n\r\nC22 meas 10.67 normalization factor for C11 1.00 C55 meas 2.26 normalization factor for C44 1.00 C13 temperature scaling factors\r\n\r\n10.56 Put ambient temperature value of the specific sample/mode used on the elevated temperature run 1.00 2.02 Put ambient temperature value of the specific sample/mode used on the elevated temperature run 1.00\r\n\r\n0.04 0.02 0.03\r\n\r\n0.05 0.04 0.04\r\n\r\n0.05 0.02 0.04\r\n\r\n0.04 0.06 0.05\r\n\r\n0.06 0.04 0.05\r\n\r\n0.09 0.06 0.08\r\n\r\n0.13 0.07 0.10\r\n\r\n0.07 0.09 0.08\r\n\r\n0.05 0.09 0.07\r\n\r\n0.10 0.07 0.09\r\n\r\n0.11 0.07 0.09\r\n\r\n0.20 0.09 0.14\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n21\r\n\r\nLining model\r\nTypical ETEK-data: TRW-CMT-Matrix\r\nExtrapolation to t300p5 – Observations - All data (C11, C33, C13, C44, C66) available at each other parameter combination\r\nC33 5000.0 4000.0 3000.0 2000.0 1000.0 0.0 0 100 200 300 400 5 bar 15 bar 30 bar\r\n4500.0 4000.0 3500.0 3000.0 2500.0 2000.0 1500.0 1000.0 500.0 0.0 0 10 20 30 40 C33\r\n\r\nT20 T100 T200 T300\r\n\r\n- 3 points for extrapolation on p5 curve\r\n- 4 points on p < 30 curves - 3 parameter C33(T) extrapolation (?)\r\n\r\n- 2 points for extrapolation on t300 curve\r\n- 3 points on t < 300 curves - C33(p) curve changes curvature over T !\r\n\r\nExample: Renault Colette I Galfer G 4505-10 – A1/A2\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n22\r\n\r\nLining model\r\nTypical ETEK-data: TRW-Template-Scaling-Matrix\r\n- 12pt-cmt-matrix-mat-scaling-general-w-ANSYS-20110418.xls\r\n\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n23\r\n\r\nETEK Data - Sources\r\nConstraints - original procedure on cubic test specimen is expensive - enhanced procedure (interpolation) is not feasible for all rigs - intact pad measurements reduce cost but do not deliver C13\r\n\r\nData Sources\r\nTRW : testrig in Livonia => Cij(p) ambient T only, or full matrix Cij(p,T) Lining-Suppliers: request as part Lining-data-sheet FERODO, GALFER: IMS-Testrig for Cij(p,T) JURID: „Hybrid“-testrig Cij(p) – (C13 from estimates !) TMD: outsorcing to IMS (Don Yuhas)\r\n© TRW Automotive Holdings Corp. 2009\r\n\r\n24\r\n\r\n',	'2016-07-25',	0,	'0f486526f2c5f56f84cea0328c16012d',	2,	'pdf',	1),
(7,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pdf\\20130904-LiningStiffness-dyanmicl-trw.pdf',	'20130904-LiningStiffness-dyanmicl-trw',	'Lining Property Measurement Benchmark Inverse Identification / Alco\r\n\r\nKoblenz, 28.6.2013 Last Update 04.09.2013\r\nHans Giese, Dr.-Ing Specialist CAE\r\nTRW Automotive - Lucas Varity GmbH Carl-Spaeter-Straße 8 D-56070 Koblenz +49(0)261895-2075 hans-martin.giese@trw.com\r\n\r\n© TRW Automotive 2012\r\n\r\nInsert Presentation Name & Date Here\r\n\r\n1\r\n\r\nScope\r\n Measurement and Characterization of different lining materials with different measurement methodologies  Linings:\r\n\r\nECE: NAO: Ceramic:\r\n\r\nGalfer 5503-8 Galfer NCF050 Pagid P40-3W\r\n\r\n Measurement approaches\r\n\r\nEigenfrequencies Compress measurement ALCO ETEK\r\n• Intact Pad • SAE standard • 40x40 mm specimen\r\n\r\nDCTR DCSTR\r\n\r\n© TRW Automotive 2012\r\n\r\nCompress Measurement Setup\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nCeramic Application (Pagid P40-3W)\r\nDensity: 3,06g/cm³ Porosity: ???%\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n3\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\nPad Material ECE 168 ECE 169 ECE 170 ECE 171 ECE 172 ECE 173 ECE 174 ECE 175 ECE 176 ECE 178 Bending Mode 1 Bending Mode 2 Bending Mode 3 Bending Mode 4 Torsional Mode 1 Torsional Mode 2 Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] 2528 1.02 5331 1.39 8384 1.38 11466 1.1 3888 1.31 7328 1.32 2500 1.02 5284 1.35 8369 1.44 11428 1.18 3878 1.3 7294 1.32 2503 0.95 5319 1.32 8387 1.28 11509 1.07 3863 1.19 7294 1.28 2541 1.02 5350 1.41 8456 1.34 11550 1.18 3913 1.25 7378 1.35 2506 0.94 5291 1.22 8325 1.26 11433 1.09 3881 1.22 7294 1.35 2491 1.12 5253 1.49 8284 1.59 11381 1.44 3831 1.42 7219 1.41 2481 1.04 5269 1.37 8328 1.49 11422 1.24 3841 1.27 7288 1.35 2453 1.12 5191 1.51 8200 1.51 11253 1.27 3794 1.44 7172 1.47 2494 1.13 5250 1.49 8266 1.58 11356 1.29 3834 1.42 7225 1.52 2497 1.04 5303 1.46 8391 1.43 11509 1.24 3878 1.38 7328 1.44\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n4\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nCorrelation\r\nmax-dev 0.15 min-dev -0.54 130 0 f_FE [Hz] f_meas [Hz] 2526 2528 3894 3888 5331 5331 7309 7328 8339 8384 9853 10542 11268 11485 11460 13966 14034 14770 15017 16326 17493 17895 18396\r\n© TRW Automotive 2012\r\n\r\n% % 6 dev. % -0.09% 0.15% 0.00% -0.26% -0.54% 100.00% 100.00% 100.00% 0.22% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%\r\n\r\n! t20 p5 generic MAT2 MP, EX, 2, 16940. MP, EY, 2, 16940. MP, EZ, 2, 3654.7 ! GXY=EX/2/(1+PRXY) MP, GXY, 2, 5844.3 MP, GYZ, 2, 4483.3 MP, GXZ, 2, 4483.3 MP, DENS,2, 3.172E-9 MP, PRXY,2, 0.44928 MP, PRYZ,2, 0.89140E -01 MP, PRXZ,2, 0.08914 !\r\n\r\nCompressibility measurement\r\n\r\n5\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nStartvector 1\r\nWith Ez + 1000 MPa\r\nCorrelation ECE168 - Opt3 Ex 16940 Mpa Ez 3655 Mpa dev. E 0.15 % dev. ρ -0.54 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2526 2528 -0.09% 3894 3888 0.15% 5331 5331 0.00% 7309 7328 -0.26% 8339 8384 -0.54% 9853 100.00% 10542 100.00% 11268 100.00% 11485 11460 0.22%\r\nCorrelation ECE168 - Opt3 ez4600 Ex Ez 4600.0 max-dev 0.17 % min-dev -0.30 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2527 2528 -0.05% 3895 3888 0.17% 5338 5331 0.13% 7314 7328 -0.18% 8359 8384 -0.30% 9853 100.00% 10556 100.00% 11278 100.00% 11519 11460 0.51%\r\n\r\nStartvector 2\r\nWith Ez=2500 MPa\r\nCorrelation ECE168 - Opt4 Ex 16911 Mpa Ez 3061 Mpa dev. E 0.12 % dev. ρ -0.54 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2526 2528 -0.09% 3893 3888 0.12% 5333 5331 0.03% 7310 7328 -0.25% 8339 8384 -0.54% 9854 100.00% 10544 100.00% 11305 100.00% 11481 11460 0.18%\r\n\r\n=> Identified Value for Ez is not stable for different startvectors\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n6\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nStartvector 1 (opt 3)\r\n\r\nStartvector 4 (opt 6)\r\n\r\nStartvector 2 (opt 4)\r\n\r\nStartvector 5 (opt 7)\r\n\r\nStartvector 3 (opt 5) => Identified Value for Ez > ~ 3000 MPa\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n7\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\nPad Material NAO 77 NAO 78 NAO 79 NAO 80 NAO 81 NAO 82 NAO 83 NAO 84 NAO 85 NAO 86 Bending Mode 1 Bending Mode 2 Bending Mode 3 Bending Mode 4 Torsional Mode 1 Torsional Mode 2 Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] 1966 1.21 4350 1.95 7216 2.22 10284 2.08 3150 1.83 6088 2.16 1984 1.26 4353 2.09 7216 2.31 10275 1.09 3166 1.92 6144 2.13 1969 1.2 4353 1.97 7222 2.18 10279 1.99 3150 1.81 6084 2.13 1997 1.24 4409 1.98 7278 2.12 10450 1.78 3197 1.77 6178 2.03 1966 1.19 4338 1.84 7213 2.07 11250 1.75 3144 1.78 6084 1.91 1972 1.26 4350 1.95 7216 2.2 10281 1.93 3147 1.99 6081 2.13 1972 1.15 4350 1.88 7213 2.11 10322 1.85 3147 1.74 6094 2.08 1966 1.23 4338 1.92 7219 2.2 10306 1.88 3153 1.78 6088 2.19 1966 1.21 4353 1.9 7241 2.09 10294 1.93 3147 1.82 6091 1.72 1972 1.19 4334 1.88 7213 2.11 10266 1.63 3150 1.89 6088 2.06\r\n\r\nNAO77 NAO78 NAO 79 Mode f [Hz] f [Hz] f [Hz] 1 1966 1984 1969 2 3150 3166 3150 3 4350 4353 4353 4 6088 6144 6084 5 7216 7216 7222 6 10284 10275 10279\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n8\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nStartvector 1\r\nCorrelation NAO-77 Opt3 Ex 8302 Mpa Ez 3361 Mpa max 0.69 % min -0.64 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 1962 1966 -0.23% 3152 3150 0.05% 4380 4350 0.69% 6052 6088 -0.59% 7170 7216 -0.64% 9018 100.00% 9080 100.00% 9227 100.00% 10138 10216 -0.77%\r\n\r\nStartvector 2\r\nCorrelation NAO-77 Opt4 Ex 8263 Mpa Ez 2440 Mpa max 0.72 % min -0.65 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 1960 1966 -0.30% 3153 3150 0.09% 4381 4350 0.72% 6058 6088 -0.50% 7169 7216 -0.65% 9021 100.00% 9088 100.00% 9231 100.00% 10118 10216 -0.97%\r\n\r\n=> Identified Value for Ez is not stable for different startvectors\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n9\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nStartvector 1 (Opt 3)\r\n\r\nStartvector 6 (Opt 8)\r\n\r\nStartvector 2 (Opt 4)\r\n\r\nStartvector 3 (Opt 5)\r\n\r\nStartvector 5 (Opt 7)\r\n\r\nStartvector 4 (Opt 6)\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n10\r\n\r\nThe Global Leader in Automotive Safety Systems\r\n\r\n© TRW Automotive 2012\r\n\r\n11\r\n\r\n',	'2016-07-25',	0,	'4ea563e563005900255ddde32dae99e6',	2,	'pdf',	1),
(8,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pdf\\alexandria.pdf',	'alexandria',	'CK ALEXANDRIA – nabídka slev pro zaměstnance TRW Automotive Czech s.r.o\r\nVyužijte momentální zaměstnanecké slevy u cestovní kanceláře CK ALEXANDRIA. Všem zaměstnancům TRW Automotive Czech s.r.o.; Jablonec nad Nisou (kmenovým i agenturním) nabízí CK Alexandria tyto uvedené slevy: Sleva 12% na letecké zájezdy Sleva 10% na zájezdy vlastní a autobusovou dopravou Sleva 6% na LAST MINUTE zájezdy Na slevu mají nárok také rodinní příslušníci zaměstnanců a případní spolucestující. Pro uplatnění slevy je třeba identifikace firemní kartou zaměstnance. Kompletní nabídku zájezdů naleznete na www.alexandria.cz; případně v tištěném katalogu na pobočce CK ALEXANDRIA.\r\n\r\nCK ALEXANDRIA\r\nKomenského 23/7; Jablonec nad Nisou\r\n\r\nwww.alexandria.cz\r\ntelefon 739 246 123 jablonec.@alexandria.cz\r\n\r\n',	'2016-07-25',	0,	'3634431064aba66a89dc010fee3831f6',	2,	'pdf',	1),
(9,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pdf\\testPdf.pdf',	'testPdf',	'Windchill Download CAD Data\r\n\r\nZF Friedrichshafen AG\r\n\r\n1\r\n\r\n© ZF Friedrichshafen AG, 2015\r\n\r\n',	'2016-07-25',	0,	'0c627fe46e046646096893d68dd9deb4',	2,	'pdf',	1),
(10,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\ppt',	'ppt',	'20150416_JimBeam-Coupling evaluation.ppt 20150421_JimBeam-Coupling evaluation_results.ppt test.bat ',	'2016-07-25',	0,	'3ed68172455a04f6255d0f84a9df071b',	1,	'dir',	1),
(11,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\ppt\\20150416_JimBeam-Coupling evaluation.ppt',	'20150416_JimBeam-Coupling evaluation',	'No content to read',	'2016-07-25',	0,	'ed40c78083bb53a7357e888be26db8a5',	2,	'file',	1),
(12,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\ppt\\20150421_JimBeam-Coupling evaluation_results.ppt',	'20150421_JimBeam-Coupling evaluation_results',	'No content to read',	'2016-07-25',	0,	'7e1b45d31d4dbc75669a210d2284e0cd',	2,	'file',	1),
(13,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\ppt\\test.bat',	'test',	'No content to read',	'2016-07-25',	0,	'19d0140e108f7840845f0f8465a9ced9',	2,	'file',	1),
(14,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pptx',	'pptx',	'20150729_summary-meeting.pptx 20151125_How-to-do_post-processing_on_EF.pptx 20151127_how-to-download-data-from-windchill.pptx 20151202_Simulation_Plzen.pptx 20160108_how-to-set-it.pptx 20160204_Pad_Topology_Sensitivity_Analysis.pptx 20160219_How_to_generate_smooth_GIFs_from_HV13.pptx ',	'2016-07-25',	0,	'8d64ab4070afb70c2cb17f7e2c6cf92d',	1,	'dir',	1),
(15,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pptx\\20150729_summary-meeting.pptx',	'20150729_summary-meeting',	'No content to read',	'2016-07-25',	0,	'2dbe44c469b0e993892bebe91ee2a019',	2,	'file',	1),
(16,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pptx\\20151125_How-to-do_post-processing_on_EF.pptx',	'20151125_How-to-do_post-processing_on_EF',	'No content to read',	'2016-07-25',	0,	'a3105c3e489701f8e366c26836b5266d',	2,	'file',	1),
(17,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pptx\\20151127_how-to-download-data-from-windchill.pptx',	'20151127_how-to-download-data-from-windchill',	'No content to read',	'2016-07-25',	0,	'fd377b7c61cab553fe216d71c50f7c72',	2,	'file',	1),
(18,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pptx\\20151202_Simulation_Plzen.pptx',	'20151202_Simulation_Plzen',	'No content to read',	'2016-07-25',	0,	'435fb010e522ea72614b1f6a06a384b2',	2,	'file',	1),
(19,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pptx\\20160108_how-to-set-it.pptx',	'20160108_how-to-set-it',	'No content to read',	'2016-07-25',	0,	'f53fc74aaa15733b5d26a1d3f5903eb0',	2,	'file',	1),
(20,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pptx\\20160204_Pad_Topology_Sensitivity_Analysis.pptx',	'20160204_Pad_Topology_Sensitivity_Analysis',	'No content to read',	'2016-07-25',	0,	'2d69e50b817df8e7ea23468712b9df18',	2,	'file',	1),
(21,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\pptx\\20160219_How_to_generate_smooth_GIFs_from_HV13.pptx',	'20160219_How_to_generate_smooth_GIFs_from_HV13',	'No content to read',	'2016-07-25',	0,	'3c9187e99af8dbc50f03d143716dbd92',	2,	'file',	1),
(22,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\newDir',	'newDir',	'subdir output.txt send mail 7 ',	'2016-07-25',	0,	'4512abe188d6054bc43bfcbb091f53cc',	1,	'dir',	1),
(23,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\newDir\\subdir',	'subdir',	'runAsCommand.TXT ',	'2016-07-25',	0,	'3d0e3c288e05e26750594deccfe7813d',	2,	'dir',	1),
(24,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\newDir\\subdir\\runAsCommand.TXT',	'runAsCommand',	'l:\\>runas /profile /user:ad.trw.com\\jbccae \"CSCRIPT \\\\sjabcz-vyv-bck\\cae\\ppt2txt.vbs \\\\sjabcz-vyv-bck\\cae\\pp3.ppt \\\\sjabcz-vyv-bck\\cae\\out.pdf\"',	'2016-07-25',	0,	'30717892a08e1f14ea897f976432d9ec',	3,	'txt',	1),
(25,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\newDir\\output.txt',	'output',	'Lining Property Measurement Benchmark Inverse Identification / Alco\r\n\r\nKoblenz, 28.6.2013 Last Update 04.09.2013\r\nHans Giese, Dr.-Ing Specialist CAE\r\nTRW Automotive - Lucas Varity GmbH Carl-Spaeter-Straße 8 D-56070 Koblenz +49(0)261895-2075 hans-martin.giese@trw.com\r\n\r\n© TRW Automotive 2012\r\n\r\nInsert Presentation Name & Date Here\r\n\r\n1\r\n\r\nScope\r\n Measurement and Characterization of different lining materials with different measurement methodologies  Linings:\r\n\r\nECE: NAO: Ceramic:\r\n\r\nGalfer 5503-8 Galfer NCF050 Pagid P40-3W\r\n\r\n Measurement approaches\r\n\r\nEigenfrequencies Compress measurement ALCO ETEK\r\n• Intact Pad • SAE standard • 40x40 mm specimen\r\n\r\nDCTR DCSTR\r\n\r\n© TRW Automotive 2012\r\n\r\nCompress Measurement Setup\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nCeramic Application (Pagid P40-3W)\r\nDensity: 3,06g/cm³ Porosity: ???%\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n3\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\nPad Material ECE 168 ECE 169 ECE 170 ECE 171 ECE 172 ECE 173 ECE 174 ECE 175 ECE 176 ECE 178 Bending Mode 1 Bending Mode 2 Bending Mode 3 Bending Mode 4 Torsional Mode 1 Torsional Mode 2 Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] 2528 1.02 5331 1.39 8384 1.38 11466 1.1 3888 1.31 7328 1.32 2500 1.02 5284 1.35 8369 1.44 11428 1.18 3878 1.3 7294 1.32 2503 0.95 5319 1.32 8387 1.28 11509 1.07 3863 1.19 7294 1.28 2541 1.02 5350 1.41 8456 1.34 11550 1.18 3913 1.25 7378 1.35 2506 0.94 5291 1.22 8325 1.26 11433 1.09 3881 1.22 7294 1.35 2491 1.12 5253 1.49 8284 1.59 11381 1.44 3831 1.42 7219 1.41 2481 1.04 5269 1.37 8328 1.49 11422 1.24 3841 1.27 7288 1.35 2453 1.12 5191 1.51 8200 1.51 11253 1.27 3794 1.44 7172 1.47 2494 1.13 5250 1.49 8266 1.58 11356 1.29 3834 1.42 7225 1.52 2497 1.04 5303 1.46 8391 1.43 11509 1.24 3878 1.38 7328 1.44\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n4\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nCorrelation\r\nmax-dev 0.15 min-dev -0.54 130 0 f_FE [Hz] f_meas [Hz] 2526 2528 3894 3888 5331 5331 7309 7328 8339 8384 9853 10542 11268 11485 11460 13966 14034 14770 15017 16326 17493 17895 18396\r\n© TRW Automotive 2012\r\n\r\n% % 6 dev. % -0.09% 0.15% 0.00% -0.26% -0.54% 100.00% 100.00% 100.00% 0.22% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%\r\n\r\n! t20 p5 generic MAT2 MP, EX, 2, 16940. MP, EY, 2, 16940. MP, EZ, 2, 3654.7 ! GXY=EX/2/(1+PRXY) MP, GXY, 2, 5844.3 MP, GYZ, 2, 4483.3 MP, GXZ, 2, 4483.3 MP, DENS,2, 3.172E-9 MP, PRXY,2, 0.44928 MP, PRYZ,2, 0.89140E -01 MP, PRXZ,2, 0.08914 !\r\n\r\nCompressibility measurement\r\n\r\n5\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nStartvector 1\r\nWith Ez + 1000 MPa\r\nCorrelation ECE168 - Opt3 Ex 16940 Mpa Ez 3655 Mpa dev. E 0.15 % dev. ρ -0.54 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2526 2528 -0.09% 3894 3888 0.15% 5331 5331 0.00% 7309 7328 -0.26% 8339 8384 -0.54% 9853 100.00% 10542 100.00% 11268 100.00% 11485 11460 0.22%\r\nCorrelation ECE168 - Opt3 ez4600 Ex Ez 4600.0 max-dev 0.17 % min-dev -0.30 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2527 2528 -0.05% 3895 3888 0.17% 5338 5331 0.13% 7314 7328 -0.18% 8359 8384 -0.30% 9853 100.00% 10556 100.00% 11278 100.00% 11519 11460 0.51%\r\n\r\nStartvector 2\r\nWith Ez=2500 MPa\r\nCorrelation ECE168 - Opt4 Ex 16911 Mpa Ez 3061 Mpa dev. E 0.12 % dev. ρ -0.54 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2526 2528 -0.09% 3893 3888 0.12% 5333 5331 0.03% 7310 7328 -0.25% 8339 8384 -0.54% 9854 100.00% 10544 100.00% 11305 100.00% 11481 11460 0.18%\r\n\r\n=> Identified Value for Ez is not stable for different startvectors\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n6\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nStartvector 1 (opt 3)\r\n\r\nStartvector 4 (opt 6)\r\n\r\nStartvector 2 (opt 4)\r\n\r\nStartvector 5 (opt 7)\r\n\r\nStartvector 3 (opt 5) => Identified Value for Ez > ~ 3000 MPa\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n7\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\nPad Material NAO 77 NAO 78 NAO 79 NAO 80 NAO 81 NAO 82 NAO 83 NAO 84 NAO 85 NAO 86 Bending Mode 1 Bending Mode 2 Bending Mode 3 Bending Mode 4 Torsional Mode 1 Torsional Mode 2 Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] 1966 1.21 4350 1.95 7216 2.22 10284 2.08 3150 1.83 6088 2.16 1984 1.26 4353 2.09 7216 2.31 10275 1.09 3166 1.92 6144 2.13 1969 1.2 4353 1.97 7222 2.18 10279 1.99 3150 1.81 6084 2.13 1997 1.24 4409 1.98 7278 2.12 10450 1.78 3197 1.77 6178 2.03 1966 1.19 4338 1.84 7213 2.07 11250 1.75 3144 1.78 6084 1.91 1972 1.26 4350 1.95 7216 2.2 10281 1.93 3147 1.99 6081 2.13 1972 1.15 4350 1.88 7213 2.11 10322 1.85 3147 1.74 6094 2.08 1966 1.23 4338 1.92 7219 2.2 10306 1.88 3153 1.78 6088 2.19 1966 1.21 4353 1.9 7241 2.09 10294 1.93 3147 1.82 6091 1.72 1972 1.19 4334 1.88 7213 2.11 10266 1.63 3150 1.89 6088 2.06\r\n\r\nNAO77 NAO78 NAO 79 Mode f [Hz] f [Hz] f [Hz] 1 1966 1984 1969 2 3150 3166 3150 3 4350 4353 4353 4 6088 6144 6084 5 7216 7216 7222 6 10284 10275 10279\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n8\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nStartvector 1\r\nCorrelation NAO-77 Opt3 Ex 8302 Mpa Ez 3361 Mpa max 0.69 % min -0.64 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 1962 1966 -0.23% 3152 3150 0.05% 4380 4350 0.69% 6052 6088 -0.59% 7170 7216 -0.64% 9018 100.00% 9080 100.00% 9227 100.00% 10138 10216 -0.77%\r\n\r\nStartvector 2\r\nCorrelation NAO-77 Opt4 Ex 8263 Mpa Ez 2440 Mpa max 0.72 % min -0.65 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 1960 1966 -0.30% 3153 3150 0.09% 4381 4350 0.72% 6058 6088 -0.50% 7169 7216 -0.65% 9021 100.00% 9088 100.00% 9231 100.00% 10118 10216 -0.97%\r\n\r\n=> Identified Value for Ez is not stable for different startvectors\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n9\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nStartvector 1 (Opt 3)\r\n\r\nStartvector 6 (Opt 8)\r\n\r\nStartvector 2 (Opt 4)\r\n\r\nStartvector 3 (Opt 5)\r\n\r\nStartvector 5 (Opt 7)\r\n\r\nStartvector 4 (Opt 6)\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n10\r\n\r\nThe Global Leader in Automotive Safety Systems\r\n\r\n© TRW Automotive 2012\r\n\r\n11\r\n\r\n',	'2016-07-25',	0,	'f18beeb89a3fef2e5c668edc65c4c493',	2,	'txt',	1),
(26,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\newDir\\send mail 7',	'send mail 7',	'output.txt ',	'2016-07-25',	0,	'9a97761e677e2ef5ca8a0b206e557835',	2,	'dir',	1),
(27,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\newDir\\send mail 7\\output.txt',	'output',	'Lining Property Measurement Benchmark Inverse Identification / Alco\r\n\r\nKoblenz, 28.6.2013 Last Update 04.09.2013\r\nHans Giese, Dr.-Ing Specialist CAE\r\nTRW Automotive - Lucas Varity GmbH Carl-Spaeter-Straße 8 D-56070 Koblenz +49(0)261895-2075 hans-martin.giese@trw.com\r\n\r\n© TRW Automotive 2012\r\n\r\nInsert Presentation Name & Date Here\r\n\r\n1\r\n\r\nScope\r\n Measurement and Characterization of different lining materials with different measurement methodologies  Linings:\r\n\r\nECE: NAO: Ceramic:\r\n\r\nGalfer 5503-8 Galfer NCF050 Pagid P40-3W\r\n\r\n Measurement approaches\r\n\r\nEigenfrequencies Compress measurement ALCO ETEK\r\n• Intact Pad • SAE standard • 40x40 mm specimen\r\n\r\nDCTR DCSTR\r\n\r\n© TRW Automotive 2012\r\n\r\nCompress Measurement Setup\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nCeramic Application (Pagid P40-3W)\r\nDensity: 3,06g/cm³ Porosity: ???%\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n3\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\nPad Material ECE 168 ECE 169 ECE 170 ECE 171 ECE 172 ECE 173 ECE 174 ECE 175 ECE 176 ECE 178 Bending Mode 1 Bending Mode 2 Bending Mode 3 Bending Mode 4 Torsional Mode 1 Torsional Mode 2 Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] 2528 1.02 5331 1.39 8384 1.38 11466 1.1 3888 1.31 7328 1.32 2500 1.02 5284 1.35 8369 1.44 11428 1.18 3878 1.3 7294 1.32 2503 0.95 5319 1.32 8387 1.28 11509 1.07 3863 1.19 7294 1.28 2541 1.02 5350 1.41 8456 1.34 11550 1.18 3913 1.25 7378 1.35 2506 0.94 5291 1.22 8325 1.26 11433 1.09 3881 1.22 7294 1.35 2491 1.12 5253 1.49 8284 1.59 11381 1.44 3831 1.42 7219 1.41 2481 1.04 5269 1.37 8328 1.49 11422 1.24 3841 1.27 7288 1.35 2453 1.12 5191 1.51 8200 1.51 11253 1.27 3794 1.44 7172 1.47 2494 1.13 5250 1.49 8266 1.58 11356 1.29 3834 1.42 7225 1.52 2497 1.04 5303 1.46 8391 1.43 11509 1.24 3878 1.38 7328 1.44\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n4\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nCorrelation\r\nmax-dev 0.15 min-dev -0.54 130 0 f_FE [Hz] f_meas [Hz] 2526 2528 3894 3888 5331 5331 7309 7328 8339 8384 9853 10542 11268 11485 11460 13966 14034 14770 15017 16326 17493 17895 18396\r\n© TRW Automotive 2012\r\n\r\n% % 6 dev. % -0.09% 0.15% 0.00% -0.26% -0.54% 100.00% 100.00% 100.00% 0.22% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%\r\n\r\n! t20 p5 generic MAT2 MP, EX, 2, 16940. MP, EY, 2, 16940. MP, EZ, 2, 3654.7 ! GXY=EX/2/(1+PRXY) MP, GXY, 2, 5844.3 MP, GYZ, 2, 4483.3 MP, GXZ, 2, 4483.3 MP, DENS,2, 3.172E-9 MP, PRXY,2, 0.44928 MP, PRYZ,2, 0.89140E -01 MP, PRXZ,2, 0.08914 !\r\n\r\nCompressibility measurement\r\n\r\n5\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nStartvector 1\r\nWith Ez + 1000 MPa\r\nCorrelation ECE168 - Opt3 Ex 16940 Mpa Ez 3655 Mpa dev. E 0.15 % dev. ρ -0.54 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2526 2528 -0.09% 3894 3888 0.15% 5331 5331 0.00% 7309 7328 -0.26% 8339 8384 -0.54% 9853 100.00% 10542 100.00% 11268 100.00% 11485 11460 0.22%\r\nCorrelation ECE168 - Opt3 ez4600 Ex Ez 4600.0 max-dev 0.17 % min-dev -0.30 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2527 2528 -0.05% 3895 3888 0.17% 5338 5331 0.13% 7314 7328 -0.18% 8359 8384 -0.30% 9853 100.00% 10556 100.00% 11278 100.00% 11519 11460 0.51%\r\n\r\nStartvector 2\r\nWith Ez=2500 MPa\r\nCorrelation ECE168 - Opt4 Ex 16911 Mpa Ez 3061 Mpa dev. E 0.12 % dev. ρ -0.54 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 2526 2528 -0.09% 3893 3888 0.12% 5333 5331 0.03% 7310 7328 -0.25% 8339 8384 -0.54% 9854 100.00% 10544 100.00% 11305 100.00% 11481 11460 0.18%\r\n\r\n=> Identified Value for Ez is not stable for different startvectors\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n6\r\n\r\nFRF Measurement\r\nFile: Freq-Damp-dyn-lining-measurement-summary.xlsx\r\n\r\nECE (Galfer 5503-8)\r\nDensity: 2.52 to 2.55 g/cm³ Porosity: 22%\r\n\r\nStartvector 1 (opt 3)\r\n\r\nStartvector 4 (opt 6)\r\n\r\nStartvector 2 (opt 4)\r\n\r\nStartvector 5 (opt 7)\r\n\r\nStartvector 3 (opt 5) => Identified Value for Ez > ~ 3000 MPa\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n7\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\nPad Material NAO 77 NAO 78 NAO 79 NAO 80 NAO 81 NAO 82 NAO 83 NAO 84 NAO 85 NAO 86 Bending Mode 1 Bending Mode 2 Bending Mode 3 Bending Mode 4 Torsional Mode 1 Torsional Mode 2 Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] Frequency [Hz] Damping [%] 1966 1.21 4350 1.95 7216 2.22 10284 2.08 3150 1.83 6088 2.16 1984 1.26 4353 2.09 7216 2.31 10275 1.09 3166 1.92 6144 2.13 1969 1.2 4353 1.97 7222 2.18 10279 1.99 3150 1.81 6084 2.13 1997 1.24 4409 1.98 7278 2.12 10450 1.78 3197 1.77 6178 2.03 1966 1.19 4338 1.84 7213 2.07 11250 1.75 3144 1.78 6084 1.91 1972 1.26 4350 1.95 7216 2.2 10281 1.93 3147 1.99 6081 2.13 1972 1.15 4350 1.88 7213 2.11 10322 1.85 3147 1.74 6094 2.08 1966 1.23 4338 1.92 7219 2.2 10306 1.88 3153 1.78 6088 2.19 1966 1.21 4353 1.9 7241 2.09 10294 1.93 3147 1.82 6091 1.72 1972 1.19 4334 1.88 7213 2.11 10266 1.63 3150 1.89 6088 2.06\r\n\r\nNAO77 NAO78 NAO 79 Mode f [Hz] f [Hz] f [Hz] 1 1966 1984 1969 2 3150 3166 3150 3 4350 4353 4353 4 6088 6144 6084 5 7216 7216 7222 6 10284 10275 10279\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n8\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nStartvector 1\r\nCorrelation NAO-77 Opt3 Ex 8302 Mpa Ez 3361 Mpa max 0.69 % min -0.64 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 1962 1966 -0.23% 3152 3150 0.05% 4380 4350 0.69% 6052 6088 -0.59% 7170 7216 -0.64% 9018 100.00% 9080 100.00% 9227 100.00% 10138 10216 -0.77%\r\n\r\nStartvector 2\r\nCorrelation NAO-77 Opt4 Ex 8263 Mpa Ez 2440 Mpa max 0.72 % min -0.65 % 130 0 6 f_FE [Hz] f_meas [Hz] dev. % 1960 1966 -0.30% 3153 3150 0.09% 4381 4350 0.72% 6058 6088 -0.50% 7169 7216 -0.65% 9021 100.00% 9088 100.00% 9231 100.00% 10118 10216 -0.97%\r\n\r\n=> Identified Value for Ez is not stable for different startvectors\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n9\r\n\r\nFRF Measurement\r\nNAO (Galfer NCF050)\r\nDensity: 2.40 to 2.41 g/cm³ Porosity: 19.4% to 20%\r\n\r\nStartvector 1 (Opt 3)\r\n\r\nStartvector 6 (Opt 8)\r\n\r\nStartvector 2 (Opt 4)\r\n\r\nStartvector 3 (Opt 5)\r\n\r\nStartvector 5 (Opt 7)\r\n\r\nStartvector 4 (Opt 6)\r\n\r\n© TRW Automotive 2012\r\n\r\nCompressibility measurement\r\n\r\n10\r\n\r\nThe Global Leader in Automotive Safety Systems\r\n\r\n© TRW Automotive 2012\r\n\r\n11\r\n\r\n',	'2016-07-25',	0,	'15744ea038d2461708267280ea3a1bdd',	3,	'txt',	1),
(28,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\important.txt',	'important',	'What a mess of a file name! important',	'2016-07-25',	0,	'3662f85281e32e1aceae0ed071f6015f',	1,	'txt',	1),
(29,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\newDir2',	'newDir2',	'runAsCommand.TXT ',	'2016-07-25',	0,	'440544159c91829483a05d0dc08cd152',	1,	'dir',	1),
(30,	'\\\\sjabcz-vyv-fs2\\cae\\04_Knowledge-base\\testReindex\\newDir2\\runAsCommand.TXT',	'runAsCommand',	'l:\\>runas /profile /user:ad.trw.com\\jbccae \"CSCRIPT \\\\sjabcz-vyv-bck\\cae\\ppt2txt.vbs \\\\sjabcz-vyv-bck\\cae\\pp3.ppt \\\\sjabcz-vyv-bck\\cae\\out.pdf\"',	'2016-07-25',	0,	'ea12be2a9c330157b1e1775c1798b268',	2,	'txt',	1),
(32,	'c:\\\\Users\\Lubos\\Documents\\!bankaCertifikat',	'!bankaCertifikat',	'SUK LUBO? (1).p12 Thumbs.db ',	'2016-07-28',	0,	'bc6b648f0df557eb5085371e280dc7e4',	1,	'dir',	3);

DROP TABLE IF EXISTS `linkkeyword0`;
CREATE TABLE `linkkeyword0` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyword0_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword0_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword0` (`linkId`, `keywordId`, `weight`) VALUES
(1,	10,	1),
(1,	24,	5),
(2,	27,	1),
(2,	24,	5),
(3,	27,	1),
(3,	24,	5),
(3,	10,	5),
(4,	38,	1),
(4,	41,	1),
(5,	63,	1),
(5,	79,	1),
(5,	84,	10),
(5,	110,	3),
(5,	115,	1),
(5,	123,	1),
(5,	132,	2),
(5,	161,	1),
(5,	171,	1),
(5,	173,	1),
(5,	27,	6),
(5,	177,	1),
(5,	193,	1),
(5,	210,	2),
(5,	138,	3),
(5,	212,	1),
(5,	243,	1),
(5,	248,	1),
(5,	284,	1),
(5,	291,	1),
(5,	301,	1),
(5,	303,	1),
(5,	361,	1),
(5,	393,	47),
(5,	407,	1),
(5,	409,	1),
(5,	410,	3),
(5,	425,	1),
(5,	427,	2),
(5,	435,	1),
(5,	448,	2),
(5,	475,	1),
(5,	486,	2),
(5,	500,	1),
(6,	79,	1),
(6,	84,	24),
(6,	210,	4),
(6,	523,	1),
(6,	524,	1),
(6,	525,	1),
(6,	393,	7),
(6,	557,	3),
(6,	574,	2),
(6,	603,	4),
(6,	606,	2),
(6,	608,	1),
(6,	27,	6),
(6,	110,	1),
(6,	654,	1),
(6,	661,	3),
(6,	425,	1),
(6,	407,	2),
(6,	674,	1),
(6,	691,	1),
(6,	701,	1),
(6,	706,	1),
(6,	722,	1),
(6,	435,	1),
(6,	410,	1),
(6,	448,	1),
(6,	301,	1),
(6,	756,	1),
(6,	759,	2),
(6,	775,	1),
(6,	776,	3),
(6,	796,	2),
(6,	827,	1),
(6,	839,	3),
(6,	759,	4),
(6,	885,	1),
(6,	893,	1),
(6,	911,	1),
(6,	913,	1),
(6,	934,	1),
(6,	10,	1),
(6,	945,	1),
(6,	951,	1),
(6,	965,	2),
(6,	984,	1),
(6,	991,	1),
(6,	1010,	1),
(6,	1012,	2),
(6,	1042,	2),
(6,	1052,	2),
(6,	138,	2),
(6,	1090,	1),
(6,	1095,	4),
(6,	1106,	1),
(6,	1116,	1),
(6,	1117,	1),
(6,	38,	5),
(7,	59,	1),
(7,	79,	1),
(7,	1190,	5),
(7,	27,	13),
(7,	1202,	1),
(7,	1219,	2),
(7,	410,	1),
(7,	1225,	1),
(7,	1227,	2),
(7,	1244,	1),
(7,	1245,	2),
(7,	1246,	1),
(7,	1249,	1),
(7,	1254,	1),
(7,	1290,	17),
(7,	1350,	1),
(7,	1387,	1),
(7,	1396,	1),
(7,	1404,	6),
(7,	1412,	1),
(7,	1417,	2),
(7,	1425,	1),
(7,	1429,	1),
(7,	1434,	1),
(7,	1452,	1),
(7,	984,	1),
(7,	1012,	1),
(7,	1462,	1),
(7,	1475,	1),
(7,	1484,	1),
(7,	1494,	1),
(7,	1504,	1),
(7,	1510,	1),
(7,	1511,	1),
(7,	41,	5),
(8,	1529,	1),
(8,	210,	2),
(8,	1568,	1),
(11,	27,	1),
(12,	27,	1),
(13,	27,	1),
(14,	27,	4),
(14,	1610,	1),
(15,	27,	1),
(16,	27,	5),
(17,	27,	5),
(17,	1610,	5),
(18,	27,	1),
(19,	27,	5),
(20,	27,	1),
(21,	27,	5),
(22,	1626,	5),
(23,	1626,	5),
(24,	1626,	5),
(25,	59,	1),
(25,	79,	1),
(25,	1190,	5),
(25,	27,	13),
(25,	1202,	1),
(25,	1219,	2),
(25,	410,	1),
(25,	1225,	1),
(25,	1227,	2),
(25,	1244,	1),
(25,	1245,	2),
(25,	1246,	1),
(25,	1249,	1),
(25,	1254,	1),
(25,	1290,	17),
(25,	1350,	1),
(25,	1387,	1),
(25,	1396,	1),
(25,	1404,	6),
(25,	1412,	1),
(25,	1417,	2),
(25,	1425,	1),
(25,	1429,	1),
(25,	1434,	1),
(25,	1452,	1),
(25,	984,	1),
(25,	1012,	1),
(25,	1462,	1),
(25,	1475,	1),
(25,	1484,	1),
(25,	1494,	1),
(25,	1504,	1),
(25,	1510,	1),
(25,	1511,	1),
(25,	1626,	5),
(26,	1626,	5),
(27,	59,	1),
(27,	79,	1),
(27,	1190,	5),
(27,	27,	13),
(27,	1202,	1),
(27,	1219,	2),
(27,	410,	1),
(27,	1225,	1),
(27,	1227,	2),
(27,	1244,	1),
(27,	1245,	2),
(27,	1246,	1),
(27,	1249,	1),
(27,	1254,	1),
(27,	1290,	17),
(27,	1350,	1),
(27,	1387,	1),
(27,	1396,	1),
(27,	1404,	6),
(27,	1412,	1),
(27,	1417,	2),
(27,	1425,	1),
(27,	1429,	1),
(27,	1434,	1),
(27,	1452,	1),
(27,	984,	1),
(27,	1012,	1),
(27,	1462,	1),
(27,	1475,	1),
(27,	1484,	1),
(27,	1494,	1),
(27,	1504,	1),
(27,	1510,	1),
(27,	1511,	1),
(27,	1626,	5),
(28,	210,	2);

DROP TABLE IF EXISTS `linkkeyword1`;
CREATE TABLE `linkkeyword1` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyword1_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword1_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword1` (`linkId`, `keywordId`, `weight`) VALUES
(1,	4,	1),
(1,	5,	1),
(1,	14,	1),
(1,	21,	5),
(2,	21,	5),
(2,	4,	5),
(2,	5,	5),
(3,	21,	5),
(3,	14,	5),
(4,	21,	5),
(5,	51,	1),
(5,	5,	5),
(5,	150,	4),
(5,	195,	1),
(5,	224,	1),
(5,	229,	4),
(5,	259,	1),
(5,	266,	4),
(5,	269,	1),
(5,	46,	1),
(5,	294,	1),
(5,	302,	1),
(5,	322,	1),
(5,	327,	1),
(5,	342,	1),
(5,	387,	1),
(5,	394,	15),
(5,	439,	3),
(5,	401,	1),
(5,	449,	2),
(5,	455,	1),
(5,	456,	1),
(5,	463,	1),
(5,	468,	2),
(5,	21,	5),
(6,	528,	1),
(6,	5,	16),
(6,	266,	15),
(6,	536,	2),
(6,	593,	2),
(6,	594,	1),
(6,	614,	1),
(6,	690,	1),
(6,	698,	1),
(6,	327,	1),
(6,	394,	1),
(6,	723,	1),
(6,	725,	1),
(6,	401,	1),
(6,	455,	1),
(6,	456,	1),
(6,	463,	1),
(6,	762,	1),
(6,	767,	1),
(6,	773,	1),
(6,	528,	1),
(6,	846,	1),
(6,	860,	3),
(6,	878,	1),
(6,	901,	1),
(6,	907,	1),
(6,	928,	1),
(6,	937,	1),
(6,	962,	1),
(6,	976,	1),
(6,	977,	2),
(6,	999,	4),
(6,	1005,	3),
(6,	1009,	2),
(6,	1013,	1),
(6,	1017,	1),
(6,	1019,	2),
(6,	1041,	2),
(6,	969,	2),
(6,	1048,	2),
(6,	1055,	1),
(6,	1056,	1),
(6,	1081,	2),
(6,	1084,	2),
(6,	1089,	1),
(6,	1100,	2),
(6,	1121,	1),
(6,	1138,	1),
(6,	1153,	1),
(6,	21,	5),
(7,	1193,	10),
(7,	1208,	4),
(7,	266,	1),
(7,	1217,	3),
(7,	327,	7),
(7,	394,	1),
(7,	1222,	4),
(7,	401,	2),
(7,	455,	1),
(7,	456,	1),
(7,	976,	1),
(7,	463,	1),
(7,	1258,	1),
(7,	1317,	2),
(7,	1323,	1),
(7,	150,	2),
(7,	1339,	1),
(7,	1352,	1),
(7,	211,	3),
(7,	1005,	2),
(7,	1413,	2),
(7,	999,	2),
(7,	1428,	1),
(7,	1437,	1),
(7,	1447,	2),
(7,	1455,	1),
(7,	1458,	1),
(7,	1463,	1),
(7,	1478,	1),
(7,	1488,	1),
(7,	1490,	1),
(7,	1493,	1),
(7,	1497,	1),
(7,	1498,	1),
(7,	5,	1),
(7,	21,	5),
(8,	1526,	1),
(8,	1530,	1),
(8,	1556,	1),
(8,	1567,	1),
(8,	1574,	1),
(8,	1588,	1),
(8,	21,	5),
(9,	1593,	1),
(9,	21,	5),
(10,	21,	5),
(11,	21,	5),
(12,	21,	5),
(13,	21,	5),
(14,	1606,	2),
(14,	1614,	1),
(14,	1616,	1),
(14,	266,	1),
(14,	1617,	1),
(14,	21,	5),
(15,	21,	5),
(16,	21,	5),
(16,	1606,	5),
(17,	21,	5),
(18,	21,	5),
(19,	21,	5),
(19,	1614,	5),
(20,	21,	5),
(20,	1616,	5),
(21,	21,	5),
(21,	1606,	5),
(21,	1617,	5),
(22,	21,	5),
(23,	21,	5),
(24,	21,	5),
(25,	1193,	10),
(25,	1208,	4),
(25,	266,	1),
(25,	1217,	3),
(25,	327,	7),
(25,	394,	1),
(25,	1222,	4),
(25,	401,	2),
(25,	455,	1),
(25,	456,	1),
(25,	976,	1),
(25,	463,	1),
(25,	1258,	1),
(25,	1317,	2),
(25,	1323,	1),
(25,	150,	2),
(25,	1339,	1),
(25,	1352,	1),
(25,	211,	3),
(25,	1005,	2),
(25,	1413,	2),
(25,	999,	2),
(25,	1428,	1),
(25,	1437,	1),
(25,	1447,	2),
(25,	1455,	1),
(25,	1458,	1),
(25,	1463,	1),
(25,	1478,	1),
(25,	1488,	1),
(25,	1490,	1),
(25,	1493,	1),
(25,	1497,	1),
(25,	1498,	1),
(25,	5,	1),
(25,	21,	5),
(26,	21,	5),
(27,	1193,	10),
(27,	1208,	4),
(27,	266,	1),
(27,	1217,	3),
(27,	327,	7),
(27,	394,	1),
(27,	1222,	4),
(27,	401,	2),
(27,	455,	1),
(27,	456,	1),
(27,	976,	1),
(27,	463,	1),
(27,	1258,	1),
(27,	1317,	2),
(27,	1323,	1),
(27,	150,	2),
(27,	1339,	1),
(27,	1352,	1),
(27,	211,	3),
(27,	1005,	2),
(27,	1413,	2),
(27,	999,	2),
(27,	1428,	1),
(27,	1437,	1),
(27,	1447,	2),
(27,	1455,	1),
(27,	1458,	1),
(27,	1463,	1),
(27,	1478,	1),
(27,	1488,	1),
(27,	1490,	1),
(27,	1493,	1),
(27,	1497,	1),
(27,	1498,	1),
(27,	5,	1),
(27,	21,	5),
(28,	1638,	1),
(28,	21,	5),
(29,	21,	5),
(30,	21,	5);

DROP TABLE IF EXISTS `linkkeyword2`;
CREATE TABLE `linkkeyword2` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `linkId` (`linkId`),
  KEY `keywordId` (`keywordId`),
  CONSTRAINT `linkkeyword2_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword2_ibfk_3` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword2` (`linkId`, `keywordId`, `weight`) VALUES
(1,	7,	1),
(1,	13,	1),
(2,	7,	5),
(3,	13,	5),
(4,	36,	1),
(4,	42,	1),
(5,	52,	1),
(5,	65,	1),
(5,	71,	1),
(5,	98,	1),
(5,	100,	1),
(5,	117,	1),
(5,	120,	2),
(5,	134,	4),
(5,	137,	2),
(5,	151,	4),
(5,	162,	1),
(5,	170,	1),
(5,	194,	1),
(5,	214,	1),
(5,	223,	1),
(5,	267,	28),
(5,	285,	1),
(5,	290,	1),
(5,	297,	1),
(5,	356,	4),
(5,	359,	1),
(5,	388,	1),
(5,	438,	3),
(5,	36,	1),
(5,	489,	1),
(5,	480,	1),
(5,	502,	1),
(6,	52,	1),
(6,	65,	1),
(6,	71,	1),
(6,	522,	1),
(6,	529,	1),
(6,	530,	1),
(6,	532,	1),
(6,	561,	3),
(6,	134,	8),
(6,	597,	2),
(6,	605,	10),
(6,	621,	1),
(6,	630,	1),
(6,	647,	1),
(6,	652,	1),
(6,	657,	1),
(6,	658,	1),
(6,	668,	1),
(6,	36,	5),
(6,	683,	1),
(6,	267,	13),
(6,	689,	1),
(6,	438,	1),
(6,	285,	1),
(6,	734,	1),
(6,	740,	1),
(6,	742,	1),
(6,	797,	3),
(6,	876,	1),
(6,	895,	1),
(6,	906,	1),
(6,	967,	2),
(6,	971,	6),
(6,	979,	1),
(6,	997,	1),
(6,	1003,	6),
(6,	1006,	3),
(6,	1015,	2),
(6,	1026,	1),
(6,	1035,	1),
(6,	1046,	2),
(6,	1047,	2),
(6,	1071,	1),
(6,	1073,	1),
(6,	1079,	1),
(6,	1083,	2),
(6,	502,	1),
(6,	444,	1),
(6,	859,	2),
(6,	1151,	1),
(6,	1152,	1),
(7,	1156,	1),
(7,	65,	1),
(7,	71,	1),
(7,	530,	4),
(7,	1166,	1),
(7,	134,	1),
(7,	1167,	1),
(7,	1180,	1),
(7,	1198,	4),
(7,	1207,	4),
(7,	1226,	1),
(7,	1231,	1),
(7,	1234,	2),
(7,	1237,	2),
(7,	502,	2),
(7,	1274,	2),
(7,	1285,	1),
(7,	1294,	2),
(7,	597,	9),
(7,	267,	1),
(7,	1342,	3),
(7,	1343,	1),
(7,	1345,	1),
(7,	1370,	1),
(7,	1392,	3),
(7,	1400,	1),
(7,	1415,	2),
(7,	1436,	1),
(7,	1453,	3),
(7,	1456,	1),
(7,	1477,	1),
(7,	1480,	1),
(7,	42,	5),
(8,	1583,	1),
(14,	1620,	1),
(21,	1620,	5),
(22,	1624,	1),
(25,	1156,	1),
(25,	65,	1),
(25,	71,	1),
(25,	530,	4),
(25,	1166,	1),
(25,	134,	1),
(25,	1167,	1),
(25,	1180,	1),
(25,	1198,	4),
(25,	1207,	4),
(25,	1226,	1),
(25,	1231,	1),
(25,	1234,	2),
(25,	1237,	2),
(25,	502,	2),
(25,	1274,	2),
(25,	1285,	1),
(25,	1294,	2),
(25,	597,	9),
(25,	267,	1),
(25,	1342,	3),
(25,	1343,	1),
(25,	1345,	1),
(25,	1370,	1),
(25,	1392,	3),
(25,	1400,	1),
(25,	1415,	2),
(25,	1436,	1),
(25,	1453,	3),
(25,	1456,	1),
(25,	1477,	1),
(25,	1480,	1),
(26,	1624,	5),
(27,	1156,	1),
(27,	65,	1),
(27,	71,	1),
(27,	530,	4),
(27,	1166,	1),
(27,	134,	1),
(27,	1167,	1),
(27,	1180,	1),
(27,	1198,	4),
(27,	1207,	4),
(27,	1226,	1),
(27,	1231,	1),
(27,	1234,	2),
(27,	1237,	2),
(27,	502,	2),
(27,	1274,	2),
(27,	1285,	1),
(27,	1294,	2),
(27,	597,	9),
(27,	267,	1),
(27,	1342,	3),
(27,	1343,	1),
(27,	1345,	1),
(27,	1370,	1),
(27,	1392,	3),
(27,	1400,	1),
(27,	1415,	2),
(27,	1436,	1),
(27,	1453,	3),
(27,	1456,	1),
(27,	1477,	1),
(27,	1480,	1),
(27,	1624,	5),
(28,	1643,	5),
(32,	1645,	1);

DROP TABLE IF EXISTS `linkkeyword3`;
CREATE TABLE `linkkeyword3` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyword3_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword3_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword3` (`linkId`, `keywordId`, `weight`) VALUES
(5,	54,	1),
(5,	59,	1),
(5,	62,	1),
(5,	82,	1),
(5,	94,	1),
(5,	122,	3),
(5,	175,	2),
(5,	186,	1),
(5,	190,	2),
(5,	199,	1),
(5,	200,	1),
(5,	242,	1),
(5,	252,	1),
(5,	255,	1),
(5,	260,	1),
(5,	265,	1),
(5,	280,	5),
(5,	298,	1),
(5,	329,	1),
(5,	338,	3),
(5,	374,	6),
(5,	401,	1),
(5,	413,	1),
(5,	417,	1),
(5,	428,	2),
(5,	461,	1),
(5,	480,	2),
(5,	484,	2),
(5,	491,	1),
(5,	508,	1),
(6,	280,	11),
(6,	513,	1),
(6,	82,	1),
(6,	531,	3),
(6,	556,	3),
(6,	562,	3),
(6,	586,	3),
(6,	591,	1),
(6,	618,	1),
(6,	624,	1),
(6,	632,	1),
(6,	633,	1),
(6,	122,	1),
(6,	675,	1),
(6,	676,	1),
(6,	686,	1),
(6,	329,	1),
(6,	374,	1),
(6,	724,	1),
(6,	413,	1),
(6,	417,	1),
(6,	461,	1),
(6,	752,	1),
(6,	787,	1),
(6,	800,	1),
(6,	804,	1),
(6,	806,	3),
(6,	830,	1),
(6,	848,	1),
(6,	870,	1),
(6,	873,	2),
(6,	877,	1),
(6,	897,	1),
(6,	903,	1),
(6,	910,	4),
(6,	938,	1),
(6,	956,	1),
(6,	966,	2),
(6,	975,	2),
(6,	987,	2),
(6,	990,	3),
(6,	1059,	1),
(6,	1063,	3),
(6,	1074,	1),
(6,	1085,	2),
(6,	1091,	1),
(6,	1107,	1),
(6,	1123,	1),
(6,	1127,	1),
(6,	1132,	1),
(7,	1157,	1),
(7,	82,	1),
(7,	966,	1),
(7,	1186,	1),
(7,	329,	1),
(7,	374,	6),
(7,	990,	3),
(7,	413,	2),
(7,	417,	1),
(7,	461,	1),
(7,	1233,	3),
(7,	1236,	3),
(7,	1253,	1),
(7,	1263,	1),
(7,	1275,	3),
(7,	1282,	1),
(7,	1289,	1),
(7,	1302,	1),
(7,	1309,	1),
(7,	586,	2),
(7,	1353,	2),
(7,	1354,	1),
(7,	1359,	1),
(7,	1388,	1),
(7,	1391,	13),
(7,	1402,	7),
(7,	1423,	2),
(7,	1450,	3),
(7,	1486,	1),
(7,	1496,	1),
(7,	1513,	1),
(7,	1515,	1),
(7,	1520,	1),
(8,	280,	1),
(8,	1524,	1),
(8,	1532,	2),
(8,	1538,	1),
(8,	1555,	1),
(8,	877,	1),
(8,	1571,	1),
(8,	1586,	1),
(14,	1612,	1),
(18,	1612,	5),
(24,	1634,	3),
(25,	1157,	1),
(25,	82,	1),
(25,	966,	1),
(25,	1186,	1),
(25,	329,	1),
(25,	374,	6),
(25,	990,	3),
(25,	413,	2),
(25,	417,	1),
(25,	461,	1),
(25,	1233,	3),
(25,	1236,	3),
(25,	1253,	1),
(25,	1263,	1),
(25,	1275,	3),
(25,	1282,	1),
(25,	1289,	1),
(25,	1302,	1),
(25,	1309,	1),
(25,	586,	2),
(25,	1353,	2),
(25,	1354,	1),
(25,	1359,	1),
(25,	1388,	1),
(25,	1391,	13),
(25,	1402,	7),
(25,	1423,	2),
(25,	1450,	3),
(25,	1486,	1),
(25,	1496,	1),
(25,	1513,	1),
(25,	1515,	1),
(25,	1520,	1),
(27,	1157,	1),
(27,	82,	1),
(27,	966,	1),
(27,	1186,	1),
(27,	329,	1),
(27,	374,	6),
(27,	990,	3),
(27,	413,	2),
(27,	417,	1),
(27,	461,	1),
(27,	1233,	3),
(27,	1236,	3),
(27,	1253,	1),
(27,	1263,	1),
(27,	1275,	3),
(27,	1282,	1),
(27,	1289,	1),
(27,	1302,	1),
(27,	1309,	1),
(27,	586,	2),
(27,	1353,	2),
(27,	1354,	1),
(27,	1359,	1),
(27,	1388,	1),
(27,	1391,	13),
(27,	1402,	7),
(27,	1423,	2),
(27,	1450,	3),
(27,	1486,	1),
(27,	1496,	1),
(27,	1513,	1),
(27,	1515,	1),
(27,	1520,	1),
(30,	1634,	3);

DROP TABLE IF EXISTS `linkkeyword4`;
CREATE TABLE `linkkeyword4` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyword4_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword4_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword4` (`linkId`, `keywordId`, `weight`) VALUES
(1,	17,	5),
(1,	9,	5),
(2,	17,	5),
(2,	9,	5),
(3,	17,	5),
(3,	9,	5),
(4,	29,	1),
(4,	35,	1),
(4,	17,	5),
(4,	9,	5),
(4,	45,	5),
(5,	61,	1),
(5,	72,	1),
(5,	88,	1),
(5,	135,	2),
(5,	141,	1),
(5,	153,	28),
(5,	156,	1),
(5,	181,	1),
(5,	203,	2),
(5,	209,	1),
(5,	218,	1),
(5,	232,	3),
(5,	29,	5),
(5,	201,	1),
(5,	256,	1),
(5,	274,	1),
(5,	288,	1),
(5,	296,	1),
(5,	304,	5),
(5,	349,	1),
(5,	354,	2),
(5,	386,	1),
(5,	396,	10),
(5,	424,	1),
(5,	431,	1),
(5,	494,	1),
(5,	17,	5),
(5,	9,	5),
(5,	45,	5),
(6,	72,	1),
(6,	521,	1),
(6,	542,	4),
(6,	153,	42),
(6,	550,	4),
(6,	565,	2),
(6,	580,	1),
(6,	581,	3),
(6,	598,	1),
(6,	602,	3),
(6,	203,	16),
(6,	218,	4),
(6,	629,	1),
(6,	635,	1),
(6,	141,	1),
(6,	651,	1),
(6,	666,	1),
(6,	667,	1),
(6,	29,	5),
(6,	304,	3),
(6,	696,	1),
(6,	714,	1),
(6,	396,	1),
(6,	754,	1),
(6,	766,	1),
(6,	768,	1),
(6,	795,	1),
(6,	808,	2),
(6,	393,	1),
(6,	832,	1),
(6,	835,	1),
(6,	866,	1),
(6,	920,	1),
(6,	930,	1),
(6,	933,	1),
(6,	936,	1),
(6,	947,	1),
(6,	953,	1),
(6,	958,	1),
(6,	980,	5),
(6,	988,	2),
(6,	992,	4),
(6,	1016,	2),
(6,	1023,	2),
(6,	1025,	2),
(6,	159,	2),
(6,	1062,	1),
(6,	1070,	2),
(6,	1088,	1),
(6,	1101,	1),
(6,	1105,	1),
(6,	873,	1),
(6,	35,	5),
(6,	1122,	1),
(6,	930,	1),
(6,	1126,	1),
(6,	1129,	1),
(6,	17,	5),
(6,	9,	5),
(6,	45,	5),
(7,	72,	1),
(7,	1161,	1),
(7,	1163,	1),
(7,	930,	1),
(7,	1191,	5),
(7,	1212,	10),
(7,	304,	1),
(7,	396,	1),
(7,	1248,	1),
(7,	159,	6),
(7,	1278,	2),
(7,	1296,	2),
(7,	1318,	1),
(7,	1327,	1),
(7,	1329,	1),
(7,	1336,	3),
(7,	1348,	1),
(7,	1369,	1),
(7,	203,	1),
(7,	1385,	1),
(7,	1398,	1),
(7,	1410,	1),
(7,	1420,	2),
(7,	1016,	1),
(7,	1442,	1),
(7,	1461,	1),
(7,	1466,	1),
(7,	1507,	1),
(7,	1516,	1),
(7,	17,	5),
(7,	9,	5),
(7,	45,	5),
(8,	1540,	2),
(8,	1558,	1),
(8,	1572,	1),
(8,	17,	5),
(8,	9,	5),
(8,	45,	5),
(9,	17,	5),
(9,	9,	5),
(9,	45,	5),
(10,	17,	5),
(10,	9,	5),
(11,	17,	5),
(11,	9,	5),
(12,	17,	5),
(12,	9,	5),
(13,	17,	5),
(13,	9,	5),
(14,	1607,	1),
(14,	1608,	1),
(14,	1611,	1),
(14,	201,	1),
(14,	17,	5),
(14,	9,	5),
(15,	17,	5),
(15,	9,	5),
(16,	17,	5),
(16,	9,	5),
(16,	1607,	5),
(16,	1608,	5),
(17,	17,	5),
(17,	9,	5),
(18,	17,	5),
(18,	9,	5),
(18,	1611,	5),
(19,	17,	5),
(19,	9,	5),
(20,	17,	5),
(20,	9,	5),
(20,	201,	5),
(21,	17,	5),
(21,	9,	5),
(22,	17,	5),
(22,	9,	5),
(23,	17,	5),
(23,	9,	5),
(24,	1628,	1),
(24,	1629,	1),
(24,	17,	5),
(24,	9,	5),
(25,	72,	1),
(25,	1161,	1),
(25,	1163,	1),
(25,	930,	1),
(25,	1191,	5),
(25,	1212,	10),
(25,	304,	1),
(25,	396,	1),
(25,	1248,	1),
(25,	159,	6),
(25,	1278,	2),
(25,	1296,	2),
(25,	1318,	1),
(25,	1327,	1),
(25,	1329,	1),
(25,	1336,	3),
(25,	1348,	1),
(25,	1369,	1),
(25,	203,	1),
(25,	1385,	1),
(25,	1398,	1),
(25,	1410,	1),
(25,	1420,	2),
(25,	1016,	1),
(25,	1442,	1),
(25,	1461,	1),
(25,	1466,	1),
(25,	1507,	1),
(25,	1516,	1),
(25,	17,	5),
(25,	9,	5),
(26,	17,	5),
(26,	9,	5),
(27,	72,	1),
(27,	1161,	1),
(27,	1163,	1),
(27,	930,	1),
(27,	1191,	5),
(27,	1212,	10),
(27,	304,	1),
(27,	396,	1),
(27,	1248,	1),
(27,	159,	6),
(27,	1278,	2),
(27,	1296,	2),
(27,	1318,	1),
(27,	1327,	1),
(27,	1329,	1),
(27,	1336,	3),
(27,	1348,	1),
(27,	1369,	1),
(27,	203,	1),
(27,	1385,	1),
(27,	1398,	1),
(27,	1410,	1),
(27,	1420,	2),
(27,	1016,	1),
(27,	1442,	1),
(27,	1461,	1),
(27,	1466,	1),
(27,	1507,	1),
(27,	1516,	1),
(27,	17,	5),
(27,	9,	5),
(28,	1642,	1),
(28,	17,	5),
(28,	9,	5),
(29,	17,	5),
(29,	9,	5),
(30,	1628,	1),
(30,	1629,	1),
(30,	17,	5),
(30,	9,	5);

DROP TABLE IF EXISTS `linkkeyword5`;
CREATE TABLE `linkkeyword5` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyword5_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword5_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword5` (`linkId`, `keywordId`, `weight`) VALUES
(1,	6,	1),
(1,	11,	1),
(1,	22,	5),
(2,	22,	5),
(2,	6,	5),
(3,	22,	5),
(3,	11,	5),
(4,	34,	1),
(4,	22,	5),
(5,	34,	3),
(5,	46,	12),
(5,	87,	1),
(5,	130,	1),
(5,	158,	10),
(5,	34,	8),
(5,	202,	1),
(5,	207,	1),
(5,	250,	1),
(5,	318,	4),
(5,	353,	1),
(5,	368,	1),
(5,	378,	1),
(5,	419,	2),
(5,	487,	2),
(5,	501,	1),
(5,	22,	5),
(6,	34,	4),
(6,	544,	2),
(6,	554,	3),
(6,	318,	12),
(6,	563,	1),
(6,	564,	2),
(6,	566,	1),
(6,	573,	1),
(6,	599,	1),
(6,	604,	5),
(6,	640,	1),
(6,	650,	1),
(6,	34,	5),
(6,	656,	1),
(6,	671,	1),
(6,	11,	1),
(6,	713,	2),
(6,	419,	2),
(6,	720,	1),
(6,	730,	1),
(6,	739,	1),
(6,	741,	1),
(6,	750,	1),
(6,	751,	1),
(6,	753,	1),
(6,	755,	4),
(6,	770,	1),
(6,	784,	1),
(6,	836,	1),
(6,	850,	1),
(6,	852,	2),
(6,	862,	1),
(6,	889,	1),
(6,	905,	3),
(6,	914,	1),
(6,	924,	1),
(6,	927,	3),
(6,	941,	1),
(6,	942,	1),
(6,	960,	1),
(6,	970,	2),
(6,	973,	3),
(6,	983,	3),
(6,	993,	1),
(6,	1018,	1),
(6,	1038,	1),
(6,	1087,	1),
(6,	1094,	1),
(6,	1099,	2),
(6,	1118,	1),
(6,	22,	5),
(7,	34,	1),
(7,	46,	1),
(7,	1158,	1),
(7,	1159,	1),
(7,	34,	5),
(7,	544,	2),
(7,	1192,	10),
(7,	1204,	1),
(7,	1205,	7),
(7,	1213,	8),
(7,	1221,	1),
(7,	1229,	3),
(7,	1264,	1),
(7,	1265,	1),
(7,	1291,	8),
(7,	1295,	2),
(7,	1301,	1),
(7,	1308,	1),
(7,	1312,	1),
(7,	1330,	1),
(7,	1340,	1),
(7,	1367,	1),
(7,	1371,	1),
(7,	1376,	2),
(7,	1386,	1),
(7,	1395,	1),
(7,	1421,	1),
(7,	1457,	1),
(7,	1482,	1),
(7,	1517,	1),
(7,	22,	5),
(8,	1522,	4),
(8,	22,	5),
(9,	22,	5),
(10,	22,	5),
(11,	22,	5),
(12,	22,	5),
(13,	22,	5),
(14,	1605,	1),
(14,	22,	5),
(15,	22,	5),
(15,	1605,	5),
(16,	22,	5),
(17,	22,	5),
(18,	22,	5),
(19,	22,	5),
(20,	22,	5),
(21,	22,	5),
(22,	1623,	1),
(22,	22,	5),
(23,	1627,	1),
(23,	22,	5),
(24,	1635,	1),
(24,	22,	5),
(24,	1627,	5),
(25,	34,	1),
(25,	46,	1),
(25,	1158,	1),
(25,	1159,	1),
(25,	34,	5),
(25,	544,	2),
(25,	1192,	10),
(25,	1204,	1),
(25,	1205,	7),
(25,	1213,	8),
(25,	1221,	1),
(25,	1229,	3),
(25,	1264,	1),
(25,	1265,	1),
(25,	1291,	8),
(25,	1295,	2),
(25,	1301,	1),
(25,	1308,	1),
(25,	1312,	1),
(25,	1330,	1),
(25,	1340,	1),
(25,	1367,	1),
(25,	1371,	1),
(25,	1376,	2),
(25,	1386,	1),
(25,	1395,	1),
(25,	1421,	1),
(25,	1457,	1),
(25,	1482,	1),
(25,	1517,	1),
(25,	22,	5),
(25,	1623,	5),
(26,	1623,	1),
(26,	22,	5),
(27,	34,	1),
(27,	46,	1),
(27,	1158,	1),
(27,	1159,	1),
(27,	34,	5),
(27,	544,	2),
(27,	1192,	10),
(27,	1204,	1),
(27,	1205,	7),
(27,	1213,	8),
(27,	1221,	1),
(27,	1229,	3),
(27,	1264,	1),
(27,	1265,	1),
(27,	1291,	8),
(27,	1295,	2),
(27,	1301,	1),
(27,	1308,	1),
(27,	1312,	1),
(27,	1330,	1),
(27,	1340,	1),
(27,	1367,	1),
(27,	1371,	1),
(27,	1376,	2),
(27,	1386,	1),
(27,	1395,	1),
(27,	1421,	1),
(27,	1457,	1),
(27,	1482,	1),
(27,	1517,	1),
(27,	22,	5),
(27,	1623,	5),
(28,	22,	5),
(29,	1627,	1),
(29,	22,	5),
(29,	1644,	5),
(30,	1635,	1),
(30,	22,	5),
(30,	1644,	5),
(30,	1627,	5);

DROP TABLE IF EXISTS `linkkeyword6`;
CREATE TABLE `linkkeyword6` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `linkId` (`linkId`),
  KEY `keywordId` (`keywordId`),
  CONSTRAINT `linkkeyword6_ibfk_1` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword6_ibfk_2` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword6` (`linkId`, `keywordId`, `weight`) VALUES
(1,	8,	1),
(1,	23,	5),
(2,	23,	5),
(3,	23,	5),
(3,	8,	5),
(4,	23,	5),
(5,	57,	1),
(5,	86,	1),
(5,	114,	1),
(5,	126,	1),
(5,	133,	2),
(5,	145,	1),
(5,	184,	1),
(5,	185,	1),
(5,	189,	1),
(5,	197,	1),
(5,	215,	1),
(5,	225,	1),
(5,	246,	1),
(5,	306,	1),
(5,	312,	1),
(5,	320,	2),
(5,	321,	1),
(5,	336,	1),
(5,	357,	2),
(5,	365,	1),
(5,	367,	1),
(5,	398,	1),
(5,	399,	1),
(5,	416,	1),
(5,	420,	1),
(5,	426,	2),
(5,	444,	4),
(5,	465,	1),
(5,	485,	2),
(5,	495,	1),
(5,	498,	1),
(5,	506,	1),
(5,	23,	5),
(6,	512,	1),
(6,	86,	1),
(6,	547,	2),
(6,	320,	7),
(6,	553,	2),
(6,	575,	3),
(6,	578,	2),
(6,	583,	1),
(6,	584,	1),
(6,	589,	7),
(6,	601,	1),
(6,	612,	1),
(6,	625,	1),
(6,	637,	6),
(6,	655,	1),
(6,	670,	2),
(6,	679,	3),
(6,	306,	1),
(6,	699,	1),
(6,	700,	1),
(6,	312,	1),
(6,	444,	1),
(6,	416,	1),
(6,	420,	1),
(6,	133,	1),
(6,	778,	1),
(6,	809,	1),
(6,	815,	1),
(6,	833,	1),
(6,	843,	1),
(6,	844,	1),
(6,	891,	1),
(6,	908,	1),
(6,	465,	9),
(6,	246,	1),
(6,	943,	1),
(6,	948,	1),
(6,	954,	1),
(6,	964,	1),
(6,	969,	1),
(6,	1007,	4),
(6,	1034,	2),
(6,	1039,	1),
(6,	1061,	3),
(6,	1082,	2),
(6,	485,	1),
(6,	498,	1),
(6,	281,	2),
(6,	1134,	2),
(6,	1135,	1),
(6,	1142,	1),
(6,	1143,	1),
(6,	1150,	1),
(6,	23,	5),
(7,	1162,	1),
(7,	1170,	1),
(7,	1175,	1),
(7,	1199,	1),
(7,	1201,	1),
(7,	306,	1),
(7,	969,	13),
(7,	312,	5),
(7,	416,	3),
(7,	420,	1),
(7,	1007,	1),
(7,	465,	1),
(7,	485,	1),
(7,	498,	1),
(7,	1034,	1),
(7,	1243,	1),
(7,	1269,	3),
(7,	145,	6),
(7,	1281,	1),
(7,	1305,	1),
(7,	1310,	1),
(7,	1332,	1),
(7,	1335,	3),
(7,	589,	5),
(7,	1356,	1),
(7,	1362,	1),
(7,	1372,	1),
(7,	1046,	3),
(7,	1414,	5),
(7,	1459,	2),
(7,	1509,	1),
(7,	1518,	1),
(7,	23,	5),
(8,	1551,	5),
(8,	1561,	1),
(8,	1563,	1),
(8,	1582,	1),
(8,	23,	5),
(9,	23,	5),
(10,	23,	5),
(11,	23,	5),
(12,	23,	5),
(13,	23,	5),
(14,	23,	5),
(15,	23,	5),
(16,	23,	5),
(17,	23,	5),
(18,	23,	5),
(19,	23,	5),
(20,	23,	5),
(21,	23,	5),
(22,	23,	5),
(23,	23,	5),
(24,	1637,	1),
(24,	23,	5),
(25,	1162,	1),
(25,	1170,	1),
(25,	1175,	1),
(25,	1199,	1),
(25,	1201,	1),
(25,	306,	1),
(25,	969,	13),
(25,	312,	5),
(25,	416,	3),
(25,	420,	1),
(25,	1007,	1),
(25,	465,	1),
(25,	485,	1),
(25,	498,	1),
(25,	1034,	1),
(25,	1243,	1),
(25,	1269,	3),
(25,	145,	6),
(25,	1281,	1),
(25,	1305,	1),
(25,	1310,	1),
(25,	1332,	1),
(25,	1335,	3),
(25,	589,	5),
(25,	1356,	1),
(25,	1362,	1),
(25,	1372,	1),
(25,	1046,	3),
(25,	1414,	5),
(25,	1459,	2),
(25,	1509,	1),
(25,	1518,	1),
(25,	23,	5),
(26,	23,	5),
(27,	1162,	1),
(27,	1170,	1),
(27,	1175,	1),
(27,	1199,	1),
(27,	1201,	1),
(27,	306,	1),
(27,	969,	13),
(27,	312,	5),
(27,	416,	3),
(27,	420,	1),
(27,	1007,	1),
(27,	465,	1),
(27,	485,	1),
(27,	498,	1),
(27,	1034,	1),
(27,	1243,	1),
(27,	1269,	3),
(27,	145,	6),
(27,	1281,	1),
(27,	1305,	1),
(27,	1310,	1),
(27,	1332,	1),
(27,	1335,	3),
(27,	589,	5),
(27,	1356,	1),
(27,	1362,	1),
(27,	1372,	1),
(27,	1046,	3),
(27,	1414,	5),
(27,	1459,	2),
(27,	1509,	1),
(27,	1518,	1),
(27,	23,	5),
(28,	23,	5),
(29,	23,	5),
(30,	1637,	1),
(30,	23,	5);

DROP TABLE IF EXISTS `linkkeyword7`;
CREATE TABLE `linkkeyword7` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyword7_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword7_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword7` (`linkId`, `keywordId`, `weight`) VALUES
(1,	20,	5),
(2,	20,	5),
(3,	20,	5),
(4,	32,	1),
(4,	43,	1),
(4,	20,	5),
(5,	50,	1),
(5,	68,	1),
(5,	74,	1),
(5,	83,	10),
(5,	92,	2),
(5,	97,	2),
(5,	99,	5),
(5,	105,	1),
(5,	106,	1),
(5,	118,	1),
(5,	142,	1),
(5,	163,	1),
(5,	219,	1),
(5,	226,	4),
(5,	228,	1),
(5,	230,	3),
(5,	264,	1),
(5,	273,	1),
(5,	277,	1),
(5,	279,	1),
(5,	292,	1),
(5,	295,	1),
(5,	311,	1),
(5,	324,	1),
(5,	330,	1),
(5,	340,	1),
(5,	351,	1),
(5,	380,	1),
(5,	383,	1),
(5,	402,	1),
(5,	412,	1),
(5,	414,	3),
(5,	423,	1),
(5,	453,	1),
(5,	482,	1),
(5,	483,	1),
(5,	492,	1),
(5,	493,	1),
(5,	20,	5),
(5,	32,	5),
(6,	514,	1),
(6,	68,	1),
(6,	74,	1),
(6,	83,	28),
(6,	519,	1),
(6,	99,	1),
(6,	534,	1),
(6,	535,	4),
(6,	539,	1),
(6,	546,	1),
(6,	560,	1),
(6,	567,	1),
(6,	569,	2),
(6,	588,	1),
(6,	592,	1),
(6,	97,	1),
(6,	642,	1),
(6,	643,	1),
(6,	163,	1),
(6,	423,	1),
(6,	659,	1),
(6,	414,	2),
(6,	311,	1),
(6,	709,	2),
(6,	219,	1),
(6,	719,	2),
(6,	25,	1),
(6,	732,	1),
(6,	749,	6),
(6,	758,	2),
(6,	791,	1),
(6,	794,	1),
(6,	801,	4),
(6,	803,	4),
(6,	813,	1),
(6,	818,	6),
(6,	819,	1),
(6,	829,	1),
(6,	226,	2),
(6,	840,	1),
(6,	853,	1),
(6,	865,	1),
(6,	874,	1),
(6,	916,	1),
(6,	926,	1),
(6,	952,	1),
(6,	961,	1),
(6,	1001,	1),
(6,	1036,	2),
(6,	118,	2),
(6,	1053,	1),
(6,	1064,	1),
(6,	1065,	1),
(6,	944,	2),
(6,	1076,	1),
(6,	1077,	1),
(6,	1078,	1),
(6,	1093,	1),
(6,	1113,	1),
(6,	1141,	1),
(6,	1148,	1),
(6,	20,	5),
(7,	1154,	1),
(7,	68,	1),
(7,	74,	1),
(7,	83,	11),
(7,	1171,	1),
(7,	1173,	1),
(7,	1185,	1),
(7,	1194,	1),
(7,	311,	5),
(7,	50,	12),
(7,	1218,	1),
(7,	1220,	1),
(7,	1240,	3),
(7,	1242,	1),
(7,	1247,	1),
(7,	1255,	1),
(7,	1260,	1),
(7,	1267,	1),
(7,	1286,	1),
(7,	1306,	6),
(7,	1360,	2),
(7,	1373,	1),
(7,	1377,	1),
(7,	1382,	3),
(7,	1403,	2),
(7,	1408,	2),
(7,	1418,	2),
(7,	1419,	3),
(7,	1441,	1),
(7,	1446,	3),
(7,	1473,	2),
(7,	1481,	1),
(7,	20,	5),
(8,	83,	2),
(8,	1533,	1),
(8,	1535,	1),
(8,	1537,	1),
(8,	1543,	1),
(8,	1559,	1),
(8,	1565,	1),
(8,	1569,	1),
(8,	1570,	1),
(8,	1573,	1),
(8,	1578,	1),
(8,	1587,	1),
(8,	20,	5),
(8,	43,	5),
(9,	1596,	1),
(9,	20,	5),
(10,	1598,	2),
(10,	20,	5),
(11,	20,	5),
(11,	1598,	5),
(12,	20,	5),
(12,	1598,	5),
(13,	20,	5),
(14,	20,	5),
(15,	20,	5),
(16,	20,	5),
(17,	20,	5),
(18,	20,	5),
(19,	20,	5),
(20,	20,	5),
(21,	20,	5),
(22,	20,	5),
(23,	20,	5),
(24,	1630,	1),
(24,	1632,	1),
(24,	20,	5),
(25,	1154,	1),
(25,	68,	1),
(25,	74,	1),
(25,	83,	11),
(25,	1171,	1),
(25,	1173,	1),
(25,	1185,	1),
(25,	1194,	1),
(25,	311,	5),
(25,	50,	12),
(25,	1218,	1),
(25,	1220,	1),
(25,	1240,	3),
(25,	1242,	1),
(25,	1247,	1),
(25,	1255,	1),
(25,	1260,	1),
(25,	1267,	1),
(25,	1286,	1),
(25,	1306,	6),
(25,	1360,	2),
(25,	1373,	1),
(25,	1377,	1),
(25,	1382,	3),
(25,	1403,	2),
(25,	1408,	2),
(25,	1418,	2),
(25,	1419,	3),
(25,	1441,	1),
(25,	1446,	3),
(25,	1473,	2),
(25,	1481,	1),
(25,	20,	5),
(26,	20,	5),
(27,	1154,	1),
(27,	68,	1),
(27,	74,	1),
(27,	83,	11),
(27,	1171,	1),
(27,	1173,	1),
(27,	1185,	1),
(27,	1194,	1),
(27,	311,	5),
(27,	50,	12),
(27,	1218,	1),
(27,	1220,	1),
(27,	1240,	3),
(27,	1242,	1),
(27,	1247,	1),
(27,	1255,	1),
(27,	1260,	1),
(27,	1267,	1),
(27,	1286,	1),
(27,	1306,	6),
(27,	1360,	2),
(27,	1373,	1),
(27,	1377,	1),
(27,	1382,	3),
(27,	1403,	2),
(27,	1408,	2),
(27,	1418,	2),
(27,	1419,	3),
(27,	1441,	1),
(27,	1446,	3),
(27,	1473,	2),
(27,	1481,	1),
(27,	20,	5),
(28,	20,	5),
(29,	20,	5),
(30,	1630,	1),
(30,	1632,	1),
(30,	20,	5);

DROP TABLE IF EXISTS `linkkeyword8`;
CREATE TABLE `linkkeyword8` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyword8_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword8_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword8` (`linkId`, `keywordId`, `weight`) VALUES
(1,	1,	1),
(1,	18,	5),
(2,	18,	5),
(2,	1,	5),
(3,	18,	5),
(4,	31,	1),
(4,	44,	1),
(4,	18,	5),
(5,	47,	1),
(5,	55,	1),
(5,	109,	11),
(5,	111,	1),
(5,	125,	6),
(5,	128,	1),
(5,	138,	1),
(5,	143,	4),
(5,	144,	6),
(5,	143,	3),
(5,	182,	14),
(5,	196,	1),
(5,	198,	1),
(5,	221,	1),
(5,	227,	1),
(5,	233,	1),
(5,	244,	1),
(5,	253,	1),
(5,	261,	1),
(5,	268,	3),
(5,	271,	1),
(5,	281,	1),
(5,	282,	1),
(5,	196,	1),
(5,	319,	2),
(5,	326,	1),
(5,	331,	1),
(5,	334,	1),
(5,	344,	1),
(5,	345,	1),
(5,	355,	1),
(5,	379,	1),
(5,	385,	1),
(5,	391,	1),
(5,	395,	10),
(5,	422,	1),
(5,	433,	3),
(5,	440,	3),
(5,	451,	3),
(5,	477,	1),
(5,	490,	1),
(5,	18,	5),
(5,	31,	5),
(6,	138,	1),
(6,	516,	1),
(6,	533,	1),
(6,	109,	15),
(6,	391,	4),
(6,	111,	8),
(6,	182,	3),
(6,	576,	1),
(6,	577,	1),
(6,	595,	1),
(6,	653,	1),
(6,	422,	1),
(6,	128,	1),
(6,	125,	6),
(6,	663,	1),
(6,	268,	2),
(6,	678,	3),
(6,	144,	3),
(6,	685,	1),
(6,	319,	9),
(6,	227,	2),
(6,	702,	1),
(6,	433,	1),
(6,	440,	1),
(6,	728,	2),
(6,	395,	1),
(6,	729,	1),
(6,	451,	1),
(6,	731,	1),
(6,	738,	1),
(6,	143,	1),
(6,	764,	1),
(6,	777,	2),
(6,	780,	3),
(6,	355,	2),
(6,	798,	4),
(6,	822,	1),
(6,	837,	3),
(6,	841,	1),
(6,	868,	3),
(6,	875,	1),
(6,	331,	1),
(6,	281,	2),
(6,	899,	2),
(6,	921,	1),
(6,	776,	1),
(6,	935,	1),
(6,	915,	4),
(6,	959,	1),
(6,	963,	1),
(6,	986,	1),
(6,	1021,	1),
(6,	1066,	1),
(6,	1109,	1),
(6,	1132,	2),
(6,	18,	5),
(7,	109,	1),
(7,	1177,	1),
(7,	1187,	1),
(7,	1195,	4),
(7,	1197,	4),
(7,	276,	4),
(7,	268,	1),
(7,	395,	1),
(7,	1224,	2),
(7,	1238,	2),
(7,	143,	15),
(7,	1287,	1),
(7,	1288,	1),
(7,	1314,	1),
(7,	414,	8),
(7,	1338,	1),
(7,	1357,	1),
(7,	1021,	1),
(7,	1426,	2),
(7,	1440,	3),
(7,	1449,	2),
(7,	1468,	1),
(7,	1474,	1),
(7,	1495,	1),
(7,	1500,	1),
(7,	1501,	1),
(7,	1502,	1),
(7,	18,	5),
(8,	1528,	2),
(8,	144,	1),
(8,	1545,	1),
(8,	1547,	1),
(8,	1560,	1),
(8,	1575,	1),
(8,	1580,	1),
(8,	18,	5),
(9,	1590,	1),
(9,	1591,	1),
(9,	1594,	1),
(9,	18,	5),
(9,	44,	5),
(10,	1602,	1),
(10,	18,	5),
(10,	1603,	5),
(11,	18,	5),
(11,	1603,	5),
(12,	18,	5),
(12,	1603,	5),
(13,	18,	5),
(13,	1603,	5),
(13,	1602,	5),
(14,	915,	1),
(14,	18,	5),
(15,	18,	5),
(16,	18,	5),
(17,	18,	5),
(17,	915,	5),
(18,	18,	5),
(19,	18,	5),
(20,	18,	5),
(21,	18,	5),
(22,	1622,	1),
(22,	18,	5),
(23,	18,	5),
(23,	1622,	5),
(24,	1631,	1),
(24,	18,	5),
(24,	1622,	5),
(25,	109,	1),
(25,	1177,	1),
(25,	1187,	1),
(25,	1195,	4),
(25,	1197,	4),
(25,	276,	4),
(25,	268,	1),
(25,	395,	1),
(25,	1224,	2),
(25,	1238,	2),
(25,	143,	15),
(25,	1287,	1),
(25,	1288,	1),
(25,	1314,	1),
(25,	414,	8),
(25,	1338,	1),
(25,	1357,	1),
(25,	1021,	1),
(25,	1426,	2),
(25,	1440,	3),
(25,	1449,	2),
(25,	1468,	1),
(25,	1474,	1),
(25,	1495,	1),
(25,	1500,	1),
(25,	1501,	1),
(25,	1502,	1),
(25,	18,	5),
(26,	18,	5),
(27,	109,	1),
(27,	1177,	1),
(27,	1187,	1),
(27,	1195,	4),
(27,	1197,	4),
(27,	276,	4),
(27,	268,	1),
(27,	395,	1),
(27,	1224,	2),
(27,	1238,	2),
(27,	143,	15),
(27,	1287,	1),
(27,	1288,	1),
(27,	1314,	1),
(27,	414,	8),
(27,	1338,	1),
(27,	1357,	1),
(27,	1021,	1),
(27,	1426,	2),
(27,	1440,	3),
(27,	1449,	2),
(27,	1468,	1),
(27,	1474,	1),
(27,	1495,	1),
(27,	1500,	1),
(27,	1501,	1),
(27,	1502,	1),
(27,	18,	5),
(28,	109,	1),
(28,	1640,	1),
(28,	18,	5),
(29,	18,	5),
(30,	1631,	1),
(30,	18,	5);

DROP TABLE IF EXISTS `linkkeyword9`;
CREATE TABLE `linkkeyword9` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyword9_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyword9_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyword9` (`linkId`, `keywordId`, `weight`) VALUES
(1,	3,	1),
(2,	26,	1),
(2,	3,	5),
(3,	26,	1),
(4,	30,	1),
(5,	56,	1),
(5,	112,	5),
(5,	136,	1),
(5,	140,	3),
(5,	148,	1),
(5,	152,	15),
(5,	155,	1),
(5,	159,	1),
(5,	164,	1),
(5,	166,	1),
(5,	174,	2),
(5,	183,	1),
(5,	204,	1),
(5,	206,	1),
(5,	213,	1),
(5,	216,	3),
(5,	220,	1),
(5,	234,	4),
(5,	241,	1),
(5,	245,	1),
(5,	257,	1),
(5,	272,	1),
(5,	299,	1),
(5,	300,	1),
(5,	310,	1),
(5,	313,	1),
(5,	328,	1),
(5,	362,	1),
(5,	364,	1),
(5,	366,	1),
(5,	400,	1),
(5,	406,	1),
(5,	415,	2),
(5,	429,	3),
(5,	452,	3),
(5,	497,	1),
(5,	503,	1),
(5,	510,	5),
(5,	30,	5),
(6,	517,	1),
(6,	518,	1),
(6,	527,	1),
(6,	536,	9),
(6,	548,	4),
(6,	616,	1),
(6,	622,	1),
(6,	623,	1),
(6,	638,	6),
(6,	93,	10),
(6,	140,	1),
(6,	164,	1),
(6,	166,	1),
(6,	112,	3),
(6,	665,	2),
(6,	669,	1),
(6,	681,	3),
(6,	682,	3),
(6,	692,	1),
(6,	697,	1),
(6,	704,	1),
(6,	310,	4),
(6,	328,	1),
(6,	727,	1),
(6,	452,	1),
(6,	736,	1),
(6,	743,	1),
(6,	747,	1),
(6,	763,	1),
(6,	765,	1),
(6,	774,	3),
(6,	783,	2),
(6,	785,	3),
(6,	789,	1),
(6,	799,	3),
(6,	802,	5),
(6,	812,	1),
(6,	823,	1),
(6,	834,	1),
(6,	856,	1),
(6,	858,	3),
(6,	863,	1),
(6,	881,	1),
(6,	883,	1),
(6,	894,	1),
(6,	896,	2),
(6,	757,	1),
(6,	923,	1),
(6,	978,	3),
(6,	981,	2),
(6,	1020,	4),
(6,	1024,	2),
(6,	1032,	1),
(6,	1067,	1),
(6,	1068,	1),
(6,	1072,	1),
(6,	204,	1),
(6,	1080,	1),
(6,	503,	1),
(6,	1111,	1),
(6,	1114,	1),
(6,	1119,	1),
(6,	1133,	1),
(6,	1145,	1),
(7,	774,	4),
(7,	1155,	1),
(7,	1165,	1),
(7,	1169,	1),
(7,	310,	8),
(7,	328,	5),
(7,	503,	1),
(7,	510,	1),
(7,	1032,	1),
(7,	1259,	1),
(7,	1262,	1),
(7,	1266,	1),
(7,	313,	2),
(7,	1279,	2),
(7,	1283,	1),
(7,	1304,	10),
(7,	1311,	1),
(7,	1321,	1),
(7,	1326,	1),
(7,	1333,	1),
(7,	1341,	1),
(7,	1384,	1),
(7,	1411,	6),
(7,	1416,	2),
(7,	1432,	1),
(7,	1433,	1),
(7,	1454,	2),
(7,	1471,	1),
(7,	1479,	1),
(7,	1499,	1),
(7,	1512,	1),
(8,	1531,	1),
(8,	1541,	2),
(8,	1544,	1),
(8,	1548,	1),
(8,	1553,	3),
(8,	1551,	1),
(8,	1566,	1),
(8,	353,	1),
(8,	1585,	1),
(10,	1597,	2),
(11,	26,	1),
(11,	1597,	5),
(12,	26,	1),
(12,	1597,	5),
(13,	26,	1),
(14,	1615,	1),
(15,	26,	1),
(16,	26,	1),
(17,	26,	1),
(18,	26,	1),
(19,	26,	1),
(20,	26,	1),
(20,	1615,	5),
(21,	26,	1),
(25,	774,	4),
(25,	1155,	1),
(25,	1165,	1),
(25,	1169,	1),
(25,	310,	8),
(25,	328,	5),
(25,	503,	1),
(25,	510,	1),
(25,	1032,	1),
(25,	1259,	1),
(25,	1262,	1),
(25,	1266,	1),
(25,	313,	2),
(25,	1279,	2),
(25,	1283,	1),
(25,	1304,	10),
(25,	1311,	1),
(25,	1321,	1),
(25,	1326,	1),
(25,	1333,	1),
(25,	1341,	1),
(25,	1384,	1),
(25,	1411,	6),
(25,	1416,	2),
(25,	1432,	1),
(25,	1433,	1),
(25,	1454,	2),
(25,	1471,	1),
(25,	1479,	1),
(25,	1499,	1),
(25,	1512,	1),
(27,	774,	4),
(27,	1155,	1),
(27,	1165,	1),
(27,	1169,	1),
(27,	310,	8),
(27,	328,	5),
(27,	503,	1),
(27,	510,	1),
(27,	1032,	1),
(27,	1259,	1),
(27,	1262,	1),
(27,	1266,	1),
(27,	313,	2),
(27,	1279,	2),
(27,	1283,	1),
(27,	1304,	10),
(27,	1311,	1),
(27,	1321,	1),
(27,	1326,	1),
(27,	1333,	1),
(27,	1341,	1),
(27,	1384,	1),
(27,	1411,	6),
(27,	1416,	2),
(27,	1432,	1),
(27,	1433,	1),
(27,	1454,	2),
(27,	1471,	1),
(27,	1479,	1),
(27,	1499,	1),
(27,	1512,	1);

DROP TABLE IF EXISTS `linkkeyworda`;
CREATE TABLE `linkkeyworda` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `linkId` (`linkId`),
  KEY `keywordId` (`keywordId`),
  CONSTRAINT `linkkeyworda_ibfk_1` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyworda_ibfk_2` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyworda` (`linkId`, `keywordId`, `weight`) VALUES
(5,	64,	1),
(5,	75,	1),
(5,	20,	1),
(5,	102,	4),
(5,	121,	1),
(5,	147,	2),
(5,	167,	1),
(5,	192,	5),
(5,	192,	1),
(5,	211,	2),
(5,	235,	1),
(5,	283,	1),
(5,	309,	1),
(5,	315,	1),
(5,	317,	1),
(5,	341,	14),
(5,	377,	1),
(5,	384,	1),
(5,	403,	1),
(5,	404,	1),
(5,	437,	3),
(5,	441,	6),
(5,	457,	1),
(5,	458,	1),
(5,	462,	1),
(5,	478,	1),
(5,	488,	1),
(5,	437,	1),
(5,	507,	1),
(6,	36,	2),
(6,	64,	1),
(6,	75,	1),
(6,	20,	16),
(6,	526,	1),
(6,	537,	10),
(6,	540,	1),
(6,	541,	1),
(6,	317,	14),
(6,	549,	4),
(6,	552,	4),
(6,	570,	2),
(6,	571,	2),
(6,	610,	6),
(6,	619,	3),
(6,	626,	1),
(6,	639,	1),
(6,	641,	1),
(6,	646,	1),
(6,	664,	1),
(6,	677,	3),
(6,	309,	1),
(6,	441,	2),
(6,	457,	1),
(6,	458,	1),
(6,	462,	1),
(6,	746,	1),
(6,	760,	1),
(6,	782,	1),
(6,	842,	1),
(6,	887,	1),
(6,	904,	1),
(6,	363,	1),
(6,	192,	4),
(6,	250,	2),
(6,	982,	1),
(6,	995,	1),
(6,	1008,	1),
(6,	1027,	1),
(6,	1028,	4),
(6,	1040,	1),
(6,	1050,	2),
(6,	1108,	1),
(6,	1110,	1),
(6,	1125,	1),
(6,	1137,	1),
(6,	1149,	1),
(7,	64,	1),
(7,	75,	1),
(7,	1178,	1),
(7,	1184,	1),
(7,	1189,	5),
(7,	20,	1),
(7,	309,	7),
(7,	457,	1),
(7,	458,	1),
(7,	462,	1),
(7,	1232,	2),
(7,	437,	1),
(7,	1257,	1),
(7,	1271,	6),
(7,	1292,	10),
(7,	1293,	4),
(7,	1297,	3),
(7,	1298,	25),
(7,	1320,	1),
(7,	1324,	1),
(7,	1346,	2),
(7,	1351,	1),
(7,	1365,	1),
(7,	1366,	1),
(7,	1368,	1),
(7,	192,	2),
(7,	1390,	1),
(7,	1399,	1),
(7,	1431,	1),
(7,	1438,	2),
(7,	1448,	1),
(7,	1483,	1),
(7,	1489,	1),
(8,	1536,	1),
(8,	1523,	1),
(8,	1546,	1),
(8,	1526,	1),
(9,	1592,	2),
(14,	1604,	1),
(14,	20,	1),
(14,	1618,	1),
(15,	1604,	5),
(21,	1618,	5),
(24,	1636,	1),
(25,	64,	1),
(25,	75,	1),
(25,	1178,	1),
(25,	1184,	1),
(25,	1189,	5),
(25,	20,	1),
(25,	309,	7),
(25,	457,	1),
(25,	458,	1),
(25,	462,	1),
(25,	1232,	2),
(25,	437,	1),
(25,	1257,	1),
(25,	1271,	6),
(25,	1292,	10),
(25,	1293,	4),
(25,	1297,	3),
(25,	1298,	25),
(25,	1320,	1),
(25,	1324,	1),
(25,	1346,	2),
(25,	1351,	1),
(25,	1365,	1),
(25,	1366,	1),
(25,	1368,	1),
(25,	192,	2),
(25,	1390,	1),
(25,	1399,	1),
(25,	1431,	1),
(25,	1438,	2),
(25,	1448,	1),
(25,	1483,	1),
(25,	1489,	1),
(27,	64,	1),
(27,	75,	1),
(27,	1178,	1),
(27,	1184,	1),
(27,	1189,	5),
(27,	20,	1),
(27,	309,	7),
(27,	457,	1),
(27,	458,	1),
(27,	462,	1),
(27,	1232,	2),
(27,	437,	1),
(27,	1257,	1),
(27,	1271,	6),
(27,	1292,	10),
(27,	1293,	4),
(27,	1297,	3),
(27,	1298,	25),
(27,	1320,	1),
(27,	1324,	1),
(27,	1346,	2),
(27,	1351,	1),
(27,	1365,	1),
(27,	1366,	1),
(27,	1368,	1),
(27,	192,	2),
(27,	1390,	1),
(27,	1399,	1),
(27,	1431,	1),
(27,	1438,	2),
(27,	1448,	1),
(27,	1483,	1),
(27,	1489,	1),
(30,	1636,	1);

DROP TABLE IF EXISTS `linkkeywordb`;
CREATE TABLE `linkkeywordb` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeywordb_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeywordb_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeywordb` (`linkId`, `keywordId`, `weight`) VALUES
(1,	9,	1),
(1,	12,	1),
(2,	25,	1),
(3,	25,	1),
(3,	9,	5),
(3,	12,	5),
(4,	40,	1),
(5,	53,	1),
(5,	69,	11),
(5,	85,	10),
(5,	127,	2),
(5,	157,	1),
(5,	179,	1),
(5,	180,	1),
(5,	217,	1),
(5,	238,	7),
(5,	240,	1),
(5,	251,	1),
(5,	254,	1),
(5,	270,	1),
(5,	276,	1),
(5,	278,	1),
(5,	289,	1),
(5,	314,	2),
(5,	346,	1),
(5,	347,	1),
(5,	348,	4),
(5,	358,	14),
(5,	371,	1),
(5,	397,	2),
(5,	429,	2),
(5,	434,	3),
(5,	436,	3),
(5,	443,	3),
(5,	496,	1),
(5,	505,	1),
(6,	53,	1),
(6,	69,	25),
(6,	85,	24),
(6,	238,	12),
(6,	543,	1),
(6,	555,	3),
(6,	596,	1),
(6,	607,	1),
(6,	627,	4),
(6,	628,	2),
(6,	240,	1),
(6,	127,	1),
(6,	638,	1),
(6,	278,	1),
(6,	693,	1),
(6,	703,	1),
(6,	705,	1),
(6,	358,	1),
(6,	718,	1),
(6,	721,	1),
(6,	726,	1),
(6,	436,	1),
(6,	443,	1),
(6,	314,	1),
(6,	771,	1),
(6,	786,	2),
(6,	790,	1),
(6,	792,	1),
(6,	793,	1),
(6,	805,	2),
(6,	807,	1),
(6,	810,	1),
(6,	828,	1),
(6,	838,	5),
(6,	348,	3),
(6,	849,	1),
(6,	854,	1),
(6,	861,	1),
(6,	884,	1),
(6,	902,	2),
(6,	917,	1),
(6,	919,	1),
(6,	922,	1),
(6,	940,	1),
(6,	944,	1),
(6,	657,	1),
(6,	972,	1),
(6,	998,	1),
(6,	1000,	1),
(6,	1002,	1),
(6,	1037,	1),
(6,	250,	1),
(6,	1042,	1),
(6,	1146,	1),
(7,	69,	13),
(7,	238,	1),
(7,	1172,	1),
(7,	1183,	1),
(7,	443,	9),
(7,	1206,	1),
(7,	1210,	4),
(7,	1211,	1),
(7,	358,	5),
(7,	1223,	3),
(7,	1235,	2),
(7,	505,	1),
(7,	1299,	1),
(7,	1316,	1),
(7,	1363,	1),
(7,	1380,	1),
(7,	1381,	2),
(7,	1389,	3),
(7,	1439,	1),
(7,	1451,	1),
(7,	1465,	1),
(7,	1467,	1),
(7,	1000,	1),
(7,	1037,	1),
(7,	1492,	2),
(7,	40,	5),
(8,	69,	2),
(8,	1534,	1),
(8,	1554,	1),
(11,	25,	1),
(12,	25,	1),
(13,	25,	1),
(15,	25,	1),
(16,	25,	1),
(17,	25,	1),
(18,	25,	1),
(19,	25,	1),
(20,	25,	1),
(21,	25,	1),
(22,	1625,	1),
(25,	69,	13),
(25,	238,	1),
(25,	1172,	1),
(25,	1183,	1),
(25,	443,	9),
(25,	1206,	1),
(25,	1210,	4),
(25,	1211,	1),
(25,	358,	5),
(25,	1223,	3),
(25,	1235,	2),
(25,	505,	1),
(25,	1299,	1),
(25,	1316,	1),
(25,	1363,	1),
(25,	1380,	1),
(25,	1381,	2),
(25,	1389,	3),
(25,	1439,	1),
(25,	1451,	1),
(25,	1465,	1),
(25,	1467,	1),
(25,	1000,	1),
(25,	1037,	1),
(25,	1492,	2),
(26,	1625,	5),
(27,	69,	13),
(27,	238,	1),
(27,	1172,	1),
(27,	1183,	1),
(27,	443,	9),
(27,	1206,	1),
(27,	1210,	4),
(27,	1211,	1),
(27,	358,	5),
(27,	1223,	3),
(27,	1235,	2),
(27,	505,	1),
(27,	1299,	1),
(27,	1316,	1),
(27,	1363,	1),
(27,	1380,	1),
(27,	1381,	2),
(27,	1389,	3),
(27,	1439,	1),
(27,	1451,	1),
(27,	1465,	1),
(27,	1467,	1),
(27,	1000,	1),
(27,	1037,	1),
(27,	1492,	2),
(27,	1625,	5);

DROP TABLE IF EXISTS `linkkeywordc`;
CREATE TABLE `linkkeywordc` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeywordc_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeywordc_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeywordc` (`linkId`, `keywordId`, `weight`) VALUES
(4,	1,	1),
(4,	33,	1),
(4,	39,	1),
(5,	49,	5),
(5,	1,	11),
(5,	33,	1),
(5,	39,	1),
(5,	66,	1),
(5,	70,	1),
(5,	101,	1),
(5,	116,	1),
(5,	119,	3),
(5,	129,	2),
(5,	139,	1),
(5,	149,	2),
(5,	201,	7),
(5,	208,	1),
(5,	222,	1),
(5,	262,	1),
(5,	275,	1),
(5,	307,	1),
(5,	308,	1),
(5,	285,	1),
(5,	316,	1),
(5,	333,	1),
(5,	373,	1),
(5,	389,	1),
(5,	405,	7),
(5,	411,	1),
(5,	418,	1),
(5,	430,	2),
(5,	474,	1),
(5,	499,	1),
(6,	515,	1),
(6,	66,	1),
(6,	70,	1),
(6,	1,	2),
(6,	33,	1),
(6,	39,	1),
(6,	149,	3),
(6,	558,	2),
(6,	590,	1),
(6,	208,	1),
(6,	613,	1),
(6,	615,	1),
(6,	634,	1),
(6,	139,	1),
(6,	645,	1),
(6,	275,	1),
(6,	688,	1),
(6,	307,	1),
(6,	308,	1),
(6,	285,	3),
(6,	711,	1),
(6,	418,	1),
(6,	757,	3),
(6,	761,	1),
(6,	772,	1),
(6,	831,	2),
(6,	847,	1),
(6,	867,	2),
(6,	879,	1),
(6,	892,	1),
(6,	918,	1),
(6,	931,	1),
(6,	932,	2),
(6,	946,	1),
(6,	949,	1),
(6,	49,	1),
(6,	968,	1),
(6,	985,	1),
(6,	996,	1),
(6,	1014,	1),
(6,	1069,	1),
(6,	499,	1),
(6,	1104,	1),
(7,	49,	1),
(7,	66,	1),
(7,	70,	1),
(7,	1,	2),
(7,	33,	1),
(7,	39,	1),
(7,	1160,	1),
(7,	1168,	1),
(7,	1181,	1),
(7,	1188,	9),
(7,	275,	1),
(7,	307,	1),
(7,	308,	1),
(7,	285,	5),
(7,	1214,	4),
(7,	1215,	12),
(7,	418,	1),
(7,	1230,	2),
(7,	499,	1),
(7,	1256,	1),
(7,	1284,	1),
(7,	1307,	2),
(7,	1334,	2),
(7,	1361,	1),
(7,	405,	1),
(7,	1393,	1),
(7,	1401,	1),
(7,	1405,	2),
(7,	1470,	1),
(7,	1472,	1),
(7,	1503,	1),
(7,	1508,	1),
(8,	1523,	1),
(8,	1550,	1),
(8,	1577,	1),
(8,	1579,	1),
(8,	1,	1),
(8,	33,	1),
(8,	39,	1),
(9,	1589,	1),
(10,	1,	1),
(10,	33,	1),
(11,	1,	5),
(12,	1,	5),
(14,	1,	1),
(14,	33,	1),
(14,	39,	1),
(14,	1613,	1),
(14,	1619,	1),
(15,	1,	5),
(16,	1,	5),
(17,	1,	5),
(18,	1,	5),
(19,	1,	5),
(19,	1613,	5),
(20,	1,	5),
(21,	1,	5),
(21,	1619,	5),
(22,	1,	1),
(25,	49,	1),
(25,	66,	1),
(25,	70,	1),
(25,	1,	2),
(25,	33,	1),
(25,	39,	1),
(25,	1160,	1),
(25,	1168,	1),
(25,	1181,	1),
(25,	1188,	9),
(25,	275,	1),
(25,	307,	1),
(25,	308,	1),
(25,	285,	5),
(25,	1214,	4),
(25,	1215,	12),
(25,	418,	1),
(25,	1230,	2),
(25,	499,	1),
(25,	1256,	1),
(25,	1284,	1),
(25,	1307,	2),
(25,	1334,	2),
(25,	1361,	1),
(25,	405,	1),
(25,	1393,	1),
(25,	1401,	1),
(25,	1405,	2),
(25,	1470,	1),
(25,	1472,	1),
(25,	1503,	1),
(25,	1508,	1),
(26,	1,	5),
(27,	49,	1),
(27,	66,	1),
(27,	70,	1),
(27,	1,	2),
(27,	33,	1),
(27,	39,	1),
(27,	1160,	1),
(27,	1168,	1),
(27,	1181,	1),
(27,	1188,	9),
(27,	275,	1),
(27,	307,	1),
(27,	308,	1),
(27,	285,	5),
(27,	1214,	4),
(27,	1215,	12),
(27,	418,	1),
(27,	1230,	2),
(27,	499,	1),
(27,	1256,	1),
(27,	1284,	1),
(27,	1307,	2),
(27,	1334,	2),
(27,	1361,	1),
(27,	405,	1),
(27,	1393,	1),
(27,	1401,	1),
(27,	1405,	2),
(27,	1470,	1),
(27,	1472,	1),
(27,	1503,	1),
(27,	1508,	1);

DROP TABLE IF EXISTS `linkkeywordd`;
CREATE TABLE `linkkeywordd` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeywordd_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeywordd_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeywordd` (`linkId`, `keywordId`, `weight`) VALUES
(1,	16,	10),
(2,	16,	10),
(3,	16,	10),
(4,	16,	10),
(5,	48,	5),
(5,	16,	10),
(5,	29,	1),
(5,	58,	1),
(5,	67,	1),
(5,	89,	13),
(5,	90,	2),
(5,	91,	1),
(5,	93,	5),
(5,	95,	1),
(5,	107,	1),
(5,	113,	1),
(5,	124,	1),
(5,	160,	2),
(5,	169,	6),
(5,	176,	2),
(5,	178,	1),
(5,	188,	1),
(5,	191,	1),
(5,	236,	1),
(5,	249,	1),
(5,	263,	1),
(5,	305,	1),
(5,	335,	1),
(5,	350,	5),
(5,	360,	1),
(5,	363,	1),
(5,	382,	1),
(5,	392,	1),
(5,	432,	3),
(5,	445,	3),
(5,	459,	1),
(5,	460,	1),
(5,	466,	1),
(5,	469,	1),
(5,	470,	1),
(5,	504,	1),
(6,	90,	2),
(6,	29,	7),
(6,	67,	1),
(6,	16,	10),
(6,	89,	13),
(6,	178,	1),
(6,	443,	4),
(6,	587,	2),
(6,	600,	1),
(6,	617,	1),
(6,	621,	3),
(6,	631,	1),
(6,	169,	6),
(6,	48,	6),
(6,	93,	1),
(6,	672,	1),
(6,	305,	1),
(6,	707,	1),
(6,	710,	4),
(6,	432,	1),
(6,	445,	1),
(6,	459,	1),
(6,	460,	1),
(6,	735,	1),
(6,	744,	1),
(6,	769,	1),
(6,	779,	1),
(6,	811,	1),
(6,	814,	5),
(6,	816,	1),
(6,	817,	1),
(6,	820,	2),
(6,	821,	1),
(6,	826,	1),
(6,	855,	1),
(6,	857,	3),
(6,	363,	1),
(6,	871,	1),
(6,	872,	1),
(6,	880,	1),
(6,	886,	1),
(6,	912,	1),
(6,	236,	1),
(6,	925,	1),
(6,	939,	1),
(6,	950,	1),
(6,	144,	2),
(6,	466,	2),
(6,	910,	15),
(6,	974,	3),
(6,	1011,	1),
(6,	1030,	2),
(6,	1044,	2),
(6,	1049,	2),
(6,	1058,	1),
(6,	1060,	1),
(6,	1112,	1),
(6,	1124,	1),
(6,	1128,	1),
(6,	1130,	1),
(6,	1147,	1),
(6,	504,	5),
(7,	16,	10),
(7,	58,	1),
(7,	67,	1),
(7,	1164,	1),
(7,	774,	6),
(7,	1176,	1),
(7,	1179,	1),
(7,	29,	1),
(7,	1209,	4),
(7,	90,	2),
(7,	305,	1),
(7,	707,	27),
(7,	459,	1),
(7,	460,	1),
(7,	466,	1),
(7,	504,	1),
(7,	1250,	1),
(7,	643,	4),
(7,	1270,	6),
(7,	1272,	3),
(7,	1276,	3),
(7,	1303,	1),
(7,	1313,	1),
(7,	1315,	1),
(7,	1322,	1),
(7,	1328,	1),
(7,	1344,	1),
(7,	89,	5),
(7,	710,	2),
(7,	1397,	1),
(7,	1409,	7),
(7,	1422,	1),
(7,	1430,	1),
(7,	1445,	1),
(7,	1460,	1),
(7,	1485,	1),
(7,	1487,	1),
(7,	1378,	6),
(7,	1514,	1),
(7,	1519,	1),
(8,	1527,	1),
(8,	1552,	1),
(8,	1564,	1),
(8,	16,	10),
(9,	16,	10),
(10,	1599,	1),
(10,	1600,	1),
(10,	16,	10),
(11,	16,	10),
(11,	1599,	5),
(12,	16,	10),
(12,	1600,	5),
(13,	16,	10),
(14,	1128,	1),
(14,	1606,	2),
(14,	48,	2),
(14,	29,	1),
(14,	16,	10),
(15,	16,	10),
(16,	16,	10),
(16,	1128,	5),
(17,	16,	10),
(17,	1606,	5),
(17,	48,	5),
(18,	16,	10),
(19,	16,	10),
(19,	1606,	5),
(20,	16,	10),
(20,	29,	5),
(21,	16,	10),
(21,	48,	5),
(22,	16,	10),
(23,	16,	10),
(24,	16,	10),
(25,	16,	10),
(25,	58,	1),
(25,	67,	1),
(25,	1164,	1),
(25,	774,	6),
(25,	1176,	1),
(25,	1179,	1),
(25,	29,	1),
(25,	1209,	4),
(25,	90,	2),
(25,	305,	1),
(25,	707,	27),
(25,	459,	1),
(25,	460,	1),
(25,	466,	1),
(25,	504,	1),
(25,	1250,	1),
(25,	643,	4),
(25,	1270,	6),
(25,	1272,	3),
(25,	1276,	3),
(25,	1303,	1),
(25,	1313,	1),
(25,	1315,	1),
(25,	1322,	1),
(25,	1328,	1),
(25,	1344,	1),
(25,	89,	5),
(25,	710,	2),
(25,	1397,	1),
(25,	1409,	7),
(25,	1422,	1),
(25,	1430,	1),
(25,	1445,	1),
(25,	1460,	1),
(25,	1485,	1),
(25,	1487,	1),
(25,	1378,	6),
(25,	1514,	1),
(25,	1519,	1),
(26,	16,	10),
(27,	16,	10),
(27,	58,	1),
(27,	67,	1),
(27,	1164,	1),
(27,	774,	6),
(27,	1176,	1),
(27,	1179,	1),
(27,	29,	1),
(27,	1209,	4),
(27,	90,	2),
(27,	305,	1),
(27,	707,	27),
(27,	459,	1),
(27,	460,	1),
(27,	466,	1),
(27,	504,	1),
(27,	1250,	1),
(27,	643,	4),
(27,	1270,	6),
(27,	1272,	3),
(27,	1276,	3),
(27,	1303,	1),
(27,	1313,	1),
(27,	1315,	1),
(27,	1322,	1),
(27,	1328,	1),
(27,	1344,	1),
(27,	89,	5),
(27,	710,	2),
(27,	1397,	1),
(27,	1409,	7),
(27,	1422,	1),
(27,	1430,	1),
(27,	1445,	1),
(27,	1460,	1),
(27,	1485,	1),
(27,	1487,	1),
(27,	1378,	6),
(27,	1514,	1),
(27,	1519,	1),
(28,	16,	10),
(29,	16,	10),
(30,	16,	10);

DROP TABLE IF EXISTS `linkkeyworde`;
CREATE TABLE `linkkeyworde` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeyworde_ibfk_2` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeyworde_ibfk_3` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeyworde` (`linkId`, `keywordId`, `weight`) VALUES
(1,	2,	1),
(1,	15,	1),
(2,	28,	1),
(2,	2,	5),
(3,	28,	1),
(3,	15,	5),
(5,	76,	1),
(5,	80,	1),
(5,	96,	1),
(5,	90,	8),
(5,	104,	1),
(5,	108,	1),
(5,	131,	1),
(5,	146,	1),
(5,	165,	1),
(5,	168,	1),
(5,	172,	1),
(5,	187,	1),
(5,	205,	2),
(5,	231,	4),
(5,	237,	1),
(5,	286,	7),
(5,	293,	5),
(5,	332,	1),
(5,	339,	1),
(5,	343,	1),
(5,	352,	1),
(5,	369,	1),
(5,	372,	1),
(5,	375,	1),
(5,	381,	1),
(5,	421,	1),
(5,	446,	3),
(5,	447,	3),
(5,	454,	1),
(6,	511,	1),
(6,	76,	13),
(6,	520,	8),
(6,	80,	11),
(6,	131,	1),
(6,	538,	1),
(6,	559,	6),
(6,	568,	5),
(6,	90,	4),
(6,	572,	2),
(6,	582,	1),
(6,	609,	1),
(6,	611,	2),
(6,	338,	1),
(6,	649,	1),
(6,	172,	1),
(6,	660,	1),
(6,	662,	1),
(6,	332,	1),
(6,	680,	3),
(6,	684,	1),
(6,	687,	1),
(6,	695,	1),
(6,	712,	1),
(6,	717,	2),
(6,	286,	1),
(6,	446,	1),
(6,	447,	1),
(6,	454,	1),
(6,	733,	1),
(6,	737,	1),
(6,	745,	1),
(6,	781,	1),
(6,	348,	3),
(6,	845,	1),
(6,	869,	6),
(6,	882,	1),
(6,	888,	1),
(6,	898,	1),
(6,	900,	1),
(6,	869,	2),
(6,	1022,	2),
(6,	1031,	1),
(6,	1033,	2),
(6,	339,	7),
(6,	1054,	2),
(6,	205,	1),
(6,	1086,	1),
(6,	1092,	1),
(6,	1097,	1),
(6,	1098,	2),
(6,	1102,	1),
(6,	1103,	1),
(6,	187,	1),
(6,	1144,	2),
(7,	76,	6),
(7,	1182,	1),
(7,	1196,	4),
(7,	1200,	1),
(7,	1203,	1),
(7,	80,	1),
(7,	454,	1),
(7,	1251,	1),
(7,	1261,	1),
(7,	1268,	4),
(7,	1097,	1),
(7,	1325,	1),
(7,	1347,	1),
(7,	1349,	1),
(7,	1355,	1),
(7,	1374,	1),
(7,	1378,	5),
(7,	1379,	2),
(7,	1394,	2),
(7,	1406,	7),
(7,	1427,	3),
(7,	1022,	3),
(7,	1435,	1),
(7,	1464,	1),
(7,	1469,	1),
(7,	1521,	5),
(8,	1525,	1),
(8,	1539,	1),
(8,	1549,	3),
(8,	1576,	1),
(8,	1581,	1),
(8,	1584,	1),
(8,	76,	1),
(9,	2,	1),
(9,	1595,	1),
(11,	28,	1),
(12,	28,	1),
(13,	28,	1),
(14,	339,	1),
(14,	76,	1),
(14,	80,	1),
(15,	28,	1),
(16,	28,	1),
(16,	339,	5),
(17,	28,	1),
(18,	28,	1),
(19,	28,	1),
(20,	28,	1),
(21,	28,	1),
(25,	76,	6),
(25,	1182,	1),
(25,	1196,	4),
(25,	1200,	1),
(25,	1203,	1),
(25,	80,	1),
(25,	454,	1),
(25,	1251,	1),
(25,	1261,	1),
(25,	1268,	4),
(25,	1097,	1),
(25,	1325,	1),
(25,	1347,	1),
(25,	1349,	1),
(25,	1355,	1),
(25,	1374,	1),
(25,	1378,	5),
(25,	1379,	2),
(25,	1394,	2),
(25,	1406,	7),
(25,	1427,	3),
(25,	1022,	3),
(25,	1435,	1),
(25,	1464,	1),
(25,	1469,	1),
(27,	76,	6),
(27,	1182,	1),
(27,	1196,	4),
(27,	1200,	1),
(27,	1203,	1),
(27,	80,	1),
(27,	454,	1),
(27,	1251,	1),
(27,	1261,	1),
(27,	1268,	4),
(27,	1097,	1),
(27,	1325,	1),
(27,	1347,	1),
(27,	1349,	1),
(27,	1355,	1),
(27,	1374,	1),
(27,	1378,	5),
(27,	1379,	2),
(27,	1394,	2),
(27,	1406,	7),
(27,	1427,	3),
(27,	1022,	3),
(27,	1435,	1),
(27,	1464,	1),
(27,	1469,	1),
(27,	1521,	5),
(28,	1641,	1);

DROP TABLE IF EXISTS `linkkeywordf`;
CREATE TABLE `linkkeywordf` (
  `linkId` int(11) NOT NULL,
  `keywordId` int(11) NOT NULL,
  `weight` int(3) NOT NULL,
  KEY `keywordId` (`keywordId`),
  KEY `linkId` (`linkId`),
  CONSTRAINT `linkkeywordf_ibfk_1` FOREIGN KEY (`keywordId`) REFERENCES `keywords` (`keywordId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkkeywordf_ibfk_2` FOREIGN KEY (`linkId`) REFERENCES `link` (`linkId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `linkkeywordf` (`linkId`, `keywordId`, `weight`) VALUES
(1,	19,	5),
(2,	19,	5),
(3,	19,	5),
(4,	37,	1),
(4,	19,	5),
(5,	60,	1),
(5,	73,	1),
(5,	77,	1),
(5,	78,	1),
(5,	81,	1),
(5,	50,	5),
(5,	103,	1),
(5,	154,	1),
(5,	239,	1),
(5,	247,	2),
(5,	258,	5),
(5,	287,	2),
(5,	323,	1),
(5,	325,	1),
(5,	337,	1),
(5,	370,	1),
(5,	376,	1),
(5,	390,	1),
(5,	408,	1),
(5,	442,	1),
(5,	450,	3),
(5,	464,	1),
(5,	467,	1),
(5,	471,	1),
(5,	472,	1),
(5,	473,	1),
(5,	476,	1),
(5,	479,	1),
(5,	481,	2),
(5,	79,	1),
(5,	509,	1),
(5,	19,	5),
(6,	73,	1),
(6,	77,	1),
(6,	78,	1),
(6,	81,	1),
(6,	476,	4),
(6,	545,	3),
(6,	390,	4),
(6,	471,	7),
(6,	551,	3),
(6,	579,	1),
(6,	585,	2),
(6,	620,	3),
(6,	636,	1),
(6,	644,	1),
(6,	648,	1),
(6,	673,	1),
(6,	694,	1),
(6,	708,	1),
(6,	715,	1),
(6,	716,	1),
(6,	450,	1),
(6,	748,	1),
(6,	788,	1),
(6,	824,	2),
(6,	825,	2),
(6,	851,	1),
(6,	859,	9),
(6,	864,	1),
(6,	890,	1),
(6,	909,	1),
(6,	464,	7),
(6,	915,	3),
(6,	929,	1),
(6,	37,	5),
(6,	50,	1),
(6,	955,	1),
(6,	957,	1),
(6,	989,	2),
(6,	994,	3),
(6,	1004,	1),
(6,	1029,	1),
(6,	1043,	1),
(6,	1045,	3),
(6,	1051,	1),
(6,	1057,	2),
(6,	1075,	1),
(6,	79,	2),
(6,	1096,	3),
(6,	287,	1),
(6,	1115,	1),
(6,	1120,	1),
(6,	1131,	1),
(6,	1136,	2),
(6,	1139,	1),
(6,	1140,	1),
(6,	19,	5),
(6,	37,	5),
(7,	73,	1),
(7,	77,	1),
(7,	78,	1),
(7,	81,	1),
(7,	1174,	2),
(7,	1216,	12),
(7,	1228,	1),
(7,	464,	1),
(7,	79,	1),
(7,	1239,	1),
(7,	1241,	2),
(7,	1252,	1),
(7,	1273,	2),
(7,	1277,	2),
(7,	1280,	4),
(7,	1300,	1),
(7,	1319,	1),
(7,	1331,	2),
(7,	1337,	1),
(7,	903,	1),
(7,	1358,	1),
(7,	1364,	1),
(7,	1375,	2),
(7,	1383,	2),
(7,	1407,	1),
(7,	1424,	1),
(7,	1443,	1),
(7,	1444,	1),
(7,	1476,	1),
(7,	1491,	1),
(7,	1505,	1),
(7,	1506,	1),
(7,	19,	5),
(8,	1542,	1),
(8,	1557,	1),
(8,	58,	1),
(8,	1562,	1),
(8,	19,	5),
(9,	19,	5),
(10,	1601,	1),
(10,	19,	5),
(11,	19,	5),
(12,	19,	5),
(12,	1601,	5),
(13,	19,	5),
(14,	1609,	1),
(14,	1590,	1),
(14,	19,	5),
(14,	1621,	5),
(15,	19,	5),
(15,	1621,	5),
(16,	19,	5),
(16,	1621,	5),
(16,	1609,	5),
(17,	19,	5),
(17,	1621,	5),
(17,	1590,	5),
(18,	19,	5),
(18,	1621,	5),
(19,	19,	5),
(19,	1621,	5),
(20,	19,	5),
(20,	1621,	5),
(21,	19,	5),
(21,	1621,	5),
(22,	19,	5),
(23,	19,	5),
(24,	1633,	1),
(24,	19,	5),
(25,	73,	1),
(25,	77,	1),
(25,	78,	1),
(25,	81,	1),
(25,	1174,	2),
(25,	1216,	12),
(25,	1228,	1),
(25,	464,	1),
(25,	79,	1),
(25,	1239,	1),
(25,	1241,	2),
(25,	1252,	1),
(25,	1273,	2),
(25,	1277,	2),
(25,	1280,	4),
(25,	1300,	1),
(25,	1319,	1),
(25,	1331,	2),
(25,	1337,	1),
(25,	903,	1),
(25,	1358,	1),
(25,	1364,	1),
(25,	1375,	2),
(25,	1383,	2),
(25,	1407,	1),
(25,	1424,	1),
(25,	1443,	1),
(25,	1444,	1),
(25,	1476,	1),
(25,	1491,	1),
(25,	1505,	1),
(25,	1506,	1),
(25,	19,	5),
(26,	19,	5),
(27,	73,	1),
(27,	77,	1),
(27,	78,	1),
(27,	81,	1),
(27,	1174,	2),
(27,	1216,	12),
(27,	1228,	1),
(27,	464,	1),
(27,	79,	1),
(27,	1239,	1),
(27,	1241,	2),
(27,	1252,	1),
(27,	1273,	2),
(27,	1277,	2),
(27,	1280,	4),
(27,	1300,	1),
(27,	1319,	1),
(27,	1331,	2),
(27,	1337,	1),
(27,	903,	1),
(27,	1358,	1),
(27,	1364,	1),
(27,	1375,	2),
(27,	1383,	2),
(27,	1407,	1),
(27,	1424,	1),
(27,	1443,	1),
(27,	1444,	1),
(27,	1476,	1),
(27,	1491,	1),
(27,	1505,	1),
(27,	1506,	1),
(27,	19,	5),
(28,	1639,	1),
(28,	19,	5),
(29,	19,	5),
(30,	1633,	1),
(30,	19,	5);

-- 2016-07-28 18:22:07