Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
Serious |
Reported By: Ulrich Doewich Reported On: 4/22/2010 For: Version 2.03 Build 11 |
CREATE TABLE "user" ( "id" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1), "created" TIMESTAMP DEFAULT CURRENT_TIMESTAMP, "modified" TIMESTAMP GENERATED ALWAYS AS CURRENT_TIMESTAMP, "auth_type" INTEGER DEFAULT 0, "alias" VARCHAR(16) COLLATE "UNI_CI", "password" VARCHAR(32) COLLATE "UNI", "dn" VARCHAR(256) COLLATE "UNI", "fst_name" VARCHAR(32) COLLATE "UNI_CI", "surname" VARCHAR(32) COLLATE "UNI_CI", "tel" VARCHAR(24) COLLATE "UNI_CI", "email" VARCHAR(64) COLLATE "UNI_CI", "tlan_cal" INTEGER, "tree_lvl" INTEGER, "tree_pid" INTEGER, "acc_code" INTEGER, "log_seq" INTEGER, "last_mac" BYTE(8) ) VERSION 1.0 ENCRYPTED CREATE INDEX "tlvl_idx" ON "user" ("tree_lvl") DESCRIPTION '1.0' ALTER TABLE "user" ADD CONSTRAINT "id_pk" PRIMARY KEY ("id") DESCRIPTION '1.0' ALTER TABLE "user" ADD CONSTRAINT "alias_con" UNIQUE ("alias") DESCRIPTION '1.0'
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |