众筹支付出现你访问的页面不存在是什么问题,是不能用吗还是怎么拉,
支付宝接口做了,但是付宝审核中。是不是不能跳到那个支付页面还是什么问题?
project:
CREATE TABLE `aws_payment` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`uid` int(10) NOT NULL,
`amount` double NOT NULL,
`time` int(10) NOT NULL,
`note` varchar(255) DEFAULT NULL,
`order_id` bigint(16) NOT NULL,
`terrace_id` varchar(64) DEFAULT NULL,
`payment_id` varchar(16) DEFAULT '',
`source` varchar(16) NOT NULL DEFAULT '',
`extra_param` text,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `terrace_id` (`terrace_id`),
KEY `time` (`time`),
KEY `payment_id` (`payment_id`),
KEY `order_id` (`order_id`),
KEY `source` (`source`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aws_product_order` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`uid` int(10) NOT NULL,
`payment_order_id` bigint(16) NOT NULL DEFAULT '0',
`product_id` int(10) NOT NULL,
`project_id` int(10) NOT NULL,
`project_title` varchar(255) DEFAULT NULL,
`amount` decimal(10,2) NOT NULL,
`description` text,
`shipping_address` varchar(255) DEFAULT NULL,
`shipping_name` varchar(64) DEFAULT NULL,
`shipping_province` varchar(64) DEFAULT NULL,
`shipping_city` varchar(64) DEFAULT NULL,
`shipping_mobile` varchar(16) DEFAULT NULL,
`shipping_zipcode` int(10) DEFAULT NULL,
`add_time` int(10) NOT NULL DEFAULT '0',
`refund_time` int(10) NOT NULL DEFAULT '0',
`shipping_time` int(10) NOT NULL DEFAULT '0',
`is_donate` tinyint(1) NOT NULL DEFAULT '0',
`track_no` varchar(32) NOT NULL DEFAULT '',
`track_branch` varchar(64) NOT NULL DEFAULT '',
`note` text,
`payment_time` int(10) NOT NULL DEFAULT '0',
`product_title` varchar(255) NOT NULL DEFAULT '',
`cancel_time` int(10) NOT NULL DEFAULT '0',
`has_attach` tinyint(1) NOT NULL DEFAULT '0',
`address` varchar(255) DEFAULT NULL,
`project_type` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `product_id` (`product_id`),
KEY `project_id` (`project_id`),
KEY `payment_order_id` (`payment_order_id`),
KEY `track_no` (`track_no`),
KEY `is_donate` (`is_donate`),
KEY `refund_time` (`refund_time`),
KEY `add_time` (`add_time`),
KEY `payment_time` (`payment_time`),
KEY `cancel_time` (`cancel_time`),
KEY `project_type` (`project_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aws_project` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`open_notify` int( 10 ) NOT NULL DEFAULT '0',
`close_notify` int( 10 ) NOT NULL DEFAULT '0',
`uid` int(10) NOT NULL DEFAULT '0',
`category_id` int(10) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL,
`country` varchar(16) NOT NULL,
`province` varchar(16) NOT NULL,
`city` varchar(16) DEFAULT NULL,
`summary` text,
`description` text,
`start_time` int(10) NOT NULL DEFAULT '0',
`end_time` int(10) NOT NULL DEFAULT '0',
`amount` decimal(10,2) NOT NULL DEFAULT '0.00',
`contact` text,
`paid` decimal(10,2) NOT NULL DEFAULT '0.00',
`sponsored_users` int(10) NOT NULL DEFAULT '0',
`approved` tinyint(1) NOT NULL DEFAULT '0',
`views` int(10) NOT NULL DEFAULT '0',
`add_time` int(10) NOT NULL DEFAULT '0',
`update_time` int(10) NOT NULL DEFAULT '0',
`has_attach` tinyint(1) NOT NULL DEFAULT '0',
`topic_id` int(10) NOT NULL DEFAULT '0',
`discuss_count` int(10) NOT NULL DEFAULT '0',
`status` varchar(16) DEFAULT NULL,
`like_count` int(10) NOT NULL DEFAULT '0',
`video_link` varchar(255) NOT NULL DEFAULT '',
`project_type` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `open_notify` (`open_notify`),
KEY `close_notify` (`close_notify`),
KEY `category_id` (`category_id`),
KEY `title` (`title`),
KEY `country` (`country`),
KEY `province` (`province`),
KEY `city` (`city`),
KEY `start_time` (`start_time`),
KEY `end_time` (`end_time`),
KEY `amount` (`amount`),
KEY `paid` (`paid`),
KEY `approved` (`approved`),
KEY `uid` (`uid`),
KEY `add_time` (`add_time`),
KEY `views` (`views`),
KEY `update_time` (`update_time`),
KEY `discuss_count` (`discuss_count`),
KEY `sponsored_users` (`sponsored_users`),
KEY `status` (`status`),
KEY `like_count` (`like_count`),
KEY `project_type` (`project_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aws_project_product` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`amount` decimal(10,2) NOT NULL DEFAULT '0.00',
`stock` int(10) NOT NULL DEFAULT '0',
`description` text,
`project_id` int(10) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `amount` (`amount`),
KEY `project_id` (`project_id`),
KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aws_project_like` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`project_id` int(10) NOT NULL,
`uid` int(10) NOT NULL,
`add_time` int(10) NOT NULL,
PRIMARY KEY (`id`),
KEY `project_id` (`project_id`),
KEY `uid` (`uid`),
KEY `add_time` (`add_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('project_enabled', 's:1:"N";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('alipay_partner', 's:0:"";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('alipay_key', 's:0:"";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('alipay_seller_email', 's:0:"";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('alipay_sign_type', 's:3:"MD5";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('alipay_input_charset', 's:5:"utf-8";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('alipay_transport', 's:5:"https";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('alipay_private_key', 's:0:"";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('alipay_ali_public_key', 's:0:"";');
ticket:
CREATE TABLE `aws_ticket` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`priority` enum('low', 'normal', 'high', 'urgent') NOT NULL DEFAULT 'normal',
`status` enum('pending', 'closed') NOT NULL DEFAULT 'pending',
`uid` int(10) UNSIGNED NOT NULL DEFAULT 0,
`title` varchar(255) NOT NULL,
`message` text,
`time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`rating` enum('valid', 'invalid', 'undefined') NOT NULL DEFAULT 'undefined',
`service` int(10) UNSIGNED NOT NULL DEFAULT 0,
`ip` bigint(11) UNSIGNED DEFAULT NULL,
`source` enum('local', 'weibo', 'weixin', 'email') NOT NULL DEFAULT 'local',
`question_id` int(10) UNSIGNED DEFAULT NULL,
`weibo_msg_id` bigint(20) UNSIGNED DEFAULT NULL,
`received_email_id` int(10) UNSIGNED DEFAULT NULL,
`reply_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`close_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`has_attach` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `priority` (`priority`),
KEY `status` (`status`),
KEY `uid` (`uid`),
KEY `time` (`time`),
KEY `rating` (`rating`),
KEY `service` (`service`),
KEY `source` (`source`),
KEY `question_id` (`question_id`),
KEY `weibo_msg_id` (`weibo_msg_id`),
KEY `received_email_id` (`received_email_id`),
KEY `reply_time` (`reply_time`),
KEY `close_time` (`close_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aws_ticket_reply` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`ticket_id` int(10) UNSIGNED NOT NULL,
`message` text,
`uid` int(10) UNSIGNED NOT NULL DEFAULT 0,
`time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`ip` bigint(11) UNSIGNED DEFAULT NULL,
`has_attach` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `ticket_id` (`ticket_id`),
KEY `uid` (`uid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aws_ticket_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`ticket_id` int(10) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL DEFAULT 0,
`action` varchar(255) NOT NULL,
`data` text,
`time` int(10) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `ticket_id` (`ticket_id`),
KEY `uid` (`uid`),
KEY `action` (`action`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aws_ticket_invite` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`ticket_id` int(10) UNSIGNED NOT NULL,
`sender_uid` int(10) UNSIGNED NOT NULL DEFAULT 0,
`recipient_uid` int(10) UNSIGNED NOT NULL DEFAULT 0,
`time` int(10) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `ticket_id` (`ticket_id`),
KEY `sender_uid` (`sender_uid`),
KEY `recipient_uid` (`recipient_uid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('ticket_enabled', 's:1:"N";');
ALTER TABLE `aws_question` ADD `ticket_id` int(10) UNSIGNED DEFAULT NULL, ADD INDEX (`ticket_id`);
阅读全文
收起全文