26-12-2012, 11:17 PM
--
-- Table structure for table `event`
--
DROP TABLE IF EXISTS `event`;
CREATE TABLE IF NOT EXISTS `event` (
`EventID` int(10) unsigned NOT NULL auto_increment,
`EventName` varchar(35) NOT NULL,
`FromDate` date default '0000-00-00',
`ToDate` date default '0000-00-00',
`EventTime` time default NULL,
`DressCode` varchar(100) NOT NULL,
`Description` text,
`MainThumbnail` varchar(100) default NULL,
`FeaturedCopy` varchar(150) default NULL,
`CategoryID` int(10) unsigned default NULL,
`Price` varchar(6) default 'R0',
`AreaID` int(10) unsigned default NULL,
`IsFeatured` tinyint(1) unsigned NOT NULL default '0',
`DateAdded` datetime NOT NULL,
`IsActive` tinyint(1) NOT NULL default '0',
`CanComment` tinyint(1) NOT NULL default '1',
`FavouriteCount` int(10) unsigned NOT NULL default '0',
`RSVP` varchar(60) default NULL,
`RSVPContact` char(10) default NULL,
`Type` varchar(8) NOT NULL,
`EventDay` varchar(2) default NULL,
`RunsMon` tinyint(1) unsigned default '0',
`RunsTues` tinyint(1) unsigned default '0',
`RunsWed` tinyint(1) unsigned default '0',
`RunsThurs` tinyint(1) unsigned default '0',
`RunsFri` tinyint(1) unsigned default '0',
`RunsSat` tinyint(1) unsigned default '0',
`RunsSun` tinyint(1) unsigned default '0',
`FlashImg1` varchar(100) default NULL,
`FlashImg2` varchar(100) default NULL,
`FlashImg3` varchar(100) default NULL,
PRIMARY KEY (`EventID`),
KEY `FK_event_1` (`CategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=169 ;
--
-- Dumping data for table `event`
--
INSERT INTO `event` (`EventID`, `EventName`, `FromDate`, `ToDate`, `EventTime`, `DressCode`, `Description`, `MainThumbnail`, `FeaturedCopy`, `CategoryID`, `Price`, `AreaID`, `IsFeatured`, `DateAdded`, `IsActive`, `CanComment`, `FavouriteCount`, `RSVP`, `RSVPContact`, `Type`, `EventDay`, `RunsMon`, `RunsTues`, `RunsWed`, `RunsThurs`, `RunsFri`, `RunsSat`, `RunsSun`, `FlashImg1`, `FlashImg2`, `FlashImg3`) VALUES
(1, 'WWE wrestling', '2009-08-04', '2009-08-07', '11:50:49', 'Smart Casual, Funky Corporate, Jeans wear and sports', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1450914/main_thumbnail/thumb_event1450914.jpg', 'Lorem ipsum dolor si', 1, 'R50', 25, 1, '2009-10-24 11:11:49', 1, 1, 4, NULL, NULL, 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(123, 'ANC Annual Meeting', '2009-11-13', '2009-11-13', '02:05:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1230913/main_thumbnail/thumb_event1230913.jpg', '', 10, 'R231', 7, 1, '2008-09-13 08:48:12', 1, 1, 0, 'Dele', '0219531253', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(129, 'Baba Indaba', '2008-10-22', '2008-10-22', '05:00:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1290914/main_thumbnail/thumb_event1290914.jpg', '', 1, 'R50', 25, 1, '2008-09-14 19:51:44', 1, 1, 0, '', '', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(131, 'Design Indaba 2010', '2009-11-11', '2009-11-25', '00:00:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1310914/main_thumbnail/thumb_event1310914.jpg', '', 1, 'R0', 2, 0, '2008-09-14 19:56:36', 1, 0, 0, '', '', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(132, 'Decorex 2009', '2009-10-15', '2009-10-15', '05:00:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1480203/main_thumbnail/thumb_event1480203.jpg', '', 1, 'R0', 2, 0, '2008-09-14 19:57:58', 1, 0, 0, '', '', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(141, 'Cafe Expo 2008', '2009-06-07', '2009-08-08', '05:00:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1410914/main_thumbnail/thumb_event1410914.jpg', '', 1, 'R1500', 14, 0, '2008-09-14 20:59:34', 1, 0, 0, '', '', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(142, 'Cafe Expo', '2008-04-04', '2009-05-02', '05:00:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1420914/main_thumbnail/thumb_event1420914.jpg', '', 7, 'R0', 14, 0, '2008-09-14 21:00:02', 1, 0, 0, '', '', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(143, 'Indaba Expo 2009', '2008-11-28', '2008-11-29', '06:00:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1430914/main_thumbnail/thumb_event1430914.jpg', '', 1, 'R200', 4, 0, '2008-09-14 21:01:35', 1, 0, 0, '', '', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(144, 'Wordpress 2009', '2009-09-05', '2009-09-05', '03:15:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1440914/main_thumbnail/thumb_event1440914.jpg', '', 1, 'R200', 4, 0, '2009-09-14 21:03:28', 1, 0, 0, 'George Micheal', '0219531253', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(145, 'Ackermans Summit', '2008-04-04', '2008-04-04', '05:20:00', '', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1450914/main_thumbnail/thumb_event1450914.jpg', '', 4, 'R20', 89, 1, '2008-09-14 21:06:12', 1, 1, 0, '', '', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(146, 'Christain Prayers Net', '2009-05-22', '2009-05-22', '03:15:00', 'casual', 'You can initiate this validator with both options. The first option is min, the second option is max. When only one option is given it is used as max. But you can also use the methods setMin() and setMax() to set both options afterwards and getMin() and getMax() to retrieve the actual set values.', 'event1320914/main_thumbnail/thumb_event1320914.jpg', '', 4, 'R20', 17, 1, '2008-09-14 21:06:12', 1, 1, 0, 'Louw Amstrong', '0219556565', 'onceoff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(148, 'Alice in Wonderlandc', '0000-00-00', '0000-00-00', '06:00:00', '', 'A group of professionals with experience in design, marketing and the service industry came \rtogether with the goal to create a marketing platform that surpassed all others in terms of quality,\rservices and features - the result was Main Event. ', 'event1480203/main_thumbnail/thumb_event1480203.jpg', '', 1, 'R0', 21, 1, '2009-02-03 10:23:47', 1, 1, 0, '', '', 'weekly', NULL, 0, 0, 1, 0, 0, 0, 0, '', NULL, NULL),
(149, 'J&B Crackdown', '0000-00-00', '0000-00-00', '06:00:00', '', 'dsfdfdfd', 'event1490203/main_thumbnail/thumb_event1490203.jpg', '', 1, 'R0', 25, 1, '2009-02-03 11:38:40', 1, 1, 0, '', '', 'weekly', '23', 0, 0, 0, 0, 0, 0, 0, '', NULL, NULL),
(158, 'Flash 2009 test', '2008-02-04', '2008-06-02', '04:00:00', '', 'dfdf', 'event1440914/main_thumbnail/thumb_event1440914.jpg', 'This is the coming of what is to come', 6, 'R0', 14, 1, '2009-02-05 13:40:41', 1, 1, 0, '', '', 'onceoff', NULL, 0, 0, 0, 0, 0, 0, 0, 'event1580205/flash_img/fla_img1581.jpg', 'event1580205/flash_img/fla_img1582.jpg', 'event1580205/flash_img/fla_img1582.jpg'),
(163, 'Flash 2009 test2', '2008-10-22', '2008-10-22', '04:05:00', '', 'afaffa', 'event1630206/main_thumbnail/thumb_event1630206.jpg', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Mauris libero. Praesent lobortis, tellus ac placerat viverra, magna felis cursus nibh, et rh', 13, 'R250', 8, 1, '2009-02-06 07:35:28', 1, 1, 0, '', '', 'onceoff', NULL, 0, 0, 0, 0, 0, 0, 0, 'event1630206/flash_img/fla_img1631.jpg', 'event1630206/flash_img/fla_img1632.jpg', 'event1630206/flash_img/fla_img1632.jpg'),
(165, 'Weekly Test', '0000-00-00', '0000-00-00', '03:00:00', '', 'ssfff', 'event1650211/main_thumbnail/thumb_event1650211.jpg', NULL, 6, 'R0', 22, 0, '2009-02-11 14:42:22', 1, 1, 0, '', '', 'weekly', NULL, 1, 1, 0, 0, 0, 1, 0, 'event1650211/flash_img/fla_img1651.jpg', 'event1650211/flash_img/fla_img1652.jpg', 'event1650211/flash_img/fla_img1652.jpg'),
(166, 'Weekly Test 2', '0000-00-00', '0000-00-00', '03:40:00', '', 'dsfsfsfsf', 'event1660211/main_thumbnail/thumb_event1660211.jpg', NULL, 1, 'R0', 14, 1, '2009-02-11 14:48:32', 1, 1, 0, '', '', 'weekly', NULL, 1, 0, 0, 0, 0, 0, 0, 'event1660211/flash_img/fla_img1661.jpg', 'event1660211/flash_img/fla_img1662.jpg', 'event1660211/flash_img/fla_img1662.jpg'),
(167, 'Flash 2009 test3', '0000-00-00', '0000-00-00', '03:30:00', '', 'ssdsdsdsdsdsd', 'event1670211/main_thumbnail/thumb_event1670211.jpg', NULL, 1, 'R0', 20, 1, '2009-02-11 14:51:15', 1, 1, 0, '', '', 'weekly', NULL, 1, 0, 1, 0, 1, 0, 0, 'event1670211/flash_img/fla_img1671.jpg', 'event1670211/flash_img/fla_img1672.jpg', 'event1670211/flash_img/fla_img1672.jpg'),
(168, 'Flash 2009 test4', '0000-00-00', '0000-00-00', '03:00:00', '', 'ssd', 'event1680211/main_thumbnail/thumb_event1680211.jpg', NULL, 1, 'R10', 8, 1, '2009-02-11 14:59:09', 1, 1, 0, '', '', 'weekly', '05', 0, 0, 0, 1, 0, 0, 0, 'event1680211/flash_img/fla_img1681.jpg', 'event1680211/flash_img/fla_img1682.jpg', 'event1680211/flash_img/fla_img1682.jpg');
-- --------------------------------------------------------