From e6697f33a18fa7df70586f3ff563aa7d0102e71f Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Thu, 12 Jan 2006 13:20:43 +0000 Subject: [PATCH] Merge von 766 aus unstable: DB-Update Variable user_password auf Typ "text" gesetzt, um lange codierte Passwoerter speichern zu koennen --- sql/Pg-upgrade-2.1.1-2.1.2.sql | 4 ++-- sql/lx-office.sql | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql index 547f97ccc..876c6af83 100644 --- a/sql/Pg-upgrade-2.1.1-2.1.2.sql +++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql @@ -123,8 +123,8 @@ alter table vendor add column ustid varchar(12); alter table customer add column username varchar(50); alter table vendor add column username varchar(50); -alter table customer add column user_password varchar(12); -alter table vendor add column user_password varchar(12); +alter table customer add column user_password text; +alter table vendor add column user_password text; alter table customer add column salesman_id integer; alter table vendor add column salesman_id integer; diff --git a/sql/lx-office.sql b/sql/lx-office.sql index 439b119bb..ca5b1d35e 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -243,7 +243,7 @@ CREATE TABLE "customer" ( "obsolete" boolean DEFAULT 'f', "ustid" varchar(12), "username" varchar(50), - "user_password" varchar(12), + "user_password" text, "salesman_id" integer, "c_vendor_id" text, "klass" integer DEFAULT 0 -- 2.20.1