/*#ifndef MKSADB60_SQL_HEADER
**#define MKSADB60_SQL_HEADER
**static char SCCS_ID[] = @(#) LIV  2001/08/01 11:27:09   mksadb60.sql \main\callpilot2.0\1 ~
** LIV  2001/08/01 11:27:09   mksadb60.sql \main\callpilot2.0\1 ~
** [liv/Database/nbdb0078]
**
**#endif
*/
--  *************************************************************************
--  *       Copyright (C) 1988-2000, by Sybase, Inc.                        *
--  *       All rights reserved. No part of this software may be            *
--  *       reproduced in any form or by any means - graphic,               *
--  *       electronic or mechanical, including photocopying,               *
--  *       recording, taping or information storage and retrieval          *
--  *       systems - except with the written permission of                 *
--  *       Sybase, Inc.                                                    *
--  *************************************************************************
--
--  WARNING: This is a program generated file. Do not edit.
--
 
CREATE VARIABLE @avoid_view_collisions	char(1)
go
set @avoid_view_collisions = @ss_compatible
go
message lang_message(  7973  ) type info to client
go
create table SYS.SYSTABLE (
		       table_id			 unsigned int         NOT NULL,
		       file_id			smallint        NOT NULL,
		       count			 unsigned bigint     NOT NULL,
		       first_page		int             NOT NULL,
		       last_page		int             NOT NULL,
		       primary_root		int		NOT NULL,
		       creator			 unsigned int             NOT NULL,
		       
		       first_ext_page		int             NOT NULL,
		       last_ext_page		int             NOT NULL,
		       table_page_count		int             NOT NULL,
		       ext_page_count		int             NOT NULL,
		       
		       table_name		char(128)       NOT NULL,
		       table_type		char(10)        NOT NULL,
		       view_def			long varchar,
		       remarks			long varchar,
		       replicate		char(1)         NOT NULL,
		       
		       existing_obj		char(1),
		       remote_location		long varchar,
		       remote_objtype		char(1),
		       srvid			int,
		       server_type		char(4)		NOT NULL,
		       primary_hash_limit	smallint	NOT NULL
		       )
go
create table SYS.SYSCOLUMN (
			table_id     unsigned int             NOT NULL,
			column_id    unsigned int             NOT NULL,
			pkey        char(1)         NOT NULL,
			domain_id   smallint        NOT NULL,
			nulls       char(1)         NOT NULL,
			width       smallint        NOT NULL,
			scale       smallint        NOT NULL,
			estimate    int             NOT NULL,
		        
			max_identity bigint	    NOT NULL,
		        
			column_name char(128)       NOT NULL,
			remarks     long varchar,
			"default"   long varchar,
			"check"     long varchar,
			user_type   smallint,
			format_str  char(128),
			column_type char(1)	    NOT NULL,
			
			remote_name varchar(128),
			remote_type  unsigned int     
			)
go
alter table SYS.SYSTABLE add PRIMARY KEY ( table_id )
go
alter table SYS.SYSCOLUMN add PRIMARY KEY ( table_id, column_id )
go
create table SYS.SYSINDEX (
		       table_id     unsigned int     		NOT NULL,
		       index_id     unsigned int     		NOT NULL,
		       root        int			NOT NULL,
		       file_id     smallint		NOT NULL,
		       "unique"    char(1)		NOT NULL,	 
									
		       creator      unsigned int     		NOT NULL,
		       index_name  char(128)		NOT NULL,
		       remarks     long varchar,
		       index_type  char(4)		NOT NULL,
		       index_owner char(4)		NOT NULL,
		       hash_limit  smallint		NOT NULL,
		       PRIMARY KEY ( table_id, index_id )
		       )
go
create table SYS.SYSIXCOL (
		       table_id     unsigned int             NOT NULL,
		       index_id     unsigned int             NOT NULL,
		       sequence    smallint        NOT NULL,
		       column_id    unsigned int             NOT NULL,
		       "order"     char(1)         NOT NULL,
		       PRIMARY KEY ( table_id, index_id, sequence )
		       )
go
create table SYS.SYSFOREIGNKEY (
			    foreign_table_id	 unsigned int        NOT NULL,
			    foreign_key_id	smallint     NOT NULL,
			    primary_table_id	 unsigned int        NOT NULL,
			    root        	int             NOT NULL,
			    check_on_commit 	char(1)     NOT NULL,
			    nulls       	char(1)         NOT NULL,
			    role        	char(128)       NOT NULL,
			    remarks     	long varchar,
			    primary_index_id	 unsigned int        NOT NULL,
			    fk_not_enforced	char(1)		NOT NULL,
			    hash_limit		smallint	NOT NULL,
			    PRIMARY KEY ( foreign_table_id, foreign_key_id )
			    )
go
create table SYS.SYSFKCOL (
		       foreign_table_id  unsigned int        NOT NULL,
		       foreign_key_id smallint     NOT NULL,
		       foreign_column_id  unsigned int       NOT NULL,
		       primary_column_id  unsigned int       NOT NULL,
		       PRIMARY KEY ( foreign_table_id, foreign_key_id, foreign_column_id )
		       )
go
create table SYS.SYSFILE (
		      file_id     smallint        NOT NULL,
		      file_name   long varchar    NOT NULL,
		      dbspace_name char(128)      NOT NULL,
		      store_type  char( 8 )	  NOT NULL,
		      PRIMARY KEY ( file_id )
		      )
go
create table SYS.SYSDOMAIN (
			domain_id   smallint        NOT NULL,
			domain_name char(128)       NOT NULL,
			type_id	smallint	NOT NULL,
			"precision" smallint,
			PRIMARY KEY ( domain_id )
			)
go
create table SYS.SYSUSERPERM (
			  user_id      unsigned int             NOT NULL,
			  user_name   char(128)       NOT NULL,
			  password    binary(36),
			  resourceauth char(1)        NOT NULL,
			  dbaauth     char(1)         NOT NULL,
			  scheduleauth char(1)        NOT NULL,
			  publishauth char(1)         NOT NULL,
			  remotedbaauth char(1)       NOT NULL,
			  user_group  char(1)         NOT NULL,
			  remarks     long varchar,
			  PRIMARY KEY ( user_id )
			  )
go
create table SYS.SYSTABLEPERM (
			   stable_id    unsigned int             NOT NULL,
			   grantee      unsigned int             NOT NULL,
			   grantor      unsigned int             NOT NULL,
			   ttable_id    unsigned int             NOT NULL,
			   selectauth  char(1)         NOT NULL,
			   insertauth  char(1)         NOT NULL,
			   deleteauth  char(1)         NOT NULL,
			   updateauth  char(1)         NOT NULL,
			   updatecols  char(1)         NOT NULL,
			   alterauth   char(1)         NOT NULL,
			   referenceauth char(1)       NOT NULL,
			   PRIMARY KEY ( stable_id, grantee, grantor )
			   )
go
create table SYS.SYSCOLPERM (
			 table_id	 unsigned int             NOT NULL,
			 grantee     	 unsigned int             NOT NULL,
			 grantor     	 unsigned int             NOT NULL,
			 column_id   	 unsigned int             NOT NULL,
			 privilege_type	smallint	NOT NULL,
			 is_grantable	char(1)		NOT NULL,
			 PRIMARY KEY ( table_id, grantee, grantor, column_id, privilege_type
				       )
			 )
go
create table SYS.SYSOPTION (
			user_id      unsigned int             NOT NULL,
			"option"    char(128)       NOT NULL,
			"setting"   long varchar    NOT NULL,
			
			)
go
create table SYS.SYSGROUP (
		       group_id     unsigned int             NOT NULL,
		       group_member  unsigned int            NOT NULL,
		       PRIMARY KEY ( group_id, group_member )
		       )
go
create table SYS.SYSCOLLATION (
			   collation_id    smallint     NOT NULL,
			   collation_label char(10)     NOT NULL,
			   collation_name  char(128)    NOT NULL,
			   collation_order BINARY(1280) NOT NULL,
			   PRIMARY KEY ( collation_id )
			   )
go
insert into SYS.SYSFILE values (  0 , @dbfilename, 'SYSTEM' , 'SA')
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 1,	'smallint',	5,	5 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 2,	'integer',	4,	10 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 3,	'numeric',	2,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 4,	'float',	7,	7 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 5,	'double',	8,	15 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 6,	'date',	9,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 7,	'char',	1,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 8,	'char',	1,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 9,	'varchar',	12,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 10,	'long varchar',	-1,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 11,	'binary',	-2,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 12,	'long binary',	-4,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 13,	'timestamp',	11,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 14,	'time',	10,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 19,	'tinyint',	-6,	3 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 20,	'bigint',	-5,	20 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 21,	'unsigned int',	-9,	10 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 22,	'unsigned smallint',	-10,	5 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 23,	'unsigned bigint',	-11,	21 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 24,	'bit',	-7,	1 )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 25,	'java.lang.Object',	0,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 26,	'java serialization',	-4,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 27,	'decimal',	2,	NULL )
go
INSERT INTO SYS.SYSDOMAIN VALUES ( 28,	'varbinary',	-2,	NULL )
go
import collseqs.sql
import custom.sql
COMMIT WORK
go
RESET COLLATION @default_collation
go
message lang_message(  8641  ) + @default_collation type info to client
go
INSERT INTO SYS.SYSUSERPERM 
	VALUES (  0 , 'SYS', NULL, 'Y', 'Y', 'Y', 'N', 'N', 'Y', NULL )
go
INSERT INTO SYS.SYSUSERPERM 
	VALUES (  1 , 'DBA', NULL, 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL )
go
INSERT INTO SYS.SYSUSERPERM
	VALUES (  2 , 'PUBLIC', NULL, 'N', 'N', 'N', 'N', 'N', 'Y', NULL )
go
INSERT INTO SYS.SYSGROUP
	VALUES (  0 ,  2  )
go
INSERT INTO SYS.SYSGROUP
	VALUES (  2 ,  1  )
go
INSERT INTO SYS.SYSUSERPERM 
	VALUES (  3 , 'dbo', NULL, 'Y', 'Y', 'N', 'N', 'N', 'Y', NULL )
go
INSERT INTO SYS.SYSGROUP VALUES (  3 ,  2  )
go
INSERT INTO SYS.SYSGROUP VALUES (  0 ,  3  )
go
ALTER TABLE SYS.SYSOPTION ADD PRIMARY KEY ( user_id, "option" )
go
CREATE UNIQUE INDEX file_name ON SYSFILE( file_name )
go
CREATE TABLE SYS.SYSPROCEDURE (
	    proc_id		smallint    NOT NULL,
	    creator		 unsigned int     NOT NULL,
	    proc_name		char(128)   NOT NULL,
	    proc_defn		long varchar,
	    remarks		long varchar,
	    replicate		char(1)     NOT NULL,
	    srvid		int,
	    PRIMARY KEY (proc_id) )
go
GRANT SELECT on SYS.SYSPROCEDURE to SYS
go
CREATE TABLE SYS.SYSPROCPARM (
	    proc_id		smallint    NOT NULL,
	    parm_id		smallint    NOT NULL,
	    parm_type		smallint    NOT NULL,
	    parm_mode_in	char(1)	    NOT NULL,
	    parm_mode_out	char(1)	    NOT NULL,
	    domain_id		smallint    NOT NULL,
	    width		smallint    NOT NULL,
	    scale		smallint    NOT NULL,
	    parm_name		char(128)   NOT NULL,
	    remarks		long varchar,
	    "default"		long varchar,
	    user_type		int,
	    PRIMARY KEY (proc_id,parm_id))
go
GRANT SELECT on SYS.SYSPROCPARM to SYS
go
CREATE TABLE SYS.SYSTRIGGER (
	    trigger_id		smallint    NOT NULL,
	    table_id		 unsigned int         NOT NULL,
	    event		char(1)	    NOT NULL,
	    trigger_time	char(1)	    NOT NULL,
	    trigger_order	smallint,
	    foreign_table_id	 unsigned int     ,
	    foreign_key_id	smallint,
	    referential_action	char(1),
	    trigger_name	char(128),
	    trigger_defn	long varchar NOT NULL,
	    remarks		long varchar,
	    PRIMARY KEY (trigger_id ))
go
GRANT SELECT on SYS.SYSTRIGGER to SYS
go
CREATE TABLE SYS.SYSPROCPERM (
	    proc_id		smallint    NOT NULL,
	    grantee		 unsigned int         NOT NULL,
	    PRIMARY KEY ( proc_id, grantee) )
go
GRANT SELECT on SYS.SYSPROCPERM to SYS
go
CREATE TABLE SYS.SYSPUBLICATION (
    publication_id	 unsigned int         NOT NULL,
    creator		 unsigned int     	NOT NULL,
    publication_name	char(128)       NOT NULL,
    remarks		long varchar,
    type		char(1)		NOT NULL,
    PRIMARY KEY (publication_id)
) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSPUBLICATION to SYS
 go 
create table SYS.SYSARTICLE (
    publication_id	 unsigned int         NOT NULL,
    table_id		 unsigned int         NOT NULL,
    where_expr		long varchar,
    subscribe_by_expr	long varchar,
    query		char(1)		NOT NULL,
    PRIMARY KEY (publication_id, table_id)
) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSARTICLE to SYS
 go 
create table SYS.SYSARTICLECOL (
    publication_id	 unsigned int         NOT NULL,
    table_id		 unsigned int         NOT NULL,
    column_id		 unsigned int         NOT NULL,
    PRIMARY KEY (publication_id, table_id, column_id)
) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSARTICLECOL to SYS
 go 
create table SYS.SYSREMOTEUSER (
    user_id		 unsigned int         NOT NULL,
    consolidate		char(1)		NOT NULL,
    type_id		smallint	NOT NULL,
    address		long varchar	NOT NULL,
    frequency		char(1)		NOT NULL,
    send_time		time,
    log_send		numeric(20,0)	NOT NULL,
    time_sent		timestamp,
    log_sent		numeric(20,0)	NOT NULL,
    confirm_sent	numeric(20,0)	NOT NULL,
    send_count		integer		NOT NULL,
    resend_count	integer		NOT NULL,
    time_received	timestamp,
    log_received	numeric(20,0)	NOT NULL,
    confirm_received	numeric(20,0),
    receive_count	integer		NOT NULL,
    rereceive_count	integer		NOT NULL,
    PRIMARY KEY (user_id)
) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSREMOTEUSER to SYS
 go 
create table SYS.SYSSUBSCRIPTION (
    publication_id	 unsigned int         NOT NULL,
    user_id		 unsigned int         NOT NULL,
    subscribe_by	char(128)	NOT NULL,
    created		numeric(20,0)	NOT NULL,
    started		numeric(20,0),
    PRIMARY KEY (publication_id, user_id, subscribe_by)
) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSSUBSCRIPTION to SYS
 go 
CREATE table SYS.SYSUSERMESSAGES (
	    error	int		NOT NULL,	
	    uid		 unsigned int     	NOT NULL,
	    description varchar(255)	NOT NULL,
	    langid	smallint	NOT NULL,
	    unique (error,langid)
	    ) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSUSERMESSAGES TO SYS, PUBLIC
 go 
	
CREATE table SYS.SYSUSERTYPE (
	    type_id		smallint	NOT NULL,
	    creator		 unsigned int     	NOT NULL,
	    domain_id		smallint	NOT NULL,
	    nulls		char(1)		NOT NULL,
	    width		smallint	NOT NULL,
	    scale		smallint	NOT NULL,
	    type_name		char(128)	NOT NULL,
	    "default"		long varchar	NULL,
	    "check"		long varchar	NULL,
	    format_str  	char(128),
	    super_type_id	smallint	NULL,
	    unique	(type_name),
	    primary key (type_id)
	    ) IN SYSTEM
 go 
ALTER TABLE SYS.SYSUSERTYPE ADD FOREIGN KEY super_type_id references
    SYS.SYSUSERTYPE( type_id )
 go 
GRANT SELECT on SYS.SYSUSERTYPE TO SYS, PUBLIC
 go 
CREATE table SYS.SYSEXTENT (
	    file_id	smallint	NOT NULL,
            extent_id   smallint        NOT NULL,
            first_page  int             NOT NULL,
            last_page   int             NOT NULL,
            file_name   long varchar    NOT NULL,
	    primary key (file_id, extent_id),
	    ) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSEXTENT TO SYS, PUBLIC
 go 
CREATE table SYS.SYSREMOTETYPE (
	    type_id		smallint        NOT NULL,
	    type_name		char(128)       NOT NULL,
	    publisher_address	long varchar	NOT NULL,
	    remarks		long varchar,
	    PRIMARY KEY (type_id)
	) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSREMOTETYPE to SYS
 go 
CREATE table SYS.SYSREMOTEOPTIONTYPE (
	    option_id 		 unsigned int 	NOT NULL,
	    type_id		smallint	NOT NULL,
	    "option"		varchar( 128 )  NOT NULL,
	    PRIMARY KEY ( option_id )
	)
 go 
GRANT SELECT on SYS.SYSREMOTEOPTIONTYPE to SYS
 go 
CREATE table SYS.SYSREMOTEOPTION (
	    option_id		 unsigned int 	NOT NULL,
	    user_id		 unsigned int 	NOT NULL,
	    "setting"		varchar( 255 )	NOT NULL,
	    PRIMARY KEY ( option_id, user_id )
	)
 go 
GRANT SELECT on SYS.SYSREMOTEOPTION to SYS
 go 
CREATE view SYS.SYSREMOTEOPTIONS
         as SELECT type_name,
	           user_name,
		   "option",
		   "setting"
	    FROM SYS.SYSREMOTETYPE srt,
	         SYS.SYSREMOTEOPTIONTYPE srot,
		 SYS.SYSREMOTEOPTION sro,
		 SYS.SYSUSERPERM sup
	    WHERE srt.type_id = srot.type_id
	      AND srot.option_id = sro.option_id
	      AND sro.user_id = sup.user_id
 go 
GRANT SELECT on SYS.SYSREMOTEOPTIONS to SYS
 go 
	
CREATE TABLE SYS.SYSSQLSERVERTYPE (
	    ss_user_type	    smallint	NOT NULL,
	    ss_domain_id	    smallint  	NOT NULL,
	    ss_type_name	    varchar(30)	NOT NULL,
	    primary_sa_domain_id    smallint	NOT NULL,
	    primary_sa_user_type    smallint	NULL,
	    PRIMARY KEY ( ss_user_type )
	) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSSQLSERVERTYPE TO SYS, PUBLIC
 go 
CREATE TABLE SYS.SYSTYPEMAP (
	    ss_user_type	    smallint 	NOT NULL,
	    sa_domain_id	    smallint 	NOT NULL,
	    sa_user_type	    smallint	NULL,
	    nullable		    char(1)	NULL
	) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSTYPEMAP TO SYS, PUBLIC
 go 
CREATE table SYS.SYSSYNC (
    sync_id		 unsigned int 	NOT NULL,
    type		char(1)		NOT NULL,
    publication_id	 unsigned int         NOT NULL,
    progress		numeric(20,0),
    site_name		char(128),
    "option"		long varchar,
    server_connect	long varchar,
    server_conn_type	long varchar,
    PRIMARY KEY( sync_id )
)
 go 
GRANT SELECT on SYS.SYSSYNC to SYS
 go 
CREATE view SYS.SYSSYNCS
	as select
	    (select publication_name from SYS.SYSPUBLICATION p
		where p.publication_id = s.publication_id) as publication_name,
	    progress, site_name, "option", server_connect, server_conn_type
	FROM SYS.SYSSYNC s
 go 
GRANT SELECT on SYS.SYSSYNCS to SYS
 go 
CREATE INDEX sync_type ON SYSSYNC
	( type )
 go 
CREATE INDEX sync_site_name ON SYSSYNC
	( site_name )
 go 
	
CREATE view SYS.SYSSYNCDEFINITIONS
	as select
	    sync_id, 
	    (select publication_name from SYS.SYSPUBLICATION p
		where p.publication_id = s.publication_id) as publication_name,
	    progress, site_name, "option", server_connect,
	    server_conn_type
	FROM SYS.SYSSYNC s where type = 'D'
 go 
GRANT SELECT on SYS.SYSSYNCDEFINITIONS to SYS
 go 
CREATE view SYS.SYSSYNCTEMPLATES
	as select
	    sync_id, 
	    (select publication_name from SYS.SYSPUBLICATION p
		where p.publication_id = s.publication_id) as publication_name,
	    "option", server_connect, server_conn_type
	FROM SYS.SYSSYNC s where type = 'T'
 go 
GRANT SELECT on SYS.SYSSYNCTEMPLATES to SYS
 go 
CREATE view SYS.SYSSYNCSITES
	as select
	    sync_id, 
	    (select publication_name from SYS.SYSPUBLICATION p
		where p.publication_id = s.publication_id) as publication_name,
	    site_name, "option", server_connect, server_conn_type
	FROM SYS.SYSSYNC s where type = 'S'
 go 
GRANT SELECT on SYS.SYSSYNCSITES to SYS
 go 
commit
go
CREATE TABLE SYS.SYSLOGIN (
	    integrated_login_id	    char(128) 	NOT NULL,
	    login_uid		     unsigned int      	NOT NULL,
	    remarks		    long varchar,
	    PRIMARY KEY ( integrated_login_id )
	) IN SYSTEM
 go 
if not exists( select * from SYS.SYSTABLE where table_name = 'SYSEVENTTYPE' and creator = 0 ) then
    create table SYSEVENTTYPE (
	event_type_id	    int		    not null primary key,
	name		    varchar(128)    not null unique,
	description	    long varchar    null
    );
    GRANT SELECT on SYS.SYSEVENTTYPE to SYS;
end if
go
commit
go
if not exists( select * from SYS.SYSTABLE where table_name = 'SYSEVENT' and creator = 0 ) then
    create table SYSEVENT (
	event_id	    int		    not null primary key,
	creator		     unsigned int         not null,
	event_name	    varchar(128)    not null unique,
	enabled		    char(1)	    not null,
	location	    char(1)	    not null,
	event_type_id	    int		    null,
	action		    long varchar    null,
	external_action	    long varchar    null,
	condition	    long varchar    null,
	remarks 	    long varchar    null
    );
    GRANT SELECT on SYS.SYSEVENT to SYS;
    alter table SYSEVENT add foreign key for SYSEVENTTYPE;
    alter table SYSEVENT add foreign key for SYSUSERPERM
	( creator is user_id );
end if
go
commit
go
if not exists( select * from SYS.SYSTABLE where table_name = 'SYSSCHEDULE' and creator = 0 ) then
    create table SYSSCHEDULE (
	event_id	    int		    not null,
	sched_name	    varchar(128)    not null,
	recurring	    tinyint	    not null,
	start_time	    time	    not null,
	stop_time	    time	    null,
	start_date	    date	    null,
	days_of_week	    tinyint	    null,
	days_of_month	    unsigned int    null,
	interval_units	    char(10)	    null,
	interval_amt	    int		    null,
	primary key (event_id, sched_name)
    );
    GRANT SELECT on SYS.SYSSCHEDULE to SYS;
    alter table SYSSCHEDULE add foreign key for SYSEVENT;
end if
go    
commit
go
--  *************************************************************************
--  *       Copyright (C) 1988-2000, by Sybase, Inc.                        *
--  *       All rights reserved. No part of this software may be            *
--  *       reproduced in any form or by any means - graphic,               *
--  *       electronic or mechanical, including photocopying,               *
--  *       recording, taping or information storage and retrieval          *
--  *       systems - except with the written permission of                 *
--  *       Sybase, Inc.                                                    *
--  *************************************************************************
--
--  WARNING: This is a program generated file. Do not edit.
--
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 0 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 0, 'GrowDB', 'database file extended' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 1 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 1, 'GrowLog', 'transaction log extended' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 2 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 2, 'GrowTemp', 'temporary file extended' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 3 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 3, 'DatabaseStart', 'database started' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 4 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 4, 'ServerIdle', 'server idle' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 5 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 5, 'Connect', 'user connected' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 6 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 6, 'Disconnect', 'user disconnected' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 7 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 7, 'ConnectFailed', 'connect failed' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 8 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 8, 'RAISERROR', 'RAISERROR issued' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 9 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 9, 'BackupEnd', 'backup completed' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 10 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 10, 'DBDiskSpace', 'database disk space checked' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 11 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 11, 'LogDiskSpace', 'transaction log disk space checked' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 12 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 12, 'TempDiskSpace', 'temporary file disk space checked' )
end if
go
if not exists( select * from SYS.SYSEVENTTYPE where event_type_id = 13 ) then
    insert into SYSEVENTTYPE (event_type_id, name, description)
        values( 13, 'GlobalAutoincrement', 'global autoincrement near end of range' )
end if
go
commit
go
create table SYS.SYSJAR (
		jar_id		integer   	not null,
		creator		 unsigned int         not null,
		jar_name	long varchar	not null,
		jar_file	long varchar,
		create_time	timestamp	not null,
		update_time	timestamp	not null,
		remarks		long varchar,
		primary key ( jar_id )
	)
go
GRANT SELECT on SYS.SYSJAR to SYS
go
create table SYS.SYSJAVACLASS (
		class_id		integer		not null,
		replaced_by		integer,
		creator			 unsigned int         not null,
		jar_id			integer,
		type_id			smallint,
		class_name		long varchar	not null,
		public			char(1)		not null,
		component_id		integer,
		create_time		timestamp	not null,
		update_time		timestamp	not null,
		class_descriptor	long binary,
		remarks			long varchar,
		primary key ( class_id ),
		foreign key ( replaced_by )
			references SYS.SYSJAVACLASS( class_id )
	)
go
GRANT SELECT on SYS.SYSJAVACLASS to SYS
go
create table SYS.SYSJARCOMPONENT (
		component_id		integer		not null,
		jar_id			integer,
		component_name		long varchar,
		component_type		char(1),
		create_time		timestamp	not null,
		contents		long binary,
		remarks			long varchar,
		primary key ( component_id )
	)
go
GRANT SELECT on SYS.SYSJARCOMPONENT to SYS
go
create table SYS.SYSCOLLATIONMAPPINGS (
			   collation_label char(10)     NOT NULL,
			   collation_name  char(128)    NOT NULL,
			   cs_label	   char(128),
			   so_case_label   char(128),
			   so_caseless_label char(128),
			   jdk_label       char(128),
			   PRIMARY KEY ( collation_label )
			   )
go
GRANT SELECT on SYS.SYSCOLLATIONMAPPINGS to SYS
go
import collsqmp.sql
import custmap.sql
--  *************************************************************************
--  *       Copyright (C) 1988-2000, by Sybase, Inc.                        *
--  *       All rights reserved. No part of this software may be            *
--  *       reproduced in any form or by any means - graphic,               *
--  *       electronic or mechanical, including photocopying,               *
--  *       recording, taping or information storage and retrieval          *
--  *       systems - except with the written permission of                 *
--  *       Sybase, Inc.                                                    *
--  *************************************************************************
--
--  WARNING: This is a program generated file. Do not edit.
--
CREATE TABLE SYS.SYSSERVERS (
	    srvid		int 	NOT NULL,
	    srvname		varchar(128)	NOT NULL,
	    srvclass		long varchar	NOT NULL,
	    srvinfo		long varchar,
	    srvreadonly		char(1)		NOT NULL,
	    PRIMARY KEY ( srvid )
	) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSSERVERS TO SYS
 go 
CREATE TABLE SYS.SYSEXTERNLOGINS (
	    user_id		 unsigned int  	NOT NULL,
	    srvid		int 	NOT NULL,
	    remote_login	varchar(128),
	    remote_password	varbinary(128),
	    PRIMARY KEY ( user_id, srvid )
	) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSEXTERNLOGINS TO SYS
 go 
alter table SYS.SYSEXTERNLOGINS add foreign key for SYS.SYSUSERPERM
	( user_id is user_id )
 go 
    
alter table SYS.SYSEXTERNLOGINS add foreign key for SYS.SYSSERVERS
	( srvid is srvid )
 go 
    
alter table SYS.SYSTABLE add foreign key for SYS.SYSSERVERS
	( srvid is srvid )
 go 
CREATE TABLE SYS.SYSCAPABILITY (
	    capid		int 	NOT NULL,
	    srvid		int 	NOT NULL,
	    capvalue		char(128) NOT NULL,
	    PRIMARY KEY ( capid, srvid )
	) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSCAPABILITY TO SYS
 go 
CREATE TABLE SYS.SYSCAPABILITYNAME (
	    capid		int 	NOT NULL,
	    capname		char(128) NOT NULL,
	    PRIMARY KEY ( capid )
	) IN SYSTEM
 go 
GRANT SELECT on SYS.SYSCAPABILITYNAME TO SYS
 go 
CREATE VIEW SYS.SYSCAPABILITIES AS
	SELECT t1.capid, srvid, capname, capvalue
	FROM SYSCAPABILITY t1 JOIN SYSCAPABILITYNAME t2
	ON t1.capid = t2.capid
 go 
GRANT SELECT on SYS.SYSCAPABILITIES TO SYS
 go 
alter table SYS.SYSCAPABILITY add foreign key for SYS.SYSSERVERS
	( srvid is srvid )
 go 
    
alter table SYS.SYSCAPABILITY add foreign key for SYS.SYSCAPABILITYNAME
	( capid is capid )
 go 
    
alter table SYS.SYSPROCEDURE add foreign key for SYS.SYSSERVERS
	( srvid is srvid )
 go 
--  *************************************************************************
--  *       Copyright (C) 1988-2000, by Sybase, Inc.                        *
--  *       All rights reserved. No part of this software may be            *
--  *       reproduced in any form or by any means - graphic,               *
--  *       electronic or mechanical, including photocopying,               *
--  *       recording, taping or information storage and retrieval          *
--  *       systems - except with the written permission of                 *
--  *       Sybase, Inc.                                                    *
--  *************************************************************************
--
--  WARNING: This is a program generated file. Do not edit.
--
INSERT INTO SYSCAPABILITYNAME VALUES( 1, 'Alter table with add' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 2, 'Alter table with drop' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 3, 'Owner supported' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 4, 'Primary key requires index' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 5, 'Create table constraints' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 6, 'Truncate table' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 7, 'Create index' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 8, 'Create unique index' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 9, 'Syscapability system table initialized' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 10, 'Subquery' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 11, 'Subquery in group by' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 12, 'Subquery in comparison' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 13, 'Subquery in exist' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 14, 'Subquery in IN' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 15, 'Subquery correlated' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 16, 'Subquery in select list' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 17, 'Subquery in update' );
 go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 18, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 19, NULL );
--  go 
INSERT INTO SYSCAPABILITYNAME VALUES( 20, 'Order by' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 21, 'Order by expressions' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 22, 'Order by column not in select list' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 23, 'Order by allowed in update' );
 go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 24, NULL );
--  go 
INSERT INTO SYSCAPABILITYNAME VALUES( 25, 'Joins' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 26, 'Outer joins' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 27, 'Full outer joins' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 28, 'Multiple outer joins' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 29, 'Logical operators in outer join' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 30, 'Outer joins mixed with normal joins' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 31, 'ANSI join syntax' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 32, 'TSQL join syntax' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 33, 'ODBC outer join syntax' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 34, 'Unrestricted ANSI ON' );
 go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 35, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 36, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 37, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 38, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 39, NULL );
--  go 
INSERT INTO SYSCAPABILITYNAME VALUES( 40, 'Group by' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 41, 'Group by ALL' );
 go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 42, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 43, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 44, NULL );
--  go 
INSERT INTO SYSCAPABILITYNAME VALUES( 45, 'Aggregates' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 46, 'Aggregates with column name' );
 go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 47, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 48, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 49, NULL );
--  go 
INSERT INTO SYSCAPABILITYNAME VALUES( 50, 'And' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 51, 'Or' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 52, 'Like' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 53, 'Like - TSQL' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 54, 'Distinct' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 55, 'In' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 56, 'Case expression' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 57, 'For update clause required' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 58, 'Expressions, minimum' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 59, 'Expressions, ANSI' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 60, 'Expressions, TSQL' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 61, 'update/delete allow multiple tables' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 62, 'Insert select' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 63, 'Insert select with order by' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 64, 'Holdlock' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 65, 'Case sensitivity' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 66, 'Insert' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 67, 'Update' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 68, 'Delete' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 69, 'List' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 70, 'ASE function names' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 71, 'DB2 function names' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 72, 'Textpointers' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 73, 'Positioned updates via rowid' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 74, 'Position updates and deletes' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 75, 'Update table list' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 76, 'Union' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 77, 'Union all' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 78, 'Having' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 79, 'Having without group by' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 80, 'Current constants' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 81, 'Identity, ASE' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 82, 'Identity, ASA' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 83, 'Default' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 84, 'ODBC function escapes' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 85, 'Correlation names' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 86, 'Derived tables' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 87, 'Correlation names in update' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 88, 'Database names can be quoted' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 89, 'Reserved 89' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 90, 'Reserved 90' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 91, 'Reserved 91' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 92, 'ANSI Concatenate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 93, 'TSQL Concatenate' );
 go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 94, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 95, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 96, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 97, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 98, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 99, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 100, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 101, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 102, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 103, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 104, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 105, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 106, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 107, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 108, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 109, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 110, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 111, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 112, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 113, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 114, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 115, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 116, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 117, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 118, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 119, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 120, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 121, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 122, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 123, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 124, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 125, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 126, NULL );
--  go 
-- INSERT INTO SYSCAPABILITYNAME VALUES( 127, NULL );
--  go 
INSERT INTO SYSCAPABILITYNAME VALUES( 128, 'today' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 129, 'substr' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 130, 'substring' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 131, 'ifnull' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 132, 'argn' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 133, 'days' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 134, 'second' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 135, 'minute' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 136, 'hour' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 137, 'day' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 138, 'month' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 139, 'hours' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 140, 'minutes' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 141, 'seconds' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 142, 'number' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 143, 'identity' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 144, 'now' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 145, 'remainder' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 146, 'mod' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 147, 'weeks' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 148, 'datetime' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 149, 'date' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 150, 'explanation' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 151, 'plan' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 152, 'ulplan' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 153, 'traceback' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 154, 'atn2' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 155, 'char' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 156, 'estimate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 157, 'estimate-source' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 158, 'index_estimate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 159, 'experience_estimate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 160, 'tsequal' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 161, 'dayname' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 162, 'monthname' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 163, 'quarter' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 164, 'truncate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 165, 'datalength' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 166, 'db_id' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 167, 'db_name' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 168, 'property_name' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 169, 'property_description' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 170, 'property_number' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 171, 'next_connection' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 172, 'next_database' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 173, 'property' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 174, 'connection_property' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 175, 'db_property' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 176, 'textptr' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 177, 'rowid' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 178, 'user id' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 179, 'user name' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 180, 'suser id' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 181, 'suser name' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 182, 'cot' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 183, 'degrees' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 184, 'exp' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 185, 'floor' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 186, 'log' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 187, 'log10' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 188, 'pi' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 189, 'power' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 190, 'radians' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 191, 'rand' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 192, 'round' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 193, 'sign' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 194, 'sin' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 195, 'sqrt' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 196, 'tan' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 197, 'datepart' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 198, 'datadiff' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 199, 'datename' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 200, 'dateadd' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 201, 'hextoint' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 202, 'inttohex' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 203, 'convert' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 204, 'getdate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 205, 'pattern' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 206, 'byte length' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 207, 'byte substr' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 208, 'insertstr' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 209, 'lcase' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 210, 'ucase' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 211, 'left' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 212, 'length' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 213, 'locate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 214, 'repeat' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 215, 'similar' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 216, 'trim' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 217, 'ascii' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 218, 'asciichar' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 219, 'charindex' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 220, 'charlen' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 221, 'difference' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 222, 'lower' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 223, 'ltrim' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 224, 'patindex' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 225, 'replicate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 226, 'reverse' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 227, 'right' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 228, 'rtrim' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 229, 'soundex' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 230, 'space' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 231, 'str' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 232, 'stuff' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 233, 'upper' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 234, 'abs' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 235, 'acos' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 236, 'asin' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 237, 'atan' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 238, 'atan2' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 239, 'ceiling' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 240, 'cos' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 241, 'isnull' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 242, 'coalesce' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 243, 'string' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 244, 'ymd' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 245, 'todate' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 246, 'months' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 247, 'year' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 248, 'years' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 249, 'dateformat' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 250, 'dow' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 251, 'nullif' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 252, 'char_length' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 253, 'replace' );
 go 
INSERT INTO SYSCAPABILITYNAME VALUES( 254, 'Contains' );
 go 
if @is_IQ_database = 'Y' then
CREATE DATATYPE hs_blockmapidentity	binary(128)
;
CREATE DATATYPE hs_vdoidentity		binary(256)
;
CREATE DATATYPE hs_vdorecid		binary(16)
;
CREATE DATATYPE rowid			unsigned bigint
;
CREATE DATATYPE	xact_id			unsigned bigint
;
end if
go
if @is_IQ_database = 'Y' then
execute immediate
'CREATE TABLE SYS.SYSIQINFO (
	    last_full_backup	timestamp,
	    last_incr_backup	timestamp,
	    create_time		timestamp NOT NULL,
	    update_time		timestamp NOT NULL,
	    file_format_version	unsigned int NOT NULL,
	    cat_format_version	unsigned int NOT NULL,
	    sp_format_version	unsigned int NOT NULL,
	    block_size		unsigned int NOT NULL,
	    chunk_size		unsigned int NOT NULL,
	    file_format_date	char(10) NOT NULL,
	    dbsig		binary(136) NOT NULL,
	    PRIMARY KEY ( create_time )
	)'
;
GRANT SELECT on SYS.SYSIQINFO TO SYS
;
execute immediate
'CREATE TABLE SYS.SYSIQFILE (
	    file_id		smallint NOT NULL,
	    start_block		rowid NOT NULL,
	    block_count		rowid NOT NULL,
	    create_time		timestamp NOT NULL,
	    segment_type	char(8) NOT NULL,
	    allocated		char(1) NOT NULL,
	    server_name		char(30) NOT NULL,
	    file_name		char(128) NOT NULL,
	    data_offset		unsigned int NOT NULL,
	    PRIMARY KEY ( file_id, server_name ),
	    UNIQUE ( server_name, file_name )
	)'
;
GRANT SELECT on SYS.SYSIQFILE TO SYS
;
execute immediate
'CREATE TABLE SYS.SYSIQTABLE (
	    table_id		unsigned int NOT NULL,
	    block_map		hs_blockmapidentity NOT NULL,
	    block_map_size	unsigned int NOT NULL,
	    vdo			hs_vdoidentity NOT NULL,
	    vdoid_size		unsigned int NOT NULL,
	    info_location	hs_vdorecid NOT NULL,
	    info_recid_size	unsigned int NOT NULL,
	    info_location_size  unsigned int NOT NULL,
	    commit_txn_id	xact_id NOT NULL,
	    txn_id		xact_id NOT NULL,
	    join_id		unsigned int NOT NULL,
	    create_time		timestamp NOT NULL,
	    update_time		timestamp NOT NULL,
	    PRIMARY KEY ( table_id )
	)'
;
GRANT SELECT on SYS.SYSIQTABLE TO SYS
;
execute immediate
'CREATE TABLE SYS.SYSIQCOLUMN (
	    table_id		unsigned int NOT NULL,
	    column_id		unsigned int NOT NULL,
	    link_table_id	unsigned int,
	    link_column_id	unsigned int,
	    max_length		unsigned int NOT NULL,
	    approx_unique_count rowid,
	    cardinality		rowid NOT NULL,
	    has_data		char(1) NOT NULL,
	    has_original	char(1) NOT NULL,
	    original_not_null	char(1) NOT NULL,
	    original_unique	char(1) NOT NULL,
	    info_location	hs_vdorecid NOT NULL,
	    info_recid_size	unsigned int NOT NULL,
	    info_location_size  unsigned int NOT NULL,
	    PRIMARY KEY ( table_id, column_id )
	)'
;
GRANT SELECT on SYS.SYSIQCOLUMN to SYS
;
execute immediate
'CREATE TABLE SYS.SYSIQINDEX (
	    table_id		unsigned int NOT NULL,
	    index_id		unsigned int NOT NULL,
	    max_key		unsigned int NOT NULL,
	    identity_location	hs_vdorecid NOT NULL,
	    identity_size	unsigned int NOT NULL,
	    identity_location_size unsigned int NOT NULL,
	    info_location	hs_vdorecid NOT NULL,
	    info_recid_size	unsigned int NOT NULL,
	    info_location_size  unsigned int NOT NULL,
	    link_table_id	unsigned int,
	    link_index_id	unsigned int,
	    PRIMARY KEY ( table_id, index_id )
	)'
;
GRANT SELECT on SYS.SYSIQINDEX to SYS
;
execute immediate
'CREATE TABLE SYS.SYSIQJOININDEX (
	    joinindex_id	unsigned int NOT NULL,
	    jvt_id		unsigned int NOT NULL,
	    file_id		smallint NOT NULL,		
	    joinindex_name	char(128) NOT NULL,
	    joinindex_type	char(12) NOT NULL,
	    creator		unsigned int NOT NULL,
	    join_info_location	hs_vdorecid NOT NULL,
	    join_info_loc_size	unsigned int NOT NULL,
	    join_info_size	unsigned int NOT NULL,
	    block_map		hs_blockmapidentity NOT NULL,
	    block_map_size	unsigned int NOT NULL,
	    vdo			hs_vdoidentity NOT NULL,
	    vdo_size		unsigned int NOT NULL,
	    commit_txn_id	xact_id NOT NULL,
	    txn_id		xact_id NOT NULL,
	    valid		char(1) NOT NULL,
	    remarks		long varchar,
	    PRIMARY KEY ( joinindex_id ),
	    UNIQUE ( jvt_id, commit_txn_id, txn_id )
	)'
;
GRANT SELECT on SYS.SYSIQJOININDEX to SYS
;
execute immediate
'CREATE TABLE SYS.SYSIQJOINIXTABLE (
	    table_id		unsigned int NOT NULL,
	    joinindex_id	unsigned int NOT NULL,
	    active		unsigned int NOT NULL,
	    PRIMARY KEY ( table_id, joinindex_id )
	)'
;
GRANT SELECT on SYS.SYSIQJOINIXTABLE to SYS
;
execute immediate
'CREATE TABLE SYS.SYSIQJOINIXCOLUMN (
	    joinindex_id	unsigned int NOT NULL,
	    left_table_id	unsigned int NOT NULL,
	    left_column_id	unsigned int NOT NULL,
	    join_type		char(4) NOT NULL,
	    right_table_id	unsigned int NOT NULL,
	    right_column_id	unsigned int NOT NULL,
	    order_num		unsigned int NOT NULL,
	    left_order_num		unsigned int NOT NULL,
	    right_order_num		unsigned int NOT NULL,
	    key_type		char(8) NOT NULL,
	    coalesce		char(1) NOT NULL,
	    PRIMARY KEY ( joinindex_id, left_table_id, left_column_id,
	    				right_table_id, right_column_id )
	)'
;
GRANT SELECT on SYS.SYSIQJOINIXCOLUMN to SYS
;
end if
go
alter table SYSTABLE add foreign key for SYSFILE
go
alter table SYSTABLE add foreign key for SYSUSERPERM
	( creator is user_id )
go
alter table SYSCOLUMN add foreign key for SYSTABLE
go
alter table SYSCOLUMN add foreign key for SYSDOMAIN
go
alter table SYSINDEX add foreign key for SYSTABLE
go
alter table SYSINDEX add foreign key for SYSUSERPERM
	( creator is user_id )
go
alter table SYSIXCOL add foreign key for SYSINDEX
go
alter table SYSIXCOL add foreign key for SYSCOLUMN
go
alter table SYSFOREIGNKEY add foreign_table foreign key for SYSTABLE
	( foreign_table_id is table_id )
go
alter table SYSFOREIGNKEY add primary_table foreign key for SYSTABLE
	( primary_table_id is table_id )
go
alter table SYSFKCOL add foreign key for SYSFOREIGNKEY
go
alter table SYSFKCOL add foreign key for SYSCOLUMN
	( foreign_table_id is table_id, foreign_column_id is column_id )
go
alter table SYSTABLEPERM add foreign key for SYSTABLE
	( stable_id is table_id )
go
alter table SYSTABLEPERM add future foreign key for SYSTABLE
	( ttable_id is table_id )
go
alter table SYSTABLEPERM add grantor foreign key for SYSUSERPERM
	( grantor is user_id )
go
alter table SYSTABLEPERM add grantee foreign key for SYSUSERPERM
	( grantee is user_id )
go
alter table SYSCOLPERM add foreign key for SYSCOLUMN
go
alter table SYSCOLPERM add grantor foreign key for SYSUSERPERM
	( grantor is user_id )
go
alter table SYSCOLPERM add grantee foreign key for SYSUSERPERM
	( grantee is user_id )
go
alter table SYSOPTION add foreign key for SYSUSERPERM
go
alter table SYSGROUP add group_id foreign key for SYSUSERPERM
	( group_id is user_id )
go
alter table SYSGROUP add group_member foreign key for SYSUSERPERM
	( group_member is user_id )
go
    
alter table SYSLOGIN add foreign key for SYSUSERPERM
	( login_uid is user_id )
go
    
alter table SYSJAVACLASS add foreign key for SYSJARCOMPONENT
go
alter table SYSJARCOMPONENT add foreign key for SYSJAR
go
alter table SYSJAVACLASS add foreign key for SYSUSERPERM
	( creator is user_id )
go
alter table SYSJAVACLASS add foreign key for SYSUSERTYPE
go
if @is_IQ_database = 'Y' then
alter table SYSIQFILE add foreign key for SYSFILE
	( file_id is file_id )
;
alter table SYSIQTABLE add foreign key for SYSTABLE
	( table_id is table_id )
;
alter table SYSIQCOLUMN add foreign key 
	( table_id, column_id ) references SYSCOLUMN ( table_id, column_id )
;
alter table SYSIQINDEX add foreign key 
	( table_id, index_id ) references SYSINDEX ( table_id, index_id )
;
alter table SYSIQINDEX add foreign key 
	( link_table_id, link_index_id ) references SYSINDEX ( table_id, index_id )
;
alter table SYSIQJOININDEX add foreign key for SYSTABLE
	( jvt_id is table_id )
;
alter table SYSIQJOININDEX add foreign key for SYSFILE
	( file_id is file_id )
;
alter table SYSIQJOININDEX add foreign key for SYSUSERPERM
	( creator is user_id )
;
alter table SYSIQJOINIXTABLE add foreign key for SYSTABLE
	( table_id is table_id )
;
alter table SYSIQJOINIXTABLE add foreign key for SYSIQJOININDEX
	( joinindex_id is joinindex_id )
;
alter table SYSIQJOINIXCOLUMN add foreign key for SYSIQJOININDEX
	( joinindex_id is joinindex_id )
;
alter table SYSIQJOINIXCOLUMN add foreign key
	( left_table_id, left_column_id ) references SYSCOLUMN ( table_id, column_id )
;
alter table SYSIQJOINIXCOLUMN add foreign key
	( right_table_id, right_column_id ) references SYSCOLUMN ( table_id, column_id )
;
end if
go
ALTER table SYSPROCEDURE add foreign key for SYSUSERPERM
            ( creator is user_id )
go
ALTER table SYSPROCPARM add foreign key for SYSPROCEDURE
go
ALTER table SYSPROCPARM add foreign key for SYSDOMAIN
go
ALTER table SYSTRIGGER add foreign key for SYSTABLE
go
ALTER table SYSTRIGGER add foreign key for SYSFOREIGNKEY
go
ALTER table SYSPROCPERM add foreign key for SYSUSERPERM
	    ( grantee is user_id )
go
ALTER table SYSPROCPERM add foreign key for SYSPROCEDURE
go
ALTER table SYSPUBLICATION add foreign key for SYSUSERPERM
            ( creator is user_id )
 go 
	    
ALTER table SYSARTICLE add foreign key for SYSPUBLICATION
 go 
	
ALTER table SYSARTICLE add foreign key for SYSTABLE
 go 
	
ALTER table SYSARTICLECOL add foreign key for SYSARTICLE
 go 
	
ALTER table SYSARTICLECOL add foreign key for SYSCOLUMN
 go 
	
ALTER table SYSREMOTEUSER add foreign key for SYSUSERPERM
 go 
	
ALTER table SYSSUBSCRIPTION add foreign key for SYSPUBLICATION
 go 
	
ALTER table SYSSUBSCRIPTION add foreign key for SYSUSERPERM
 go 
	
ALTER table SYSREMOTEUSER add foreign key for SYSREMOTETYPE
 go 
ALTER table SYSUSERTYPE add foreign key for SYSUSERPERM
		(creator is user_id)
 go 
ALTER table SYSUSERTYPE add foreign key for SYSDOMAIN
 go 
ALTER table SYSCOLUMN add foreign key for SYSUSERTYPE
		(user_type is type_id)
 go 
ALTER table SYSEXTENT add foreign key for SYSFILE
 go 
ALTER table SYSREMOTEOPTIONTYPE add foreign key for SYSREMOTETYPE
 go 
ALTER table SYSREMOTEOPTION add foreign key for SYSREMOTEOPTIONTYPE
 go 
ALTER table SYSTYPEMAP add foreign key for SYSDOMAIN
		(sa_domain_id is domain_id)
 go 
ALTER table SYSSYNC add foreign key for SYSPUBLICATION
 go 
	
CREATE UNIQUE INDEX table_name ON SYSTABLE (table_name, creator )
go
	
CREATE UNIQUE INDEX index_name ON SYSINDEX (index_name, table_id )
go
	
CREATE UNIQUE INDEX user_name ON SYSUSERPERM (user_name )
go
	
CREATE UNIQUE INDEX role_name ON SYSFOREIGNKEY (role, foreign_table_id )
go
	
CREATE UNIQUE INDEX procedure_name ON SYSPROCEDURE
	( proc_name, creator )
go
CREATE UNIQUE INDEX trigger_index ON SYSTRIGGER
	( table_id, event, trigger_time, trigger_order )
go
CREATE UNIQUE INDEX trigger_name ON SYSTRIGGER
	( trigger_name )
go
CREATE UNIQUE INDEX trigger_referential_actions ON SYSTRIGGER
	( table_id, foreign_table_id, foreign_key_id, event )
go
CREATE UNIQUE INDEX publication_name ON SYSPUBLICATION
	( publication_name, creator )
 go 
	
CREATE UNIQUE INDEX remote_address ON SYSREMOTEUSER
	( type_id, address )
 go 
	
CREATE INDEX remote_frequency ON SYSREMOTEUSER
	( frequency, send_time )
 go 
	
CREATE UNIQUE INDEX remote_type ON SYSREMOTETYPE
	( type_name )
 go 
COMMIT WORK
 go 
go
	
CREATE UNIQUE INDEX jar_name ON SYSJAR ( jar_name )
go
	
GRANT CONNECT TO "DBA" IDENTIFIED BY "SQL"
go
import sysviews.sql
CREATE TABLE SYS.DUMMY ( dummy_col INT NOT NULL ) IN SYSTEM
go
INSERT INTO SYS.DUMMY VALUES ( 0 )
go
GRANT SELECT on SYS.DUMMY to SYS
go
    
CREATE TABLE SYSINFO (
	    page_size		int	    NOT NULL,
	    encryption		char(1)	    NOT NULL,
	    blank_padding	char(1)	    NOT NULL,
	    case_sensitivity	char(1)	    NOT NULL,
	    default_collation	char(10),
	    database_version	smallint    NOT NULL,
	    classes_version	char(10)
	) IN SYSTEM
go
INSERT INTO SYSINFO VALUES
	(@page_size,
	 @encryption,
	 @blank_padding,
	 @case_sensitivity,
	 @default_collation,
	 (select db_property( 'FileVersion' )),
	 '1.1.3' )
go
GRANT SELECT on SYS.SYSINFO to SYS
go
COMMIT WORK
go
   
import  dbovws60.sql 
message lang_message(  7974  ) type info to client
go
grant select on SYSTABLE to SYS
go
grant select on SYSCOLUMN to SYS
go
grant select on SYSINDEX to SYS
go
grant select on SYSIXCOL to SYS
go
grant select on SYSFOREIGNKEY to SYS
go
grant select on SYSFKCOL to SYS
go
grant select on SYSFILE to SYS
go
grant select on SYSDOMAIN to SYS
go
	
grant select on SYSTABLEPERM to SYS
go
grant select on SYSCOLPERM to SYS
go
grant select on SYSOPTION to SYS
go
grant select on SYSGROUP to SYS
go
grant select on SYSCOLLATION to SYS
go
grant select on SYSCOLLATIONMAPPINGS to SYS
go
CREATE DOMAIN money	    	numeric(19,4)
 go 
CREATE DOMAIN smallmoney	numeric(10,4)
 go 
CREATE DOMAIN datetime	    	timestamp
 go 
CREATE DOMAIN smalldatetime    	timestamp
 go 
CREATE DOMAIN text		long varchar
 go 
CREATE DOMAIN image	    	long binary
 go 
CREATE DOMAIN oldbit	    	tinyint
 go 
CREATE DOMAIN sysname	    	varchar(30) not null
 go 
go
import  sybprc60.sql  
import rstab.sql
message lang_message(  7975  ) type info to client
go
import saopts.sql
set option PUBLIC.Ansi_update_constraints = 'Cursors';
    INSERT INTO SYS.SYSREMOTETYPE ( type_id, type_name, publisher_address )
		VALUES ( 0, 'FILE', '' )
 go 
    INSERT INTO SYS.SYSREMOTETYPE ( type_id, type_name, publisher_address )
		VALUES ( 1, 'MAPI', '' )
 go 
    INSERT INTO SYS.SYSREMOTETYPE ( type_id, type_name, publisher_address )
		VALUES ( 2, 'VIM', '' )
 go 
    INSERT INTO SYS.SYSREMOTETYPE ( type_id, type_name, publisher_address )
		VALUES ( 3, 'SMTP', '' )
 go 
    INSERT INTO SYS.SYSREMOTETYPE ( type_id, type_name, publisher_address )
		VALUES ( 4, 'FTP', '' )
 go 
go
TRUNCATE TABLE SYS.SYSSQLSERVERTYPE
 go 
TRUNCATE TABLE SYS.SYSTYPEMAP
 go 
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  1 ,	47,	'char',		 8 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  2 ,	39,	'varchar',	 9 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  3 ,	45,	'binary',	 11 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  4 ,37,	'varbinary',	 28 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  5 ,	48,	'tinyint',	 19 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  6 ,	52,	'smallint',	 1 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  7 ,	56,	'int',		 2 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  8 ,	62,	'float',	 5 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  10 ,	63,	'numeric',	 3 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  11 ,	60,	'money',	 3 ,	    (select type_id from SYS.SYSUSERTYPE where type_name = 'money') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  12 ,	61,	'datetime',	 13 ,   (select type_id from SYS.SYSUSERTYPE where type_name = 'datetime') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  13 ,	38,	'intn',		 2 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  14 ,	109,	'floatn',	 5 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  15 ,	111,	'datetimn',	 13 ,   (select type_id from SYS.SYSUSERTYPE where type_name = 'datetime') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  16 ,	50,	'bit',		 24 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  17 ,	110,	'moneyn',	 3 ,	    (select type_id from SYS.SYSUSERTYPE where type_name = 'money') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  18 ,	39,	'sysname',	 9 ,	    (select type_id from SYS.SYSUSERTYPE where type_name = 'sysname') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  19 ,	35,	'text',		 10 , (select type_id from SYS.SYSUSERTYPE where type_name = 'text') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  20 ,	34,	'image',	 12 ,  (select type_id from SYS.SYSUSERTYPE where type_name = 'image') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  21 ,122,	'smallmoney',	 3 ,	    (select type_id from SYS.SYSUSERTYPE where type_name = 'smallmoney') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  22 ,58,	'smalldatetime', 13 ,   (select type_id from SYS.SYSUSERTYPE where type_name = 'smalldatetime') )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  23 ,	59,	'real',		 4 ,	    NULL )
 go 
 go 	
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  26 ,	55,	'decimal',	 27 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  27 ,	106,	'decimaln',	 27 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  28 ,	108,	'numericn',	 3 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  80 ,37,	'timestamp',	 13 ,   NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  29 ,	63,	'unsigned int',	 3 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  30 ,	63,	'unsigned intn',  3 ,    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  31 , 63,	'unsigned smallint',	 3 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  32 , 63,	'unsigned smallintn',  3 ,    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  33 , 63,	'bigint',	 3 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  34 , 63,	'bigintn',	 3 ,    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  35 , 63,	'unsigned bigint',	 3 ,	    NULL )
 go 	
INSERT INTO SYS.SYSSQLSERVERTYPE
	VALUES (  36 , 63,	'unsigned bigintn',	 3 ,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  6 ,	 1 ,	    NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  7 ,	 2 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  13 ,	 2 ,	    NULL,    'Y' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  10 ,	 3 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  28 ,	 3 ,	    NULL,    'Y' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  23 ,	 4 ,	    NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  8 ,	 5 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  14 ,	 5 ,	    NULL,    'Y' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  12 ,	 6 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  15 ,	 6 ,	    NULL,    'Y' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  1 ,	 7 ,	    NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  2 ,	 9 ,	    NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  1 ,	 8 ,	    NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  19 ,	 10 , NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  3 ,	 11 ,	    NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  4 ,  28 ,    NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  20 ,	 12 ,  NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  80 , 13 ,   NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  12 ,	 14 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  15 ,	 14 ,	    NULL,    'Y' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  5 ,	 19 ,	    NULL,    NULL )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  16 ,	 24 ,	    NULL,    NULL )
 go 
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  11 ,	 3 ,	    (select type_id from SYS.SYSUSERTYPE where type_name = 'money'),     'N' )
 go    
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  17 ,	 3 ,	    (select type_id from SYS.SYSUSERTYPE where type_name = 'money'),     'Y' )
 go    
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  21 , 3 ,    (select type_id from SYS.SYSUSERTYPE where type_name = 'smallmoney'),     NULL )
 go   
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  12 ,  13 ,   (select type_id from SYS.SYSUSERTYPE where type_name = 'datetime'),     'N' )
 go    
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  15 ,  13 ,   (select type_id from SYS.SYSUSERTYPE where type_name = 'datetime'),     'Y' )
 go    
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  22 , 13 ,  (select type_id from SYS.SYSUSERTYPE where type_name = 'smalldatetime'),  NULL )
 go   
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  19 ,	 10 , (select type_id from SYS.SYSUSERTYPE where type_name = 'text'),     NULL )
 go   
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  20 ,	 12 ,  (select type_id from SYS.SYSUSERTYPE where type_name = 'image'),     NULL )
 go   
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  18 ,	 9 ,	    (select type_id from SYS.SYSUSERTYPE where type_name = 'sysname'),     NULL )
 go   
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  26 ,	 27 ,	    NULL,     'N' )
 go    
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  27 ,	 27 ,	    NULL,     'Y' )
 go    
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  29 ,	 21 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  30 ,	 21 ,	    NULL,    'Y' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  31 ,  22 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  32 ,  22 ,	    NULL,    'Y' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  33 ,	 20 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  34 ,	 20 ,	    NULL,    'Y' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  35 ,	 23 ,	    NULL,    'N' )
 go 	
INSERT INTO SYS.SYSTYPEMAP
	VALUES (  36 ,	 23 ,	    NULL,    'Y' )
 go 	
COMMIT WORK
 go 
go
import instjava.sql
import instcis.sql
import ulsetup.sql
import syncasa.sql
create table dbo.EXCLUDEOBJECT (
	name char( 128 ),
	type char(1),
	PRIMARY KEY( name, type )
	);
grant select on dbo.EXCLUDEOBJECT to PUBLIC;
go
import migrat.sql
go
import mkexclud.sql
go