--
-- PostgreSQL database dump
--

\connect - fr3733

SET search_path = public, pg_catalog;

--
-- TOC entry 2 (OID 18204)
-- Name: member_info; Type: TABLE; Schema: public; Owner: to3058
--

CREATE TABLE member_info (
email character varying(50),
name character varying(50),
address character varying(100),
nikname character varying(50),
"password" character varying(20),
flag_hyouji character(5),
kaisi_time integer
);

--
-- TOC entry 3 (OID 18204)
-- Name: member_info; Type: ACL; Schema: public; Owner: to3058
--

REVOKE ALL ON TABLE member_info FROM PUBLIC;
GRANT ALL ON TABLE member_info TO fr3733_hsoprmgn;

--
-- TOC entry 4 (OID 18206)
-- Name: oukshon_id; Type: TABLE; Schema: public; Owner: to3058
--

CREATE TABLE oukshon_id (
id character varying(20),
"password" character varying(20)
);

--
-- TOC entry 5 (OID 18206)
-- Name: oukshon_id; Type: ACL; Schema: public; Owner: to3058
--

REVOKE ALL ON TABLE oukshon_id FROM PUBLIC;
GRANT ALL ON TABLE oukshon_id TO fr3733_hsoprmgn;

--
-- TOC entry 6 (OID 18208)
-- Name: member_info_backup; Type: TABLE; Schema: public; Owner: to3058
--

CREATE TABLE member_info_backup (
email character varying(50),
name character varying(50),
address character varying(100),
nikname character varying(50),
"password" character varying(20),
flag_hyouji character(5),
kaisi_time integer
);

--
-- TOC entry 7 (OID 18208)
-- Name: member_info_backup; Type: ACL; Schema: public; Owner: to3058
--

REVOKE ALL ON TABLE member_info_backup FROM PUBLIC;
GRANT ALL ON TABLE member_info_backup TO fr3733_hsoprmgn;

--
-- TOC entry 8 (OID 18210)
-- Name: shouhin_table; Type: TABLE; Schema: public; Owner: to3058
--

CREATE TABLE shouhin_table (
titol character varying(300),
kakaku bigint,
nyusatu_kakaku bigint,
email character varying(50),
serial_time bigint,
shubetu bigint,
nyuusatu_shuryo character varying(5),
nyuusatu_num integer,
nikname character varying(50),
serial_num bigint,
kakaku_tani integer,
title character varying(20),
obj oid,
userfile_type character varying(20),
kinsi integer,
upp_member_email character varying(50),
titol_shousai character varying(900),
sinamono_check integer,
rename_file_num bigint,
day_num double precision,
category character varying(100)
);

--
-- TOC entry 9 (OID 18210)
-- Name: shouhin_table; Type: ACL; Schema: public; Owner: to3058
--

REVOKE ALL ON TABLE shouhin_table FROM PUBLIC;
GRANT ALL ON TABLE shouhin_table TO fr3733_hsoprmgn;

--
-- TOC entry 10 (OID 18212)
-- Name: shouhin_table_backup; Type: TABLE; Schema: public; Owner: to3058
--

CREATE TABLE shouhin_table_backup (
titol character varying(300),
kakaku bigint,
nyusatu_kakaku bigint,
email character varying(50),
serial_time bigint,
shubetu bigint,
nyuusatu_shuryo character varying(5),
nyuusatu_num integer,
nikname character varying(50),
serial_num bigint,
kakaku_tani integer,
title character varying(20),
obj oid,
userfile_type character varying(20),
kinsi integer,
upp_member_email character varying(50),
titol_shousai character varying(900),
sinamono_check integer,
rename_file_num bigint,
day_num double precision,
category character varying(100)
);

--
-- TOC entry 11 (OID 18212)
-- Name: shouhin_table_backup; Type: ACL; Schema: public; Owner: to3058
--

REVOKE ALL ON TABLE shouhin_table_backup FROM PUBLIC;
GRANT ALL ON TABLE shouhin_table_backup TO fr3733_hsoprmgn;

--
-- TOC entry 12 (OID 18214)
-- Name: nyusatusha_table; Type: TABLE; Schema: public; Owner: to3058
--

CREATE TABLE nyusatusha_table (
serial bigint,
nikname character varying(50),
email character varying(50)
);

--
-- TOC entry 13 (OID 18214)
-- Name: nyusatusha_table; Type: ACL; Schema: public; Owner: to3058
--

REVOKE ALL ON TABLE nyusatusha_table FROM PUBLIC;
GRANT ALL ON TABLE nyusatusha_table TO fr3733_hsoprmgn;

--
-- TOC entry 14 (OID 18216)
-- Name: serial_info; Type: TABLE; Schema: public; Owner: to3058
--

CREATE TABLE serial_info (
serial_num bigint
);

--
-- TOC entry 15 (OID 18216)
-- Name: serial_info; Type: ACL; Schema: public; Owner: to3058
--

REVOKE ALL ON TABLE serial_info FROM PUBLIC;
GRANT ALL ON TABLE serial_info TO fr3733_hsoprmgn;

--
-- TOC entry 16 (OID 18218)
-- Name: nyusatusha_table_backup; Type: TABLE; Schema: public; Owner: to3058
--

CREATE TABLE nyusatusha_table_backup (
serial bigint,
nikname character varying(50),
email character varying(50)
);

--
-- TOC entry 17 (OID 18218)
-- Name: nyusatusha_table_backup; Type: ACL; Schema: public; Owner: to3058
--

REVOKE ALL ON TABLE nyusatusha_table_backup FROM PUBLIC;
GRANT ALL ON TABLE nyusatusha_table_backup TO fr3733_hsoprmgn;

--
-- Data for TOC entry 18 (OID 18204)
-- Name: member_info; Type: TABLE DATA; Schema: public; Owner: to3058
--

INSERT INTO member_info VALUES ('e-sato@sky.quolia.com', 'sato', 'kagawa', 'sss', 'abc', '0 ', 1074077456);
INSERT INTO member_info VALUES ('toramaru@titan.ocn.ne.jp', 'sato', 'x', 'hello', 'xnbqs', '0 ', 1075518332);

--
-- Data for TOC entry 19 (OID 18206)
-- Name: oukshon_id; Type: TABLE DATA; Schema: public; Owner: to3058
--

INSERT INTO oukshon_id VALUES ('dogwhitekuma', 'speakdog');
INSERT INTO oukshon_id VALUES ('dogwhitekuma', 'speakdog');

--
-- Data for TOC entry 20 (OID 18208)
-- Name: member_info_backup; Type: TABLE DATA; Schema: public; Owner: to3058
--

--
-- Data for TOC entry 21 (OID 18210)
-- Name: shouhin_table; Type: TABLE DATA; Schema: public; Owner: to3058
--

--
-- Data for TOC entry 22 (OID 18212)
-- Name: shouhin_table_backup; Type: TABLE DATA; Schema: public; Owner: to3058
--

--
-- Data for TOC entry 23 (OID 18214)
-- Name: nyusatusha_table; Type: TABLE DATA; Schema: public; Owner: to3058
--

--
-- Data for TOC entry 24 (OID 18216)
-- Name: serial_info; Type: TABLE DATA; Schema: public; Owner: to3058
--

--
-- Data for TOC entry 25 (OID 18218)
-- Name: nyusatusha_table_backup; Type: TABLE DATA; Schema: public; Owner: to3058
--

HOME

This time is 2026 04 24 09 23 GMT.

0.15035500 1777022615