2 -- PostgreSQL database dump
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;
12 SET search_path = public, pg_catalog;
15 -- Name: furigana(text); Type: FUNCTION; Schema: public; Owner: -
18 CREATE FUNCTION furigana(text) RETURNS text
19 LANGUAGE c IMMUTABLE STRICT
20 AS '$libdir/textsearch_ja', 'furigana';
24 -- Name: hiragana(text); Type: FUNCTION; Schema: public; Owner: -
27 CREATE FUNCTION hiragana(text) RETURNS text
28 LANGUAGE c IMMUTABLE STRICT
29 AS '$libdir/textsearch_ja', 'hiragana';
33 -- Name: ja_analyze(text); Type: FUNCTION; Schema: public; Owner: -
36 CREATE FUNCTION ja_analyze(text, OUT word text, OUT type text, OUT subtype1 text, OUT subtype2 text, OUT subtype3 text, OUT conjtype text, OUT conjugation text, OUT basic text, OUT ruby text, OUT pronounce text) RETURNS SETOF record
37 LANGUAGE c IMMUTABLE STRICT
38 AS '$libdir/textsearch_ja', 'ja_analyze';
42 -- Name: ja_normalize(text); Type: FUNCTION; Schema: public; Owner: -
45 CREATE FUNCTION ja_normalize(text) RETURNS text
46 LANGUAGE c IMMUTABLE STRICT
47 AS '$libdir/textsearch_ja', 'ja_normalize';
51 -- Name: ja_wakachi(text); Type: FUNCTION; Schema: public; Owner: -
54 CREATE FUNCTION ja_wakachi(text) RETURNS text
55 LANGUAGE c IMMUTABLE STRICT
56 AS '$libdir/textsearch_ja', 'ja_wakachi';
60 -- Name: katakana(text); Type: FUNCTION; Schema: public; Owner: -
63 CREATE FUNCTION katakana(text) RETURNS text
64 LANGUAGE c IMMUTABLE STRICT
65 AS '$libdir/textsearch_ja', 'katakana';
69 -- Name: ts_ja_end(internal); Type: FUNCTION; Schema: public; Owner: -
72 CREATE FUNCTION ts_ja_end(internal) RETURNS void
74 AS '$libdir/textsearch_ja', 'ts_ja_end';
78 -- Name: ts_ja_gettoken(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
81 CREATE FUNCTION ts_ja_gettoken(internal, internal, internal) RETURNS internal
83 AS '$libdir/textsearch_ja', 'ts_ja_gettoken';
87 -- Name: ts_ja_lexize(internal, internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
90 CREATE FUNCTION ts_ja_lexize(internal, internal, internal, internal) RETURNS internal
92 AS '$libdir/textsearch_ja', 'ts_ja_lexize';
96 -- Name: ts_ja_start(internal, integer); Type: FUNCTION; Schema: public; Owner: -
99 CREATE FUNCTION ts_ja_start(internal, integer) RETURNS internal
101 AS '$libdir/textsearch_ja', 'ts_ja_start';
105 -- Name: web_query(text); Type: FUNCTION; Schema: public; Owner: -
108 CREATE FUNCTION web_query(text) RETURNS text
109 LANGUAGE sql IMMUTABLE STRICT
111 SELECT regexp_replace(regexp_replace(regexp_replace($1,
112 E'(^|\\s+)-', E'\\1!', 'g'),
113 E'\\s+OR\\s+', '|', 'g'),
118 SET default_tablespace = '';
120 SET default_with_oids = false;
123 -- Name: arcs; Type: TABLE; Schema: public; Owner: -; Tablespace:
128 code character varying(10) NOT NULL,
129 extname character varying(10) NOT NULL,
131 summary character varying(255),
132 origname character varying(255),
133 created_at timestamp without time zone,
134 updated_at timestamp without time zone
139 -- Name: arcs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
142 CREATE SEQUENCE arcs_id_seq
151 -- Name: arcs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
154 ALTER SEQUENCE arcs_id_seq OWNED BY arcs.id;
158 -- Name: locations; Type: TABLE; Schema: public; Owner: -; Tablespace:
161 CREATE TABLE locations (
163 code character varying(10) NOT NULL,
164 site character varying(255) NOT NULL,
165 summary character varying(255) NOT NULL,
166 created_at timestamp without time zone,
167 updated_at timestamp without time zone
172 -- Name: locations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
175 CREATE SEQUENCE locations_id_seq
184 -- Name: locations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
187 ALTER SEQUENCE locations_id_seq OWNED BY locations.id;
191 -- Name: pmds; Type: TABLE; Schema: public; Owner: -; Tablespace:
197 path character varying(255) NOT NULL,
198 created_at timestamp without time zone,
199 updated_at timestamp without time zone
204 -- Name: pmds_id_seq; Type: SEQUENCE; Schema: public; Owner: -
207 CREATE SEQUENCE pmds_id_seq
216 -- Name: pmds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
219 ALTER SEQUENCE pmds_id_seq OWNED BY pmds.id;
223 -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace:
226 CREATE TABLE schema_migrations (
227 version character varying(255) NOT NULL
232 -- Name: thumbs; Type: TABLE; Schema: public; Owner: -; Tablespace:
235 CREATE TABLE thumbs (
236 video_id character varying(15) NOT NULL,
237 title character varying(255),
239 created_at timestamp without time zone,
240 updated_at timestamp without time zone,
246 -- Name: vmds; Type: TABLE; Schema: public; Owner: -; Tablespace:
252 path character varying(255) NOT NULL,
253 created_at timestamp without time zone,
254 updated_at timestamp without time zone
259 -- Name: vmds_id_seq; Type: SEQUENCE; Schema: public; Owner: -
262 CREATE SEQUENCE vmds_id_seq
271 -- Name: vmds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
274 ALTER SEQUENCE vmds_id_seq OWNED BY vmds.id;
278 -- Name: xes; Type: TABLE; Schema: public; Owner: -; Tablespace:
284 path character varying(255) NOT NULL,
285 created_at timestamp without time zone,
286 updated_at timestamp without time zone
291 -- Name: xes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
294 CREATE SEQUENCE xes_id_seq
303 -- Name: xes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
306 ALTER SEQUENCE xes_id_seq OWNED BY xes.id;
310 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
313 ALTER TABLE arcs ALTER COLUMN id SET DEFAULT nextval('arcs_id_seq'::regclass);
317 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
320 ALTER TABLE locations ALTER COLUMN id SET DEFAULT nextval('locations_id_seq'::regclass);
324 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
327 ALTER TABLE pmds ALTER COLUMN id SET DEFAULT nextval('pmds_id_seq'::regclass);
331 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
334 ALTER TABLE vmds ALTER COLUMN id SET DEFAULT nextval('vmds_id_seq'::regclass);
338 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
341 ALTER TABLE xes ALTER COLUMN id SET DEFAULT nextval('xes_id_seq'::regclass);
345 -- Name: arcs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
348 ALTER TABLE ONLY arcs
349 ADD CONSTRAINT arcs_pkey PRIMARY KEY (id);
353 -- Name: locations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
356 ALTER TABLE ONLY locations
357 ADD CONSTRAINT locations_pkey PRIMARY KEY (id);
361 -- Name: pmds_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
364 ALTER TABLE ONLY pmds
365 ADD CONSTRAINT pmds_pkey PRIMARY KEY (id);
369 -- Name: vmds_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
372 ALTER TABLE ONLY vmds
373 ADD CONSTRAINT vmds_pkey PRIMARY KEY (id);
377 -- Name: xes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
381 ADD CONSTRAINT xes_pkey PRIMARY KEY (id);
385 -- Name: index_thumbs_on_vector; Type: INDEX; Schema: public; Owner: -; Tablespace:
388 CREATE INDEX index_thumbs_on_vector ON thumbs USING gin (vector);
392 -- Name: index_thumbs_on_video_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
395 CREATE UNIQUE INDEX index_thumbs_on_video_id ON thumbs USING btree (video_id);
399 -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -; Tablespace:
402 CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
406 -- Name: tsvectorupdate; Type: TRIGGER; Schema: public; Owner: -
409 CREATE TRIGGER tsvectorupdate
410 BEFORE INSERT OR UPDATE ON thumbs
412 EXECUTE PROCEDURE tsvector_update_trigger('vector', 'pg_catalog.japanese', 'description');
416 -- PostgreSQL database dump complete
419 INSERT INTO schema_migrations (version) VALUES ('20100608074721');
421 INSERT INTO schema_migrations (version) VALUES ('20100608080758');
423 INSERT INTO schema_migrations (version) VALUES ('20100608081439');
425 INSERT INTO schema_migrations (version) VALUES ('20100608143904');
427 INSERT INTO schema_migrations (version) VALUES ('20100608144944');
429 INSERT INTO schema_migrations (version) VALUES ('20100612234341');
431 INSERT INTO schema_migrations (version) VALUES ('20100613202235');
433 INSERT INTO schema_migrations (version) VALUES ('20100613202356');
435 INSERT INTO schema_migrations (version) VALUES ('20100613205243');