-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 30, 2010 at 12:51 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

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: `voting`
--
CREATE DATABASE `voting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `voting`;

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `leve` int(25) NOT NULL auto_increment,
  `password` varchar(25) NOT NULL,
  `username` varchar(25) NOT NULL,
  PRIMARY KEY  (`leve`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`leve`, `password`, `username`) VALUES
(1, 'admin', 'admin');

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

--
-- Table structure for table `candidate`
--

CREATE TABLE `candidate` (
  `id` int(11) NOT NULL,
  `position` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `picture` varchar(255) default NULL,
  `votecount` int(11) NOT NULL default '0',
  `sy` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `candidate`
--

INSERT INTO `candidate` (`id`, `position`, `name`, `platform`, `picture`, `votecount`, `sy`) VALUES
(1, 'President', 'RJ S. ANDRES', 'kdfjkdj', NULL, 0, '2010-2011'),
(2, 'President', 'JR S. ANDRES', 'dsfgfdsghgfh', NULL, 0, '2010-2011'),
(3, 'Secretary', 'Ehla', 'fgdh', NULL, 0, ''),
(4, 'Secretary', 'dfhdgfhgf', 'fgjhfjf', NULL, 0, ''),
(5, 'Secretary', 'dfjkdskfksdjk', 'kjkjkj', NULL, 0, 'j'),
(5, 'Secretary', 'dfjkdskfksdjk', 'kjkjkj', NULL, 0, 'j');

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

--
-- Table structure for table `position`
--

CREATE TABLE `position` (
  `position` varchar(50) NOT NULL,
  `IDNo` int(11) NOT NULL auto_increment,
  `Limit` int(11) NOT NULL,
  PRIMARY KEY  (`IDNo`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `position`
--

INSERT INTO `position` (`position`, `IDNo`, `Limit`) VALUES
('President', 1, 1),
('Vice President', 2, 1),
('Secretary', 3, 1),
('Bussines Manager', 4, 2),
('Sport Coordinator', 5, 2);

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `studid` varchar(15) NOT NULL,
  `name` varchar(255) NOT NULL,
  `course` varchar(100) NOT NULL,
  `year` varchar(10) NOT NULL,
  `sec` varchar(5) NOT NULL,
  `password` varchar(15) NOT NULL,
  `gov` varchar(10) NOT NULL,
  `vgov` varchar(10) NOT NULL,
  `congres` varchar(10) NOT NULL,
  `board` varchar(10) NOT NULL,
  `councilor` varchar(10) NOT NULL,
  `Mayor` varchar(10) NOT NULL,
  `Vice` varchar(10) NOT NULL,
  `leve` varchar(10) NOT NULL default '2',
  `sy` varchar(15) NOT NULL,
  PRIMARY KEY  (`studid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`studid`, `name`, `course`, `year`, `sec`, `password`, `gov`, `vgov`, `congres`, `board`, `councilor`, `Mayor`, `Vice`, `leve`, `sy`) VALUES
('1211', 'Joan Salvador', 'BSE', '3rd', 'C', 'user', '', '', '', '', '', '', '', '2', '2008-2009'),
('1222', 'nemie', 'BSE', '4th', 'B', 'user', '', '', '', '', '', '', '', '2', '2008-2009'),
('1233', 'richard', 'BSF', '4th', 'A', 'user', '', '', '', '', '', '', '', '2', '2008-2009'),
('1234', 'majorie', 'BSINFOTECT', '1st', 'A', 'user', '', '', '', '', '', '', '', '2', '2008-2009'),
('1244', 'Resty Tamargo', 'BSPA', '2nd', 'D', 'user', '', '', '', '', '', '', '', '2', '2008-2009'),
('1245', 'glai', 'BS INFO.TECH.', '4th', 'B', 'user', '', '', '', '', '', '', '', '2', '2008-2009'),
('1255', 'Paul Acosta', 'BSBA', '1st', 'B', 'user', '', '', '', '', '', '', '', '2', '2008-2009'),
('1266', 'Ricky', 'BSCrim', '2nd', 'C', 'user', '', '', '', '', '', '', '', '2', '2008-2009'),
('1277', 'Rona', 'BSHim', '3rd', 'C', 'user', '', '', '', '', '', '', '', '2', '2008-2009');

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

--
-- Table structure for table `votecount`
--

CREATE TABLE `votecount` (
  `StudID` varchar(15) NOT NULL,
  `Position` varchar(50) NOT NULL,
  `Result` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `votecount`
--

INSERT INTO `votecount` (`StudID`, `Position`, `Result`) VALUES
('1211', 'President', 1),
('1211', 'Secretary', 1);
