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

#
# Table structure for table `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)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 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', 'prime.psychogenic.com', 'no', 'string');
INSERT INTO prime_config VALUES (2, 'server_document_root', 'Full path to document root', '/', 'no', 'string');
INSERT INTO prime_config VALUES (3, 'server_smtphost', 'Host for outgoing mail', 'gw.psychogenic.com', 'no', 'string');
INSERT INTO prime_config VALUES (4, 'server_smtp_hostname', 'Hostname to use in SMTP HELO', 'prime.psychogenic.com', 'yes', 'string');
INSERT INTO prime_config VALUES (5, 'server_smtp_user', 'Username to provide for SMTP host (outgoing mail)', '', 'yes', 'string');
INSERT INTO prime_config VALUES (6, 'server_smtp_password', 'Password to use for SMTP host (outgoing mail)', '', 'yes', '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', '/home/malcalypse/Projects/Lexiconn/prime/', 'no', 'string');
INSERT INTO prime_config VALUES (12, 'tpl_dir', 'Template directory', 'templates/', 'no', 'string');
INSERT INTO prime_config VALUES (13, 'tpl_c_dir', 'Compiled template dir', 'templates/templates_c/', 'no', 'string');
INSERT INTO prime_config VALUES (14, 'cache_dir', 'Smarty cache directory', 'templates/cache/', 'no', 'string');
INSERT INTO prime_config VALUES (15, 'admin_review_default_rating', 'Default value for rating when adding review', '5', 'no', 'int');
INSERT INTO prime_config VALUES (16, 'admin_review_max_rating', 'Maximum value of review rating', '10', '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', '/admin/', 'no', 'string');
INSERT INTO prime_config VALUES (23, 'admin_contact_email', 'Email address for system admin', 'webdev@psychogenic.com', 'yes', 'string');
INSERT INTO prime_config VALUES (24, 'admin_from_email', 'Email address to send messages as (From:)', 'oanda@psychogenic.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', '234234', 'yes', 'string');
INSERT INTO prime_config VALUES (29, 'admin_tplpreview_reviewid', 'ID of review to use in admin template previews', '16', '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');
# --------------------------------------------------------

#
# Table structure for table `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)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Product SKU to id mapping';

#
# Dumping data for table `prime_product`
#

INSERT INTO prime_product VALUES (1, '234234', 'Confabulator Delux', 'sortindex', 'asc', 'allow', 16, '6');
INSERT INTO prime_product VALUES (2, '234235', NULL, 'default', 'desc', 'allow', 1, '4');
INSERT INTO prime_product VALUES (3, '234236', 'Unreviewable Wonder', 'default', 'desc', 'disallow', 0, '0');
# --------------------------------------------------------

#
# Table structure for table `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)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Product rating and review by user';

#
# Dumping data for table `prime_review`
#

INSERT INTO prime_review VALUES (1, '2005-04-04 22:59:37', 1, 8, '8 stars for this, fer sure!', 'Wam bap a luah, ah wap bam boo!\r\n\r\n8 stars are better than none ;-)', 'published', 'Blonk Boozah', 'avrfreak@psychogenic.com', 'Montreal', 'QC', 'CA', 2, '127.0.0.1');
INSERT INTO prime_review VALUES (2, '2005-04-04 23:01:55', 1, 2, '2 stars for this junk!!', 'This is total shizerola, I tell ya!', 'published', 'Anonymous User', '', '', '', '', 1, '127.0.0.1');
INSERT INTO prime_review VALUES (3, '2005-04-04 23:03:27', 1, 9, '9 star wonder!', '', 'suspended', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (4, '2005-04-05 07:48:52', 1, 7, 'Bestest in the Westest', '', 'published', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (5, '2005-04-05 07:51:14', 1, 6, 'Better than you\'d have imagined', 'Tonight, Ole André Vadla Ravnås of the Farsight project (LGPL), which \'is an audio/video conferencing framework specifically designed for Instant Messengers\' for the GNU Linux operating system, finished coding a release candidate of libmimic, \'an open source video encoding/decoding library for Mimic V2.x-encoded content (fourCC: ML20), which is the encoding used by MSN Messenger for webcam conversations.\' \r\n\r\nOle, on the libmimic site, remarks that \'It should be noted that reverse-engineering for interoperability is 100% legal here in Norway (and in most European countries).\' \r\n\r\nLooks like the Free/Open Source Software movement is very close to closing up one of the most noticeable software gaps remaining from its glorious efforts.', 'published', 'André Vadla Ravnås', '', '', '', 'NO', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (6, '2005-04-05 07:52:31', 1, 5, 'It\'s really ok', 'hohoho\r\n', 'published', '', '', '', '', '', 4, '127.0.0.1');
INSERT INTO prime_review VALUES (7, '2005-04-05 07:53:29', 1, 8, 'Fantabulous!!!', 'Really is amazing -- I am flabergasted!', 'published', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (8, '2005-04-05 08:02:26', 1, 9, 'I laughed, I cried', 'IN THE movie Terminator 2, the villain is a robot made of liquid metal. He morphs from human form to helicopter and back again with ease, moulds himself into any shape without breaking, and can even flow under doorways.\r\n\r\nNow a similar-sounding futuristic material is about to turn up everywhere. It is called metallic glass. In the past year, researchers have made metallic glass three times stronger than the best industrial steel and 10 times springier. Almost a match for the Terminator, in other words.\r\n\r\nMetallic glass sounds like an oxymoron, and in a way it is. It describes a metal alloy with a chaotic structure. While metal atoms normally arrange themselves in ordered arrays, or crystals, the atoms in a metallic glass are a disordered jumble, rather like the atoms in a liquid or a glass. And although strictly speaking a metallic glass isn\'t a liquid, because the atoms are fixed in place, one company is already marketing the stuff as "liquid metal".', 'published', 'Bill Nye', 'avrfreak@psychogenic.com', 'Science City', 'CA', 'US', 2, '127.0.0.1');
INSERT INTO prime_review VALUES (9, '2005-04-05 08:03:24', 1, 3, 'Boop', '', 'published', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (10, '2005-04-05 09:30:51', 1, 5, '5 stars are better than none!', '', 'published', '', '', '', '', '', 5, '127.0.0.1');
INSERT INTO prime_review VALUES (11, '2005-04-05 09:31:36', 1, 5, '5 stars are better than none!', '', 'published', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (12, '2005-04-05 09:34:42', 1, 8, 'Awesome! Will never look at another product the same way...', 'The next generation of personal computers and portable music players could hold 10 times more information than current models, thanks to a different way of writing magnetic data to a hard disc.\r\n\r\nJapanese electronics company Hitachi announced on Monday that a number of its employees had begun testing the experimental technology, known as "perpendicular recording". The company aims to offer drives incorporating it to the public towards the end of 2005.\r\n\r\nHard drives store information by magnetising sectors of a disc in a specific direction, which then correspond to either a “1” or a “0”. This is done by passing magnetic heads over the disc surface which magnetises the sectors in a direction parallel to its surface - so-called "longitudinal recording". The heads are turned around to impart the reverse polarity.\r\n\r\nPerpendicular recording uses different-shaped heads to magnetise disc sectors so that the polarity points either up or down - at 90° to the disc’s surface. Data can still be retrieved from the disc in the traditional way, using another head to detect the magnetic charge.\r\n\r\n"It\'s a major technical change," says John Fox, business manager for Hitachi\'s European hard drive business. "But it\'s transparent to the user."', 'published', 'Fox Mulder', 'avrfreak@psychogenic.com', 'Vancouver', 'BC', 'CA', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (13, '2005-04-05 09:35:23', 1, 7, 'Seen better, but seen worse.', 'Pretty good, though a little rough around some edges...', 'published', '', '', 'Montreal', 'QC', 'CA', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (14, '2005-04-05 09:36:22', 1, 6, 'Sunday is my fun day', '', 'published', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (15, '2005-04-05 09:40:19', 1, 8, 'Who framed its fearful symmetry?', 'Cotton, the fabric of your life, could soon have the potential to save it. Scientists at Texas Tech University\'s Institute of Environmental and Human Health on Monday unveiled a new composite cotton fabric they say will protect against biological and chemical agents.\r\n\r\nThe fabric, developed with the U.S. Department of Defense in mind, also brings a fresh market to cotton farmers in West Texas, the nation\'s largest producing region.\r\n\r\n"We are the first to bring cotton into the national defense arena,\'\' said Seshadri Ramkumar, the researcher at the institute who developed the fabric. "This is a big thing.\'\'\r\n\r\nThe nonwoven fabric is "exactly\'\' the type the defense department placed in its decontamination and science technology strategy, he said. A thin piece of carbon is encased on either side by the nonwoven cotton.\r\n\r\nThe fabric can be used as a wipe to remove dangerous contaminants from a variety of surfaces, including human skin and intricate equipment on fighter planes. The fabric is lightweight, soft, flexible and able to be draped over unusually shaped objects.\r\n\r\nThe material neutralizes and absorbs toxic chemicals used in chemical warfare and pesticides.\r\n\r\nAnother use could be the inner lining of a protective suit.\r\n\r\n"This is a win-win day for Texas Tech,\'\' said U.S. Rep. Randy Neugebauer, R-Lubbock, who attended a news conference announcing the technology and its licensing to a Texas company. "It\'s a win-win day for the American people.\'\'\r\n\r\nNow, the military uses a cloth made from carbon, which leaves skin and other surfaces dirty.\r\n\r\nThe fabric passed tests for bacteria, yeast, fungus and mold but has not been tested for anthrax and other potentially deadly biological agents. But enzymes specifically targeting a particular agent can be applied.\r\n\r\n"Once it has been tested for nerve agents, sure it can\'\' save lives, Ramkumar said.\r\n\r\nCotton watchers in West Texas said the fabric presents an exciting avenue for area producers.\r\n\r\n"It\'s an opportunity to add value to our locally grown fiber and add a new income source to our area economy,\'\' said Roger Haldenby, a spokesman for the Plains Cotton Growers, which serves a 41-county region.\r\n\r\nIn recent days, the university licensed a Waco-based company, Hobbs Bonded Fibers, to market the fabric.\r\n\r\nCarey Hobbs, the company\'s chief executive officer, said negotiations with government officials could begin within a couple of months.\r\n\r\n"This is something that could be very meaningful and contribute to the country\'s mission right now,\'\' Hobbs said. "This is an opportunity you look for your whole business life.\'\' ', 'published', 'Roger Roger', '', 'Roboville', 'WA', 'US', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (16, '2005-04-05 09:41:31', 1, 3, 'Mayan ceramics were better', 'Underwater archaeologists have discovered 41 new seaside salt production works used by the ancient Mayans in Central America. The discovery at Punta Ycacos Lagoon in what is now Belize provides evidence of extensive salt production to serve the large Mayan cities on the interior of the Yucatan Peninsula, reports researcher Heather McKillop of Louisiana State University. Her findings are reported in Tuesday\'s issue of Proceedings of the National Academy of Science. Four salt works had previously been known in that area. The discovery of 41 new works, along with the remains of wooden buildings from the era of A.D. 600 to 900, indicates salt was mass-produced and stored before shipment upriver, she reported. \r\n\r\nCeramic pottery was used for boiling water to produce the salt, she wrote, and a canoe paddle was also found, indicating that the salt was transported inland by canoe. \r\n\r\nThe research was supported by a grant from Louisiana State University.', 'published', 'Daniel Jackson', '', '', '', '', 3, '127.0.0.1');
INSERT INTO prime_review VALUES (17, '2005-04-05 09:42:25', 1, 4, 'It\'s batteries die out and it tastes funny', '', 'queued', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (18, '2005-04-06 07:34:03', 2, 4, 'Not as good as the first one!', '', 'published', 'Freddy Mercury', 'avrfreak@psychogenic.com', '', '', 'US', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (19, '2005-04-06 14:14:00', 2, 6, 'Better but not the best', 'As of April 4, 2005 the SANS Internet Storm Center has raised their alert level to Yellow following a rash of active DNS poisonings. \r\n\r\nThe infected DNS servers are re-directing users from popular sites such as Google or American Express to malware infecting advertising sites. According to the ISC presentation on the attack, it is believed to be linked to known spammers and malware distributors. \r\n\r\nThe full presentation of information up until this point can be found aaaahhhhhh!', 'deleted', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (20, '2005-04-06 14:18:34', 2, 6, 'Better but not the best', 'As of April 4, 2005 the SANS Internet Storm Center has raised their alert level to Yellow following a rash of active DNS poisonings. \r\n\r\nThe infected DNS servers are re-directing users from popular sites such as Google or American Express to malware infecting advertising sites. According to the ISC presentation on the attack, it is believed to be linked to known spammers and malware distributors. \r\n\r\nThe full presentation of information up until this point can be found aaaahhhhhh!', 'deleted', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (21, '2005-04-06 14:20:26', 2, 6, 'Better but not the best', 'As of April 4, 2005 the SANS Internet Storm Center has raised their alert level to Yellow following a rash of active DNS poisonings. \r\n\r\nThe infected DNS servers are re-directing users from popular sites such as Google or American Express to malware infecting advertising sites. According to the ISC presentation on the attack, it is believed to be linked to known spammers and malware distributors. \r\n\r\nThe full presentation of information up until this point can be found aaaahhhhhh!', 'queued', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (22, '2005-04-06 14:29:04', 2, 8, 'Swift measures distance to gamma-ray bursts', 'NASA\'s Swift space telescope has been used to directly measure the distance to fleeting cosmic explosions, called gamma-ray bursts, for the first time. The measurements are crucial for determining how much energy the bursts unleash.\r\n\r\nGamma-ray bursts (GRBs) are powerful blasts of high-energy gamma-ray photons thought to herald the birth of black holes. They typically last less than a minute but can produce afterglows at a range of wavelengths - from X-rays to radio waves - that linger for hours or weeks. The afterglows can reveal the distance and nature of the bursts, and Swift was designed to swivel towards them in about a minute.\r\n\r\nSwift has detected two dozen GRBs since its launch in November 2004, and it has found X-ray afterglows for about 15 of them. But until recently, it saw no optical afterglows - light emitted in the visible spectrum - even when ground-based observers looking at the same bursts did. "We were getting a little worried," admits Dale Frail, a Swift team member at the National Radio Astronomy Observatory in Socorro, New Mexico, US.\r\n\r\nBut Swift\'s Ultraviolet/Optical Telescope (UVOT) has made up for lost time, catching the optical afterglow of a bright GRB on 18 March 2005 and a second one the very next day. "Now we know there\'s no problem - the first few events were just too faint for UVOT to detect".', 'queued', 'Johnny Dep', 'johnny@dep.com', 'Typecast-as-a-pirate-ville', 'OH', 'US', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (23, '2005-04-06 14:56:29', 1, 7, 'Wowa!', 'THE spectacle is depressingly familiar - angry supporters of losing sports teams venting their frustration through violence and rioting. It is what happened in London\'s Trafalgar Square in 1996, after England\'s soccer team lost to Germany. But surprisingly, things might have been even worse had England won.\r\n\r\nThat\'s according to an analysis by Vaseekaran Sivarajasingam, a surgeon at Cardiff University in Wales based on admissions to the University Hospital of Wales\'s accident and emergency department, also in Cardiff. The city is home to the 74,500-seat Millennium Stadium, scene of numerous sporting events, including Wales\'s recent grand slam victory in rugby union\'s Six Nations championship.\r\n\r\nThe team focused on the 106 international rugby or soccer matches between 1995 and 2002. On non-match days, the number of assault victims averaged 21 per day, and on match days when Wales lost this rose to 25. But the situation was worse after a win, with 33 admissions per day on average (Injury Prevention, vol 11, p 69).\r\n\r\nSivarajasingam blames fans\' extra swagger when they win, aggravated by drunken celebrations. "Alcohol is a big part in this," he says. "And when people mingle around in a heightened state of self-assertiveness and confidence, they are more likely to resolve an argument with a fight."', 'queued', 'Blimey Mate', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (24, '2005-04-06 15:02:13', 1, 6, 'I put my comment in the title, that\'s what I do', '', 'published', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (26, '2005-04-14 00:38:48', 1, 5, 'asdfasd', 'sadfasdf sdafsdfsdaf', 'queued', 'sadf sadfsadf', '', '', '', '', 99, '192.168.48.100');
INSERT INTO prime_review VALUES (25, '2005-04-13 07:01:01', 1, 5, 'oeuoaeu oaeuoaeu', '', 'queued', '', '', '', '', '', 99, '127.0.0.1');
INSERT INTO prime_review VALUES (27, '2005-04-14 01:10:15', 1, 5, 'asdfasd', 'sadfasdf sdafsdfsdaf', 'queued', 'sadf sadfsadf', '', '', '', '', 99, '192.168.48.100');
INSERT INTO prime_review VALUES (28, '2005-04-14 01:11:05', 1, 5, 'asdfasd', 'sadfasdf sdafsdfsdaf', 'queued', 'sadf sadfsadf', '', '', '', '', 99, '192.168.48.100');
INSERT INTO prime_review VALUES (29, '2005-04-14 01:16:02', 1, 5, 'erywe5yw yw', 'egerrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rrrrrrrrrrerrtewrytw54werywe56y w5y5y7w4575476u658378ew83e794e', 'queued', '', '', '', '', '', 99, '192.168.48.100');
INSERT INTO prime_review VALUES (30, '2005-04-14 01:16:12', 1, 5, 'erywe5yw yw', 'egerrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rrrrrrrrrrerrtewrytw54werywe56y w5y5y7w4575476u658378ew83e794e', 'queued', '', '', '', '', '', 99, '192.168.48.100');
# --------------------------------------------------------

#
# Table structure for table `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)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 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`
#

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)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='One version of template content';

#
# Dumping data for table `prime_tplcontent`
#

INSERT INTO prime_tplcontent VALUES (1, '2005-04-14 07:22:38', 1, '{include file="header/page.html"}\r\n\r\n<!-- tpl review/full.html begin -->\r\n{include file="file:common/errmsg.html"}\r\n\r\n<h2>{if $product.name}{$product.name|truncate:30:"...":true|escape:"htmlall"} reviews{else}Reviews{/if}</h2>\r\n\r\n{if $product.numratings}\r\n<div class="feedbackBG"><img src="/images/pixel.gif" class="feedback" height="13" width="{$product.ratingwidth}" border="0" /></div>\r\n<p>Global Rating: {$product.avgrating|string_format:"%.2f"} from {$product.numratings} reviews.</p>\r\n  {else}\r\n  {/if}\r\n<p><a href="{$newhref}">Add your own review for this product</a></p>\r\n\r\n{include file="file:common/pager.html"}\r\n\r\n<table class="reviews">\r\n	<tr>\r\n		<th><a href="{$sorthref.title}">title</a></th>\r\n		<th><a href="{$sorthref.created}">date</a></th>\r\n		<th><a href="{$sorthref.name}">name</a></th>\r\n		<th><a href="{$sorthref.city}">city</a> <a href="{$sorthref.state}">state</a> <a href="{$sorthref.country}">country</a></th>\r\n		<th><a href="{$sorthref.rating}">rating</a></th>\r\n	</tr>\r\n{foreach item=review from=$reviews}\r\n	<tr class="head">\r\n		<td class="title">{$review.title|truncate:60:"..."|escape:"htmlall"} ({$review.rating}/{$reviewmaximum})</td>\r\n		<td nowrap="nowrap">{$review.created|date_format}</td>\r\n		<td>{$review.name|truncate:40:"..."|escape:"htmlall"}</td>\r\n		<td>{$review.city|truncate:30:"..."|escape:"htmlall"} {$review.state} {$review.country}</td>\r\n		<td><div class="feedbackBG"><img src="/images/pixel.gif" class="feedback" height="13" width="{$review.ratingwidth}" border="0" /></div></td>\r\n	</tr>\r\n	<tr>\r\n		<td colspan="5">\r\n			<blockquote>\r\n		{if $review.review}{$review.review|escape:"htmlall"|nl2br}{else}\r\n				No comment.\r\n		{/if}\r\n			</blockquote>\r\n		</td>\r\n	</tr>\r\n{/foreach}\r\n</table>\r\n{include file="file:common/pager.html"}\r\n\r\n{include file="header/pagefooter.html"}\r\n<!-- tpl review/full.html end -->\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (2, '2005-04-14 07:22:38', 10, '<?xml version="1.0" encoding="iso-8859-1"?>\r\n<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml">\r\n<head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />\r\n<link rel="stylesheet" href="/css/public.css" type="text/css" />\r\n<link rel="stylesheet" href="/css/feedback.css" type="text/css" />\r\n<title>PRIME: Product Review Module</title>\r\n</head>\r\n<body>\r\n<!-- tpl header/page.html end -->', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (3, '2005-04-14 07:22:38', 9, '<!-- tpl header/pagefooter.html begin -->\r\n</body>\r\n</html>\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (4, '2005-04-14 07:23:02', 5, '{include file="header/page.html"}\r\n\r\n{include file="file:common/errmsg.html"}\r\n\r\n<!-- tpl review/details.html begin -->\r\n<h2>{if $product.name}{$product.name|escape:"htmlall"} review{else}Review{/if} \r\n{if $review.name}by {$review.name|escape:"htmlall"}{else}(anonymous){/if}</h2>\r\n<p>\r\n<a href="{$fullhref}">See all reviews</a> or <a href="{$newhref}">add your own review of this product</a>\r\n</p>\r\n<table class="review">\r\n	<tr class="head">\r\n		<td class="title">{$review.title|truncate:60:"..."|escape:"htmlall"} ({$review.rating}/{$reviewmaximum})</td>\r\n		<td nowrap="nowrap">{$review.created|date_format}</td>\r\n		<td>{$review.name|truncate:40:"..."|escape:"htmlall"}</td>\r\n		<td>{$review.city|truncate:30:"..."|escape:"htmlall"} {$review.state} {$review.country}</td>\r\n		<td><div class="feedbackBG"><img src="/images/pixel.gif" class="feedback" height="13" width="{$review.ratingwidth}" border="0" /></div></td>\r\n	</tr>\r\n	<tr>\r\n		<td colspan="5" class="review">\r\n			<blockquote>\r\n	{if $review.review}{$review.review|escape:"htmlall"|nl2br}{else}\r\n	No comment.\r\n	{/if}\r\n			</blockquote>\r\n		</td>\r\n	</tr>\r\n</table>\r\n<!-- tpl review/details.html end -->\r\n\r\n{include file="header/pagefooter.html"}\r\n\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (5, '2005-04-14 07:23:05', 2, '<!-- tpl review/newform.html begin -->\r\n{include file="header/page.html"}\r\n<h2>Rate a Product / Write a Review</h2>\r\n{include file="file:common/errmsg.html"}\r\n\r\n<p>Enter your rating and review of this product</p>\r\n<form method="POST" action="{$newreviewaction}">\r\n<input type="hidden" name="getguard" value="1" />\r\n<div class="form">\r\n{include file="file:common/reviewfields.html"}\r\n</div>\r\n<div class="button"><input type="submit" name="submit" value="Preview" /></div>\r\n</form>\r\n{include file="header/pagefooter.html"}\r\n\r\n<!-- tpl review/newform.html end -->\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (6, '2005-04-14 07:23:06', 8, '{literal}\n<script language="JavaScript"><!--\nfunction createNewReviewWindow (where)\n{\n	window.open(where, \'newproductreview\', \'width=475,height=500,scrollbars=1\');\n}\n--></script>\n{/literal}\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (7, '2005-04-14 07:23:07', 3, '<!-- tpl review/preview.html begin -->\r\n{include file="header/page.html"}\r\n{include file="file:common/errmsg.html"}\r\n\r\n<h2>Rating / Review preview</h2>\r\n<p>Please verify the contents of your review before saving</p>\r\n<div class="form">\r\n<div class="label">By:</div> {if $name}{$name|escape:"htmlall"}{else}\r\nPosted anonymously\r\n{/if}<br />\r\n\r\n{if $city || $state || $country}\r\n<div class="label">From:</div>\r\n{$city|escape:"htmlall"} {$state|escape:"htmlall"} {$country|escape:"htmlall"}<br />\r\n{/if}\r\n\r\n<div class="label">Title:</div> \r\n{$title|escape:"htmlall"}<br />\r\n\r\n<div class="label">{$reviewunits|escape:"htmlall"}:</div>\r\n{$rating|escape:"htmlall"} <br />\r\n\r\n{if $review}\r\n\r\n<h3>Comments: </h3>\r\n<blockquote>\r\n{$review|escape:"htmlall"|nl2br}\r\n</blockquote>\r\n{/if}\r\n</div>\r\n<div class="button">\r\n<form method="POST" action="{$donewaction}">\r\n{include file="file:review/newformcache.html"}\r\n<input type="submit" name="submit" value="Save this review" />\r\n</form>\r\n\r\n<form method="POST" action="{$doeditaction}">\r\n{include file="file:review/newformcache.html"}\r\n<input type="submit" name="submit" value="Edit review further" />\r\n</form>\r\n</div>\r\n\r\n{include file="header/pagefooter.html"}\r\n\r\n\r\n<!-- tpl review/preview.html end -->\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (8, '2005-04-14 07:23:08', 4, '<!-- tpl review/reviewdone.html begin -->\r\n{include file="header/page.html"}\r\n\r\n<h2>Rating Submitted</h2>\r\n\r\n<p>Thank you.  Your product rating has been successfully submitted.\r\n{if $status == \'queued\'}It has been queued for review by our staff and should be publically available within the next two business days.\r\n{elseif $status == \'published\'}It is now visible along side other visitor submitted reviews{/if}\r\n</p>\r\n{include file="header/pagefooter.html"}\r\n\r\n<!-- tpl review/reviewdone.html end -->\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (9, '2005-04-14 07:23:09', 11, '\r\n{include file="review/popupfunc.js"}\r\n\r\n<p><a href="#" onclick="createNewReviewWindow(\'{$newhref}\')">No rating yet... Be the first to rate this product!</a></p>\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (10, '2005-04-14 07:23:10', 7, '<!-- tpl review/summary-item.html begin -->\r\n<tr class="head">\r\n	<td class="title">\r\n	{if $review.review}\r\n		<a href="{$review.href}">{$review.title|truncate:36:"..."|escape:"htmlall"}</a>\r\n	{else}\r\n		{$review.title|truncate:36:"..."|escape:"htmlall"}\r\n	{/if}\r\n	</td>\r\n	<td nowrap="nowrap">{$review.created|date_format}</td>\r\n	<td>{$review.name|truncate:20:"..."|escape:"htmlall"}</td>\r\n	<td>{$review.city|truncate:20:"..."|escape:"htmlall"} {$review.state} {$review.country}</td>\r\n	<td><div class="feedbackBG"><img src="/images/pixel.gif" class="feedback" height="13" width="{$review.ratingwidth}" border="0" /></div></td>\r\n</tr>\r\n{if $review.review}\r\n<tr>\r\n	<td colspan="5" class="review">\r\n		<blockquote>\r\n			{$review.review|truncate:160:"..."|escape:"htmlall"} <a href="{$review.href}">more...</a>\r\n		</blockquote>\r\n	</td>\r\n</tr>\r\n{/if}\r\n<!-- tpl review/summary-item.html end -->\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (11, '2005-04-14 07:23:11', 6, '<!-- tpl review/summary.html begin -->\r\n{include file="header/page.html"}\r\n{include file="review/popupfunc.js"}\r\n\r\n<h2>{if $product.name}{$product.name|truncate:30:"...":true|escape:"htmlall"} reviews{else}Reviews{/if}</h2>\r\n{if $product.numratings}\r\n<div class="feedbackBG"><img src="/images/pixel.gif" class="feedback" height="13" width="{$product.ratingwidth}" border="0" /></div>\r\n<p>Global Rating: {$product.avgrating|string_format:"%.2f"} from \r\n  	<a href="{$fullhref}">{$product.numratings} reviews</a></p>\r\n  {else}\r\n  {/if}\r\n<p><a href="{$fullhref}">See all reviews</a><br />\r\n	<a href="#" onclick="createNewReviewWindow(\'{$newhref}\')">Add your review of this product</a>\r\n</p>\r\n\r\n<table class="review">\r\n{foreach item=review from=$reviews}\r\n  {include file="review/summary-item.html"}\r\n{/foreach}\r\n</table>\r\n<!-- tpl review/summary.html end -->\r\n', 'Default', 'enabled');
INSERT INTO prime_tplcontent VALUES (12, '2005-04-14 07:23:45', 7, '<!-- tpl review/summary-item.html begin -->\r\n<tr class="head">\r\n	<td class="title">\r\n	{if $review.review}\r\n		<a href="{$review.href}">{$review.title|truncate:7:"..."|escape:"htmlall"}</a>\r\n	{else}\r\n		{$review.title|truncate:6:"..."|escape:"htmlall"}\r\n	{/if}\r\n	</td>\r\n	<td nowrap="nowrap">{$review.created|date_format}</td>\r\n	<td>{$review.name|truncate:6:"..."|escape:"htmlall"}</td>\r\n	<td>{$review.city|truncate:6:"..."|escape:"htmlall"} {$review.state} {$review.country}</td>\r\n	<td><div class="feedbackBG"><img src="/images/pixel.gif" class="feedback" height="13" width="{$review.ratingwidth}" border="0" /></div></td>\r\n</tr>\r\n{if $review.review}\r\n<tr>\r\n	<td colspan="5" class="review">\r\n		<blockquote>\r\n			{$review.review|truncate:16:"..."|escape:"htmlall"} <a href="{$review.href}">more...</a>\r\n		</blockquote>\r\n	</td>\r\n</tr>\r\n{/if}\r\n<!-- tpl review/summary-item.html end -->\r\n', 'Scrunch', 'disabled');
INSERT INTO prime_tplcontent VALUES (13, '2005-04-14 07:25:42', 9, '<!-- tpl header/pagefooter.html begin -->\r\n\r\n<p align="center"><b>Copyright (C) 2005, ME.  All rights reserved, you shouldn\'t even be reading this!</b></p>\r\n</body>\r\n</html>\r\n', 'Copyright', 'disabled');

