• Home
• org.sakaiproject.kernel
• sakai-kernel-impl
• 11.0
• source code
• sakai_locks.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

oracle.sakai_locks.sql Maven / Gradle / Ivy

-----------------------------------------------------------------------------
-- SAKAI_LOCKS
-----------------------------------------------------------------------------

CREATE TABLE SAKAI_LOCKS
(
	TABLE_NAME VARCHAR2 (64),
	RECORD_ID VARCHAR2 (512),
	LOCK_TIME DATE,
	USAGE_SESSION_ID VARCHAR2 (36)
);

CREATE UNIQUE INDEX SAKAI_LOCKS_INDEX ON SAKAI_LOCKS
(
	TABLE_NAME, RECORD_ID
);