dEi0zKbe

1DROP TABLE IF EXISTS ATTENDEE CASCADE;
2DROP TABLE IF EXISTS EVENT CASCADE;
3
4CREATE TABLE ATTENDEE (
5	ID INTEGER NOT NULL,
6	FIRST_NAME CHARACTER VARYING(256) NOT NULL,
7	LAST_NAME CHARACTER VARYING(256) NOT NULL,
8	SCANNED_VALUE CHARACTER VARYING(256) NOT NULL,
9	PRIMARY KEY ( ID )
10);
11
12CREATE TABLE EVENT (
13	ID INTEGER NOT NULL,
14	EVENT_NAME CHARACTER VARYING(256) NOT NULL,
15	EVENT_CITY CHARACTER VARYING(256) NOT NULL,
16	EVENT_COUNTRY CHARACTER(256) NOT NULL,
17	PRIMARY KEY ( ID )
18);