CREATE TABLE vss_basket (  id int(11) NOT NULL auto_increment,  session_id varchar(125) default NULL,  product_name varchar(125) default NULL,  quantity mediumint(9) default NULL,  media_id int(11) default NULL,  add_date varchar(10) default NULL,  PRIMARY KEY  (id) ) TYPE=MyISAM
CREATE TABLE vss_category ( id int(11) NOT NULL auto_increment, sys_name varchar(128) default NULL, dis_name varchar(255) default NULL,path varchar(255) default NULL,parent_name varchar(128) default NULL,parent_path varchar(255) default NULL,description text,icon varchar(128) default NULL,size float default '0',last_modified varchar(10) default NULL, media int(11) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY path (path)) TYPE=MyISAM
CREATE TABLE vss_file_type ( id mediumint(9) NOT NULL auto_increment,ext varchar(10) default NULL,code text,PRIMARY KEY  (id)) TYPE=MyISAM
INSERT INTO vss_file_type VALUES (1, 'gif', '<img src="[FILENAME]" border="0">')
INSERT INTO vss_file_type VALUES (2, 'jpg', '<img src="[FILENAME]" border="0">')
INSERT INTO vss_file_type VALUES (3, 'au', '<EMBED src="[FILENAME]" type="audio/au" hidden=true autostart=true loop=true height=1 width=1> </EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble hearing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (4, 'avi', '<EMBED SRC="[FILENAME]" border="0" WIDTH=320 HEIGHT=240 type="application/x-mplayer2"></EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble viewing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (5, 'aif', '<EMBED src="[FILENAME]" type="audio/aiff" hidden=true autostart=true loop=true height=1 width=1> </EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble hearing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (6, 'htm', '[FILENAME]')
INSERT INTO vss_file_type VALUES (7, 'html', '[FILENAME]')
INSERT INTO vss_file_type VALUES (8, 'mid', '<EMBED src="[FILENAME]" type="audio/midi" hidden=true autostart=true loop=true height=1 width=1> </EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble hearing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (9, 'mp3', '<EMBED src="[FILENAME]" type="audio/mp3" hidden=true autostart=true loop=true height=1 width=1> </EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble hearing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (10, 'mpg', '<EMBED SRC="[FILENAME]" border="0" WIDTH=320 HEIGHT=240 type="application/x-mplayer2"></EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble viewing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (11, 'mov', '<embed controller="true" WIDTH=320 HEIGHT=280 target="myself" src="[FILENAME]" border="0" pluginspage="http://www.apple.com/quicktime/download/indext.html"></EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble viewing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (12, 'png', '<img src="[FILENAME]" border="0">')
INSERT INTO vss_file_type VALUES (13, 'ra', '[FILENAME]')
INSERT INTO vss_file_type VALUES (14, 'ram', '[FILENAME]')
INSERT INTO vss_file_type VALUES (15, 'rar', '[FILENAME]')
INSERT INTO vss_file_type VALUES (16, 'swf', '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,2,0" <WIDTH=400> <HEIGHT=400> ><param name=movie value="[FILENAME]"><param name=id value="3dCube"><param name=quality value=high><param name=play value=true><param name=scale value=showall><param name=loop value=true><param name=menu value=true><embed src="[FILENAME]" name="shockwaveflash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" <WIDTH=300> <HEIGHT=300> play=true loop=true quality=high></embed></object><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble viewing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (17, 'wav', '<EMBED src="[FILENAME]" type="audio/wav" hidden=true autostart=true loop=true height=1 width=1> </EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble hearing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
INSERT INTO vss_file_type VALUES (18, 'zip', '[FILENAME]')
INSERT INTO vss_file_type VALUES (20, 'wma', '<EMBED src="[FILENAME]" type="<EMBED SRC="[FILENAME]" border="0" WIDTH=320 HEIGHT=240 type="application/x-mplayer2"></EMBED><table border=0 cellspacing=0 cellpadding=3><tr><td> </td><td align=center><font face="Verdana,Arial,Helvetica" size=1>Having trouble viewing this file?</font><br><font face="Verdana,Arial,Helvetica" size=2><a href="[FILENAME]"><b>Click here to download it!</b></a></font></td></tr></table>')
CREATE TABLE vss_instant_download (id int(11) NOT NULL default '0',dbname varchar(125) NOT NULL default '', file_name varchar(125) NOT NULL default '',file_path varchar(255) NOT NULL default '') TYPE=MyISAM
CREATE TABLE vss_lightbox ( media_id int(11) default NULL, session_id varchar(125) default NULL, ipaddress varchar(16) default NULL, add_date varchar(10) default NULL) TYPE=MyISAM
CREATE TABLE vss_media (id int(11) NOT NULL auto_increment, sys_name varchar(128) default NULL, dis_name varchar(255) default NULL, description text, file_path varchar(255) default NULL, folder_name varchar(125) default NULL, folder_path varchar(255) default NULL, author varchar(128) default NULL, copyright varchar(255) default NULL, size varchar(10) default NULL, hit int(11) NOT NULL default '0', vote_number varchar(10) default NULL, vote_rate varchar(10) default NULL, last_modified varchar(10) default NULL, watermark char(1) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY file_path (file_path) ) TYPE=MyISAM
CREATE TABLE vss_member_extra ( username varchar(30) NOT NULL default '', firstname varchar(255) default NULL, lastname varchar(255) default NULL, address text, city varchar(255) default NULL, state varchar(255) default NULL, zip varchar(255) default NULL, PRIMARY KEY  (username) ) TYPE=MyISAM
CREATE TABLE vss_member_pro ( id int(11) NOT NULL auto_increment, dbname varchar(30) default NULL, type varchar(10) default NULL, size varchar(5) default NULL, maxsize varchar(5) default NULL, defaultval text, active char(1) default '1', required char(1) default '1', prompmss text, checkerr varchar(128) default NULL, fieldindex tinyint(4) NOT NULL default '0', errormss text, PRIMARY KEY  (id)) TYPE=MyISAM
INSERT INTO vss_member_pro VALUES (1, 'firstname', 'TEXT', '', '', '', '1', '1', 'First Name', '`~!@#$%^&*()-_+={}|\\;?/<>', 1, 'First Name Error')
INSERT INTO vss_member_pro VALUES (2, 'lastname', 'TEXT', '', '', '', '1', '1', 'Last Name', '`~!@#$%^&*()-_+={}|\\;?/<>', 2, 'Last Name Error')
INSERT INTO vss_member_pro VALUES (3, 'address', 'TEXTAREA', '30', '3', '', '1', '1', 'Address', '`~!@#$%^&*()-_+={}|\\;?/<>', 3, 'Address Error')
INSERT INTO vss_member_pro VALUES (4, 'city', 'TEXT', '', '', '', '1', '1', 'City', '`~!@#$%^&*()-_+={}|\\;?/<>', 4, 'City Error')
INSERT INTO vss_member_pro VALUES (5, 'state', 'SELECT', '', '', 'AK;AL;AR;AZ;CA;CO;CT;DC;DE;FL;GA;HI;IA;ID;IL;IN;KS;KY;LA;MA;MD;ME;MI;MN;MO;MS;MT;NC;ND;NE;NH;NJ;NM;NV;NY;OH;OK;OR;PA;RI;SC;SD;TN;TX;UT;VA;VT;WA;WI;WV;WY;AB;BC;MB;NB;NL;NS;NT;NU;ON;PE;QC;SK;YT;', '1', '1', 'State/Province', '`~!@#$%^&*()-_+={}|\\;?/<>', 5, 'State error')
INSERT INTO vss_member_pro VALUES (6, 'zip', 'TEXT', '6', '10', '', '1', '1', 'Zip/Postal Code', '`~!@#$%^&*()-_+={}|\\;?/<>', 6, 'Zip error')
CREATE TABLE vss_members ( username varchar(30) NOT NULL default '', password varchar(30) default NULL, email varchar(125) default NULL, activate_code varchar(10) default NULL, last_visit varchar(10) default NULL, date_join varchar(10) default NULL, ipaddress varchar(16) default NULL, user_group varchar(10) NOT NULL default 'user', status char(1) NOT NULL default '0', PRIMARY KEY  (username) ) TYPE=MyISAM
INSERT INTO vss_members VALUES ('admin', 'admin', 'sales@lightboxphoto.com', NULL, NULL, NULL, NULL, 'user', '1')
CREATE TABLE vss_order_info ( order_id varchar(10) NOT NULL default '', username varchar(30) default NULL, tax1 float NOT NULL default '0', tax2 float NOT NULL default '0', tax3 float NOT NULL default '0', tax4 float NOT NULL default '0', tax5 float NOT NULL default '0', total_tax float NOT NULL default '0', shipping float NOT NULL default '0', sub_total float NOT NULL default '0', total float NOT NULL default '0', add_date varchar(10) NOT NULL default '', status char(1) NOT NULL default '0', PRIMARY KEY  (order_id) ) TYPE=MyISAM
CREATE TABLE vss_orders ( id int(11) NOT NULL auto_increment, username varchar(30) default NULL, order_id varchar(10) default NULL, product_name varchar(125) default NULL, quantity mediumint(9) default NULL, media_id int(11) default NULL, status char(1) NOT NULL default '0', PRIMARY KEY  (id) ) TYPE=MyISAM
CREATE TABLE vss_product_tax ( id mediumint(9) NOT NULL auto_increment, label varchar(255) default NULL, value varchar(255) default NULL, tax1 float NOT NULL default '0', tax2 float NOT NULL default '0', tax3 float NOT NULL default '0', tax4 float NOT NULL default '0', tax5 float NOT NULL default '0', PRIMARY KEY  (id) ) TYPE=MyISAM
CREATE TABLE vss_product_type ( id int(11) NOT NULL default '0', shipping float default NULL, addition_shipping float NOT NULL default '0', PRIMARY KEY  (id) ) TYPE=MyISAM
CREATE TABLE vss_product_type_pro ( dbname varchar(30) NOT NULL default '', label varchar(255) default NULL, position mediumint(9) NOT NULL default '1', PRIMARY KEY  (dbname)) TYPE=MyISAM