# phpMyAdmin MySQL-Dump
# version 2.3.3pl1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Apr 18, 2005 at 05:47 PM
# Server version: 4.01.10
# PHP Version: 5.0.3
# Database : `lexiconn`
# --------------------------------------------------------

#
# Table structure for table `prime_config`
#

DROP TABLE IF EXISTS prime_config;
CREATE TABLE prime_config (
  id smallint(5) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  description varchar(255) default NULL,
  `value` varchar(255) NOT NULL default '',
  webadmin enum('yes','no') NOT NULL default 'no',
  `type` enum('int','float','string') NOT NULL default 'string',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) Type=MyISAM COMMENT='System-wide configuration data';

#
# Dumping data for table `prime_config`
#

INSERT INTO prime_config VALUES (1, 'server_fqdn', 'Fully qualified domain name of webserver', 'wrightslaw.com', 'no', 'string');
INSERT INTO prime_config VALUES (2, 'server_document_root', 'Full path to document root', '/reviews/', 'no', 'string');
INSERT INTO prime_config VALUES (7, 'admin_review_default_sort', 'Default sort for reviews', 'created', 'no', 'string');
INSERT INTO prime_config VALUES (8, 'review_title_min_chars', 'Minimum length of review title', '3', 'no', 'int');
INSERT INTO prime_config VALUES (9, 'review_title_max_chars', 'Maximum length of review title', '200', 'no', 'int');
INSERT INTO prime_config VALUES (10, 'review_title_display_chars', 'Length of title to display in summary', '60', 'no', 'int');
INSERT INTO prime_config VALUES (11, 'base_install_dir', 'Base filesystem install dir', '/www/wrightslaw/reviews/', 'no', 'string');
INSERT INTO prime_config VALUES (12, 'tpl_dir', 'Template directory', '/resources/templates/', 'no', 'string');
INSERT INTO prime_config VALUES (13, 'tpl_c_dir', 'Compiled template dir', '/resources/templates/templates_c/', 'no', 'string');
INSERT INTO prime_config VALUES (14, 'cache_dir', 'Smarty cache directory', '/resources/templates/cache/', 'no', 'string');
INSERT INTO prime_config VALUES (15, 'admin_review_default_rating', 'Default value for rating when adding review', '3', 'no', 'int');
INSERT INTO prime_config VALUES (16, 'admin_review_max_rating', 'Maximum value of review rating', '5', 'no', 'int');
INSERT INTO prime_config VALUES (17, 'review_num_summary_display', 'Number of reviews summaries to display on product page', '5', 'yes', 'int');
INSERT INTO prime_config VALUES (18, 'review_rating_bargraph_pixels', 'Number of pixels for 100% rating bargraph image', '75', 'yes', 'int');
INSERT INTO prime_config VALUES (19, 'review_rating_unitname', 'Name of rating unit (e.g. "stars")', 'stars', 'yes', 'string');
INSERT INTO prime_config VALUES (20, 'admin_newreview_start_state', 'State at which new reviews are saved with (\'published\', \'queued\')', 'queued', 'no', 'string');
INSERT INTO prime_config VALUES (21, 'review_num_display_per_fullpage', 'Number of reviews to display per full listing page', '10', 'yes', 'int');
INSERT INTO prime_config VALUES (22, 'server_admin_root', 'Server path to admin document root', '/reviews/admin/', 'no', 'string');
INSERT INTO prime_config VALUES (23, 'admin_contact_email', 'Email address for system admin', 'pwright@harborhouselaw.com', 'yes', 'string');
INSERT INTO prime_config VALUES (24, 'admin_from_email', 'Email address to send messages as (From:)', 'pwright@harborhouselaw.com', 'yes', 'string');
INSERT INTO prime_config VALUES (25, 'admin_send_review_notifications', 'Send review notification emails (yes/no)', 'yes', 'no', 'string');
INSERT INTO prime_config VALUES (26, 'review_num_searchresult_per_page', 'Number of reviews summaries to display per page in admin search', '10', 'yes', 'int');
INSERT INTO prime_config VALUES (27, 'admin_review_notif_subject', 'Subject line for admin "new review" notifications', 'New product rating requires verification', 'yes', 'string');
INSERT INTO prime_config VALUES (28, 'admin_tplpreview_productsku', 'SKU of product to use in admin template previews', '999999', 'yes', 'string');
INSERT INTO prime_config VALUES (29, 'admin_tplpreview_reviewid', 'ID of review to use in admin template previews', '1', 'yes', 'int');
INSERT INTO prime_config VALUES (30, 'cache_summary_filename_format', 'Format used for names of flypage review summary cache files', 'summary_{sku}.html', 'no', 'string');
INSERT INTO prime_config VALUES (31, 'tmp_dir', 'Temporary directory for scratch files', '/tmp/', 'no', 'string');
# --------------------------------------------------------

#
# Table structure for table `prime_product`
#

DROP TABLE IF EXISTS prime_product;
CREATE TABLE prime_product (
  id int(10) unsigned NOT NULL auto_increment,
  sku varchar(127) NOT NULL default '',
  name varchar(255) default NULL,
  sortby enum('default','title','rating','created','name','sortindex') NOT NULL default 'default',
  sortdir enum('desc','asc') NOT NULL default 'desc',
  reviews enum('allow','disallow','suspended') NOT NULL default 'allow',
  numratings int(10) unsigned NOT NULL default '0',
  avgrating float unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY sku (sku)
) Type=MyISAM COMMENT='Product SKU to id mapping';

#
# Dumping data for table `prime_product`
#

INSERT INTO prime_product VALUES (1, '999999', 'Test Product', 'default', 'desc', 'allow', 6, '4.1667');
# --------------------------------------------------------

#
# Table structure for table `prime_review`
#

DROP TABLE IF EXISTS prime_review;
CREATE TABLE prime_review (
  id int(10) unsigned NOT NULL auto_increment,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  product int(10) unsigned NOT NULL default '0',
  rating smallint(5) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  review text NOT NULL,
  `status` enum('new','queued','published','suspended','disabled','deleted') NOT NULL default 'new',
  name varchar(127) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  city varchar(63) NOT NULL default '',
  state char(2) NOT NULL default '',
  country char(2) NOT NULL default '',
  sortindex smallint(6) unsigned NOT NULL default '99',
  ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (id)
) Type=MyISAM COMMENT='Product rating and review by user';

#
# Dumping data for table `prime_review`
#

INSERT INTO prime_review VALUES (1, '2005-04-18 17:31:00', 1, 5, 'Gigantic!', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nunc ullamcorper. Maecenas rhoncus. Donec erat justo, porta quis, dapibus eu, faucibus a, neque. Vestibulum non eros. Cras elementum nulla ac lacus. Quisque lacinia est vel mauris. Phasellus luctus tempus est. Nam imperdiet gravida dui. Ut non enim vitae mauris convallis condimentum. Etiam sem eros, imperdiet ut, tincidunt vel, laoreet ac, justo. Etiam et lacus auctor nunc vulputate elementum. Pellentesque diam ipsum, iaculis vel, bibendum sit amet, fermentum non, mauris. Nulla tincidunt adipiscing tellus. Etiam vitae neque. Phasellus eros tortor, aliquam quis, viverra in, pellentesque gravida, elit. Donec at neque et sem varius faucibus. Maecenas elementum erat. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos.\r\n\r\nPellentesque venenatis augue vel tortor. Curabitur massa. Vestibulum non dui. Phasellus mattis hendrerit arcu. Etiam id ligula. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam vel velit. Phasellus nec enim. Fusce ut tortor. Donec porttitor. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Suspendisse auctor dapibus massa. Proin eget lorem. Nulla felis ipsum, mattis in, mollis sed, lacinia eget, dolor. Etiam tortor diam, accumsan eget, lacinia eget, faucibus semper, est. Integer quis neque et ante ornare accumsan. Quisque nonummy, eros vitae pellentesque viverra, nisl ipsum eleifend sem, nec sollicitudin lectus ligula dictum sapien. Nulla malesuada nonummy est. Suspendisse sed quam. Praesent tellus. ', 'published', 'Ralph Nader', '', 'Miami', 'Fl', 'US', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (2, '2005-04-18 17:31:47', 1, 2, 'Not as great as I\'d hoped', 'Cras et risus vitae nunc ultricies rutrum. Mauris consectetuer libero quis nisl. Integer ipsum quam, gravida vel, bibendum at, scelerisque in, sapien. Ut rhoncus odio in sem. Cras elementum ornare leo. Phasellus condimentum tempor nibh. Maecenas porta porta mauris. Vivamus odio. Donec convallis velit vitae wisi. Sed semper malesuada massa. Integer dolor risus, nonummy at, suscipit sit amet, mollis in, nulla. Donec tempor nisl at sapien malesuada aliquam. Proin fringilla eros ut mauris. Morbi eu urna. Nam varius malesuada lectus. Vestibulum odio diam, aliquam et, pretium vel, laoreet quis, nibh. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Sed vitae velit eget diam vestibulum elementum. Donec convallis. Curabitur ac arcu.', 'published', 'Patty Pessimist', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (3, '2005-04-18 17:32:21', 1, 4, 'Better than advertised', '', 'published', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (4, '2005-04-18 17:32:52', 1, 5, 'Fantabulous', 'Aenean nunc nibh, molestie eu, consequat ac, sollicitudin in, nisl. Sed rhoncus felis luctus tortor. Mauris nec nibh. In placerat massa blandit dolor. Vestibulum sagittis. Integer sed arcu sed lorem lacinia vehicula. Nullam turpis nibh, rhoncus at, tincidunt non, scelerisque nec, ante. Mauris metus mauris, pharetra ac, dignissim at, consectetuer non, purus. Nulla laoreet, turpis sit amet pellentesque varius, elit tellus laoreet mauris, vitae tincidunt enim sapien ac est. Sed sit amet nisl sed wisi tincidunt dapibus. Aliquam facilisis nisl ut dui. Nam aliquam ultricies ipsum. Donec dolor neque, suscipit nonummy, pulvinar vel, gravida in, erat. Nam fermentum ligula nec purus. Nulla sed nibh. Pellentesque sit amet quam adipiscing mi tempus faucibus.', 'published', 'Joe Review', '', 'Montreal', 'QC', 'CA', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (5, '2005-04-18 17:33:49', 1, 5, 'Mui excellente!', 'Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Nulla blandit, magna a malesuada nonummy, enim justo pretium diam, ut dignissim ligula pede vel justo. Nullam wisi arcu, mattis vitae, dictum venenatis, dapibus vitae, pede. \r\n\r\nEtiam rutrum velit ut justo. In sapien sem, sodales quis, condimentum vel, porta non, risus. Duis eget justo. Nam iaculis metus ac urna lacinia ultricies. Fusce accumsan varius risus. Suspendisse faucibus erat eu augue. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Phasellus ut sapien a dui vehicula luctus. Aenean dapibus. \r\n\r\nCurabitur risus orci, dictum tincidunt, adipiscing vel, malesuada eu, nibh.', 'published', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (6, '2005-04-18 17:42:19', 1, 4, 'Better than good, worse than great', '', 'published', '', '', '', '', 'US', 99, '127.0.0.1');
# --------------------------------------------------------

#
# Table structure for table `prime_template`
#

DROP TABLE IF EXISTS prime_template;
CREATE TABLE prime_template (
  id smallint(5) unsigned NOT NULL auto_increment,
  name varchar(63) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  `action` varchar(31) NOT NULL default '',
  actionparam enum('none','productid','productsku','reviewid') NOT NULL default 'none',
  regenrequired enum('no','yes') NOT NULL default 'no',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) Type=MyISAM COMMENT='User managed templates used by system';

#
# Dumping data for table `prime_template`
#

INSERT INTO prime_template VALUES (1, 'review/full.html', 'Full listing of all reviews.', 'full', 'productsku', 'no');
INSERT INTO prime_template VALUES (2, 'review/newform.html', 'New review submission form', 'new', 'productsku', 'no');
INSERT INTO prime_template VALUES (3, 'review/preview.html', 'New review preview page', '', 'none', 'no');
INSERT INTO prime_template VALUES (4, 'review/reviewdone.html', 'New review submitted, thank you page.', '', 'none', 'no');
INSERT INTO prime_template VALUES (5, 'review/details.html', 'Single review, full listing.', 'details', 'reviewid', 'no');
INSERT INTO prime_template VALUES (6, 'review/summary.html', 'Product review summaries included on flypage', 'summary', 'productsku', 'yes');
INSERT INTO prime_template VALUES (7, 'review/summary-item.html', 'Summary for a single review', 'summary', 'productsku', 'yes');
INSERT INTO prime_template VALUES (8, 'review/popupfunc.js', 'Javascript used to generate popup window', '', 'none', 'yes');
INSERT INTO prime_template VALUES (9, 'header/pagefooter.html', 'Page footer', 'full', 'productsku', 'no');
INSERT INTO prime_template VALUES (10, 'header/page.html', 'Page header', 'full', 'productsku', 'no');
INSERT INTO prime_template VALUES (11, 'review/summary-empty.html', 'Used in place of summary when no reviews to date.', 'summary', 'productsku', 'yes');
# --------------------------------------------------------

#
# Table structure for table `prime_tplcontent`
#

DROP TABLE IF EXISTS prime_tplcontent;
CREATE TABLE prime_tplcontent (
  id int(10) unsigned NOT NULL auto_increment,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  template smallint(5) unsigned NOT NULL default '0',
  content text NOT NULL,
  notes varchar(255) NOT NULL default '',
  `status` enum('new','enabled','disabled','suspended','deleted') NOT NULL default 'new',
  PRIMARY KEY  (id)
) Type=MyISAM COMMENT='One version of template content';

#
# Dumping data for table `prime_tplcontent`
#


