so here is what i need
Can someone make an admin panel for this SQL tables?
Insert into:
Artists
Contests
List for: (with a delete option)
Artists
Contests
Entries
Comments
Here is the SQL file
Code: Select all
Database glebe_ca_-_test running on localhost
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jun 11, 2004 at 10:03 AM
# Server version: 3.23.58
# PHP Version: 4.3.4
#
# Database : `glebe_ca_-_test`
#
# --------------------------------------------------------
#
# Table structure for table `artists`
#
CREATE TABLE `artists` (
`artist` text NOT NULL,
`password` text NOT NULL,
`email` text NOT NULL,
`website` text NOT NULL,
`title` text NOT NULL,
`banner` text NOT NULL,
`message` text NOT NULL,
`popular` smallint(5) unsigned NOT NULL default '0',
`art` smallint(5) unsigned NOT NULL default '0',
`concept` smallint(5) unsigned NOT NULL default '0',
`suggestion` smallint(5) unsigned NOT NULL default '0',
`winner` smallint(5) unsigned NOT NULL default '0',
`entry` smallint(5) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `artists`
#
# --------------------------------------------------------
#
# Table structure for table `comments`
#
CREATE TABLE `comments` (
`contest` smallint(5) unsigned NOT NULL default '0',
`entry` smallint(5) unsigned NOT NULL default '0',
`stamp` datetime NOT NULL default '0000-00-00 00:00:00',
`name` text NOT NULL,
`suggestion` text NOT NULL,
`ip` text NOT NULL
) TYPE=MyISAM;
#
# Dumping data for table `comments`
#
# --------------------------------------------------------
#
# Table structure for table `contests`
#
CREATE TABLE `contests` (
`contest` smallint(5) unsigned NOT NULL default '0',
`theme` text NOT NULL,
`date` date NOT NULL default '0000-00-00',
`date2` date NOT NULL default '0000-00-00',
`date3` date NOT NULL default '0000-00-00',
`date4` date NOT NULL default '0000-00-00',
`popular` smallint(5) unsigned NOT NULL default '0',
`art` smallint(5) unsigned NOT NULL default '0',
`concept` smallint(5) unsigned NOT NULL default '0',
`suggestion` smallint(5) unsigned NOT NULL default '0',
`entry` smallint(5) unsigned NOT NULL default '0',
`description` text NOT NULL
) TYPE=MyISAM COMMENT='list of weekly drawing contests';
#
# Dumping data for table `contests`
#
# --------------------------------------------------------
#
# Table structure for table `entries`
#
CREATE TABLE `entries` (
`contest` smallint(5) unsigned NOT NULL default '0',
`entry` smallint(5) unsigned NOT NULL default '0',
`artist` text NOT NULL,
`artist2` text NOT NULL,
`image` text NOT NULL,
`popular` smallint(5) unsigned NOT NULL default '0',
`art` smallint(5) unsigned NOT NULL default '0',
`concept` smallint(5) unsigned NOT NULL default '0',
`suggestion` smallint(5) unsigned NOT NULL default '0',
`winner` set('popular','art','concept') NOT NULL default '',
FULLTEXT KEY `image` (`image`),
FULLTEXT KEY `image_2` (`image`)
) TYPE=MyISAM COMMENT='Drawing Contest Entry';
#
# Dumping data for table `entries`
#
# --------------------------------------------------------
#
# Table structure for table `votes`
#
CREATE TABLE `votes` (
`contest` smallint(5) unsigned NOT NULL default '0',
`ip` text NOT NULL,
`popular` text NOT NULL,
`art` text NOT NULL,
`concept` text NOT NULL,
`stamp` datetime NOT NULL default '0000-00-00 00:00:00',
`proxy` text
) TYPE=MyISAM;
#
# Dumping data for table `votes`
#