DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`admin_id` varchar(10) NOT NULL default '0',
`fname` varchar(50) NOT NULL default '0',
`lname` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '0',
`street` varchar(50) NOT NULL default '0',
`city` varchar(50) NOT NULL default '0',
`state` varchar(50) NOT NULL default '0',
`country` varchar(50) NOT NULL default '0',
`zipcode` varchar(10) NOT NULL default '0',
`password` varchar(10) NOT NULL default '0',
`email` varchar(50) NOT NULL default '0',
`phone` int(10) NOT NULL default '0',
`fax` int(10) NOT NULL default '0',
`mobile` int(10) NOT NULL default '0',
`doj` timestamp(4) NOT NULL,
`secret_qtn` tinytext NOT NULL,
`secret_ans` tinytext NOT NULL,
`status` varchar(20) NOT NULL default '',
PRIMARY KEY (`admin_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `auction`;
CREATE TABLE `auction` (
`auctn_id` varchar(10) NOT NULL default '0',
`start_date` varchar(50) NOT NULL default '0',
`end_date` varchar(50) NOT NULL default '0',
`item_id` varchar(50) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
PRIMARY KEY (`auctn_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `auction_bids`;
CREATE TABLE `auction_bids` (
`bid_id` varchar(10) NOT NULL default '0',
`auctn_id` varchar(50) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`amount` varchar(50) NOT NULL default '0',
`date_time` varchar(50) NOT NULL default '0',
PRIMARY KEY (`bid_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `billing_info`;
CREATE TABLE `billing_info` (
`bill_id` varchar(10) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`fname` varchar(50) NOT NULL default '0',
`lname` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '0',
`street` varchar(50) NOT NULL default '0',
`country` varchar(50) NOT NULL default '0',
`zipcode` varchar(50) NOT NULL default '0',
PRIMARY KEY (`bill_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `cc_info`;
CREATE TABLE `cc_info` (
`cc_id` varchar(10) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`fname` varchar(50) NOT NULL default '0',
`lname` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '0',
`street` varchar(50) NOT NULL default '0',
`country` varchar(50) NOT NULL default '0',
`zipcode` varchar(50) NOT NULL default '0',
`ccno` varchar(50) NOT NULL default '0',
`***` varchar(50) NOT NULL default '0',
`expry_mnth` varchar(50) NOT NULL default '0',
`expry_year` varchar(50) NOT NULL default '0',
PRIMARY KEY (`cc_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `contacts`;
CREATE TABLE `contacts` (
`cont_id` varchar(10) NOT NULL default '0',
`contact_name` varchar(50) NOT NULL default '0',
PRIMARY KEY (`cont_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `contacts_detl`;
CREATE TABLE `contacts_detl` (
`cont_detl_id` varchar(10) NOT NULL default '0',
`cont_id` varchar(50) NOT NULL default '0',
`department` varchar(50) NOT NULL default '0',
`designation` varchar(50) NOT NULL default '0',
`email` varchar(50) NOT NULL default '0',
`phone` varchar(50) NOT NULL default '0',
`fax` varchar(50) NOT NULL default '0',
PRIMARY KEY (`cont_detl_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `feedback`;
CREATE TABLE `feedback` (
`feed_id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '0',
`comments` text NOT NULL,
PRIMARY KEY (`feed_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `feturd_optn`;
CREATE TABLE `feturd_optn` (
`feturd_id` varchar(10) NOT NULL default '0',
`optn_desc` varchar(50) NOT NULL default '0',
`price` varchar(50) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
`expry_mnth` varchar(50) NOT NULL default '0',
`expry_year` varchar(50) NOT NULL default '0',
PRIMARY KEY (`feturd_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
`item_id` varchar(10) NOT NULL default '0',
`item_desc` varchar(50) NOT NULL default '0',
`catgry_id` varchar(50) NOT NULL default '0',
`price` int(10) NOT NULL default '0',
`pic_url` varchar(50) NOT NULL default '0',
`qty` int(10) NOT NULL default '0',
`incrmnt_price` int(10) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
`max_price` int(10) NOT NULL default '0',
`shpng_type` varchar(50) NOT NULL default '0',
PRIMARY KEY (`item_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `itm_catgry`;
CREATE TABLE `itm_catgry` (
`catgry_id` varchar(10) NOT NULL default '0',
`catgry_desc` varchar(50) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
PRIMARY KEY (`catgry_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `itm_feturd`;
CREATE TABLE `itm_feturd` (
`itm_feturd_id` varchar(10) NOT NULL default '0',
`feturd_id` varchar(50) NOT NULL default '0',
`item_id` varchar(50) NOT NULL default '0',
PRIMARY KEY (`itm_feturd_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
`mem_id` varchar(10) NOT NULL default '0',
`fname` varchar(50) NOT NULL default '0',
`lname` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '0',
`street` varchar(50) NOT NULL default '0',
`city` varchar(50) NOT NULL default '0',
`state` varchar(50) NOT NULL default '0',
`country` varchar(50) NOT NULL default '0',
`zipcode` varchar(10) NOT NULL default '0',
`password` varchar(10) NOT NULL default '0',
`email` varchar(50) NOT NULL default '0',
`phone` int(10) NOT NULL default '0',
`fax` int(10) NOT NULL default '0',
`mobile` int(10) NOT NULL default '0',
`plan_id` int(5) NOT NULL default '0',
`doj` timestamp(4) NOT NULL,
`secret_qtn` text NOT NULL,
`secret_ans` text NOT NULL,
`pymnt_status` int(5) NOT NULL default '0',
`status` varchar(20) NOT NULL default '',
PRIMARY KEY (`mem_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `pymnt_plan`;
CREATE TABLE `pymnt_plan` (
`plan_id` varchar(10) NOT NULL default '0',
`plan_name` varchar(50) NOT NULL default '0',
`price` int(10) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
`no_of_lstng` int(10) NOT NULL default '0',
`expry_mnth` varchar(10) NOT NULL default '',
`expry_year` varchar(10) NOT NULL default '',
PRIMARY KEY (`plan_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `shpng_type`;
CREATE TABLE `shpng_type` (
`shpng_id` varchar(10) NOT NULL default '0',
`shpng_desc` varchar(50) NOT NULL default '0',
PRIMARY KEY (`shpng_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `site_customize`;
CREATE TABLE `site_customize` (
`cust_id` varchar(10) NOT NULL default '0',
`font_color` varchar(50) NOT NULL default '0',
`font_style` varchar(50) NOT NULL default '0',
`font_name` varchar(50) NOT NULL default '0',
`font_size` varchar(50) NOT NULL default '0',
`header` varchar(50) NOT NULL default '0',
`footer` varchar(50) NOT NULL default '0',
`history` varchar(50) NOT NULL default '0',
`faqs` varchar(50) NOT NULL default '0',
`privacy_policy` varchar(50) NOT NULL default '0',
PRIMARY KEY (`cust_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `ticket`;
CREATE TABLE `ticket` (
`tkt_id` varchar(10) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`comments` varchar(50) NOT NULL default '0',
PRIMARY KEY (`tkt_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `transaction`;
CREATE TABLE `transaction` (
`trans_id` varchar(10) NOT NULL default '0',
`mem_id` varchar(50) NOT NULL default '0',
`trans_type` varchar(50) NOT NULL default '0',
`amount` varchar(50) NOT NULL default '0',
`date_time` varchar(50) NOT NULL default '0',
`remarks` varchar(50) NOT NULL default '0',
`status` varchar(50) NOT NULL default '0',
PRIMARY KEY (`trans_id`)
) TYPE=MyISAM;

This is something which I think need suggestions what else can be added to it to increase the fucntionality of the programe.. This is database for auction managment system... kind of a bidding system... reponse with suggestion behighly appreciated.

That depends on the needs of your client. Working out a properly normalized schema based on the needs is what people get paid a lot for. Are you going to pay anyone to help you with this? Do you have use case scenerios? Clear cut definations of what the system is supposed to do?

Hi, Shani! I also would suggest describing what you are showing us rather than just throwing your setup code out there, e.g.

"I am developing an auction management system w/10 tables... 2 for auction item info, 1 for billing, 2 for user/login.... , etc. The bidding will be online via a web browser and items are pre-submitted using a web form. The admin approves the item for auction and then..."

--ST

hello
depending on your needs this can become a huge database, for example in site_customize you could add many more things like specific metatags, titles, descriptions for each page etc