-- phpMyAdmin SQL Dump -- version 2.7.0-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Mar 02, 2006 at 10:30 PM -- Server version: 4.1.12 -- PHP Version: 5.0.4 -- -- Database: `vina` -- -- -------------------------------------------------------- -- -- Table structure for table `announce` -- CREATE TABLE `announce` ( `announce_id` bigint(20) NOT NULL auto_increment, `announce_text` varchar(100) NOT NULL default '', `announce_start_date` date NOT NULL default '0000-00-00', `announce_event_date` date NOT NULL default '0000-00-00', `announce_time` varchar(50) NOT NULL default '', PRIMARY KEY (`announce_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `announce` -- INSERT INTO `announce` VALUES (1, 'another', '2006-01-25', '2006-02-28', 'time'); INSERT INTO `announce` VALUES (2, 'new', '2006-01-16', '2006-02-27', 'time'); -- -------------------------------------------------------- -- -- Table structure for table `calander` -- CREATE TABLE `calander` ( `cal_id` bigint(20) NOT NULL auto_increment, `cal_date` date NOT NULL default '0000-00-00', `cal_event` varchar(40) character set latin1 NOT NULL default '', `cal_moon_phase` char(1) character set latin1 NOT NULL default '', PRIMARY KEY (`cal_id`), UNIQUE KEY `cal_date` (`cal_date`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii AUTO_INCREMENT=101 ; -- -- Dumping data for table `calander` -- INSERT INTO `calander` VALUES (1, '2005-09-11', 'Gaura-astami.', '1'); INSERT INTO `calander` VALUES (2, '2006-03-14', ' Sri Gauravirbhava h', '1'); INSERT INTO `calander` VALUES (3, '2005-08-31', ' Krishna-dvada si. Paran by 9:a.m.', ''); INSERT INTO `calander` VALUES (4, '2006-03-11', 'Gaura-dvadasi. Paran by 9:54 a.m. Parikr', ''); INSERT INTO `calander` VALUES (5, '2005-09-16', 'Gaura-trayodasi. Appearance of Srila Sac', ''); INSERT INTO `calander` VALUES (6, '2005-11-04', 'aura-tritiya. Disappearance of Srila Vas', ''); INSERT INTO `calander` VALUES (7, '2005-10-25', 'Krishna-astami. Bahulastami. Manifestati', '0'); INSERT INTO `calander` VALUES (8, '2006-01-11', 'Gaura-dvadasi. Paran by 9:57 a.m.', ''); INSERT INTO `calander` VALUES (9, '2006-02-28', '. by 9:54 a.m. for those', ''); INSERT INTO `calander` VALUES (10, '2005-11-15', 'Gaura-chaturdasi. Disappearance of Srila', ''); INSERT INTO `calander` VALUES (11, '2006-01-23', 'Krishna-astami. Disappearance of Srila L', ''); INSERT INTO `calander` VALUES (12, '2006-02-09', 'Gaura-dvadasi. Varaha . Paran aft', ''); INSERT INTO `calander` VALUES (13, '2006-02-03', 'aura-panchami. Sri Krishna Vasanta Panch', '1'); INSERT INTO `calander` VALUES (14, '2005-08-30', 'Krishna-ekadasi. Annada Ekadasi. Fast.', ''); INSERT INTO `calander` VALUES (15, '2005-11-06', 'Gaura-panchami. Disappearance of Tridand', ''); INSERT INTO `calander` VALUES (16, '2005-10-14', 'Gaura-dvadasi. Fast of Pasankosa Ekadasi', '1'); INSERT INTO `calander` VALUES (17, '2005-10-29', 'Krishna-dvadasi. Paran between 8:45', '0'); INSERT INTO `calander` VALUES (18, '2006-01-17', 'Krishna-tritiya. Appearance of Srila Gop', ''); INSERT INTO `calander` VALUES (19, '2005-11-12', 'Sri Utthana Ekadasi. Fast.', ''); INSERT INTO `calander` VALUES (20, '2005-08-14', 'Gaura-navami. Disappearance of Tridandi', ''); INSERT INTO `calander` VALUES (21, '2006-03-10', 'Gaura-ekadasi. Fast. Sri Nabadwip Dham P', ''); INSERT INTO `calander` VALUES (22, '2006-01-26', 'Krishna-dvadasi. Paran between 9:11 and', ''); INSERT INTO `calander` VALUES (23, '2005-08-09', 'aura-chaturthi. Disappearance of Srila V', ''); INSERT INTO `calander` VALUES (24, '2005-12-28', 'Krishna-dvadasi. Paran by 9:52 a.m. Dis', ''); INSERT INTO `calander` VALUES (25, '2005-10-22', 'Krishna-panchami. Disappearance of Srila', ''); INSERT INTO `calander` VALUES (26, '2006-02-25', 'Krishna-dvadasi. Paran by 9:51 a.m.', ''); INSERT INTO `calander` VALUES (27, '2006-01-30', 'Gaura-pratipad. Disappearance of Tridand', ''); INSERT INTO `calander` VALUES (28, '2005-12-15', 'Purnima.', ''); INSERT INTO `calander` VALUES (29, '2006-03-13', 'Gaura-chaturdasi. Adhivas observance cer', ''); INSERT INTO `calander` VALUES (30, '2005-08-12', 'Gaura-saptami. Disappearance of Sripad A', ''); INSERT INTO `calander` VALUES (31, '2005-12-01', 'mavasya. Disappearance of Srila Jagaband', ''); INSERT INTO `calander` VALUES (32, '2005-10-31', 'Krishna-chaturdasi. Offering and placing', ''); INSERT INTO `calander` VALUES (33, '2006-01-20', 'Krishna-sasthi. Disappearance of Srila J', ''); INSERT INTO `calander` VALUES (34, '2005-08-16', 'Gaura-ekadasi. Pavitraropani Ekadasi. Fa', ''); INSERT INTO `calander` VALUES (35, '2005-10-17', 'Purnima. Saradiya Rasa Yatra of Sri Kris', ''); INSERT INTO `calander` VALUES (36, '2006-03-12', 'Gaura-trayodasi. Parikrama of Sri Godrum', ''); INSERT INTO `calander` VALUES (37, '2005-09-20', 'Krishna-dvitiya. Disappearance of Tridan', ''); INSERT INTO `calander` VALUES (38, '2006-03-15', 'Krishna-pratipada. Paran by 9:47 a.m. A', ''); INSERT INTO `calander` VALUES (39, '2006-02-08', 'aura-ekadasi. Bhaimi Ekadasi. Fast.\r\n', ''); INSERT INTO `calander` VALUES (40, '2006-02-13', 'Purnima. Appearance of Srila Narottama d', ''); INSERT INTO `calander` VALUES (41, '2006-02-27', 'Krishna-chaturdasi. Sri Sri Shivaratri.', ''); INSERT INTO `calander` VALUES (42, '2005-09-30', 'Krishna-dvadasi. Paran by 9:28 a.m.\r\n', ''); INSERT INTO `calander` VALUES (43, '2005-10-13', 'Gaura-ekadasi. No Fast. Vijay Utsav of S', ''); INSERT INTO `calander` VALUES (44, '2005-10-20', 'Krishna-tritiya. Disappearance of Tridan', ''); INSERT INTO `calander` VALUES (45, '2006-02-24', ' Krishna-ekadasi. Fast of Viyay Ekadasi.', ''); INSERT INTO `calander` VALUES (46, '2006-02-07', 'aura-dasami. Disappearance of Srila Rama', ''); INSERT INTO `calander` VALUES (47, '2005-09-14', 'Gaura-ekadasi. Parshvaika Ekadasi. Fast.', ''); INSERT INTO `calander` VALUES (48, '2006-02-18', 'Krishna-panchami. The festival of the Di', ''); INSERT INTO `calander` VALUES (49, '2005-08-28', 'Krishna-navami. Sri Nandotsava. Sri Janm', ''); INSERT INTO `calander` VALUES (50, '2005-11-13', ' Gaura-dvadasi. Paran by 9:31 a.m.\r\n', ''); INSERT INTO `calander` VALUES (51, '2005-08-19', 'Purnima. Appearance of Sri Baladeva. Fas', ''); INSERT INTO `calander` VALUES (52, '2005-11-29', 'Krishna-trayodasi. Disappearance of Sril', ''); INSERT INTO `calander` VALUES (53, '2005-09-15', 'Gaura-dvadasi. Appearance of Sri Vamanad', ''); INSERT INTO `calander` VALUES (54, '2005-11-03', 'aura-pratipada. Go-puja (cow-worship) an', ''); INSERT INTO `calander` VALUES (55, '2005-12-12', 'Gaura-dvadasi. Paran by 9:43 a.m.\r\n', ''); INSERT INTO `calander` VALUES (56, '2006-01-14', 'Purnima. Pusyabhisheka Yatra of Sri Kris', ''); INSERT INTO `calander` VALUES (57, '2005-10-06', 'aura-tritiya. Disappearance of Sri Yukta', ''); INSERT INTO `calander` VALUES (58, '2005-10-26', 'Krishna-navami. Grand 111th Appearance f', ''); INSERT INTO `calander` VALUES (59, '2005-09-08', 'aura-panchami. Appearance of Sri Sita De', ''); INSERT INTO `calander` VALUES (60, '2005-12-29', 'Krishna-trayodasi. Disappearance of Sril', ''); INSERT INTO `calander` VALUES (61, '2005-12-17', 'Krishna-dvitiya. The grand celebration o', ''); INSERT INTO `calander` VALUES (62, '2006-02-10', 'Gaura-trayodasi. Appearance of Sri Nitya', ''); INSERT INTO `calander` VALUES (63, '2006-03-01', 'aura-dvitiya. Disappearance of Vaishnava', ''); INSERT INTO `calander` VALUES (64, '2006-01-15', 'Krishna-pratipad. Festival in remembranc', ''); INSERT INTO `calander` VALUES (65, '2005-10-23', 'Krishna-sasthi. Disappearance of Srila B', ''); INSERT INTO `calander` VALUES (66, '2005-12-11', 'Gaura-ekadasi. Moksa Ekadasi. Fast.\r\n', ''); INSERT INTO `calander` VALUES (67, '2005-09-18', 'Purnima. Visvarupa Mahotsava. End of mon', ''); INSERT INTO `calander` VALUES (68, '2006-01-31', 'Gaura-dvitiya. Disappearance of Tridandi', ''); INSERT INTO `calander` VALUES (69, '2005-12-18', 'Krishna-tritiya. Festivals at the appear', ''); INSERT INTO `calander` VALUES (70, '2005-11-08', 'h from 11 to 12 regarding packing and ba', ''); INSERT INTO `calander` VALUES (71, '2006-01-02', 'aura-tritiya. Disappearance of Srila Jiv', ''); INSERT INTO `calander` VALUES (72, '2005-11-09', 'aura-astami. Disappearance of Sri Gadadh', ''); INSERT INTO `calander` VALUES (73, '2005-11-02', 'mavasya. Dipavali. Offering and placing', ''); INSERT INTO `calander` VALUES (74, '2005-11-05', 'aura-chaturthi. Disappearance festival o', ''); INSERT INTO `calander` VALUES (75, '2005-11-16', 'Purnima. Rasayatra of Sri Krishna. Insta', ''); INSERT INTO `calander` VALUES (76, '2005-10-28', 'Krishna-ekadasi. Rama Ekadasi. Fast.\r\n', ''); INSERT INTO `calander` VALUES (77, '2005-08-27', 'Krishna-astami. Sri Sri Krishna Janmasta', ''); INSERT INTO `calander` VALUES (78, '2005-09-13', 'pancho things\r\n', ''); INSERT INTO `calander` VALUES (79, '2006-02-05', 'aura-astami. Appearance of Mahavishnu Av', ''); INSERT INTO `calander` VALUES (80, '2005-11-27', ' Utpanna Ekadasi. Fast.\r\n', ''); INSERT INTO `calander` VALUES (81, '2006-02-19', 'Krishna-sasthi. Appearance of Tridandi S', ''); INSERT INTO `calander` VALUES (82, '2005-12-19', 'Krishna-chaturthi. Disappearance festiva', ''); INSERT INTO `calander` VALUES (83, '2005-09-10', 'Gaura-saptami. Sri Lalita-saptami. Appea', ''); INSERT INTO `calander` VALUES (84, '2006-03-02', 'aura-tritiya. Sri Sri Guru-Gauranga-Radh', ''); INSERT INTO `calander` VALUES (85, '2005-08-05', 'mavasya. Disappearance of Om Vishnupad P', ''); INSERT INTO `calander` VALUES (86, '2006-03-09', 'aura-dasami. Adhivas Festival of Sri Nab', ''); INSERT INTO `calander` VALUES (87, '2006-03-03', 'aura-chaturthi. Appearance of Srila Puru', ''); INSERT INTO `calander` VALUES (88, '2005-10-15', 'Gaura-trayodasi. Paran by 9:27 a.m.\r\n', ''); INSERT INTO `calander` VALUES (89, '2005-11-28', 'Krishna-dvadasi. Paran by 9:37 a.m. Dis', ''); INSERT INTO `calander` VALUES (90, '2006-02-11', 'Gaura-chaturdasi. Paran by 9:59 a.m. for', ''); INSERT INTO `calander` VALUES (91, '2006-02-06', 'aura-navami. Disappearance of Sripad Mad', ''); INSERT INTO `calander` VALUES (92, '2006-03-20', 'Krishna-panchami. Festival at the Appear', ''); INSERT INTO `calander` VALUES (93, '2005-09-17', 'Gaura-chaturdasi. Disappearance of Srila', ''); INSERT INTO `calander` VALUES (94, '2005-12-27', 'Krishna-ekadasi. Saphala Ekadasi. Fast.', ''); INSERT INTO `calander` VALUES (95, '2006-01-10', 'Gaura-ekadasi. Putrada Ekadasi. Fast.\r\n', ''); INSERT INTO `calander` VALUES (96, '2005-09-29', 'Krishna-ekadasi. Indira Ekadasi. Fast.\r\n', ''); INSERT INTO `calander` VALUES (97, '2006-01-18', 'Krishna-chaturthi. Disappearance of Srip', ''); INSERT INTO `calander` VALUES (98, '2006-01-01', 'aura-pratipada. Appearance of Srila Loch', ''); INSERT INTO `calander` VALUES (99, '2005-08-17', 'Gaura-dvadasi. Paran by 7:31 a.m. Disapp', ''); INSERT INTO `calander` VALUES (100, '2006-01-25', 'Krishna-ekadasi. Sat-tila Ekadasi. Fast.', ''); -- -------------------------------------------------------- -- -- Table structure for table `dham_seva` -- CREATE TABLE `dham_seva` ( `dham_seva_id` bigint(20) NOT NULL auto_increment, `dham_seva_title` varchar(255) NOT NULL default '', `dham_seva_author` varchar(255) NOT NULL default '', `dham_seva_article` longtext NOT NULL, `dham_seva_pic_path` varchar(255) NOT NULL default '', `dham_seva_pic_path_flag` char(1) NOT NULL default '0', `dham_seva_source_link` varchar(255) NOT NULL default '', `dham_seva_source_link_flag` char(1) NOT NULL default '0', `dham_seva_external_link` varchar(255) NOT NULL default '', `dham_seva_external_link_flag` char(1) NOT NULL default '0', `dham_seva_date_pub` date NOT NULL default '0000-00-00', `dham_seva_submit_by` varchar(255) NOT NULL default '', `dham_seva_priority` char(1) NOT NULL default '0', `dham_seva_insti_name` varchar(255) NOT NULL default '', `dham_seva_place` varchar(255) NOT NULL default '', `dham_seva_place_flag` char(1) NOT NULL default '0', `dham_seva_description` text NOT NULL, `dham_seva_gallery_flag` char(2) NOT NULL default '0', PRIMARY KEY (`dham_seva_id`), UNIQUE KEY `dham_seva_title` (`dham_seva_title`) ) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=1 ; -- -- Dumping data for table `dham_seva` -- -- -------------------------------------------------------- -- -- Table structure for table `general_news` -- CREATE TABLE `general_news` ( `general_news_id` bigint(20) NOT NULL auto_increment, `general_news_title` varchar(255) NOT NULL default '', `general_news_author` varchar(255) NOT NULL default '', `general_news_article` longtext NOT NULL, `general_news_pic_path` varchar(255) NOT NULL default '', `general_news_pic_path_flag` char(1) NOT NULL default '0', `general_news_source_link` varchar(255) NOT NULL default '', `general_news_source_link_flag` char(1) NOT NULL default '0', `general_news_external_link` varchar(255) NOT NULL default '', `general_news_external_link_flag` char(1) NOT NULL default '0', `general_news_date_pub` date NOT NULL default '0000-00-00', `general_news_submit_by` varchar(255) NOT NULL default '', `general_news_priority` char(1) NOT NULL default '0', `general_news_insti_name` varchar(255) NOT NULL default '', `general_news_place` varchar(255) NOT NULL default '', `general_news_place_flag` char(1) NOT NULL default '0', `general_news_description` text NOT NULL, `general_news_gallery_flag` char(2) NOT NULL default '0', PRIMARY KEY (`general_news_id`), UNIQUE KEY `general_news_title` (`general_news_title`), UNIQUE KEY `general_news_title_2` (`general_news_title`) ) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=4 ; -- -- Dumping data for table `general_news` -- INSERT INTO `general_news` VALUES (1, 'jkh', 'jkh', 'kjhkhkhhkj', '', '', '', '0', '', '0', '2006-01-23', 'kjh', '1', 'kjh', 'jkk', '1', 'hjkhkjh', '1'); INSERT INTO `general_news` VALUES (2, 'SRILA GOUR GOVINDA MAHARAJA DISAPPEARANCE FESTIVAL', 'GK', 'Annual Disappearance Festival Sri Srimad Gour Govinda Swami\r\n\r\nGopal Jiu Publications is pleased to invite all Vaishnavas to attend the 10th annual disappearance festival of Srila Gour Govinda Swami.\r\n\r\nSee our blog page to read the story about his disappearance or to see photos from last years festival: \r\nThe festival will take place on the 18th and 19th of February 2006 at ISKCON Sridham Mayapur. Everyone is welcome.\r\n\r\nSCHEDULE:\r\n\r\n18 FEB\r\n\r\nSri Srimad Gour Govinda Maharaja''s Disappearance Day\r\nEvents at Maharaja''s Puspa Samadhi:\r\n\r\n5:30 PM Bhajans by Gadeigiri Orissa kirtaniyas\r\n\r\n6:15 PM Srila Gour Govinda Maharaja Video lecture\r\n\r\n6:45 PM Remembrances and talks\r\n\r\n8:45 PM Program finishes\r\n\r\n19 FEB\r\n\r\n2:00 PM Mahaprasadam Distribution at ISKCON campus.\r\n\r\nEvents at Maharaja''s Puspa Samadhi:\r\n\r\n5:30 PM Bhajans by Gadeigiri kirtaniyas\r\n\r\n6:15 PM Srila Gour Govinda Maharaja Video lecture\r\n\r\n6:45 PM Remembrances and talks\r\n\r\n8:45 PM Program finishes\r\n\r\n20 FEB\r\n\r\nEvening: Orissan style bhajanas Gadeigiri kirtaniyas. Place and time to be announced.', '', '', '', '0', 'http://sggsm.blogspot.com/', '1', '2006-02-27', 'Govind', '0', 'ISCON', 'Mayapur', '1', 'Gopal Jiu Publications is pleased to invite all Vaishnavas to attend the 10th annual disappearance festival of Srila Gour Govinda Swami. The festival will take place on the 18th and 19th of February 2006 at ISKCON Sridham Mayapur. Everyone is welcome.', '1'); INSERT INTO `general_news` VALUES (3, 'kjk', 'jlkjkljkl', 'jkljklj', '', '', 'lk', '1', 'lkj', '1', '2006-03-01', 'kljlk', '1', 'lkjlkljklk', 'lkjkl', '1', 'lkjlk', '0'); -- -------------------------------------------------------- -- -- Table structure for table `mission_news` -- CREATE TABLE `mission_news` ( `mission_news_id` bigint(20) NOT NULL auto_increment, `mission_news_title` varchar(255) NOT NULL default '', `mission_news_author` varchar(255) NOT NULL default '', `mission_news_article` longtext NOT NULL, `mission_news_pic_path` varchar(255) NOT NULL default '', `mission_news_pic_path_flag` char(1) NOT NULL default '0', `mission_news_source_link` varchar(255) NOT NULL default '', `mission_news_source_link_flag` char(1) NOT NULL default '0', `mission_news_external_link` varchar(255) NOT NULL default '', `mission_news_external_link_flag` char(1) NOT NULL default '0', `mission_news_date_pub` date NOT NULL default '0000-00-00', `mission_news_submit_by` varchar(255) NOT NULL default '', `mission_news_priority` char(1) NOT NULL default '0', `mission_news_insti_name` varchar(255) NOT NULL default '', `mission_news_place` varchar(255) NOT NULL default '', `mission_news_place_flag` char(1) NOT NULL default '0', `mission_news_description` text NOT NULL, `mission_news_gallery_flag` char(2) NOT NULL default '0', PRIMARY KEY (`mission_news_id`), UNIQUE KEY `mission_news_title` (`mission_news_title`) ) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=4 ; -- -- Dumping data for table `mission_news` -- INSERT INTO `mission_news` VALUES (1, 'title', 'author', 'arti', '', '', '', '0', '', '0', '2006-02-19', 'me', '1', 'insti name', 'place', '1', 'des', '1'); INSERT INTO `mission_news` VALUES (2, 'kjk', 'jlkjkljkl', 'jkljklj', '', '', 'lk', '1', 'lkj', '1', '2006-03-01', 'kljlk', '1', 'lkjlkljklk', 'lkjkl', '1', 'lkjlk', '0'); INSERT INTO `mission_news` VALUES (3, 'kjkj', 'jlkjkljkl', 'jkljklj', '', '', 'lk', '1', 'lkj', '1', '2006-03-01', 'kljlk', '1', 'lkjlkljklk', 'lkjkl', '1', 'lkjlk', '0'); -- -------------------------------------------------------- -- -- Table structure for table `philosophy_news` -- CREATE TABLE `philosophy_news` ( `philosophy_news_id` bigint(20) NOT NULL auto_increment, `philosophy_news_title` varchar(255) NOT NULL default '', `philosophy_news_author` varchar(255) NOT NULL default '', `philosophy_news_article` longtext NOT NULL, `philosophy_news_pic_path` varchar(255) NOT NULL default '', `philosophy_news_pic_path_flag` char(1) NOT NULL default '0', `philosophy_news_source_link` varchar(255) NOT NULL default '', `philosophy_news_source_link_flag` char(1) NOT NULL default '0', `philosophy_news_external_link` varchar(255) NOT NULL default '', `philosophy_news_external_link_flag` char(1) NOT NULL default '0', `philosophy_news_date_pub` date NOT NULL default '0000-00-00', `philosophy_news_submit_by` varchar(255) NOT NULL default '', `philosophy_news_priority` char(1) NOT NULL default '0', `philosophy_news_insti_name` varchar(255) NOT NULL default '', `philosophy_news_place` varchar(255) NOT NULL default '', `philosophy_news_place_flag` char(1) NOT NULL default '0', `philosophy_news_description` text NOT NULL, `philosophy_news_gallery_flag` char(2) NOT NULL default '0', PRIMARY KEY (`philosophy_news_id`), UNIQUE KEY `philosophy_news_title` (`philosophy_news_title`) ) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=3 ; -- -- Dumping data for table `philosophy_news` -- INSERT INTO `philosophy_news` VALUES (1, 'jkhl', 'jkh', 'kjhkhkhhkj', '', '', '', '0', '', '0', '2006-01-23', 'kjh', '1', 'kjh', 'jkk', '1', 'hjkhkjh', '1'); INSERT INTO `philosophy_news` VALUES (2, 'jkh', 'jkh', 'kjhkhkhhkj', '', '', '', '0', '', '0', '2006-01-23', 'kjh', '1', 'kjh', 'jkk', '1', 'hjkhkjh', '1'); -- -------------------------------------------------------- -- -- Table structure for table `photo_gallery` -- CREATE TABLE `photo_gallery` ( `photo_gal_id` bigint(20) NOT NULL auto_increment, `photo_gal_art_id` bigint(20) NOT NULL default '0', `photo_gal_text` longtext character set latin1 NOT NULL, `photo_gal_flag` char(1) character set latin1 NOT NULL default '1', `photo_gal_image_name` varchar(255) character set latin1 NOT NULL default '', `photo_image_index` char(3) character set latin1 NOT NULL default '', `photo_dir_type` char(1) character set latin1 NOT NULL default '2', `photo_gal_alt` varchar(255) character set latin1 NOT NULL default '', PRIMARY KEY (`photo_gal_id`), KEY `photo_gal_art_id` (`photo_gal_art_id`) ) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=68 ; -- -- Dumping data for table `photo_gallery` -- INSERT INTO `photo_gallery` VALUES (58, 9, 'iopiopiopi', '1', './images\\\\2006\\\\01\\\\23\\\\9.dham_seva\\\\Copy (3) of fractal6.jpg', '1', '1', 'vina - Copy (3) of fractal6.jpg'); INSERT INTO `photo_gallery` VALUES (59, 9, 'opkiopkpko;lk;l', '1', './images\\\\2006\\\\01\\\\23\\\\9.dham_seva\\\\fractal7.jpg', '2', '1', 'vina - fractal7.jpg'); INSERT INTO `photo_gallery` VALUES (61, 9, '][p][\r\n;p][\r\n', '1', './images\\\\2006\\\\01\\\\23\\\\9.dham_seva\\\\gallery\\\\fractal6.jpg', '1', '2', 'vina - fractal6.jpg'); INSERT INTO `photo_gallery` VALUES (62, 9, 'jhjkhkh;jkhkjhl;', '1', './images\\\\2006\\\\01\\\\23\\\\9.dham_seva\\\\Copy (2) of fractal6.jpg', '3', '1', 'vina - Copy (2) of fractal6.jpg'); INSERT INTO `photo_gallery` VALUES (63, 9, '][''l,''kllo''\r\nlklhljnm.j''', '1', './images\\\\2006\\\\01\\\\23\\\\9.dham_seva\\\\Copy of fractal7.jpg', '4', '1', 'vina - Copy of fractal7.jpg'); INSERT INTO `photo_gallery` VALUES (64, 9, 'l;[prkgDFsgdfkgml;sd''', '1', './images\\\\2006\\\\01\\\\23\\\\9.dham_seva\\\\gallery\\\\fractal7.jpg', '2', '2', 'vina - fractal7.jpg'); INSERT INTO `photo_gallery` VALUES (65, 12, 'ggighij', '1', './images\\\\2006\\\\02\\\\20\\\\12.dham_seva\\\\BG Krishna instructs Arjuna.jpg', '1', '1', 'vina - BG Krishna instructs Arjuna.jpg'); INSERT INTO `photo_gallery` VALUES (66, 12, 'gy', '1', './images\\\\2006\\\\02\\\\20\\\\12.dham_seva\\\\gallery\\\\akshayapatra.jpg', '1', '2', 'vina - akshayapatra.jpg'); INSERT INTO `photo_gallery` VALUES (67, 13, 'jkhkj', '1', './images\\\\2006\\\\02\\\\20\\\\13.dham_seva\\\\rudra.kunda.small.jpg', '1', '1', 'vina - rudra.kunda.small.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `pubilication_news` -- CREATE TABLE `pubilication_news` ( `pubilication_news_id` bigint(20) NOT NULL auto_increment, `pubilication_news_title` varchar(255) NOT NULL default '', `pubilication_news_author` varchar(255) NOT NULL default '', `pubilication_news_article` longtext NOT NULL, `pubilication_news_pic_path` varchar(255) NOT NULL default '', `pubilication_news_pic_path_flag` char(1) NOT NULL default '0', `pubilication_news_source_link` varchar(255) NOT NULL default '', `pubilication_news_source_link_flag` char(1) NOT NULL default '0', `pubilication_news_external_link` varchar(255) NOT NULL default '', `pubilication_news_external_link_flag` char(1) NOT NULL default '0', `pubilication_news_date_pub` date NOT NULL default '0000-00-00', `pubilication_news_submit_by` varchar(255) NOT NULL default '', `pubilication_news_priority` char(1) NOT NULL default '0', `pubilication_news_insti_name` varchar(255) NOT NULL default '', `pubilication_news_place` varchar(255) NOT NULL default '', `pubilication_news_place_flag` char(1) NOT NULL default '0', `pubilication_news_description` text NOT NULL, `pubilication_news_gallery_flag` char(2) NOT NULL default '0', PRIMARY KEY (`pubilication_news_id`), UNIQUE KEY `pubilication_news_title` (`pubilication_news_title`) ) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=2 ; -- -- Dumping data for table `pubilication_news` -- INSERT INTO `pubilication_news` VALUES (1, 'kjk', 'jlkjkljkl', 'jkljklj', '', '', 'lk', '1', 'lkj', '1', '2006-03-01', 'kljlk', '1', 'lkjlkljklk', 'lkjkl', '1', 'lkjlk', '0'); -- -------------------------------------------------------- -- -- Table structure for table `saints_news` -- CREATE TABLE `saints_news` ( `saints_news_id` bigint(20) NOT NULL auto_increment, `saints_news_title` varchar(255) NOT NULL default '', `saints_news_author` varchar(255) NOT NULL default '', `saints_news_article` longtext NOT NULL, `saints_news_pic_path` varchar(255) NOT NULL default '', `saints_news_pic_path_flag` char(1) NOT NULL default '0', `saints_news_source_link` varchar(255) NOT NULL default '', `saints_news_source_link_flag` char(1) NOT NULL default '0', `saints_news_external_link` varchar(255) NOT NULL default '', `saints_news_external_link_flag` char(1) NOT NULL default '0', `saints_news_date_pub` date NOT NULL default '0000-00-00', `saints_news_submit_by` varchar(255) NOT NULL default '', `saints_news_priority` char(1) NOT NULL default '0', `saints_news_insti_name` varchar(255) NOT NULL default '', `saints_news_place` varchar(255) NOT NULL default '', `saints_news_place_flag` char(1) NOT NULL default '0', `saints_news_description` text NOT NULL, `saints_news_gallery_flag` char(2) NOT NULL default '0', PRIMARY KEY (`saints_news_id`), UNIQUE KEY `saints_news_title` (`saints_news_title`) ) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=3 ; -- -- Dumping data for table `saints_news` -- INSERT INTO `saints_news` VALUES (1, 'titlel', 'author', 'acticale main', '', '', 'source link', '1', 'external link', '1', '2006-01-31', 'submit by', '1', '', '', '0', 'description', '0'); INSERT INTO `saints_news` VALUES (2, 'title', 'author', 'acticale main', '', '', 'source link', '1', 'external link', '1', '2006-01-31', 'submit by', '1', '', '', '0', 'description', '0'); -- -------------------------------------------------------- -- -- Table structure for table `wva_news` -- CREATE TABLE `wva_news` ( `wva_news_id` bigint(20) NOT NULL auto_increment, `wva_news_title` varchar(255) NOT NULL default '', `wva_news_author` varchar(255) NOT NULL default '', `wva_news_article` longtext NOT NULL, `wva_news_pic_path` varchar(255) NOT NULL default '', `wva_news_pic_path_flag` char(1) NOT NULL default '0', `wva_news_source_link` varchar(255) NOT NULL default '', `wva_news_source_link_flag` char(1) NOT NULL default '0', `wva_news_external_link` varchar(255) NOT NULL default '', `wva_news_external_link_flag` char(1) NOT NULL default '0', `wva_news_date_pub` date NOT NULL default '0000-00-00', `wva_news_submit_by` varchar(255) NOT NULL default '', `wva_news_priority` char(1) NOT NULL default '0', `wva_news_insti_name` varchar(255) NOT NULL default '', `wva_news_place` varchar(255) NOT NULL default '', `wva_news_place_flag` char(1) NOT NULL default '0', `wva_news_description` text NOT NULL, `wva_news_gallery_flag` char(2) NOT NULL default '0', PRIMARY KEY (`wva_news_id`), UNIQUE KEY `wva_news_title` (`wva_news_title`) ) ENGINE=InnoDB DEFAULT CHARSET=ascii AUTO_INCREMENT=1 ; -- -- Dumping data for table `wva_news` --