SQL Script, console database
/* 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