-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 03, 2010 at 08:58 AM
-- Server version: 5.1.36
-- PHP Version: 5.3.0
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: `sruthi_lyrics`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`admin_id` int(10) NOT NULL AUTO_INCREMENT,
`admin_name` varchar(120) DEFAULT NULL,
`admin_password` varchar(25) NOT NULL,
`status` enum('H','L') NOT NULL DEFAULT 'L',
`last_login_date` varchar(200) NOT NULL,
`last_login_time` varchar(200) NOT NULL,
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`admin_id`, `admin_name`, `admin_password`, `status`, `last_login_date`, `last_login_time`) VALUES
(1, 'admin', 'admin', 'L', 'Tue, August 3, 2010', '4:45 AM');
-- --------------------------------------------------------
--
-- Table structure for table `master`
--
CREATE TABLE IF NOT EXISTS `master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name_english` varchar(200) NOT NULL,
`name_tamil` varchar(200) NOT NULL,
`status` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `master`
--
INSERT INTO `master` (`id`, `name_english`, `name_tamil`, `status`) VALUES
(1, 'SPB', 'SPB', '0'),
(2, 'Chitra', 'Chitra', '1'),
(3, 'Yesudas', 'Yesudas', '0'),
(4, 'unni', 'unni', '0');
-- --------------------------------------------------------
--
-- Table structure for table `site_setting`
--
CREATE TABLE IF NOT EXISTS `site_setting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_title` varchar(250) DEFAULT NULL,
`admin_email` varchar(100) DEFAULT NULL,
`status` enum('L','H') DEFAULT 'L',
`offline_note` text,
`admin_list_per_page` int(11) DEFAULT '0',
`user_list_per_page` int(11) DEFAULT '0',
`general_ads_limit` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `site_setting`
--
INSERT INTO `site_setting` (`id`, `site_title`, `admin_email`, `status`, `offline_note`, `admin_list_per_page`, `user_list_per_page`, `general_ads_limit`) VALUES
(1, 'Lakshman sruthi', 'info@lakshmansruthi.com', 'L', 'Under Construction...', 100, 100, 0);
-- --------------------------------------------------------
--
-- Table structure for table `song_list`
--
CREATE TABLE IF NOT EXISTS `song_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`song_title` varchar(255) NOT NULL,
`song_category` varchar(200) NOT NULL,
`movie_name` varchar(200) NOT NULL,
`male_singer` varchar(200) NOT NULL,
`female_singer` varchar(200) NOT NULL,
`actor` varchar(200) NOT NULL,
`actress` varchar(200) NOT NULL,
`music_director` varchar(200) NOT NULL,
`production` varchar(200) NOT NULL,
`release_year` varchar(200) NOT NULL,
`ragam` varchar(200) NOT NULL,
`lyricist` varchar(200) NOT NULL,
`movie_director` varchar(200) NOT NULL,
`scale` varchar(200) NOT NULL,
`rhythm` varchar(200) NOT NULL,
`alphabetic` varchar(200) NOT NULL,
`song_situation` varchar(200) NOT NULL,
`chorus` varchar(200) NOT NULL,
`lyrics_english` text NOT NULL,
`lyrics_tamil` text NOT NULL,
`status` enum('L','S') NOT NULL DEFAULT 'L',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `song_list`
--
INSERT INTO `song_list` (`id`, `song_title`, `song_category`, `movie_name`, `male_singer`, `female_singer`, `actor`, `actress`, `music_director`, `production`, `release_year`, `ragam`, `lyricist`, `movie_director`, `scale`, `rhythm`, `alphabetic`, `song_situation`, `chorus`, `lyrics_english`, `lyrics_tamil`, `status`) VALUES
(1, 'idhu oru pon malai pozhudhu', 'nature', 'nizhalgal', 'spb', '', 'nizhalgal ravi', '', 'ilaiyaraja', '', '', '', 'vairamuthu', 'bharathi raja', '', '', '', 'nature', '', 'MUSIC PALLAVI
Hey... Oh... Hmm... Lalalaa...(Music)
Pon Maalaip Pozhudhu
Idhu Oru Pon Maalaip Pozhudhu
Vaana Magal Naanughiraal
Vaeru Udai Poonughiraal
Idhu Oru Pon Maalaip Pozhudhu
Hmmm...Hey...Haa...Oh...hm...mm
MUSIC CHARANAM 1
Aayiram Nirangal Jaalamidum
Raathiri Vaasalil Kolamidum
(Music)
Aayiram Nirangal Jaalamidum
Raatthiri Vaasalil Kolamidum
Vaanam Iravukku Paalamidum
Paadum Paravaigal Thaalamidum
Poo Marangal Saamarangal Veesaadho
Idhu Oru Pon Maalaip Pozhudhu
Vaana Magal Naanughiraal
Vaeru Udai Poonughiraal
Idhu Oru Pon Maalaip Pozhudhu
MUSIC CHARANAM 2
Vaanam Enakkoru Bodhi Maram
Naalum Enakkadhu Saedhi Tharum
(Music)
Vaanam Enakkoru Bodhi Maram
Naalum Enakkadhu Saedhi Tharum
Oru Naal Ulagam Needhi Perum
Thiru Naal Nighazhum Thedhi Varum
Kaelvigalaal Vaelvigalai Naan Seithaen
Idhu Oru Pon Maalaip Pozhudhu
Vaana Magal Naanughiraal
Vaeru Udai Poonughiraal
Idhu Oru Pon Maalaip Pozhudhu
Hey...Oh...Haa...Lalalaa
Hmmm...Hey...Haa...Oh...hm...mm..
', '$lyrics_tamil
', 'L'),
(2, 'Ayarpadi maligaiyil', 'devotional', 'gfhgf', 'spb', 'dsfds', 'gfh', 'gfhgfh', 'm.s.viswanathan', 'hmv', 'dfgfdg', 'dsfds', 'kannadasan', 'dfgdf', 'gdfgdf', 'dfg', 'dfgdfg', 'hgfh', 'gfhg', 'AAYARPAADI MAALIGAIYIL
MUSIC PALLAVI
Aayarpaadi maaligayil thaai madiyil kandrinaip pol
Maayak kannan thoongugindraan thaalaelo (music)
Aayarpaadi maaligayil thaai madiyil kandrinaip pol
Maayak kannan thoongugindraan thaalaelo
Avan vaai niraiya mannai undu
Mandalatthaik kaatiya pin
Oivedutthu thoongugindraan aaraaro
Oivedutthu thoongugindraan aaraaro
Aayarpaadi maaligayil thaai madiyil kandrinaip pol
Maayak kannan thoongugindraan thaalaelo
MUSIC CHARANAM 1
Pinnalitta gopiyarin kannatthilae kannamittu
Mannavan pol leelai seithaan thaalaelo
Pinnalitta gopiyarin kannatthilae kannamittu
Mannavan pol leelai seithaan thaalaelo
Antha mandhirathil avar uranga
Mayakatthilae ivan uranga
Mandalamae uranguthammaa aaraaro
Mandalamae uranguthammaa aaraaro
Aayarpaadi maaligayil thaai madiyil kandrinaip pol
Maayak kannan thoongugindraan thaalaelo
MUSIC CHARANAM 2
Naagap padam meethil avan nartthanangal aadiyathil
Thaaham ellaam theerthuk kondaan thaalaelo
Naagap padam meethil avan nartthanangal aadiyathil
Thaaham ellaam theerthuk kondaan thaalaelo
Avan moha nilai kooda oru yoga nilaip pol irukkum
Yaar avanai thoonga vittaar aaraaro
Yaar avanai thoonga vittaar aaraaro
Aayarpaadi maaligayil thaai madiyil kandrinaip pol
Maayak kannan thoongugindraan thaalaelo
MUSIC CHARANAM 3
Kannan avan thoongivittaal
Kaasiniyae thoongividum
Annaiyarae thuyil ezhuppa vaareero
Kannan avan thoongivittaal
Kaasiniyae thoongividum
Annaiyarae thuyil ezhuppa vaareero
Avan punnagaiyai paarppatharkkum
Bodhai muttham kaetpatharkkum
Kanniyarae gopiyarae vaareero
Kanniyarae gopiyarae vaareero
Aayarpaadi maaligayil thaai madiyil kandrinaip pol
Maayak kannan thoongugindraan thaalaelo
Maayak kannan thoongugindraan thaalaelo
', 'dsfdsfdsf
', 'L');