Variable user_password auf Typ "text" gesetzt, um lange codierte Passwoerter speicher...

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 547f97ccc8c864164cb7672b40173e9293e85728..876c6af8365d36974406cef6e2be479004430ccd 100644 (file)
--- 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 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;
 
 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 439b119bb8f43d0d22757bdfdbe936234741d476..ca5b1d35e52c605fb279f7cd58d95bc23e3b2ca2 100644 (file)
--- 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),
         "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
         "salesman_id" integer,
         "c_vendor_id" text,
         "klass" integer DEFAULT 0