Strukturänderungen an der Datenbank |
Top Previous Next |
|
Moskito GIS fügt in die SQLBase-Datenbank von Pro Baum neue Tabellen und Tabellenspalten ein.
neue Spalten in der Tabelle Kollekti: X1, Y1, X2, Y2, OBJECT, ORT
neue Spalte in der Tabelle Baum: BLS
Neue Tabellen: MOSKITO_PROJECT_LAYER MOSKITO_LAYER MOSKITO_MAPS MOSKITO_BLOBS MOSKITO_OBJ_TYPES MOSKITO_LINE_TABLES MOSKITO_SYMBOL_TABLES MOSKITO_COMPLEX_TABLES GIS_OBJECTS NETZE MESSPUNKTE
SQL: ALTER TABLE Kollekti ADD X1 VARCHAR(20) ALTER TABLE Kollekti ADD Y1 VARCHAR(20) ALTER TABLE Kollekti ADD X2 VARCHAR(20) ALTER TABLE Kollekti ADD Y2 VARCHAR(20) ALTER TABLE Kollekti ADD OBJECT LONG VARCHAR ALTER TABLE Kollekti ADD ORT VARCHAR(20)
ALTER TABLE Baum ADD BLS VARCHAR(20)
CREATE TABLE MOSKITO_PROJECT_LAYER (PROJECT VARCHAR(20), LAYER VARCHAR(6)) CREATE UNIQUE INDEX MOSKITO_PROJECT_LAYER_IDX ON MOSKITO_PROJECT_LAYER (PROJECT,LAYER) INSERT INTO MOSKITO_PROJECT_LAYER (PROJECT,LAYER) Values ('Kollektiv','181') INSERT INTO MOSKITO_PROJECT_LAYER (PROJECT,LAYER) Values ('Einzelbaum','180')
CREATE TABLE MOSKITO_LAYER (AM_DATENBANK VARCHAR(20), STORE_BINARY DECIMAL(1)) CREATE UNIQUE INDEX MOSKITO_LAYER_IDX ON MOSKITO_LAYER (AM_DATENBANK) INSERT INTO MOSKITO_LAYER (AM_DATENBANK,STORE_BINARY) Values ('180',0.0) INSERT INTO MOSKITO_LAYER (AM_DATENBANK,STORE_BINARY) Values ('181',0.0)
CREATE TABLE MOSKITO_MAPS (NAME VARCHAR(40), LAYER VARCHAR(20), MAP_LEFT DECIMAL(15,7), MAP_BOTTOM DECIMAL(15,7), MAP_TOP DECIMAL(15,7), MAP_RIGHT DECIMAL(15,7), VERSION DECIMAL(12,8), SCALE DECIMAL(12,8), RESOLUTION DECIMAL(12,8), DATA_LEFT DECIMAL(15,7), DATA_BOTTOM DECIMAL(15,7), DATA_TOP DECIMAL(15,7), DATA_RIGHT DECIMAL(15,7)) CREATE UNIQUE INDEX MOSKITO_MAPS_IDX ON MOSKITO_MAPS (Name,Layer)
CREATE TABLE MOSKITO_BLOBS (NAME VARCHAR(40), LAYER VARCHAR(20), DATA LONG VARCHAR) CREATE UNIQUE INDEX MOSKITO_BLOBS_IDX ON MOSKITO_BLOBS (name,layer)
CREATE TABLE MOSKITO_OBJ_TYPES (OBJCLASS VARCHAR(40), TABLENAME VARCHAR(40), OBJTYPE VARCHAR(10), AM_DATENBANK VARCHAR(4), SELECTION_COL VARCHAR(50), SELECTION_VAL VARCHAR(50), KEY1 VARCHAR(10), KEY2 VARCHAR(50), BOX_X1 VARCHAR(20), BOX_Y1 VARCHAR(20), BOX_X2 VARCHAR(20), BOX_Y2 VARCHAR(20), AMID VARCHAR(20), FMID VARCHAR(20), ALL_ATRS DECIMAL(1)) CREATE UNIQUE INDEX MOSKITO_OBJ_TYPES_Idx ON MOSKITO_OBJ_TYPES (ObjClass, TableName ,SELECTION_COL, SELECTION_VAL) INSERT INTO MOSKITO_OBJ_TYPES (OBJCLASS,TABLENAME,OBJTYPE,AM_DATENBANK,SELECTION_COL,SELECTION_VAL,KEY1,KEY2,BOX_X1,BOX_Y1,BOX_X2,BOX_Y2,AMID,FMID) Values ('Kollektiv','KOLLEKTI','COMPLEX','181',NULL,NULL,NULL,NULL,'X1','Y1','X2','Y2','$id','ID') INSERT INTO MOSKITO_OBJ_TYPES (OBJCLASS,TABLENAME,OBJTYPE,AM_DATENBANK,SELECTION_COL,SELECTION_VAL,KEY1,KEY2,BOX_X1,BOX_Y1,BOX_X2,BOX_Y2,AMID,FMID) Values ('Einzelbaum','BAUM','SYMBOL','180','ObjArt || ''_'' || AStatus || ''_'' || MapStatus','baum_0_0','13161','0',NULL,NULL,NULL,NULL,'$id','ID') INSERT INTO MOSKITO_OBJ_TYPES (OBJCLASS,TABLENAME,OBJTYPE,AM_DATENBANK,SELECTION_COL,SELECTION_VAL,KEY1,KEY2,BOX_X1,BOX_Y1,BOX_X2,BOX_Y2,AMID,FMID) Values ('Einzelbaum','BAUM','SYMBOL','180','ObjArt || ''_'' || AStatus || ''_'' || MapStatus','baum_0_1','13161','0',NULL,NULL,NULL,NULL,'$id','ID') INSERT INTO MOSKITO_OBJ_TYPES (OBJCLASS,TABLENAME,OBJTYPE,AM_DATENBANK,SELECTION_COL,SELECTION_VAL,KEY1,KEY2,BOX_X1,BOX_Y1,BOX_X2,BOX_Y2,AMID,FMID) Values ('Einzelbaum','BAUM','SYMBOL','180','ObjArt || ''_'' || AStatus || ''_'' || MapStatus','baum_0_2','13162','0',NULL,NULL,NULL,NULL,'$id','ID') INSERT INTO MOSKITO_OBJ_TYPES (OBJCLASS,TABLENAME,OBJTYPE,AM_DATENBANK,SELECTION_COL,SELECTION_VAL,KEY1,KEY2,BOX_X1,BOX_Y1,BOX_X2,BOX_Y2,AMID,FMID) Values ('Einzelbaum','BAUM','SYMBOL','180','ObjArt || ''_'' || AStatus || ''_'' || MapStatus','baum_10_0','13163','0',NULL,NULL,NULL,NULL,'$id','ID') INSERT INTO MOSKITO_OBJ_TYPES (OBJCLASS,TABLENAME,OBJTYPE,AM_DATENBANK,SELECTION_COL,SELECTION_VAL,KEY1,KEY2,BOX_X1,BOX_Y1,BOX_X2,BOX_Y2,AMID,FMID) Values ('Einzelbaum','BAUM','SYMBOL','180','ObjArt || ''_'' || AStatus || ''_'' || MapStatus','baum_10_1','13164','0',NULL,NULL,NULL,NULL,'$id','ID') INSERT INTO MOSKITO_OBJ_TYPES (OBJCLASS,TABLENAME,OBJTYPE,AM_DATENBANK,SELECTION_COL,SELECTION_VAL,KEY1,KEY2,BOX_X1,BOX_Y1,BOX_X2,BOX_Y2,AMID,FMID) Values ('Einzelbaum','BAUM','SYMBOL','180','ObjArt || ''_'' || AStatus || ''_'' || MapStatus','baum_10_2','13165','0',NULL,NULL,NULL,NULL,'$id','ID')
CREATE TABLE MOSKITO_LINE_TABLES (TABLENAME VARCHAR(40), X1 VARCHAR(40), Y1 VARCHAR(40), X2 VARCHAR(40), Y2 VARCHAR(40), ID VARCHAR(40), ID_NUMERIC DECIMAL(1), ID_QTX VARCHAR(40), TXT_X VARCHAR(40), TXT_Y VARCHAR(40), MIDDLE_POINTS VARCHAR(50), AM_DATENBANK VARCHAR(40), BLS VARCHAR(40))
CREATE TABLE MOSKITO_SYMBOL_TABLES (TABLENAME VARCHAR(40), X1 VARCHAR(40), Y1 VARCHAR(40), X2 VARCHAR(40), Y2 VARCHAR(40), ID VARCHAR(40), ID_NUMERIC DECIMAL(1), ID_QTX VARCHAR(40), TXT_X VARCHAR(40), TXT_Y VARCHAR(40), TXT_ALPHA VARCHAR(20), SYM_ALPHA VARCHAR(20), MIDDLE_POINTS VARCHAR(50), AM_DATENBANK VARCHAR(40), BLS VARCHAR(40)) INSERT INTO MOSKITO_SYMBOL_TABLES (TABLENAME,X1,Y1,ID,ID_NUMERIC,ID_QTX,TXT_X,TXT_Y,AM_DATENBANK,BLS) Values ('BAUM','Rechts','Hoch','BaumID',1,'BaumID',NULL,NULL,'180','BLS')
CREATE TABLE MOSKITO_COMPLEX_TABLES (TABLENAME VARCHAR(40), XML VARCHAR(20), ID VARCHAR(20), ID_NUMERIC DECIMAL(1), ID_QTX VARCHAR(20), AM_DATENBANK VARCHAR(30), BLS VARCHAR(40)) CREATE UNIQUE INDEX MOSKITO_COMPLEX_TABLES_IDX ON MOSKITO_COMPLEX_TABLES (TABLENAME) INSERT INTO MOSKITO_COMPLEX_TABLES (TABLENAME,XML,ID,ID_NUMERIC,ID_QTX,AM_DATENBANK,BLS) Values ('Kollekti','OBJECT','KOLLID',1,'KOLLID','181','ORT')
CREATE TABLE GIS_OBJECTS (ID VARCHAR(20), X1 VARCHAR(50), Y1 VARCHAR(50), X2 VARCHAR(50), Y2 VARCHAR(50), OBJECT LONG VARCHAR, ORT VARCHAR(40)) CREATE UNIQUE INDEX GIS_OBJECTS_IDX ON GIS_OBJECTS (ID)
CREATE TABLE NETZE (Name VARCHAR(20),Praefix VARCHAR(20)) CREATE UNIQUE INDEX NETZE_IDX ON NETZE (Name)
CREATE TABLE MESSPUNKTE (ID DECIMAL(9,0) NOT NULL, GRUNDNR INTEGER, MESSPUNKTNR INTEGER, CREATEDAT DATETIME, RECHTS DECIMAL(13,5), HOCH DECIMAL(13,5), WERT DECIMAL(15,7)) CREATE UNIQUE INDEX MESSPUNKTE_IDX ON MESSPUNKTE (ID)
|