/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50528 Source Host : localhost:3306 Source Database : test Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2013-06-02 17:53:17 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `businesssales` -- ---------------------------- DROP TABLE IF EXISTS `businesssales`; CREATE TABLE `businesssales` ( `bID` int(10) unsigned NOT NULL AUTO_INCREMENT, `BusinessID` int(11) unsigned NOT NULL DEFAULT '0', `Text` varchar(128) DEFAULT '0', `Price` int(11) DEFAULT '0', `Available` int(11) NOT NULL DEFAULT '0', `Purchased` int(11) DEFAULT '0', `Type` int(11) DEFAULT '0', PRIMARY KEY (`bID`) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of businesssales -- ----------------------------