56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `activity` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL DEFAULT '',
`state` INT(10) NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
CREATE TABLE `ad_group` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL DEFAULT '',
`activity_id` INT(11) UNSIGNED NOT NULL,
`state` INT(10) NULL DEFAULT '0',
PRIMARY KEY (`id`),
INDEX `activity_id` (`activity_id`),
CONSTRAINT `FK_ad_group_activity` FOREIGN KEY (`activity_id`) REFERENCES `activity` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
)
ENGINE=InnoDB
CREATE TABLE `ad` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL DEFAULT '',
`group_id` INT(11) UNSIGNED NOT NULL,
`state` INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
INDEX `group_id` (`group_id`),
CONSTRAINT `ad_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `ad_group` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
)
ENGINE=InnoDB
INSERT INTO `activity` (`id`, `name`, `state`) VALUES (1, '第一次推广测试活动', 0), (2, '第二次推广测试活动', 0), (3, '第三次推广测试活动', 0);
INSERT INTO `ad_group` (`id`, `name`, `activity_id`, `state`) VALUES (1, '第一组', 1, 0), (2, '第二组', 1, 0), (3, '第三组', 1, 0), (4, '第四组', 2, 0), (5, '第五组', 2, 0), (6, '第六组', 3, 0), (7, '第七组', 3, 0);
INSERT INTO `ad` (`id`, `name`, `group_id`, `state`) VALUES (1, '广告1', 1, 0), (2, '广告2', 1, 0), (3, '广告3', 1, 0), (4, '广告4', 2, 0), (5, '广告5', 2, 0), (6, '广告6', 3, 0), (7, '广告7', 3, 0), (8, '广告8', 3, 0);