-- -- 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 --