| By | Chris Done;Chris Done |
| At | 2013-03-01; 2013-03-01 |
| Title | Move SQL scripts to sql/ |
| Description |
Edit file README.md 33188 → 33188
1 1 ## Database setup
2 2 3 3 $ sudo su postgres --command 'createuser hpaste -P'
4 4 $ sudo su postgres --command 'createdb hpaste -O hpaste'
- 5 $ cat schema.sql | psql -U hpaste -h 127.0.0.1 -d hpaste
- 6 $ cat data.sql | psql -U hpaste -h 127.0.0.1 -d hpaste
+ 5 $ cat sql/schema.sql | psql -U hpaste -h 127.0.0.1 -d hpaste
+ 6 $ cat sql/data.sql | psql -U hpaste -h 127.0.0.1 -d hpaste
7 7 8 8 ## Configuration & Running
9 9 10 10 $ cp amelie.conf.sample amelie.conf
11 11 … … … … Remove file SQLCHANGES 33188
- 1 alter table report add created timestamp with time zone not null default now(); Remove file amelie.schema 33188
- 1 -- - 2 -- PostgreSQL database dump - 3 -- - 4 - 5 SET statement_timeout = 0; - 6 SET client_encoding = 'UTF8'; - 7 SET standard_conforming_strings = off; - 8 SET check_function_bodies = false; - 9 SET client_min_messages = warning; - 10 SET escape_string_warning = off; - 11 - 12 SET search_path = public, pg_catalog; - 13 - 14 SET default_tablespace = ''; - 15 - 16 SET default_with_oids = false; - 17 - 18 -- - 19 -- Name: channel; Type: TABLE; Schema: public; Owner: amelie; Tablespace: - 20 -- - 21 - 22 CREATE TABLE channel ( - 23 id integer NOT NULL, - 24 title character varying(28) NOT NULL - 25 ); - 26 - 27 - 28 ALTER TABLE public.channel OWNER TO amelie; - 29 - 30 -- - 31 -- Name: channel_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie - 32 -- - 33 - 34 CREATE SEQUENCE channel_id_seq - 35 START WITH 1 - 36 INCREMENT BY 1 - 37 NO MAXVALUE - 38 NO MINVALUE - 39 CACHE 1; - 40 - 41 - 42 ALTER TABLE public.channel_id_seq OWNER TO amelie; - 43 - 44 -- - 45 -- Name: channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie - 46 -- - 47 - 48 ALTER SEQUENCE channel_id_seq OWNED BY channel.id; - 49 - 50 - 51 -- - 52 -- Name: hint; Type: TABLE; Schema: public; Owner: amelie; Tablespace: - 53 -- - 54 - 55 CREATE TABLE hint ( - 56 id integer NOT NULL, - 57 paste integer, - 58 type text NOT NULL, - 59 content text NOT NULL - 60 ); - 61 - 62 - 63 ALTER TABLE public.hint OWNER TO amelie; - 64 - 65 -- - 66 -- Name: hint_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie - 67 -- - 68 - 69 CREATE SEQUENCE hint_id_seq - 70 START WITH 1 - 71 INCREMENT BY 1 - 72 NO MAXVALUE - 73 NO MINVALUE - 74 CACHE 1; - 75 - 76 - 77 ALTER TABLE public.hint_id_seq OWNER TO amelie; - 78 - 79 -- - 80 -- Name: hint_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie - 81 -- - 82 - 83 ALTER SEQUENCE hint_id_seq OWNED BY hint.id; - 84 - 85 - 86 -- - 87 -- Name: language; Type: TABLE; Schema: public; Owner: amelie; Tablespace: - 88 -- - 89 - 90 CREATE TABLE language ( - 91 id integer NOT NULL, - 92 name character varying(32) NOT NULL, - 93 title character varying(64) NOT NULL, - 94 ordinal integer DEFAULT 0 NOT NULL, - 95 visible boolean DEFAULT false NOT NULL - 96 ); - 97 - 98 - 99 ALTER TABLE public.language OWNER TO amelie; - 100 - 101 -- - 102 -- Name: language_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie - 103 -- - 104 - 105 CREATE SEQUENCE language_id_seq - 106 START WITH 1 - 107 INCREMENT BY 1 - 108 NO MAXVALUE - 109 NO MINVALUE - 110 CACHE 1; - 111 - 112 - 113 ALTER TABLE public.language_id_seq OWNER TO amelie; - 114 - 115 -- - 116 -- Name: language_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie - 117 -- - 118 - 119 ALTER SEQUENCE language_id_seq OWNED BY language.id; - 120 - 121 - 122 -- - 123 -- Name: paste; Type: TABLE; Schema: public; Owner: amelie; Tablespace: - 124 -- - 125 - 126 CREATE TABLE paste ( - 127 id integer NOT NULL, - 128 title character varying(512) NOT NULL, - 129 content text NOT NULL, - 130 tags text, - 131 author character varying(128) NOT NULL, - 132 created timestamp with time zone DEFAULT now() NOT NULL, - 133 views integer DEFAULT 0 NOT NULL, - 134 language integer, - 135 channel integer, - 136 annotation_of integer, - 137 expire timestamp with time zone, - 138 output text, - 139 public boolean DEFAULT true - 140 ); - 141 - 142 - 143 ALTER TABLE public.paste OWNER TO amelie; - 144 - 145 -- - 146 -- Name: paste_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie - 147 -- - 148 - 149 CREATE SEQUENCE paste_id_seq - 150 START WITH 1 - 151 INCREMENT BY 1 - 152 NO MAXVALUE - 153 NO MINVALUE - 154 CACHE 1; - 155 - 156 - 157 ALTER TABLE public.paste_id_seq OWNER TO amelie; - 158 - 159 -- - 160 -- Name: paste_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie - 161 -- - 162 - 163 ALTER SEQUENCE paste_id_seq OWNED BY paste.id; - 164 - 165 - 166 -- - 167 -- Name: public_paste; Type: VIEW; Schema: public; Owner: amelie - 168 -- - 169 - 170 CREATE VIEW public_paste AS - 171 SELECT paste.id, paste.title, paste.content, paste.author, paste.created, paste.views, paste.language, paste.channel, paste.annotation_of FROM paste WHERE paste.public; - 172 - 173 - 174 ALTER TABLE public.public_paste OWNER TO amelie; - 175 - 176 -- - 177 -- Name: public_toplevel_paste; Type: VIEW; Schema: public; Owner: amelie - 178 -- - 179 - 180 CREATE VIEW public_toplevel_paste AS - 181 SELECT public_paste.id, public_paste.title, public_paste.content, public_paste.author, public_paste.created, public_paste.views, public_paste.language, public_paste.channel, public_paste.annotation_of FROM public_paste WHERE (public_paste.annotation_of IS NULL); - 182 - 183 - 184 ALTER TABLE public.public_toplevel_paste OWNER TO amelie; - 185 - 186 -- - 187 -- Name: report; Type: TABLE; Schema: public; Owner: amelie; Tablespace: - 188 -- - 189 - 190 CREATE TABLE report ( - 191 id integer NOT NULL, - 192 paste integer NOT NULL, - 193 comments text NOT NULL, - 194 created timestamp with time zone DEFAULT now() NOT NULL - 195 ); - 196 - 197 - 198 ALTER TABLE public.report OWNER TO amelie; - 199 - 200 -- - 201 -- Name: report_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie - 202 -- - 203 - 204 CREATE SEQUENCE report_id_seq - 205 START WITH 1 - 206 INCREMENT BY 1 - 207 NO MAXVALUE - 208 NO MINVALUE - 209 CACHE 1; - 210 - 211 - 212 ALTER TABLE public.report_id_seq OWNER TO amelie; - 213 - 214 -- - 215 -- Name: report_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie - 216 -- - 217 - 218 ALTER SEQUENCE report_id_seq OWNED BY report.id; - 219 - 220 - 221 -- - 222 -- Name: step; Type: TABLE; Schema: public; Owner: amelie; Tablespace: - 223 -- - 224 - 225 CREATE TABLE step ( - 226 paste integer NOT NULL, - 227 step integer NOT NULL, - 228 content text NOT NULL - 229 ); - 230 - 231 - 232 ALTER TABLE public.step OWNER TO amelie; - 233 - 234 -- - 235 -- Name: toplevel_paste; Type: VIEW; Schema: public; Owner: amelie - 236 -- - 237 - 238 CREATE VIEW toplevel_paste AS - 239 SELECT paste.id, paste.title, paste.content, paste.tags, paste.author, paste.created, paste.views, paste.language, paste.channel, paste.annotation_of, paste.expire, paste.output, paste.public FROM paste WHERE (paste.annotation_of IS NULL); - 240 - 241 - 242 ALTER TABLE public.toplevel_paste OWNER TO amelie; - 243 - 244 -- - 245 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie - 246 -- - 247 - 248 ALTER TABLE channel ALTER COLUMN id SET DEFAULT nextval('channel_id_seq'::regclass); - 249 - 250 - 251 -- - 252 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie - 253 -- - 254 - 255 ALTER TABLE hint ALTER COLUMN id SET DEFAULT nextval('hint_id_seq'::regclass); - 256 - 257 - 258 -- - 259 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie - 260 -- - 261 - 262 ALTER TABLE language ALTER COLUMN id SET DEFAULT nextval('language_id_seq'::regclass); - 263 - 264 - 265 -- - 266 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie - 267 -- - 268 - 269 ALTER TABLE paste ALTER COLUMN id SET DEFAULT nextval('paste_id_seq'::regclass); - 270 - 271 - 272 -- - 273 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie - 274 -- - 275 - 276 ALTER TABLE report ALTER COLUMN id SET DEFAULT nextval('report_id_seq'::regclass); - 277 - 278 - 279 -- - 280 -- Name: channel_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: - 281 -- - 282 - 283 ALTER TABLE ONLY channel - 284 ADD CONSTRAINT channel_pkey PRIMARY KEY (id); - 285 - 286 - 287 -- - 288 -- Name: hint_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: - 289 -- - 290 - 291 ALTER TABLE ONLY hint - 292 ADD CONSTRAINT hint_pkey PRIMARY KEY (id); - 293 - 294 - 295 -- - 296 -- Name: language_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: - 297 -- - 298 - 299 ALTER TABLE ONLY language - 300 ADD CONSTRAINT language_pkey PRIMARY KEY (id); - 301 - 302 - 303 -- - 304 -- Name: paste_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: - 305 -- - 306 - 307 ALTER TABLE ONLY paste - 308 ADD CONSTRAINT paste_pkey PRIMARY KEY (id); - 309 - 310 - 311 -- - 312 -- Name: report_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: - 313 -- - 314 - 315 ALTER TABLE ONLY report - 316 ADD CONSTRAINT report_pkey PRIMARY KEY (id); - 317 - 318 - 319 -- - 320 -- Name: hint_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: amelie - 321 -- - 322 - 323 ALTER TABLE ONLY hint - 324 ADD CONSTRAINT hint_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id) ON UPDATE CASCADE ON DELETE CASCADE; - 325 - 326 - 327 -- - 328 -- Name: paste_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: amelie - 329 -- - 330 - 331 ALTER TABLE ONLY paste - 332 ADD CONSTRAINT paste_channel_fkey FOREIGN KEY (channel) REFERENCES channel(id); - 333 - 334 - 335 -- - 336 -- Name: paste_language_fkey; Type: FK CONSTRAINT; Schema: public; Owner: amelie - 337 -- - 338 - 339 ALTER TABLE ONLY paste - 340 ADD CONSTRAINT paste_language_fkey FOREIGN KEY (language) REFERENCES language(id); - 341 - 342 - 343 -- - 344 -- Name: report_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: amelie - 345 -- - 346 - 347 ALTER TABLE ONLY report - 348 ADD CONSTRAINT report_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id) ON UPDATE CASCADE ON DELETE CASCADE; - 349 - 350 - 351 -- - 352 -- Name: step_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: amelie - 353 -- - 354 - 355 ALTER TABLE ONLY step - 356 ADD CONSTRAINT step_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id); - 357 - 358 - 359 -- - 360 -- Name: public; Type: ACL; Schema: -; Owner: postgres - 361 -- - 362 - 363 REVOKE ALL ON SCHEMA public FROM PUBLIC; - 364 REVOKE ALL ON SCHEMA public FROM postgres; - 365 GRANT ALL ON SCHEMA public TO postgres; - 366 GRANT ALL ON SCHEMA public TO PUBLIC; - 367 - 368 - 369 -- - 370 -- PostgreSQL database dump complete - 371 -- - 372 Remove file data.sql 33188
- 1 -- - 2 -- PostgreSQL database dump - 3 -- - 4 - 5 SET statement_timeout = 0; - 6 SET client_encoding = 'UTF8'; - 7 SET standard_conforming_strings = off; - 8 SET check_function_bodies = false; - 9 SET client_min_messages = warning; - 10 SET escape_string_warning = off; - 11 - 12 SET search_path = public, pg_catalog; - 13 - 14 SET default_tablespace = ''; - 15 - 16 SET default_with_oids = false; - 17 - 18 -- - 19 -- Name: channel; Type: TABLE; Schema: public; Owner: amelie; Tablespace: - 20 -- - 21 - 22 CREATE TABLE channel ( - 23 id integer NOT NULL, - 24 title character varying(28) NOT NULL - 25 ); - 26 - 27 - 28 ALTER TABLE public.channel OWNER TO amelie; - 29 - 30 -- - 31 -- Name: channel_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie - 32 -- - 33 - 34 CREATE SEQUENCE channel_id_seq - 35 START WITH 1 - 36 INCREMENT BY 1 - 37 NO MAXVALUE - 38 NO MINVALUE - 39 CACHE 1; - 40 - 41 - 42 ALTER TABLE public.channel_id_seq OWNER TO amelie; - 43 - 44 -- - 45 -- Name: channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie - 46 -- - 47 - 48 ALTER SEQUENCE channel_id_seq OWNED BY channel.id; - 49 - 50 - 51 -- - 52 -- Name: channel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: amelie - 53 -- - 54 - 55 SELECT pg_catalog.setval('channel_id_seq', 24, true); - 56 - 57 - 58 -- - 59 -- Name: language; Type: TABLE; Schema: public; Owner: amelie; Tablespace: - 60 -- - 61 - 62 CREATE TABLE language ( - 63 id integer NOT NULL, - 64 name character varying(32) NOT NULL, - 65 title character varying(64) NOT NULL, - 66 ordinal integer DEFAULT 0 NOT NULL, - 67 visible boolean DEFAULT false NOT NULL - 68 ); - 69 - 70 - 71 ALTER TABLE public.language OWNER TO amelie; - 72 - 73 -- - 74 -- Name: language_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie - 75 -- - 76 - 77 CREATE SEQUENCE language_id_seq - 78 START WITH 1 - 79 INCREMENT BY 1 - 80 NO MAXVALUE - 81 NO MINVALUE - 82 CACHE 1; - 83 - 84 - 85 ALTER TABLE public.language_id_seq OWNER TO amelie; - 86 - 87 -- - 88 -- Name: language_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie - 89 -- - 90 - 91 ALTER SEQUENCE language_id_seq OWNED BY language.id; - 92 - 93 - 94 -- - 95 -- Name: language_id_seq; Type: SEQUENCE SET; Schema: public; Owner: amelie - 96 -- - 97 - 98 SELECT pg_catalog.setval('language_id_seq', 119, true); - 99 - 100 - 101 -- - 102 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie - 103 -- - 104 - 105 ALTER TABLE channel ALTER COLUMN id SET DEFAULT nextval('channel_id_seq'::regclass); - 106 - 107 - 108 -- - 109 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie - 110 -- - 111 - 112 ALTER TABLE language ALTER COLUMN id SET DEFAULT nextval('language_id_seq'::regclass); - 113 - 114 - 115 -- - 116 -- Data for Name: channel; Type: TABLE DATA; Schema: public; Owner: amelie - 117 -- - 118 - 119 COPY channel (id, title) FROM stdin; - 120 1 #haskell - 121 2 #xmonad - 122 3 #javascript - 123 4 #python - 124 5 #ruby - 125 6 #lisp - 126 7 #scala - 127 8 #agda - 128 9 #coffeescript - 129 10 #arc - 130 11 ##c - 131 12 #clojure - 132 13 #scheme - 133 14 ##prolog - 134 15 #emacs - 135 16 #hpaste - 136 17 #happs - 137 18 #fay - 138 19 #haskell-lens - 139 20 #ghc - 140 21 #hakyll - 141 22 #diagrams - 142 23 #haskell-mobile - 143 24 #idris - 144 \. - 145 - 146 - 147 -- - 148 -- Data for Name: language; Type: TABLE DATA; Schema: public; Owner: amelie - 149 -- - 150 - 151 COPY language (id, name, title, ordinal, visible) FROM stdin; - 152 14 d D 999 f - 153 27 xml XML 999 f - 154 32 actionscript 3 ActionScript 3 999 f - 155 47 css CSS 999 f - 156 71 irc logs IRC logs 999 f - 157 23 perl Perl 999 t - 158 8 javascript JavaScript 999 t - 159 19 lua Lua 999 t - 160 13 cpp C++ 999 t - 161 16 java Java 999 t - 162 22 objectivec Objective-C 999 t - 163 116 smalltalk Smalltalk 999 t - 164 117 cs C# 999 t - 165 29 sql SQL 999 t - 166 51 diff Diff 999 t - 167 10 bash Bash/shell 999 t - 168 1 haskell Haskell 0 t - 169 28 agda Agda (via Haskell) 1 t - 170 21 ocaml OCaml 2 t - 171 9 lisp Common Lisp 3 t - 172 114 lisp Emacs Lisp 3 t - 173 25 ruby Ruby 4 t - 174 24 prolog Prolog 5 t - 175 113 elisp Elisp 6 f - 176 26 scala Scala 3 t - 177 15 erlang Erlang 3 t - 178 18 literatehaskell Literate Haskell 3 t - 179 115 go Go 4 t - 180 4 python Python 4 t - 181 12 c C 999 t - 182 106 tex TeX 999 t - 183 118 scheme Scheme 5 t - 184 119 idris Idris 5 t - 185 \. - 186 - 187 - 188 -- - 189 -- Name: channel_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: - 190 -- - 191 - 192 ALTER TABLE ONLY channel - 193 ADD CONSTRAINT channel_pkey PRIMARY KEY (id); - 194 - 195 - 196 -- - 197 -- Name: language_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: - 198 -- - 199 - 200 ALTER TABLE ONLY language - 201 ADD CONSTRAINT language_pkey PRIMARY KEY (id); - 202 - 203 - 204 -- - 205 -- PostgreSQL database dump complete - 206 -- - 207 Remove file schema.sql 33188
- 1 -- - 2 -- PostgreSQL database dump - 3 -- - 4 - 5 SET statement_timeout = 0; - 6 SET client_encoding = 'UTF8'; - 7 SET standard_conforming_strings = off; - 8 SET check_function_bodies = false; - 9 SET client_min_messages = warning; - 10 SET escape_string_warning = off; - 11 - 12 SET search_path = public, pg_catalog; - 13 - 14 SET default_tablespace = ''; - 15 - 16 SET default_with_oids = false; - 17 - 18 -- - 19 -- Name: channel; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: - 20 -- - 21 - 22 CREATE TABLE channel ( - 23 id integer NOT NULL, - 24 title character varying(28) NOT NULL - 25 ); - 26 - 27 - 28 ALTER TABLE public.channel OWNER TO hpaste; - 29 - 30 -- - 31 -- Name: channel_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste - 32 -- - 33 - 34 CREATE SEQUENCE channel_id_seq - 35 START WITH 1 - 36 INCREMENT BY 1 - 37 NO MAXVALUE - 38 NO MINVALUE - 39 CACHE 1; - 40 - 41 - 42 ALTER TABLE public.channel_id_seq OWNER TO hpaste; - 43 - 44 -- - 45 -- Name: channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste - 46 -- - 47 - 48 ALTER SEQUENCE channel_id_seq OWNED BY channel.id; - 49 - 50 - 51 -- - 52 -- Name: hint; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: - 53 -- - 54 - 55 CREATE TABLE hint ( - 56 id integer NOT NULL, - 57 paste integer, - 58 type text NOT NULL, - 59 content text NOT NULL - 60 ); - 61 - 62 - 63 ALTER TABLE public.hint OWNER TO hpaste; - 64 - 65 -- - 66 -- Name: hint_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste - 67 -- - 68 - 69 CREATE SEQUENCE hint_id_seq - 70 START WITH 1 - 71 INCREMENT BY 1 - 72 NO MAXVALUE - 73 NO MINVALUE - 74 CACHE 1; - 75 - 76 - 77 ALTER TABLE public.hint_id_seq OWNER TO hpaste; - 78 - 79 -- - 80 -- Name: hint_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste - 81 -- - 82 - 83 ALTER SEQUENCE hint_id_seq OWNED BY hint.id; - 84 - 85 - 86 -- - 87 -- Name: language; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: - 88 -- - 89 - 90 CREATE TABLE language ( - 91 id integer NOT NULL, - 92 name character varying(32) NOT NULL, - 93 title character varying(64) NOT NULL, - 94 ordinal integer DEFAULT 0 NOT NULL, - 95 visible boolean DEFAULT false NOT NULL - 96 ); - 97 - 98 - 99 ALTER TABLE public.language OWNER TO hpaste; - 100 - 101 -- - 102 -- Name: language_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste - 103 -- - 104 - 105 CREATE SEQUENCE language_id_seq - 106 START WITH 1 - 107 INCREMENT BY 1 - 108 NO MAXVALUE - 109 NO MINVALUE - 110 CACHE 1; - 111 - 112 - 113 ALTER TABLE public.language_id_seq OWNER TO hpaste; - 114 - 115 -- - 116 -- Name: language_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste - 117 -- - 118 - 119 ALTER SEQUENCE language_id_seq OWNED BY language.id; - 120 - 121 - 122 -- - 123 -- Name: paste; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: - 124 -- - 125 - 126 CREATE TABLE paste ( - 127 id integer NOT NULL, - 128 title character varying(512) NOT NULL, - 129 content text NOT NULL, - 130 tags text, - 131 author character varying(128) NOT NULL, - 132 created timestamp with time zone DEFAULT now() NOT NULL, - 133 views integer DEFAULT 0 NOT NULL, - 134 language integer, - 135 channel integer, - 136 annotation_of integer, - 137 expire timestamp with time zone, - 138 output text, - 139 public boolean DEFAULT true, - 140 revision_of integer - 141 ); - 142 - 143 - 144 ALTER TABLE public.paste OWNER TO hpaste; - 145 - 146 -- - 147 -- Name: paste_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste - 148 -- - 149 - 150 CREATE SEQUENCE paste_id_seq - 151 START WITH 1 - 152 INCREMENT BY 1 - 153 NO MAXVALUE - 154 NO MINVALUE - 155 CACHE 1; - 156 - 157 - 158 ALTER TABLE public.paste_id_seq OWNER TO hpaste; - 159 - 160 -- - 161 -- Name: paste_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste - 162 -- - 163 - 164 ALTER SEQUENCE paste_id_seq OWNED BY paste.id; - 165 - 166 - 167 -- - 168 -- Name: public_paste; Type: VIEW; Schema: public; Owner: hpaste - 169 -- - 170 - 171 CREATE VIEW public_paste AS - 172 SELECT paste.id, paste.title, paste.content, paste.author, paste.created, paste.views, paste.language, paste.channel, paste.annotation_of, paste.revision_of FROM paste WHERE paste.public; - 173 - 174 - 175 ALTER TABLE public.public_paste OWNER TO hpaste; - 176 - 177 -- - 178 -- Name: public_toplevel_paste; Type: VIEW; Schema: public; Owner: hpaste - 179 -- - 180 - 181 CREATE VIEW public_toplevel_paste AS - 182 SELECT public_paste.id, public_paste.title, public_paste.content, public_paste.author, public_paste.created, public_paste.views, public_paste.language, public_paste.channel, public_paste.annotation_of, public_paste.revision_of FROM public_paste WHERE ((public_paste.annotation_of IS NULL) AND (public_paste.revision_of IS NULL)); - 183 - 184 - 185 ALTER TABLE public.public_toplevel_paste OWNER TO hpaste; - 186 - 187 -- - 188 -- Name: report; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: - 189 -- - 190 - 191 CREATE TABLE report ( - 192 id integer NOT NULL, - 193 paste integer NOT NULL, - 194 comments text NOT NULL, - 195 created timestamp with time zone DEFAULT now() NOT NULL - 196 ); - 197 - 198 - 199 ALTER TABLE public.report OWNER TO hpaste; - 200 - 201 -- - 202 -- Name: report_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste - 203 -- - 204 - 205 CREATE SEQUENCE report_id_seq - 206 START WITH 1 - 207 INCREMENT BY 1 - 208 NO MAXVALUE - 209 NO MINVALUE - 210 CACHE 1; - 211 - 212 - 213 ALTER TABLE public.report_id_seq OWNER TO hpaste; - 214 - 215 -- - 216 -- Name: report_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste - 217 -- - 218 - 219 ALTER SEQUENCE report_id_seq OWNED BY report.id; - 220 - 221 - 222 -- - 223 -- Name: step; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: - 224 -- - 225 - 226 CREATE TABLE step ( - 227 paste integer NOT NULL, - 228 step integer NOT NULL, - 229 content text NOT NULL - 230 ); - 231 - 232 - 233 ALTER TABLE public.step OWNER TO hpaste; - 234 - 235 -- - 236 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste - 237 -- - 238 - 239 ALTER TABLE channel ALTER COLUMN id SET DEFAULT nextval('channel_id_seq'::regclass); - 240 - 241 - 242 -- - 243 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste - 244 -- - 245 - 246 ALTER TABLE hint ALTER COLUMN id SET DEFAULT nextval('hint_id_seq'::regclass); - 247 - 248 - 249 -- - 250 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste - 251 -- - 252 - 253 ALTER TABLE language ALTER COLUMN id SET DEFAULT nextval('language_id_seq'::regclass); - 254 - 255 - 256 -- - 257 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste - 258 -- - 259 - 260 ALTER TABLE paste ALTER COLUMN id SET DEFAULT nextval('paste_id_seq'::regclass); - 261 - 262 - 263 -- - 264 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste - 265 -- - 266 - 267 ALTER TABLE report ALTER COLUMN id SET DEFAULT nextval('report_id_seq'::regclass); - 268 - 269 - 270 -- - 271 -- Name: channel_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: - 272 -- - 273 - 274 ALTER TABLE ONLY channel - 275 ADD CONSTRAINT channel_pkey PRIMARY KEY (id); - 276 - 277 - 278 -- - 279 -- Name: hint_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: - 280 -- - 281 - 282 ALTER TABLE ONLY hint - 283 ADD CONSTRAINT hint_pkey PRIMARY KEY (id); - 284 - 285 - 286 -- - 287 -- Name: language_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: - 288 -- - 289 - 290 ALTER TABLE ONLY language - 291 ADD CONSTRAINT language_pkey PRIMARY KEY (id); - 292 - 293 - 294 -- - 295 -- Name: paste_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: - 296 -- - 297 - 298 ALTER TABLE ONLY paste - 299 ADD CONSTRAINT paste_pkey PRIMARY KEY (id); - 300 - 301 - 302 -- - 303 -- Name: report_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: - 304 -- - 305 - 306 ALTER TABLE ONLY report - 307 ADD CONSTRAINT report_pkey PRIMARY KEY (id); - 308 - 309 - 310 -- - 311 -- Name: paste_author_index; Type: INDEX; Schema: public; Owner: hpaste; Tablespace: - 312 -- - 313 - 314 CREATE INDEX paste_author_index ON paste USING btree (author); - 315 - 316 - 317 -- - 318 -- Name: paste_date_index; Type: INDEX; Schema: public; Owner: hpaste; Tablespace: - 319 -- - 320 - 321 CREATE INDEX paste_date_index ON paste USING btree (created); - 322 - 323 - 324 -- - 325 -- Name: paste_title_index; Type: INDEX; Schema: public; Owner: hpaste; Tablespace: - 326 -- - 327 - 328 CREATE INDEX paste_title_index ON paste USING btree (title); - 329 - 330 - 331 -- - 332 -- Name: hint_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste - 333 -- - 334 - 335 ALTER TABLE ONLY hint - 336 ADD CONSTRAINT hint_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id) ON UPDATE CASCADE ON DELETE CASCADE; - 337 - 338 - 339 -- - 340 -- Name: paste_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste - 341 -- - 342 - 343 ALTER TABLE ONLY paste - 344 ADD CONSTRAINT paste_channel_fkey FOREIGN KEY (channel) REFERENCES channel(id); - 345 - 346 - 347 -- - 348 -- Name: paste_language_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste - 349 -- - 350 - 351 ALTER TABLE ONLY paste - 352 ADD CONSTRAINT paste_language_fkey FOREIGN KEY (language) REFERENCES language(id); - 353 - 354 - 355 -- - 356 -- Name: paste_revision_of_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste - 357 -- - 358 - 359 ALTER TABLE ONLY paste - 360 ADD CONSTRAINT paste_revision_of_fkey FOREIGN KEY (revision_of) REFERENCES paste(id) ON DELETE CASCADE; - 361 - 362 - 363 -- - 364 -- Name: report_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste - 365 -- - 366 - 367 ALTER TABLE ONLY report - 368 ADD CONSTRAINT report_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id) ON UPDATE CASCADE ON DELETE CASCADE; - 369 - 370 - 371 -- - 372 -- Name: step_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste - 373 -- - 374 - 375 ALTER TABLE ONLY step - 376 ADD CONSTRAINT step_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id); - 377 - 378 - 379 -- - 380 -- Name: public; Type: ACL; Schema: -; Owner: postgres - 381 -- - 382 - 383 REVOKE ALL ON SCHEMA public FROM PUBLIC; - 384 REVOKE ALL ON SCHEMA public FROM postgres; - 385 GRANT ALL ON SCHEMA public TO postgres; - 386 GRANT ALL ON SCHEMA public TO PUBLIC; - 387 - 388 - 389 -- - 390 -- PostgreSQL database dump complete - 391 -- - 392 Add file sql/data.sql 33188
+ 1 -- + 2 -- PostgreSQL database dump + 3 -- + 4 + 5 SET statement_timeout = 0; + 6 SET client_encoding = 'UTF8'; + 7 SET standard_conforming_strings = off; + 8 SET check_function_bodies = false; + 9 SET client_min_messages = warning; + 10 SET escape_string_warning = off; + 11 + 12 SET search_path = public, pg_catalog; + 13 + 14 SET default_tablespace = ''; + 15 + 16 SET default_with_oids = false; + 17 + 18 -- + 19 -- Name: channel; Type: TABLE; Schema: public; Owner: amelie; Tablespace: + 20 -- + 21 + 22 CREATE TABLE channel ( + 23 id integer NOT NULL, + 24 title character varying(28) NOT NULL + 25 ); + 26 + 27 + 28 ALTER TABLE public.channel OWNER TO amelie; + 29 + 30 -- + 31 -- Name: channel_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie + 32 -- + 33 + 34 CREATE SEQUENCE channel_id_seq + 35 START WITH 1 + 36 INCREMENT BY 1 + 37 NO MAXVALUE + 38 NO MINVALUE + 39 CACHE 1; + 40 + 41 + 42 ALTER TABLE public.channel_id_seq OWNER TO amelie; + 43 + 44 -- + 45 -- Name: channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie + 46 -- + 47 + 48 ALTER SEQUENCE channel_id_seq OWNED BY channel.id; + 49 + 50 + 51 -- + 52 -- Name: channel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: amelie + 53 -- + 54 + 55 SELECT pg_catalog.setval('channel_id_seq', 24, true); + 56 + 57 + 58 -- + 59 -- Name: language; Type: TABLE; Schema: public; Owner: amelie; Tablespace: + 60 -- + 61 + 62 CREATE TABLE language ( + 63 id integer NOT NULL, + 64 name character varying(32) NOT NULL, + 65 title character varying(64) NOT NULL, + 66 ordinal integer DEFAULT 0 NOT NULL, + 67 visible boolean DEFAULT false NOT NULL + 68 ); + 69 + 70 + 71 ALTER TABLE public.language OWNER TO amelie; + 72 + 73 -- + 74 -- Name: language_id_seq; Type: SEQUENCE; Schema: public; Owner: amelie + 75 -- + 76 + 77 CREATE SEQUENCE language_id_seq + 78 START WITH 1 + 79 INCREMENT BY 1 + 80 NO MAXVALUE + 81 NO MINVALUE + 82 CACHE 1; + 83 + 84 + 85 ALTER TABLE public.language_id_seq OWNER TO amelie; + 86 + 87 -- + 88 -- Name: language_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amelie + 89 -- + 90 + 91 ALTER SEQUENCE language_id_seq OWNED BY language.id; + 92 + 93 + 94 -- + 95 -- Name: language_id_seq; Type: SEQUENCE SET; Schema: public; Owner: amelie + 96 -- + 97 + 98 SELECT pg_catalog.setval('language_id_seq', 119, true); + 99 + 100 + 101 -- + 102 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie + 103 -- + 104 + 105 ALTER TABLE channel ALTER COLUMN id SET DEFAULT nextval('channel_id_seq'::regclass); + 106 + 107 + 108 -- + 109 -- Name: id; Type: DEFAULT; Schema: public; Owner: amelie + 110 -- + 111 + 112 ALTER TABLE language ALTER COLUMN id SET DEFAULT nextval('language_id_seq'::regclass); + 113 + 114 + 115 -- + 116 -- Data for Name: channel; Type: TABLE DATA; Schema: public; Owner: amelie + 117 -- + 118 + 119 COPY channel (id, title) FROM stdin; + 120 1 #haskell + 121 2 #xmonad + 122 3 #javascript + 123 4 #python + 124 5 #ruby + 125 6 #lisp + 126 7 #scala + 127 8 #agda + 128 9 #coffeescript + 129 10 #arc + 130 11 ##c + 131 12 #clojure + 132 13 #scheme + 133 14 ##prolog + 134 15 #emacs + 135 16 #hpaste + 136 17 #happs + 137 18 #fay + 138 19 #haskell-lens + 139 20 #ghc + 140 21 #hakyll + 141 22 #diagrams + 142 23 #haskell-mobile + 143 24 #idris + 144 \. + 145 + 146 + 147 -- + 148 -- Data for Name: language; Type: TABLE DATA; Schema: public; Owner: amelie + 149 -- + 150 + 151 COPY language (id, name, title, ordinal, visible) FROM stdin; + 152 14 d D 999 f + 153 27 xml XML 999 f + 154 32 actionscript 3 ActionScript 3 999 f + 155 47 css CSS 999 f + 156 71 irc logs IRC logs 999 f + 157 23 perl Perl 999 t + 158 8 javascript JavaScript 999 t + 159 19 lua Lua 999 t + 160 13 cpp C++ 999 t + 161 16 java Java 999 t + 162 22 objectivec Objective-C 999 t + 163 116 smalltalk Smalltalk 999 t + 164 117 cs C# 999 t + 165 29 sql SQL 999 t + 166 51 diff Diff 999 t + 167 10 bash Bash/shell 999 t + 168 1 haskell Haskell 0 t + 169 28 agda Agda (via Haskell) 1 t + 170 21 ocaml OCaml 2 t + 171 9 lisp Common Lisp 3 t + 172 114 lisp Emacs Lisp 3 t + 173 25 ruby Ruby 4 t + 174 24 prolog Prolog 5 t + 175 113 elisp Elisp 6 f + 176 26 scala Scala 3 t + 177 15 erlang Erlang 3 t + 178 18 literatehaskell Literate Haskell 3 t + 179 115 go Go 4 t + 180 4 python Python 4 t + 181 12 c C 999 t + 182 106 tex TeX 999 t + 183 118 scheme Scheme 5 t + 184 119 idris Idris 5 t + 185 \. + 186 + 187 + 188 -- + 189 -- Name: channel_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: + 190 -- + 191 + 192 ALTER TABLE ONLY channel + 193 ADD CONSTRAINT channel_pkey PRIMARY KEY (id); + 194 + 195 + 196 -- + 197 -- Name: language_pkey; Type: CONSTRAINT; Schema: public; Owner: amelie; Tablespace: + 198 -- + 199 + 200 ALTER TABLE ONLY language + 201 ADD CONSTRAINT language_pkey PRIMARY KEY (id); + 202 + 203 + 204 -- + 205 -- PostgreSQL database dump complete + 206 -- + 207 Add file sql/schema.sql 33188
+ 1 -- + 2 -- PostgreSQL database dump + 3 -- + 4 + 5 SET statement_timeout = 0; + 6 SET client_encoding = 'UTF8'; + 7 SET standard_conforming_strings = off; + 8 SET check_function_bodies = false; + 9 SET client_min_messages = warning; + 10 SET escape_string_warning = off; + 11 + 12 SET search_path = public, pg_catalog; + 13 + 14 SET default_tablespace = ''; + 15 + 16 SET default_with_oids = false; + 17 + 18 -- + 19 -- Name: channel; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: + 20 -- + 21 + 22 CREATE TABLE channel ( + 23 id integer NOT NULL, + 24 title character varying(28) NOT NULL + 25 ); + 26 + 27 + 28 ALTER TABLE public.channel OWNER TO hpaste; + 29 + 30 -- + 31 -- Name: channel_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste + 32 -- + 33 + 34 CREATE SEQUENCE channel_id_seq + 35 START WITH 1 + 36 INCREMENT BY 1 + 37 NO MAXVALUE + 38 NO MINVALUE + 39 CACHE 1; + 40 + 41 + 42 ALTER TABLE public.channel_id_seq OWNER TO hpaste; + 43 + 44 -- + 45 -- Name: channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste + 46 -- + 47 + 48 ALTER SEQUENCE channel_id_seq OWNED BY channel.id; + 49 + 50 + 51 -- + 52 -- Name: hint; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: + 53 -- + 54 + 55 CREATE TABLE hint ( + 56 id integer NOT NULL, + 57 paste integer, + 58 type text NOT NULL, + 59 content text NOT NULL + 60 ); + 61 + 62 + 63 ALTER TABLE public.hint OWNER TO hpaste; + 64 + 65 -- + 66 -- Name: hint_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste + 67 -- + 68 + 69 CREATE SEQUENCE hint_id_seq + 70 START WITH 1 + 71 INCREMENT BY 1 + 72 NO MAXVALUE + 73 NO MINVALUE + 74 CACHE 1; + 75 + 76 + 77 ALTER TABLE public.hint_id_seq OWNER TO hpaste; + 78 + 79 -- + 80 -- Name: hint_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste + 81 -- + 82 + 83 ALTER SEQUENCE hint_id_seq OWNED BY hint.id; + 84 + 85 + 86 -- + 87 -- Name: language; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: + 88 -- + 89 + 90 CREATE TABLE language ( + 91 id integer NOT NULL, + 92 name character varying(32) NOT NULL, + 93 title character varying(64) NOT NULL, + 94 ordinal integer DEFAULT 0 NOT NULL, + 95 visible boolean DEFAULT false NOT NULL + 96 ); + 97 + 98 + 99 ALTER TABLE public.language OWNER TO hpaste; + 100 + 101 -- + 102 -- Name: language_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste + 103 -- + 104 + 105 CREATE SEQUENCE language_id_seq + 106 START WITH 1 + 107 INCREMENT BY 1 + 108 NO MAXVALUE + 109 NO MINVALUE + 110 CACHE 1; + 111 + 112 + 113 ALTER TABLE public.language_id_seq OWNER TO hpaste; + 114 + 115 -- + 116 -- Name: language_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste + 117 -- + 118 + 119 ALTER SEQUENCE language_id_seq OWNED BY language.id; + 120 + 121 + 122 -- + 123 -- Name: paste; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: + 124 -- + 125 + 126 CREATE TABLE paste ( + 127 id integer NOT NULL, + 128 title character varying(512) NOT NULL, + 129 content text NOT NULL, + 130 tags text, + 131 author character varying(128) NOT NULL, + 132 created timestamp with time zone DEFAULT now() NOT NULL, + 133 views integer DEFAULT 0 NOT NULL, + 134 language integer, + 135 channel integer, + 136 annotation_of integer, + 137 expire timestamp with time zone, + 138 output text, + 139 public boolean DEFAULT true, + 140 revision_of integer + 141 ); + 142 + 143 + 144 ALTER TABLE public.paste OWNER TO hpaste; + 145 + 146 -- + 147 -- Name: paste_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste + 148 -- + 149 + 150 CREATE SEQUENCE paste_id_seq + 151 START WITH 1 + 152 INCREMENT BY 1 + 153 NO MAXVALUE + 154 NO MINVALUE + 155 CACHE 1; + 156 + 157 + 158 ALTER TABLE public.paste_id_seq OWNER TO hpaste; + 159 + 160 -- + 161 -- Name: paste_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste + 162 -- + 163 + 164 ALTER SEQUENCE paste_id_seq OWNED BY paste.id; + 165 + 166 + 167 -- + 168 -- Name: public_paste; Type: VIEW; Schema: public; Owner: hpaste + 169 -- + 170 + 171 CREATE VIEW public_paste AS + 172 SELECT paste.id, paste.title, paste.content, paste.author, paste.created, paste.views, paste.language, paste.channel, paste.annotation_of, paste.revision_of FROM paste WHERE paste.public; + 173 + 174 + 175 ALTER TABLE public.public_paste OWNER TO hpaste; + 176 + 177 -- + 178 -- Name: public_toplevel_paste; Type: VIEW; Schema: public; Owner: hpaste + 179 -- + 180 + 181 CREATE VIEW public_toplevel_paste AS + 182 SELECT public_paste.id, public_paste.title, public_paste.content, public_paste.author, public_paste.created, public_paste.views, public_paste.language, public_paste.channel, public_paste.annotation_of, public_paste.revision_of FROM public_paste WHERE ((public_paste.annotation_of IS NULL) AND (public_paste.revision_of IS NULL)); + 183 + 184 + 185 ALTER TABLE public.public_toplevel_paste OWNER TO hpaste; + 186 + 187 -- + 188 -- Name: report; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: + 189 -- + 190 + 191 CREATE TABLE report ( + 192 id integer NOT NULL, + 193 paste integer NOT NULL, + 194 comments text NOT NULL, + 195 created timestamp with time zone DEFAULT now() NOT NULL + 196 ); + 197 + 198 + 199 ALTER TABLE public.report OWNER TO hpaste; + 200 + 201 -- + 202 -- Name: report_id_seq; Type: SEQUENCE; Schema: public; Owner: hpaste + 203 -- + 204 + 205 CREATE SEQUENCE report_id_seq + 206 START WITH 1 + 207 INCREMENT BY 1 + 208 NO MAXVALUE + 209 NO MINVALUE + 210 CACHE 1; + 211 + 212 + 213 ALTER TABLE public.report_id_seq OWNER TO hpaste; + 214 + 215 -- + 216 -- Name: report_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hpaste + 217 -- + 218 + 219 ALTER SEQUENCE report_id_seq OWNED BY report.id; + 220 + 221 + 222 -- + 223 -- Name: step; Type: TABLE; Schema: public; Owner: hpaste; Tablespace: + 224 -- + 225 + 226 CREATE TABLE step ( + 227 paste integer NOT NULL, + 228 step integer NOT NULL, + 229 content text NOT NULL + 230 ); + 231 + 232 + 233 ALTER TABLE public.step OWNER TO hpaste; + 234 + 235 -- + 236 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste + 237 -- + 238 + 239 ALTER TABLE channel ALTER COLUMN id SET DEFAULT nextval('channel_id_seq'::regclass); + 240 + 241 + 242 -- + 243 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste + 244 -- + 245 + 246 ALTER TABLE hint ALTER COLUMN id SET DEFAULT nextval('hint_id_seq'::regclass); + 247 + 248 + 249 -- + 250 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste + 251 -- + 252 + 253 ALTER TABLE language ALTER COLUMN id SET DEFAULT nextval('language_id_seq'::regclass); + 254 + 255 + 256 -- + 257 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste + 258 -- + 259 + 260 ALTER TABLE paste ALTER COLUMN id SET DEFAULT nextval('paste_id_seq'::regclass); + 261 + 262 + 263 -- + 264 -- Name: id; Type: DEFAULT; Schema: public; Owner: hpaste + 265 -- + 266 + 267 ALTER TABLE report ALTER COLUMN id SET DEFAULT nextval('report_id_seq'::regclass); + 268 + 269 + 270 -- + 271 -- Name: channel_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: + 272 -- + 273 + 274 ALTER TABLE ONLY channel + 275 ADD CONSTRAINT channel_pkey PRIMARY KEY (id); + 276 + 277 + 278 -- + 279 -- Name: hint_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: + 280 -- + 281 + 282 ALTER TABLE ONLY hint + 283 ADD CONSTRAINT hint_pkey PRIMARY KEY (id); + 284 + 285 + 286 -- + 287 -- Name: language_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: + 288 -- + 289 + 290 ALTER TABLE ONLY language + 291 ADD CONSTRAINT language_pkey PRIMARY KEY (id); + 292 + 293 + 294 -- + 295 -- Name: paste_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: + 296 -- + 297 + 298 ALTER TABLE ONLY paste + 299 ADD CONSTRAINT paste_pkey PRIMARY KEY (id); + 300 + 301 + 302 -- + 303 -- Name: report_pkey; Type: CONSTRAINT; Schema: public; Owner: hpaste; Tablespace: + 304 -- + 305 + 306 ALTER TABLE ONLY report + 307 ADD CONSTRAINT report_pkey PRIMARY KEY (id); + 308 + 309 + 310 -- + 311 -- Name: paste_author_index; Type: INDEX; Schema: public; Owner: hpaste; Tablespace: + 312 -- + 313 + 314 CREATE INDEX paste_author_index ON paste USING btree (author); + 315 + 316 + 317 -- + 318 -- Name: paste_date_index; Type: INDEX; Schema: public; Owner: hpaste; Tablespace: + 319 -- + 320 + 321 CREATE INDEX paste_date_index ON paste USING btree (created); + 322 + 323 + 324 -- + 325 -- Name: paste_title_index; Type: INDEX; Schema: public; Owner: hpaste; Tablespace: + 326 -- + 327 + 328 CREATE INDEX paste_title_index ON paste USING btree (title); + 329 + 330 + 331 -- + 332 -- Name: hint_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste + 333 -- + 334 + 335 ALTER TABLE ONLY hint + 336 ADD CONSTRAINT hint_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id) ON UPDATE CASCADE ON DELETE CASCADE; + 337 + 338 + 339 -- + 340 -- Name: paste_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste + 341 -- + 342 + 343 ALTER TABLE ONLY paste + 344 ADD CONSTRAINT paste_channel_fkey FOREIGN KEY (channel) REFERENCES channel(id); + 345 + 346 + 347 -- + 348 -- Name: paste_language_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste + 349 -- + 350 + 351 ALTER TABLE ONLY paste + 352 ADD CONSTRAINT paste_language_fkey FOREIGN KEY (language) REFERENCES language(id); + 353 + 354 + 355 -- + 356 -- Name: paste_revision_of_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste + 357 -- + 358 + 359 ALTER TABLE ONLY paste + 360 ADD CONSTRAINT paste_revision_of_fkey FOREIGN KEY (revision_of) REFERENCES paste(id) ON DELETE CASCADE; + 361 + 362 + 363 -- + 364 -- Name: report_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste + 365 -- + 366 + 367 ALTER TABLE ONLY report + 368 ADD CONSTRAINT report_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id) ON UPDATE CASCADE ON DELETE CASCADE; + 369 + 370 + 371 -- + 372 -- Name: step_paste_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hpaste + 373 -- + 374 + 375 ALTER TABLE ONLY step + 376 ADD CONSTRAINT step_paste_fkey FOREIGN KEY (paste) REFERENCES paste(id); + 377 + 378 + 379 -- + 380 -- Name: public; Type: ACL; Schema: -; Owner: postgres + 381 -- + 382 + 383 REVOKE ALL ON SCHEMA public FROM PUBLIC; + 384 REVOKE ALL ON SCHEMA public FROM postgres; + 385 GRANT ALL ON SCHEMA public TO postgres; + 386 GRANT ALL ON SCHEMA public TO PUBLIC; + 387 + 388 + 389 -- + 390 -- PostgreSQL database dump complete + 391 -- + 392