Changes in database

---

LIDS 10.0.3

Build 10.0.3, 2026-02-16

Component	Version
Date:	2026-02-16
AS:	10.0.3
Database:	74

LIDS Document tables

• Added column DELETION_TYPE to LIDS_DOCUMENT_H table (NUMBER(1), default 0, NOT NULL).
• Created index idx_lidsdocumenth_deletiontype on LIDS_DOCUMENT_H (DELETION_TYPE).
• Recreated view LIDS_DOCUMENT_A with the new DELETION_TYPE column.

Data migration

• Documents belonging to deleted folders (where lids_doc_folder.valid = 0) are moved from LIDS_DOCUMENT to LIDS_DOCUMENT_H with deletion_type = 1 and then deleted from LIDS_DOCUMENT.

LIDS 9.21

Build 9.21.0, 2025-09-12

Component	Version
Date:	2025-09-12
AS:	9.21.0
Database:	73

Cross section tables

• Change data type column CABLE_POS to LIDS_CABLE_ROUTE_POSITIONS.
• Add column CABLE_POS_INDEX to LIDS_CS_CONTENT_LT.

LIDS 9.20

Build 9.20.0, 2025-07-09

Component	Version
Date:	2025-07-09
AS:	9.20.0
Database:	72

Cross section tables

• Added column CABLE_POS_INDEX to LIDS_CS_CONTENT.

LIDS 9.18

Build 9.18.0, 2025-05-07

Component	Version
Date:	2025-05-07
AS:	9.18.0
Database:	71

Auth server

• Added table auth_code.

LIDS 8.25

Build 8.25.55, 2025-04-15

Component	Version
Date:	2025-04-15
AS:	8.25.55
Database:	70

BackdropService function

• Added function GET_SDO_GEOM_FROM_TILE for DBMS postgresql.

Integrations

• Removed existing primary key from lids_integrations_info table.
• Added lt_id column to lids_integrations_info table.
• Created new composite primary key in lids_integrations_info table.

---

Build 8.25.44, 2025-01-16

Component	Version
Date:	2025-01-16
AS:	8.25.44
Database:	69

Integrations

• Changed datatype of last_error column in lids_integrations_info table.

Datachecks

• Added err_type column to lids_check_error table.

---

Build 8.25.23, 2024-06-03

Component	Version
Date:	2024-06-03
AS:	8.25.23
Database:	68

BackdropService function

• Added function GET_SDO_GEOM_FROM_TILE.

---

Build 8.25.10, 2023-12-06

Component	Version
Date:	2023-12-06
AS:	8.25.11
Database:	67

Cross section long transaction history tables and views

• Added table LIDS_CS_HEADER_LTH and view LIDS_CS_HEADER_LTA.
• Added table LIDS_CS_CONTENT_LTH and view LIDS_CS_CONTENT_LTA.
• Fixes views LIDS_CS_HEADER_LTL and LIDS_CS_CONTENT_LTL if defined incorrectly in version 66.

---

Build 8.25.7, 2023-10-17

Component	Version
Date:	2023-10-17
AS:	8.25.X
Database:	66

Cross section long transaction tables

• Added tables LIDS_CS_HEADER_LT and LIDS_CS_CONTENT_LT.
• Added views LIDS_CS_HEADER_LTL and LIDS_CS_CONTENT_LTL.

---

Build 8.25.3, 2023-07-14

Component	Version
Date:	2023-07-14
AS:	8.25.3
Database:	65

Data check tables

• Renamed tables and sequences SAMO_CHECK_* to LIDS_CHECK_* including primary and foreign keys.

LIDS_CHECK_TASK table

• Added columns fixed_count, fix_start_date and fix_finish_date.
• Modified existing start_date and finish_date columns from DATE data type to DATETIME(0) for DBMS postgresql and mssql.

---

LIDS 8.21

Component	Version
Date:	2023-03-01
AS:	8.21.3
Database:	64

Data check tables

• Added column fix_info to existing SAMO_CHECK_ERROR table.

---

LIDS 8.17

Component	Version
Date:	-- Not released yet--
AS:	8.17.X
Database:	63

LIDS Document tables

• Added index on LIDS_DOCUMENT (USER_FILE_NAME).
• Added index on LIDS_DOCUMENT_H (USER_FILE_NAME).

Data check tables

• Added column check_report to existing SAMO_CHECK_TASK table.
• Create SAMO_CHECK_TASK table.
• Create SAMO_CHECK_ERROR table.
• Create SAMO_CHECK_FEATURE table.
• Create SAMO_CHECK_TASK_SEQ sequence.
• Create SAMO_CHECK_ERROR_SEQ sequence.

---

LIDS 8.15

Component	Version
Date:	-- Not released yet--
AS:	8.15.X
Database:	62

Integration journal table

• Added numeric column lt_id
• Create system table lids_integrations_journal

Integration info table

• Create sytem table lids_integrations_info

---

LIDS 8.8

Component	Version
Date:	-- Not released yet--
AS:	8.8.X
Database:	61

Fixing missing FK indexes for SAMO Business server tables

• Table samo_bs_task

• index samo_bs_task_parent_idx on column parent_id

• Table samo_bs_event_attribute

• index samo_bs_event_att_event_idx on column event

• Table samo_bs_event_lab_event_idx

• index samo_bs_event_labels on column event_id

• Table samo_bs_process_execution

• index samo_bs_process_ex_parent on column parent

• index samo_bs_process_ex_process on column process

• Table samo_bs_process_execution_hist

• index samo_bs_process_ex_h_process on column process

• Table samo_bs_process_variable

• index samo_bs_process_var_process on column process_id

• Table samo_bs_process_incident

• index samo_bs_process_incident_exec on column execution

• Table samo_bs_proc_ref_assoc

• index samo_bs_proc_ref_assoc_proc on column process_id

• index samo_bs_proc_ref_assoc_ref on column reference_id

• Table samo_bs_proc_task_assoc

• index samo_bs_proc_task_assoc_proc on column process_id

• index samo_bs_proc_task_assoc_exec on column execution_id

• index samo_bs_proc_task_assoc_task on column task_id

• Table samo_bs_task_candidate_groups

• index samo_bs_task_cg_task_id on column task_id

• Table samo_bs_task_ref_assoc

• index samo_bs_task_ref_assoc_ref on column reference_id

• index samo_bs_task_ref_assoc_task on column task_id

• Table samo_bs_alloc

• index samo_bs_alloc_task on column task_id

• index samo_bs_alloc_plan on column plan_id

---

LIDS 8.4

Component	Version
Date:	2021-06-02
AS:	8.4-xxxxx
Database:	60

• LIDS Documents structures updated

Added new column TAGS (varchar(500)) into LIDS_DOCUMENT, LIDS_DOCUMENT_H AND LIDS_DOCUMENT_A, added new index for TAGS column.
Altered index on LIDS_DOC_FOLDER (SID) from unique to non-unique (drop and create).
Dropped unique index LIDS_DOC_FOLDER (FTID,SID).
Filled LIDS_DOC_FOLDER (FTID,SID) for NATIVE folders.
Added index on LIDS_DOCUMENT (NAME).
Modified column CREATE_DATE of table LIDS_DOC_VERSION from datetime(0) to timestamp.
Recreated foreign key on LIDS_DOC_VERSION (DOCUMENT_ID) fk_lidsdocversion_document with ON DELETE CASCADE.

• Security system tables

Extended column PARAMETER of SEC_CONFIG table to varchar(60).

---

LIDS 7.7.3

Component	Version
Date:	2020-09-xx
AS:	7.7.3-xxxxx
Database:	59

• LIDS Document shortcuts support

Added columns SHORTCUT_TARGET_ID and SHORTCUT_TARGET_TYPE to LIDS_DOCUMENT(_x) tables.
Removed NOT NULL constraint from ATTID column.

---

LIDS 7.7.1

Component	Version
Date:	2020-06-xx
AS:	7.7.1-xxxxx
Database:	58

• Long transaction support

Added new system table LIDS_LONG_TRANS_CONFLICT if it was not added during version 55.

• Security system tables

Added new security system table SEC_TASK_STATE.

• Samo bs event attribute value increased

Column VALUE of table SAMO_BS_EVENT_ATTRIBUTE is now varchar(4000).

---

LIDS 7.7.0

Component	Version
Date:	2020-03-xx
AS:	7.6.10-xxxxx
Database:	57

• LIDS Documents support

The LIDS_ATTACHMENT table has been split into tables LIDS_DOC_FOLDER and LIDS_DOCUMENT. Added table LIDS_DOCUMENT_H and DB view LIDS_DOCUMENT_A to support document history. Added the LIDS_DOC_VERSION table to create user versions of a document.

---

LIDS 7.6.8

Component	Version
Date:	2020-01-xx
AS:	7.6.8-xxxxx
Database:	56

• Long transaction support

Extended column SESSION_ID of table LIDS_LOCK from 30 to 35 chars

• Collaboration service - added support for attachments

Added SAMO_COLLAB_COMMENT_ATTACH table

---

LIDS 7.6.7

Component	Version
Date:	2019-12-xx
AS:	7.6.7-xxxxx
Database:	55

• Long transaction support.

Added new system tables LIDS_LONG_TRANS and LIDS_LONG_TRANS_CONFLICT.

---

LIDS 7.6.3

Component	Version
Date:	2019-09-xx
AS:	7.6.3-xxxxx
Database:	54

• Security patch

LIDS 7.6.3 distribution directory contains scripts for upgrading security tables.

• Business service

Added new columns to SAMO_BS_ALLOC table.

---

LIDS 7.6.0

Component	Version
Date:	2019-06-xx
AS:	7.6.0-xxxxx
Database:	53

• Initial scripts for liquibase

Added new initial scripts for liquibase database change management.

---

LIDS 7.5.6

Component	Version
Date:	2019-02-xx
AS:	7.5.6-xxxxx
Database:	52

LIDS 7.5.6 distribution directory contains scripts and read-me for upgrading the database.

Changes (from 51 to 52):

• Attachment table

Column NAME in LIDS_ATTACHMENT table were prolonged from 100 to 255 chars.

---

LIDS 7.5.1

Component	Version
Date:	2018-09-06
AS:	7.5.1-xxxxx
Database:	51

LIDS 7.5.1 distribution directory contains scripts and read-me for upgrading the database.

Changes (from 50 to 51):

• Backdrop table

ID and SUP_ID columns in LIDS_BACKDROP table were prolonged from 40 to 80 bytes.

---

LIDS 7.5.0

Component	Version
Date:	2018-06-25
AS:	7.5.0-xxxxx
Database:	50

LIDS 7.5.0 distribution directory contains scripts and read-me for upgrading the database.

Changes (from 49 to 50):

• License server

Dropped LCS_LOCK_INTERVAL table. It's not used anymore.
Changed LCS_LOCK_LOG.USER_ID column from LONG to NUMERIC.
Created LCS_LOCK_ARCHIVE table for archived records. Only locked licenses will be stored in LCS_LOCK_LOG from now on.

• Attachment table

CONTENT_TYPE and PREVIEW_CONTENT_TYPE columns in LIDS_ATTACHMENT table were prolonged to 100 bytes.

---

LIDS 7.4.1

Component	Version
Date:	2017-12-06
AS:	7.4.1-132028
Database:	49

LIDS 7.4.1 distribution directory contains scripts and read me file for upgrading database part.

Changes (from 47 to 48):

• New security table SEC_REPORT

Added SEC_REPORT table.
Changes (from 48 to 49):

• Extended column INSTANCE_ID in LCS_LOCK_LOG table

The column INSTANCE_ID in table LCS_LOCK_LOG has been extended from 50 Bytes to 100 Bytes.

• Altered columns START_TIME and END_TIME in LIDS_AUDIT table

Columns START_TIME and END_TIME in table LIDS_AUDIT have been changed from datatype DATE to TIMESTAMP.

---

LIDS 7.4.0

Component	Version
Date:	2016-07-29
AS:	7.4.0-131017
Database:	47

LIDS 7.4.0 distribution directory contains scripts and read me file for upgrading database part.

Changes (from 46 to 47):

• Extended LIDS_ATTACHMENT table

Added columns RELATED_FID, X_SCALE, Y_SCALE, X_SKEW, Y_SKEW, X_COORD and Y_COORD to LIDS_ATTACHMENT table.

• Extended LIDS_BACKDROP table

Added columns FID, VALID_FROM and VALID_TO to LIDS_BACKDROP table.

• New system table LIDS_AUDIT

Added LIDS_AUDIT table.

• New system table LIDS_TMP_IDS

Added LIDS_TMP_IDS table.

---

LIDS 7.3.5

Component	Version
Date:	2014-11-03
AS:	7.3.5-12711
Database:	46

LIDS 7.3.5 distribution directory contains scripts and read me file for upgrading database part.

Changes (from 45 to 46):

• Extended LIDS_IMPORT_LOG table

Added column TRANSACTION_ID to LIDS_IMPORT_LOG table.

---

LIDS 7.3.4

Component	Version
Date:	2014-05-05
AS:	7.3.4-12610
Database:	45

LIDS 7.3.4 has just slight db changes that can be completed by the Synchronize Database function.

• Added NOT NULL constraints to relation tables.
• Added the unique index on codelist binding tables.

---

LIDS 7.3.3

Component	Version
Date:	2013-11-28
AS:	7.3.3-12513 (SP1)
Database:	45

LIDS 7.3.3 distribution directory contains scripts and read me file for upgrading database part.

Changes (from 42 to 43):

• New table LIDS_IMPORT_LOG

Added new table LIDS_IMPORT_LOG and sequence LIDS_IMPORT_LOG_S.
Changes (from 43 to 44):

• Dropped columns START_GRAPH_ID and END_GRAPH_ID from the LIDS_TOPO_CONNECTION table.

The graph references were not used because their values can be derived from topology connections metadata.
Changes (from 44 to 45):

• New table SEC_GROUP_TYPE, modified table SEC_GROUP

User group types supported by security. New table SEC_GROUP_TYPE added, new column TYPE added to SEC_GROUP table.

---

LIDS 7.3.2

Component	Version
Date:	2013-07-14
AS:	7.3.2-12412 (SP1.BETA2)
Database:	42

LIDS 7.3.2 distribution directory contains scripts and read me file for upgrading database part.

Changes (from 40 to 41):

• New table LIDS_FEATURE_SETTINGS

Added new table LIDS_FEATURE_SETTINGS.
Changes (from 41 to 42):

• New column SETDEFINITION_SETTING_ID in table LIDS_TRANSACTION

---

LIDS 7.3.1

Component	Version
Date:	2012-10-18
AS:	7.3.1.12306 (RC1)
Database:	40

LIDS 7.3.1 distribution directory contains scripts and read me file for upgrading database part.

Changes (from 39 to 40):

• Extended LIDS_PACKAGE table and new table LIDS_PACKAGE_IMP

Added new columns EXP_REQUEST and IMP_ID to LIDS_PACKAGE table. Added new table LIDS_PACKAGE_IMP that stores identifiers all imported features.

• Added another indexes on LIDS_FEATURE_HIST table

Another indexes were added on CHANGE_FLAG and CHANGE_DATE columns.

• Modified data of LIDS_ATTACHMENT table

USER_LINK attribute was set to null for physically stored (non-link) attachments.

---

LIDS 7.3.0

Component	Version
Date:	2012-06-06
AS:	7.3.0.12214 (SP2)
Database:	39

LIDS 7.3.0 distribution directory contains scripts and read me file for upgrading database part.

Changes (from 38 to 39):

• New indexes on LIDS_FEATURE_HIST table

Added three indexes on FID, SID and FTID columns.

---

LIDS 7.2.2

Component	Version
Date:	2011-09-01
AS:	7.2.2.12016 (SP4)
Database:	38

LIDS 7.2.2 distribution directory contains scripts and read me file for upgrading database part.

Changes (from 36 to 37):

• New table LIDS_SETTINGS_SEC

There is a new table called LIDS_SETTINGS_SEC that is used for managing user rights on settings.

• LIDS_SETTINGS table values have been updated

Settings having setting_level = 'project' and user_access = 'public' are updated. The user_access of folder's settings was set to 'writable', other were set to 'shared'. Existing user rights (settings with setting_level = 'proj_group' or 'user_group') were inserted to the new table LIDS_SETTINGS_SEC.

• Dropped column SETTING_LEVEL from tables LIDS_SETTINGS and LIDS_SETTINGS_HIST

The column SETTING_LEVEL is not used anymore.

• LIDS_GEOMEXT data type changed

The item TEXT of LIDS_GEOMEXT data type has been extended from 255 to 1000 characters. This change is optional, upgrade to version 37 doesn't perform it.

Changes (from 37 to 38):

• Upgraded attachment identifiers in LIDS_ATTACHMENT table

Attachment identifiers have been upgraded to global unique identifiers.

• Extended column EXTENSION_INFO in LIDS_BACKDROP table

The column EXTENSION_INFO in table LIDS_BACKDROP has been extended from 512 Bytes to 2000 Chars.

---

LIDS 7.2.1

Component	Version
Date:	2011-03-11
AS:	7.2.1.11913
Database:	36

LIDS 7.2.1 distribution directory contains scripts and read me file for upgrading database part.

The upgrade consists of two parts:

• Upgrading from version 34 to 35
• Upgrading from version 35 to 36

Changes (from 34 to 35):

• New sequences

Generated attributes implemented as DB sequences.

• New column in LIDS_BACKDROP table

New column EXTENSION_INFO added to LIDS_BACKDROP table. It enables to save extra information to backdrop files (for integration with Bentley ProjectWise).

• LIDS_SYMBOLOGY_TOKEN_ARRAY data type changed

LIDS_SYMBOLOGY_TOKEN_ARRAY data type changed. Maximal length for token is extended to 4000 bytes. This change is optional, upgrade to version 35 doesn't perform it.

• LIDS_SETTINGS table values updated

In LIDS_SETTINGS table, the values of TYPE column 'visualisationmodel' updated to 'visualizationmodel'. It's done to unify terminology.

Changes (from 35 to 36):

• Extended column SHORT_VALUE in LIDS_SETTINGS and LIDS_SETTINGS_HIST tables

The column SHORT_VALUE in tables LIDS_SETTINGS and LIDS_SETTINGS_HIST has been extended from 50 to 255 Bytes

---

LIDS 7.2.0

Component	Version
Date:	2010-05-11
AS:	7.2.0.11812 (SP1)
Database:	34

LIDS 7.2.0 distribution directory contains script and read me file for upgrading database part.

Changes (from 33 to 34):

• New tables

New tables exist: LIDS_FEATURE_HIST (to record deleted features), SEC_CHANGE_LOG (for passwords synchronization with TOMS). New column FILE_HIST_ID has been added to LIDS_SETTINGS_HIST table - it contains a setting file name.

• To deploy server use a new version of ECA

It is not possible to deploy LIDS AS with the previous versions of ECA. If old version of ECA is used LIDS AS is not started and following error java.lang.NoSuchMethodError is reported in J2EE server log file: com.berit.lids.security.ISecurityManager.getUserGroups()Ljava/util/Collection;

---

LIDS 7.1.6

Component	Version
Date:	2010-06-01
AS:	7.1.6.11733 (SP8)
Database:	33

LIDS 7.1.6 distribution directory contains script and read me file for upgrading database part.

You should backup your data before upgrading.

Changes (from 32 to 33):

• Change of the LIDS_GTAG_COMPONENT object type

The script adds new column symbology_tokens to an object type LIDS_GTAG_COMPONENT. This object type must be dropped and created with new column. All tables that contain column "COMPLEX_INFO" with data type "LIDS_GTAG_COMPONENT_ARRAY" will be converted to this new type.

---

LIDS 7.1.5

Component	Version
Date:	2009-10-07
AS:	7.1.5.11627 (SP8)
Database:	32

LIDS 7.1.5 distribution directory contains script and read me file for upgrading database part.

The upgrade consists of three parts:

• Upgrading from version 27 to 30 - standard upgrade script
• Upgrading from version 30 to 31 - security upgrade from ADM_SEC to LIDS security tables
• Upgrading from version 31 to 32 - standard upgrade script for new security tables

Upgrading must be done in these three steps.

Changes (from 27 to 30):

• New Column in LIDS_SETTINGS table

There is a new column called VERSION in LIDS_SETTINGS table. The new column contains version of a setting.

• New Table LIDS_SETTINGS_HIST

There is a new table called LIDS_SETTINGS_HIST that stores previous version of settings. It means settings before upgrade to newer version.

• Sequences Were Dropped

Unused sequences lids_semantic_s,lids_geometry_s, lids_dispattr_s were dropped.

Changes (from 30 to 31):

• New Set of Security Tables

There are new security tables SEC_APPLICATION, SEC_ATTACHMENT, SEC_CATEGORY, SEC_CATEGORY_FEATURE, SEC_CODELIST, SEC_CODELIST_METHOD, SEC_CODELIST_PERMISSION, SEC_FEATURE_ATTRIBUTE, SEC_FEATURE_TYPE, SEC_GROUP, SEC_METHOD, SEC_METHOD_OWNER, SEC_PERMISSION, SEC_SEQUENCE, SEC_USER, SEC_USER_GROUP. These tables are used for managing user rights. Data is converted from ADM_SEC. The old ADM_SEC is no longer used.

Changes (from 31 to 32):

• Change Data Type of CODELIST_ID Column

Data type of CODELIST_ID in security tables SEC_CODELIST_METHOD, SEC_CODELIST from number to VARCHAR2(100).

---

LIDS 7.1.4

Component	Version
Date:	2008-09-29
Metadata:	47
AS:	7.1.4.11514 (Final)
Client:	7.1.4 (Final)
Database:	27

LIDS 7.1.4 distribution directory contains script and read me file for upgrading database part.

LIDS 7.1.4 brings new functionality supporting Cross-Sections and Export / Import of data between two LIDS projects or between LIDS project and external system.

Changes:

• New Database Tables for Cross-Sections

There are two new tables LIDS_CS_HEADER and LIDS_CS_CONTENT that represents assigned crosssections.

• New Database Table for Export/Import Functionality

There is new LIDS system table called LIDS_PACKAGE. This table contains all information about all data export processed and all data import processed in the system.

• New Column for LIDS_SETTINGS Table

Settings are used for storing user preferences, selection sets, predefined views. LIDS 7.1.4 allows to add a file to any user setting. This is quite useful when user wants to store plot stamps and plot legend rasters. There is a new column called STORAGE that says if the setting value is stored in CLOB data in the table or in a LIDS AS file system.

---

LIDS 7.1.3

Component	Version
Date:	2008-05-22
Metadata:	39
AS:	7.1.3.11405 (Final)
Client:	7.1.3.3064 (Final)
Database:	24

No changes in LIDS database.

---

LIDS 7.1.2

Component	Version
Date:	2008-02-08
Metadata:	34
AS:	7.1.2.11311 (SP3)
Client:	7.1.2.2962 (SP3)
Database:	24

Release of LIDS 7.1.2 SP3 can be found in the distribution directory. Distribution directory contains also script and readme file for upgrading database part.

Changes:

• New table for Graphic Tags

There is new set of tables for graphic tags. These tables now contain all graphic tags for features. Example of a graphic tag can be a displayable attribute or a cross section. The table names are XXX_GT.

• Dropped NOT NULL constraint for LIDS_DETAIL_HEADER.DESCRIPTION

A NOT NULL constraint is dropped for DESCRIPTION column in LIDS_DETAIL_HEADER table.

---

LIDS 7.1.1

Component	Version
Date:	2007-11-26
Metadata:	28
AS:	7.1.1.11214 (SP4)
Client:	7.1.1.2886 (SP5)
Database:	20

Release of LIDS 7.1.1 SP4 can be found in the distribution directory. Distribution directory contains also script and readme file for upgrading database part.

Changes:

• Columns NAME and DESCRIPTION

Columns with NAME and DESCRIPTION was consolidated for all system tables to:

NAME VARCHAR2(100 CHAR); DESCRIPTION VARCHAR2(500 CHAR);

• New columns in table LIDS_DETAIL_HEADER

Table LIDS_DETAIL_HEADER contains two new columns UPDATED_BY and UPDATE_DATE.

• New table LIDS_TOPO_CONNECTION

New table LIDS_TOPO_CONNECTION for topology connections was added.

• Renaming column INVALID to VALID for all topology tables

A column called INVALID was renamed to VALID for all topology tables (xxx_NODE, xxx_EDGE, xxx_FACE).

• New structure of graphic table

Graphic table (xxx_GR) now has new structure.

---

LIDS 7.1.0

Component	Version
Date:	2007-08-15
Metadata:	24
AS:	7.1.0.11104 (SP1)
Client:	7.1.0.2784 (SP1)
Database:	18

Release of LIDS 7.1.0 SP1 can be found here .

Changes:
No changes in database structure.

---

LIDS 7.0.6

Component	Version
Date:	2007-05-28
Metadata:	24
AS:	7.0.6.11008 (FCS)
Client:	7.00.06.2704 (FCS)
Database:	18

TODO: Internal release of LIDS 7.0.5 FCS can be found here .

TODO: Public release of LIDS 7.0.5 FCS can be found here .

Changes:

New Columns in LIDS_TRANSACTION table

There are two new columns in LIDS_TRANSACTION table. Column LAST_MERGED_BY says who made last merge of a long transaction. Column LAST_MERGE_DATE stores the time of a last merge.

Script

LIDS_DB_INFO view is updated

The LIDS_DB_INFO is updated. The database version was increased to 18.

Script

---

LIDS 7.0.5

Component	Version
Date:	2007-02-16
Metadata:	21
AS:	7.0.5.10906 (FCS)
Client:	7.00.05.2603 (FCS)
Database:	17

Internal release of LIDS 7.0.5 FCS can be found here .

Public release of LIDS 7.0.5 FCS can be found here .

Changes:

New table for attachment

There is a new table in the database called LIDS_ATTACHMENT. Table is used for managing LIDS 7 attachments. There is an SQL Script for creating the table available.

Script

LIDS_DB_INFO view is updated

The LIDS_DB_INFO was updated. The database version was increased to 17 and min application server version is increased to 10903.

Script

Script for replacing non-breaking-space

In the previous version of LIDS 7 there was a bug that spaces in string attributes were replaced with non breaking spaces. This can cause problems when searching data. Here is a script for finding and replacing the non-breaking spaces for normal spaces.

Script

---

LIDS 7.0.4

Component	Version
Date:	2006-12-12
Metadata:	17
AS:	7.0.4.10804
Client:	2435
Database:	15

Official release of LIDS 7 AS can be found here.

Official release of LIDS 7.0.4 Project Database Guide can be found here.

Changes:

Added a column in all graphich tables

In all graphich tables there is a new column BINARY_GEOM of type BLOB that holds data for dimensions. You can use database scripts that will upgrade the database. Be carefull to use right script. There is a script for versioned tables and for not versioned tables also.

• Script for versioned tables. It must be run in LIDS data user. Without any parameters.

• Script for not versioned tables. It must be run in LIDS data user. Without any parameters.

Script for fixing line arc string

There was a bug in the older version of migration and some line-arc strings were migrated in a wrong format. There is a script that tries to find these lin-arc string and fix them.

• Script for fixing line-arc string. It must be run in LIDS data user. Without any parameters.

PL/SQL script for creating a tablespace for LIDS data user

There is script for creating the tablespace for LIDS data user. It must be run in SYS user with following parameters:

1. Tablespace name
2. Path to datafile (e.g. /oracle/data/tblspace.dbf)
3. Tablespace Size (e.g. 2000)
4. Tablespace extend size (e.g. 250)
5. LOG directory for script(e.g. .\logs)

PL/SQL script for creating a LIDS 7 data user

There is script for creating the LIDS 7 data user. It must be run in SYS user with following parameters:

1. LIDS data user name
2. Password for LIDS data user
3. Tablespace that should be used
4. The directory where to generate log file

It creates new view called DBID in the SYS user that holds the unique database id. This view is granted to the LIDS 7 data user.

CREATE OR REPLACE VIEW DBID AS SELECT DBID FROM V_$DATABASE;

GRANT SELECT ON DBID to &in_USER.;

PL/SQL script for creating a mandatory LIDS_DB_INFO view

There is script that creates mandatory view called LIDS_DB_INFO in the LIDS 7 data user. It mustbe run in the LIDS 7 data user with following parameters:

1. The directory where to generate log file

It creates new view called LIDS_DB_INFO in the LIDS 7 data user that holds information about the LIDS 7 database version. If this view is missing LIDS 7.0.4 AS runs in the backward compatibility mode where there is no BINARY_GEOM database column, though there is no possibility to use dimensions in LIDS 7.0.4.

CREATE OR REPLACE VIEW LIDS_DB_INFO AS SELECT 16 AS DB_VERSION, 10802 AS MIN_AS_BUILD, DBID AS DB_ID FROM SYS.DBID;

---

LIDS 7.0.3

Component	Version
Date:	2006-10-11
Metadata:	14
AS:	7.0.3.10605
Client:	2435
Database:	15

Here is the document that contains the description of LIDS 7.0.3 database model LIDS 7.0.3 Database Model.

The database model 7.0.3 is the same as the dabase model 7.0.2.