drop table if exists missorttest;

CREATE TABLE missorttest (
    pkid integer,
    hiercode character varying(1024),
    primary key (pkid)
);


COPY missorttest (pkid, hiercode) FROM stdin;
1	   1
2	   1   1
3	   1   2
4	   1   3
5	   1   4
6	   1   5
7	   1   6
8	   2
9	   2   1
10	   2   2
11	   2   3
12	   2   4
13	   2   5
14	   2   6
15	   2   7
16	   2   8
17	   2   9
18	   2  10
19	   2  11
20	   2  12
21	   2  13
22	   2  14
23	   2  15
24	   2  16
25	   2  17
26	   2  18
27	   2  19
28	   2  20
29	   2  21
30	   2  22
31	   2  23
32	   2  24
33	   2  25
34	   2  26
35	   2  27
36	   3
37	   3   1
38	   3   2
39	   3   3
40	   3   4
41	   4
42	   4   1
43	   4   2
44	   4   3
45	
\.

