rendered paste body//NY DATABASE - PHPBB3
CREATE TABLE phpbb_topics_evaluation (
topic_id mediumint(8) unsigned NOT NULL default '0',
evaluation tinyint(1) unsigned NOT NULL default '0',
user_id mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`topic_id`,`user_id`)
);
//GAMMEL CONTENT
--
-- Struktur-dump for tabellen `phpbb_rating`
--
CREATE TABLE `phpbb_rating` (
`post_id` int(10) unsigned NOT NULL default '0',
`user_id` int(10) unsigned NOT NULL default '0',
`rating_time` int(10) unsigned NOT NULL default '0',
`option_id` smallint(5) unsigned NOT NULL default '0',
KEY `rating_postid` (`post_id`),
KEY `rating_userid` (`user_id`),
KEY `rating_ratingoptionid` (`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Data dump for tabellen `phpbb_rating`
--
INSERT INTO `phpbb_rating` (`post_id`, `user_id`, `rating_time`, `option_id`) VALUES
(71, 2, 1059005154, 15),
(71, 6, 1058988501, 11),
(152, 6, 1059100526, 14),
(71, 4, 1060290349, 13),
(132, 12, 1061305144, 12),
(143, 12, 1061305316, 12),
(144, 12, 1061305364, 14),
(104, 12, 1061305404, 15),
(112, 12, 1061305488, 15),
(112, 4, 1061323845, 14),
(158, 4, 1061324476, 12),
(167, 4, 1061324780, 14),
(157, 4, 1061325146, 14),
(110, 4, 1061325545, 14),
(109, 4, 1061325692, 14),
(114, 4, 1061326026, 12),
(280, 4, 1061326430, 11),
(104, 4, 1061327089, 14),
(119, 4, 1061327624, 12),
(172, 9, 1061838718, 14),
(288, 9, 1061838778, 14),
(144, 9, 1061838875, 12),
(143, 9, 1061838909, 12),
(182, 9, 1061838973, 14),
(122, 9, 1061839211, 12),
(114, 10, 1061932991, 14),
(109, 10, 1061933050, 15),
(131, 50, 1061934743, 12),
(104, 25, 1061971239, 13),
(119, 22, 1061981698, 12),
(62, 22, 1061982118, 15),
(104, 22, 1061982418, 14),
(115, 25, 1061986304, 12),
(157, 25, 1061987103, 12),
(117, 73, 1062015857, 15),
(112, 73, 1062016054, 14),
(157, 73, 1062016167, 12),
(114, 73, 1062016272, 14),
(109, 73, 1062016329, 14),
(110, 73, 1062016380, 14),
(116, 73, 1062016445, 14),
(100, 73, 1062016505, 13),
(104, 73, 1062016607, 12),
(11, 73, 1062016724, 14),
(119, 73, 1062016881, 13),
(346, 50, 1062017758, 15),
(105, 50, 1062018023, 15),
(280, 50, 1062072087, 12),
(157, 22, 1062084264, 15),
(117, 22, 1062085311, 14),
(121, 22, 1062085808, 14),
(158, 22, 1062085980, 15),
(386, 50, 1062156857, 12),
(117, 50, 1062156979, 15),
(117, 119, 1062186073, 15),
(100, 119, 1062187481, 16),
(112, 119, 1062187968, 14),
(392, 8, 1062255863, 15),
(142, 130, 1062257014, 12),
(106, 25, 1062332408, 11),
(119, 104, 1062339454, 14),
(347, 104, 1062339649, 12),
(176, 104, 1062339694, 15),
(112, 104, 1062339779, 14),
(100, 104, 1062339874, 13),
(14, 104, 1062340134, 12),
(105, 161, 1062402275, 13),
(11, 4, 1062407819, 14),
(114, 25, 1062417644, 12),
(358, 179, 1062442279, 15),
(131, 161, 1062491687, 12),
(119, 25, 1062520122, 13),
(212, 167, 1062523574, 14),
(132, 167, 1062523644, 13),
(128, 167, 1062523696, 14),
(117, 167, 1062523742, 15),
(114, 167, 1062523827, 12),
(112, 201, 1062524407, 14),
(119, 167, 1062579389, 13),
(144, 167, 1062579608, 12),
(109, 167, 1062580772, 14),
(110, 167, 1062581240, 14),
(158, 167, 1062581933, 12),
(62, 167, 1062582021, 15),
(417, 167, 1062582602, 15),
(118, 167, 1062582656, 12),
(117, 80, 1062584901, 15),
(157, 225, 1062598089, 11),
(144, 86, 1062605431, 16),
(346, 167, 1062679593, 14),
(140, 167, 1062680289, 14),
(105, 167, 1062694099, 14),
(279, 167, 1062694253, 12),
(134, 167, 1062694695, 12),
(280, 167, 1062747010, 12),
(300, 167, 1062747086, 13),
(299, 167, 1062747912, 12),
(149, 167, 1062748369, 14),
(59, 167, 1062748712, 11),
(228, 167, 1062765325, 15),
(141, 167, 1062765464, 15),
(123, 167, 1062766135, 12),
(11, 25, 1062767961, 15),
(11, 22, 1062837129, 15),
(280, 25, 1062858648, 16),
(301, 279, 1062952997, 11),
(133, 4, 1062973042, 14),
(100, 4, 1062974808, 12),
(108, 167, 1063022329, 14),
(296, 167, 1063022396, 14),
(296, 25, 1063028082, 12),
(15, 167, 1063040786, 12),
(14, 167, 1063040864, 12),
(100, 167, 1063041485, 12),
(16, 167, 1063042098, 12),
(116, 167, 1063042187, 12),
(115, 167, 1063042262, 14),
(120, 167, 1063042363, 12),
(106, 296, 1063047238, 11),
(72, 296, 1063047345, 12),
(457, 296, 1063047867, 14),
(442, 9, 1063049473, 14),
(132, 9, 1063049664, 12),
(229, 9, 1063049903, 13),
(167, 330, 1063142376, 15),
(112, 330, 1063142510, 14),
(110, 330, 1063142533, 15),
(117, 340, 1063188432, 15),
(121, 340, 1063188592, 11),
(116, 340, 1063188680, 12),
(112, 340, 1063188756, 15),
(167, 340, 1063189849, 12),
(58, 344, 1063192573, 14),
(11, 300, 1063201831, 15),
(58, 354, 1063217110, 15),
(158, 360, 1063264913, 14),
(135, 167, 1063283221, 14),
(110, 100, 1063300530, 14),
(112, 100, 1063300582, 14),
(192, 9, 1063348013, 12),
(199, 9, 1063348254, 15),
(291, 9, 1063348369, 15),
(133, 100, 1063389225, 15),
(167, 100, 1063389302, 14),
(58, 385, 1063532074, 14),
(199, 167, 1063535558, 12),
(176, 50, 1063657926, 15),
(198, 25, 1063800995, 12),
(288, 161, 1063872603, 14),
(157, 340, 1063900575, 14),
(100, 340, 1063900682, 14),
(117, 276, 1063903270, 15),
(167, 276, 1063903421, 15),
(128, 22, 1063916659, 15),
(456, 354, 1063972727, 13),
(182, 354, 1063972838, 15),
(226, 354, 1063973110, 14),
(11, 428, 1063976094, 15),
(100, 201, 1064083463, 12),
(158, 441, 1064085630, 12),
(114, 441, 1064086065, 14),
(105, 158, 1064425905, 11),
(118, 158, 1064425952, 12),
(62, 158, 1064426562, 14),
(417, 158, 1064426630, 12),
(134, 158, 1064427035, 11),
(276, 158, 1064427628, 12),
(277, 158, 1064427779, 11),
(108, 158, 1064443442, 14),
(72, 158, 1064444196, 12),
(535, 158, 1064444376, 11),
(291, 167, 1064487241, 14),
(296, 158, 1064505131, 14),
(103, 158, 1064589132, 12),
(116, 465, 1064758249, 14),
(103, 465, 1064759366, 16),
(158, 465, 1064760108, 14),
(112, 465, 1064761180, 14),
(10, 465, 1064761663, 14),
(11, 465, 1064761880, 15),
(345, 465, 1064762456, 12),
(185, 465, 1064763291, 12),
(119, 100, 1064767406, 12),
(11, 100, 1064767459, 12),
(142, 86, 1064778698, 11),
(128, 86, 1064778739, 15),
(289, 86, 1064778934, 14),
(345, 22, 1064825253, 14),
(145, 22, 1064825385, 15),
(130, 22, 1064825423, 15),
(110, 65, 1064846090, 13),
(109, 65, 1064846126, 13),
(112, 65, 1064846179, 14),
(131, 65, 1064846611, 13),
(143, 167, 1065009977, 14),
(112, 167, 1065011135, 14),
(145, 167, 1065011271, 15),
(112, 9, 1065041553, 15),
(173, 48, 1065274630, 12),
(770, 257, 1065287833, 15),
(114, 21, 1065703520, 13),
(122, 491, 1065947848, 14),
(291, 491, 1065948053, 15),
(122, 130, 1067519970, 13),
(145, 130, 1067520316, 12),
(346, 540, 1067699315, 14),
(105, 540, 1067699375, 13),
(131, 540, 1067699476, 14),
(58, 50, 1067901376, 15),
(157, 50, 1067902133, 13),
(16, 50, 1067902294, 13),
(149, 565, 1068069963, 13),
(124, 590, 1069068897, 15),
(771, 6, 1069223767, 15),
(277, 71, 1069274081, 11),
(143, 75, 1069283413, 13),
(110, 75, 1069284116, 11),
(112, 75, 1069284754, 14),
(129, 75, 1069285109, 12),
(535, 75, 1069285328, 14),
(106, 75, 1069285628, 11),
(140, 75, 1069285807, 14),
(289, 199, 1069350761, 14),
(143, 199, 1069350892, 13),
(226, 199, 1069350962, 12),
(142, 199, 1069351097, 11),
(49, 599, 1069352266, 15),
(72, 86, 1069583287, 11),
(108, 86, 1069584331, 14),
(143, 575, 1069585533, 14),
(537, 575, 1069585871, 14),
(172, 296, 1069618164, 12),
(282, 296, 1069619126, 13),
(128, 296, 1069619307, 12),
(159, 199, 1069866705, 14),
(145, 75, 1069876708, 14),
(182, 21, 1070013445, 12),
(172, 21, 1070014160, 13),
(167, 21, 1070014494, 15),
(49, 167, 1070370250, 12),
(124, 167, 1070370296, 12),
(136, 167, 1070384810, 14),
(142, 167, 1070553929, 15),
(524, 639, 1070571910, 14),
(347, 639, 1070572040, 16),
(130, 654, 1071441460, 15),
(291, 15, 1071585705, 15),
(226, 669, 1071755035, 13),
(116, 50, 1072061737, 14),
(124, 130, 1073084705, 14),
(549, 130, 1073134925, 13),
(12, 130, 1073135556, 14),
(124, 677, 1073337037, 15),
(122, 677, 1073337125, 13),
(291, 677, 1073337529, 14),
(123, 677, 1073337596, 12),
(141, 677, 1073337652, 14),
(228, 677, 1073337729, 16),
(105, 130, 1073397627, 14),
(126, 130, 1073476353, 12),
(228, 130, 1073496837, 15),
(195, 130, 1073497256, 12),
(202, 130, 1073497700, 14),
(228, 161, 1073570784, 15),
(117, 130, 1074482425, 15),
(112, 677, 1075127974, 15),
(288, 677, 1075128051, 15),
(109, 677, 1075128109, 13),
(198, 677, 1075128238, 14),
(58, 677, 1075128366, 15),
(167, 677, 1075128437, 14),
(145, 677, 1075128473, 12),
(537, 677, 1075128520, 14),
(182, 677, 1075128596, 14),
(108, 677, 1075128662, 14),
(59, 281, 1076427715, 11),
(106, 281, 1076427785, 13),
(108, 281, 1076427853, 15),
(12, 281, 1076427901, 14),
(535, 281, 1076428008, 13),
(295, 568, 1076446721, 15),
(122, 568, 1076446769, 13),
(770, 568, 1076446847, 15),
(417, 795, 1076586843, 14),
(49, 65, 1076588632, 15),
(1528, 187, 1078687846, 15),
(1528, 7, 1078769219, 11),
(836, 875, 1079189008, 15),
(1738, 7, 1080203725, 12),
(136, 130, 1082404554, 14),
(295, 130, 1082404650, 12),
(1052, 71, 1082404993, 11),
(180, 50, 1082536574, 14),
(140, 25, 1082557522, 13),
(58, 104, 1082623519, 14),
(192, 583, 1083007608, 14),
(291, 591, 1083130589, 14),
(291, 771, 1083923190, 15),
(178, 130, 1084125805, 14),
(2246, 296, 1086807613, 15),
(2127, 644, 1086819498, 15),
(2246, 644, 1086819815, 14),
(1162, 771, 1087303455, 14),
(136, 771, 1087303573, 14),
(2316, 540, 1087370069, 15),
(128, 540, 1087546195, 15),
(836, 50, 1088158638, 15),
(770, 1002, 1089064782, 15),
(346, 771, 1089222156, 15),
(276, 1006, 1089278615, 13),
(277, 1006, 1089278669, 11),
(537, 906, 1091708858, 15),
(2963, 6, 1093797458, 15),
(2978, 1154, 1093846720, 15),
(2986, 2, 1093862803, 15),
(2978, 986, 1093899497, 15),
(836, 685, 1094155200, 15),
(457, 685, 1094155264, 14),
(158, 685, 1094155317, 13),
(2986, 1193, 1094377761, 15),
(733, 50, 1096915975, 15),
(417, 50, 1096916369, 15),
(61, 1006, 1098226805, 14),
(836, 1366, 1098268080, 15),
(3783, 905, 1100429928, 15),
(2418, 1409, 1100553958, 15),
(114, 1038, 1100594962, 11),
(117, 1038, 1100596647, 14),
(112, 1038, 1100596772, 12),
(3864, 905, 1100817643, 16),
(351, 167, 1101036652, 16),
(524, 1269, 1101305985, 12),
(3594, 1337, 1101414052, 14),
(4007, 71, 1101501967, 13),
(3942, 1449, 1101997372, 15),
(149, 1073, 1102764205, 13),
(534, 1073, 1102764361, 12),
(3751, 1073, 1102766780, 14),
(4173, 1468, 1102855571, 15),
(17, 1006, 1103065839, 14),
(143, 21, 1103296555, 14),
(4173, 905, 1103579569, 16),
(142, 1493, 1103813336, 13),
(1901, 1378, 1104668136, 12),
(179, 1378, 1104668180, 13),
(122, 1378, 1104668495, 14),
(123, 1378, 1104668574, 14),
(165, 1378, 1104668691, 13),
(534, 1378, 1104668797, 14),
(927, 1378, 1104668853, 14),
(126, 1378, 1104668993, 12),
(4411, 654, 1104797906, 11),
(1507, 654, 1105044014, 15),
(2931, 745, 1105186288, 12),
(2415, 1269, 1105998000, 15),
(1052, 1269, 1105998058, 11),
(228, 56, 1106211360, 15),
(1901, 640, 1107100645, 15),
(11, 842, 1107107758, 14),
(2931, 159, 1107128243, 15),
(836, 1479, 1108147288, 15),
(158, 71, 1109074223, 14),
(49, 886, 1109694365, 14),
(119, 974, 1109705224, 12),
(124, 974, 1109705321, 15),
(192, 974, 1109705375, 14),
(199, 974, 1109705418, 15),
(10, 974, 1109705662, 12),
(345, 974, 1109706457, 12),
(5020, 1551, 1110135026, 14),
(5091, 10247, 1110334606, 15),
(45229, 104, 1111008340, 15),
(41254, 646, 1111014742, 12),
(55, 201, 1111340328, 15),
(142, 50, 1111770005, 11),
(457, 674, 1112192912, 16),
(457, 10, 1112309750, 15),
(120, 744, 1112346821, 14),
(105, 1002, 1112518714, 13),
(133, 1002, 1112518911, 14),
(105, 674, 1112690879, 15),
(109, 674, 1112691038, 12),
(4007, 674, 1112691151, 16),
(301, 674, 1112691351, 15),
(61, 674, 1112691856, 14),
(133, 674, 1112692106, 13),
(347, 674, 1112692350, 12),
(524, 674, 1112692826, 12),
(462, 674, 1112694413, 16),
(301, 10, 1112700646, 11),
(119, 674, 1112931674, 12),
(4411, 540, 1113568265, 15),
(927, 50, 1114270691, 13),
(288, 50, 1114270760, 15),
(4173, 2, 1114803890, 15),
(130, 10, 1115243871, 15),
(3942, 2, 1115830959, 14),
(143, 281, 1116590016, 13),
(927, 12245, 1118325953, 11),
(2380, 1269, 1119124721, 14),
(2380, 12303, 1119168435, 14),
(47794, 1514, 1119712727, 16),
(135, 945, 1121349196, 15),
(1123, 12455, 1121366035, 15),
(104, 838, 1122405660, 15),
(10, 838, 1122405734, 11),
(345, 104, 1122564630, 14),
(120, 104, 1122565034, 15),
(117, 679, 1122761377, 15),
(114, 679, 1122762323, 14),
(116, 1479, 1122879568, 14),
(114, 1479, 1122879619, 14),
(57, 1479, 1122880545, 14),
(1052, 12487, 1123003767, 11),
(131, 12493, 1123156482, 14),
(48579, 986, 1123657807, 15),
(836, 1151, 1124033954, 16),
(116, 1151, 1124034266, 16),
(386, 1151, 1124034308, 15),
(301, 56, 1124360292, 14),
(48740, 986, 1124527812, 15),
(48773, 1099, 1124715657, 15),
(49106, 1261, 1127057756, 16),
(609, 130, 1127493986, 14),
(2090, 12806, 1127576959, 15),
(33915, 12522, 1128977723, 12),
(49444, 12887, 1129744521, 15),
(49613, 501, 1129993173, 16),
(114, 71, 1132128833, 12),
(2316, 12746, 1134172433, 15),
(836, 12746, 1134948448, 15),
(45498, 12746, 1134948610, 15),
(50452, 674, 1135864191, 15),
(114, 13176, 1137374465, 15),
(50667, 13178, 1137379340, 15),
(50479, 8, 1137607058, 15),
(117, 1269, 1137970472, 14),
(116, 1269, 1137971228, 11),
(114, 1269, 1137972161, 13),
(112, 12746, 1137972478, 13),
(133, 12746, 1137973035, 12),
(62, 12746, 1137973074, 14),
(386, 1269, 1137973314, 14),
(158, 1269, 1137973451, 12),
(457, 1269, 1137974166, 14),
(110, 1269, 1137974200, 14),
(167, 1269, 1137974226, 15),
(17, 1269, 1137975061, 15),
(15, 1269, 1137975105, 12),
(45499, 1269, 1137975681, 15),
(15, 1577, 1138021810, 14),
(114, 1577, 1138021865, 13),
(116, 1577, 1138022172, 14),
(167, 1577, 1138022300, 14),
(119, 1577, 1138022458, 11),
(45498, 1577, 1138022491, 14),
(157, 71, 1138053560, 13),
(100, 71, 1138053585, 14),
(167, 71, 1138053651, 11),
(549, 71, 1138053973, 15),
(128, 71, 1138054069, 13),
(165, 478, 1138108293, 12),
(140, 1154, 1138128410, 14),
(4411, 1154, 1138128481, 14),
(182, 1154, 1138128541, 14),
(100, 1009, 1138202370, 14),
(50556, 10293, 1138279774, 16),
(158, 12746, 1138444169, 13),
(114, 12746, 1138444232, 12),
(16, 12746, 1138444575, 14),
(120, 12746, 1138444680, 12),
(392, 674, 1138544007, 14),
(58, 674, 1138544047, 15),
(117, 1517, 1138555579, 14),
(2931, 1517, 1138555605, 14),
(157, 1517, 1138555652, 14),
(116, 1517, 1138555678, 13),
(158, 1517, 1138555700, 14),
(178, 903, 1138629882, 14),
(282, 903, 1138629950, 12),
(120, 674, 1138638029, 14),
(117, 674, 1138638122, 15),
(176, 12746, 1138646914, 14),
(820, 12746, 1138647087, 15),
(2003, 12746, 1138647417, 14),
(50479, 721, 1138651214, 15),
(157, 13260, 1138798314, 13),
(100, 13260, 1138798358, 14),
(114, 13260, 1138798401, 13),
(116, 13260, 1138798694, 14),
(57, 13260, 1138798911, 15),
(57, 1080, 1138818996, 15),
(15, 12746, 1139003488, 14),
(14, 12746, 1139003697, 14),
(10, 1479, 1139403485, 14),
(10, 501, 1139485116, 14),
(10, 1225, 1140251756, 12),
(2380, 1225, 1140252877, 14),
(2931, 12448, 1140528867, 14),
(836, 13370, 1140537250, 14),
(11, 12693, 1140720137, 15),
(133, 12693, 1140720481, 12),
(1077, 12693, 1140720926, 13),
(112, 12693, 1140721243, 13),
(132, 1048, 1141929339, 11),
(112, 998, 1142770593, 14),
(117, 998, 1142770621, 15),
(11, 998, 1142770662, 15),
(48676, 998, 1142770696, 15),
(52202, 10732, 1143745814, 15),
(45464, 12303, 1143992113, 15),
(45498, 998, 1143992509, 15),
(105, 12303, 1143992934, 16),
(157, 998, 1144588755, 15),
(104, 12522, 1144594783, 12),
(1052, 12105, 1144932148, 12),
(786, 10647, 1145814565, 15),
(51881, 10104, 1145994544, 15),
(51881, 613, 1147978509, 15),
(51145, 13365, 1148656939, 15),
(733, 12746, 1150185015, 15),
(296, 12746, 1150185673, 14),
(53288, 13386, 1150386439, 15),
(49479, 1066, 1151218205, 16),
(1052, 13525, 1151516594, 14),
(117, 12693, 1151969971, 15),
(55690, 13727, 1154124804, 15),
(145, 13829, 1154890502, 15),
(130, 1479, 1155559669, 15),
(56611, 13783, 1156246395, 16),
(462, 1479, 1156326602, 12),
(172, 50, 1157525821, 12),
(33915, 10450, 1157834543, 15),
(52202, 13051, 1157972269, 15),
(48597, 12096, 1159193877, 14),
(57772, 13754, 1161298879, 15),
(57772, 678, 1161513777, 16),
(191, 161, 1161688795, 14),
(57710, 1008, 1162751655, 15),
(149, 12245, 1163939686, 11),
(417, 745, 1164124434, 15),
(2316, 14096, 1164291652, 11),
(58209, 10013, 1165099550, 11),
(32603, 14161, 1165880139, 15),
(128, 1479, 1166644064, 14),
(61, 1479, 1166644169, 14),
(133, 12105, 1167252068, 12),
(11, 12105, 1167252093, 15),
(48676, 12105, 1167252121, 12),
(112, 12105, 1167252165, 14),
(59316, 13998, 1167925188, 14),
(59508, 14257, 1168635081, 15),
(295, 12096, 1169056629, 14),
(172, 12143, 1169059204, 14),
(282, 12143, 1169059261, 12),
(2859, 12143, 1169059335, 12),
(48597, 12245, 1169394768, 14),
(182, 12245, 1169395057, 12),
(48597, 12143, 1169461655, 14),
(45498, 1080, 1169988258, 15),
(345, 1080, 1169988388, 12),
(119, 1080, 1169988580, 11),
(417, 1080, 1169988711, 15),
(59809, 14257, 1170058342, 15),
(140, 56, 1170193455, 13),
(2859, 56, 1170193626, 12),
(291, 56, 1170194161, 14),
(122, 56, 1170194432, 13),
(417, 1517, 1171007006, 15),
(60546, 12585, 1172249219, 15),
(60546, 12894, 1172250709, 15),
(60546, 14432, 1172305830, 15),
(60760, 13727, 1172705602, 15),
(60760, 12585, 1172783474, 15),
(60955, 14365, 1173219643, 13),
(61043, 721, 1173277506, 15),
(417, 14532, 1173497070, 15),
(48676, 14532, 1173497171, 15),
(45464, 14096, 1173629675, 15),
(118, 14096, 1173629840, 15),
(50556, 14448, 1174433215, 15),
(61583, 10624, 1174662509, 16),
(61824, 12143, 1175435332, 15),
(51145, 13731, 1178736407, 15),
(62793, 14652, 1179088269, 15),
(170, 12245, 1180432185, 14),
(63179, 14675, 1180874627, 16),
(64102, 12644, 1183756990, 15),
(105, 679, 1185882687, 16),
(53, 14912, 1186606118, 15),
(733, 1269, 1186652987, 15),
(100, 14864, 1186778543, 13),
(158, 14864, 1186778699, 14),
(45498, 14864, 1186790221, 13),
(165, 12245, 1187016627, 11),
(49479, 14801, 1190856571, 15),
(176, 15044, 1190857146, 16),
(49479, 15044, 1190857183, 15),
(300, 14801, 1190857333, 16);
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `phpbb_rating_bias`
--
CREATE TABLE `phpbb_rating_bias` (
`bias_id` int(10) unsigned NOT NULL auto_increment,
`user_id` int(10) unsigned NOT NULL default '0',
`target_user` int(10) unsigned NOT NULL default '0',
`bias_status` tinyint(3) unsigned NOT NULL default '0',
`bias_time` int(10) unsigned NOT NULL default '0',
`post_id` int(10) unsigned NOT NULL default '0',
`option_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`bias_id`),
KEY `ratingbias_userid_targetuser` (`user_id`,`target_user`),
KEY `ratingbias_targetuser` (`target_user`),
KEY `ratingbias_postid` (`post_id`),
KEY `ratingbias_optionid` (`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Data dump for tabellen `phpbb_rating_bias`
--
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `phpbb_rating_config`
--
CREATE TABLE `phpbb_rating_config` (
`label` varchar(100) default NULL,
`num_value` int(10) unsigned NOT NULL default '0',
`text_value` varchar(255) default NULL,
`config_id` int(10) unsigned NOT NULL default '0',
`input_type` tinyint(3) unsigned NOT NULL default '0',
`list_order` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`config_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Data dump for tabellen `phpbb_rating_config`
--
INSERT INTO `phpbb_rating_config` (`label`, `num_value`, `text_value`, `config_id`, `input_type`, `list_order`) VALUES
('Rating system active', 1, NULL, 1, 3, 100),
('Weighting method', 0, NULL, 3, 3, 300),
('Users can change ratings', 0, NULL, 4, 3, 400),
('Max daily ratings (0=unlimited)', 0, NULL, 5, 2, 500),
('Show who rated', 1, NULL, 6, 3, 600),
('Allow users to hide name', 1, NULL, 7, 3, 700),
('Rate first post only', 1, NULL, 2, 3, 200),
('Overall ranking method: posts', 2, NULL, 8, 3, 800),
('Overall ranking method: topics', 2, NULL, 9, 3, 900),
('Overall ranking method: users', 2, NULL, 10, 3, 1000),
('Max daily ratings per user', 100, NULL, 13, 2, 550),
('Open in new window', 1, NULL, 14, 3, 1400),
('Min. post count', 0, NULL, 15, 2, 240),
('Min. days registered', 0, NULL, 16, 2, 250),
('Bias system active', 0, NULL, 11, 3, 1100),
('Show bias usernames?', 0, NULL, 17, 3, 1150),
('Show dropdown in viewtopic?', 0, NULL, 18, 3, 1800),
('Show dropdown in viewforum?', 0, NULL, 19, 3, 1900);
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `phpbb_rating_option`
--
CREATE TABLE `phpbb_rating_option` (
`option_id` smallint(5) unsigned NOT NULL auto_increment,
`points` tinyint(4) NOT NULL default '0',
`label` varchar(100) default NULL,
`weighting` smallint(5) unsigned NOT NULL default '0',
`user_type` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`option_id`),
KEY `ratingoption_rating` (`points`),
KEY `ratingoption_weighting` (`weighting`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
--
-- Data dump for tabellen `phpbb_rating_option`
--
INSERT INTO `phpbb_rating_option` (`option_id`, `points`, `label`, `weighting`, `user_type`) VALUES
(16, 0, '0 ud af 5 stjerner', 0, 1),
(15, 10, '5 ud af 5 stjerner', 5, 1),
(14, 8, '4 ud af 5 stjerner', 4, 1),
(13, 4, '2 ud af 5 stjerner', 3, 1),
(12, 6, '3 ud af 5 stjerner', 2, 1),
(11, 2, '1 ud af 5 stjerner', 1, 1);
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `phpbb_rating_rank`
--
CREATE TABLE `phpbb_rating_rank` (
`rating_rank_id` smallint(5) unsigned NOT NULL auto_increment,
`type` tinyint(3) unsigned NOT NULL default '0',
`average_threshold` tinyint(4) NOT NULL default '0',
`sum_threshold` int(11) NOT NULL default '0',
`label` varchar(100) default NULL,
`icon` varchar(255) default NULL,
`user_rank` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`rating_rank_id`),
KEY `ratingrank_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;
--
-- Data dump for tabellen `phpbb_rating_rank`
--
INSERT INTO `phpbb_rating_rank` (`rating_rank_id`, `type`, `average_threshold`, `sum_threshold`, `label`, `icon`, `user_rank`) VALUES
(24, 4, 4, 0, '2 ud af 5 stjerner', 'stars2.gif', 0),
(25, 4, 2, 0, '1 ud af 5 stjerner', 'stars1.gif', 0),
(21, 4, 10, 0, '5 ud af 5 stjerner', 'stars5.gif', 0),
(22, 4, 8, 0, '4 ud af 5 stjerner', 'stars4.gif', 0),
(23, 4, 6, 0, '3 ud af 5 stjerner', 'stars3.gif', 0),
(20, 5, 0, 0, '0 ud af 5 stjerner', 'stars0.gif', 0),
(19, 5, 2, 0, '1 ud af 5 stjerner', 'stars1.gif', 0),
(18, 5, 4, 0, '2 ud af 5 stjerner', 'stars2.gif', 0),
(17, 5, 6, 0, '3 ud af 5 stjerner', 'stars3.gif', 0),
(15, 5, 10, 0, '5 ud af 5 stjerner', 'stars5.gif', 0),
(16, 5, 8, 0, '4 ud af 5 stjerner', 'stars4.gif', 0),
(26, 4, 0, 0, '0 ud af 5 stjerner', 'stars0.gif', 0),
(28, 4, 1, 0, '0,5 ud af 5 stjerner', 'stars05.gif', 0),
(29, 4, 9, 0, '4,5 ud af 5 stjerner', 'stars45.gif', 0),
(30, 4, 7, 0, '3,5 ud af 5 stjener', 'stars35.gif', 0),
(31, 4, 5, 0, '2,5 ud af 5 stjerner', 'stars25.gif', 0),
(32, 4, 3, 0, '1,5 stjener ud af 5', 'stars15.gif', 0),
(33, 5, 9, 0, '4,5 ud af 5 stjerner', 'stars45.gif', 0),
(34, 5, 7, 0, '3,5 ud af 5 stjener', 'stars35.gif', 0),
(35, 5, 5, 0, '2,5 ud af 5 stjerner', 'stars25.gif', 0),
(36, 4, 3, 0, '1,5 stjener ud af 5', 'stars15.gif', 0),
(37, 4, 1, 0, '0,5 ud af 5 stjerner', 'stars05.gif', 0);
-- --------------------------------------------------------