testdata.sql
3.2 KB
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
49
50
--
-- 转存表中的数据 `__PREFIX__facrm_clues`
--
INSERT INTO `__PREFIX__facrm_clues` (`id`, `name`, `mobile`, `telephone`, `status`, `customer_id`, `change_time`, `level`, `industry`, `tags`, `source`, `remark`, `create_user_id`, `owner_user_id`, `user_id`, `ro_user_id`, `rw_user_id`, `province`, `city`, `area`, `detail_address`, `next_time`, `follow_time`, `create_time`, `update_time`, `delete_time`, `collect_time`) VALUES
(18, '移动公司', '13800138000', '', 1, 62, NULL, 3, 9, '', 1, '', 1, 1, 0, '', '', 0, 0, 0, '地址', 0, 1647857315, 1647857295, 1647857866, NULL, 1647857295);
-- --------------------------------------------------------
--
-- 转存表中的数据 `__PREFIX__facrm_customer`
--
INSERT INTO `__PREFIX__facrm_customer` (`id`, `name`, `mobile`, `telephone`, `deal_status`, `deal_time`, `is_lock`, `level`, `industry`, `tags`, `source`, `remark`, `create_user_id`, `owner_user_id`, `user_id`, `ro_user_id`, `rw_user_id`, `province`, `city`, `area`, `detail_address`, `lng`, `lat`, `next_time`, `follow_time`, `create_time`, `update_time`, `delete_time`, `collect_time`, `weixin`, `qq`) VALUES
(62, '移动公司', '13800138000', '', 0, NULL, 0, 3, 9, '', 1, '', 1, 1, 0, '', '', 0, 0, 0, '国际空港中心', NULL, NULL, 0, 1647857350, 1647857319, 1647857833, NULL, 1647857319, '', 0);
-- --------------------------------------------------------
--
-- 转存表中的数据 `__PREFIX__facrm_customer_contacts`
--
INSERT INTO `__PREFIX__facrm_customer_contacts` (`id`, `customer_id`, `name`, `mobile`, `birthday`, `telephone`, `wechat`, `email`, `decision`, `post`, `sex`, `detail_address`, `remark`, `ro_user_id`, `rw_user_id`, `create_user_id`, `owner_user_id`, `next_time`, `create_time`, `update_time`, `delete_time`) VALUES
(60, 62, '张总', '', NULL, '13800138000', '', '', -1, '', -1, '', '自动添加', '', '', 1, 1, NULL, 1647857319, 1647857319, NULL);
-- --------------------------------------------------------
--
-- 转存表中的数据 `__PREFIX__facrm_product`
--
INSERT INTO `__PREFIX__facrm_product` (`id`, `name`, `product_type_id`, `specification`, `sku`, `prop`, `inventory`, `min_warning`, `max_warning`, `price`, `remark`, `create_time`, `update_time`, `delete_time`, `product_unit_id`, `unit`, `status`) VALUES
(2, 'CRM高级版', 5, '1', 'DM112501', '[{\"title\":\"版本\",\"value\":\"高级版\"}]', 100, NULL, NULL, '10000.00', '', 1647857717, 1647857756, NULL, 3, '套', 1),
(3, 'CRM初级版', 5, '1', 'DM112502', '[{\"title\":\"版本\",\"value\":\"初级版本\"}]', 111, NULL, NULL, '5000.00', '', 1647857786, 1647857786, NULL, 3, '套', 1);
-- --------------------------------------------------------
INSERT INTO `__PREFIX__facrm_product_type` (`id`, `name`, `prop`, `create_time`, `update_time`, `delete_time`, `pid`, `image`, `weigh`) VALUES
(5, '软件', '[{\"title\":\"版本\"}]', 1647857591, 1647857664, NULL, 0, '', 50);
-- --------------------------------------------------------
--
-- 转存表中的数据 `__PREFIX__facrm_product_unit`
--
INSERT INTO `__PREFIX__facrm_product_unit` (`id`, `name`, `create_time`, `update_time`, `delete_time`) VALUES
(3, '套', 1647857615, 1647857670, NULL);
-- --------------------------------------------------------