From 6349623b40ef4b94a6905d96b3b0fa8daaefd178 Mon Sep 17 00:00:00 2001 From: Philip Reetz Date: Wed, 11 Jan 2006 12:17:54 +0000 Subject: [PATCH] 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