PHP Classes

File: data.sql

Recommend this page to a friend!
  Classes of Jure Merhar   Poll Engine   data.sql   Download  
File: data.sql
Role: Auxiliary data
Content type: text/plain
Description: example data (for phpMyAdmin)
Class: Poll Engine
Build and process polls stored in a database
Author: By
Last change:
Date: 19 years ago
Size: 1,765 bytes
 

Contents

Class file image Download
# 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?');