CREATE TABLE "STAMMDAT"("S_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"S_KNR" INTEGER,"S_LNR" INTEGER,"S_ENR" INTEGER,S_ANREDE VARCHAR(50),S_TITEL VARCHAR(50),S_VORNAME VARCHAR(50),S_NAME VARCHAR(50),S_NAME2 VARCHAR(50),S_NAME3 VARCHAR(50),S_STRASSE VARCHAR(50),S_LAND VARCHAR(50),S_PLZ VARCHAR(10),S_ORT VARCHAR(50),S_TEL_PRIV VARCHAR(20),S_TEL_FIRM VARCHAR(20),S_TEL_MOBIL VARCHAR(20),S_MAIL_PRIV VARCHAR(20),S_MAIL_FIRM VARCHAR(20),S_WEB_PRIV VARCHAR(20),S_WEB_FIRM VARCHAR(20),S_ZUSATZ1 VARCHAR(65535),S_ZUSATZ2 VARCHAR(65535),S_ZUSATZ3 VARCHAR(65535),S_ZUSATZ4 VARCHAR(65535),"S_KONTAKT" INTEGER,"S_KONT_W" BIT)
CREATE TABLE "R_DAT"("R_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"R_ART" INTEGER,"R_NR" VARCHAR(10),"R_DAT" DATE,"R_AS1" VARCHAR(50),"R_AS2" VARCHAR(50),"R_AS3" VARCHAR(50),"R_AS4" VARCHAR(50),"R_AS5" VARCHAR(50),"R_LA1" VARCHAR(50),"R_LA2" VARCHAR(50),"R_LA3" VARCHAR(50),"R_LA4" VARCHAR(50),"R_LA5" VARCHAR(50),"R_ZT1" VARCHAR(50),"R_ZT2" VARCHAR(50),"R_ZT3" VARCHAR(50),"R_GS_N" DECIMAL(50),"R_MWSt" DECIMAL(50))
CREATE TABLE "A_DAT"("A_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"A_GRP" INTEGER,"A_BEZ_K" VARCHAR(50),"A_BEZ" VARCHAR(50),"A_EINH" VARCHAR(50),"A_MWST" DECIMAL(15,2),"A_LAG" BIT,"A_LAG_ID" BIGINT,"A_EK_L" DECIMAL(15,2),"A_EK_M" DECIMAL(15,2),"A_BEST_IST" DECIMAL(15,2),"A_BEST_SOLL" DECIMAL(15,2))
CREATE TABLE "RP_DAT"("RP_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"R_NR" VARCHAR(10),"RP_NR" INTEGER,"RP_A_NR" INTEGER,"RP_A_TXT1" VARCHAR(50),"RP_A_TXT2" VARCHAR(50))
CREATE USER SA PASSWORD "" ADMIN
INSERT INTO "STAMMDAT" VALUES(0,10100,NULL,NULL,NULL,NULL,NULL,'allg. A-Kunde',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
INSERT INTO "A_DAT" VALUES(0,1,'allg Standard-Artikel.','allgemeiner Standard Artikel','St.',16,FALSE,NULL,NULL,NULL,NULL,NULL)