text: --*********************************************************************************
  -- $URL$
  -- $Id$
  --**********************************************************************************
  --
  -- Copyright (c) 2008 Etudes, Inc.
  -- 
  -- Portions completed before September 1, 2008
  -- Copyright (c) 2007, 2008 The Regents of the University of Michigan & Foothill College, ETUDES Project
  --
  -- Licensed under the Apache License, Version 2.0 (the "License");
  -- you may not use this file except in compliance with the License.
  -- You may obtain a copy of the License at
  -- 
  --      http://www.apache.org/licenses/LICENSE-2.0
  -- 
  -- Unless required by applicable law or agreed to in writing, software
  -- distributed under the License is distributed on an "AS IS" BASIS,
  -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  -- See the License for the specific language governing permissions and
  -- limitations under the License.
  --
  --*********************************************************************************/
  
  -----------------------------------------------------------------------------
  -- Mneme Pool DDL
  -----------------------------------------------------------------------------
  
  CREATE TABLE MNEME_POOL
  (
  	CONTEXT				VARCHAR (99),
  	CREATED_BY_DATE		BIGINT,
  	CREATED_BY_USER		VARCHAR (99),
  	DESCRIPTION			LONGTEXT,
  	DIFFICULTY			CHAR (1),
  	HISTORICAL			CHAR (1),
  	ID					BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
  	MINT				CHAR (1),
  	MODIFIED_BY_DATE	BIGINT,
  	MODIFIED_BY_USER	VARCHAR (99),
  	POINTS				FLOAT,
  	TITLE				VARCHAR (255)
  );
  
  CREATE INDEX MNEME_POOL_IDX_CMH ON MNEME_POOL
  (
  	CONTEXT		ASC,
  	MINT		ASC,
  	HISTORICAL	ASC
  );
  
  CREATE INDEX MNEME_POOL_IDX_M ON MNEME_POOL
  (
  	MINT		ASC
  );
  