Differences

This shows you the differences between two versions of the page.

--- cobi.wms:management_database [2023/06/28 16:04] – tkammer
+++ cobi.wms:management_database [2024/12/05 08:15] (current) – thuth
@@ Line 74: / Line 74: @@
 The ''Profile'' column is used to enable customer-specific specializations in the app and should be left empty unless instructed.
-The ''PrintService'' column can be used to centrally define the address of the [[Print Service|COBI.wms Print Service]].  If not defined here, it has to be set on each Android device in the [[Print Settings]] screen of COBI.wms.
+The ''PrintService'' column can be used to centrally define the address of the [[Print Service|COBI.wms Print Service]].  If not defined here, it has to be set on each Android device in the [[Print Settings]] screen of COBI.wms.  When using the standard port of the COBI.wms Print Service, you should only enter the host name or IP address in this column.  When using a non-standard port number, you can specify it by entering the value ''HOST:PORT'' in this column where ''HOST'' is the host name or IP address and ''PORT'' is the TCP port number.
@@ Line 207: / Line 207: @@
 insert into licenses (license) values ('LICENSE_2');
 insert into licenses (license) values ('LICENSE_3');
+</code>
+The licenses table also has an optional ''notes'' column which you can use for notes about the license.  For example, if you have both regular COBI.wms licenses as well as COBI.ppc licenses in the same database, you can differentiate them through these notes.  Or, when importing test licenses that are only valid for a limited time, you can enter this as a note.  Examples:
+<code sql>
+insert into licenses (license, 'notes') values ('LICENSE_1', 'WMS');
+insert into licenses (license, 'notes') values ('LICENSE_2', 'PPC');
+insert into licenses (license, 'notes') values ('LICENSE_3', 'PPC, valid until November 2023');
 </code>