444
DROP TABLE IF EXISTS `wst_ad_positions`;
CREATE TABLE `wst_ad_positions` (
`positionld` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`positionType` tinyint(4) NOT NULL COMMENT '广告类型(1:电脑端2:微信端3:手机端4:app端5:小程序端)',
`positionName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '广告位置名称',
`positionWidth` int(11) NOT NULL COMMENT '建议宽度',
`positionHeight` int(11) NOT NULL COMMENT '建议高度',
`dataFlag` tinyint(4) NOT NULL COMMENT '有效状态(1:有效-1:无效)',
`positionCode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '广告位置代码(N/A)',
`apSort` int(11) NOT NULL COMMENT '排序号',
PRIMARY KEY (`positionld`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;