EVYGnFBt

1CREATE TABLE IF NOT EXISTS [ChestShops] (
2[ID] integer PRIMARY KEY NULL,
3[ShopID] integer  NULL,
4[ServerID] INTEGER NOT NULL,
5[WeltID] INTEGER NULL,
6[X] integer  NULL,
7[Y] integer  NULL,
8[Z] integer  NULL,
9[BankAccountID] integer  NULL,
10[Anzahl] integer  NULL,
11[PreisB] decimal  NULL,
12[PreisS] decimal  NULL,
13[PreisBPro1] decimal  NULL,
14[PreisSPro1] decimal  NULL,
15[ItemID] integer  NULL,
16[AufLager] integer  NULL,
17[PlatzFrei] integer  NULL,
18FOREIGN KEY(ShopID) REFERENCES Shops(ID),
19FOREIGN KEY(ServerID) REFERENCES Server(ID),
20FOREIGN KEY(WeltID) REFERENCES Welten(ID),
21FOREIGN KEY(BankAccountID) REFERENCES BankAccounts(ID),
22FOREIGN KEY(ItemID) REFERENCES Items(ID)
23)