loading....

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
CREATE TABLE IF NOT EXISTS `alipay_order` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `orderid` char(20) NOT NULL,
  `title` char(50) NOT NULL,
  `des` varchar(200) NOT NULL,
  `price` float NOT NULL,
  `type` tinyint(4) NOT NULL default '0',
  `alipayno` char(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `alipay_order` (`id`, `orderid`, `title`, `des`, `price`, `type`, `alipayno`) VALUES
(1, '7741248787', '苹果', '20千克', 0.01, 0, NULL);

 

posted on 2014-07-08 22:35  程序加载中  阅读(365)  评论(0编辑  收藏  举报