-- -- PostgreSQL database dump -- -- Dumped from database version 16.2 -- Dumped by pg_dump version 16.2 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: accounts; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.accounts ( guid character varying(32) NOT NULL, name character varying(2048) NOT NULL, account_type character varying(2048) NOT NULL, commodity_guid character varying(32), commodity_scu integer NOT NULL, non_std_scu integer NOT NULL, parent_guid character varying(32), code character varying(2048), description character varying(2048), hidden integer, placeholder integer ); ALTER TABLE public.accounts OWNER TO "user"; -- -- Name: billterms; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.billterms ( guid character varying(32) NOT NULL, name character varying(2048) NOT NULL, description character varying(2048) NOT NULL, refcount integer NOT NULL, invisible integer NOT NULL, parent character varying(32), type character varying(2048) NOT NULL, duedays integer, discountdays integer, discount_num bigint, discount_denom bigint, cutoff integer ); ALTER TABLE public.billterms OWNER TO "user"; -- -- Name: books; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.books ( guid character varying(32) NOT NULL, root_account_guid character varying(32) NOT NULL, root_template_guid character varying(32) NOT NULL ); ALTER TABLE public.books OWNER TO "user"; -- -- Name: budget_amounts; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.budget_amounts ( id integer NOT NULL, budget_guid character varying(32) NOT NULL, account_guid character varying(32) NOT NULL, period_num integer NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL ); ALTER TABLE public.budget_amounts OWNER TO "user"; -- -- Name: budget_amounts_id_seq; Type: SEQUENCE; Schema: public; Owner: user -- CREATE SEQUENCE public.budget_amounts_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.budget_amounts_id_seq OWNER TO "user"; -- -- Name: budget_amounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user -- ALTER SEQUENCE public.budget_amounts_id_seq OWNED BY public.budget_amounts.id; -- -- Name: budgets; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.budgets ( guid character varying(32) NOT NULL, name character varying(2048) NOT NULL, description character varying(2048), num_periods integer NOT NULL ); ALTER TABLE public.budgets OWNER TO "user"; -- -- Name: commodities; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.commodities ( guid character varying(32) NOT NULL, namespace character varying(2048) NOT NULL, mnemonic character varying(2048) NOT NULL, fullname character varying(2048), cusip character varying(2048), fraction integer NOT NULL, quote_flag integer NOT NULL, quote_source character varying(2048), quote_tz character varying(2048) ); ALTER TABLE public.commodities OWNER TO "user"; -- -- Name: customers; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.customers ( guid character varying(32) NOT NULL, name character varying(2048) NOT NULL, id character varying(2048) NOT NULL, notes character varying(2048) NOT NULL, active integer NOT NULL, discount_num bigint NOT NULL, discount_denom bigint NOT NULL, credit_num bigint NOT NULL, credit_denom bigint NOT NULL, currency character varying(32) NOT NULL, tax_override integer NOT NULL, addr_name character varying(1024), addr_addr1 character varying(1024), addr_addr2 character varying(1024), addr_addr3 character varying(1024), addr_addr4 character varying(1024), addr_phone character varying(128), addr_fax character varying(128), addr_email character varying(256), shipaddr_name character varying(1024), shipaddr_addr1 character varying(1024), shipaddr_addr2 character varying(1024), shipaddr_addr3 character varying(1024), shipaddr_addr4 character varying(1024), shipaddr_phone character varying(128), shipaddr_fax character varying(128), shipaddr_email character varying(256), terms character varying(32), tax_included integer, taxtable character varying(32) ); ALTER TABLE public.customers OWNER TO "user"; -- -- Name: employees; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.employees ( guid character varying(32) NOT NULL, username character varying(2048) NOT NULL, id character varying(2048) NOT NULL, language character varying(2048) NOT NULL, acl character varying(2048) NOT NULL, active integer NOT NULL, currency character varying(32) NOT NULL, ccard_guid character varying(32), workday_num bigint NOT NULL, workday_denom bigint NOT NULL, rate_num bigint NOT NULL, rate_denom bigint NOT NULL, addr_name character varying(1024), addr_addr1 character varying(1024), addr_addr2 character varying(1024), addr_addr3 character varying(1024), addr_addr4 character varying(1024), addr_phone character varying(128), addr_fax character varying(128), addr_email character varying(256) ); ALTER TABLE public.employees OWNER TO "user"; -- -- Name: entries; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.entries ( guid character varying(32) NOT NULL, date timestamp without time zone NOT NULL, date_entered timestamp without time zone, description character varying(2048), action character varying(2048), notes character varying(2048), quantity_num bigint, quantity_denom bigint, i_acct character varying(32), i_price_num bigint, i_price_denom bigint, i_discount_num bigint, i_discount_denom bigint, invoice character varying(32), i_disc_type character varying(2048), i_disc_how character varying(2048), i_taxable integer, i_taxincluded integer, i_taxtable character varying(32), b_acct character varying(32), b_price_num bigint, b_price_denom bigint, bill character varying(32), b_taxable integer, b_taxincluded integer, b_taxtable character varying(32), b_paytype integer, billable integer, billto_type integer, billto_guid character varying(32), order_guid character varying(32) ); ALTER TABLE public.entries OWNER TO "user"; -- -- Name: gnclock; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.gnclock ( hostname character varying(255), pid integer ); ALTER TABLE public.gnclock OWNER TO "user"; -- -- Name: invoices; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.invoices ( guid character varying(32) NOT NULL, id character varying(2048) NOT NULL, date_opened timestamp without time zone, date_posted timestamp without time zone, notes character varying(2048) NOT NULL, active integer NOT NULL, currency character varying(32) NOT NULL, owner_type integer, owner_guid character varying(32), terms character varying(32), billing_id character varying(2048), post_txn character varying(32), post_lot character varying(32), post_acc character varying(32), billto_type integer, billto_guid character varying(32), charge_amt_num bigint, charge_amt_denom bigint ); ALTER TABLE public.invoices OWNER TO "user"; -- -- Name: jobs; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.jobs ( guid character varying(32) NOT NULL, id character varying(2048) NOT NULL, name character varying(2048) NOT NULL, reference character varying(2048) NOT NULL, active integer NOT NULL, owner_type integer, owner_guid character varying(32) ); ALTER TABLE public.jobs OWNER TO "user"; -- -- Name: lots; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.lots ( guid character varying(32) NOT NULL, account_guid character varying(32), is_closed integer NOT NULL ); ALTER TABLE public.lots OWNER TO "user"; -- -- Name: orders; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.orders ( guid character varying(32) NOT NULL, id character varying(2048) NOT NULL, notes character varying(2048) NOT NULL, reference character varying(2048) NOT NULL, active integer NOT NULL, date_opened timestamp without time zone NOT NULL, date_closed timestamp without time zone NOT NULL, owner_type integer NOT NULL, owner_guid character varying(32) NOT NULL ); ALTER TABLE public.orders OWNER TO "user"; -- -- Name: prices; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.prices ( guid character varying(32) NOT NULL, commodity_guid character varying(32) NOT NULL, currency_guid character varying(32) NOT NULL, date timestamp without time zone NOT NULL, source character varying(2048), type character varying(2048), value_num bigint NOT NULL, value_denom bigint NOT NULL ); ALTER TABLE public.prices OWNER TO "user"; -- -- Name: recurrences; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.recurrences ( id integer NOT NULL, obj_guid character varying(32) NOT NULL, recurrence_mult integer NOT NULL, recurrence_period_type character varying(2048) NOT NULL, recurrence_period_start date NOT NULL, recurrence_weekend_adjust character varying(2048) NOT NULL ); ALTER TABLE public.recurrences OWNER TO "user"; -- -- Name: recurrences_id_seq; Type: SEQUENCE; Schema: public; Owner: user -- CREATE SEQUENCE public.recurrences_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.recurrences_id_seq OWNER TO "user"; -- -- Name: recurrences_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user -- ALTER SEQUENCE public.recurrences_id_seq OWNED BY public.recurrences.id; -- -- Name: schedxactions; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.schedxactions ( guid character varying(32) NOT NULL, name character varying(2048), enabled integer NOT NULL, start_date date, end_date date, last_occur date, num_occur integer NOT NULL, rem_occur integer NOT NULL, auto_create integer NOT NULL, auto_notify integer NOT NULL, adv_creation integer NOT NULL, adv_notify integer NOT NULL, instance_count integer NOT NULL, template_act_guid character varying(32) NOT NULL ); ALTER TABLE public.schedxactions OWNER TO "user"; -- -- Name: slots; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.slots ( id integer NOT NULL, obj_guid character varying(32) NOT NULL, name character varying(4096) NOT NULL, slot_type integer NOT NULL, int64_val bigint, string_val character varying(4096), double_val double precision, timespec_val timestamp without time zone, guid_val character varying(32), numeric_val_num bigint, numeric_val_denom bigint, gdate_val date ); ALTER TABLE public.slots OWNER TO "user"; -- -- Name: slots_id_seq; Type: SEQUENCE; Schema: public; Owner: user -- CREATE SEQUENCE public.slots_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.slots_id_seq OWNER TO "user"; -- -- Name: slots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user -- ALTER SEQUENCE public.slots_id_seq OWNED BY public.slots.id; -- -- Name: splits; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.splits ( guid character varying(32) NOT NULL, tx_guid character varying(32) NOT NULL, account_guid character varying(32) NOT NULL, memo character varying(2048) NOT NULL, action character varying(2048) NOT NULL, reconcile_state character varying(1) NOT NULL, reconcile_date timestamp without time zone, value_num bigint NOT NULL, value_denom bigint NOT NULL, quantity_num bigint NOT NULL, quantity_denom bigint NOT NULL, lot_guid character varying(32) ); ALTER TABLE public.splits OWNER TO "user"; -- -- Name: taxtable_entries; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.taxtable_entries ( id integer NOT NULL, taxtable character varying(32) NOT NULL, account character varying(32) NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL, type integer NOT NULL ); ALTER TABLE public.taxtable_entries OWNER TO "user"; -- -- Name: taxtable_entries_id_seq; Type: SEQUENCE; Schema: public; Owner: user -- CREATE SEQUENCE public.taxtable_entries_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.taxtable_entries_id_seq OWNER TO "user"; -- -- Name: taxtable_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: user -- ALTER SEQUENCE public.taxtable_entries_id_seq OWNED BY public.taxtable_entries.id; -- -- Name: taxtables; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.taxtables ( guid character varying(32) NOT NULL, name character varying(50) NOT NULL, refcount bigint NOT NULL, invisible integer NOT NULL, parent character varying(32) ); ALTER TABLE public.taxtables OWNER TO "user"; -- -- Name: transactions; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.transactions ( guid character varying(32) NOT NULL, currency_guid character varying(32) NOT NULL, num character varying(2048) NOT NULL, post_date timestamp without time zone, enter_date timestamp without time zone, description character varying(2048) ); ALTER TABLE public.transactions OWNER TO "user"; -- -- Name: vendors; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.vendors ( guid character varying(32) NOT NULL, name character varying(2048) NOT NULL, id character varying(2048) NOT NULL, notes character varying(2048) NOT NULL, currency character varying(32) NOT NULL, active integer NOT NULL, tax_override integer NOT NULL, addr_name character varying(1024), addr_addr1 character varying(1024), addr_addr2 character varying(1024), addr_addr3 character varying(1024), addr_addr4 character varying(1024), addr_phone character varying(128), addr_fax character varying(128), addr_email character varying(256), terms character varying(32), tax_inc character varying(2048), tax_table character varying(32) ); ALTER TABLE public.vendors OWNER TO "user"; -- -- Name: versions; Type: TABLE; Schema: public; Owner: user -- CREATE TABLE public.versions ( table_name character varying(50) NOT NULL, table_version integer NOT NULL ); ALTER TABLE public.versions OWNER TO "user"; -- -- Name: budget_amounts id; Type: DEFAULT; Schema: public; Owner: user -- ALTER TABLE ONLY public.budget_amounts ALTER COLUMN id SET DEFAULT nextval('public.budget_amounts_id_seq'::regclass); -- -- Name: recurrences id; Type: DEFAULT; Schema: public; Owner: user -- ALTER TABLE ONLY public.recurrences ALTER COLUMN id SET DEFAULT nextval('public.recurrences_id_seq'::regclass); -- -- Name: slots id; Type: DEFAULT; Schema: public; Owner: user -- ALTER TABLE ONLY public.slots ALTER COLUMN id SET DEFAULT nextval('public.slots_id_seq'::regclass); -- -- Name: taxtable_entries id; Type: DEFAULT; Schema: public; Owner: user -- ALTER TABLE ONLY public.taxtable_entries ALTER COLUMN id SET DEFAULT nextval('public.taxtable_entries_id_seq'::regclass); -- -- Data for Name: accounts; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.accounts (guid, name, account_type, commodity_guid, commodity_scu, non_std_scu, parent_guid, code, description, hidden, placeholder) FROM stdin; 00622dda21937b29e494179de5013f82 Root Account ROOT \N 0 0 \N 0 0 fcd795021c976ba75621ec39e75f6214 Asset ASSET 346629655191dcf59a7e2c2a85b70f69 100 0 00622dda21937b29e494179de5013f82 0 1 3bc319753945b6dba3e1928abed49e35 Current ASSET 346629655191dcf59a7e2c2a85b70f69 100 0 fcd795021c976ba75621ec39e75f6214 0 1 93fc043c3062aaa1297b30e543d2cd0d Cash ASSET 346629655191dcf59a7e2c2a85b70f69 100 0 3bc319753945b6dba3e1928abed49e35 0 0 a1dd9e8118bff87db289482bceebfea9 Savings ASSET 346629655191dcf59a7e2c2a85b70f69 100 0 3bc319753945b6dba3e1928abed49e35 0 0 adc619f0ac7fa27d5768bfd73ecbc01e Checking ASSET 346629655191dcf59a7e2c2a85b70f69 100 0 3bc319753945b6dba3e1928abed49e35 0 0 5b5100d58bcc030d2f7828d897fda62e Fixed ASSET 346629655191dcf59a7e2c2a85b70f69 100 0 fcd795021c976ba75621ec39e75f6214 0 0 a3dc764fea53b709af7fcead6470da43 House ASSET 346629655191dcf59a7e2c2a85b70f69 100 0 5b5100d58bcc030d2f7828d897fda62e 0 0 01f6b1417935528fdc97ac2e130a150c Broker ASSET 5f586908098232e67edb1371408bfaa8 100 0 fcd795021c976ba75621ec39e75f6214 0 1 1c089803052e85f5c6d8e786057dbaee Foo stock STOCK 069410ffec45a41a218bba474093d466 10000 0 01f6b1417935528fdc97ac2e130a150c 0 0 96ed7a45459fb5fe570e48fcd46f05d0 Liability LIABILITY 346629655191dcf59a7e2c2a85b70f69 100 0 00622dda21937b29e494179de5013f82 0 0 6bbc8f20544452cac1637fb9a9b851bb Income INCOME 346629655191dcf59a7e2c2a85b70f69 100 0 00622dda21937b29e494179de5013f82 0 0 af88d386d44b14acf244362b85ccaf4c Expense EXPENSE 346629655191dcf59a7e2c2a85b70f69 100 0 00622dda21937b29e494179de5013f82 0 0 8056f425ecdc352cf6039e3a0d0d1e6c Equity EQUITY 346629655191dcf59a7e2c2a85b70f69 100 0 00622dda21937b29e494179de5013f82 0 0 1305127e63737f8c39afb49b5bbeca7a Opening Balances - EUR EQUITY 346629655191dcf59a7e2c2a85b70f69 100 0 8056f425ecdc352cf6039e3a0d0d1e6c 0 0 bb43218d7d95b1fe062a731d1aa7e9e2 Mouvements TRADING 069410ffec45a41a218bba474093d466 10000 0 00622dda21937b29e494179de5013f82 0 1 f2b78b76f6093ba04204d972a7ce42d6 NASDAQ TRADING 069410ffec45a41a218bba474093d466 10000 0 bb43218d7d95b1fe062a731d1aa7e9e2 0 1 0ccab772d0d16a3e1eaf42cd53f891e5 FOO TRADING 069410ffec45a41a218bba474093d466 10000 0 f2b78b76f6093ba04204d972a7ce42d6 0 0 e97809296efb670cff4f92138bd69ec8 CURRENCY TRADING 346629655191dcf59a7e2c2a85b70f69 100 0 bb43218d7d95b1fe062a731d1aa7e9e2 0 1 7894e9c3e955f5eaa9689d16ed775660 EUR5 TRADING 346629655191dcf59a7e2c2a85b70f69 100 0 e97809296efb670cff4f92138bd69ec8 0 0 f6c0cd00ec04169a44f170181882adab Template Root ROOT \N 0 0 \N 0 0 \. -- -- Data for Name: billterms; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.billterms (guid, name, description, refcount, invisible, parent, type, duedays, discountdays, discount_num, discount_denom, cutoff) FROM stdin; \. -- -- Data for Name: books; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.books (guid, root_account_guid, root_template_guid) FROM stdin; 7d4ef4044fd30f41d08914a8174c2f5b 00622dda21937b29e494179de5013f82 f6c0cd00ec04169a44f170181882adab \. -- -- Data for Name: budget_amounts; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.budget_amounts (id, budget_guid, account_guid, period_num, amount_num, amount_denom) FROM stdin; \. -- -- Data for Name: budgets; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.budgets (guid, name, description, num_periods) FROM stdin; \. -- -- Data for Name: commodities; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.commodities (guid, namespace, mnemonic, fullname, cusip, fraction, quote_flag, quote_source, quote_tz) FROM stdin; 346629655191dcf59a7e2c2a85b70f69 CURRENCY EUR Euro 978 100 1 currency 5f586908098232e67edb1371408bfaa8 CURRENCY AED UAE Dirham 784 100 1 currency 069410ffec45a41a218bba474093d466 NASDAQ FOO Foo Inc 10000 0 \N d821d6776fde9f7c2d01b67876406fd3 CURRENCY ADF Andorran Franc 950 100 0 currency 1e5d65e2726a5d4595741cb204992991 CURRENCY USD US Dollar 840 100 0 currency \. -- -- Data for Name: customers; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.customers (guid, name, id, notes, active, discount_num, discount_denom, credit_num, credit_denom, currency, tax_override, addr_name, addr_addr1, addr_addr2, addr_addr3, addr_addr4, addr_phone, addr_fax, addr_email, shipaddr_name, shipaddr_addr1, shipaddr_addr2, shipaddr_addr3, shipaddr_addr4, shipaddr_phone, shipaddr_fax, shipaddr_email, terms, tax_included, taxtable) FROM stdin; \. -- -- Data for Name: employees; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.employees (guid, username, id, language, acl, active, currency, ccard_guid, workday_num, workday_denom, rate_num, rate_denom, addr_name, addr_addr1, addr_addr2, addr_addr3, addr_addr4, addr_phone, addr_fax, addr_email) FROM stdin; \. -- -- Data for Name: entries; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.entries (guid, date, date_entered, description, action, notes, quantity_num, quantity_denom, i_acct, i_price_num, i_price_denom, i_discount_num, i_discount_denom, invoice, i_disc_type, i_disc_how, i_taxable, i_taxincluded, i_taxtable, b_acct, b_price_num, b_price_denom, bill, b_taxable, b_taxincluded, b_taxtable, b_paytype, billable, billto_type, billto_guid, order_guid) FROM stdin; \. -- -- Data for Name: gnclock; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.gnclock (hostname, pid) FROM stdin; \. -- -- Data for Name: invoices; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.invoices (guid, id, date_opened, date_posted, notes, active, currency, owner_type, owner_guid, terms, billing_id, post_txn, post_lot, post_acc, billto_type, billto_guid, charge_amt_num, charge_amt_denom) FROM stdin; \. -- -- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.jobs (guid, id, name, reference, active, owner_type, owner_guid) FROM stdin; \. -- -- Data for Name: lots; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.lots (guid, account_guid, is_closed) FROM stdin; \. -- -- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.orders (guid, id, notes, reference, active, date_opened, date_closed, owner_type, owner_guid) FROM stdin; \. -- -- Data for Name: prices; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.prices (guid, commodity_guid, currency_guid, date, source, type, value_num, value_denom) FROM stdin; 0d6684f44fb018e882de76094ed9c433 d821d6776fde9f7c2d01b67876406fd3 5f586908098232e67edb1371408bfaa8 2018-02-20 23:00:00 user:price-editor unknown 3 2 831ce95a146243a0b66895151538990a 5f586908098232e67edb1371408bfaa8 346629655191dcf59a7e2c2a85b70f69 2017-05-08 16:00:00 user:price-editor last 1 2 c266e6ce9bdf8832bf88360df524669e 346629655191dcf59a7e2c2a85b70f69 5f586908098232e67edb1371408bfaa8 2018-02-20 23:00:00 user:price-editor unknown 10 9 715ad31cb272437fc883d658f732a8eb 1e5d65e2726a5d4595741cb204992991 346629655191dcf59a7e2c2a85b70f69 2018-02-20 23:00:00 user:price-editor unknown 7 5 86a98448a82e9012cad82ac677eb86df 069410ffec45a41a218bba474093d466 5f586908098232e67edb1371408bfaa8 2018-02-20 23:00:00 user:price-editor unknown 9 10 \. -- -- Data for Name: recurrences; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.recurrences (id, obj_guid, recurrence_mult, recurrence_period_type, recurrence_period_start, recurrence_weekend_adjust) FROM stdin; \. -- -- Data for Name: schedxactions; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.schedxactions (guid, name, enabled, start_date, end_date, last_occur, num_occur, rem_occur, auto_create, auto_notify, adv_creation, adv_notify, instance_count, template_act_guid) FROM stdin; \. -- -- Data for Name: slots; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.slots (id, obj_guid, name, slot_type, int64_val, string_val, double_val, timespec_val, guid_val, numeric_val_num, numeric_val_denom, gdate_val) FROM stdin; 1 7d4ef4044fd30f41d08914a8174c2f5b features 9 0 \N \N 1970-01-01 00:00:00 fce6a886a9204dbab6b2ff1e45c49faa 0 1 \N 2 fce6a886a9204dbab6b2ff1e45c49faa features/ISO-8601 formatted date strings in SQLite3 databases. 4 0 Use ISO formatted date-time strings in SQLite3 databases (requires at least GnuCash 2.6.20) \N 1970-01-01 00:00:00 \N 0 1 \N 3 7d4ef4044fd30f41d08914a8174c2f5b options 9 0 \N \N 1970-01-01 00:00:00 8c289969313f47dca3f2529cca5a0e63 0 1 \N 4 8c289969313f47dca3f2529cca5a0e63 options/Accounts 9 0 \N \N 1970-01-01 00:00:00 75aa9359d50e4d2a9388d1cddf774b39 0 1 \N 5 75aa9359d50e4d2a9388d1cddf774b39 options/Accounts/Use Trading Accounts 4 0 t \N 1970-01-01 00:00:00 \N 0 1 \N 6 8c289969313f47dca3f2529cca5a0e63 options/Budgeting 9 0 \N \N 1970-01-01 00:00:00 de347c6285ee4cd08b54eea78dd9b9b4 0 1 \N 7 7d4ef4044fd30f41d08914a8174c2f5b remove-color-not-set-slots 4 0 true \N 1970-01-01 00:00:00 \N 0 1 \N 8 fcd795021c976ba75621ec39e75f6214 placeholder 4 0 true \N 1970-01-01 00:00:00 \N 0 1 \N 9 3bc319753945b6dba3e1928abed49e35 placeholder 4 0 true \N 1970-01-01 00:00:00 \N 0 1 \N 10 01f6b1417935528fdc97ac2e130a150c placeholder 4 0 true \N 1970-01-01 00:00:00 \N 0 1 \N 11 bb43218d7d95b1fe062a731d1aa7e9e2 placeholder 4 0 true \N 1970-01-01 00:00:00 \N 0 1 \N 12 f2b78b76f6093ba04204d972a7ce42d6 placeholder 4 0 true \N 1970-01-01 00:00:00 \N 0 1 \N 13 e97809296efb670cff4f92138bd69ec8 placeholder 4 0 true \N 1970-01-01 00:00:00 \N 0 1 \N 14 0fac88d8412f46d5e16beb87aee0fd22 date-posted 10 0 \N \N 1970-01-01 00:00:00 \N 0 1 2018-02-20 \. -- -- Data for Name: splits; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.splits (guid, tx_guid, account_guid, memo, action, reconcile_state, reconcile_date, value_num, value_denom, quantity_num, quantity_denom, lot_guid) FROM stdin; de832fe97e37811a7fff7e28b3a43425 6c8876003c4a6026e38e3afb67d6f2b1 93fc043c3062aaa1297b30e543d2cd0d n 1970-01-01 00:00:00 15000 100 15000 100 \N 1e612f650eb598d9e803902b6aca73e3 6c8876003c4a6026e38e3afb67d6f2b1 6bbc8f20544452cac1637fb9a9b851bb n 1970-01-01 00:00:00 -15000 100 -15000 100 \N 42336a5732d54b22fa080be3b50ff5b7 0fac88d8412f46d5e16beb87aee0fd22 93fc043c3062aaa1297b30e543d2cd0d n 1970-01-01 00:00:00 10000 100 10000 100 \N 486341b68457b037ecd75dcdcbf64bc5 0fac88d8412f46d5e16beb87aee0fd22 adc619f0ac7fa27d5768bfd73ecbc01e n 1970-01-01 00:00:00 -10000 100 -10000 100 \N eb832677cb2a013fcc4140316ccb3323 a5b50b770ee5e01361c49300aedb5e0f af88d386d44b14acf244362b85ccaf4c n 1970-01-01 00:00:00 3000 100 3000 100 \N f32095185808aff854fc020ee2eedb5d a5b50b770ee5e01361c49300aedb5e0f 93fc043c3062aaa1297b30e543d2cd0d n 1970-01-01 00:00:00 -3000 100 -3000 100 \N ea72c01205e1f619aa278930648b060e e774d4b1fbd3c8c853b2c45a1d74f5f9 adc619f0ac7fa27d5768bfd73ecbc01e n 1970-01-01 00:00:00 25000 100 25000 100 \N bae8bc3a2b29812691016e61c425fda5 e774d4b1fbd3c8c853b2c45a1d74f5f9 a1dd9e8118bff87db289482bceebfea9 n 1970-01-01 00:00:00 -25000 100 -25000 100 \N 4f78ef3650c38115abf60365f9484b45 7b3a2df3645b3e490121814c8ad7146d a1dd9e8118bff87db289482bceebfea9 n 1970-01-01 00:00:00 250000 100 250000 100 \N afcba9bb98422e5ca64931a5efd86025 7b3a2df3645b3e490121814c8ad7146d 1305127e63737f8c39afb49b5bbeca7a n 1970-01-01 00:00:00 -250000 100 -250000 100 \N e07539176a70222b16369bd246b174b9 a5924cd14525c307cc5862c97361b031 1c089803052e85f5c6d8e786057dbaee n 1970-01-01 00:00:00 120000 100 1300000 10000 \N e055799a549308621a16c715c870e29a a5924cd14525c307cc5862c97361b031 7894e9c3e955f5eaa9689d16ed775660 n 1970-01-01 00:00:00 120000 100 120000 100 \N f5f1b767b38439eff788bed8fca8d1c2 a5924cd14525c307cc5862c97361b031 a1dd9e8118bff87db289482bceebfea9 n 1970-01-01 00:00:00 -120000 100 -120000 100 \N 85d451d09db85fb97cea6fe2e876d566 a5924cd14525c307cc5862c97361b031 0ccab772d0d16a3e1eaf42cd53f891e5 n 1970-01-01 00:00:00 -120000 100 -1300000 10000 \N b3c4df045f2a19332e143cd83a7e013f 2d249b7d3fc8efe17865873b97748f50 a1dd9e8118bff87db289482bceebfea9 n 1970-01-01 00:00:00 250000 100 250000 100 \N d240433d6812fc634c21200fb559d07f 2d249b7d3fc8efe17865873b97748f50 1305127e63737f8c39afb49b5bbeca7a n 1970-01-01 00:00:00 -250000 100 -250000 100 \N 714c69b235d450f11e4add7077b4cde7 5be11c009a88b4198aa65ee878ddf99d adc619f0ac7fa27d5768bfd73ecbc01e n 1970-01-01 00:00:00 100000 100 100000 100 \N 3a53ab1f73cb74d9882dd14b7d6a4a78 5be11c009a88b4198aa65ee878ddf99d 96ed7a45459fb5fe570e48fcd46f05d0 n 1970-01-01 00:00:00 -100000 100 -100000 100 \N b8387081c3d60310465a5d316fb6745a 6294086c678a584e7ce184b523699f6c af88d386d44b14acf244362b85ccaf4c n 1970-01-01 00:00:00 20000 100 20000 100 \N d96c36fed7324332bfeff80e52cd9892 6294086c678a584e7ce184b523699f6c adc619f0ac7fa27d5768bfd73ecbc01e n 1970-01-01 00:00:00 -20000 100 -20000 100 \N 6ca852f33ee5415d22dfc132f5c5ec09 325537f4f0fadfd9ffb6aad3cd18e360 96ed7a45459fb5fe570e48fcd46f05d0 capital n 1970-01-01 00:00:00 10000 100 10000 100 \N 3142f6ebed4469f9a692dfa69a0080f5 325537f4f0fadfd9ffb6aad3cd18e360 af88d386d44b14acf244362b85ccaf4c interest n 1970-01-01 00:00:00 3000 100 3000 100 \N 47c7fdca3bc04d6ad734eefc2794ddfe 325537f4f0fadfd9ffb6aad3cd18e360 adc619f0ac7fa27d5768bfd73ecbc01e monthly payment n 1970-01-01 00:00:00 -13000 100 -13000 100 \N 76cd1180d563db608495c710d2774c9a 59d9b60221a4615e74f8e489dceff58b a3dc764fea53b709af7fcead6470da43 n 1970-01-01 00:00:00 2000000 100 2000000 100 \N c8eb859a307babbb2fdf66871cf4c0a8 59d9b60221a4615e74f8e489dceff58b 96ed7a45459fb5fe570e48fcd46f05d0 n 1970-01-01 00:00:00 -2000000 100 -2000000 100 \N \. -- -- Data for Name: taxtable_entries; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.taxtable_entries (id, taxtable, account, amount_num, amount_denom, type) FROM stdin; \. -- -- Data for Name: taxtables; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.taxtables (guid, name, refcount, invisible, parent) FROM stdin; \. -- -- Data for Name: transactions; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.transactions (guid, currency_guid, num, post_date, enter_date, description) FROM stdin; 6c8876003c4a6026e38e3afb67d6f2b1 346629655191dcf59a7e2c2a85b70f69 2014-12-24 10:59:00 2014-12-25 10:08:15 income 1 0fac88d8412f46d5e16beb87aee0fd22 346629655191dcf59a7e2c2a85b70f69 2018-02-20 10:59:00 2018-02-20 21:12:49 Transfer current a5b50b770ee5e01361c49300aedb5e0f 346629655191dcf59a7e2c2a85b70f69 2018-02-20 10:59:00 2018-02-20 21:13:01 Purchase e774d4b1fbd3c8c853b2c45a1d74f5f9 346629655191dcf59a7e2c2a85b70f69 2018-02-20 10:59:00 2018-02-20 21:13:30 transfer intra 7b3a2df3645b3e490121814c8ad7146d 346629655191dcf59a7e2c2a85b70f69 2018-02-20 10:59:00 2018-02-20 21:13:50 Opening Balance a5924cd14525c307cc5862c97361b031 346629655191dcf59a7e2c2a85b70f69 2018-02-21 10:59:00 2018-02-21 06:58:44 buy foo 2d249b7d3fc8efe17865873b97748f50 346629655191dcf59a7e2c2a85b70f69 2018-02-21 10:59:00 2018-02-21 07:25:53 Opening Balance 5be11c009a88b4198aa65ee878ddf99d 346629655191dcf59a7e2c2a85b70f69 2014-12-24 10:59:00 2014-12-25 10:07:30 initial load 6294086c678a584e7ce184b523699f6c 346629655191dcf59a7e2c2a85b70f69 2014-12-24 10:59:00 2014-12-25 10:08:08 expense 1 325537f4f0fadfd9ffb6aad3cd18e360 346629655191dcf59a7e2c2a85b70f69 2014-12-24 10:59:00 2014-12-25 10:11:26 loan payment 59d9b60221a4615e74f8e489dceff58b 346629655191dcf59a7e2c2a85b70f69 2018-02-20 10:59:00 2018-02-20 21:14:36 house load \. -- -- Data for Name: vendors; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.vendors (guid, name, id, notes, currency, active, tax_override, addr_name, addr_addr1, addr_addr2, addr_addr3, addr_addr4, addr_phone, addr_fax, addr_email, terms, tax_inc, tax_table) FROM stdin; \. -- -- Data for Name: versions; Type: TABLE DATA; Schema: public; Owner: user -- COPY public.versions (table_name, table_version) FROM stdin; Gnucash 5000004 Gnucash-Resave 19920 books 1 commodities 1 accounts 1 budgets 1 budget_amounts 1 prices 3 transactions 4 splits 5 slots 4 recurrences 2 schedxactions 1 lots 2 billterms 2 customers 2 employees 2 entries 4 invoices 4 jobs 1 orders 1 taxtables 2 taxtable_entries 3 vendors 1 \. -- -- Name: budget_amounts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user -- SELECT pg_catalog.setval('public.budget_amounts_id_seq', 1, false); -- -- Name: recurrences_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user -- SELECT pg_catalog.setval('public.recurrences_id_seq', 1, false); -- -- Name: slots_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user -- SELECT pg_catalog.setval('public.slots_id_seq', 14, true); -- -- Name: taxtable_entries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: user -- SELECT pg_catalog.setval('public.taxtable_entries_id_seq', 1, false); -- -- Name: accounts accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.accounts ADD CONSTRAINT accounts_pkey PRIMARY KEY (guid); -- -- Name: billterms billterms_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.billterms ADD CONSTRAINT billterms_pkey PRIMARY KEY (guid); -- -- Name: books books_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.books ADD CONSTRAINT books_pkey PRIMARY KEY (guid); -- -- Name: budget_amounts budget_amounts_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.budget_amounts ADD CONSTRAINT budget_amounts_pkey PRIMARY KEY (id); -- -- Name: budgets budgets_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.budgets ADD CONSTRAINT budgets_pkey PRIMARY KEY (guid); -- -- Name: commodities commodities_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.commodities ADD CONSTRAINT commodities_pkey PRIMARY KEY (guid); -- -- Name: customers customers_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.customers ADD CONSTRAINT customers_pkey PRIMARY KEY (guid); -- -- Name: employees employees_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.employees ADD CONSTRAINT employees_pkey PRIMARY KEY (guid); -- -- Name: entries entries_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.entries ADD CONSTRAINT entries_pkey PRIMARY KEY (guid); -- -- Name: invoices invoices_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.invoices ADD CONSTRAINT invoices_pkey PRIMARY KEY (guid); -- -- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.jobs ADD CONSTRAINT jobs_pkey PRIMARY KEY (guid); -- -- Name: lots lots_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.lots ADD CONSTRAINT lots_pkey PRIMARY KEY (guid); -- -- Name: orders orders_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.orders ADD CONSTRAINT orders_pkey PRIMARY KEY (guid); -- -- Name: prices prices_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.prices ADD CONSTRAINT prices_pkey PRIMARY KEY (guid); -- -- Name: recurrences recurrences_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.recurrences ADD CONSTRAINT recurrences_pkey PRIMARY KEY (id); -- -- Name: schedxactions schedxactions_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.schedxactions ADD CONSTRAINT schedxactions_pkey PRIMARY KEY (guid); -- -- Name: slots slots_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.slots ADD CONSTRAINT slots_pkey PRIMARY KEY (id); -- -- Name: splits splits_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.splits ADD CONSTRAINT splits_pkey PRIMARY KEY (guid); -- -- Name: taxtable_entries taxtable_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.taxtable_entries ADD CONSTRAINT taxtable_entries_pkey PRIMARY KEY (id); -- -- Name: taxtables taxtables_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.taxtables ADD CONSTRAINT taxtables_pkey PRIMARY KEY (guid); -- -- Name: transactions transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.transactions ADD CONSTRAINT transactions_pkey PRIMARY KEY (guid); -- -- Name: vendors vendors_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.vendors ADD CONSTRAINT vendors_pkey PRIMARY KEY (guid); -- -- Name: versions versions_pkey; Type: CONSTRAINT; Schema: public; Owner: user -- ALTER TABLE ONLY public.versions ADD CONSTRAINT versions_pkey PRIMARY KEY (table_name); -- -- Name: slots_guid_index; Type: INDEX; Schema: public; Owner: user -- CREATE INDEX slots_guid_index ON public.slots USING btree (obj_guid); -- -- Name: splits_account_guid_index; Type: INDEX; Schema: public; Owner: user -- CREATE INDEX splits_account_guid_index ON public.splits USING btree (account_guid); -- -- Name: splits_tx_guid_index; Type: INDEX; Schema: public; Owner: user -- CREATE INDEX splits_tx_guid_index ON public.splits USING btree (tx_guid); -- -- Name: tx_post_date_index; Type: INDEX; Schema: public; Owner: user -- CREATE INDEX tx_post_date_index ON public.transactions USING btree (post_date); -- -- PostgreSQL database dump complete --