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

CREATE TABLE IF NOT EXISTS `subscribeevent` (
  `subscribeeventid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `eventid` int(10) unsigned NOT NULL DEFAULT '0',
  `lastreminder` int(10) unsigned NOT NULL DEFAULT '0',
  `reminder` int(10) unsigned NOT NULL DEFAULT '3600',
  PRIMARY KEY (`subscribeeventid`),
  UNIQUE KEY `subindex` (`userid`,`eventid`),
  KEY `eventid` (`eventid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=140 ;

--
-- Dumping data for table `subscribeevent`
--

INSERT INTO `subscribeevent` (`subscribeeventid`, `userid`, `eventid`, `lastreminder`, `reminder`) VALUES
(1, 1, 107, 0, 3600),
(99, 556, 332, 1191474000, 259200),
(98, 6961, 333, 1178323200, 259200),
(81, 141, 277, 1177650000, 259200),
(80, 6834, 163, 1167433200, 86400),
(6, 103, 29, 0, 3600),
(7, 141, 2, 0, 3600),
(8, 141, 11, 0, 3600),
(9, 141, 12, 0, 3600),
(10, 141, 14, 0, 3600),
(11, 244, 11, 0, 3600),
(12, 1300, 7, 0, 3600),
(13, 1300, 24, 0, 3600),
(14, 1356, 33, 0, 3600),
(15, 1489, 77, 0, 3600),
(16, 2333, 11, 0, 3600),
(97, 6961, 335, 1183161600, 259200),
(96, 4035, 284, 1171065600, 172800),
(95, 7282, 278, 1177077600, 259200),
(94, 6908, 309, 1170466200, 28800),
(21, 2996, 86, 0, 3600),
(22, 2996, 95, 0, 3600),
(23, 3499, 117, 0, 3600),
(24, 3587, 11, 0, 3600),
(25, 2996, 135, 0, 3600),
(26, 3132, 134, 0, 3600),
(27, 190, 11, 0, 3600),
(28, 3643, 11, 0, 3600),
(29, 2996, 139, 1147957200, 3600),
(91, 4760, 287, 1180702800, 259200),
(93, 2472, 277, 1177650000, 259200),
(32, 190, 144, 0, 3600),
(33, 33, 148, 0, 3600),
(90, 2472, 287, 1180702800, 259200),
(35, 2996, 154, 1142640000, 3600),
(50, 5336, 189, 1149897600, 259200),
(89, 5675, 284, 1171065600, 259200),
(38, 1034, 154, 1142640000, 3600),
(39, 567, 158, 1137351316, 3600),
(88, 6080, 284, 1171065600, 172800),
(43, 4653, 163, 1167433200, 86400),
(44, 1034, 167, 1143849600, 259200),
(45, 3736, 169, 1149267600, 259200),
(46, 3132, 154, 1142640000, 259200),
(47, 4040, 154, 1142640000, 172800),
(48, 4056, 160, 1153719000, 259200),
(49, 4934, 186, 1143849600, 86400),
(51, 5336, 160, 1153719000, 259200),
(52, 3309, 191, 1149292800, 172800),
(53, 5792, 205, 1161270000, 172800),
(54, 3422, 160, 1153719000, 259200),
(87, 5758, 284, 1171065600, 259200),
(56, 5862, 205, 1161270000, 259200),
(57, 3076, 205, 1161270000, 259200),
(59, 3975, 205, 1161270000, 259200),
(60, 3367, 205, 1161270000, 259200),
(61, 3076, 224, 1160784000, 259200),
(62, 4143, 225, 1163808000, 259200),
(63, 3795, 205, 1161270000, 259200),
(64, 6056, 238, 1154736000, 86400),
(65, 5940, 237, 1156550400, 10800),
(66, 6221, 205, 1161270000, 172800),
(67, 5998, 246, 1161993600, 259200),
(137, 6571, 620, 1247270400, 172800),
(86, 7074, 284, 1171065600, 259200),
(70, 6241, 246, 1161993600, 259200),
(84, 4916, 279, 1171656000, 259200),
(75, 2332, 246, 1161993600, 3600),
(85, 1552, 278, 1177077600, 259200),
(74, 6174, 251, 1159574400, 259200),
(76, 2863, 205, 1161270000, 3600),
(77, 3043, 269, 1165017600, 172800),
(83, 4323, 284, 1171065600, 259200),
(79, 6768, 269, 1165017600, 259200),
(100, 7427, 337, 1181833200, 259200),
(101, 3422, 332, 1191474000, 259200),
(102, 141, 349, 1176508800, 259200),
(103, 7496, 278, 1177077600, 86400),
(104, 4206, 288, 1179424800, 172800),
(105, 3727, 332, 1191474000, 259200),
(106, 6777, 362, 1183622400, 259200),
(107, 6834, 354, 1181048400, 259200),
(108, 4600, 335, 1183161600, 172800),
(109, 6110, 391, 1184371200, 259200),
(139, 13665, 636, 1260637200, 86400),
(130, 9963, 508, 1215820800, 259200),
(112, 4035, 412, 1192233600, 259200),
(129, 7962, 517, 1210809600, 86400),
(114, 8118, 424, 1194048000, 172800),
(115, 2472, 425, 1194739200, 172800),
(116, 8803, 417, 1201305600, 259200),
(117, 8579, 423, 1203105600, 259200),
(118, 2472, 434, 1203724800, 259200),
(119, 4752, 417, 1201305600, 259200),
(120, 9334, 437, 1203091200, 259200),
(121, 7120, 423, 1203105600, 259200),
(122, 9036, 467, 1210863600, 172800),
(123, 9040, 439, 0, 172800),
(124, 9063, 431, 1218265200, 259200),
(125, 4531, 486, 1207353600, 259200),
(126, 8624, 486, 1207353600, 172800),
(127, 10322, 457, 1213362000, 259200),
(128, 10431, 457, 1213362000, 259200),
(131, 33, 490, 1227466800, 28800),
(132, 7120, 533, 1215216000, 86400),
(133, 9887, 533, 1215216000, 86400),
(134, 4600, 552, 1218844800, 172800),
(136, 12089, 599, 1244246400, 259200);