Start OpenOffice Base
1
2
3
4
5
6
7
8
9
Design License Table

Create the license table stub

You need to create a new table to hold the license data. While the table design is up to you, the default-configuration of the JLicensure server needs at least a token, a signature and a count column. We also need an auto-incremented primary key column.

Click on Tools -> SQL... as shown above. In the SQL dialog, enter the following:


  CREATE TABLE licenses (
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    token VARCHAR(256),
    signature VARCHAR(1024),
    count INTEGER NOT NULL
)

and click Execute. The status field should print out “Command successfully executed.”:

Hit the “Close” button.

On the left, select the “Tables” icon, then click “View” and “ Refresh Tables” as shown below:

The licenses table should appear in the “Tables” section.


 


Click here to continue

Start OpenOffice Base
1
2
3
4
5
6
7
8
9
Design License Table