403 lines
13 KiB
SQL
403 lines
13 KiB
SQL
--
|
|
-- PostgreSQL database dump
|
|
--
|
|
|
|
SET statement_timeout = 0;
|
|
SET lock_timeout = 0;
|
|
SET client_encoding = 'UTF8';
|
|
SET standard_conforming_strings = on;
|
|
SET check_function_bodies = false;
|
|
SET client_min_messages = warning;
|
|
|
|
--
|
|
-- Name: syshost; Type: DATABASE; Schema: -; Owner: syshost
|
|
--
|
|
|
|
CREATE DATABASE syshost WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C';
|
|
|
|
|
|
ALTER DATABASE syshost OWNER TO syshost;
|
|
|
|
\connect syshost
|
|
|
|
SET statement_timeout = 0;
|
|
SET lock_timeout = 0;
|
|
SET client_encoding = 'UTF8';
|
|
SET standard_conforming_strings = on;
|
|
SET check_function_bodies = false;
|
|
SET client_min_messages = warning;
|
|
|
|
--
|
|
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
|
|
--
|
|
|
|
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
|
|
|
|
|
|
--
|
|
-- 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 = true;
|
|
|
|
--
|
|
-- Name: t_group; Type: TABLE; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE TABLE t_group (
|
|
group_seq bigint NOT NULL,
|
|
group_id character varying(32) NOT NULL,
|
|
group_password character varying(32) NOT NULL,
|
|
group_name character varying(32) NOT NULL,
|
|
deleted_yn character(1) DEFAULT 'N'::bpchar,
|
|
reg_datetime timestamp without time zone NOT NULL,
|
|
update_datetime timestamp without time zone NOT NULL
|
|
);
|
|
|
|
|
|
ALTER TABLE public.t_group OWNER TO pgsql;
|
|
|
|
--
|
|
-- Name: t_group_group_seq_seq; Type: SEQUENCE; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
CREATE SEQUENCE t_group_group_seq_seq
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
ALTER TABLE public.t_group_group_seq_seq OWNER TO pgsql;
|
|
|
|
--
|
|
-- Name: t_group_group_seq_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
ALTER SEQUENCE t_group_group_seq_seq OWNED BY t_group.group_seq;
|
|
|
|
|
|
--
|
|
-- Name: t_group_member; Type: TABLE; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE TABLE t_group_member (
|
|
group_seq bigint NOT NULL,
|
|
member_name character varying(32) NOT NULL,
|
|
member_cellphone character varying(16) NOT NULL,
|
|
reg_datetime timestamp without time zone NOT NULL,
|
|
update_datetime timestamp without time zone NOT NULL
|
|
);
|
|
|
|
|
|
ALTER TABLE public.t_group_member OWNER TO pgsql;
|
|
|
|
--
|
|
-- Name: t_server_list; Type: TABLE; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE TABLE t_server_list (
|
|
group_seq bigint NOT NULL,
|
|
server_name character varying(32) NOT NULL,
|
|
server_addr character varying(16) NOT NULL,
|
|
server_port integer NOT NULL,
|
|
server_type character varying(12) NOT NULL,
|
|
reg_datetime timestamp without time zone NOT NULL,
|
|
update_datetime timestamp without time zone NOT NULL
|
|
);
|
|
|
|
|
|
ALTER TABLE public.t_server_list OWNER TO pgsql;
|
|
|
|
--
|
|
-- Name: t_server_log; Type: TABLE; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE TABLE t_server_log (
|
|
log_seq bigint NOT NULL,
|
|
group_seq bigint NOT NULL,
|
|
server_name character varying(32) NOT NULL,
|
|
server_address character varying(32) NOT NULL,
|
|
server_statchgtime bigint NOT NULL,
|
|
server_status integer NOT NULL,
|
|
server_type character varying(12) NOT NULL,
|
|
server_deadcount integer NOT NULL,
|
|
reg_datetime timestamp without time zone NOT NULL,
|
|
update_datetime timestamp without time zone NOT NULL
|
|
);
|
|
|
|
|
|
ALTER TABLE public.t_server_log OWNER TO pgsql;
|
|
|
|
--
|
|
-- Name: t_server_log_log_seq_seq; Type: SEQUENCE; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
CREATE SEQUENCE t_server_log_log_seq_seq
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
ALTER TABLE public.t_server_log_log_seq_seq OWNER TO pgsql;
|
|
|
|
--
|
|
-- Name: t_server_log_log_seq_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
ALTER SEQUENCE t_server_log_log_seq_seq OWNED BY t_server_log.log_seq;
|
|
|
|
|
|
--
|
|
-- Name: t_sms_log; Type: TABLE; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE TABLE t_sms_log (
|
|
sms_log_seq bigint NOT NULL,
|
|
group_seq bigint NOT NULL,
|
|
sms_id character varying(32) NOT NULL,
|
|
sms_cellphone character varying(16) NOT NULL,
|
|
sms_message text NOT NULL,
|
|
reg_datetime timestamp without time zone NOT NULL,
|
|
update_datetime timestamp without time zone NOT NULL
|
|
);
|
|
|
|
|
|
ALTER TABLE public.t_sms_log OWNER TO pgsql;
|
|
|
|
--
|
|
-- Name: t_sms_log_sms_log_seq_seq; Type: SEQUENCE; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
CREATE SEQUENCE t_sms_log_sms_log_seq_seq
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
ALTER TABLE public.t_sms_log_sms_log_seq_seq OWNER TO pgsql;
|
|
|
|
--
|
|
-- Name: t_sms_log_sms_log_seq_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
ALTER SEQUENCE t_sms_log_sms_log_seq_seq OWNED BY t_sms_log.sms_log_seq;
|
|
|
|
|
|
--
|
|
-- Name: group_seq; Type: DEFAULT; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
ALTER TABLE ONLY t_group ALTER COLUMN group_seq SET DEFAULT nextval('t_group_group_seq_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- Name: log_seq; Type: DEFAULT; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
ALTER TABLE ONLY t_server_log ALTER COLUMN log_seq SET DEFAULT nextval('t_server_log_log_seq_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- Name: sms_log_seq; Type: DEFAULT; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
ALTER TABLE ONLY t_sms_log ALTER COLUMN sms_log_seq SET DEFAULT nextval('t_sms_log_sms_log_seq_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- Data for Name: t_group; Type: TABLE DATA; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
COPY t_group (group_seq, group_id, group_password, group_name, deleted_yn, reg_datetime, update_datetime) FROM stdin;
|
|
1 ALL 1234 ALL N 2006-03-09 16:32:50.079344 2008-01-08 14:28:10.855279
|
|
3 ADMIN 1234 ADMIN N 2007-12-07 20:35:54.581478 2008-01-08 15:27:07.097177
|
|
\.
|
|
|
|
|
|
--
|
|
-- Name: t_group_group_seq_seq; Type: SEQUENCE SET; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
SELECT pg_catalog.setval('t_group_group_seq_seq', 3, true);
|
|
|
|
|
|
--
|
|
-- Data for Name: t_group_member; Type: TABLE DATA; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
COPY t_group_member (group_seq, member_name, member_cellphone, reg_datetime, update_datetime) FROM stdin;
|
|
1 정기욱 01094964373 2012-04-02 16:30:26.788956 2012-04-02 16:30:26.788956
|
|
3 유희곤 01065540424 2012-04-04 11:17:03.007993 2015-11-04 09:56:45.13787
|
|
1 유희곤 01065540424 2009-12-16 07:29:49.302311 2015-11-04 09:56:57.520116
|
|
\.
|
|
|
|
|
|
--
|
|
-- Data for Name: t_server_list; Type: TABLE DATA; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
COPY t_server_list (group_seq, server_name, server_addr, server_port, server_type, reg_datetime, update_datetime) FROM stdin;
|
|
\.
|
|
|
|
|
|
--
|
|
-- Data for Name: t_server_log; Type: TABLE DATA; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
COPY t_server_log (log_seq, group_seq, server_name, server_address, server_statchgtime, server_status, server_type, server_deadcount, reg_datetime, update_datetime) FROM stdin;
|
|
\.
|
|
|
|
|
|
--
|
|
-- Name: t_server_log_log_seq_seq; Type: SEQUENCE SET; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
SELECT pg_catalog.setval('t_server_log_log_seq_seq', 1, false);
|
|
|
|
|
|
--
|
|
-- Data for Name: t_sms_log; Type: TABLE DATA; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
COPY t_sms_log (sms_log_seq, group_seq, sms_id, sms_cellphone, sms_message, reg_datetime, update_datetime) FROM stdin;
|
|
2 1 SH_ALL 01094964373 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:04:24 2016-08-02 18:04:24.923343 2016-08-02 18:04:24.923343
|
|
3 1 SH_ALL 01065540424 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:04:24 2016-08-02 18:04:24.923343 2016-08-02 18:04:24.923343
|
|
4 1 SH_ALL 01094964373 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:08:55 2016-08-02 18:08:55.334082 2016-08-02 18:08:55.334082
|
|
5 1 SH_ALL 01065540424 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:08:55 2016-08-02 18:08:55.334082 2016-08-02 18:08:55.334082
|
|
6 1 SH_ALL 01094964373 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:13:25 2016-08-02 18:13:25.756345 2016-08-02 18:13:25.756345
|
|
7 1 SH_ALL 01065540424 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:13:25 2016-08-02 18:13:25.756345 2016-08-02 18:13:25.756345
|
|
8 1 SH_ALL 01094964373 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:18:25 2016-08-02 18:18:25.211858 2016-08-02 18:18:25.211858
|
|
9 1 SH_ALL 01065540424 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:18:25 2016-08-02 18:18:25.211858 2016-08-02 18:18:25.211858
|
|
10 1 SH_ALL 01094964373 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:23:25 2016-08-02 18:23:25.674751 2016-08-02 18:23:25.674751
|
|
11 1 SH_ALL 01065540424 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:23:25 2016-08-02 18:23:25.674751 2016-08-02 18:23:25.674751
|
|
12 1 SH_ALL 01094964373 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:28:25 2016-08-02 18:28:25.129366 2016-08-02 18:28:25.129366
|
|
13 1 SH_ALL 01065540424 [ SK51_RCTS02 ] DEAD :: 2016-08-02 18:28:25 2016-08-02 18:28:25.129366 2016-08-02 18:28:25.129366
|
|
14 1 SH_ALL 01094964373 [ SK51_FHS002 ] DEAD :: 2016-08-04 10:57:04 2016-08-04 10:57:04.06802 2016-08-04 10:57:04.06802
|
|
15 1 SH_ALL 01065540424 [ SK51_FHS002 ] DEAD :: 2016-08-04 10:57:04 2016-08-04 10:57:04.06802 2016-08-04 10:57:04.06802
|
|
16 1 SH_ALL 01094964373 [ SK51_FHS002 ] IS BACK :: 2016-08-04 10:57:34 2016-08-04 10:57:34.124508 2016-08-04 10:57:34.124508
|
|
17 1 SH_ALL 01065540424 [ SK51_FHS002 ] IS BACK :: 2016-08-04 10:57:34 2016-08-04 10:57:34.124508 2016-08-04 10:57:34.124508
|
|
18 1 SH_ALL 01094964373 [ SK51_RC ] DEAD :: 2016-08-04 14:23:56 2016-08-04 14:23:56.3195 2016-08-04 14:23:56.3195
|
|
19 1 SH_ALL 01065540424 [ SK51_RC ] DEAD :: 2016-08-04 14:23:56 2016-08-04 14:23:56.3195 2016-08-04 14:23:56.3195
|
|
20 1 SH_ALL 01094964373 [ SK51_RC ] DEAD :: 2016-08-04 14:41:56 2016-08-04 14:41:56.125315 2016-08-04 14:41:56.125315
|
|
21 1 SH_ALL 01065540424 [ SK51_RC ] DEAD :: 2016-08-04 14:41:56 2016-08-04 14:41:56.125315 2016-08-04 14:41:56.125315
|
|
22 1 SH_ALL 01094964373 [ SK51_RC ] DEAD :: 2016-08-04 15:01:56 2016-08-04 15:01:56.161069 2016-08-04 15:01:56.161069
|
|
23 1 SH_ALL 01065540424 [ SK51_RC ] DEAD :: 2016-08-04 15:01:56 2016-08-04 15:01:56.161069 2016-08-04 15:01:56.161069
|
|
24 1 SH_ALL 01094964373 [ SK51_RC ] DEAD :: 2016-08-04 15:21:56 2016-08-04 15:21:56.162701 2016-08-04 15:21:56.162701
|
|
25 1 SH_ALL 01065540424 [ SK51_RC ] DEAD :: 2016-08-04 15:21:56 2016-08-04 15:21:56.162701 2016-08-04 15:21:56.162701
|
|
26 1 SH_ALL 01094964373 [ SK51_RC ] DEAD :: 2016-08-04 15:41:56 2016-08-04 15:41:56.247911 2016-08-04 15:41:56.247911
|
|
27 1 SH_ALL 01065540424 [ SK51_RC ] DEAD :: 2016-08-04 15:41:56 2016-08-04 15:41:56.247911 2016-08-04 15:41:56.247911
|
|
28 1 SH_ALL 01094964373 [ SK51_RC ] DEAD :: 2016-08-04 17:52:09 2016-08-04 17:52:09.099334 2016-08-04 17:52:09.099334
|
|
29 1 SH_ALL 01065540424 [ SK51_RC ] DEAD :: 2016-08-04 17:52:09 2016-08-04 17:52:09.099334 2016-08-04 17:52:09.099334
|
|
30 1 SH_ALL 01094964373 [ SK51_RC ] IS BACK :: 2016-08-04 17:53:29 2016-08-04 17:53:29.214297 2016-08-04 17:53:29.214297
|
|
31 1 SH_ALL 01065540424 [ SK51_RC ] IS BACK :: 2016-08-04 17:53:29 2016-08-04 17:53:29.214297 2016-08-04 17:53:29.214297
|
|
\.
|
|
|
|
|
|
--
|
|
-- Name: t_sms_log_sms_log_seq_seq; Type: SEQUENCE SET; Schema: public; Owner: pgsql
|
|
--
|
|
|
|
SELECT pg_catalog.setval('t_sms_log_sms_log_seq_seq', 31, true);
|
|
|
|
|
|
--
|
|
-- Name: pk_group_group_seq; Type: CONSTRAINT; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
ALTER TABLE ONLY t_group
|
|
ADD CONSTRAINT pk_group_group_seq PRIMARY KEY (group_seq);
|
|
|
|
|
|
--
|
|
-- Name: pk_server_log_log_seq; Type: CONSTRAINT; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
ALTER TABLE ONLY t_server_log
|
|
ADD CONSTRAINT pk_server_log_log_seq PRIMARY KEY (log_seq);
|
|
|
|
|
|
--
|
|
-- Name: pk_sms_log_log_seq; Type: CONSTRAINT; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
ALTER TABLE ONLY t_sms_log
|
|
ADD CONSTRAINT pk_sms_log_log_seq PRIMARY KEY (sms_log_seq);
|
|
|
|
|
|
--
|
|
-- Name: idx_erver_list_group_seq; Type: INDEX; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE INDEX idx_erver_list_group_seq ON t_server_list USING btree (group_seq);
|
|
|
|
|
|
--
|
|
-- Name: idx_group_member_group_seq; Type: INDEX; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE INDEX idx_group_member_group_seq ON t_group_member USING btree (group_seq);
|
|
|
|
|
|
--
|
|
-- Name: idx_server_log_log_seq; Type: INDEX; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE INDEX idx_server_log_log_seq ON t_server_log USING btree (log_seq);
|
|
|
|
|
|
--
|
|
-- Name: idx_server_log_regdate_time; Type: INDEX; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE INDEX idx_server_log_regdate_time ON t_server_log USING btree (reg_datetime);
|
|
|
|
|
|
--
|
|
-- Name: idx_server_log_server_name; Type: INDEX; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE INDEX idx_server_log_server_name ON t_server_log USING btree (server_name);
|
|
|
|
|
|
--
|
|
-- Name: idx_server_log_server_status; Type: INDEX; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE INDEX idx_server_log_server_status ON t_server_log USING btree (server_status);
|
|
|
|
|
|
--
|
|
-- Name: idx_sms_log; Type: INDEX; Schema: public; Owner: pgsql; Tablespace:
|
|
--
|
|
|
|
CREATE INDEX idx_sms_log ON t_sms_log USING btree (group_seq);
|
|
|
|
|
|
--
|
|
-- Name: public; Type: ACL; Schema: -; Owner: pgsql
|
|
--
|
|
|
|
REVOKE ALL ON SCHEMA public FROM PUBLIC;
|
|
REVOKE ALL ON SCHEMA public FROM pgsql;
|
|
GRANT ALL ON SCHEMA public TO pgsql;
|
|
GRANT ALL ON SCHEMA public TO PUBLIC;
|
|
|
|
|
|
--
|
|
-- PostgreSQL database dump complete
|
|
--
|
|
|