--
-- Copyright 2005-2016 The Kuali Foundation
--
-- Licensed under the Educational Community 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.opensource.org/licenses/ecl2.php
--
-- 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.
--

CREATE TABLE KRTST_PARENT_GEN_KEY_T
    ( GENERATED_PK_COL DECIMAL(8) )
/
CREATE TABLE KRTST_PARENT_GEN_KEY_CHILD_T
    ( GENERATED_PK_COL DECIMAL(8)
    , CHILDS_PK_COL DECIMAL(8) )
/
CREATE TABLE KRTST_GENERATED_PK_S  ( 
	id	bigint(19) AUTO_INCREMENT NOT NULL,
	PRIMARY KEY(id)
)
ENGINE = MyISAM
AUTO_INCREMENT = 10000
/
CREATE TABLE KRTST_PARENT_OF_UPDATABLE_T
    ( PK_COL DECIMAL(8),
    UPDATABLE_CHILD_KEY_COL VARCHAR(10) )
/
CREATE TABLE KRTST_UPDATABLE_CHILD_T
    ( PK_COL VARCHAR(10), SOME_DATA_COL VARCHAR(40) )
/
