/* Microsoft SQL Server - Scripting                     */
/* Server: SESODI                       */
/* Database: setup                      */
/* Creation Date 08-02-96 13:56:18                      */
/****** Object:  Table dbo.ConsoleGroups    Script Date: 08-02-96 13:56:21 ******/
if exists (select * from sysobjects where id = object_id('dbo.ConsoleGroups') and sysstat & 0xf = 3)
        drop table dbo.ConsoleGroups
GO

CREATE TABLE ConsoleGroups
(
        ID int NULL ,
        Name varchar (255) NULL ,
        Description varchar (255) NULL ,
        UserName varchar (255) NULL ,
        Button int NULL ,
        Page1 varchar (255) NULL ,
        Page2 varchar (255) NULL ,
        Page3 varchar (255) NULL ,
        Page4 varchar (255) NULL ,
        Page5 varchar (255) NULL ,
        Page6 varchar (255) NULL ,
        Page7 varchar (255) NULL ,
        Page8 varchar (255) NULL ,
        Page9 varchar (255) NULL ,
        Page10 varchar (255) NULL ,
        Page11 varchar (255) NULL ,
        Page12 varchar (255) NULL ,
        Page13 varchar (255) NULL ,
        Page14 varchar (255) NULL ,
        Page15 varchar (255) NULL 
)
GO

/****** Object:  Table dbo.ConsolePages    Script Date: 08-02-96 13:56:23 ******/
if exists (select * from sysobjects where id = object_id('dbo.ConsolePages') and sysstat & 0xf = 3)
        drop table dbo.ConsolePages
GO

CREATE TABLE ConsolePages
(
        ID int NULL ,
        Name varchar (255) NULL ,
        Description varchar (255) NULL ,
        UserName varchar (255) NULL ,
        Button int NULL ,
        ConsBar1 varchar (255) NULL ,
        ConsBar2 varchar (255) NULL ,
        ConsBar3 varchar (255) NULL ,
        ConsBar4 varchar (255) NULL ,
        ConsBar5 varchar (255) NULL ,
        ConsBar6 varchar (255) NULL ,
        ConsBar7 varchar (255) NULL ,
        ConsBar8 varchar (255) NULL ,
        ConsBar9 varchar (255) NULL ,
        ConsBar10 varchar (255) NULL ,
        ConsBar11 varchar (255) NULL ,
        ConsBar12 varchar (255) NULL ,
        ConsBar13 varchar (255) NULL ,
        ConsBar14 varchar (255) NULL ,
        ConsBar15 varchar (255) NULL 
)
GO

/****** Object:  Table dbo.ConsoleViewBars    Script Date: 08-02-96 13:56:25 ******/
if exists (select * from sysobjects where id = object_id('dbo.ConsoleViewBars') and sysstat & 0xf = 3)
        drop table dbo.ConsoleViewBars
GO

CREATE TABLE ConsoleViewBars
(
        ID int NULL ,
        Name varchar (255) NULL ,
        Description varchar (255) NULL ,
        Class varchar (255) NULL ,
        Form varchar (255) NULL ,
        UserName varchar (255) NULL ,
        Param1 varchar (255) NULL ,
        Param2 varchar (255) NULL ,
        Param3 varchar (255) NULL ,
        Param4 varchar (255) NULL ,
        Param5 varchar (255) NULL ,
        Param6 varchar (255) NULL ,
        Param7 varchar (255) NULL ,
        Param8 varchar (255) NULL ,
        Param9 varchar (255) NULL ,
        Param10 varchar (255) NULL ,
        Param11 varchar (255) NULL ,
        Param12 varchar (255) NULL ,
        Param13 varchar (255) NULL ,
        Param14 varchar (255) NULL ,
        Param15 varchar (255) NULL 
)
GO

Last Modified 11 January 2019