php+アリペイ統合

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);