| 1 | -- |
|---|
| 2 | -- Table structure for table `auction` |
|---|
| 3 | -- |
|---|
| 4 | |
|---|
| 5 | DROP TABLE IF EXISTS `auction`; |
|---|
| 6 | CREATE TABLE `auction` ( |
|---|
| 7 | `auction_id` bigint(20) unsigned NOT NULL auto_increment, |
|---|
| 8 | `seller_id` int(11) unsigned NOT NULL default '0', |
|---|
| 9 | `seller_name` varchar(30) NOT NULL default '', |
|---|
| 10 | `buyer_id` int(11) unsigned NOT NULL default '0', |
|---|
| 11 | `buyer_name` varchar(30) NOT NULL default '', |
|---|
| 12 | `price` int(11) unsigned NOT NULL default '0', |
|---|
| 13 | `buynow` int(11) unsigned NOT NULL default '0', |
|---|
| 14 | `hours` smallint(6) NOT NULL default '0', |
|---|
| 15 | `timestamp` int(11) unsigned NOT NULL default '0', |
|---|
| 16 | `nameid` int(11) unsigned NOT NULL default '0', |
|---|
| 17 | `item_name` varchar(50) NOT NULL default '', |
|---|
| 18 | `type` smallint(6) NOT NULL default '0', |
|---|
| 19 | `refine` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 20 | `attribute` tinyint(4) unsigned NOT NULL default '0', |
|---|
| 21 | `card0` smallint(11) NOT NULL default '0', |
|---|
| 22 | `card1` smallint(11) NOT NULL default '0', |
|---|
| 23 | `card2` smallint(11) NOT NULL default '0', |
|---|
| 24 | `card3` smallint(11) NOT NULL default '0', |
|---|
| 25 | PRIMARY KEY (`auction_id`) |
|---|
| 26 | ) ENGINE=MyISAM; |
|---|
