-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 01:29 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 `announcementread`
--

CREATE TABLE IF NOT EXISTS `announcementread` (
  `announcementid` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`announcementid`,`userid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `announcementread`
--

INSERT INTO `announcementread` (`announcementid`, `userid`) VALUES
(12, 1),
(12, 3),
(12, 10),
(12, 11),
(12, 24),
(12, 25),
(12, 26),
(12, 27),
(12, 104),
(12, 121),
(12, 123),
(12, 146),
(12, 176),
(12, 210),
(12, 212),
(12, 244),
(12, 284),
(12, 300),
(12, 341),
(12, 347),
(12, 408),
(12, 492),
(12, 505),
(12, 548),
(12, 556),
(12, 567),
(12, 603),
(12, 662),
(12, 735),
(12, 803),
(12, 827),
(12, 894),
(12, 919),
(12, 1042),
(12, 1195),
(12, 1231),
(12, 1356),
(12, 1371),
(12, 1412),
(12, 1474),
(12, 1546),
(12, 1591),
(12, 1617),
(12, 1619),
(12, 1654),
(12, 1705),
(12, 1720),
(12, 1735),
(12, 1760),
(12, 1768),
(12, 1802),
(12, 1849),
(12, 1881),
(12, 1912),
(12, 1932),
(12, 1968),
(12, 1988),
(12, 2055),
(12, 2093),
(12, 2183),
(12, 2192),
(12, 2205),
(12, 2231),
(12, 2323),
(12, 2332),
(12, 2435),
(12, 2472),
(12, 2559),
(12, 2568),
(12, 2612),
(12, 2660),
(12, 2727),
(12, 2752),
(12, 2762),
(12, 2785),
(12, 2788),
(12, 2832),
(12, 2881),
(12, 2939),
(12, 2974),
(12, 3043),
(12, 3061),
(12, 3076),
(12, 3163),
(12, 3166),
(12, 3180),
(12, 3286),
(12, 3356),
(12, 3357),
(12, 3367),
(12, 3384),
(12, 3417),
(12, 3435),
(12, 3477),
(12, 3491),
(12, 3511),
(12, 3527),
(12, 3551),
(12, 3563),
(12, 3579),
(12, 3606),
(12, 3654),
(12, 3655),
(12, 3689),
(12, 3712),
(12, 3782),
(12, 3795),
(12, 3797),
(12, 3827),
(12, 3830),
(12, 3865),
(12, 3869),
(12, 3907),
(12, 3923),
(12, 3953),
(12, 3972),
(12, 3973),
(12, 4027),
(12, 4035),
(12, 4037),
(12, 4056),
(12, 4089),
(12, 4125),
(12, 4164),
(12, 4238),
(12, 4248),
(12, 4312),
(12, 4323),
(12, 4390),
(12, 4407),
(12, 4418),
(12, 4428),
(12, 4468),
(12, 4489),
(12, 4531),
(12, 4541),
(12, 4588),
(12, 4603),
(12, 4650),
(12, 4653),
(12, 4748),
(12, 4762),
(12, 4769),
(12, 4782),
(12, 4799),
(12, 4802),
(12, 4846),
(12, 4868),
(12, 4947),
(12, 5044),
(12, 5097),
(12, 5109),
(12, 5113),
(12, 5195),
(12, 5254),
(12, 5302),
(12, 5341),
(12, 5345),
(12, 5363),
(12, 5400),
(12, 5452),
(12, 5464),
(12, 5477),
(12, 5484),
(12, 5492),
(12, 5495),
(12, 5543),
(12, 5551),
(12, 5595),
(12, 5614),
(12, 5637),
(12, 5675),
(12, 5686),
(12, 5745),
(12, 5779),
(12, 5805),
(12, 5869),
(12, 5875),
(12, 5880),
(12, 5884),
(12, 5887),
(12, 5895),
(12, 5919),
(12, 5940),
(12, 5952),
(12, 5954),
(12, 5968),
(12, 5982),
(12, 5998),
(12, 6045),
(12, 6064),
(12, 6077),
(12, 6092),
(12, 6191),
(12, 6251),
(12, 6275),
(12, 6287),
(12, 6288),
(12, 6289),
(12, 6304),
(12, 6344),
(12, 6347),
(12, 6349),
(12, 6365),
(12, 6367),
(12, 6390),
(12, 6402),
(12, 6417),
(12, 6434),
(12, 6439),
(12, 6441),
(12, 6459),
(12, 6460),
(12, 6488),
(12, 6509),
(12, 6516),
(12, 6536),
(12, 6568),
(12, 6589),
(12, 6606),
(12, 6642),
(12, 6658),
(12, 6662),
(12, 6676),
(12, 6679),
(12, 6704),
(12, 6712),
(12, 6724),
(12, 6738),
(12, 6757),
(12, 6775),
(12, 6777),
(12, 6787),
(12, 6796),
(12, 6798),
(12, 6799),
(12, 6810),
(12, 6858),
(12, 6862),
(12, 6874),
(12, 6881),
(12, 6898),
(12, 6908),
(12, 6911),
(12, 6923),
(12, 6924),
(12, 6928),
(12, 6933),
(12, 6936),
(12, 6944),
(12, 6960),
(12, 6961),
(12, 6975),
(12, 6984),
(12, 6986),
(12, 6996),
(12, 6997),
(12, 7007),
(12, 7035),
(12, 7037),
(12, 7049),
(12, 7106),
(12, 7120),
(12, 7121),
(12, 7123),
(12, 7127),
(12, 7132),
(12, 7137),
(12, 7141),
(12, 7153),
(12, 7171),
(12, 7174),
(12, 7176),
(12, 7181),
(12, 7209),
(12, 7212),
(12, 7221),
(12, 7226),
(12, 7237),
(12, 7243),
(12, 7246),
(12, 7248),
(12, 7261),
(12, 7264),
(12, 7288),
(12, 7297),
(12, 7304),
(12, 7310),
(12, 7311),
(12, 7318),
(12, 7329),
(12, 7334),
(12, 7338),
(12, 7346),
(12, 7350),
(12, 7374),
(12, 7376),
(12, 7378),
(12, 7390),
(12, 7429),
(12, 7463),
(12, 7470),
(12, 7493),
(12, 7533),
(12, 7549),
(12, 7560),
(12, 7568),
(12, 7577),
(12, 7593),
(12, 7599),
(12, 7603),
(12, 7605),
(12, 7615),
(12, 7619),
(12, 7645),
(12, 7648),
(12, 7654),
(12, 7662),
(12, 7666),
(12, 7679),
(12, 7691),
(12, 7704),
(12, 7712),
(12, 7714),
(12, 7735),
(12, 7747),
(12, 7755),
(12, 7761),
(12, 7765),
(12, 7779),
(12, 7791),
(12, 7793),
(12, 7796),
(12, 7806),
(12, 7813),
(12, 7821),
(12, 7828),
(12, 7831),
(12, 7833),
(12, 7837),
(12, 7855),
(12, 7860),
(12, 7881),
(12, 7956),
(12, 7962),
(12, 7969),
(12, 7979),
(12, 7984),
(12, 7988),
(12, 7994),
(12, 8008),
(12, 8011),
(12, 8027),
(12, 8038),
(12, 8079),
(12, 8090),
(12, 8094),
(12, 8103),
(12, 8106),
(12, 8116),
(12, 8128),
(12, 8133),
(12, 8151),
(12, 8152),
(12, 8175),
(12, 8178),
(12, 8184),
(12, 8187),
(12, 8205),
(12, 8218),
(12, 8220),
(12, 8249),
(12, 8250),
(12, 8258),
(12, 8261),
(12, 8265),
(12, 8278),
(12, 8282),
(12, 8290),
(12, 8293),
(12, 8334),
(12, 8346),
(12, 8350),
(12, 8353),
(12, 8397),
(12, 8412),
(12, 8417),
(12, 8444),
(12, 8456),
(12, 8481),
(12, 8509),
(12, 8523),
(12, 8529),
(12, 8530),
(12, 8531),
(12, 8534),
(12, 8558),
(12, 8564),
(12, 8569),
(12, 8576),
(12, 8579),
(12, 8581),
(12, 8585),
(12, 8599),
(12, 8600),
(12, 8607),
(12, 8619),
(12, 8624),
(12, 8628),
(12, 8662),
(12, 8671),
(12, 8677),
(12, 8678),
(12, 8681),
(12, 8692),
(12, 8697),
(12, 8739),
(12, 8745),
(12, 8750),
(12, 8751),
(12, 8753),
(12, 8757),
(12, 8758),
(12, 8763),
(12, 8765),
(12, 8768),
(12, 8772),
(12, 8778),
(12, 8783),
(12, 8789),
(12, 8791),
(12, 8797),
(12, 8803),
(12, 8838),
(12, 8859),
(12, 8868),
(12, 8881),
(12, 8882),
(12, 8906),
(12, 8939),
(12, 8964),
(12, 8969),
(12, 8993),
(12, 8997),
(12, 9000),
(12, 9002),
(12, 9034),
(12, 9036),
(12, 9042),
(12, 9063),
(12, 9081),
(12, 9084),
(12, 9105),
(12, 9139),
(12, 9151),
(12, 9154),
(12, 9179),
(12, 9181),
(12, 9194),
(12, 9202),
(12, 9232),
(12, 9245),
(12, 9249),
(12, 9283),
(12, 9294),
(12, 9327),
(12, 9334),
(12, 9382),
(12, 9390),
(12, 9391),
(12, 9396),
(12, 9398),
(12, 9399),
(12, 9402),
(12, 9407),
(12, 9415),
(12, 9420),
(12, 9426),
(12, 9438),
(12, 9448),
(12, 9449),
(12, 9450),
(12, 9464),
(12, 9478),
(12, 9486),
(12, 9492),
(12, 9507),
(12, 9524),
(12, 9544),
(12, 9557),
(12, 9565),
(12, 9567),
(12, 9572),
(12, 9614),
(12, 9627),
(12, 9628),
(12, 9633),
(12, 9649),
(12, 9670),
(12, 9677),
(12, 9703),
(12, 9720),
(12, 9728),
(12, 9787),
(12, 9788),
(12, 9807),
(12, 9808),
(12, 9814),
(12, 9815),
(12, 9824),
(12, 9827),
(12, 9833),
(12, 9841),
(12, 9847),
(12, 9889),
(12, 9890),
(12, 9907),
(12, 9918),
(12, 9936),
(12, 9944),
(12, 9963),
(12, 9964),
(12, 9966),
(12, 9970),
(12, 10031),
(12, 10039),
(12, 10057),
(12, 10073),
(12, 10091),
(12, 10103),
(12, 10143),
(12, 10154),
(12, 10180),
(12, 10187),
(12, 10188),
(12, 10203),
(12, 10208),
(12, 10264),
(12, 10277),
(12, 10322),
(12, 10328),
(12, 10332),
(12, 10334),
(12, 10349),
(12, 10354),
(12, 10357),
(12, 10367),
(12, 10393),
(12, 10427),
(12, 10428),
(12, 10447),
(12, 10464),
(12, 10492),
(12, 10496),
(12, 10511),
(12, 10516),
(12, 10538),
(12, 10564),
(12, 10567),
(12, 10576),
(12, 10594),
(12, 10627),
(12, 10651),
(12, 10658),
(12, 10660),
(12, 10664),
(12, 10677),
(12, 10691),
(12, 10693),
(12, 10703),
(12, 10707),
(12, 10717),
(12, 10725),
(12, 10746),
(12, 10751),
(12, 10756),
(12, 10768),
(12, 10776),
(12, 10778),
(12, 10783),
(12, 10813),
(12, 10821),
(12, 10826),
(12, 10831),
(12, 10834),
(12, 10837),
(12, 10854),
(12, 10873),
(12, 10879),
(12, 10891),
(12, 10923),
(12, 10939),
(12, 10952),
(12, 10991),
(12, 11018),
(12, 11040),
(12, 11050),
(12, 11057),
(12, 11093),
(12, 11115),
(12, 11136),
(12, 11152),
(12, 11163),
(12, 11168),
(12, 11174),
(12, 11178),
(12, 11179),
(12, 11186),
(12, 11190),
(12, 11207),
(12, 11214),
(12, 11218),
(12, 11226),
(12, 11235),
(12, 11236),
(12, 11301),
(12, 11306),
(12, 11350),
(12, 11406),
(12, 11414),
(12, 11420),
(12, 11425),
(12, 11472),
(12, 11487),
(12, 11492),
(12, 11501),
(12, 11515),
(12, 11519),
(12, 11542),
(12, 11548),
(12, 11582),
(12, 11603),
(12, 11625),
(12, 11629),
(12, 11633),
(12, 11635),
(12, 11637),
(12, 11642),
(12, 11721),
(12, 11748),
(12, 11781),
(12, 11790),
(12, 11801),
(12, 11810),
(12, 11828),
(12, 11831),
(12, 11845),
(12, 11847),
(12, 11902),
(12, 11906),
(12, 11972),
(12, 11984),
(12, 11996),
(12, 12000),
(12, 12014),
(12, 12072),
(12, 12073),
(12, 12098),
(12, 12100),
(12, 12135),
(12, 12137),
(12, 12146),
(12, 12147),
(12, 12149),
(12, 12152),
(12, 12186),
(12, 12214),
(12, 12240),
(12, 12245),
(12, 12252),
(12, 12278),
(12, 12285),
(12, 12287),
(12, 12298),
(12, 12303),
(12, 12311),
(12, 12329),
(12, 12348),
(12, 12352),
(12, 12409),
(12, 12414),
(12, 12417),
(12, 12426),
(12, 12429),
(12, 12431),
(12, 12446),
(12, 12477),
(12, 12489),
(12, 12491),
(12, 12518),
(12, 12538),
(12, 12540),
(12, 12555),
(12, 12585),
(12, 12639),
(12, 12682),
(12, 12685),
(12, 12703),
(12, 12711),
(12, 12715),
(12, 12728),
(12, 12765),
(12, 12777),
(12, 12790),
(12, 12798),
(12, 12836),
(12, 12843),
(12, 12866),
(12, 12867),
(12, 12911),
(12, 12918),
(12, 12969),
(12, 12974),
(12, 13027),
(12, 13038),
(12, 13077),
(12, 13089),
(12, 13094),
(12, 13096),
(12, 13103),
(12, 13129),
(12, 13216),
(12, 13254),
(12, 13259),
(12, 13297),
(12, 13384),
(12, 13386),
(12, 13411),
(12, 13450),
(12, 13521),
(12, 13559),
(12, 13569),
(12, 13574),
(12, 13578),
(12, 13586),
(12, 13587),
(12, 13609),
(12, 13614),
(12, 13695),
(12, 13712),
(12, 13727),
(12, 13761),
(12, 13780),
(12, 13790),
(12, 13811),
(12, 13820),
(12, 13822);