Skip to content

Instantly share code, notes, and snippets.

View brewdium's full-sized avatar

Stephen de Bruin brewdium

  • Adelaide
View GitHub Profile

Keybase proof

I hereby claim:

  • I am spazworm on github.
  • I am spazworm (https://keybase.io/spazworm) on keybase.
  • I have a public key whose fingerprint is 8E04 E935 771F 97A6 ED86 8985 76BC E144 1A99 43EB

To claim this, I am signing this object:

@brewdium
brewdium / CreateTableInDerby
Created March 13, 2015 04:22
Table Creation in Derby including primary key, auto increment and current timespamp
CREATE TABLE Contacts
(
id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1),
firstname VARCHAR(30),
lastname VARCHAR(30),
telephone VARCHAR(15),
email VARCHAR(30),
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT primary_key PRIMARY KEY (id)
) ;