Changeset 38


Ignore:
Timestamp:
01/10/14 16:37:52 (10 years ago)
Author:
lucsch
Message:

Updating base_structure to latest ToolMap? database version 229

Location:
trunk/models/base
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/models/base/base_structure_swiss.sql

    r37 r38  
    197197CREATE TABLE `prj_settings` ( 
    198198  `SETTING_DBK` int(11) NOT NULL AUTO_INCREMENT, 
    199   `PRJ_UNIT` varchar(10) NOT NULL, 
     199  `PRJ_UNIT` varchar(45) NOT NULL, 
    200200  `PRJ_PROJECTION` varchar(45) NOT NULL, 
    201201  `PRJ_NAME` varchar(45) NOT NULL, 
     
    207207  `PRJ_SUMMARY` text, 
    208208  `PRJ_SNAP_TOLERENCE` int(11) NOT NULL DEFAULT '10', 
     209  `PRJ_LANG_ACTIVE` int(11) NOT NULL DEFAULT '0', 
     210  `PRJ_BEZIER_APPROX` float NOT NULL DEFAULT '0.5', 
     211  `PRJ_BEZIER_WIDTH` float NOT NULL DEFAULT '1', 
     212  `PRJ_BEZIER_NB_VERTEX` int(11) NOT NULL DEFAULT '10', 
     213  `PRJ_BEZIER_METHOD` int(11) NOT NULL DEFAULT '0', 
    209214  PRIMARY KEY (`SETTING_DBK`) 
    210 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    211  
    212  
    213 INSERT INTO prj_settings VALUES(1,"Meters","Swiss projection (CH1903)","Master",225,"",0,"","SWISSTOPO - CREALP", "", 0); 
     215) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     216 
     217INSERT INTO prj_settings VALUES(1,"Meters","Swiss projection (CH1903)","Master",229,"",0,"","SWISSTOPO - CREALP", "", 10, 0, 0.5, 1, 10, 0); 
    214218 
    215219-- prj_snapping -- 
  • trunk/models/base/base_structure_wgs84.sql

    r36 r38  
    197197CREATE TABLE `prj_settings` ( 
    198198  `SETTING_DBK` int(11) NOT NULL AUTO_INCREMENT, 
    199   `PRJ_UNIT` varchar(10) NOT NULL, 
     199  `PRJ_UNIT` varchar(45) NOT NULL, 
    200200  `PRJ_PROJECTION` varchar(45) NOT NULL, 
    201201  `PRJ_NAME` varchar(45) NOT NULL, 
     
    207207  `PRJ_SUMMARY` text, 
    208208  `PRJ_SNAP_TOLERENCE` int(11) NOT NULL DEFAULT '10', 
     209  `PRJ_LANG_ACTIVE` int(11) NOT NULL DEFAULT '0', 
     210  `PRJ_BEZIER_APPROX` float NOT NULL DEFAULT '0.5', 
     211  `PRJ_BEZIER_WIDTH` float NOT NULL DEFAULT '1', 
     212  `PRJ_BEZIER_NB_VERTEX` int(11) NOT NULL DEFAULT '10', 
     213  `PRJ_BEZIER_METHOD` int(11) NOT NULL DEFAULT '0', 
    209214  PRIMARY KEY (`SETTING_DBK`) 
    210 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    211  
    212  
    213 INSERT INTO prj_settings VALUES(1,"Degrees (DD)","World (WGS84)","Master",225,"",0,"","SWISSTOPO - CREALP", "", 0); 
     215) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     216 
     217INSERT INTO prj_settings VALUES(1,"Degrees (DD)","World (WGS84)","Master",229,"",0,"","SWISSTOPO - CREALP", "", 10, 0, 0.5, 1, 10, 0); 
    214218 
    215219-- prj_snapping -- 
Note: See TracChangeset for help on using the changeset viewer.