-- phpMyAdmin SQL Dump -- version 2.11.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 27, 2009 at 05:51 AM -- Server version: 4.1.22 -- PHP Version: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `cybercon_ccm` -- -- -------------------------------------------------------- -- -- Table structure for table `m01_00news_and_events` -- CREATE TABLE IF NOT EXISTS `m01_00news_and_events` ( `rowno` int(10) unsigned NOT NULL auto_increment, `type` varchar(10) NOT NULL default '', `news_topic_eng` varchar(50) NOT NULL default '', `news_topic_sin` varchar(50) default NULL, `news_topic_tn` varchar(50) default NULL, `news_des_eng` longtext NOT NULL, `news_des_sin` longtext, `news_des_tn` longtext, `cur_date` date NOT NULL default '0000-00-00', `exp_date` date NOT NULL default '0000-00-00', `news_image` varchar(200) NOT NULL default '', `news_thumbnail` varchar(200) NOT NULL default '', PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=87 ; -- -- Dumping data for table `m01_00news_and_events` -- INSERT INTO `m01_00news_and_events` (`rowno`, `type`, `news_topic_eng`, `news_topic_sin`, `news_topic_tn`, `news_des_eng`, `news_des_sin`, `news_des_tn`, `cur_date`, `exp_date`, `news_image`, `news_thumbnail`) VALUES (49, 'note', 'nfnrhryry', '', 'bnfbfgb', 'ryyryry', '', 'bvbnvbnvrnhgjhjggf', '2009-10-20', '2009-10-31', 'frhryry20091008082907.', 'frhryry20091008082907.'), (65, 'note', 'testdn', '', '', 'fdfdfdfd', '', '', '2009-10-22', '2009-10-23', 'testdn20091014045125.', 'testdn20091014045125.'), (68, 'note', 'test5DN', '', '', 'sdsds', '', '', '2009-10-01', '2009-10-31', '', ''), (69, 'note', 'otice2', '', '', 'fdfdhkjhk khkjkj', '', '', '2009-10-01', '2009-10-31', '', ''), (70, 'note', 'test6', '', '', 'dsdsd', '', '', '2009-10-01', '2009-10-30', '', ''), (79, 'news', 'test ccm site test ccm site hhh fjg adadfashfj kkk', '', '', 'hdhdfdjhj ggjgj\r\nfjfj fjf\r\njfgkgkgkgk', '', '', '2009-10-01', '2009-10-31', '', ''), (80, 'news', 'test diyath', '', '', 'fdfdgfgvnvnvrnff gf', '', '', '2009-10-06', '2009-10-28', '', ''), (81, 'note', 'test notice fhfjpho', '', '', 'hahah djrfktkrndhgkkrn last', '', '', '2009-10-01', '2009-10-20', '', ''), (82, 'note', 'dsdsdsd', '', 'ுிுிுி', 'sdsdsdsvvcvc', '', 'යටයටයටයටයට', '2009-10-06', '2009-10-14', '', ''), (83, 'news', 'trrtrtrtrtr', '', '', 'rtr hgghg nghgh gb', '', '', '2009-10-06', '2009-10-20', '', ''), (84, 'news', 'dssdsdsd', '', '', 'dsdsds', '', '', '2009-10-06', '2009-10-13', '', ''), (85, 'note', 'dsdsds', '', '', 'dsdsds', '', '', '2009-10-12', '2009-10-23', '', ''), (86, 'note', 'dsdsds2', '', '', 'dsdsds', '', '', '2009-10-12', '2009-10-23', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `m02_00forums` -- CREATE TABLE IF NOT EXISTS `m02_00forums` ( `rowno` int(10) unsigned NOT NULL auto_increment, `name` varchar(200) NOT NULL default '', `type` varchar(20) default NULL, `exp_date` date NOT NULL default '0000-00-00', `path` varchar(200) default NULL, `cur_date` date default NULL, `path_sin` varchar(200) default NULL, `path_ta` varchar(200) default NULL, `name_sin` varchar(200) default NULL, `name_ta` varchar(200) default NULL, PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ; -- -- Dumping data for table `m02_00forums` -- INSERT INTO `m02_00forums` (`rowno`, `name`, `type`, `exp_date`, `path`, `cur_date`, `path_sin`, `path_ta`, `name_sin`, `name_ta`) VALUES (7, 'test diyath3', 'app', '2009-09-30', '20090911053807.pdf', '2009-09-11', '20090911053807s.pdf', '20090911053807t.pdf', 'dddd', 'ttttttt'), (9, '29th CCm Meeting', 'min', '2009-09-13', '920090929094426.pdf', '2009-10-14', NULL, NULL, NULL, NULL), (10, '55th CCM Meeting', 'min', '2009-09-20', '1020090929094601.pdf', '2009-09-29', NULL, NULL, NULL, NULL), (12, 'pagination', 'app', '2009-09-22', '20090912062522.doc', '2009-09-12', '20090912062522s.doc', '20090912062522t.doc', 'pagination s', 'pagination t'), (15, '12th meeting', 'min', '2009-10-08', '20091008094507.pdf', '2009-10-08', NULL, NULL, NULL, NULL), (16, '13th meeting', 'min', '2009-10-08', '20091008094542.pdf', '2009-10-08', NULL, NULL, NULL, NULL), (17, '14th meeting test', 'min', '2009-10-01', '20091008094600.pdf', '2009-10-08', NULL, NULL, NULL, NULL), (19, 'aAaAa edi', 'min', '2009-10-29', '20091014082042.pdf', '2009-10-26', NULL, NULL, NULL, NULL), (20, 'diyath', 'min', '2009-10-26', '20091014083331.pdf', '2009-10-14', NULL, NULL, NULL, NULL), (21, 'adadadad', 'app', '2009-10-20', '20091019102924.pdf', '0000-00-00', '20091019102924s.pdf', '20091019102924t.pdf', 'dssdsd', 'dsdsdsds'), (22, 'sasasasasa', 'app', '2009-10-28', '20091019104115.pdf', '0000-00-00', '20091019104115s.pdf', '20091019104115t.pdf', 'ටටෙටෙටෙටෙටෙටෙටෙටෙ‍ෙ', 'fgfgfgfgfgfgfhghg'), (24, 'ipiog psjhjsh', 'min', '2009-10-20', '20091020062909.doc', '2009-10-26', NULL, NULL, NULL, NULL), (25, 'nirmala', 'min', '2009-10-20', '20091020102650.pdf', '0000-00-00', NULL, NULL, NULL, NULL), (26, 'jhgjhjh', 'min', '2009-10-21', '20091020103336.pdf', '0000-00-00', NULL, NULL, NULL, NULL), (27, 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb', 'min', '2009-10-14', '20091020110830.pdf', '2009-10-20', NULL, NULL, NULL, NULL), (28, 'dggfgf', 'min', '2009-10-27', '20091021041637.pdf', '2009-10-21', NULL, NULL, NULL, NULL), (29, 'dggfgf', 'min', '2009-10-27', '20091021042049.pdf', '2009-10-21', NULL, NULL, NULL, NULL), (30, 'fdfdfdfd', 'app', '2009-10-27', '20091021042449.pdf', '2009-10-21', '20091021042449s.pdf', '20091021042449t.pdf', 'gfgfgfgfg', 'gfgfgfgfgf'); -- -------------------------------------------------------- -- -- Table structure for table `m03_00gallery` -- CREATE TABLE IF NOT EXISTS `m03_00gallery` ( `rowno` int(10) unsigned NOT NULL auto_increment, `name` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default '', `path` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default '', `name_sin` varchar(50) NOT NULL default '', `name_tam` varchar(50) NOT NULL default '', PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ; -- -- Dumping data for table `m03_00gallery` -- INSERT INTO `m03_00gallery` (`rowno`, `name`, `path`, `name_sin`, `name_tam`) VALUES (18, '2 album', '20090911041508.jpg', '2 ්කඉමප', '2 யடஇரஅ'), (20, '2 album', '20090911041517.gif', '2 ්කඉමප', '2 யடஇரஅ'), (22, '1 album', '2220090911112059.jpg', '1 ්කඉමප', '1 யடஇரஅ'), (23, '1 album', '20090911041542.jpg', '1 ්කඉමප', '1 யடஇரஅ'), (25, '1 album', '20090911041550.jpg', '1 ්කඉමප', '1 யடஇரஅ'), (26, 'fgf', '20090911111802.jpg', 'ෛටෙ‍ෙ', 'அ​ெ'), (27, 'fgf', '20090911111817.jpg', 'ෛටෙ‍ෙ', 'அ​ெ'), (28, 'fgf', '20090911111826.jpg', 'ෛටෙ‍ෙ', 'அ​ெ'), (29, '2 album', '20090912054704.gif', '2 ්කඉමප', '2 யடஇரஅ'), (30, '2 album', '20090912054709.jpg', '2 ්කඉමප', '2 யடஇரஅ'), (31, '2 album', '20090912054723.jpg', '2 ්කඉමප', '2 யடஇரஅ'), (32, '1 album', '20090912054757.jpg', '1 ්කඉමප', '1 யடஇரஅ'), (33, '1 album', '20090912054801.jpg', '1 ්කඉමප', '1 யடஇரஅ'), (34, 'dfdfgdsf', '20090922060042.jpg', '', ''), (35, 'dfdfgdsf', '20090922060111.jpg', '', ''), (36, 'hjgjgjgj', '20091009101452.JPG', 'වටවටවටව', 'ுருருரு&'), (37, 'hjgjgjgj fkfkfkf fjfjfj', '20091009101513.JPG', 'වටවටවටව', 'ுருருரு&'), (38, '', '20091009101805.JPG', 'යෙටෙයෙය', 'ෙයෙයෙයෙ&'), (40, 'sasas', '20091019042113.jpg', 'sasas', 'asasa'), (41, 'kgkgkgkg', '20091020085259.jpg', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `session` -- CREATE TABLE IF NOT EXISTS `session` ( `session` varchar(32) NOT NULL default '', `code` varchar(4) NOT NULL default '', `heure` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`session`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `session` -- -- -------------------------------------------------------- -- -- Table structure for table `u01_00users` -- CREATE TABLE IF NOT EXISTS `u01_00users` ( `rowno` int(10) unsigned NOT NULL auto_increment, `u_id` varchar(30) NOT NULL default '', `user_pw` varchar(100) NOT NULL default '', `user_type` varchar(20) NOT NULL default '', PRIMARY KEY (`rowno`), UNIQUE KEY `u_id` (`u_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ; -- -- Dumping data for table `u01_00users` -- INSERT INTO `u01_00users` (`rowno`, `u_id`, `user_pw`, `user_type`) VALUES (1, 'admin', '202cb962ac59075b964b07152d234b70', 'ADMIN'), (2, 'ccm', '123', 'MEMB'), (4, 'dghs@health.gov.lk', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (8, 'shirleytissera@yahoo.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (9, 'nata@health.gov.lk', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (10, 'nonis@mackwoods.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (11, 'ed@fpasrilanka.org', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (12, 'gfatmsar@gmail.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (13, 'swarna.kodagoda@gmail.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (14, 'iqbal@sewalanka.org', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (15, 'nimaindu@hotmail.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (16, 'wayambawason@yahoo.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (17, 'matalebr@redcross.lk', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (18, 'dfsfsf@sds.lk', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (19, 'dtcs@health.gov.lk', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (20, 'ccmsrilanka@gmail.com', '123', 'MEMB'), (21, 'chanaka.walawwatte@gmail.com', '123', 'MEMB'), (22, 'slplusnet@gmail.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (23, 'ewew@n.vo', '123', 'MEMB'), (24, 'dnptccd@gmail.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (25, 'gfatmprojoff@sltnet.lk', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (26, 'n.ediri@gmail.com', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'), (27, 'antimal@sltnet.lk', 'd41d8cd98f00b204e9800998ecf8427e', 'MEMB'); -- -------------------------------------------------------- -- -- Table structure for table `u01_01memb_details` -- CREATE TABLE IF NOT EXISTS `u01_01memb_details` ( `rowno` int(10) unsigned NOT NULL auto_increment, `u_id` varchar(50) character set latin1 NOT NULL default '', `name_eng` varchar(200) character set latin1 NOT NULL default '', `role_eng` varchar(50) character set latin1 NOT NULL default '', `sector_eng` varchar(50) character set latin1 NOT NULL default '', `member_sin` date NOT NULL default '0000-00-00', `org_eng` text character set latin1 NOT NULL, `org_title_eng` text character set latin1 NOT NULL, `address_eng` varchar(200) character set latin1 NOT NULL default '', `tel` varchar(20) character set latin1 NOT NULL default '', `fax` varchar(20) character set latin1 NOT NULL default '', `email` varchar(50) character set latin1 NOT NULL default '', `web` varchar(100) character set latin1 default NULL, `img_path` varchar(200) character set latin1 NOT NULL default '', `name_sin` varchar(200) character set latin1 default NULL, `role_sin` varchar(200) character set latin1 default NULL, `sector_sin` varchar(200) character set latin1 default NULL, `org_sin` text character set latin1, `org_title_sin` text character set latin1, `address_sin` varchar(200) character set latin1 default NULL, `name_tam` varchar(200) character set latin1 default NULL, `role_tam` varchar(50) character set latin1 default NULL, `sector_tam` varchar(50) character set latin1 default NULL, `org_tam` text character set latin1, `org_title_tam` text character set latin1, `address_tam` varchar(200) character set latin1 default NULL, `detail_eng` longtext character set latin1, `detail_sin` longtext character set latin1, `detail_tam` longtext character set latin1, PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=20 ; -- -- Dumping data for table `u01_01memb_details` -- INSERT INTO `u01_01memb_details` (`rowno`, `u_id`, `name_eng`, `role_eng`, `sector_eng`, `member_sin`, `org_eng`, `org_title_eng`, `address_eng`, `tel`, `fax`, `email`, `web`, `img_path`, `name_sin`, `role_sin`, `sector_sin`, `org_sin`, `org_title_sin`, `address_sin`, `name_tam`, `role_tam`, `sector_tam`, `org_tam`, `org_title_tam`, `address_tam`, `detail_eng`, `detail_sin`, `detail_tam`) VALUES (2, '', 'Dr. Ajith Mendis', 'Member', 'Public', '2007-06-01', 'Ministry of Healthcare and Nutrition', 'Director General', 'Ministry of Healthcare and Nutrition No. 385, Deans Road, Colombo 10, Sri Lanka', '0112694860', '', 'dghs@health.gov.lk', 'www.health.gov.lk', '220091020082301.jpg', 'දොස්තර අජිත් මෙන්ඩිස්', 'සාමාජික', NULL, 'සෞඛ්‍ය හා පෝෂණ අමාත්‍යංශය', 'සෞඛ්‍ය සේවා අධ්‍යක්ෂ ජනරාල් ', 'සෞඛ්‍ය හා පෝෂණ අමාත්‍යංශය නො. 385, ඩීන', 'டெக்டர்.அஜித் மெண்டிஸ்', 'உறுப்பி&', NULL, 'சுகாதார மற்றும் போஷாக்கு அமைச்சு ', 'பணிப்பாளர் நாயகம்', 'சுகாதார மற்றும் போஷாக்கு அமைச்&', ' ', '', ''), (3, '', 'Dr. P. G. Mahipala', 'Member', 'Public', '2007-05-01', 'Ministry of Healthcare and Nutrition', 'Deputy Director General (Public Health Service)', 'Ministry of Healthcare and Nutrition No. 385, Deans Road, Colombo 10, Sri Lanka', '0112693622', '0112690035', 'dtcs@health.gov.lk', 'www.health.gov.lk', '320091026104239.bmp', 'දොස්තර පී.ජී. මහීපාල', 'සාමාජික', NULL, 'සෞඛ්‍ය හා පෝෂණ අමාත්‍යංශය ', 'නි‍යෝජ්‍ය අධ්‍යක්ෂ ජනරාල් සෞඛ්‍ය සේවා (මහජන සෞඛ්‍ය සේවා) ', 'සෞඛ්‍ය හා පෝෂණ අමාත්‍යංශය නො. 385, ඩීන', 'டெக்டர்.பி.ஜி.மஹிபால', 'உறுப்பி&', NULL, 'சுகாதார மற்றும் போஷாக்கு அமைச்சு', 'பிரதிப் பணிப்பாளர் நாயகம் சுகாதார சேவைகள் (பொதுசுகாதாரம்)', 'சுகாதார மற்றும் போஷாக்குஅமைச்ச&#', ' ', '', ''), (4, '', 'Dr A.K.S.B. Alwis', 'Member', 'Public', '2009-02-25', 'National Program for Tuberculosis Control &Chest Disease (NPTCCD)', 'Director/NPTCCD', 'NPTCCD,3rd Floor, Public Health Complex, 555/5, Elvitigala Mawatha, Colombo 05, Sri Lanka', '0112368301', '0112368275', 'dnptccd@gmail.com', '', '420091026104601.bmp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ' ', NULL, NULL), (5, '', 'Dr. R.R. Abeyasinghe', 'Focal Point', 'Public', '2006-09-01', 'GFATM Project', 'Director', 'GFATM Project 3rd Floor, Public Health Complex, 555/5, Elvitigala Mawatha, Colombo 05, Sri Lanka', '0112581918', '0112368826', 'gfatmprojoff@sltnet.lk', 'www.ccmsl.lk', '20090926052903.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ' ', NULL, NULL), (6, '', 'Dr. Nimal Edirisinghe', 'Member', 'Public', '2006-07-01', 'Sexually Transmitted Disease & AIDS', 'Director/ STD AIDS', 'STD AIDS, P.O. Box 567, De Seram Place, Colombo 10, Sri Lanka', '0112667163', '0115336873', 'n.ediri@gmail.com', '', '620091026104954.bmp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ' ', NULL, NULL), (7, '', 'Dr. S. Deniyage', 'Member', 'Public', '2009-02-25', 'Anti Malaria Campaign', 'Director/ AMC', 'AMC, 3rd Floor, Public Health Complex, 555/5, Elvitigala Mawatha,Colombo 05, Sri Lanka', '0112588947', '0112368360', 'antimal@sltnet.lk', '', '720091026110117.bmp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ' ', NULL, NULL), (8, '', 'Shirley Tissera', 'Vice Chair', 'Faith Based', '2002-07-01', 'a) Congress of Religions b) Community Front for Prevention of AIDS-CFPA', 'a) Coordinator / Treasurer b) President', 'No.16, Christ the King Mawatha, Negombo Road Mahabage, Sri Lanka', '0115664957', '0112958180', 'shirleytissera@yahoo.com', '', '20090926053729.bmp', 'ෂර්ලි තිසේරා', 'උප සභාපත', NULL, 'අ) ආගමික සමුළුව ආ) ඒඩ්ස් නිවාරණ ප්‍', ') සමිබන්ධීකාරක/භාණ්ඩාගාරික ආ) සභා&#', '16, ක්‍රිස්තුරාජ මාවත, මීගමුව පාර, මහ&', NULL, NULL, NULL, NULL, NULL, NULL, ' A company director by profession with specialty being marketing management, was elected district governor of lions international in 1991, founder president of the community front for prevention of aids in 1992, was a member of the national aids committee for many years, was elected president of the South Asian Federation of NGOs for prevention of drug & substance abuse –SAFNGO in 1995, president of the International Federation of NGOs –IFNGO in 2003/2005. In 1996 was founder chairman of the movement for justice peace & national reconciliation which founded the congress of religions which is today the leading faith based organization in Sri Lanka with representation of all major religions, was instrumental in conducting some of the most unique aids awareness projects in Sri Lanka since 1992 which included aids in the workplace programmes, establishing counseling centers in the security forces and police in 1995. ', 'වෘත්තීයම වශයෙන් අලෙවිකරණ කළමණාකරනය පිළිබදව සමාගම් අධ්‍යක්ෂකවරයකුවන අතර 1991 වර්ෂ‍යේ ජාත්‍යන්තර සිංහ සමාජය දිස්ත්‍රික් අධිපති ලෙස කටයුතු කර ඇත. ඒඩිස් නිවාරණ ප්‍රජා පෙරමුණ සංවිධානයේ ආරම්භක සභාපති වන අතර වසර කිහිපයක් ජාතික ඒඩිස් කමිටු‍වේ සමාජිකත්වය දරණ ලදී. ඒඩ්ස් නිවාරණ ප්‍රජා පෙරමුණ යටතේ ශ්‍රී ලංකාවේ ඉතා වැදගත් සහ පිළිගත් ව්‍යාපෘති කිහිපයක් ක්‍රියාත්මක කරන ලද අතර සේවාස්ථානවල ඒඩ්ස් දැනුවත් කිරීම සහ නිවාරණ ව්‍යාපෘති යටතේ ත්‍රිවිධ හමුදා සහ පොලිස් සේවාස්ථාන තුල උපදේශන සේවා මධ්‍යස්ථාන පිහිටුවන්ලදී. ෂර්ලි තිසේරා මහතා 1995 වසරේදී මත්ද්‍රව්‍ය විරෝධී සහ අමද්‍යප දකුණු ආසියාතික රාජ්‍ය නොවන සංවිධාන ‍ඒකාබද්ධ සම්මේලනයේ සභාපතීත්වයද, 2003 සහ 2005 වර්ෂයන්හීදී ජාත්‍යන්තර මත්ද්‍රව්‍ය විරෝධී සහ අමද්‍යප රාජ්‍ය නොවන සංවිධාන එකමුතුවේ සභාපතීත්වයද හොබවන ලදී. 1996 වසරේදී සාමය, යුක්තිය සහ සමගි කිරීමේ ව්‍යාපාරයේ ආරම්ක සභාපති වශයෙන්ද කටයුතු කල අතර මෙම ව්‍යාපාරය යටතේ බිහිවු ආගමික සමුළුව සියලු ප්‍රධාන ආගම් එක්බාද්ධව වර්ථමානයේ පවතින ශ්‍රී ලංකාවේ ප්‍රථම සහ ප්‍රමුඛතම සංවිධානය වේ. ', NULL), (9, '', 'Prof. Carlo Fonseka', 'Member', 'Education', '2006-04-01', 'University Grants Commission', 'Member', 'University Grants Commission No 88/14, Thotupola Road, Ethul Kotte, Sri Lanka', '0112867767', '', 'nata@health.gov.lk', '', '20090926054240.bmp', 'මහාචාර්ය කාලෝ ෆොන්සේකා', 'සාමාජික', NULL, 'විශ්ව විද්‍යාල ප්‍රතිපාදන කොමිස&', 'සාමාජික', 'විශ්ව විද්‍යාල ප්‍රතිපාදන කොමිස&', 'பேராசிரியர் கார&', 'உறுப்பி&', 'Public', 'பல்கலைக்கழக மான&', 'உறுப்பி&', 'பல்கலைக்கழகமானியஆணைக்குழு இல 88/14,', ' ', '', ' '), (10, '', 'Dr. Chris Nonis', 'Member', 'Private', '2005-08-01', 'Mackwoods', 'Member, Ceylon Chamber of Commerce/Chairman, Mackw', 'Mackwoods, No 10, Gnanartha Pradeepa Mawatha, Colombo 08, Sri Lanka', '0112669832', '0112691445', 'nonis@mackwoods.com', '', '20090926054430.bmp', 'දොස්තර ක්‍රිස් නෝනිස්', 'සාමාජික', NULL, 'මැක්වුඩ්ස් ', 'සාමාජික/ශ්‍රී ලංකා වානිජ්‍ය මණ්ඩලය, සභාපති/මැක්වුඩ්ස් ', 'මැක්වුඩ්ස් නො. 10, ඥාණාරතන ප්‍රදීප ම', NULL, NULL, NULL, NULL, NULL, NULL, ' ', '', NULL), (11, '', 'Mr. Gamini Wanasekara', 'Member', 'NGO', '2007-05-01', 'Family Planning Association', 'Executive Director', 'Family Planning Association of Sri Lanka 37/27, Bullers Road,Colombo 07, Sri Lanka', '0112584157', '0115367308', 'ed@fpasrilanka.org', 'www.fpasrilanka.org', '20090926054758.bmp', 'ගාමිණි වනසේකර', 'සාමාජික', NULL, 'පවුල් සැලසුම් සංවිධානය', 'විධායක අධ්‍යක්ෂ ', 'ශ්‍රී ලංකා පවුල් සැලසුම් සංවිධාන', 'திரு.காமினிவனசேகர', 'உறுப்பி&', NULL, 'குடும்ப திட்டமிடல் சங்கம்', 'நிறைவேற்றுப் பணிப்பாளர் ', 'இலங்கை குடும்ப திட்டமிடல் சங்கம&', 'Gamini Wanasekara has been working at Family Planning Association of Sri Lanka for the past 8 years. He became a member of CCM when he assumed duties as the Executive Director in 2007. He is a Lawyer by profession and has a MSc in Project Management from the Curtin University, Perth. ', 'ගාමිණි වනසේකර මහතා වසර 8ක් පුරා ශ්‍රී ලංකා පවුල් සැලසුම් සංවිධානයේ සේවය කරන අතර 2007 වසරේදී විධායක අධ්‍යක්ෂධූරයට පත්වීමත් සමග දේශීය සම්බන්ධීකරණ කමිටු සමාජිකත්වය සදහා පත්විය. මොහු වෘත්තීමය වශයෙන් නීතිඥයකු වන අතර ව්‍යාපෘති කළමණාකරණය පිළිබද පර්ත්, කර්ටන් විශ්වවිද්‍යාලයේ විද්‍යාපති උපාධිලාභියෙකි. ', 'காமினிவனசேகர கடந்த எட்டு வருடங்களாக இலங்கை குடும்பதிட்டமிடல் சங்கத்தில் பணியாற்றிவருகின்றார். 2007ல் அவர் நிறைவேற்றுப்பணிப்பாளராகப் பொறுப்பேற்றது முதல் CCMSL உறுப்பினரானார். தொழிற்சார் ரீதியாக அவர் ஒரு சட்டத்தரணி. திட்டமுகாமைத்துவத்தில் பேர்த் நகர கேர்டின் பல்கலைக்கழகத்தில் Msc பட்டம் பெற்றவர். '), (12, '', 'Dr. Lalith. P. Chandradasa', 'Member', 'NGO', '2005-06-01', 'Sarvodaya', 'Director /GFATM Sarvodaya', 'Nagarodaya Centre, No. 155A, Dr. Danister De Silva Mawatha, Colombo 08, Sri Lanka', '0112667365', '0112667359', 'gfatmsar@gmail.com', '', '20090926054939.bmp', 'දොස්තර ලලිත් පී. චන්ද්‍රදාස', 'සාමාජික', NULL, 'ලංකා ජාතික සර්වෝදය ශ්‍රමදාන සංගමය ', 'අධ්‍යක්ෂක/සර්වෝදය GFATM ', 'නගරෝදය මධ්‍යස්ථානය, නො. 155A, දොස්තර ඩ&#', 'டொக்டர்.லலித்.பி.சந்திரதாஸ', 'உறுப்பி&', NULL, 'சர்வோதயா', 'பணிப்பாளர்/GFATM சர்வோதய', 'நகரோதய நிலையம் இல.155A,டெனிஸ்டர் டி &#', ' ', '', ''), (13, '', 'Ms. Swarna Kodagoda', 'Member', 'NGO', '2003-11-01', 'Alliance Lanka', 'Executive Director', 'Alliance Lanka, 60/3, Pangiriwatte Lane, Gangodawila, Nugegoda, Sri Lanka', '0115679582', '0112833908', 'swarna.kodagoda@gmail.com', '', '1320091026110850.bmp', 'ස්වර්ණා ‍කෝදාගොඩ', 'සාමාජික', NULL, 'එලයන්ස් ලංකා', 'විධායක අධක්ෂිකා', 'එලයන්ස් ලංකා 60/3, පැඟරිවත්ත වීදිය, ග"', 'திருமதி.சுவர்ணா கோதாகொட', 'உறுப்பி&', NULL, 'அலயன்ஸ் லங்கா ', 'நிறைவேற்றுப் பணிப்பாளர்', 'அலயன்ஸ் லங்கா 60/3,பங்கிரிவத்த லேன', ' ', '', ''), (14, '', 'M.I.M.Iqbal', 'Member', 'NGO', '2006-02-01', 'Sewalanka Foundation', 'Consultant/Executive Committee Member', 'Sewalanka Foudation,432 A, Colombo Road,Boralesgamuwa', '0112545362', '0112545166', 'iqbal@sewalanka.org', 'www.sewalanka.org', '20090926055438.bmp', 'එම්. අයි. එම්. ඉක්බාල්', 'සාමාජික', NULL, 'සේවා ලංකා පදනම ', 'උපදේශක/විධායක කමිටු ', 'සේවා ලංකා පදනම, 432ඒ, කොළඔ පාර, බොරලැස#', 'எம்.ஐ.எம்.இக்பால்', 'உறுப்பி&', NULL, 'சேவா லங்கா மன்றம்', 'ஆலோசகர்/நிறைவேற்றுக்குழு உறுப்பினர்', 'சேவா லங்கா மன்றம் 432 A,கொழும்பு றோட&', ' ', '', ''), (15, '', 'Mr. D A D N C Wimalaratne', 'Member', 'NGO', '2006-11-01', 'Rural and Community Development Association', 'Chairman', 'Rural and Community Development Association,21, Piriwena Road, Narampitiya, Panadura, Sri Lanka', '0114998800', '', 'nimaindu@hotmail.com', '', '1520091026111227.bmp', 'ඩී.ඒ.එන්.සී. විමලරත්න', 'සාමාජික', NULL, 'ග්‍රාමීය සහ ප්‍රජා සංවර්ධන සහයෝගීතාව', 'සභාපති', 'ග්‍රාමීය සහ ප්‍රජා සංවර්ධන සහයෝග', 'திரு.டி.ஏ.டி.என்.ஸி.விமலரட்ண', 'உறுப்பி&', NULL, 'கிராமிய மற்றும் சமூக அபிவிருத்திச் சங்கம் ', 'தலைவர்', 'கிராமிய மற்றும் சமூக அபிவிருத்த&', ' ', '', ''), (16, '', 'W.A.M. Kusum Wasala', 'Member', 'NGO', '2006-11-01', 'Foundation of Social Welfare and Cultural Development North Westerns Province', 'Manager', 'Vason Foundation Kotakanda- Ruwanbodi Pirivana , Gettuwana road, Kurunegala.', '0372232769', '0372232769', 'wayambawason@yahoo.com', '', '20090926055801.bmp', 'ඩබ්ලිව්.ඒ.එම්. කුසුම් වාසල', 'සාමාජික', NULL, 'වයඔ පළාත් සමාජ සුභසාධන හා සංස්කෘතික පදනම ', 'කළමණාකාරිණි', 'Vason පදනම කොටකන්ද - රැවන්බෝධී පිරිවෙŞ', 'டபிள்யு.ஏ.எம்.குசும்வாசலா', 'உறுப்பி&', NULL, 'சமூக நலன் மற்றும் கலாசார அபிவிருத்தி மன்றம் வடமேல் மாகாணம்', 'முகாமையாளர்', 'வாசன் மன்றம் கொட்டகந்த – ருவன்போ', ' ', '', ''), (17, '', 'Mr. S.K.D. Dassanayake', 'Member', 'People living', '2006-07-01', 'Sri Lanka Red Cross Society', 'Chairman/ Sri Lanka Red Cross Society, Matale Bran', 'Sri Lanka Red Cross Society, Matale Branch No. 660/23, Main Street, Matale, Sri Lanka', '0662223528', '0662223528', 'matalebr@redcross.lk', '', '20090926060015.bmp', 'එස්. කේ. ඩී. දසනායක', 'සාමාජික', NULL, 'ශ්‍රී ලංකා රතුකු‍රැස සමාජය ', 'සභාපති - මාතලේ ශාඛාව ', 'ශ්‍රී ලංකා රතුකුරැස සමාජය - මාතලේ #', 'திரு.எஸ்.கே.டி.தஸநாயக்க', 'உறுப்பி&', NULL, 'இலங்கைச் செஞ்சிலுவைச் சங்கம் ', 'தலைவர்/ இலங்கைச் செஞ்சிலுவைச் சங்கம் மாத்தளை கிளை', 'இலங்கைச் செஞ்சிலுவைச் சங்கம் ம', ' ', '', ''), (18, '', 'Ms. Sherin Rodrigo', 'Member', 'People living', '2009-07-21', 'Lanka Plus', 'President', 'Lanka Plus No 05, Waishaakya Mawatha,Obeysekarapura Mawatha, Rajagiriya, Sri Lanka', '011490169272', '', 'slplusnet@gmail.com', '', '20090926060140.bmp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ' ', NULL, NULL), (19, '', 'Ms. W. Prasadika', 'Member', 'People living', '2006-01-01', 'Chest Clinic', 'Employee, Chest Clinic', 'Central Chest Clinic, Colombo 08, Sri Lanka', '0112685274', '', 'dfsfsf@sds.lk', '', '20090926060330.bmp', 'ඩබ්ලිව්. ප්‍රසාදිකා', 'සාමාජික', NULL, 'මධ්‍යම ලය රෝහල ', 'සේවක, මධ්‍යම ලය රෝහල ', 'මධ්‍යම ලය රෝහල කොළඔ 08, ශ්‍රී ලංකාව', 'திருமதி.டபிள்யு.பிரசாதிக்கா', 'உறுப்பி&', NULL, 'மார்பு சிகிச்சை நிலையம்', 'ஊழியர் மார்பு சிகிச்சை நிலையம்', 'மத்திய மார்பு சிகிச்சை பிரிவு கொ', ' ', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `u01_02sec_details` -- CREATE TABLE IF NOT EXISTS `u01_02sec_details` ( `rowno` int(10) NOT NULL auto_increment, `u_id` varchar(50) character set latin1 NOT NULL default '', `name_eng` varchar(100) character set latin1 NOT NULL default '', `role_eng` varchar(50) character set latin1 NOT NULL default '', `member_sin` date NOT NULL default '0000-00-00', `org_title_eng` varchar(50) character set latin1 NOT NULL default '', `address_eng` varchar(200) character set latin1 NOT NULL default '', `tel` varchar(20) character set latin1 NOT NULL default '', `fax` varchar(20) character set latin1 NOT NULL default '', `email` varchar(50) character set latin1 NOT NULL default '', `web` varchar(100) character set latin1 default NULL, `img_path` varchar(200) character set latin1 NOT NULL default '', `name_sin` varchar(100) character set latin1 default NULL, `role_sin` varchar(50) character set latin1 default NULL, `org_title_sin` varchar(50) character set latin1 default NULL, `address_sin` varchar(200) character set latin1 default NULL, `name_tam` varchar(100) character set latin1 default NULL, `role_tam` varchar(50) character set latin1 default NULL, `org_title_tam` varchar(50) character set latin1 default NULL, `address_tam` varchar(200) character set latin1 default NULL, `detail_eng` text, `detail_sin` text, `detail_tam` text, `mobile` varchar(11) NOT NULL default '', PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ; -- -- Dumping data for table `u01_02sec_details` -- INSERT INTO `u01_02sec_details` (`rowno`, `u_id`, `name_eng`, `role_eng`, `member_sin`, `org_title_eng`, `address_eng`, `tel`, `fax`, `email`, `web`, `img_path`, `name_sin`, `role_sin`, `org_title_sin`, `address_sin`, `name_tam`, `role_tam`, `org_title_tam`, `address_tam`, `detail_eng`, `detail_sin`, `detail_tam`, `mobile`) VALUES (15, '', 'Dr. R.R. Abeyasinghe', 'Focal Point/ CCMSL', '2007-10-31', 'Director/GFATM Projects in Sri Lanka', '3rd Floor,Public Health Complex,555/5, Elvitigala Mawatha,Colombo 05.', '094112581918', '', 'ccmsrilanka@gmail.com', 'www.ccmsl.lk', '20091026100447.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '09477794858'), (16, '', 'Chanaka Walawwatte', 'Programme Officer/CCMSL', '2008-10-31', 'Programme Officer/CCMSL', '1st Floor, Public Health Complex, 555/5, Elvitigala Mawatha,Colombo 05.', '094112369066', '', 'chanaka.walawwatte@gmail.com', 'www.ccmsl.lk', '20091026101809.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '09471445400'), (17, '', 'fsdfdfd', 'fdfdf', '2009-10-06', '', 'bvbvbv', '1233333333', '12345677777', 'ewew@n.vo', 'fdfdfd', '20091026103106.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fdfdfdfd', NULL, NULL, 'bvbvb'); -- -------------------------------------------------------- -- -- Table structure for table `u01_02users_in_groups` -- CREATE TABLE IF NOT EXISTS `u01_02users_in_groups` ( `rowno` int(10) unsigned NOT NULL auto_increment, `user_group_id` varchar(10) NOT NULL default '', `user_id` varchar(50) NOT NULL default '', PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `u01_02users_in_groups` -- INSERT INTO `u01_02users_in_groups` (`rowno`, `user_group_id`, `user_id`) VALUES (1, 'ADMIN', 'admin'); -- -------------------------------------------------------- -- -- Table structure for table `u02_00usergroups` -- CREATE TABLE IF NOT EXISTS `u02_00usergroups` ( `rowno` int(10) unsigned NOT NULL auto_increment, `user_group_id` varchar(10) NOT NULL default '', `group_desc` varchar(100) NOT NULL default '', PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `u02_00usergroups` -- INSERT INTO `u02_00usergroups` (`rowno`, `user_group_id`, `group_desc`) VALUES (1, 'ADMIN', 'Administrator'), (2, 'MEMBR', 'Member'), (3, 'SECR', 'Secratariat'); -- -------------------------------------------------------- -- -- Table structure for table `u03_00menu_options` -- CREATE TABLE IF NOT EXISTS `u03_00menu_options` ( `rowno` int(10) unsigned NOT NULL auto_increment, `option_id` varchar(10) NOT NULL default '', `option_desc` varchar(100) NOT NULL default '', `page_code` varchar(50) NOT NULL default '', `parameter1` varchar(50) default NULL, `parameter2` varchar(50) default NULL, `priority` int(11) NOT NULL default '0', PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `u03_00menu_options` -- INSERT INTO `u03_00menu_options` (`rowno`, `option_id`, `option_desc`, `page_code`, `parameter1`, `parameter2`, `priority`) VALUES (1, 'NWS', 'News and Events', 'newsnevent_list', '', '', 1), (2, 'NTCS', 'Notice Board', 'noticeboard_list', '', '', 2), (3, 'MTGMIN', 'Meeting Minutes', 'minutes_list', '', '', 3), (4, 'APPS', 'Application Form', 'application_list', '', '', 4), (5, 'MEMB', 'Members', 'members_list', '', '', 5), (6, 'SEC', 'Secretariats', 'secretariat_list', '', '', 6), (7, 'VWMIN', 'View Meeting Minutes', 'minutes_list', '', '', 7), (8, 'VWNTC', 'View Notice Board', 'noticeboard_list', '', '', 8), (9, 'GALEMA', 'Image Gallery', 'gallery_list', NULL, NULL, 9); -- -------------------------------------------------------- -- -- Table structure for table `u03_01menu_option_access` -- CREATE TABLE IF NOT EXISTS `u03_01menu_option_access` ( `rowno` int(10) NOT NULL auto_increment, `user_group_id` varchar(50) NOT NULL default '', `option_id` varchar(10) NOT NULL default '', PRIMARY KEY (`rowno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `u03_01menu_option_access` -- INSERT INTO `u03_01menu_option_access` (`rowno`, `user_group_id`, `option_id`) VALUES (1, 'MEMBR', 'VWMIN'), (2, 'ADMIN', 'NWS'), (3, 'ADMIN', 'NTCS'), (4, 'ADMIN', 'MTGMIN'), (5, 'ADMIN', 'APPS'), (6, 'ADMIN', 'MEMB'), (7, 'ADMIN', 'SEC'), (8, 'MEMBR', 'VWNTC'), (9, 'ADMIN', 'GALEMA');