-
Notifications
You must be signed in to change notification settings - Fork 0
/
imooc-ad-init-data.sql
50 lines (32 loc) · 1.35 KB
/
imooc-ad-init-data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
--
-- init data for table `ad_user`
--
INSERT INTO `ad_user` VALUES (15,'qinyi','B2E56F2420D73FEC125D2D51641C5713',1,'2018-11-19 20:29:01','2018-11-19 20:29:01');
--
-- init data for table `ad_creative`
--
INSERT INTO `ad_creative` VALUES (10,'第一个创意',1,1,720,1080,1024,0,1,15,'https://www.imooc.com','2018-11-19 21:31:31','2018-11-19 21:31:31');
--
-- init data for table `ad_plan`
--
INSERT INTO `ad_plan` VALUES (10,15,'推广计划名称',1,'2018-11-28 00:00:00','2019-11-20 00:00:00','2018-11-19 20:42:27','2018-11-19 20:57:12');
--
-- init data for table `ad_unit`
--
INSERT INTO `ad_unit` VALUES (10,10,'第一个推广单元',1,1,10000000,'2018-11-20 11:43:26','2018-11-20 11:43:26'),(12,10,'第二个推广单元',1,1,15000000,'2018-01-01 00:00:00','2018-01-01 00:00:00');
--
-- init data for table `ad_unit_district`
--
INSERT INTO `ad_unit_district` VALUES (10,10,'安徽省','淮北市'),(11,10,'安徽省','宿州市'),(12,10,'安徽省','合肥市'),(14,10,'辽宁省','大连市');
--
-- init data for table `ad_unit_it`
--
INSERT INTO `ad_unit_it` VALUES (10,10,'台球'),(11,10,'游泳'),(12,10,'乒乓球');
--
-- init data for table `ad_unit_keyword`
--
INSERT INTO `ad_unit_keyword` VALUES (10,10,'宝马'),(11,10,'奥迪'),(12,10,'大众');
--
-- init data for table `creative_unit`
--
INSERT INTO `creative_unit` VALUES (10,10,10);