-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 20, 2010 at 02:40 PM -- Server version: 5.1.40 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `bmcforu_transfer` -- -- -------------------------------------------------------- -- -- Table structure for table `reputation` -- CREATE TABLE IF NOT EXISTS `reputation` ( `reputationid` int(10) unsigned NOT NULL AUTO_INCREMENT, `postid` int(10) unsigned NOT NULL DEFAULT '1', `userid` int(10) unsigned NOT NULL DEFAULT '1', `reputation` int(11) NOT NULL DEFAULT '0', `whoadded` int(10) unsigned NOT NULL DEFAULT '0', `reason` varchar(250) DEFAULT NULL, `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`reputationid`), UNIQUE KEY `whoadded_postid` (`whoadded`,`postid`), KEY `userid` (`userid`), KEY `multi` (`postid`,`userid`), KEY `dateline` (`dateline`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=135 ; -- -- Dumping data for table `reputation` -- INSERT INTO `reputation` (`reputationid`, `postid`, `userid`, `reputation`, `whoadded`, `reason`, `dateline`) VALUES (1, 358064, 4340, 63, 3367, 'He SO rocks!', 1137282964), (2, 358040, 3367, 10, 1, 'Congrats, MoM!', 1137283254), (3, 358074, 1, 29, 10, 'Thanks for getting the new software up!!', 1137283283), (4, 358073, 10, 10, 1, 'Thanks for helping me with the scale! LOL', 1137283300), (5, 358040, 3367, 29, 10, 'For December MoM!!! Congrats!!!', 1137283624), (6, 358090, 567, 29, 10, 'For being a great Friend!!! :)', 1137283861), (7, 358112, 3435, 29, 10, 'For being a REALLY cool guy!!! :)', 1137284587), (8, 358109, 10, 5, 1265, '', 1137284959), (9, 358109, 10, 9, 567, 'great', 1137285682), (10, 358077, 1, 63, 3367, 'LS Rocks!', 1137289811), (11, 358292, 1793, 11, 352, '', 1137290956), (12, 358293, 10, -31, 3367, 'weirdo', 1137291142), (13, 357848, 352, 63, 3367, '', 1137291318), (14, 358266, 146, 63, 3367, '', 1137291338), (15, 358311, 1793, 63, 3367, '', 1137291392), (16, 358433, 2734, 40, 2472, '', 1137293040), (17, 358447, 10, 10, 1, 'Great idea!! BMC Sandals!!', 1137293261), (18, 358535, 4418, 10, 3435, '', 1137294777), (19, 358546, 3435, 3, 4418, 'What ups Tom', 1137294962), (20, 358558, 3606, 3, 4418, 'Hi whats up', 1137295189), (21, 358549, 575, 63, 3367, '', 1137295238), (22, 358564, 3367, 7, 575, '', 1137295265), (23, 358577, 2734, 3, 4418, 'hey pete whats up', 1137295418), (24, 358580, 4418, 2, 2734, '', 1137295435), (25, 358581, 3606, 10, 3435, '', 1137295449), (26, 358038, 10, -31, 1, 'Goofball', 1137295546), (27, 358580, 4418, 28, 10, 'Yo!!!! just adding points!! :)', 1137295597), (28, 358575, 1, 10, 3435, '', 1137295622), (29, 358113, 1474, 28, 10, 'I want to play Tennis!!!!!!', 1137295702), (30, 358017, 4484, 62, 1, ':)', 1137295906), (31, 358575, 1, 7, 575, '', 1137296123), (32, 358592, 3435, 36, 33, 'awesome', 1137296352), (33, 358336, 10, 62, 1, 'Great comments!!', 1137296984), (34, 358106, 1265, 1, 1849, 'I think it''s awesome!!!', 1137297058), (35, 358025, 33, 12, 352, 'funny stuff', 1137297080), (36, 358649, 1011, 63, 3367, 'Your points will come back soon! :)', 1137297291), (37, 358678, 352, 5, 244, 'Yep, you said it bro!', 1137298234), (38, 358699, 1011, 5, 244, 'My sentiments exactly!', 1137298394), (39, 358526, 3435, 63, 3367, 'thats twice i said something to make you want to change your vote!! Heehee', 1137298540), (40, 358696, 4145, -31, 3367, '', 1137298822), (41, 358575, 1, 40, 2472, '', 1137301425), (42, 358749, 2011, 40, 2472, '', 1137301769), (43, 358757, 3367, 40, 2472, '', 1137301817), (44, 358758, 10, 40, 2472, '', 1137301839), (45, 358377, 1664, 6, 505, '', 1137301905), (46, 358783, 1849, 40, 2472, '', 1137302613), (47, 358778, 4143, 40, 2472, '', 1137302627), (48, 358763, 575, 40, 2472, '', 1137302647), (49, 358777, 575, 2, 1748, '', 1137302763), (50, 358792, 567, 40, 2472, '', 1137302835), (51, 358740, 3606, 40, 2472, '', 1137303976), (52, 358851, 2472, 9, 1011, '', 1137304408), (53, 358775, 1849, 36, 33, 'awesome', 1137305895), (54, 358900, 341, 9, 1011, 'Just because!!', 1137306004), (55, 358686, 575, 4, 1474, '', 1137306038), (59, 203636, 3403, 9, 1011, 'Just because!!', 1137306434), (60, 358943, 10, 9, 1011, 'Just because!!', 1137306867), (61, 358960, 1, 9, 1011, 'Just because!!', 1137307422), (62, 358797, 567, 9, 1011, 'Just because!!', 1137307500), (63, 358961, 33, 62, 1, ':)', 1137307766), (64, 358918, 33, 1, 1849, 'Rock on Tim, Thanks You made me feel better!!', 1137313352), (65, 359008, 1793, 4, 2660, 'hell I dont know, I''m just testing', 1137315135), (66, 357446, 244, 4, 2660, '', 1137315231), (67, 358922, 731, 4, 2660, '', 1137316409), (68, 359009, 2660, 23, 827, 'Dan is the MAN', 1137318390), (69, 358783, 1849, 4, 2660, '', 1137319228), (70, 356962, 2622, -5, 3435, '', 1137330850), (71, 357042, 4256, 3, 4418, 'nice pictures', 1137339308), (72, 359194, 244, 3, 4418, '', 1137339739), (73, 359202, 10, 3, 4418, '', 1137339851), (74, 358991, 33, 4, 1474, '', 1137340635), (75, 359357, 3973, 62, 1, 'Just for you!', 1137343158), (76, 359046, 244, 1, 3973, '', 1137343381), (77, 359059, 4484, 1, 4439, ':)', 1137344476), (78, 359415, 104, 62, 1, '', 1137346495), (79, 359357, 3973, 4, 2660, '', 1137347638), (80, 359290, 2472, 3, 4418, '', 1137349017), (81, 358801, 3367, 4, 2660, '', 1137349134), (82, 356489, 3076, 9, 1011, 'Just because!!', 1137349675), (83, 359733, 3727, 3, 4418, '', 1137357318), (84, 359759, 4418, 5, 3727, 'He''s up and coming.', 1137357769), (85, 359864, 3712, 3, 4418, '', 1137360764), (86, 360006, 3535, 1, 4439, '', 1137364460), (87, 360005, 146, 62, 1, '', 1137364618), (88, 360152, 22, 62, 1, '', 1137374067), (89, 359864, 3712, 5, 3727, 'You''re such a sweetie.', 1137378017), (90, 360322, 4458, 11, 3435, '', 1137380597), (91, 358811, 567, 62, 1, '', 1137381311), (92, 360454, 146, 23, 827, 'That was post was dead on! Great job, Rue', 1137383849), (93, 360479, 1265, 1, 1999, '', 1137384200), (94, 357258, 2407, 1, 1999, '', 1137384280), (95, 357173, 3367, 1, 1999, '', 1137384360), (96, 360662, 1011, 19, 104, '', 1137389141), (97, 360769, 3738, 40, 2472, '', 1137393968), (98, 360970, 33, 0, 4498, 'awesome', 1137399986), (99, 361157, 10, 62, 1, '', 1137416969), (100, 361056, 2832, 3, 4418, '', 1137422504), (101, 361419, 3727, 40, 2472, 'Just checking it out.', 1137424214), (102, 361424, 2472, 6, 3727, 'You''re so nice.', 1137424303), (103, 361489, 3076, 6, 3727, 'Bow to the Princess.', 1137425476), (104, 361306, 4439, 1, 4484, '', 1137425985), (105, 361553, 3076, 40, 2472, 'Giving some BMC luv', 1137426912), (106, 361612, 3727, 7, 3076, 'I hate rain', 1137427740), (107, 361708, 3998, 6, 3727, 'Cuz you''re so nice.', 1137428979), (108, 361698, 3076, 6, 3998, '', 1137429008), (109, 361704, 2472, 7, 3076, 'because she kicks butt', 1137429031), (110, 361748, 3998, 7, 3076, 'For Repping Me!', 1137429401), (111, 361785, 3424, 7, 3076, 'CAUSE KENNY ROCKS!', 1137429890), (112, 361594, 1793, 62, 1, '', 1137430794), (113, 361388, 244, 6, 3727, 'You are Special.', 1137431609), (114, 345848, 1770, 3, 4418, 'Thanks for the wax info', 1137437483), (115, 362242, 3623, 40, 2472, '', 1137441942), (116, 361160, 1, 40, 2472, 'Way approve!', 1137442637), (117, 357543, 3435, 40, 2472, '', 1137442821), (118, 323969, 4256, 40, 2472, '', 1137443974), (119, 362394, 3712, 12, 3435, '', 1137445032), (120, 362397, 146, 1, 3973, '', 1137445147), (121, 362510, 1793, 10, 567, 'I like you much!', 1137448142), (122, 362544, 3973, 10, 567, 'Let''s get you going..oxox', 1137448177), (123, 360054, 3367, 6, 3727, 'Why? Cusican...', 1137451641), (124, 357367, 10, 6, 3727, 'Why? Cusican', 1137451709), (125, 362656, 1793, 63, 1, '', 1137452520), (126, 358644, 1011, 1, 2570, '', 1137453132), (127, 358645, 10, 1, 2570, '', 1137453158), (128, 360289, 99, 6, 9, 'GREAR FRIEND IN DEED', 1137453517), (129, 358647, 3973, 4, 1474, '', 1137455016), (130, 362774, 9, 40, 2472, '', 1137456758), (131, 362698, 146, 40, 2472, '', 1137456776), (132, 362636, 1988, 40, 2472, '', 1137456789), (133, 362863, 567, 63, 1, '', 1137459258), (134, 363114, 2202, -32, 3367, '', 1137461825);