/*******************************************************************************
 * For creating the tables used in the Wisconsin Benchmark on Oracle           *
 ******************************************************************************/

DROP TABLE r1;
CREATE TABLE r1  (unique1		NUMBER(10,0) PRIMARY KEY, 
        	 	unique2        	NUMBER(10,0),
	        	two            	NUMBER(1,0),
			four		NUMBER(1,0),
			ten		NUMBER(1,0),
			twenty		NUMBER(2,0),
			onePercent	NUMBER(2,0),
			tenPercent	NUMBER(1,0),
			twentyPercent	NUMBER(1,0),
			fiftyPercent	NUMBER(1,0),
			unique3		NUMBER(10,0),
			evenOnePercent	NUMBER(3,0),
			oddOnePercent	NUMBER(3,0),
			stringu1	VARCHAR2(52),
			stringu2	VARCHAR2(52),
			string4		VARCHAR2(52));

DROP TABLE r2;
DROP CLUSTER cl1;
CREATE CLUSTER CL1 (a integer) HASHKEYS 400;

CREATE TABLE r2  (unique1		NUMBER(10,0) PRIMARY KEY,
	         	unique2        	NUMBER(10,0),
	        	two            	NUMBER(1,0),
			four		NUMBER(1,0),
			ten		NUMBER(1,0),
			twenty		NUMBER(2,0),
			onePercent	NUMBER(2,0),
			tenPercent	NUMBER(1,0),
			twentyPercent	NUMBER(1,0),
			fiftyPercent	NUMBER(1,0),
			unique3		NUMBER(10,0),
			evenOnePercent	NUMBER(3,0),
			oddOnePercent	NUMBER(3,0),
			stringu1	VARCHAR2(52),
			stringu2	VARCHAR2(52),
			string4		VARCHAR2(52));
