/*C1*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM SALE WHERE ID=11
INSERT INTO SALE VALUES(11,'2008-11-05 22:59:09.749000000',NULL)
DELETE FROM SALE WHERE ID=13
INSERT INTO SALE VALUES(13,'2008-11-05 22:59:37.436000000',NULL)
DELETE FROM SALE WHERE ID=15
INSERT INTO SALE VALUES(15,'2008-11-18 15:12:02.343000000',NULL)
DELETE FROM SALE WHERE ID=16
INSERT INTO SALE VALUES(16,'2008-11-18 15:13:26.827000000',NULL)
DELETE FROM SALE WHERE ID=17
INSERT INTO SALE VALUES(17,'2008-11-18 15:15:17.281000000',NULL)
DELETE FROM CLIENT WHERE ID=2
COMMIT
DELETE FROM CLIENT WHERE ID=3
COMMIT
DELETE FROM SALE WHERE ID=14
INSERT INTO SALE VALUES(14,'2008-11-17 16:06:12.624000000',NULL)
DELETE FROM CLIENT WHERE ID=4
COMMIT
DELETE FROM CLIENT WHERE ID=6
COMMIT
DISCONNECT
/*C2*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table client add due_date date
\u000aalter table client add due_sale integer
DISCONNECT
