createtables.sql

应用程序和示例代码是针对一个环境

CREATE TABLE TICKET (
  ID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  SUMMARY VARCHAR(512) NOT NULL,
  DETAIL VARCHAR(2000),
  EMAIL VARCHAR(512) NOT NULL,
  SUBMITTED TIMESTAMP,
  LASTMODIFIED TIMESTAMP
);


INSERT INTO TICKET (SUMMARY, DETAIL, EMAIL, SUBMITTED, LASTMODIFIED) VALUES ('Not enough memory.','I do not have enough memory to run Microsoft Windows XP and Microsoft Word.', '[e-mail]',CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO TICKET (SUMMARY, DETAIL, EMAIL, SUBMITTED, LASTMODIFIED) VALUES ('Computer wont.','Nothing appears on the monitor even though the hard drive is on.', '[e-mail]', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO TICKET (SUMMARY, DETAIL, EMAIL, SUBMITTED, LASTMODIFIED) VALUES ('Windows Crashed Again','Windows always crashes when I turn on my computer.', '[e-mail]', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO TICKET (SUMMARY, DETAIL, EMAIL, SUBMITTED, LASTMODIFIED) VALUES ('Popups are slowing down my computer','I get so many popup adds, my computer is unusable.', '[e-mail]', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO TICKET (SUMMARY, DETAIL, EMAIL, SUBMITTED, LASTMODIFIED) VALUES ('Monitor flickers cool.','Everytime the heat comes on my monitor flickers.', '[e-mail]', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO TICKET (SUMMARY, DETAIL, EMAIL, SUBMITTED, LASTMODIFIED) VALUES ('Cannot connect to the network.','I can not see my network drives.', '[e-mail]', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO TICKET (SUMMARY, DETAIL, EMAIL, SUBMITTED, LASTMODIFIED) VALUES ('Not enough memory.','I do not have enough memory to run Microsoft Windows XP and Microsoft Word.', '[e-mail]', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);