MEDIK_TABLE_LOADER.SQL

---

	-- DROP PUBLIC SYNONYM  MLO_LO10_DATA_LOADER;
	-- DROP TABLE           LO10_DATA_LOADER;

	CREATE TABLE  LO10_DATA_LOADER
		(	DATA			VARCHAR2(1024),
			ZDROJ			VARCHAR2(128)    NOT NULL,
			uzivatel		VARCHAR2(30)     NOT NULL,
			DATUM			DATE             NOT NULL
		)
	TABLESPACE MEDIK STORAGE (initial 32M  next 16M);


	CREATE INDEX  LO10_DATA_LOADER_I0
	ON            LO10_DATA_LOADER (ZDROJ ASC, DATA)
	              TABLESPACE MEDIK STORAGE ( initial 24M  next 16M);

	CREATE INDEX  LO10_DATA_LOADER_I1
	ON            LO10_DATA_LOADER (DATA ASC, ZDROJ)
	              TABLESPACE MEDIK STORAGE ( initial 24M  next 16M);

	CREATE INDEX  LO10_DATA_LOADER_I2
	ON            LO10_DATA_LOADER (ZDROJ ASC)
	              TABLESPACE MEDIK STORAGE ( initial 8M  next 8M);

	CREATE PUBLIC SYNONYM	MLO_LO10_DATA_LOADER  FOR  LOADER.LO10_DATA_LOADER;