--
-- Host: localhost    Database: oxford2027
-- ------------------------------------------------------


--
-- Table structure for table `school_info`
--

CREATE TABLE `school_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(33) NOT NULL,
  `name` varchar(66) NOT NULL,
  `short_name` varchar(66) NOT NULL,
  `email` varchar(33) NOT NULL,
  `mobile` varchar(22) NOT NULL,
  `description` longtext NOT NULL,
  `address` longtext NOT NULL,
  `print_address` longtext NOT NULL,
  `footer` varchar(200) NOT NULL,
  `musername` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `senderid` varchar(30) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `start_date` varchar(20) NOT NULL,
  `end_date` varchar(20) NOT NULL,
  `f_start_date` varchar(20) NOT NULL,
  `f_end_date` varchar(20) NOT NULL,
  `a_start_date` varchar(20) NOT NULL,
  `a_end_date` varchar(20) NOT NULL,
  `voice_username` varchar(33) NOT NULL,
  `voice_password` varchar(33) NOT NULL,
  `mimage` longtext NOT NULL,
  `nimage` longtext NOT NULL,
  `oimage` longtext NOT NULL,
  `m_count` int(11) NOT NULL,
  `n_count` int(11) NOT NULL,
  `o_count` int(11) NOT NULL,
  `printtypegroup` varchar(11) NOT NULL,
  `printtype` varchar(11) NOT NULL,
  `fee_text` longtext NOT NULL,
  `pref_cboxdue` varchar(11) NOT NULL,
  `finalreportprint` varchar(11) NOT NULL,
  `timestamp` varchar(22) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `school_info`
--

INSERT INTO `school_info` VALUES (3,'vamsi','Oxford High School','OHS','oxfordhighschoolh@yahoo.com','7702860987','Oxford','Hyd','Hyd','','oxford','shekhar1985','OXFORD','co-education','20-5-2022','20-5-2023','20-5-2022','20-5-2022','20-5-2022','20-5-2022','oxford','oxford','','','',0,0,0,'1','1','','1','1','1527492220');


