-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 20, 2009 at 11:48 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `spshs`
--
CREATE DATABASE `spshs` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `spshs`;

-- --------------------------------------------------------

--
-- Table structure for table `spshs_admins`
--

CREATE TABLE IF NOT EXISTS `spshs_admins` (
  `admin_id` int(12) unsigned NOT NULL auto_increment,
  `school_id` int(12) NOT NULL,
  `staff_id` int(12) NOT NULL,
  `admin_enabled` char(1) NOT NULL default 'Y',
  `admin_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_admins`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_bgroups`
--

CREATE TABLE IF NOT EXISTS `spshs_bgroups` (
  `bgroup_id` int(12) unsigned NOT NULL auto_increment,
  `bgroup_name` varchar(20) NOT NULL,
  `bgroup_enabled` char(1) NOT NULL default 'Y',
  `bgroup_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`bgroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_bgroups`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_branches`
--

CREATE TABLE IF NOT EXISTS `spshs_branches` (
  `branch_id` int(12) unsigned NOT NULL auto_increment,
  `branch_name` varchar(300) NOT NULL,
  `country_id` int(12) NOT NULL,
  `state_id` int(12) NOT NULL,
  `city_id` int(12) NOT NULL,
  `village_id` int(12) NOT NULL,
  `head_office` char(1) NOT NULL default 'N',
  `branch_enabled` char(1) NOT NULL default 'Y',
  `branch_posted_tim` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`branch_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_branches`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_cities`
--

CREATE TABLE IF NOT EXISTS `spshs_cities` (
  `city_id` int(12) unsigned NOT NULL auto_increment,
  `city_name` varchar(300) NOT NULL,
  `country_id` int(12) NOT NULL,
  `state_id` int(12) NOT NULL,
  `city_enabled` char(1) NOT NULL default 'Y',
  `city_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`city_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_cities`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_class_exam_attend`
--

CREATE TABLE IF NOT EXISTS `spshs_class_exam_attend` (
  `cea_id` int(12) unsigned NOT NULL auto_increment,
  `csboy_id` int(12) NOT NULL,
  `cesoy_id` int(12) NOT NULL,
  `login_time` datetime NOT NULL,
  `logout_time` datetime NOT NULL,
  `cea_enabled` char(1) NOT NULL default 'Y',
  `cea_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`cea_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_class_exam_attend`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_class_exam_schedules`
--

CREATE TABLE IF NOT EXISTS `spshs_class_exam_schedules` (
  `cesoy_id` int(12) unsigned NOT NULL auto_increment,
  `class_id` int(12) NOT NULL,
  `subject_id` int(12) NOT NULL,
  `year_id` int(12) NOT NULL,
  `exam_type_id` int(12) NOT NULL,
  `cesoy_date` datetime NOT NULL,
  `cesoy_staff` int(12) NOT NULL,
  `cesoy_enabled` char(1) NOT NULL default 'Y',
  `cesoy_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`cesoy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_class_exam_schedules`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_class_stude_exam_marks`
--

CREATE TABLE IF NOT EXISTS `spshs_class_stude_exam_marks` (
  `csem_id` int(12) unsigned NOT NULL auto_increment,
  `cesoy_id` int(12) NOT NULL,
  `csboy_id` int(12) NOT NULL,
  `csem_marks` int(12) NOT NULL,
  `csem_enabled` char(1) NOT NULL default 'Y',
  `csem_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`csem_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_class_stude_exam_marks`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_class_stude_year`
--

CREATE TABLE IF NOT EXISTS `spshs_class_stude_year` (
  `csboy_id` int(12) unsigned NOT NULL auto_increment,
  `class_id` int(12) NOT NULL,
  `section_id` int(12) NOT NULL,
  `student_id` int(12) NOT NULL,
  `year_id` int(12) NOT NULL,
  `staff_id` int(12) NOT NULL,
  `csboy_enabled` char(1) NOT NULL default 'Y',
  `csboy_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`csboy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_class_stude_year`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_class_teach_year`
--

CREATE TABLE IF NOT EXISTS `spshs_class_teach_year` (
  `ctboy_id` int(12) unsigned NOT NULL auto_increment,
  `class_id` int(12) NOT NULL,
  `year_id` int(12) NOT NULL,
  `subject_id` int(12) NOT NULL,
  `staff_id` int(12) NOT NULL,
  `class_time_start` varchar(30) NOT NULL,
  `class_time_end` varchar(30) NOT NULL,
  `teach_perd_start` date NOT NULL,
  `teach_perd_end` date NOT NULL,
  `ctboy_enabled` char(1) NOT NULL default 'Y',
  `ctboy_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ctboy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_class_teach_year`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_classes`
--

CREATE TABLE IF NOT EXISTS `spshs_classes` (
  `class_id` int(12) unsigned NOT NULL auto_increment,
  `class_name` varchar(300) NOT NULL,
  `class_enabled` char(1) NOT NULL default 'Y',
  `school_id` int(12) NOT NULL,
  `class_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`class_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_classes`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_countries`
--

CREATE TABLE IF NOT EXISTS `spshs_countries` (
  `country_id` int(12) unsigned NOT NULL auto_increment,
  `country_name` varchar(300) NOT NULL,
  `country_enabled` char(1) NOT NULL default 'Y',
  `country_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`country_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_countries`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_departments`
--

CREATE TABLE IF NOT EXISTS `spshs_departments` (
  `department_id` int(12) unsigned NOT NULL auto_increment,
  `department_name` varchar(300) NOT NULL,
  `department_enabled` char(1) NOT NULL default 'Y',
  `department_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`department_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_departments`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_designations`
--

CREATE TABLE IF NOT EXISTS `spshs_designations` (
  `desig_id` int(12) unsigned NOT NULL auto_increment,
  `desig_name` varchar(300) NOT NULL,
  `desig_enabled` char(1) NOT NULL default 'Y',
  `department_id` int(12) NOT NULL,
  `desig_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`desig_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_designations`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_details`
--

CREATE TABLE IF NOT EXISTS `spshs_details` (
  `school_id` int(12) unsigned NOT NULL auto_increment,
  `school_fullname` varchar(300) NOT NULL,
  `school_nickname` varchar(300) NOT NULL,
  `branch_id` int(12) NOT NULL,
  `school_estab_date` date NOT NULL,
  `school_address` text NOT NULL,
  `school_mailid` varchar(300) NOT NULL,
  `school_url` varchar(300) NOT NULL,
  `school_phone` text NOT NULL,
  `school_contact_person` varchar(300) NOT NULL,
  `school_logo` varchar(300) NOT NULL,
  `school_slogan` text NOT NULL,
  `school_enabled` char(1) NOT NULL default 'Y',
  `school_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`school_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_details`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_event_photos`
--

CREATE TABLE IF NOT EXISTS `spshs_event_photos` (
  `event_photo_id` int(12) unsigned NOT NULL auto_increment,
  `event_photo_title` varchar(300) NOT NULL,
  `event_photo_description` longtext NOT NULL,
  `event_id` int(12) NOT NULL,
  `event_photo_file` varchar(300) NOT NULL,
  `event_photo_enabled` char(1) NOT NULL default 'Y',
  `event_photo_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`event_photo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_event_photos`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_events`
--

CREATE TABLE IF NOT EXISTS `spshs_events` (
  `event_id` int(12) unsigned NOT NULL auto_increment,
  `event_name` varchar(300) NOT NULL,
  `event_date` date NOT NULL,
  `school_id` int(12) NOT NULL,
  `class_id` int(12) NOT NULL,
  `event_enabled` char(1) NOT NULL default 'Y',
  `event_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_events`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_mails_parenttosch`
--

CREATE TABLE IF NOT EXISTS `spshs_mails_parenttosch` (
  `pts_id` int(12) unsigned NOT NULL auto_increment,
  `parent_id` int(12) NOT NULL,
  `school_id` int(12) NOT NULL,
  `pts_enabled` char(1) NOT NULL default 'Y',
  `pts_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`pts_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_mails_parenttosch`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_mails_schtoparents`
--

CREATE TABLE IF NOT EXISTS `spshs_mails_schtoparents` (
  `stp_mail_id` int(12) unsigned NOT NULL auto_increment,
  `stp_mail_subject` text NOT NULL,
  `stp_mail_message` longtext NOT NULL,
  `stp_mail_file1` varchar(300) NOT NULL,
  `stp_mail_file2` varchar(300) NOT NULL,
  `stp_mail_file3` varchar(300) NOT NULL,
  `parent_id` int(12) NOT NULL,
  `stp_mail_enabled` char(1) NOT NULL default 'Y',
  `stp_mail_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`stp_mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_mails_schtoparents`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_parents`
--

CREATE TABLE IF NOT EXISTS `spshs_parents` (
  `parent_id` int(12) unsigned NOT NULL auto_increment,
  `parent_fname` varchar(300) NOT NULL,
  `parent_mname` varchar(300) NOT NULL,
  `parent_username` varchar(300) NOT NULL,
  `parent_password` varchar(300) NOT NULL,
  `parent_fath_desig` varchar(300) NOT NULL,
  `parent_moth_desig` varchar(300) NOT NULL,
  `parent_fath_qual` varchar(300) NOT NULL,
  `parent_moth_qual` varchar(300) NOT NULL,
  `parent_mailid` varchar(300) NOT NULL,
  `parent_phone` varchar(300) NOT NULL,
  `student_id` int(12) NOT NULL,
  `parent_enabled` char(1) NOT NULL default 'Y',
  `parent_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_parents`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_salaries`
--

CREATE TABLE IF NOT EXISTS `spshs_salaries` (
  `salary_id` int(12) unsigned NOT NULL auto_increment,
  `salary_value` int(12) NOT NULL,
  `salary_enabled` char(1) NOT NULL default 'Y',
  `salary_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`salary_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_salaries`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_sections`
--

CREATE TABLE IF NOT EXISTS `spshs_sections` (
  `section_id` int(12) unsigned NOT NULL auto_increment,
  `section_name` varchar(300) NOT NULL,
  `class_id` int(12) NOT NULL,
  `section_enabled` char(1) NOT NULL default 'Y',
  `section_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`section_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_sections`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_staff`
--

CREATE TABLE IF NOT EXISTS `spshs_staff` (
  `staff_id` int(12) unsigned NOT NULL auto_increment,
  `staff_usernam` varchar(300) NOT NULL,
  `staff_password` varchar(300) NOT NULL,
  `staff_fullname` varchar(300) NOT NULL,
  `staff_nickname` varchar(300) NOT NULL,
  `staff_email` varchar(300) NOT NULL,
  `staff_phone` varchar(300) NOT NULL,
  `staff_address` text NOT NULL,
  `staff_url` varchar(300) NOT NULL,
  `staff_exp` varchar(300) NOT NULL,
  `bgroup_id` int(12) NOT NULL,
  `staff_gender` char(1) NOT NULL default 'M',
  `staff_emer_person` varchar(300) NOT NULL,
  `staff_emer_per_rel` varchar(300) NOT NULL,
  `staff_emer_per_num` varchar(300) NOT NULL,
  `department_id` int(12) NOT NULL,
  `desig_id` int(12) NOT NULL,
  `salary_id` int(12) NOT NULL,
  `school_id` int(12) NOT NULL,
  `staff_qualification` varchar(300) NOT NULL,
  `staff_extra_qual` text NOT NULL,
  `staff_awards` text NOT NULL,
  `staff_enabled` char(1) NOT NULL default 'Y',
  `staff_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`staff_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_staff`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_states`
--

CREATE TABLE IF NOT EXISTS `spshs_states` (
  `state_id` int(12) unsigned NOT NULL auto_increment,
  `state_name` varchar(300) NOT NULL,
  `country_id` int(12) NOT NULL,
  `state_enabled` char(1) NOT NULL default 'Y',
  `state_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`state_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_states`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_stu_fee_deposits`
--

CREATE TABLE IF NOT EXISTS `spshs_stu_fee_deposits` (
  `deposit_id` int(12) unsigned NOT NULL auto_increment,
  `deposit_amount` int(12) NOT NULL,
  `student_id` int(12) NOT NULL,
  `deposit_date` date NOT NULL,
  `deposit_enabled` char(1) NOT NULL default 'Y',
  `deposit_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`deposit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_stu_fee_deposits`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_student_fees`
--

CREATE TABLE IF NOT EXISTS `spshs_student_fees` (
  `cwsf_id` int(12) unsigned NOT NULL auto_increment,
  `csboy_id` int(12) NOT NULL,
  `cwsf_fees` int(12) NOT NULL,
  `cwsf_enabled` char(1) NOT NULL default 'Y',
  `cwsf_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`cwsf_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_student_fees`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_students`
--

CREATE TABLE IF NOT EXISTS `spshs_students` (
  `student_id` int(12) unsigned NOT NULL auto_increment,
  `student_fullname` varchar(300) NOT NULL,
  `student_firstname` varchar(300) NOT NULL,
  `student_lastname` varchar(300) NOT NULL,
  `student_dob` date NOT NULL,
  `student_gender` char(1) NOT NULL default 'M',
  `student_address` text NOT NULL,
  `school_id` int(12) NOT NULL,
  `student_enabled` char(1) NOT NULL default 'Y',
  `student_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`student_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_students`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_students_attendance`
--

CREATE TABLE IF NOT EXISTS `spshs_students_attendance` (
  `atten_id` int(12) unsigned NOT NULL auto_increment,
  `csboy_id` int(12) NOT NULL,
  `atten_date` date NOT NULL,
  `atten_morning` char(1) NOT NULL default 'Y',
  `atten_afternoon` char(1) NOT NULL default 'Y',
  `leave_id` int(12) NOT NULL,
  `atten_enabled` char(1) NOT NULL default 'Y',
  `atten_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`atten_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_students_attendance`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_subjects`
--

CREATE TABLE IF NOT EXISTS `spshs_subjects` (
  `subject_id` int(12) unsigned NOT NULL auto_increment,
  `subject_name` varchar(300) NOT NULL,
  `class_id` int(12) NOT NULL,
  `subject_enabled` char(1) NOT NULL default 'Y',
  `subject_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`subject_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_subjects`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_themes`
--

CREATE TABLE IF NOT EXISTS `spshs_themes` (
  `theme_id` int(12) unsigned NOT NULL auto_increment,
  `theme_name` varchar(300) NOT NULL,
  `theme_folder` varchar(300) NOT NULL,
  `theme_default` char(1) NOT NULL default 'Y',
  `theme_enabled` char(1) NOT NULL default 'Y',
  `theme_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`theme_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_themes`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_villages`
--

CREATE TABLE IF NOT EXISTS `spshs_villages` (
  `village_id` int(12) unsigned NOT NULL auto_increment,
  `village_name` varchar(300) NOT NULL,
  `country_id` int(12) NOT NULL,
  `state_id` int(12) NOT NULL,
  `city_id` int(12) NOT NULL,
  `village_enabled` char(1) NOT NULL default 'Y',
  `village_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`village_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_villages`
--


-- --------------------------------------------------------

--
-- Table structure for table `spshs_years`
--

CREATE TABLE IF NOT EXISTS `spshs_years` (
  `year_id` int(12) unsigned NOT NULL auto_increment,
  `year_value` int(4) NOT NULL,
  `year_enabled` char(1) NOT NULL default 'Y',
  `year_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`year_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `spshs_years`
--

