Jopin requires a database to run. The project was written for a MySQL database.

The following SQL commands wil create the appropriate database layout for your Jopin instance.

CREATE TABLE `data` (
  `id` text,
  `ip` text,
  `source` text,
  `time` datetime default NULL,
  `pkey` bigint(20) NOT NULL auto_increment,
  PRIMARY KEY  (`pkey`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;

CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `name` text,
  `readkey` text,
  `writekey` text,
  `mail` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

There is no interface for adding users or other maintenance
Add a user using the following SQL statement:

insert into user (name, readkey, writekey, mail) values ('MachineName','RandomReadPWD' , 'RandomWritePWD', 'user@mail.be');