# This file contains the DaoGen generated SQL command to create
# the CUSTOMER table in your database server. There is also few
# insert commands to get some sample data for the example programs.
# Execute these commands as they are if you want to use the examples.

CREATE TABLE CUSTOMER (
      NUMBER bigint NOT NULL,
      NAME varchar(255),
      ADDRESS varchar(255),
      CREATED date,
      BALANCE bigint,
PRIMARY KEY(NUMBER),
INDEX CUSTOMER_NUMBER_INDEX (NUMBER),
INDEX CUSTOMER_NAME_INDEX (NAME));



INSERT INTO CUSTOMER (NUMBER, NAME, ADDRESS, CREATED, BALANCE) 
VALUES (1, 'Scooby Doo', 'DaoGen street 1A', NOW(), 100);

INSERT INTO CUSTOMER (NUMBER, NAME, ADDRESS, CREATED, BALANCE) 
VALUES (2, 'George Bush', 'The White House', NOW(), 200);

INSERT INTO CUSTOMER (NUMBER, NAME, ADDRESS, CREATED, BALANCE) 
VALUES (3, 'Nemo, the Fish', 'Pasific Ocean', NOW(), 500);