Sorry for the late reply.
Code: Select all
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 23, 2009 at 01:40 PM
-- Server version: 5.0.27
-- PHP Version: 5.2.0
--
-- Database: `login`
--
-- --------------------------------------------------------
--
-- Table structure for table `active_guests`
--
CREATE TABLE `active_guests` (
`ip` varchar(15) NOT NULL,
`timestamp` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `active_users`
--
CREATE TABLE `active_users` (
`username` varchar(30) NOT NULL,
`timestamp` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `banned_users`
--
CREATE TABLE `banned_users` (
`username` varchar(30) NOT NULL,
`timestamp` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `group_members`
--
CREATE TABLE `group_members` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`linkid` int(11) NOT NULL,
`groupid` int(11) NOT NULL,
`control` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE `groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `member_numbers`
--
CREATE TABLE `member_numbers` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`membernum` varchar(2000) character SET utf8 collate utf8_unicode_ci DEFAULT NULL,
`linkid` varchar(2000) character SET utf8 collate utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1601 ;
-- --------------------------------------------------------
--
-- Table structure for table `member_personal`
--
CREATE TABLE `member_personal` (
`id` smallint(3) NOT NULL AUTO_INCREMENT COMMENT 'Automated ID',
`first_name` varchar(40) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Billing First Name',
`last_name` varchar(40) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Billing Last Name',
`billing_street` varchar(40) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Billing Street',
`billing_city` varchar(40) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Billing City',
`billing_state` tinytext character SET utf8 collate utf8_unicode_ci NOT NULL,
`billing_zip` smallint(5) NOT NULL COMMENT 'Billing Zipcode',
`billing_phone` varchar(30) character SET utf8 collate utf8_unicode_ci NOT NULL,
`email` varchar(40) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Confirmation Email',
`credit_card_name` varchar(80) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Name on Credit Card',
`credit_card_number` smallint(12) NOT NULL COMMENT 'Credit Card Number',
`user_log` varchar(40) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Who added this info',
`linkid` smallint(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
--
-- Table structure for table `performances`
--
CREATE TABLE `performances` (
`id` tinyint(255) NOT NULL AUTO_INCREMENT,
`show_id` tinyint(255) NOT NULL,
`perf_id` tinyint(255) NOT NULL,
`perf_date` varchar(255) character SET utf8 collate utf8_unicode_ci NOT NULL,
`perf_time` varchar(255) NOT NULL,
`tickets_avail` varchar(50) NOT NULL,
`ticket_cost` tinyint(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Table structure for table `shows`
--
CREATE TABLE `shows` (
`id` smallint(3) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Automated ID',
`show_name` varchar(60) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Name of the Show',
`show_date` varchar(30) NOT NULL COMMENT 'Date of the Show',
`tickets_available` smallint(3) NOT NULL COMMENT 'Total Tickets Allotted to Website',
`tickets_left` smallint(3) NOT NULL COMMENT 'Tickets Remaining',
`show_time` varchar(30) character SET utf8 collate utf8_unicode_ci NOT NULL,
`ticket_cost` tinyint(10) NOT NULL,
`user_log` varchar(40) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Who added this show',
PRIMARY KEY (`id`),
KEY `show_name` (`show_name`,`show_date`,`tickets_available`,`tickets_left`,`show_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
-- --------------------------------------------------------
--
-- Table structure for table `ticket_sales`
--
CREATE TABLE `ticket_sales` (
`id` smallint(3) NOT NULL AUTO_INCREMENT COMMENT 'Automated ID',
`mid` smallint(3) NOT NULL COMMENT 'Member Ticket ID',
`mnum` mediumint(255) NOT NULL,
`method` smallint(3) NOT NULL COMMENT 'Reserved, Purchased, Will Call',
`ticket_amount` smallint(3) NOT NULL COMMENT 'How many tickets have they reserved?',
`tickets_left` smallint(3) NOT NULL COMMENT 'How many tickets can they reserve?',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of transaction',
`epoch` varchar(30) NOT NULL,
`user_log` varchar(40) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Who caused the transaction?',
`show_id` smallint(3) NOT NULL COMMENT 'Show the tickets are for',
`perf_id` mediumtext character SET utf8 collate utf8_unicode_ci NOT NULL,
`total` varchar(10) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Total owed, if any (Depends on method)',
`seating` varchar(10) character SET utf8 collate utf8_unicode_ci DEFAULT NULL COMMENT 'Seat selection (to be added later)',
`confirmation_number` varchar(100) character SET utf8 collate utf8_unicode_ci NOT NULL COMMENT 'Confirmation Number',
PRIMARY KEY (`id`),
KEY `mid` (`mid`,`ticket_amount`,`tickets_left`,`show_id`),
KEY `mnum` (`mnum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` smallint(255) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`password` varchar(32) DEFAULT NULL,
`userid` varchar(32) DEFAULT NULL,
`userlevel` tinyint(1) UNSIGNED NOT NULL,
`memberlevel` tinyint(10) NOT NULL,
`email` varchar(50) DEFAULT NULL,
`timestamp` int(11) UNSIGNED NOT NULL,
`current` tinyint(2) NOT NULL DEFAULT '0',
`member_num` varchar(5000) character SET utf8 collate utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`password`,`userid`,`userlevel`,`memberlevel`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
I'm still trying to find a solution for this problem if anyone can help.