-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathnestedSets.backup
140 lines (100 loc) · 3.45 KB
/
nestedSets.backup
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.2.2
-- Dumped by pg_dump version 9.2.2
-- Started on 2013-01-13 00:23:01
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- TOC entry 170 (class 3079 OID 11727)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- TOC entry 1928 (class 0 OID 0)
-- Dependencies: 170
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 168 (class 1259 OID 16547)
-- Name: tree; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE tree (
id integer NOT NULL,
node character varying(100) NOT NULL,
lft numeric(3,0) NOT NULL,
rgt numeric(3,0) NOT NULL,
depth numeric(2,0)
);
ALTER TABLE public.tree OWNER TO postgres;
--
-- TOC entry 169 (class 1259 OID 16550)
-- Name: node_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE node_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.node_id_seq OWNER TO postgres;
--
-- TOC entry 1929 (class 0 OID 0)
-- Dependencies: 169
-- Name: node_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE node_id_seq OWNED BY tree.id;
--
-- TOC entry 1916 (class 2604 OID 16552)
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY tree ALTER COLUMN id SET DEFAULT nextval('node_id_seq'::regclass);
--
-- TOC entry 1930 (class 0 OID 0)
-- Dependencies: 169
-- Name: node_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('node_id_seq', 11, true);
--
-- TOC entry 1919 (class 0 OID 16547)
-- Dependencies: 168
-- Data for Name: tree; Type: TABLE DATA; Schema: public; Owner: postgres
--
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (1, 'Clothing', 1, 22, 0);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (2, 'Men''s', 2, 9, 1);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (4, 'Suits', 3, 8, 2);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (5, 'Slacks', 4, 5, 3);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (6, 'Jackets', 6, 7, 3);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (3, 'Women''s', 10, 21, 1);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (7, 'Dresses', 11, 16, 2);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (8, 'Skirts', 17, 18, 2);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (9, 'Blousses', 19, 20, 2);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (10, 'Evening Gowns', 12, 13, 3);
INSERT INTO tree (id, node, lft, rgt, depth) VALUES (11, 'Sun Dresses', 14, 15, 3);
--
-- TOC entry 1918 (class 2606 OID 16554)
-- Name: pknode; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY tree
ADD CONSTRAINT pknode PRIMARY KEY (id);
--
-- TOC entry 1927 (class 0 OID 0)
-- Dependencies: 6
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
-- Completed on 2013-01-13 00:23:01
--
-- PostgreSQL database dump complete
--