Re: #1265 - Data truncated for column 'robot_runtime' at row 1
Posted by: CORTEGGIANI Patrice
Date: April 04, 2010 01:41PM
Date: April 04, 2010 01:41PM
Salut,
Merci de ta réponse mais ce que je comprendsp as c'est pourquoi sur un serveur héberger je n'ai pas le problème alors que sur un serveur en local avec easyphp j'ai ce problème.
Je te mais le contenu de mon fichier sql.sql qui crée tout de A à Z
Merci de ton aide
Script sql.sql :
-- MySQL dump 10.11
--
-- Host: localhost
-- ------------------------------------------------------
--
-- Table structure for table `account`
--
CREATE TABLE `account` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`amount` decimal(10,2) NOT NULL,
`payment_opt` enum('P','A') NOT NULL default 'P',
`status` enum('Y','N') NOT NULL default 'Y',
`deleted` enum('Y','N','P') NOT NULL default 'N',
`entrydate` varchar(20) NOT NULL default '',
`paystatus` enum('TRUE','FALSE','Pending') NOT NULL default 'Pending',
`order_id` int(11) NOT NULL default '0',
`transfer_status` enum('TRUE','FALSE') NOT NULL default 'FALSE',
`approved` enum('Y','N') NOT NULL default 'N',
`bid_cost` int(11) NOT NULL default '0',
`shipped` enum('Y','N') NOT NULL default 'N',
`item_id` int(11) NOT NULL,
`paytime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `account`
--
INSERT INTO `account` VALUES (1,104,'120.00','P','Y','N','2009-03-02 05:52:12','Pending',1235994732,'FALSE','N',4,'N',0,0),(2,104,'120.00','P','Y','N','2009-03-02 05:53:47','Pending',1235994827,'FALSE','N',4,'N',0,0),(3,104,'120.00','P','Y','N','2009-03-02 05:53:58','Pending',1235994838,'FALSE','N',4,'N',0,0),(4,104,'120.00','A','Y','N','2009-03-02 05:54:05','Pending',1235994845,'FALSE','N',4,'N',0,0),(5,107,'240.00','P','Y','N','2009-03-02 16:37:43','TRUE',1236033463,'TRUE','N',10,'N',0,0),(6,107,'240.00','P','Y','N','2009-03-02 16:38:03','TRUE',1236033483,'TRUE','N',10,'N',0,0),(7,107,'240.00','P','Y','N','2009-03-02 16:38:13','TRUE',1236033493,'TRUE','N',10,'N',0,0);
--
-- Table structure for table `add_bids`
--
CREATE TABLE `add_bids` (
`id` int(11) NOT NULL auto_increment,
`item_id` int(11) default NULL,
`user_id` int(11) default NULL,
`bid_rate` decimal(10,2) default NULL,
`bid_time` varchar(20) default NULL,
`city` varchar(50) default NULL,
`auction_code` varchar(4) NOT NULL default '',
`mobile_no` varchar(15) NOT NULL default '',
`bid_type` enum('S','A') NOT NULL default 'S',
`deleted` enum('Y','N') NOT NULL default 'N',
`bidbutler_type` enum('S','B') NOT NULL,
`smsid` varchar(50) NOT NULL,
`user_ip` varchar(20) NOT NULL,
`user_cookie` varchar(100) NOT NULL,
`bid_amt` decimal(10,2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `add_bids`
--
INSERT INTO `add_bids` VALUES (1,25,95,'1.10','2009-02-26 15:26:17','dfdf','1239','1212','A','N','S','','','','0.00'),(2,26,40,'1.10','2009-02-26 15:32:18','jaipur','ZDCM','45645645645','A','N','S','','','','0.00'),(3,27,104,'1.10','2009-02-26 15:36:18','sdsas','123D','00013453567','A','N','S','','','','0.00'),(4,27,95,'1.20','2009-02-26 15:38:06','dfdf','123D','1212','A','N','S','','','','0.00'),(5,27,104,'1.30','2009-02-26 15:39:17','sdsas','123D','00013453567','A','N','S','','','','0.00'),(6,27,40,'1.40','2009-02-26 15:39:22','jaipur','123D','45645645645','A','N','S','','','','0.00'),(7,27,104,'1.50','2009-02-26 15:39:29','sdsas','123D','00013453567','A','N','S','','','','0.00'),(8,27,95,'1.60','2009-02-26 15:39:32','dfdf','123D','1212','A','N','S','','','','0.00'),(9,28,95,'1.10','2009-02-26 18:48:17','dfdf','AXCO','1212','A','N','S','','','','0.00'),(10,29,40,'1.10','2009-02-28 20:35:31','jaipur','ICAA','45645645645','A','N','S','','','','0.00'),(11,15,105,'300.01','2009-03-02 05:06:02','SUNDERLAND','XAHI','07999691895','A','N','S','','','','0.00'),(12,16,105,'5650.01','2009-03-02 05:06:12','SUNDERLAND','AXCF','07999691895','A','N','S','','','','0.00'),(13,14,105,'150.01','2009-03-02 05:06:21','SUNDERLAND','IALA','07999691895','A','N','S','','','','0.00'),(14,13,105,'3000.01','2009-03-02 05:06:24','SUNDERLAND','NKAI','07999691895','A','N','S','','','','0.00'),(15,15,104,'300.02','2009-03-02 05:51:32','sdsas','XAHI','00013453567','A','N','S','','','','0.00'),(16,30,39,'1.10','2009-03-02 06:06:08','bkn','AAAA','456456546','A','N','S','','','','0.00'),(17,30,104,'1.20','2009-03-02 06:06:38','sdsas','AAAA','00013453567','A','N','S','','','','0.00'),(18,30,39,'1.30','2009-03-02 06:06:38','bkn','AAAA','456456546','A','N','S','','','','0.00'),(19,31,95,'1.10','2009-03-02 06:12:15','dfdf','AAAB','1212','A','N','S','','','','0.00'),(20,32,39,'1.10','2009-03-02 13:57:26','bkn','SSSS','456456546','A','N','S','','','','0.00'),(21,33,107,'0.01','2009-03-02 16:39:46','sofia','NCVD','000293312333','A','N','S','','','','0.00'),(22,1,107,'8000.01','2009-03-02 16:53:33','sofia','CGCS','000293312333','A','N','S','','','','0.00'),(23,15,107,'300.03','2009-03-02 17:13:54','sofia','XAHI','000293312333','A','N','S','','','','0.00'),(24,8,107,'2500.01','2009-03-02 17:13:58','sofia','WSIP','000293312333','A','N','S','','','','0.00'),(25,14,107,'150.02','2009-03-02 17:14:29','sofia','IALA','000293312333','A','N','S','','','','0.00'),(26,13,107,'3000.02','2009-03-02 17:23:00','sofia','NKAI','000293312333','A','N','B','','','','0.00'),(27,16,107,'5650.02','2009-03-02 17:37:27','sofia','AXCF','000293312333','A','N','S','','','','0.00');
--
-- Table structure for table `advert`
--
CREATE TABLE `advert` (
`advert_id` int(11) NOT NULL auto_increment,
`ad_image` varchar(100) default NULL,
`url` varchar(100) default NULL,
`start_date` date default NULL,
`end_date` date default NULL,
`no_clicks` int(11) default NULL,
`status` enum('Y','N') default NULL,
`deleted` enum('Y','N') default NULL,
`entrydate` date default NULL,
`category_sequence` int(11) NOT NULL default '0',
`lang` varchar(15) NOT NULL default '',
PRIMARY KEY (`advert_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `advert`
--
INSERT INTO `advert` VALUES (1,'upload_advert_images/advert_1236095570.gif','http://www.castorwin.com','2009-03-05','2009-03-08',0,'Y','N','0000-00-00',1,'';);
--
-- Table structure for table `amount_transfer`
--
CREATE TABLE `amount_transfer` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) default NULL,
`pay_type` varchar(20) default '',
`entrydate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`amount` int(11) default '0',
`credit` int(10) default '0',
`credit_type` varchar(10) NOT NULL default '',
`amount_type` varchar(20) NOT NULL,
`reason` tinytext NOT NULL,
`trans_type` enum('A','P','N') NOT NULL default 'N',
`deleted` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `amount_transfer`
--
INSERT INTO `amount_transfer` VALUES (1,95,'Debit','2009-02-26 21:26:17',1,0,'','','Bidding on auction','N','N'),(2,104,'Credit','2009-02-26 21:27:19',5,0,'C','R','Welcome Coupon','N','N'),(3,40,'Debit','2009-02-26 21:32:18',1,0,'','','Bidding on auction','N','N'),(4,104,'Debit','2009-02-26 21:36:18',1,0,'','','Bidding on auction','N','N'),(5,95,'Debit','2009-02-26 21:38:06',1,0,'','','Bidding on auction','N','N'),(6,104,'Debit','2009-02-26 21:39:17',1,0,'','','Bidding on auction','N','N'),(7,40,'Debit','2009-02-26 21:39:22',1,0,'','','Bidding on auction','N','N'),(8,104,'Debit','2009-02-26 21:39:29',1,0,'','','Bidding on auction','N','N'),(9,95,'Debit','2009-02-26 21:39:32',1,0,'','','Bidding on auction','N','N'),(10,95,'Debit','2009-02-27 00:48:17',1,0,'','','Bidding on auction','N','N'),(11,105,'Credit','2009-02-27 19:41:36',5,0,'C','R','Welcome Coupon','N','N'),(12,40,'Debit','2009-03-01 02:35:31',1,0,'','','Bidding on auction','N','N'),(13,105,'Debit','2009-03-02 11:06:02',1,0,'','','Bidding on auction','N','N'),(14,105,'Debit','2009-03-02 11:06:12',1,0,'','','Bidding on auction','N','N'),(15,105,'Debit','2009-03-02 11:06:21',1,0,'','','Bidding on auction','N','N'),(16,105,'Debit','2009-03-02 11:06:24',1,0,'','','Bidding on auction','N','N'),(17,104,'Debit','2009-03-02 11:51:32',1,0,'','','Bidding on auction','N','N'),(18,39,'Debit','2009-03-02 12:06:08',1,0,'','','Bidding on auction','N','N'),(19,104,'Debit','2009-03-02 12:06:38',1,0,'','','Bidding on auction','N','N'),(20,39,'Debit','2009-03-02 12:06:38',1,0,'','','Bidding on auction','N','N'),(21,95,'Debit','2009-03-02 12:12:15',1,0,'','','Bidding on auction','N','N'),(22,106,'Credit','2009-03-02 19:03:31',5,0,'C','R','Welcome Coupon','N','N'),(23,39,'Debit','2009-03-02 19:57:26',1,0,'','','Bidding on auction','N','N'),(24,107,'Credit','2009-03-02 21:58:48',5,0,'C','R','Welcome Coupon','N','N'),(25,107,'Debit','2009-03-02 22:39:46',1,0,'','','Bidding on auction','N','N'),(26,107,'Debit','2009-03-02 22:53:33',1,0,'','','Bidding on auction','N','N'),(27,107,'Credit','0000-00-00 00:00:00',240,0,'','','Bid Purchasing','N','N'),(28,107,'Debit','2009-03-02 23:13:54',1,0,'','','Bidding on auction','N','N'),(29,107,'Debit','2009-03-02 23:13:58',1,0,'','','Bidding on auction','N','N'),(30,107,'Debit','2009-03-02 23:14:29',1,0,'','','Bidding on auction','N','N'),(31,107,'Credit','0000-00-00 00:00:00',240,0,'','','Bid Purchasing','N','N'),(32,107,'Credit','0000-00-00 00:00:00',240,0,'','','Bid Purchasing','N','N'),(33,107,'Debit','2009-03-02 23:23:00',1,0,'','','Bidding on auction','N','N'),(34,107,'Debit','2009-03-02 23:37:27',1,0,'','','Bidding on auction','N','N'),(35,108,'Credit','2009-03-03 17:07:25',5,0,'C','R','Welcome Coupon','N','N');
--
-- Table structure for table `auto_bid`
--
CREATE TABLE `auto_bid` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`bid_from` decimal(10,2) NOT NULL default '0.00',
`bid_to` decimal(10,2) NOT NULL default '0.00',
`total_bid` int(11) NOT NULL,
`entrydate` varchar(20) default NULL,
`item_id` int(11) NOT NULL,
`status` enum('Y','N') NOT NULL default 'N',
`deleted` enum('Y','N') NOT NULL default 'N',
`counter` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `auto_bid`
--
INSERT INTO `auto_bid` VALUES (1,107,'0.02','0.09',3,'2009-03-02 16:41:46',33,'N','N',3),(2,107,'3000.02','3001.00',20,'2009-03-02 17:22:56',13,'Y','N',19);
--
-- Table structure for table `bid`
--
CREATE TABLE `bid` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(200) default NULL,
`bid_rate` decimal(10,2) default '0.00',
`status` enum('Y','N') default 'Y',
`deleted` enum('Y','N') NOT NULL default 'N',
`sequence` int(11) NOT NULL default '0',
`country` int(11) NOT NULL default '0',
`zipcode` varchar(15) NOT NULL default '',
`img_url` varchar(100) NOT NULL default '',
`image_path` varchar(100) NOT NULL default '',
`entrydate` varchar(20) NOT NULL default '',
`des` text NOT NULL,
`start_time` int(11) NOT NULL default '0',
`end_bid` enum('Y','E','S','N') NOT NULL default 'N',
`category` varchar(50) NOT NULL default '',
`sdate` varchar(15) NOT NULL default '',
`edate` varchar(15) NOT NULL default '',
`lang` int(3) NOT NULL default '0',
`auction_code` varchar(4) NOT NULL default '',
`hours` int(10) NOT NULL default '0',
`title_n` varchar(100) NOT NULL,
`short_description_n` text NOT NULL,
`des_n` text NOT NULL,
`extends_time` int(10) NOT NULL default '0',
`update_extend` varchar(20) NOT NULL default '',
`final_bid` decimal(10,2) NOT NULL default '0.00',
`end_time` varchar(20) NOT NULL default '',
`last_mobile` varchar(15) NOT NULL default '',
`homepage` enum('Y','N') NOT NULL default 'N',
`view_type` enum('E','L','S') NOT NULL default 'S',
`start` enum('Y','N') NOT NULL default 'N',
`start_auction` varchar(15) NOT NULL,
`end_auction` varchar(15) NOT NULL,
`running` enum('Y','N') NOT NULL default 'N',
`normal_rate` decimal(10,2) default '0.00',
`total_days` int(11) NOT NULL,
`start_pause` enum('Y','N') NOT NULL default 'N',
`start_pause_time` varchar(15) NOT NULL,
`pause_time` int(11) NOT NULL default '0',
`main_auction` enum('Y','N') NOT NULL default 'N',
`timer_value` int(10) NOT NULL default '0',
`delivery_cost` decimal(10,2) NOT NULL default '0.00',
`delivery_info` tinytext NOT NULL,
`delivery_info_n` tinytext NOT NULL,
`auction_type` varchar(100) NOT NULL,
`meta_description` tinytext NOT NULL,
`meta_keyword` tinytext NOT NULL,
`image_path2` varchar(200) NOT NULL,
`image_path3` varchar(200) NOT NULL,
`image_path4` varchar(200) NOT NULL,
`start_price` decimal(10,2) NOT NULL,
`delivery_condition` enum('S','B') NOT NULL default 'B',
`system_id` int(11) NOT NULL,
`target_price` decimal(10,2) NOT NULL default '0.00',
`robot_runtime` enum('E','D') NOT NULL,
`robot_system` enum('S','P') NOT NULL,
`quantity_stock` int(11) NOT NULL,
`mark_flag` enum('Y','N','C') NOT NULL default 'N',
`max_frequency` varchar(10) NOT NULL,
`sequenceid` int(11) NOT NULL,
`beginner_auction` enum('Y','N') NOT NULL default 'N',
`short_description` tinytext NOT NULL,
`parent_auction` int(11) NOT NULL default '0',
`fixed_price` decimal(10,2) NOT NULL,
`bid_counter` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bid`
--
INSERT INTO `bid` VALUES (1,NULL,'0.01','Y','N',1,0,'','','1235458989.jpg','2009-02-24 09:22:08','',0,'N','1','2009-2-24','2010-2-24',0,'CGCS',0,'','','',145,'1236034413','8000.01','','000293312333','N','S','Y','09:28:31','23:29:29','Y','10000.00',0,'Y','',0,'N',0,'8000.00','','','E','','','1235458989_2.jpg','1235458989_3.jpg','1235458989_4.jpg','8000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',1),(2,NULL,'0.15','Y','N',2,0,'','','1235459240.jpg','2009-02-24 09:22:08','',0,'N','2','2009-2-24','2009-12-12',0,'NLAS',0,'','','',125,'','15000.00','','','N','S','Y','10:29:31','22:29:25','Y','15000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235459240_2.jpg','1235459240_3.jpg','1235459240_4.jpg','15000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(3,NULL,'0.01','Y','N',3,0,'','','1235459522.jpg','2009-02-24 09:22:08','',0,'Y','1','2009-2-24','2009-10-12',0,'CXAU',0,'','','',145,'1235662192','24000.00','26-02-2009 10:35:46','','N','S','Y','10:32:00','23:27:00','Y','25000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235459522_2.jpg','1235459522_3.jpg','1235459522_4.jpg','24000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(4,NULL,'0.01','Y','N',4,0,'','','1235459737.jpg','2009-02-24 09:22:08','',0,'N','4','2009-2-24','2010-2-2',0,'SXIJ',0,'','','',145,'','14000.00','','','N','S','Y','10:13:27','23:29:29','Y','15000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235459737_2.jpg','1235459737_3.jpg','1235459737_4.jpg','14000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(5,NULL,'0.15','Y','N',5,0,'','','1235460067.jpg','2009-02-24 09:22:08','',0,'N','5','2009-2-24','2010-2-2',0,'OIXZ',0,'','','',124,'','10000.00','','','N','S','Y','10:29:28','23:29:29','Y','12000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235460067_2.jpg','1235460067_3.jpg','1235460067_4.jpg','10000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(6,NULL,'0.15','Y','N',6,0,'','','1235460330.jpg','2009-02-24 09:26:07','',0,'Y','7','2009-02-24','2009-02-24',0,'AAXG',0,'','','',100,'1235553924','233.00','25-02-2009 09:32:10','','N','S','Y','09:26:00','22:00:00','Y','23.00',0,'Y','',0,'N',0,'0.00','','','I','','','','','','233.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(7,NULL,'0.01','Y','N',7,0,'','','1235460818.jpg','2009-02-24 10:25:31','',0,'N','8','2009-02-24','2010-12-12',0,'CSXU',0,'','','',124,'','28000.00','','','N','S','Y','10:25:25','23:27:28','Y','30000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235460818_2.jpg','1235460818_3.jpg','1235460818_4.jpg','28000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(8,NULL,'0.01','Y','N',8,0,'','','1235461059.jpg','2009-02-24 10:02:34','',0,'N','3','2009-02-24','2010-02-24',0,'WSIP',0,'','','',126,'1236035638','2500.01','','000293312333','N','S','Y','10:02:29','23:27:28','Y','3000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235461059_2.jpg','1235461059_3.jpg','1235461059_4.jpg','2500.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',1),(9,NULL,'0.15','Y','N',9,0,'','','1235461386.jpg','2009-02-24 10:21:31','',0,'N','3','2009-02-24','2010-1-24',0,'KQCL',0,'','','',156,'','1000.00','','','N','S','Y','10:21:27','21:28:28','Y','1000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235461386_2.jpg','1235461386_3.jpg','1235461386_4.jpg','1000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(10,NULL,'0.15','Y','N',10,0,'','','1235461872.jpg','2009-02-24 09:51:18','',0,'Y','8','2009-2-24','2010-2-24',0,'AISL',0,'','','',145,'1235847121','10000.00','28-02-2009 12:54:35','','N','S','Y','10:25:00','23:00:00','Y','12000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235461872_2.jpg','1235461872_3.jpg','1235461872_4.jpg','10000.00','S',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(11,NULL,'0.15','Y','N',11,0,'','','1235462126.jpg','2009-02-24 09:55:32','',0,'N','6','2009-2-24','2010-2-24',0,'AKWK',0,'','','',124,'','2000.00','','','N','S','Y','10:27:00','23:00:00','Y','3000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235462126_2.jpg','1235462126_3.jpg','1235462126_4.jpg','2000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(12,NULL,'0.15','Y','N',12,0,'','','1235463291.jpg','2009-02-24 10:14:56','',0,'N','6','2009-2-24','2010-2-24',0,'DKIG',0,'','','',156,'','400000.00','','','N','S','Y','10:36:28','23:12:18','Y','400000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235463291_2.jpg','1235463291_3.jpg','1235463291_4.jpg','400000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(13,NULL,'0.01','Y','N',13,0,'','','1235468442.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-24',0,'NKAI',0,'','','',125,'1236036180','3000.02','','000293312333','N','S','Y','12:06:27','22:28:28','Y','3000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235468442_2.jpg','1235468442_3.jpg','1235468442_4.jpg','3000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',2),(14,NULL,'0.01','Y','N',14,0,'','','1235468844.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-12',0,'IALA',0,'','','',155,'1236035669','150.02','','000293312333','N','S','Y','12:26:30','22:29:07','Y','200.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235468844_2.jpg','1235468844_3.jpg','1235468844_4.jpg','150.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',2),(15,NULL,'0.01','Y','N',15,0,'','','1235469036.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-12',0,'XAHI',0,'','','',129,'1236035634','300.03','','000293312333','N','S','Y','12:27:31','23:27:26','Y','350.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235469036_2.jpg','1235469036_3.jpg','1235469036_4.jpg','300.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',3),(16,NULL,'0.01','Y','N',16,0,'','','1235469255.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-2',0,'AXCF',0,'','','',145,'1236037047','5650.02','','000293312333','N','S','Y','12:22:28','21:56:29','Y','5600.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235469255_2.jpg','1235469255_3.jpg','1235469255_4.jpg','5650.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',2),(17,NULL,'0.15','Y','N',17,0,'','','1235469541.JPG','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-4',0,'QXGN',0,'','','',156,'','30.00','','','N','S','Y','12:27:27','23:50:44','Y','35.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235469541_2.jpg','1235469541_3.jpg','1235469541_4.jpg','30.00','S',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(18,NULL,'0.01','Y','N',18,0,'','','1235469811.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-4',0,'CACW',0,'','','',456,'','5500.00','','','N','S','Y','12:34:29','23:52:38','Y','5000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235469811_2.jpg','1235469811_3.jpg','1235469811_4.jpg','5500.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(19,NULL,'0.01','Y','N',19,0,'','','1235470069.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-12',0,'XADA',0,'','','',345,'','14500.00','','','N','S','Y','12:51:16','23:50:14','Y','15000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235470069_2.jpg','1235470069_3.jpg','1235470069_4.jpg','14500.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(20,NULL,'0.01','Y','N',20,0,'','','1235470421.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-23',0,'CLKX',0,'','','',345,'','4500.00','','','N','S','Y','12:58:30','23:24:06','N','5000.00',0,'N','1236020699',0,'N',0,'0.00','','','E','','','1235470421_2.jpg','1235470421_3.jpg','1235470421_4.jpg','4500.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(21,NULL,'0.15','Y','Y',21,0,'','','1235648244.jpg','2009-02-26 05:37:25','',0,'N','3','2009-02-27','2009-02-28',0,'TEST',0,'','','',30,'','10.00','','','N','S','N','18:00:00','17:00:00','N','100.00',0,'Y','',0,'N',0,'10.00','','','I','TEST','TEST','1235648537_2.php','','1235648537_4.php','10.00','S',1,'0.00','','',100,'N','-1',0,'Y','',0,'0.00',0),(22,NULL,'0.15','Y','Y',22,0,'','','1235648900.jpg','2009-02-26 05:48:20','',0,'N','7','2009-02-27','2009-02-28',0,'IPHO',0,'','','',30,'','10.00','','','N','S','N','01:00:00','01:18:00','N','400.00',0,'Y','',0,'N',0,'10.00','','','I','Apple iPhone 16GB','Apple iPhone 16GB','1235648900_2.jpg','1235648900_3.jpg','1235648900_4.php','10.00','S',1,'0.00','','',100,'N','-1',0,'','',0,'0.00',0),(23,NULL,'0.15','Y','N',23,0,'','','1235460330.jpg','2009-02-28 12:18:31','',0,'Y','7','2009-02-28','2009-02-28',0,'OMWA',0,'','','',100,'1235881265','233.00','28-02-2009 22:23:27','','N','S','Y','09:26:00','22:00:00','Y','23.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235650647_2.jpg','1235650647_3.jpg','1235650898_4.php','233.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(24,NULL,'0.15','Y','N',24,0,'','','1235460330.jpg','2009-02-28 08:42:29','',0,'Y','7','2009-02-28','2009-03-01',0,'ASAS',0,'','','',100,'1235968435','233.00','02-03-2009 02:30:22','','N','S','Y','07:26:00','22:00:00','Y','23.00',0,'Y','',0,'N',0,'0.00','','','I','','','','','1235651466_4.php','233.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(25,NULL,'0.10','Y','N',25,0,'','','1235676314.jpg','2009-02-26 15:26:10','',0,'Y','1','2009-02-26','2009-02-26',0,'1239',0,'','','',20,'1235683707','1.00','26-02-2009 15:29:01','1212','N','S','Y','15:26:00','15:33:00','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'20.00','','S',1,'N','-1',0,'','',0,'0.00',1),(26,'','0.10','Y','N',26,0,'','','1235683741.jpg','2009-02-26 15:29:07','',0,'Y','1','2009-02-26','2009-02-26',0,'ZDCM',0,'','','',20,'1235683938','1.10','26-02-2009 15:32:54','45645645645','N','S','Y','15:29:01','15:30:01','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235683741_2','1235683741_3','1235676541_4','1.00','B',1,'20.00','','S',0,'N','-1',0,'','',25,'0.00',1),(27,NULL,'0.10','Y','N',27,0,'','','1235676823.jpg','2009-02-26 15:35:04','',0,'Y','1','2009-02-26','2009-02-26',0,'123D',0,'','','',30,'1235684372','1.60','26-02-2009 15:40:13','1212','N','S','Y','15:35:00','15:39:00','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'30.00','','S',1,'N','-1',0,'','',0,'0.00',6),(28,'','0.10','Y','N',28,0,'','','1235684413.jpg','2009-02-26 15:40:16','',0,'Y','1','2009-02-26','2009-02-26',0,'AXCO',0,'','','',30,'1235695697','1.10','26-02-2009 19:59:35','1212','N','S','Y','15:40:13','15:44:13','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235684413_2','1235684413_3','1235677213_4','1.00','B',1,'30.00','','S',0,'N','-1',0,'','',27,'0.00',1),(29,NULL,'0.10','Y','N',29,0,'','','1235684413.jpg','2009-02-28 17:12:29','',0,'Y','1','2009-02-28','2009-02-28',0,'ICAA',0,'','','',30,'1235874932','1.10','28-02-2009 20:36:10','45645645645','N','S','Y','16:40:00','15:44:00','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235684413_2','1235684413_3','1235838715_4.php','1.00','B',1,'30.00','','S',0,'Y','-1',0,'','',0,'0.00',1),(30,NULL,'0.10','Y','N',30,0,'','','1235988207.jpg','2009-03-02 06:05:02','',0,'Y','1','2009-03-02','2009-03-02',0,'AAAA',0,'','','',30,'1235995598','1.30','02-03-2009 06:07:15','456456546','N','S','Y','06:05:00','06:06:00','Y','1111.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'100.00','','S',0,'N','1',0,'','',0,'0.00',3),(31,NULL,'0.10','Y','N',31,0,'','','1235988207.jpg','2009-03-02 06:12:04','',0,'Y','1','2009-03-02','2009-03-02',0,'AAAB',0,'','','',30,'1235995979','1.10','02-03-2009 06:13:37','1212','N','S','Y','06:12:00','06:13:00','Y','1111.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'100.00','','S',0,'N','-1',0,'','',0,'0.00',1),(32,NULL,'0.10','Y','N',32,0,'','','1236016542.jpg','2009-03-02 13:55:43','',0,'Y','1','2009-03-02','2009-03-02',0,'SSSS',0,'','','',30,'1236023846','1.10','02-03-2009 13:58:03','456456546','N','S','Y','13:55:00','13:57:00','Y','1000.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'1000.00','','S',0,'N','-1',0,'','',0,'0.00',1),(33,NULL,'0.01','Y','N',33,0,'','','1236020644.jpg','2009-03-02 15:04:08','',0,'N','1','2009-03-02','2009-03-31',0,'NCVD',0,'','','',20,'1236033586','0.01','','000293312333','N','S','Y','14:01:00','14:10:00','Y','399.00',0,'Y','1236020739',16,'N',0,'0.00','','','E','','','','','','0.00','B',1,'450.00','','S',0,'N','',0,'','',0,'0.00',1);
--
-- Table structure for table `bid_details`
--
j'ai supprimé le reste car c'était trop gros pour le forum
Merci de ta réponse mais ce que je comprendsp as c'est pourquoi sur un serveur héberger je n'ai pas le problème alors que sur un serveur en local avec easyphp j'ai ce problème.
Je te mais le contenu de mon fichier sql.sql qui crée tout de A à Z
Merci de ton aide
Script sql.sql :
-- MySQL dump 10.11
--
-- Host: localhost
-- ------------------------------------------------------
--
-- Table structure for table `account`
--
CREATE TABLE `account` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`amount` decimal(10,2) NOT NULL,
`payment_opt` enum('P','A') NOT NULL default 'P',
`status` enum('Y','N') NOT NULL default 'Y',
`deleted` enum('Y','N','P') NOT NULL default 'N',
`entrydate` varchar(20) NOT NULL default '',
`paystatus` enum('TRUE','FALSE','Pending') NOT NULL default 'Pending',
`order_id` int(11) NOT NULL default '0',
`transfer_status` enum('TRUE','FALSE') NOT NULL default 'FALSE',
`approved` enum('Y','N') NOT NULL default 'N',
`bid_cost` int(11) NOT NULL default '0',
`shipped` enum('Y','N') NOT NULL default 'N',
`item_id` int(11) NOT NULL,
`paytime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `account`
--
INSERT INTO `account` VALUES (1,104,'120.00','P','Y','N','2009-03-02 05:52:12','Pending',1235994732,'FALSE','N',4,'N',0,0),(2,104,'120.00','P','Y','N','2009-03-02 05:53:47','Pending',1235994827,'FALSE','N',4,'N',0,0),(3,104,'120.00','P','Y','N','2009-03-02 05:53:58','Pending',1235994838,'FALSE','N',4,'N',0,0),(4,104,'120.00','A','Y','N','2009-03-02 05:54:05','Pending',1235994845,'FALSE','N',4,'N',0,0),(5,107,'240.00','P','Y','N','2009-03-02 16:37:43','TRUE',1236033463,'TRUE','N',10,'N',0,0),(6,107,'240.00','P','Y','N','2009-03-02 16:38:03','TRUE',1236033483,'TRUE','N',10,'N',0,0),(7,107,'240.00','P','Y','N','2009-03-02 16:38:13','TRUE',1236033493,'TRUE','N',10,'N',0,0);
--
-- Table structure for table `add_bids`
--
CREATE TABLE `add_bids` (
`id` int(11) NOT NULL auto_increment,
`item_id` int(11) default NULL,
`user_id` int(11) default NULL,
`bid_rate` decimal(10,2) default NULL,
`bid_time` varchar(20) default NULL,
`city` varchar(50) default NULL,
`auction_code` varchar(4) NOT NULL default '',
`mobile_no` varchar(15) NOT NULL default '',
`bid_type` enum('S','A') NOT NULL default 'S',
`deleted` enum('Y','N') NOT NULL default 'N',
`bidbutler_type` enum('S','B') NOT NULL,
`smsid` varchar(50) NOT NULL,
`user_ip` varchar(20) NOT NULL,
`user_cookie` varchar(100) NOT NULL,
`bid_amt` decimal(10,2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `add_bids`
--
INSERT INTO `add_bids` VALUES (1,25,95,'1.10','2009-02-26 15:26:17','dfdf','1239','1212','A','N','S','','','','0.00'),(2,26,40,'1.10','2009-02-26 15:32:18','jaipur','ZDCM','45645645645','A','N','S','','','','0.00'),(3,27,104,'1.10','2009-02-26 15:36:18','sdsas','123D','00013453567','A','N','S','','','','0.00'),(4,27,95,'1.20','2009-02-26 15:38:06','dfdf','123D','1212','A','N','S','','','','0.00'),(5,27,104,'1.30','2009-02-26 15:39:17','sdsas','123D','00013453567','A','N','S','','','','0.00'),(6,27,40,'1.40','2009-02-26 15:39:22','jaipur','123D','45645645645','A','N','S','','','','0.00'),(7,27,104,'1.50','2009-02-26 15:39:29','sdsas','123D','00013453567','A','N','S','','','','0.00'),(8,27,95,'1.60','2009-02-26 15:39:32','dfdf','123D','1212','A','N','S','','','','0.00'),(9,28,95,'1.10','2009-02-26 18:48:17','dfdf','AXCO','1212','A','N','S','','','','0.00'),(10,29,40,'1.10','2009-02-28 20:35:31','jaipur','ICAA','45645645645','A','N','S','','','','0.00'),(11,15,105,'300.01','2009-03-02 05:06:02','SUNDERLAND','XAHI','07999691895','A','N','S','','','','0.00'),(12,16,105,'5650.01','2009-03-02 05:06:12','SUNDERLAND','AXCF','07999691895','A','N','S','','','','0.00'),(13,14,105,'150.01','2009-03-02 05:06:21','SUNDERLAND','IALA','07999691895','A','N','S','','','','0.00'),(14,13,105,'3000.01','2009-03-02 05:06:24','SUNDERLAND','NKAI','07999691895','A','N','S','','','','0.00'),(15,15,104,'300.02','2009-03-02 05:51:32','sdsas','XAHI','00013453567','A','N','S','','','','0.00'),(16,30,39,'1.10','2009-03-02 06:06:08','bkn','AAAA','456456546','A','N','S','','','','0.00'),(17,30,104,'1.20','2009-03-02 06:06:38','sdsas','AAAA','00013453567','A','N','S','','','','0.00'),(18,30,39,'1.30','2009-03-02 06:06:38','bkn','AAAA','456456546','A','N','S','','','','0.00'),(19,31,95,'1.10','2009-03-02 06:12:15','dfdf','AAAB','1212','A','N','S','','','','0.00'),(20,32,39,'1.10','2009-03-02 13:57:26','bkn','SSSS','456456546','A','N','S','','','','0.00'),(21,33,107,'0.01','2009-03-02 16:39:46','sofia','NCVD','000293312333','A','N','S','','','','0.00'),(22,1,107,'8000.01','2009-03-02 16:53:33','sofia','CGCS','000293312333','A','N','S','','','','0.00'),(23,15,107,'300.03','2009-03-02 17:13:54','sofia','XAHI','000293312333','A','N','S','','','','0.00'),(24,8,107,'2500.01','2009-03-02 17:13:58','sofia','WSIP','000293312333','A','N','S','','','','0.00'),(25,14,107,'150.02','2009-03-02 17:14:29','sofia','IALA','000293312333','A','N','S','','','','0.00'),(26,13,107,'3000.02','2009-03-02 17:23:00','sofia','NKAI','000293312333','A','N','B','','','','0.00'),(27,16,107,'5650.02','2009-03-02 17:37:27','sofia','AXCF','000293312333','A','N','S','','','','0.00');
--
-- Table structure for table `advert`
--
CREATE TABLE `advert` (
`advert_id` int(11) NOT NULL auto_increment,
`ad_image` varchar(100) default NULL,
`url` varchar(100) default NULL,
`start_date` date default NULL,
`end_date` date default NULL,
`no_clicks` int(11) default NULL,
`status` enum('Y','N') default NULL,
`deleted` enum('Y','N') default NULL,
`entrydate` date default NULL,
`category_sequence` int(11) NOT NULL default '0',
`lang` varchar(15) NOT NULL default '',
PRIMARY KEY (`advert_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `advert`
--
INSERT INTO `advert` VALUES (1,'upload_advert_images/advert_1236095570.gif','http://www.castorwin.com','2009-03-05','2009-03-08',0,'Y','N','0000-00-00',1,'';);
--
-- Table structure for table `amount_transfer`
--
CREATE TABLE `amount_transfer` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) default NULL,
`pay_type` varchar(20) default '',
`entrydate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`amount` int(11) default '0',
`credit` int(10) default '0',
`credit_type` varchar(10) NOT NULL default '',
`amount_type` varchar(20) NOT NULL,
`reason` tinytext NOT NULL,
`trans_type` enum('A','P','N') NOT NULL default 'N',
`deleted` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `amount_transfer`
--
INSERT INTO `amount_transfer` VALUES (1,95,'Debit','2009-02-26 21:26:17',1,0,'','','Bidding on auction','N','N'),(2,104,'Credit','2009-02-26 21:27:19',5,0,'C','R','Welcome Coupon','N','N'),(3,40,'Debit','2009-02-26 21:32:18',1,0,'','','Bidding on auction','N','N'),(4,104,'Debit','2009-02-26 21:36:18',1,0,'','','Bidding on auction','N','N'),(5,95,'Debit','2009-02-26 21:38:06',1,0,'','','Bidding on auction','N','N'),(6,104,'Debit','2009-02-26 21:39:17',1,0,'','','Bidding on auction','N','N'),(7,40,'Debit','2009-02-26 21:39:22',1,0,'','','Bidding on auction','N','N'),(8,104,'Debit','2009-02-26 21:39:29',1,0,'','','Bidding on auction','N','N'),(9,95,'Debit','2009-02-26 21:39:32',1,0,'','','Bidding on auction','N','N'),(10,95,'Debit','2009-02-27 00:48:17',1,0,'','','Bidding on auction','N','N'),(11,105,'Credit','2009-02-27 19:41:36',5,0,'C','R','Welcome Coupon','N','N'),(12,40,'Debit','2009-03-01 02:35:31',1,0,'','','Bidding on auction','N','N'),(13,105,'Debit','2009-03-02 11:06:02',1,0,'','','Bidding on auction','N','N'),(14,105,'Debit','2009-03-02 11:06:12',1,0,'','','Bidding on auction','N','N'),(15,105,'Debit','2009-03-02 11:06:21',1,0,'','','Bidding on auction','N','N'),(16,105,'Debit','2009-03-02 11:06:24',1,0,'','','Bidding on auction','N','N'),(17,104,'Debit','2009-03-02 11:51:32',1,0,'','','Bidding on auction','N','N'),(18,39,'Debit','2009-03-02 12:06:08',1,0,'','','Bidding on auction','N','N'),(19,104,'Debit','2009-03-02 12:06:38',1,0,'','','Bidding on auction','N','N'),(20,39,'Debit','2009-03-02 12:06:38',1,0,'','','Bidding on auction','N','N'),(21,95,'Debit','2009-03-02 12:12:15',1,0,'','','Bidding on auction','N','N'),(22,106,'Credit','2009-03-02 19:03:31',5,0,'C','R','Welcome Coupon','N','N'),(23,39,'Debit','2009-03-02 19:57:26',1,0,'','','Bidding on auction','N','N'),(24,107,'Credit','2009-03-02 21:58:48',5,0,'C','R','Welcome Coupon','N','N'),(25,107,'Debit','2009-03-02 22:39:46',1,0,'','','Bidding on auction','N','N'),(26,107,'Debit','2009-03-02 22:53:33',1,0,'','','Bidding on auction','N','N'),(27,107,'Credit','0000-00-00 00:00:00',240,0,'','','Bid Purchasing','N','N'),(28,107,'Debit','2009-03-02 23:13:54',1,0,'','','Bidding on auction','N','N'),(29,107,'Debit','2009-03-02 23:13:58',1,0,'','','Bidding on auction','N','N'),(30,107,'Debit','2009-03-02 23:14:29',1,0,'','','Bidding on auction','N','N'),(31,107,'Credit','0000-00-00 00:00:00',240,0,'','','Bid Purchasing','N','N'),(32,107,'Credit','0000-00-00 00:00:00',240,0,'','','Bid Purchasing','N','N'),(33,107,'Debit','2009-03-02 23:23:00',1,0,'','','Bidding on auction','N','N'),(34,107,'Debit','2009-03-02 23:37:27',1,0,'','','Bidding on auction','N','N'),(35,108,'Credit','2009-03-03 17:07:25',5,0,'C','R','Welcome Coupon','N','N');
--
-- Table structure for table `auto_bid`
--
CREATE TABLE `auto_bid` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`bid_from` decimal(10,2) NOT NULL default '0.00',
`bid_to` decimal(10,2) NOT NULL default '0.00',
`total_bid` int(11) NOT NULL,
`entrydate` varchar(20) default NULL,
`item_id` int(11) NOT NULL,
`status` enum('Y','N') NOT NULL default 'N',
`deleted` enum('Y','N') NOT NULL default 'N',
`counter` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `auto_bid`
--
INSERT INTO `auto_bid` VALUES (1,107,'0.02','0.09',3,'2009-03-02 16:41:46',33,'N','N',3),(2,107,'3000.02','3001.00',20,'2009-03-02 17:22:56',13,'Y','N',19);
--
-- Table structure for table `bid`
--
CREATE TABLE `bid` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(200) default NULL,
`bid_rate` decimal(10,2) default '0.00',
`status` enum('Y','N') default 'Y',
`deleted` enum('Y','N') NOT NULL default 'N',
`sequence` int(11) NOT NULL default '0',
`country` int(11) NOT NULL default '0',
`zipcode` varchar(15) NOT NULL default '',
`img_url` varchar(100) NOT NULL default '',
`image_path` varchar(100) NOT NULL default '',
`entrydate` varchar(20) NOT NULL default '',
`des` text NOT NULL,
`start_time` int(11) NOT NULL default '0',
`end_bid` enum('Y','E','S','N') NOT NULL default 'N',
`category` varchar(50) NOT NULL default '',
`sdate` varchar(15) NOT NULL default '',
`edate` varchar(15) NOT NULL default '',
`lang` int(3) NOT NULL default '0',
`auction_code` varchar(4) NOT NULL default '',
`hours` int(10) NOT NULL default '0',
`title_n` varchar(100) NOT NULL,
`short_description_n` text NOT NULL,
`des_n` text NOT NULL,
`extends_time` int(10) NOT NULL default '0',
`update_extend` varchar(20) NOT NULL default '',
`final_bid` decimal(10,2) NOT NULL default '0.00',
`end_time` varchar(20) NOT NULL default '',
`last_mobile` varchar(15) NOT NULL default '',
`homepage` enum('Y','N') NOT NULL default 'N',
`view_type` enum('E','L','S') NOT NULL default 'S',
`start` enum('Y','N') NOT NULL default 'N',
`start_auction` varchar(15) NOT NULL,
`end_auction` varchar(15) NOT NULL,
`running` enum('Y','N') NOT NULL default 'N',
`normal_rate` decimal(10,2) default '0.00',
`total_days` int(11) NOT NULL,
`start_pause` enum('Y','N') NOT NULL default 'N',
`start_pause_time` varchar(15) NOT NULL,
`pause_time` int(11) NOT NULL default '0',
`main_auction` enum('Y','N') NOT NULL default 'N',
`timer_value` int(10) NOT NULL default '0',
`delivery_cost` decimal(10,2) NOT NULL default '0.00',
`delivery_info` tinytext NOT NULL,
`delivery_info_n` tinytext NOT NULL,
`auction_type` varchar(100) NOT NULL,
`meta_description` tinytext NOT NULL,
`meta_keyword` tinytext NOT NULL,
`image_path2` varchar(200) NOT NULL,
`image_path3` varchar(200) NOT NULL,
`image_path4` varchar(200) NOT NULL,
`start_price` decimal(10,2) NOT NULL,
`delivery_condition` enum('S','B') NOT NULL default 'B',
`system_id` int(11) NOT NULL,
`target_price` decimal(10,2) NOT NULL default '0.00',
`robot_runtime` enum('E','D') NOT NULL,
`robot_system` enum('S','P') NOT NULL,
`quantity_stock` int(11) NOT NULL,
`mark_flag` enum('Y','N','C') NOT NULL default 'N',
`max_frequency` varchar(10) NOT NULL,
`sequenceid` int(11) NOT NULL,
`beginner_auction` enum('Y','N') NOT NULL default 'N',
`short_description` tinytext NOT NULL,
`parent_auction` int(11) NOT NULL default '0',
`fixed_price` decimal(10,2) NOT NULL,
`bid_counter` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bid`
--
INSERT INTO `bid` VALUES (1,NULL,'0.01','Y','N',1,0,'','','1235458989.jpg','2009-02-24 09:22:08','',0,'N','1','2009-2-24','2010-2-24',0,'CGCS',0,'','','',145,'1236034413','8000.01','','000293312333','N','S','Y','09:28:31','23:29:29','Y','10000.00',0,'Y','',0,'N',0,'8000.00','','','E','','','1235458989_2.jpg','1235458989_3.jpg','1235458989_4.jpg','8000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',1),(2,NULL,'0.15','Y','N',2,0,'','','1235459240.jpg','2009-02-24 09:22:08','',0,'N','2','2009-2-24','2009-12-12',0,'NLAS',0,'','','',125,'','15000.00','','','N','S','Y','10:29:31','22:29:25','Y','15000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235459240_2.jpg','1235459240_3.jpg','1235459240_4.jpg','15000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(3,NULL,'0.01','Y','N',3,0,'','','1235459522.jpg','2009-02-24 09:22:08','',0,'Y','1','2009-2-24','2009-10-12',0,'CXAU',0,'','','',145,'1235662192','24000.00','26-02-2009 10:35:46','','N','S','Y','10:32:00','23:27:00','Y','25000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235459522_2.jpg','1235459522_3.jpg','1235459522_4.jpg','24000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(4,NULL,'0.01','Y','N',4,0,'','','1235459737.jpg','2009-02-24 09:22:08','',0,'N','4','2009-2-24','2010-2-2',0,'SXIJ',0,'','','',145,'','14000.00','','','N','S','Y','10:13:27','23:29:29','Y','15000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235459737_2.jpg','1235459737_3.jpg','1235459737_4.jpg','14000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(5,NULL,'0.15','Y','N',5,0,'','','1235460067.jpg','2009-02-24 09:22:08','',0,'N','5','2009-2-24','2010-2-2',0,'OIXZ',0,'','','',124,'','10000.00','','','N','S','Y','10:29:28','23:29:29','Y','12000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235460067_2.jpg','1235460067_3.jpg','1235460067_4.jpg','10000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(6,NULL,'0.15','Y','N',6,0,'','','1235460330.jpg','2009-02-24 09:26:07','',0,'Y','7','2009-02-24','2009-02-24',0,'AAXG',0,'','','',100,'1235553924','233.00','25-02-2009 09:32:10','','N','S','Y','09:26:00','22:00:00','Y','23.00',0,'Y','',0,'N',0,'0.00','','','I','','','','','','233.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(7,NULL,'0.01','Y','N',7,0,'','','1235460818.jpg','2009-02-24 10:25:31','',0,'N','8','2009-02-24','2010-12-12',0,'CSXU',0,'','','',124,'','28000.00','','','N','S','Y','10:25:25','23:27:28','Y','30000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235460818_2.jpg','1235460818_3.jpg','1235460818_4.jpg','28000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(8,NULL,'0.01','Y','N',8,0,'','','1235461059.jpg','2009-02-24 10:02:34','',0,'N','3','2009-02-24','2010-02-24',0,'WSIP',0,'','','',126,'1236035638','2500.01','','000293312333','N','S','Y','10:02:29','23:27:28','Y','3000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235461059_2.jpg','1235461059_3.jpg','1235461059_4.jpg','2500.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',1),(9,NULL,'0.15','Y','N',9,0,'','','1235461386.jpg','2009-02-24 10:21:31','',0,'N','3','2009-02-24','2010-1-24',0,'KQCL',0,'','','',156,'','1000.00','','','N','S','Y','10:21:27','21:28:28','Y','1000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235461386_2.jpg','1235461386_3.jpg','1235461386_4.jpg','1000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(10,NULL,'0.15','Y','N',10,0,'','','1235461872.jpg','2009-02-24 09:51:18','',0,'Y','8','2009-2-24','2010-2-24',0,'AISL',0,'','','',145,'1235847121','10000.00','28-02-2009 12:54:35','','N','S','Y','10:25:00','23:00:00','Y','12000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235461872_2.jpg','1235461872_3.jpg','1235461872_4.jpg','10000.00','S',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(11,NULL,'0.15','Y','N',11,0,'','','1235462126.jpg','2009-02-24 09:55:32','',0,'N','6','2009-2-24','2010-2-24',0,'AKWK',0,'','','',124,'','2000.00','','','N','S','Y','10:27:00','23:00:00','Y','3000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235462126_2.jpg','1235462126_3.jpg','1235462126_4.jpg','2000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(12,NULL,'0.15','Y','N',12,0,'','','1235463291.jpg','2009-02-24 10:14:56','',0,'N','6','2009-2-24','2010-2-24',0,'DKIG',0,'','','',156,'','400000.00','','','N','S','Y','10:36:28','23:12:18','Y','400000.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235463291_2.jpg','1235463291_3.jpg','1235463291_4.jpg','400000.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(13,NULL,'0.01','Y','N',13,0,'','','1235468442.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-24',0,'NKAI',0,'','','',125,'1236036180','3000.02','','000293312333','N','S','Y','12:06:27','22:28:28','Y','3000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235468442_2.jpg','1235468442_3.jpg','1235468442_4.jpg','3000.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',2),(14,NULL,'0.01','Y','N',14,0,'','','1235468844.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-12',0,'IALA',0,'','','',155,'1236035669','150.02','','000293312333','N','S','Y','12:26:30','22:29:07','Y','200.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235468844_2.jpg','1235468844_3.jpg','1235468844_4.jpg','150.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',2),(15,NULL,'0.01','Y','N',15,0,'','','1235469036.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-12',0,'XAHI',0,'','','',129,'1236035634','300.03','','000293312333','N','S','Y','12:27:31','23:27:26','Y','350.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235469036_2.jpg','1235469036_3.jpg','1235469036_4.jpg','300.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',3),(16,NULL,'0.01','Y','N',16,0,'','','1235469255.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-2',0,'AXCF',0,'','','',145,'1236037047','5650.02','','000293312333','N','S','Y','12:22:28','21:56:29','Y','5600.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235469255_2.jpg','1235469255_3.jpg','1235469255_4.jpg','5650.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',2),(17,NULL,'0.15','Y','N',17,0,'','','1235469541.JPG','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-4',0,'QXGN',0,'','','',156,'','30.00','','','N','S','Y','12:27:27','23:50:44','Y','35.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235469541_2.jpg','1235469541_3.jpg','1235469541_4.jpg','30.00','S',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(18,NULL,'0.01','Y','N',18,0,'','','1235469811.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-4',0,'CACW',0,'','','',456,'','5500.00','','','N','S','Y','12:34:29','23:52:38','Y','5000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235469811_2.jpg','1235469811_3.jpg','1235469811_4.jpg','5500.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(19,NULL,'0.01','Y','N',19,0,'','','1235470069.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-12',0,'XADA',0,'','','',345,'','14500.00','','','N','S','Y','12:51:16','23:50:14','Y','15000.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235470069_2.jpg','1235470069_3.jpg','1235470069_4.jpg','14500.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(20,NULL,'0.01','Y','N',20,0,'','','1235470421.jpg','2009-02-24 12:16:45','',0,'N','6','2009-2-24','2010-2-23',0,'CLKX',0,'','','',345,'','4500.00','','','N','S','Y','12:58:30','23:24:06','N','5000.00',0,'N','1236020699',0,'N',0,'0.00','','','E','','','1235470421_2.jpg','1235470421_3.jpg','1235470421_4.jpg','4500.00','B',1,'0.00','','P',0,'N','-1',0,'','',0,'0.00',0),(21,NULL,'0.15','Y','Y',21,0,'','','1235648244.jpg','2009-02-26 05:37:25','',0,'N','3','2009-02-27','2009-02-28',0,'TEST',0,'','','',30,'','10.00','','','N','S','N','18:00:00','17:00:00','N','100.00',0,'Y','',0,'N',0,'10.00','','','I','TEST','TEST','1235648537_2.php','','1235648537_4.php','10.00','S',1,'0.00','','',100,'N','-1',0,'Y','',0,'0.00',0),(22,NULL,'0.15','Y','Y',22,0,'','','1235648900.jpg','2009-02-26 05:48:20','',0,'N','7','2009-02-27','2009-02-28',0,'IPHO',0,'','','',30,'','10.00','','','N','S','N','01:00:00','01:18:00','N','400.00',0,'Y','',0,'N',0,'10.00','','','I','Apple iPhone 16GB','Apple iPhone 16GB','1235648900_2.jpg','1235648900_3.jpg','1235648900_4.php','10.00','S',1,'0.00','','',100,'N','-1',0,'','',0,'0.00',0),(23,NULL,'0.15','Y','N',23,0,'','','1235460330.jpg','2009-02-28 12:18:31','',0,'Y','7','2009-02-28','2009-02-28',0,'OMWA',0,'','','',100,'1235881265','233.00','28-02-2009 22:23:27','','N','S','Y','09:26:00','22:00:00','Y','23.00',0,'Y','',0,'N',0,'0.00','','','I','','','1235650647_2.jpg','1235650647_3.jpg','1235650898_4.php','233.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(24,NULL,'0.15','Y','N',24,0,'','','1235460330.jpg','2009-02-28 08:42:29','',0,'Y','7','2009-02-28','2009-03-01',0,'ASAS',0,'','','',100,'1235968435','233.00','02-03-2009 02:30:22','','N','S','Y','07:26:00','22:00:00','Y','23.00',0,'Y','',0,'N',0,'0.00','','','I','','','','','1235651466_4.php','233.00','B',1,'0.00','','',0,'N','-1',0,'','',0,'0.00',0),(25,NULL,'0.10','Y','N',25,0,'','','1235676314.jpg','2009-02-26 15:26:10','',0,'Y','1','2009-02-26','2009-02-26',0,'1239',0,'','','',20,'1235683707','1.00','26-02-2009 15:29:01','1212','N','S','Y','15:26:00','15:33:00','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'20.00','','S',1,'N','-1',0,'','',0,'0.00',1),(26,'','0.10','Y','N',26,0,'','','1235683741.jpg','2009-02-26 15:29:07','',0,'Y','1','2009-02-26','2009-02-26',0,'ZDCM',0,'','','',20,'1235683938','1.10','26-02-2009 15:32:54','45645645645','N','S','Y','15:29:01','15:30:01','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235683741_2','1235683741_3','1235676541_4','1.00','B',1,'20.00','','S',0,'N','-1',0,'','',25,'0.00',1),(27,NULL,'0.10','Y','N',27,0,'','','1235676823.jpg','2009-02-26 15:35:04','',0,'Y','1','2009-02-26','2009-02-26',0,'123D',0,'','','',30,'1235684372','1.60','26-02-2009 15:40:13','1212','N','S','Y','15:35:00','15:39:00','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'30.00','','S',1,'N','-1',0,'','',0,'0.00',6),(28,'','0.10','Y','N',28,0,'','','1235684413.jpg','2009-02-26 15:40:16','',0,'Y','1','2009-02-26','2009-02-26',0,'AXCO',0,'','','',30,'1235695697','1.10','26-02-2009 19:59:35','1212','N','S','Y','15:40:13','15:44:13','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235684413_2','1235684413_3','1235677213_4','1.00','B',1,'30.00','','S',0,'N','-1',0,'','',27,'0.00',1),(29,NULL,'0.10','Y','N',29,0,'','','1235684413.jpg','2009-02-28 17:12:29','',0,'Y','1','2009-02-28','2009-02-28',0,'ICAA',0,'','','',30,'1235874932','1.10','28-02-2009 20:36:10','45645645645','N','S','Y','16:40:00','15:44:00','Y','100.00',0,'Y','',0,'N',0,'0.00','','','E','','','1235684413_2','1235684413_3','1235838715_4.php','1.00','B',1,'30.00','','S',0,'Y','-1',0,'','',0,'0.00',1),(30,NULL,'0.10','Y','N',30,0,'','','1235988207.jpg','2009-03-02 06:05:02','',0,'Y','1','2009-03-02','2009-03-02',0,'AAAA',0,'','','',30,'1235995598','1.30','02-03-2009 06:07:15','456456546','N','S','Y','06:05:00','06:06:00','Y','1111.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'100.00','','S',0,'N','1',0,'','',0,'0.00',3),(31,NULL,'0.10','Y','N',31,0,'','','1235988207.jpg','2009-03-02 06:12:04','',0,'Y','1','2009-03-02','2009-03-02',0,'AAAB',0,'','','',30,'1235995979','1.10','02-03-2009 06:13:37','1212','N','S','Y','06:12:00','06:13:00','Y','1111.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'100.00','','S',0,'N','-1',0,'','',0,'0.00',1),(32,NULL,'0.10','Y','N',32,0,'','','1236016542.jpg','2009-03-02 13:55:43','',0,'Y','1','2009-03-02','2009-03-02',0,'SSSS',0,'','','',30,'1236023846','1.10','02-03-2009 13:58:03','456456546','N','S','Y','13:55:00','13:57:00','Y','1000.00',0,'Y','',0,'N',0,'0.00','','','E','','','','','','1.00','B',1,'1000.00','','S',0,'N','-1',0,'','',0,'0.00',1),(33,NULL,'0.01','Y','N',33,0,'','','1236020644.jpg','2009-03-02 15:04:08','',0,'N','1','2009-03-02','2009-03-31',0,'NCVD',0,'','','',20,'1236033586','0.01','','000293312333','N','S','Y','14:01:00','14:10:00','Y','399.00',0,'Y','1236020739',16,'N',0,'0.00','','','E','','','','','','0.00','B',1,'450.00','','S',0,'N','',0,'','',0,'0.00',1);
--
-- Table structure for table `bid_details`
--
j'ai supprimé le reste car c'était trop gros pour le forum
Subject
Views
Written By
Posted
8111
April 02, 2010 08:32PM
3295
April 03, 2010 05:52AM
3513
April 03, 2010 11:21AM
2981
April 03, 2010 11:25AM
2942
April 03, 2010 11:17AM
Re: #1265 - Data truncated for column 'robot_runtime' at row 1
6542
April 04, 2010 01:41PM
3436
April 04, 2010 01:53PM
3323
April 04, 2010 03:26PM
5409
April 05, 2010 12:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.