-- 
-- BANCO DE DADOS: `SYSIBM`
-- 

-- 
-- ESTRUTURA DA TABELA `SYSCOLUMNS`
-- 

CREATE TABLE SYSCOLUMNS (
  NAME CHAR(18) NOT NULL ,
  TBNAME CHAR(18) NOT NULL ,
  TBCREATOR CHAR(8) NOT NULL ,
  COLNO SMALLINT(6) NOT NULL ,
  COLTYPE CHAR(15) NOT NULL ,
  LENGTH SMALLINT(6) NOT NULL ,
  SCALE SMALLINT(6) NOT NULL ,
  NULLS CHAR(1) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSCOPY`
-- 

CREATE TABLE SYSCOPY (
  DBNAME CHAR(8) NOT NULL ,
  TSNAME CHAR(8) NOT NULL ,
  DSNUM SMALLINT(6) NOT NULL ,
  ICTYPE CHAR(1) NOT NULL ,
  TIMESTAMP CHAR(26) NOT NULL ,
  DSNAME CHAR(40) NOT NULL ,
  KEY COPYX2 (DBNAME,TSNAME,TIMESTAMP)
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSDATABASE`
-- 

CREATE TABLE SYSDATABASE (
  NAME CHAR(8) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSDUMMY1`
-- 

CREATE TABLE SYSDUMMY1 (
  DUMMY1 TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSFOREIGNKEYS`
-- 

CREATE TABLE SYSFOREIGNKEYS (
  CREATOR CHAR(8) NOT NULL ,
  TBNAME CHAR(18) NOT NULL ,
  RELNAME CHAR(8) NOT NULL ,
  COLNAME CHAR(18) NOT NULL ,
  COLNO SMALLINT(6) NOT NULL ,
  COLSEQ SMALLINT(6) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSINDEXES`
-- 

CREATE TABLE SYSINDEXES (
  NAME CHAR(18) NOT NULL ,
  CREATOR CHAR(8) NOT NULL ,
  TBNAME CHAR(18) NOT NULL ,
  TBCREATOR CHAR(8) NOT NULL ,
  UNIQUERULE CHAR(1) NOT NULL ,
  COLCOUNT SMALLINT(6) NOT NULL ,
  CLUSTERING CHAR(1) NOT NULL ,
  CLUSTERED CHAR(1) NOT NULL ,
  FIRSTKEYCARD INT(11) NOT NULL ,
  FULLKEYCARD INT(11) NOT NULL ,
  NLEAF INT(11) NOT NULL ,
  NLEVELS INT(11) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSINDEXPART`
-- 

CREATE TABLE SYSINDEXPART (
  IXNAME CHAR(1) NOT NULL ,
  IXCREATOR CHAR(1) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSKEYS`
-- 

CREATE TABLE SYSKEYS (
  IXNAME CHAR(18) NOT NULL ,
  IXCREATOR CHAR(8) NOT NULL ,
  COLNAME CHAR(18) NOT NULL ,
  COLNO SMALLINT(6) NOT NULL ,
  COLSEQ SMALLINT(6) NOT NULL ,
  ORDERING CHAR(1) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSPACKDEP`
-- 

CREATE TABLE SYSPACKDEP (
  BNAME VARCHAR(18) DEFAULT NULL,
  BQUALIFIER VARCHAR(8) DEFAULT NULL,
  BTYPE CHAR(1) DEFAULT NULL,
  DLOCATION VARCHAR(16) DEFAULT NULL,
  DCOLLID VARCHAR(18) DEFAULT NULL,
  DNAME VARCHAR(8) DEFAULT NULL,
  DCONTOKEN VARCHAR(8) DEFAULT NULL,
  IBMREQD CHAR(1) DEFAULT NULL,
  DOWNER VARCHAR(8) DEFAULT NULL,
  DTYPE CHAR(1) DEFAULT NULL
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSPLANDEP`
-- 

CREATE TABLE SYSPLANDEP (
  BNAME CHAR(8) NOT NULL ,
  BCREATOR CHAR(8) NOT NULL ,
  BTYPE CHAR(1) NOT NULL ,
  DNAME CHAR(8) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSRELS`
-- 

CREATE TABLE SYSRELS (
  CREATOR CHAR(8) NOT NULL ,
  TBNAME CHAR(8) NOT NULL ,
  RELNAME CHAR(8) NOT NULL ,
  REFTBNAME CHAR(8) NOT NULL ,
  REFTBCREATOR CHAR(8) NOT NULL ,
  DELETERULE CHAR(1) NOT NULL ,
  IXNAME CHAR(8) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSTABLEPART`
-- 

CREATE TABLE SYSTABLEPART (
  DBNAME CHAR(8) NOT NULL ,
  TSNAME CHAR(8) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSTABLES`
-- 

CREATE TABLE SYSTABLES (
  NAME CHAR(18) NOT NULL ,
  CREATOR CHAR(8) NOT NULL ,
  TYPE CHAR(1) NOT NULL ,
  DBNAME CHAR(8) NOT NULL ,
  TSNAME CHAR(8) NOT NULL ,
  COLCOUNT SMALLINT(6) NOT NULL ,
  CARD INT(11) NOT NULL ,
  NPAGES INT(11) NOT NULL ,
  PCTPAGES SMALLINT(6) NOT NULL ,
  RECLENGTH SMALLINT(6) NOT NULL ,
  PARENTS SMALLINT(6) NOT NULL ,
  CHILDREN SMALLINT(6) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSTRIGGERS`
-- 

CREATE TABLE SYSTRIGGERS (
  NAME VARCHAR(8) NOT NULL ,
  SCHEMA VARCHAR(8) NOT NULL ,
  SEQNO SMALLINT(2) NOT NULL ,
  DBID SMALLINT(2) NOT NULL ,
  OBID SMALLINT(2) NOT NULL ,
  OWNER VARCHAR(8) NOT NULL ,
  CREATEDBY VARCHAR(8) NOT NULL ,
  TBNAME VARCHAR(18) NOT NULL ,
  TBOWNER VARCHAR(8) NOT NULL ,
  TRIGTIME CHAR(1) NOT NULL ,
  TRIGEVENT CHAR(1) NOT NULL ,
  GRANULARITY CHAR(1) NOT NULL ,
  CREATEDTS TIMESTAMP NOT NULL,
  IBMREQD CHAR(1) NOT NULL ,
  TEXT TEXT NOT NULL,
  REMARKS VARCHAR(254) NOT NULL ,
  TRIGNAME VARCHAR(30) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSVIEWDEP`
-- 

CREATE TABLE SYSVIEWDEP (
  BNAME CHAR(8) NOT NULL ,
  BCREATOR CHAR(8) NOT NULL ,
  BTYPE CHAR(1) NOT NULL ,
  DNAME CHAR(8) NOT NULL ,
  DCREATOR CHAR(8) NOT NULL ,
  DTYPE CHAR(1) NOT NULL 
);

-- --------------------------------------------------------

-- 
-- ESTRUTURA DA TABELA `SYSVIEWS`
-- 

CREATE TABLE SYSVIEWS (
  NAME CHAR(8) NOT NULL ,
  CREATOR CHAR(8) NOT NULL ,
  SEQNO SMALLINT(6) DEFAULT NULL,
  TEXT CHAR(254) NOT NULL 
);
