pici-server database tables

pici-server has the following database scheme:

• form
  • idx: bigint(20): primary key: autoincrement
  • url: varchar(255)
  • cipher_key: varchar(255)
  • ref: varchar(255): indexed
  • formfields: varchar(255)
  • hiddenfields: varchar(255)
  • ip: varchar(255)
  • created: double: indexed
• ref2url
  • idx: bigint(20): primary key: autoincrement
  • ref: varchar(255): indexed
  • url: varchar(255)
  • created: double: indexed
  • requested: int(11)
  • ip: varchar(255)
  • idx_url: bigint(20)
• url2pic
  • idx: bigint(20): primary key: autoincrement
  • url: varchar(255): indexed
  • pic: varchar(255)
  • created: double: indexed
  • loading: int(11): default 1
  • displaynr: int(11)