```[sql] CREATE TABLE `pre_payment` ( `payment_id` varchar(40) NOT NULL, `title` varchar(32) DEFAULT NULL, `setting` text, `available` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可用', `displayorder` mediumint(4) DEFAULT NULL COMMENT '显示顺序', `user_agent` varchar(128) DEFAULT NULL, PRIMARY KEY (`payment_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ```