tiwalthe
18 lines
1.4 KiB
Plaintext
18 lines
1.4 KiB
Plaintext
SET DATABASE COLLATION "German"
|
|
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
|
|
CREATE CACHED TABLE "Kategorien"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Name" VARCHAR(255) NOT NULL)
|
|
CREATE CACHED TABLE "Transaktionen"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Datum" DATE NOT NULL,"Kategorie" INTEGER NOT NULL,"Betrag" DECIMAL(50,2) NOT NULL,"Beschreibung" VARCHAR(255),"Auslage" INTEGER DEFAULT 0 NOT NULL)
|
|
CREATE CACHED TABLE "Kategorien_Tilman"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Name" VARCHAR(255) NOT NULL)
|
|
CREATE CACHED TABLE "Transaktionen_Tilman"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Datum" DATE NOT NULL,"Kategorie" INTEGER NOT NULL,"Betrag" DECIMAL(50,2) NOT NULL,"Beschreibung" VARCHAR(255),"Auslage" INTEGER DEFAULT 0 NOT NULL)
|
|
SET TABLE "Kategorien" INDEX'108664 37'
|
|
SET TABLE "Transaktionen" INDEX'128352 763'
|
|
SET TABLE "Kategorien_Tilman" INDEX'163952 2'
|
|
SET TABLE "Transaktionen_Tilman" INDEX'164120 3'
|
|
ALTER TABLE "Kategorien" ALTER COLUMN "ID" RESTART WITH 37
|
|
ALTER TABLE "Transaktionen" ALTER COLUMN "ID" RESTART WITH 763
|
|
ALTER TABLE "Kategorien_Tilman" ALTER COLUMN "ID" RESTART WITH 2
|
|
ALTER TABLE "Transaktionen_Tilman" ALTER COLUMN "ID" RESTART WITH 3
|
|
CREATE USER SA PASSWORD ""
|
|
GRANT DBA TO SA
|
|
SET WRITE_DELAY 60
|