OldFreeLibrary

Please put things about the old Distributed Library Project here that need to be ported, or would be convenient to reference.

Old Database Tables

strikethrough indicates we plan to make the tables deprecated…

• dlp_card → Book loan entries
• dlp_categories → genre info/localization
• dlp_feedback → user-to-user reviews
• dlp_interests → additional profile info?
• dlp_library → the book store
• dlp_list_interests → actual storage of ‘interests’?
• dlp_list_items → entries in a Reading List?
• dlp_lists → Reading List metadata?
• dlp_music → the music store
• dlp_reviews → item reviews
• dlp_user → basic user info
• dlp_userbio , useroptional and userinterests → additional profile info
• dlp_userverify → used to verify new users
• dlp_version → oh god…
• dlp_video → the video store

Major table schemas

dlp_card

  `id` mediumint(9) NOT NULL,
  `type` varchar(20) NOT NULL,
  `user_id` mediumint(9) NOT NULL,
  `checkout` date NOT NULL,

dlp_categories

  `type` varchar(30) NOT NULL,
  `name` varchar(100) NOT NULL,
  `de_DE` varchar(100) NOT NULL,
  `en_UK` varchar(100) NOT NULL,
  `fr_CH` varchar(100) NOT NULL,
  `fr_FR` varchar(100) NOT NULL,
  `es_AR` varchar(100) NOT NULL,

dlp_feedback

  `user_id` mediumint(9) NOT NULL,
  `source` mediumint(9) NOT NULL,
  `positive` tinyint(1) NOT NULL,
  `notes` varchar(200) NOT NULL,
  `date` date NOT NULL,

dlp_interests

  `id` mediumint(9) NOT NULL auto_increment,
  `interest` varchar(255) NOT NULL,
  `count` mediumint(9) NOT NULL default '0',

dlp_library

  `id` mediumint(9) NOT NULL auto_increment,
  `user_id` mediumint(9) NOT NULL,
  `authorlast` varchar(30) NOT NULL,
  `authorfirst` varchar(30) NOT NULL,
  `title` varchar(200) NOT NULL,
  `section` varchar(20) NOT NULL,
  `review` mediumtext,
  `status` varchar(20) NOT NULL,
  `current_holder` mediumint(9) NOT NULL default '1',
  `isbn` char(10) default NULL,
  `date_back` date default NULL,
  `created` date NOT NULL,

dlp_list_interests

  `id` mediumint(9) NOT NULL,
  `interestid` mediumint(9) NOT NULL,

dlp_list_items

  `id` mediumint(9) NOT NULL,
  `item_title` varchar(255) NOT NULL,
  `item_comment` varchar(255) default NULL,
  `item_pos` tinyint(4) NOT NULL default '0',

dlp_lists

  `id` mediumint(9) NOT NULL auto_increment,
  `owner` mediumint(9) NOT NULL,
  `title` varchar(255) NOT NULL,
  `created` date NOT NULL,

dlp_music

  `id` mediumint(9) NOT NULL auto_increment,
  `user_id` mediumint(9) NOT NULL,
  `title` varchar(255) NOT NULL,
  `artist` varchar(255) NOT NULL,
  `genre` varchar(50) NOT NULL,
  `review` mediumtext,
  `medium` varchar(20) NOT NULL,
  `cddb_key` varchar(8) default NULL,
  `year` smallint(6) default NULL,
  `status` varchar(20) NOT NULL,
  `current_holder` mediumint(9) NOT NULL default '1',
  `date_back` date default NULL,
  `created` date NOT NULL,

dlp_reviews

  `author` mediumint(9) NOT NULL,
  `first_name` varchar(20) NOT NULL,
  `last_name` varchar(20) NOT NULL,
  `title` varchar(200) NOT NULL,
  `review` mediumtext NOT NULL

dlp_user

  `id` mediumint(9) NOT NULL auto_increment,
  `verify` varchar(50) default NULL,
  `username` varchar(15) NOT NULL,
  `password` varchar(32) NOT NULL,
  `salt` varchar(32) NOT NULL,
  `sessionid` varchar(50) default NULL,
  `first_name` varchar(20) NOT NULL,
  `last_name` varchar(20) NOT NULL,
  `address` varchar(255) NOT NULL,
  `apartment` varchar(5) default NULL,
  `zipcode` varchar(9) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created` date NOT NULL,
  `feedback` smallint(6) NOT NULL default '0',
  `lon` decimal(8,4) default NULL,
  `lat` decimal(8,4) default NULL,
  `managed_geolookup` tinyint(1) NOT NULL default '0',
  `lang` char(10) default NULL,
  `town` varchar(64) default NULL,

dlp_userbio

  `id` mediumint(9) NOT NULL,
  `bio` mediumtext,

dlp_userinterests

  `id` mediumint(9) NOT NULL,
  `interestid` mediumint(9) NOT NULL,

dlp_useroptional

  `id` mediumint(9) NOT NULL,
  `cellphone` varchar(10) default NULL,
  `url` varchar(255) default NULL,
  `aim` varchar(25) default NULL,
  `icq` varchar(10) default NULL,
  `msn` varchar(25) default NULL,

dlp_userverify

  `id` mediumint(9) NOT NULL,
  `verify` varchar(32) NOT NULL,
  `created` datetime NOT NULL,

dlp_version

  `version` mediumint(9) NOT NULL,

dlp_video

  `id` mediumint(9) NOT NULL auto_increment,
  `user_id` mediumint(9) NOT NULL,
  `title` varchar(255) NOT NULL,
  `genre` varchar(50) NOT NULL,
  `review` mediumtext,
  `medium` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `current_holder` mediumint(9) NOT NULL default '1',
  `date_back` date default NULL,
  `created` date NOT NULL,