-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathama_h.sql
16 lines (11 loc) · 1.13 KB
/
ama_h.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
truncate table AMA_H;
insert into AMA_H (address_string_id, record_id, trans_id_create, trans_id_expire, linear_name_id, lo_num, lo_num_suf, hi_num, hi_num_suf, objectid)
values (602617, 2521590, 203925, 203963, 6598, 25, null, null, null, 17);
insert into AMA_H (address_string_id, record_id, trans_id_create, trans_id_expire, linear_name_id, lo_num, lo_num_suf, hi_num, hi_num_suf, objectid)
values (603071, 2523273, 204398, 204424, 6822, 144, null, null, null, 337);
insert into AMA_H (address_string_id, record_id, trans_id_create, trans_id_expire, linear_name_id, lo_num, lo_num_suf, hi_num, hi_num_suf, objectid)
values (604864, 2530029, 205949, 205955, 19083, 8, 'A', null, null, 657);
insert into AMA_H (address_string_id, record_id, trans_id_create, trans_id_expire, linear_name_id, lo_num, lo_num_suf, hi_num, hi_num_suf, objectid)
values (609213, 2557764, 211875, 211883, 9273, 137, 'R', null, null, 1297);
insert into AMA_H (address_string_id, record_id, trans_id_create, trans_id_expire, linear_name_id, lo_num, lo_num_suf, hi_num, hi_num_suf, objectid)
values (600196, 2509725, 200722, 200738, 5121, 1, 'A', 1, 'B', 1);