Differences

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

--- cobi.wms:management_database [2023/06/28 16:07] – [Optional columns] tkammer
+++ cobi.wms:management_database [2024/12/05 08:15] (current) – thuth
@@ 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>