File: data.sql

# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 26, 2004 at 05:41 PM
# Server version: 4.0.18
# PHP Version: 4.3.4
# 
# Database : `poll`
# 

# --------------------------------------------------------

#
# Table structure for table `answers`
#

CREATE TABLE `answers` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(255) NOT NULL default '',
  `score` int(11) NOT NULL default '0',
  `poll_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `score` (`score`,`poll_id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

#
# RELATIONS FOR TABLE `answers`:
#   `poll_id`
#       `polls` -> `id`
#

#
# Dumping data for table `answers`
#

INSERT INTO `answers` VALUES (1, '10-20', 32, 1);
INSERT INTO `answers` VALUES (2, '20-30', 60, 1);
INSERT INTO `answers` VALUES (3, '30-40', 48, 1);
INSERT INTO `answers` VALUES (4, '40-50', 25, 1);
INSERT INTO `answers` VALUES (5, '>50', 12, 1);
INSERT INTO `answers` VALUES (6, '640x480', 6, 2);
INSERT INTO `answers` VALUES (7, '800x600', 16, 2);
INSERT INTO `answers` VALUES (8, '1024x768', 77, 2);
INSERT INTO `answers` VALUES (9, '1280x1024', 35, 2);
INSERT INTO `answers` VALUES (10, '1600x1200', 14, 2);
INSERT INTO `answers` VALUES (11, 'other', 10, 2);

# --------------------------------------------------------

#
# Table structure for table `polls`
#

CREATE TABLE `polls` (
  `id` int(11) NOT NULL auto_increment,
  `question` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `polls`
#

INSERT INTO `polls` VALUES (1, 'How old are you?');
INSERT INTO `polls` VALUES (2, 'What is your screen resolution?');