projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Projekt: neue Spalten (Kunde, Typ, gültig)
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
csv_import_report_cache.sql
diff --git
a/sql/Pg-upgrade2/csv_import_report_cache.sql
b/sql/Pg-upgrade2/csv_import_report_cache.sql
index
440c346
..
34fbdf6
100644
(file)
--- a/
sql/Pg-upgrade2/csv_import_report_cache.sql
+++ b/
sql/Pg-upgrade2/csv_import_report_cache.sql
@@
-8,7
+8,8
@@
CREATE TABLE csv_import_reports (
session_id TEXT NOT NULL,
profile_id INTEGER NOT NULL REFERENCES csv_import_profiles(id),
type TEXT NOT NULL,
session_id TEXT NOT NULL,
profile_id INTEGER NOT NULL REFERENCES csv_import_profiles(id),
type TEXT NOT NULL,
- file TEXT NOT NULL
+ file TEXT NOT NULL,
+ numrows INTEGER NOT NULL
);
CREATE TABLE csv_import_report_rows (
);
CREATE TABLE csv_import_report_rows (
@@
-19,11
+20,14
@@
CREATE TABLE csv_import_report_rows (
value TEXT
);
value TEXT
);
-CREATE TABLE csv_import_report_
row_
status (
+CREATE TABLE csv_import_report_status (
id SERIAL PRIMARY KEY,
id SERIAL PRIMARY KEY,
- csv_import_report_row_id INTEGER NOT NULL REFERENCES csv_import_report_rows(id),
+ csv_import_report_id INTEGER NOT NULL REFERENCES csv_import_reports(id),
+ row INTEGER NOT NULL,
type TEXT NOT NULL,
value TEXT
);
ALTER TABLE csv_import_profiles DROP constraint "csv_import_profiles_name_key";
type TEXT NOT NULL,
value TEXT
);
ALTER TABLE csv_import_profiles DROP constraint "csv_import_profiles_name_key";
+
+CREATE INDEX "csv_import_report_rows_index_row" ON csv_import_report_rows (row);