CREATE TABLE "BELEGE"("B_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"B_RID" INTEGER,"B_NR" VARCHAR_IGNORECASE(15) NOT NULL,"B_ART" TINYINT,"B_STATUS" TINYINT)
CREATE UNIQUE INDEX "BE_IND_1" ON "BELEGE"("B_RID")
CREATE TABLE "KATALOGE"("KA_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"KA_ART" VARCHAR_IGNORECASE(10) NOT NULL,"KA_NR" TINYINT NOT NULL,"KA_WERT" VARCHAR(50) NOT NULL,"KA_KURZ" VARCHAR(10))
CREATE UNIQUE INDEX "KA_IND_1" ON "KATALOGE"("KA_ART","KA_NR")
CREATE TABLE "BUCHUNG"("BU_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"BU_BID" INTEGER NOT NULL,"BU_TXT" VARCHAR(50),"BU_KTO_H" SMALLINT,"BU_KTO_S" SMALLINT,"BU_WRG" TINYINT,"BU_BETRAG" DECIMAL(18,2))
CREATE UNIQUE INDEX "BU_IND_1" ON "BUCHUNG"("BU_BID")
CREATE TABLE "KONTEN"("K_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"K_ART" TINYINT,"K_NR" SMALLINT NOT NULL,"K_BM" VARCHAR_IGNORECASE(1),"K_GV" VARCHAR_IGNORECASE(2),"K_BKTO" INTEGER,"K_BLZ" INTEGER,"K_KURZ" VARCHAR(10),"K_NAME" VARCHAR(50),"K_S_ID" INTEGER,"K_ST_REL" BOOLEAN,"K_ST_NR" SMALLINT,"K_F_NR" VARCHAR(2),"K_GRP" VARCHAR(2))
CREATE UNIQUE INDEX "KO_IND_1" ON "KONTEN"("K_NR")
CREATE UNIQUE INDEX "KO_IND_2" ON "KONTEN"("K_ART","K_NR")
CREATE TABLE "STAMMDAT"("S_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"S_GRNR" TINYINT,"S_KNR" VARCHAR_IGNORECASE(15),"S_LNR" VARCHAR_IGNORECASE(15),"S_ENR" VARCHAR_IGNORECASE(15),"S_USTNR" VARCHAR_IGNORECASE(20),"S_ART" TINYINT,"S_ANREDE" TINYINT,"S_TITEL" VARCHAR(20),"S_VORNAME" VARCHAR(30),"S_NAME" VARCHAR(30),"S_NAME2" VARCHAR(30),"S_NAME3" VARCHAR(30),"S_STRASSE" VARCHAR(20),"S_LAND" VARCHAR(3),"S_PLZ" VARCHAR(5),"S_ORT" VARCHAR(30),"S_TEL_PRIV" VARCHAR(20),"S_TEL_FIRM" VARCHAR(20),"S_TEL_MOBIL" VARCHAR(20),"S_MAIL_PRIV" VARCHAR(50),"S_MAIL_FIRM" VARCHAR(50),"S_WEB_PRIV" VARCHAR(50),"S_WEB_FIRM" VARCHAR(50),"S_ZUSATZ1" VARCHAR(250),"S_ZUSATZ2" VARCHAR(250))
CREATE UNIQUE INDEX "ST_IND_1" ON "STAMMDAT"("S_KNR")
CREATE UNIQUE INDEX "ST_IND_2" ON "STAMMDAT"("S_LNR")
CREATE UNIQUE INDEX "ST_IND_3" ON "STAMMDAT"("S_ART","S_KNR")
CREATE TABLE "SZ_ZUSATZ"("SZ_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"SZ_STID" INTEGER NOT NULL,"SZ_ART" TINYINT,"SZ_WERT" VARCHAR(255))
CREATE UNIQUE INDEX "SZ_IND_1" ON "SZ_ZUSATZ"("SZ_STID","SZ_ART")
CREATE TABLE "R_DAT"("R_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"R_ART" TINYINT,"R_NR" VARCHAR_IGNORECASE(15),"R_AUS_NR" INTEGER,"R_BNR" INTEGER,"R_NR2" VARCHAR_IGNORECASE(15),"R_KL_NR" INTEGER,"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_ZZ1" DATE,"R_ZZ2" DATE,"R_ZZ3" DATE,"R_ZB1" DECIMAL(8,2),"R_ZB2" DECIMAL(8,2),"R_ZB3" DECIMAL(8,2),"R_ZT1" VARCHAR(50),"R_ZT2" VARCHAR(50),"R_ZT3" VARCHAR(50),"R_GS_N" DECIMAL(20,2),"R_STAT" TINYINT,"R_MAHN_START" DATE,"R_ZAHL_EIN_DAT" DATE,"R_ZAH_EIN_BET" DECIMAL(18,2))
CREATE INDEX "RD_IND_1" ON "R_DAT"("R_KL_NR")
CREATE TABLE "A_DAT"("A_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"A_GRP" TINYINT,"A_BEZ" VARCHAR(250),"A_BEZ_K" VARCHAR(20),"A_EINH" TINYINT,"A_MWST" TINYINT,"A_LAG" BOOLEAN,"A_LAG_ID" TINYINT,"A_VK_L" DECIMAL(18,2),"A_VK" DECIMAL(18,2),"A_RABATT" TINYINT,"A_EK_L" DECIMAL(18,2),"A_EK_M" DECIMAL(18,2),"A_BEST_IST" INTEGER,"A_BEST_SOLL" INTEGER,"A_NR" VARCHAR_IGNORECASE(20) NOT NULL)
CREATE UNIQUE INDEX "AR_IND_1" ON "A_DAT"("A_NR")
CREATE TABLE "RP_DAT"("RP_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,"RP_RID" INTEGER NOT NULL,"RP_NR" TINYINT NOT NULL,"RP_A_NR" VARCHAR(20) NOT NULL,"RP_A_TXT1" VARCHAR(250),"RP_A_ZUSATZ" VARCHAR(250),"RP-ANZ" VARCHAR(10),"RP_E_PREIS" DECIMAL(18,2),"RP_PR_ART" BOOLEAN,"RP_MWST_SATZ" TINYINT NOT NULL,CONSTRAINT SYS_FK_1 FOREIGN KEY("RP_RID") REFERENCES "R_DAT"("R_ID"))
CREATE USER SA PASSWORD "" ADMIN
INSERT INTO "KATALOGE" VALUES(0,'anrede',0,'Herr','Hr.')
INSERT INTO "KATALOGE" VALUES(2,'ANREDE',1,'Frau','Fr.')
INSERT INTO "KATALOGE" VALUES(3,'Anrede',2,'Firma','Fa.')
INSERT INTO "KATALOGE" VALUES(4,'STAMM',0,'Mandant',NULL)
INSERT INTO "KATALOGE" VALUES(5,'STAMM',1,'Interessent',NULL)
INSERT INTO "KATALOGE" VALUES(6,'STAMM',2,'Kunde',NULL)
INSERT INTO "KATALOGE" VALUES(7,'Stamm',3,'Lieferant',NULL)
INSERT INTO "KATALOGE" VALUES(8,'Beleg',0,'ERechnung',NULL)
INSERT INTO "KATALOGE" VALUES(9,'Beleg',1,'ARechnung',NULL)
INSERT INTO "KATALOGE" VALUES(10,'Beleg',2,'KtoAusz',NULL)
INSERT INTO "KATALOGE" VALUES(11,'Einheit',0,'St\u00fcck','St.')
INSERT INTO "KATALOGE" VALUES(12,'Einheit',1,'Liter','L.')
INSERT INTO "KATALOGE" VALUES(13,'Einheit',2,'Packung','Pack.')
INSERT INTO "KATALOGE" VALUES(14,'MWST',0,'0',NULL)
INSERT INTO "KATALOGE" VALUES(15,'MWST',1,'7',NULL)
INSERT INTO "KATALOGE" VALUES(16,'MWST',2,'16',NULL)