MySQL建表语句

最新推荐文章于 2024-07-12 16:56:26 发布
zhuangbiqifei
最新推荐文章于 2024-07-12 16:56:26 发布
阅读量307
点赞数 5
文章标签： mysql android 数据库
本文链接：https://blog.csdn.net/zhuangbiqifei/article/details/138219921
版权
DDL8-23
CREATE TABLE `8attributes` (
  `attrld` int(11) NOT NULL AUTO_INCREMENT,
  `goodsCatld` int(11) DEFAULT '0',
  `gooodsCatPath` varchar(100) DEFAULT NULL,
  `attrName` varchar(100) DEFAULT NULL,
  `arreType` tinyint(4) DEFAULT '0',
  `attrVal` text NOT NULL,
  `attrSort` int(11) DEFAULT '0',
  `isShow` tinyint(4) NOT NULL DEFAULT '1',
  `dataFlag` tinyint(4) DEFAULT '1',
  `createTime` datetime DEFAULT NULL,
  `shopId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`attrld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `9banks` (
  `bankId` int(11) NOT NULL AUTO_INCREMENT,
  `bankName` varchar(50) NOT NULL,
  `dataFlag` tinyint(4) NOT NULL DEFAULT '1',
  `createTime` datetime NOT NULL,
  `bankImg` varchar(150) DEFAULT NULL,
  `isShow` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`bankId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `10brands` (
  `brandld` int(11) NOT NULL,
  `brandName` varchar(100) NOT NULL,
  `brandlmg` varchar(150) NOT NULL,
  `brandDesc` text,
  `createTime` datetime NOT NULL,
  `dataFllag` tinyint(4) NOT NULL DEFAULT '1',
  `sortNo` int(11) DEFAULT '0',
  PRIMARY KEY (`brandld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `11carts` (
  `cartld` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL DEFAULT '0',
  `isCheck` tinyint(4) NOT NULL DEFAULT '1',
  `goodsId` int(11) NOT NULL DEFAULT '0',
  `goodsSpecld` varchar(200) NOT NULL DEFAULT '0',
  `cartNum` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cartld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `12cash_configs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `targetType` tinyint(4) NOT NULL DEFAULT '0',
  `targetId` int(11) NOT NULL,
  `accType` tinyint(4) NOT NULL DEFAULT '0',
  `accTargetId` int(11) NOT NULL DEFAULT '0',
  `accAreaId` int(11) DEFAULT NULL,
  `accNo` varchar(100) NOT NULL,
  `accUser` varchar(100) NOT NULL,
  `dataFlag` tinyint(4) NOT NULL DEFAULT '1',
  `createTime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `13cash_draws` (
  `cashId` int(11) NOT NULL AUTO_INCREMENT,
  `cashNo` varchar(50) DEFAULT NULL,
  `targetType` tinyint(4) DEFAULT '0',
  `targetId` int(11) NOT NULL DEFAULT '0',
  `money` decimal(11,0) unsigned zerofill NOT NULL,
  `accType` tinyint(4) NOT NULL DEFAULT '0',
  `accTargetName` varchar(100) NOT NULL,
  `accAreaName` varchar(100) NOT NULL,
  `accNo` varchar(100) NOT NULL,
  `accUser` varchar(100) DEFAULT NULL,
  `cashSatus` tinyint(4) DEFAULT '0',
  `cashRemarks` varchar(255) NOT NULL,
  `cashConfigId` int(11) DEFAULT NULL,
  `createTime` datetime NOT NULL,
  `commission` decimal(11,0) DEFAULT NULL,
  `actualMoney` decimal(11,0) NOT NULL,
  `commissionRate` tinyint(4) NOT NULL DEFAULT '0',
  `sendData` text,
  `returnData` text,
  `returnMsg` varchar(300) DEFAULT NULL,
  `payTime` datetime DEFAULT NULL,
  `payNo` varchar(300) DEFAULT NULL,
  `accTargetId` int(11) DEFAULT '0',
  `payFee` int(11) DEFAULT '0',
  `incNo` int(11) DEFAULT '0',
  `queryData` text,
  `queryReturnData` text,
  PRIMARY KEY (`cashId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `8attributes` (
  `attrld` int(11) NOT NULL AUTO_INCREMENT,
  `goodsCatld` int(11) DEFAULT '0',
  `gooodsCatPath` varchar(100) DEFAULT NULL,
  `attrName` varchar(100) DEFAULT NULL,
  `arreType` tinyint(4) DEFAULT '0',
  `attrVal` text NOT NULL,
  `attrSort` int(11) DEFAULT '0',
  `isShow` tinyint(4) NOT NULL DEFAULT '1',
  `dataFlag` tinyint(4) DEFAULT '1',
  `createTime` datetime DEFAULT NULL,
  `shopId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`attrld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `14cat_brands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `catId` int(11) DEFAULT NULL,
  `brandId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `15cat_shops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopId` int(11) DEFAULT '0',
  `catId` int(11) DEFAULT '0',
  `commissionRate` decimal(11,0) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `16charge_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `chargeMoney` int(11) DEFAULT '0',
  `giveMoney` decimal(11,0) DEFAULT NULL,
  `itemSort` int(11) DEFAULT '0',
  `dataFlag` tinyint(4) DEFAULT '1',
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `17datas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `catId` int(11) NOT NULL DEFAULT '0',
  `dataName` varchar(255) NOT NULL,
  `dataVal` varchar(255) NOT NULL,
  `dataSort` int(11) NOT NULL DEFAULT '0',
  `dataFlag` tinyint(4) DEFAULT '1',
  `subCatId` int(11) DEFAULT '0',
  `subDataVal` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `18data_cats` (
  `catId` int(11) NOT NULL AUTO_INCREMENT,
  `catName` varchar(255) NOT NULL,
  `dataFlag` tinyint(4) DEFAULT '1',
  `carCode` varchar(255) NOT NULL,
  PRIMARY KEY (`catId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `19express` (
  `expressId` int(11) NOT NULL AUTO_INCREMENT,
  `expressName` varchar(50) NOT NULL,
  `dataFlag` tinyint(4) NOT NULL DEFAULT '1',
  `expressCode` varchar(50) DEFAULT NULL,
  `isShow` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`expressId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `20favorites` (
  `favoriteId` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL DEFAULT '0',
  `createTime` datetime NOT NULL,
  `goodsId` int(11) DEFAULT NULL,
  `curShopPrice` decimal(11,2) NOT NULL,
  PRIMARY KEY (`favoriteId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `21feedbacks` (
  `feedbackId` int(11) NOT NULL AUTO_INCREMENT,
  `feedbackType` int(4) NOT NULL DEFAULT '0',
  `userId` int(11) DEFAULT NULL,
  `createTime` datetime NOT NULL,
  `feetbackContent` text,
  `contactinfo` varchar(100) DEFAULT NULL,
  `dataFlag` tinyint(4) DEFAULT '0',
  `feedbackStatus` tinyint(4) DEFAULT '1',
  `staffId` int(11) DEFAULT '0',
  `handleTime` datetime DEFAULT NULL,
  `handleContent` text,
  PRIMARY KEY (`feedbackId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `22friendinks` (
  `friendinkId` int(11) NOT NULL AUTO_INCREMENT,
  `friendinkIco` varchar(150) DEFAULT NULL,
  `friendinkName` varchar(50) NOT NULL,
  `friendinkUrl` varchar(150) NOT NULL,
  `friendinkSort` int(11) NOT NULL DEFAULT '0',
  `dataFlag` tinyint(4) NOT NULL DEFAULT '1',
  `creataTime` datetime NOT NULL,
  PRIMARY KEY (`friendinkId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `23_1_goods` (
  `goodsId` int(11) NOT NULL AUTO_INCREMENT,
  `goodsSn` varchar(20) DEFAULT NULL,
  `productNo` varchar(20) DEFAULT NULL,
  `goodsName` varchar(200) DEFAULT NULL,
  `goodsImg` varchar(150) DEFAULT NULL,
  `shopId` int(11) DEFAULT NULL,
  `marketPrice` decimal(11,2) DEFAULT NULL,
  `shopPrice` decimal(11,2) DEFAULT NULL,
  `warnStock` int(11) DEFAULT '0',
  `goodsUnit` char(10) DEFAULT NULL,
  `goodsTips` text,
  PRIMARY KEY (`goodsId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `23_2_goods` (
  `saleNum` int(11) NOT NULL AUTO_INCREMENT,
  `saleTime` datetime DEFAULT NULL,
  `visitNum` int(11) DEFAULT '0',
  `isSpec` tinyint(4) DEFAULT '1',
  `gallery` text,
  `createTime` datetime DEFAULT NULL,
  `goodsType` tinyint(4) DEFAULT '0',
  `isDistribut` int(11) DEFAULT '0',
  `commission` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`saleNum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;