From 9ac72b7bc073277d69462d81df1be380bff990e8 Mon Sep 17 00:00:00 2001
From: "kilian (ksmachome)" <ksaffran@dks.lu>
Date: Fri, 3 Apr 2020 09:55:39 +0200
Subject: [PATCH] dd

---
 dev/db/invoicejournal.defaultdata.sql |  16 ++++
 server/defaultdata/invoicejournal.sql | 110 --------------------------
 2 files changed, 16 insertions(+), 110 deletions(-)
 create mode 100644 dev/db/invoicejournal.defaultdata.sql
 delete mode 100644 server/defaultdata/invoicejournal.sql

diff --git a/dev/db/invoicejournal.defaultdata.sql b/dev/db/invoicejournal.defaultdata.sql
new file mode 100644
index 0000000..fa04481
--- /dev/null
+++ b/dev/db/invoicejournal.defaultdata.sql
@@ -0,0 +1,16 @@
+INSERT INTO invoicejournal (id,defvalue) VALUES ('name',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('address',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('country',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('zip',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('city',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('website',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('vatid',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('rcs',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('defaultvat',null);
+
+INSERT INTO invoicejournal (id,defvalue) VALUES ('invoicereport',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('smtpserver',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('smtpport',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('smtplogin',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('smtppassword',null);
+INSERT INTO invoicejournal (id,defvalue) VALUES ('vatvalues','[{"0.17":"17,00%"},{"0.03":"3,00%"},{"0.08":"8,00%"},{"0.07":"7,00%"}]');
\ No newline at end of file
diff --git a/server/defaultdata/invoicejournal.sql b/server/defaultdata/invoicejournal.sql
deleted file mode 100644
index 5b16b00..0000000
--- a/server/defaultdata/invoicejournal.sql
+++ /dev/null
@@ -1,110 +0,0 @@
-CREATE TABLE invoicejournal (
-	id TEXT,
-	defvalue TEXT,
-	primary key (id)
-);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('name',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('address',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('country',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('zip',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('city',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('website',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('vatid',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('rcs',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('defaultvat',null);
-
-INSERT INTO invoicejournal (id,defvalue) VALUES ('invoicereport',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('smtpserver',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('smtpport',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('smtplogin',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('smtppassword',null);
-INSERT INTO invoicejournal (id,defvalue) VALUES ('vatvalues','[{"0.17":"17,00%"},{"0.03":"3,00%"},{"0.08":"8,00%"},{"0.07":"7,00%"}]');
-CREATE TABLE preferences (
-	host TEXT,
-	page TEXT,
-	preferences TEXT,
-	PRIMARY KEY (host,page)
-);
-
-CREATE TABLE addresses (
-	id TEXT,
-	receipient TEXT,
-	title TEXT,
-	prename TEXT,
-	surname TEXT,
-	address TEXT,
-	zip TEXT,
-	city TEXT,
-	country TEXT,
-	email TEXT,
-	phone TEXT,
-	clientnumber TEXT,
-	vatid TEXT,
-	iban TEXT,
-	bic TEXT,
-	ijgroup TEXT,
-	lang TEXT,
-	PRIMARY KEY (id)
-);
-DROP TABLE invoices;
-CREATE TABLE invoices (
-	id TEXT,
-	direction TEXT,
-	id_addresses TEXT,
-	Templatename TEXT,
-	receipientname TEXT,
-	addres TEXT,
-	zip TEXT,
-	city TEXT,
-	country TEXT,
-	isinnereu BOOLEAN,
-	payedamount NUMERIC,
-	grossamount NUMERIC,
-	netamount NUMERIC,
-	vatamount NUMERIC,
-	byear INTEGER,
-	bquarter TEXT,
-	invoicedate DATE,
-	deadlinedays INTEGER,
-	deadlinedate DATE,
-	statusdate DATE,
-	status TEXT,
-	footertext TEXT,
-	reference TEXT,
-	reminderdates TEXT,
-	invoicetype TEXT,
-	headertext TEXT,
-	pdffile TEXT,
-	PRIMARY KEY (id)
-	);
-	
-CREATE TABLE bookings (
-        id TEXT,
-        id_invoice TEXT,
-        id_product TEXT,
-        sku TEXT
-        quantity NUMERIC,
-        unitamount NUMERIC,
-        unit TEXT,
-        description TEXT,
-        taxamount NUMERIC,
-        taxpercent NUMERIC,
-        netamount NUMERIC,
-        grossamount NUMERIC,
-        bookingdate DATE,
-        PRIMARY KEY (id)
-);
-
-CREATE TABLE products (
-	id TEXT,
-	sku TEXT,
-	producttype TEXT,
-	unit TEXT,
-	unitamount NUMERIC,
-	vatpercent NUMERIC,
-	netamount NUMERIC,
-	grossamount NUMERIC,
-	description TEXT,
-	PRIMARY KEY (id)
-);
-
-- 
2.39.5