· 6 years ago · Jul 15, 2019, 03:38 PM
1CREATE TABLE IF NOT EXISTS rgActualOutletRests (
2[id] integer NOT NULL PRIMARY KEY,
3[idOutlet] integer NOT NULL REFERENCES [refBuyPoints]([id]) DEFAULT 0,
4[idSKU] integer NOT NULL REFERENCES [refGoods]([id]),
5[Quantity] numeric NOT NULL,
6[deleted] bit NOT NULL DEFAULT 0,
7[verstamp] integer NOT NULL DEFAULT 0
8);