.

Prv8 Shell
Server : Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4
System : Linux server.jackjohnson.com 2.6.32-279.5.2.el6.x86_64 #1 SMP Fri Aug 24 01:07:11 UTC 2012 x86_64
User : jackjohn ( 502)
PHP Version : 5.3.17
Disable Function : NONE
Directory : /home/jackjohn/public_html/cgi-bin/shopsite-data/
Upload File :
Current File : /home/jackjohn/public_html/cgi-bin/shopsite-data/shopsite_db.default
SQLite format 3@  g€dg-ùˆâvûöñìçâ	™
'Œ3x,£Jîr7zOtableDBInfoDBInfoCREATE TABLE DBInfo ( 
DBIID INTEGER PRIMARY KEY, 
DBILastChanged, 
DBIAgent,
DBIName,
DBIValue )Z'}indexpi_gu_idxPurchaseItemsCREATE INDEX pi_gu_idx ON PurchaseItems (ss_ProductGUID)W'windexpi_ci_idxPurchaseItemsCREATE INDEX pi_ci_idx ON PurchaseItems (CustomerID) ƒ''…KtablePurchaseItemsPurchaseItemsCREATE TABLE PurchaseItems ( 
PurchaseItemsID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
CustomerID INTEGER,
PurchaseID INTEGER, 
ItemID, 
Quantity, 
SKU,
Price, 
Total,
Weight,
Taxable,
ProductType,
FiniteOptions,
FreeformOptions,
ss_DobaItemID,
ss_ProductsID INTEGER,
ss_ProductGUID,
ss_SelectedMenu,
ss_PageOrderedFrom,
ss_FromWishList,
ss_UUID
 )Jiindexp_ci_idxPurchaseCREATE INDEX p_ci_idx ON Purchase (CustomerID)‡
atablePurchasePurchaseCREATE TABLE Purchase ( 
PurchaseID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
Status,
Notes,
CustomerID INTEGER, 
GroupID INTEGER, 
DeletedByCustomer,
OrderNum UNIQUE, 
OrderDate, 
DiscountTotal, 
ProductTotal,
Surcharge,
Subtotal, 
ShippingCharge, 
ShipName,
TaxTotal,
TaxName,
TaxRate,
GrandTotal,
FamilyName, 
GivenName, 
OtherName, 
NamePrefix, 
NameSuffix, 
Email,
Phone, 
Company,
Addr0, 
Addr1, 
Addr2, 
Locality, 
Region, 
pcode, 
Country,
ShippingAddressUsed,
ShipFamilyName, 
ShipGivenName, 
ShipOtherName, 
ShipNamePrefix, 
ShipNameSuffix, 
ShipPhone, 
ShipCompany,
ShipAddr0, 
ShipAddr1, 
ShipAddr2, 
ShipLocality, 
ShipRegion, 
Shippcode, 
ShipCountry,
OrderingInstructions,
Comments,
Type, 
Field01, 
Field02, 
Field03, 
Field04,
Field04_1,
Field04_2,
ss_buySAFEText,
ss_buySAFECartID,
ss_buySAFEAmount,
ss_DobaShipping,
ss_VATID,
ss_TrackingLink DEFAULT "")/Cindexsqlite_autoindex_Purchase_1PurchaseW'windexpm_ci_idxPaymentMethod
CREATE INDEX pm_ci_idx ON PaymentMethod (CustomerID) ‚
''ƒStablePaymentMethodPaymentMethodCREATE TABLE PaymentMethod ( 
PaymentMethodID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
CustomerID INTEGER, 
BillToAddress, 
Type, 
DeletedByCustomer,
DisplayName,
Field01, 
Field02, 
Field03, 
Field04,
Field04_1,
Field04_2 )	etableCustGroupCustGroup
CREATE TABLE CustGroup ( 
GroupID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
GroupName UNIQUE, 
GroupNote )1
Eindexsqlite_autoindex_CustGroup_1CustGroup@]indexd_gi_idxDeal	CREATE INDEX d_gi_idx ON Deal (GroupID) 1‚EtableDealDealCREATE TABLE Deal ( 
DealID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
GroupID, 
ProductGroupID, 
DealType, 
DealNum, 
CouponID, 
CouponName, 
CouponSlot )…‰WtableCustomerCustomerCREATE TABLE Customer ( 
CustomerID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
FamilyName, 
GivenName, 
OtherName, 
NamePrefix, 
NameSuffix, 
EmailFormat, 
Email UNIQUE, 
Password, 
AccountStatus, 
FailedAttempts, 
ChallengePhraseID, 
ChallengePhraseAnswer, 
ChallengeCount, 
ChallengeTime, 
ReentryURL, 
LastLogin, 
Handle UNIQUE, 
PreferredPaymentMethod, 
PreferredBillTo, 
PreferredShipTo, 
SavePayment, 
GroupID, 
DateRegistered, 
DateLastOrder, 
LastOrderTotal, 
TotalAmount, 
NumberOfPurchases,
FB_UID,
TaxExempt,
TaxExemptType DEFAULT "other",
TaxExemptCert,
TaxExemptCertExpire,
Company DEFAULT "",
sbid)/Cindexsqlite_autoindex_Customer_2Customer/Cindexsqlite_autoindex_Customer_1CustomerD_indexa_ph_idxAddressCREATE INDEX a_ph_idx ON Address (Phone) Iiindexa_ci_idxAddressCREATE INDEX a_ci_idx ON Address (CustomerID) ‚-„1tableAddressAddressCREATE TABLE Address ( 
AddressID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
CustomerID INTEGER, 
FamilyName, 
GivenName, 
OtherName, 
NamePrefix, 
NameSuffix, 
DisplayName,
Type, 
Email,
Phone, 
Company,
Addr0, 
Addr1, 
Addr2, 
Locality, 
Reg`cJQ<>.4'








òò<none>
öö		<none>








¹ß¹$/!sqlite_tables.sqlCurVersion8.1/sqlite_tables.sqlCreation

7îÐ…?P
Õ
œ
Z	™
'Œ3x,£Jîrm‚33ƒ+tabless_RedeemedGiftCertss_RedeemedGiftCertCREATE TABLE ss_RedeemedGiftCert ( 
ss_RedeemedGiftCertID INTEGER PRIMARY KEY, 
ss_LastChanged, 
ss_Agent, 
ss_CustomerID INTEGER,
ss_PurchaseID INTEGER,
ss_GiftCertID INTEGER,
ss_AmountLeft,
ss_AmountUsed )zOtableDBInfoDBInfoCREATE TABLE DBInfo ( 
DBIID INTEGER PRIMARY KEY, 
DBILastChanged, 
DBIAgent,
DBIName,
DBIValue )Z'}indexpi_gu_idxPurchaseItemsCREATE INDEX pi_gu_idx ON PurchaseItems (ss_ProductGUID)W'windexpi_ci_idxPurchaseItemsCREATE INDEX pi_ci_idx ON PurchaseItems (CustomerID) ƒ''…KtablePurchaseItemsPurchaseItemsCREATE TABLE PurchaseItems ( 
PurchaseItemsID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
CustomerID INTEGER,
PurchaseID INTEGER, 
ItemID, 
Quantity, 
SKU,
Price, 
Total,
Weight,
Taxable,
ProductType,
FiniteOptions,
FreeformOptions,
ss_DobaItemID,
ss_ProductsID INTEGER,
ss_ProductGUID,
ss_SelectedMenu,
ss_PageOrderedFrom,
ss_FromWishList,
ss_UUID
 )Jiindexp_ci_idxPurchaseCREATE INDEX p_ci_idx ON Purchase (CustomerID)‡
atablePurchasePurchaseCREATE TABLE Purchase ( 
PurchaseID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
Status,
Notes,
CustomerID INTEGER, 
GroupID INTEGER, 
DeletedByCustomer,
OrderNum UNIQUE, 
OrderDate, 
DiscountTotal, 
ProductTotal,
Surcharge,
Subtotal, 
ShippingCharge, 
ShipName,
TaxTotal,
TaxName,
TaxRate,
GrandTotal,
FamilyName, 
GivenName, 
OtherName, 
NamePrefix, 
NameSuffix, 
Email,
Phone, 
Company,
Addr0, 
Addr1, 
Addr2, 
Locality, 
Region, 
pcode, 
Country,
ShippingAddressUsed,
ShipFamilyName, 
ShipGivenName, 
ShipOtherName, 
ShipNamePrefix, 
ShipNameSuffix, 
ShipPhone, 
ShipCompany,
ShipAddr0, 
ShipAddr1, 
ShipAddr2, 
ShipLocality, 
ShipRegion, 
Shippcode, 
ShipCountry,
OrderingInstructions,
Comments,
Type, 
Field01, 
Field02, 
Field03, 
Field04,
Field04_1,
Field04_2,
ss_buySAFEText,
ss_buySAFECartID,
ss_buySAFEAmount,
ss_DobaShipping,
ss_VATID,
ss_TrackingLink DEFAULT "")/Cindexsqlite_autoindex_Purchase_1PurchaseW'windexpm_ci_idxPaymentMethod
CREATE INDEX pm_ci_idx ON PaymentMethod (CustomerID) ‚
''ƒStablePaymentMethodPaymentMethodCREATE TABLE PaymentMethod ( 
PaymentMethodID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
CustomerID INTEGER, 
BillToAddress, 
Type, 
DeletedByCustomer,
DisplayName,
Field01, 
Field02, 
Field03, 
Field04,
Field04_1,
Field04_2 )	etableCustGroupCustGroup
CREATE TABLE CustGroup ( 
GroupID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
GroupName UNIQUE, 
GroupNote )1
Eindexsqlite_autoindex_CustGroup_1CustGroup@]indexd_gi_idxDeal	CREATE INDEX d_gi_idx ON Deal (GroupID) 1‚EtableDealDealCREATE TABLE Deal ( 
DealID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
GroupID, 
ProductGroupID, 
DealType, 
DealNum, 
CouponID, 
CouponName, 
CouponSlot )…‰WtableCustomerCustomerCREATE TABLE Customer ( 
CustomerID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
FamilyName, 
GivenName, 
OtherName, 
NamePrefix, 
NameSuffix, 
EmailFormat, 
Email UNIQUE, 
Password, 
AccountStatus, 
FailedAttempts, 
ChallengePhraseID, 
ChallengePhraseAnswer, 
ChallengeCount, 
ChallengeTime, 
ReentryURL, 
LastLogin, 
Handle UNIQUE, 
PreferredPaymentMethod, 
PreferredBillTo, 
PreferredShipTo, 
SavePayment, 
GroupID, 
DateRegistered, 
DateLastOrder, 
LastOrderTotal, 
TotalAmount, 
NumberOfPurchases,
FB_UID,
TaxExempt,
TaxExemptType DEFAULT "other",
TaxExemptCert,
TaxExemptCertExpire,
Company DEFAULT "",
sbid)/Cindexsqlite_autoindex_Customer_2Customer/Cindexsqlite_autoindex_Customer_1CustomerD_indexa_ph_idxAddressCREATE INDEX a_ph_idx ON Address (Phone) Iiindexa_ci_idxAddressCREATE INDEX a_ci_idx ON Address (CustomerID) ‚-„1tableAddressAddressCREATE TABLE Address ( 
AddressID INTEGER PRIMARY KEY, 
LastChanged, 
Agent, 
CustomerID INTEGER, 
FamilyName, 
GivenName, 
OtherName, 
NamePrefix, 
NameSuffix, 
DisplayName,
Type, 
Email,
Phone, 
Company,
Addr0, 
Addr1, 
Addr2, 
Locality, 
Region, 
pcode, 
Country,
VATID )

SìÉÄ[	Wð<Õ	 qm:%ìò¿â«
Î
h
ÏSS8%##‚7tabless_Categoryss_Category(CREATE TABLE ss_Category (
ss_CategoryID INTEGER PRIMARY KEY,
ss_CategoryName UNIQUE,
ss_CategoryDescription,
ss_Created,
ss_LastChanged, 
ss_Agent )5&I#indexsqlite_autoindex_ss_Category_1ss_Category)¿cindexc_rw_idxss_Reward'CREATE INDEX c_rw_idx ON ss_Reward (ss_RewardQualifyingCategoryID) ƒP!†otabless_Rewardss_Reward$CREATE TABLE ss_Reward (
ss_RewardID INTEGER PRIMARY KEY,
ss_RewardName UNIQUE,
ss_RewardDescription,
ss_RewardQualifyingCategoryID UNIQUE,
ss_RewardCategoryID,
ss_RewardQualifyingQuantity,
ss_RewardProductString,
ss_RewardStatus,
ss_RewardExpiresFlag,
ss_RewardExpiresDate,
ss_RewardMonth,
ss_RewardDay,
ss_RewardYear,
ss_RewardType,
ss_RewardUrlType,
ss_RewardUrlText,
ss_RewardShopSitePage,
ss_Created,
ss_LastChanged, 
ss_Agent )1#Eindexsqlite_autoindex_ss_Reward_2ss_Reward&1"Eindexsqlite_autoindex_ss_Reward_1ss_Reward%J gindexc_na_idxss_Coupon#CREATE INDEX c_na_idx ON ss_Coupon (ss_Name) ƒF†[tabless_Couponss_Coupon CREATE TABLE ss_Coupon (
ss_CouponID INTEGER PRIMARY KEY,
ss_CouponType,
ss_Name UNIQUE,
ss_AlternateCode,
ss_CpId UNIQUE,
ss_Days,
ss_DateTime,
ss_AmountType,
ss_AMPM,
ss_PercentValue,
ss_Amount,
ss_MinimumRequiredAmount,
ss_MinimumPurchaseTypeA,
ss_Month,
ss_Day,
ss_Year,
ss_ReturnURL,
ss_ProductList,
ss_LimitProduct,
ss_LowestPrice,
ss_ExcludedProducts,
ss_OneTime,
ss_OrderNum,
ss_Created,
ss_LastChanged, 
ss_Agent )1Eindexsqlite_autoindex_ss_Coupon_2ss_Coupon"1Eindexsqlite_autoindex_ss_Coupon_1ss_Coupon!g!1	indexghi_gi_idxss_GiftCertHistoryCREATE INDEX ghi_gi_idx ON ss_GiftCertHistory (ss_GiftCertID) I11‚=tabless_GiftCertHistoryss_GiftCertHistoryCREATE TABLE ss_GiftCertHistory ( 
ss_GiftCertificateHistoryID INTEGER PRIMARY KEY, 
ss_Created, 
ss_Agent, 
ss_GiftCertID,
ss_OrderNum,
ss_AmountUsed )e!+indexgin_gi_idxss_GiftCertInfoCREATE INDEX gin_gi_idx ON ss_GiftCertInfo (ss_GiftCertInfoID) 1++‚tabless_GiftCertInfoss_GiftCertInfoCREATE TABLE ss_GiftCertInfo (
ss_GiftCertInfoID INTEGER PRIMARY KEY,
ss_LastChanged, 
ss_Agent, 
ss_ToText,
ss_FromText,
ss_Message )e1indexgi_gi_idxss_GiftCertificateCREATE INDEX gi_gi_idx ON ss_GiftCertificate (ss_GiftCertID) ƒ411†tabless_GiftCertificatess_GiftCertificateCREATE TABLE ss_GiftCertificate ( 
ss_GiftCertificateID INTEGER PRIMARY KEY, 
ss_Created, 
ss_LastChanged, 
ss_Agent, 
ss_Type,
ss_GiftCertID UNIQUE,
ss_GiftCertPIN,
ss_FailedAttempts,
ss_Expiration,
ss_ActiveFlag,
ss_LockedFlag,
ss_RecipientEmail,
ss_BuyerEmail,
ss_AddressID,
ss_GiftCertInfoID,
ss_RecipientCustomerID,
ss_CreatedOrderNum,
ss_CreatedAmount,
ss_CurrentAmount,
ss_Stuff )CW1indexsqlite_autoindex_ss_GiftCertificate_1ss_GiftCertificate
Eg3	indexss_re_idxss_RedeemedGiftCertCREATE INDEX ss_re_idx ON ss_RedeemedGiftCert (ss_PurchaseID) ‚33ƒ+tabless_RedeemedGiftCertss_RedeemedGiftCertCREATE TABLE ss_RedeemedGiftCert ( 
ss_RedeemedGiftCertID INTEGER PRIMARY KEY, 
ss_LastChanged, 
ss_Agent, 
ss_CustomerID INTEGER,
ss_PurchaseID INTEGER,
ss_GiftCertID INTEGER,
ss_AmountLeft,
ss_AmountUsed )zOtableDBInfoDBInfoCREATE TABLE DBInfo ( 
DBIID INTEGER PRIMARY KEY, 
DBILastChanged, 
DBIAgent,
DBIName,
DBIValue )‰'}indexpi_gu_idxPurchaseItemsd(+
indexc_nv_idxss_CategoryNode+CREATE INDEX c_nv_idx ON ss_CategoryNode (ss_CategoryNodeValue) Z'++‚ktabless_CategoryNodess_CategoryNode*CREATE TABLE ss_CategoryNode (
ss_CategoryNodeID INTEGER PRIMARY KEY,
ss_CategoryID INTEGER,
ss_CategoryNodeType,
ss_CategoryNodeValue,
ss_Created,
ss_LastChanged, 
ss_Agent )5&I#indexsqlite_autoindex_ss_Category_1ss_Category)8%##‚7tabless_Categoryss_Category(CREATE TABLE ss_Category (
ss_CategoryID INTEGER PRIMARY KEY,
ss_CategoryName UNIQUE,
ss_CategoryDescription,
ss_Created,
ss_LastChanged, 
ss_Agent )a$indexc_rw_idxss_Reward'CREATE INDEX c_rw_idx ON ss_Reward (ss_RewardQualifyingCategoryID) 





















f
ëšGö¨Èn5!Qárë´´56I#indexsqlite_autoindex_ss_Products_1ss_Products:4!9;indexpsp_pc_idxss_ProductToSubProduct8CREATE INDEX psp_pc_idx ON ss_ProductToSubProduct (ss_ParentID,ss_ChildID,ss_SortOrder)m3#9indexpsp_cid_idxss_ProductToSubProduct7CREATE INDEX psp_cid_idx ON ss_ProductToSubProduct (ss_ChildID)n2#9
indexpsp_pid_idxss_ProductToSubProduct6CREATE INDEX psp_pid_idx ON ss_ProductToSubProduct (ss_ParentID)a199‚]tabless_ProductToSubProductss_ProductToSubProduct5CREATE TABLE ss_ProductToSubProduct (
ss_ProductToSubProductID INTEGER PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_ParentID,
ss_ChildID,
ss_SortOrder NUMERIC)i/11‚}tabless_DigitalDownloadss_DigitalDownload3CREATE TABLE ss_DigitalDownload (
ss_UUID PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_OrderNum,
ss_FileName,
ss_TimeStamp,
ss_Expiration,
ss_DownloadAttempts,
ss_RetryLimit )C0W1indexsqlite_autoindex_ss_DigitalDownload_1ss_DigitalDownload4
X.+windexc_op_idxss_OrderProduct2CREATE INDEX c_op_idx ON ss_OrderProduct (ss_OrderID)ƒ]-++†qtabless_OrderProductss_OrderProduct1CREATE TABLE ss_OrderProduct (
ss_OrderProductID INTEGER PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_OrderID,
ss_Name,
ss_Price,
ss_Quantity,
ss_SubTotal,
ss_FiniteOptions,
ss_FreeformOptions,
ss_SKU,
ss_ProductType,
ss_TotalItemWeight,
ss_Dimension,
ss_QBImport,
ss_Taxable,
ss_ProductTypeData,
ss_DobaItemID,
ss_Graphic,
ss_ProductsID,
ss_ProductGUID,
ss_FromWishList,
ss_TaxRate,
ss_MerchantField,
ss_DisabledForCoupons )L,kindexc_oid_idxss_Order0CREATE INDEX c_oid_idx ON ss_Order (ss_OrderID)O+!oindexc_onum_idxss_Order/CREATE INDEX c_onum_idx ON ss_Order (ss_OrderNum)‰J*’gtabless_Orderss_Order-CREATE TABLE ss_Order (
ss_OrderID INTEGER PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_OrderStatus,
ss_Date,
ss_OrderNum,
ss_Name,
ss_Company,
ss_Email,
ss_Address,
ss_Address2,
ss_City,
ss_State,
ss_Zip,
ss_Country,
ss_Phone,
ss_ShipName,
ss_ShipCompany,
ss_ShipAddress,
ss_ShipAddress2,
ss_ShipCity,
ss_ShipState,
ss_ShipZip,
ss_ShipCountry,
ss_ShipPhone,
ss_PayType,
ss_pay1,
ss_pay2,
ss_pay3,
ss_pay4,
ss_ShipOn,
ss_OrderInst,
ss_Comments,
ss_ProductTotal,
ss_TaxTotal,
ss_ShippingTotal,
ss_GrandTotal,
ss_NumItems, 
ss_Viewed,
ss_Shipping,
ss_Discount,
ss_Surcharge,
ss_RefName,
ss_AllTotals,
ss_Coupons,
ss_OrderInfo,
ss_PaymentGateway,
ss_EmailList,
ss_IpHostname,
ss_OrderWeight,
ss_CustomFields,
ss_Title,
ss_First,
ss_Middle,
ss_Last,
ss_Suffix,
ss_ShipTitle,
ss_ShipFirst,
ss_ShipMiddle,
ss_ShipLast,
ss_ShipSuffix,
ss_TaxRate,
ss_TaxName,
ss_CRID,
ss_GiftCert,
ss_TransID,
ss_Time,
ss_PaymentStatus,
ss_Status2,
ss_OrderDate INTEGER,
ss_buySAFEAmount,
ss_buySAFEText,
ss_buySAFECartID,
ss_DobaShipping,
ss_DobaOrderInfo,
ss_OrderMessage,
ss_VATID,
ss_Notes,
ss_OrderMedium,
ss_PostOrderEmailStatus INTEGER DEFAULT 0,
ss_Log,
ss_TrackingNumber,
ss_Shipper,
ss_RecoveredOrder
)k)33‚}tabless_CrRewardTrackingss_CrRewardTracking,CREATE TABLE ss_CrRewardTracking (
ss_CrRewardTrackingID INTEGER PRIMARY KEY,
ss_CustomerID INTEGER,
ss_RewardID INTEGER,
ss_RewardProductCount,
ss_Created,
ss_LastChanged, 
ss_Agent )˜+
indexc_nv_idxss_CategoryNode+CREATE INDEX c_nv_idx ON ss_CategoryNode (ss_CategoryNodeValue) Z'++‚ktabless_CategoryNodess_CategoryNode*CREATE TABLE ss_CategoryNode (
ss_CategoryNodeID INTEGER PRIMARY KEY,
ss_CategoryID INTEGER,
ss_CategoryNodeType,
ss_CategoryNodeValue,
ss_Created,
ss_LastChanged, 
ss_Agent )5&I#indexsqlite_autoindex_ss_Category_1ss_Category)8%##‚7tabless_Categoryss_Category(CREATE TABLE ss_Category (
ss_CategoryID INTEGER PRIMARY KEY,
ss_CategoryName UNIQUE,
ss_CategoryDescription,
ss_Created,
ss_LastChanged, 
ss_Agent )a$indexc_rw_idxss_Reward'CREATE INDEX c_rw_idx ON ss_Reward (ss_RewardQualifyingCategoryID) d(+
indexc_nv_idxss_CategoryNode+CREATE INDEX c_nv_idx ON ss_CategoryNode (ss_CategoryNodeValue) 











_ProductField36,
ss_ProductField37,
ss_ProductField38,
ss_ProductField39,
ss_ProductField40,
ss_ProductField41,
ss_ProductField42,
ss_ProductField43,
ss_ProductField44,
ss_ProductField45,
ss_ProductField46,
ss_ProductField47,
ss_ProductField48,
ss_ProductField49,
ss_ProductField50,
ss_ProductField51,
ss_ProductField52,
ss_ProductField53,
ss_ProductField54,
ss_ProductField55,
ss_ProductField56,
ss_ProductField57,
ss_ProductField58,
ss_ProductField59,
ss_ProductField60,
ss_ProductField61,
ss_ProductField62,
ss_ProductField63,
ss_ProductField64,
ss_ProductField65,
ss_ProductField66,
ss_ProductField67,
ss_ProductField68,
ss_ProductField69,
ss_ProductField70,
ss_ProductField71,
ss_ProductField72,
ss_ProductField73,
ss_ProductField74,
ss_ProductField75,
ss_ProductField76,
ss_ProductField77,
ss_ProductField78,
ss_ProductField79,
ss_ProductField80,
ss_ProductField81,
ss_ProductField82,
ss_ProductField83,
ss_ProductField84,
ss_ProductField85,
ss_ProductField86,
ss_ProductField87,
ss_ProductField88,
ss_ProductField89,
ss_ProductField90,
ss_ProductField91,
ss_ProductField92,
ss_ProductField93,
ss_ProductField94,
ss_ProductField95,
ss_ProductField96,
ss_ProductField97,
ss_ProductField98,
ss_ProductField99,
ss_ProductField100,
ss_ProductImageSize,
ss_MoreInfoImageSize,
ss_UseFroogle,
ss_Brand,
ss_Condition,
ss_FroogleProductType,
ss_PQP_Group,
ss_USPSContainer,
ss_FedExContainer,
ss_CrossSell,
ss_DisplayQuantityPricing DEFAULT "checked",
ss_DobaItemID,
ss_DobaWatchListID,
ss_DobaSupplierName,
ss_DobaSupplierNotes,
ss_DobaStock,
ss_DobaWholeSalePrice NUMERIC,
ss_DobaPrePayPrice NUMERIC,
ss_DobaMinAdvPrice NUMERIC,
ss_DobaMSRP NUMERIC,
ss_DobaShipCost NUMERIC,
ss_DobaSupplierDropShip NUMERIC,
ss_DobaLastUpdate,
ss_AvaTaxCode,
ss_SubscriptionProduct,
ss_SubPaymentIntervalUnit,
ss_SubRegularPaymentAmount NUMERIC,
ss_SubEndingPeriod,
ss_SubBillOn,
ss_SubTrialCheckBox,
ss_SubTrialPaymentAmount NUMERIC,
ss_SubTrialPeriods,
ss_SubOneTimeCheckBox,
ss_SubOneTimePaymentAmount NUMERIC,
ss_ProductCrossSell,
ss_GlobalCrossSell,
ss_MoreInfoImage1,
ss_MoreInfoImage2,
ss_MoreInfoImage3,
ss_MoreInfoImage4,
ss_MoreInfoImage5,
ss_MoreInfoImage6,
ss_MoreInfoImage7,
ss_MoreInfoImage8,
ss_MoreInfoImage9,
ss_MoreInfoImage10,
ss_MoreInfoImage11,
ss_MoreInfoImage12,
ss_MoreInfoImage13,
ss_MoreInfoImage14,
ss_MoreInfoImage15,
ss_MoreInfoImage16,
ss_MoreInfoImage17,
ss_MoreInfoImage18,
ss_MoreInfoImage19,
ss_MoreInfoImage20,
ss_MoreInfoImageExtraSize,
ss_GTIN DEFAULT "",
ss_MPN DEFAULT "",
ss_Availability DEFAULT "in stock",
ss_GoogleProductCategory DEFAULT "",
ss_FroogleAgeGroup DEFAULT "",
ss_FroogleGender DEFAULT "",
ss_FroogleUseAdvOrdOpt DEFAULT "unchecked",
ss_FroogleColorCol DEFAULT "",
ss_FroogleSizeCol DEFAULT "",
ss_FroogleMaterialCol DEFAULT "",
ss_FrooglePatternCol DEFAULT "",
ss_ProductDisabled  DEFAULT "",
ss_ProductGUID UNIQUE,
ss_GoogleListAsFreeShipping DEFAULT "unchecked",
ss_ReviewAverage NUMERIC,
ss_ReviewCount INTEGER,
ss_CannotShipVia DEFAULT "",
ss_MerchantProductInstructions DEFAULT "",
ss_CanadaPostContainer,
ss_DisplayAddtoCart DEFAULT "All Pages",
ss_AustraliaPostContainer,
ss_Video DEFAULT "",
ss_ShipDetails DEFAULT "",
ss_Returns DEFAULT "",
ss_Warranty DEFAULT "",
ss_Specifications DEFAULT "",
ss_Materials DEFAULT "",
ss_OneLineAd DEFAULT "",
ss_HowToUse DEFAULT "",
ss_AsSeenInImage,
ss_AsSeenInImageDesc,
ss_GoogleIdentifiersExist DEFAULT "unchecked",
ss_SizeFitRadio DEFAULT "I",
ss_SizeFitImage,
ss_SizeFitImageDesc,
ss_SizeFitText DEFAULT "",
ss_ProductImageDesc,
ss_MoreInfoImageDesc,
ss_MoreInfoImageDesc1,
ss_MoreInfoImageDesc2,
ss_MoreInfoImageDesc3,
ss_MoreInfoImageDesc4,
ss_MoreInfoImageDesc5,
ss_MoreInfoImageDesc6,
ss_MoreInfoImageDesc7,
ss_MoreInfoImageDesc8,
ss_MoreInfoImageDesc9,
ss_MoreInfoImageDesc10,
ss_MoreInfoImageDesc11,
ss_MoreInfoImageDesc12,
ss_MoreInfoImageDesc13,
ss_MoreInfoImageDesc14,
ss_MoreInfoImageDesc15,
ss_MoreInfoImageDesc16,
ss_MoreInfoImageDesc17,
ss_MoreInfoImageDesc18,
ss_MoreInfoImageDesc19,
ss_MoreInfoImageDesc20,
ss_AddToCartImageDesc,
ss_ViewCartImageDesc,
ss_ItemSize,
ss_DisabledForCoupons
)

ã±zÁl§7âã„*ÍrYB!%{indexpl_cid_idxss_PageLinksHCREATE INDEX pl_cid_idx ON ss_PageLinks (ss_CategoryID)[A#%}indexpl_prid_idxss_PageLinksGCREATE INDEX pl_prid_idx ON ss_PageLinks (ss_ProductsID)X@#%windexpl_pgid_idxss_PageLinksFCREATE INDEX pl_pgid_idx ON ss_PageLinks (ss_PagesID)]?!%indexpl_pid_idxss_PageLinksECREATE INDEX pl_pid_idx ON ss_PageLinks (ss_ParentPagesID)|>%%ƒ;tabless_PageLinksss_PageLinksDCREATE TABLE ss_PageLinks (
ss_PageLinksID INTEGER PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_ParentPagesID INTEGER,
ss_PagesID INTEGER,
ss_ProductsID INTEGER,
ss_CategoryID INTEGER,
ss_SortOrder NUMERIC)S=##oindexpr_uuid_idxss_ProductsCCREATE INDEX pr_uuid_idx ON ss_Products (ss_UUID)n</#indexpr_sku_idx_nocasess_ProductsBCREATE INDEX pr_sku_idx_nocase ON ss_Products (ss_SKU COLLATE NOCASE)q;1#indexpr_name_idx_nocasess_ProductsACREATE INDEX pr_name_idx_nocase ON ss_Products (ss_Name COLLATE NOCASE)P:!#kindexpr_sku_idxss_Products@CREATE INDEX pr_sku_idx ON ss_Products (ss_SKU)S9##oindexpr_name_idxss_Products?CREATE INDEX pr_name_idx ON ss_Products (ss_Name)Z8##}indexpr_guid_idxss_Products>CREATE INDEX pr_guid_idx ON ss_Products (ss_ProductGUID)[7%#}indexpr_recid_idxss_Products=CREATE INDEX pr_recid_idx ON ss_Products (ss_ProductsID)56I#indexsqlite_autoindex_ss_Products_1ss_Products:´D5##èOtabless_Productsss_Products9CREATE TABLE ss_Products (
ss_ProductsID INTEGER PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_Status,
ss_Name,
ss_Graphic,
ss_ProductDescription,
ss_SKU,
ss_Price NUMERIC,
ss_SaleAmount NUMERIC,
ss_QuantityPricing,
ss_QtyPriceNumPriceBreaks INTEGER,
ss_QtyPriceBackgroundColor,
ss_QtyPriceCommentColor,
ss_QtyPriceOnSaleColor,
ss_QtyPriceDesc,
ss_VariablePrice,
ss_VariableName,
ss_VariableSKU,
ss_VariableWeight,
ss_Taxable,
ss_TaxCode,
ss_VAT,
ss_ProductType DEFAULT "Tangible",
ss_ProductDownloadLocation,
ss_Weight NUMERIC,
ss_DimensionOptions,
ss_DimensionText,
ss_DimensionSelected,
ss_GroundShipping,
ss_SecondDayShipping,
ss_NextDayShipping,
ss_Shipping3,
ss_Shipping4,
ss_Shipping5,
ss_Shipping6,
ss_Shipping7,
ss_Shipping8,
ss_Shipping9,
ss_ShippingCharge,
ss_NoShippingCharges,
ss_ExtraHandlingCharge NUMERIC,
ss_SearchKeywords,
ss_SearchMakePage,
ss_SearchDestType,
ss_SearchDest,
ss_CategoryID INTEGER,
ss_OptionText,
ss_OptionMenuText,
ss_NewOptionColHeaders,
ss_NewOptionColCnt INTEGER,
ss_AppendOptionSKU,
ss_UseMultiMenus,
ss_SelectDefault,
ss_CustTextEntryBox,
ss_ProductOnPages,
ss_AddToPages,
ss_DisplayMoreInfoPage,
ss_MoreInfoText,
ss_MoreInfoGraphic,
ss_MoreInfoTitle,
ss_MoreInfoMetaKeywords,
ss_MoreInfoMetaDescription,
ss_FileName,
ss_Template,
ss_DisplayName,
ss_DisplaySKU,
ss_DisplayPrice,
ss_DisplayGraphic,
ss_SaleOn,
ss_NameStyle,
ss_NameSize,
ss_PriceStyle,
ss_PriceSize,
ss_SKUStyle,
ss_SKUSize,
ss_DescriptionStyle,
ss_DescriptionSize,
ss_ImageAlignment,
ss_TextWrap,
ss_QuantityOnHand NUMERIC,
ss_LowStockThreshold NUMERIC,
ss_OutOfStockLimit NUMERIC,
ss_DisplayOrderQuantity,
ss_DisplayOrderingOptions,
ss_OrderButton,
ss_CheckoutButton,
ss_UseAddImage,
ss_AddImage,
ss_UseCheckoutImage,
ss_CheckoutImage,
ss_ProductField1,
ss_ProductField2,
ss_ProductField3,
ss_ProductField4,
ss_ProductField5,
ss_QBImport,
ss_Subproducts,
ss_UUID,
ss_ProductSitemap,
ss_ProductSitemapPriority,
ss_CustTextEntryHeader,
ss_CustTextEntryColumns,
ss_CustTextEntryRows,
ss_MinimumQuantity DEFAULT "0",
ss_ProductField6,
ss_ProductField7,
ss_ProductField8,
ss_ProductField9,
ss_ProductField10,
ss_ProductField11,
ss_ProductField12,
ss_ProductField13,
ss_ProductField14,
ss_ProductField15,
ss_ProductField16,
ss_ProductField17,
ss_ProductField18,
ss_ProductField19,
ss_ProductField20,
ss_ProductField21,
ss_ProductField22,
ss_ProductField23,
ss_ProductField24,
ss_ProductField25,
ss_ProductField26,
ss_ProductField27,
ss_ProductField28,
ss_ProductField29,
ss_ProductField30,
ss_ProductField31,
ss_ProductField32,
ss_ProductField33,
ss_ProductField34,
ss_ProductField35,
ss;













(”:ƒ($Ÿ	-Ù†/àþÉ_ó‹ÅàÁÁWhV+)	indexAux_Product_idxshV+)	indexAux_Product_idxss_ProductsAux]CREATE INDEX Aux_Product_idx ON ss_ProductsAux (ss_ProductsID);UO)indexsqlite_autoindex_ss_ProductsAux_1ss_ProductsAux\©M]‚indexkpd_kw_idx_all_indexable_fields2ss_KeywordToProduct_all_indexable_fieldsZCREATE UNIQUE INDEX kpd_kw_idx_all_indexable_fields2 on ss_KeywordToProduct_all_indexable_fields (ss_Keyword, ss_ProductsID)RR]]wtabless_KeywordToPrYB!%{indexpl_cid_idxss_PageLinksHCREATE INDEX pl_cid_idx ON ss_PageLinks (ss_CategoryID)[A#%}indexpl_prid_idxss_PageLinksGCREATE INDEX pl_prid_idx ON ss_PageLinks (ss_ProductsID)(Q33wtabless_UploadCheckpointss_UploadCheckpointXCREATE TABLE ss_UploadCheckpoint (
ss_PID INTEGER,
ss_Flags INTEGER,
ss_UploadType INTEGER,
ss_FilePosition INTEGER )O''_tabless_NonceTabless_NonceTableVCREATE TABLE ss_NonceTable (
ss_NonceID INTEGER PRIMARY KEY,
ss_Nonce UNIQUE,
ss_ExpirationTime,
ss_OTP )¥!%{indexpl_cid_idxss_PaX@#%windexpl_pgid_idxss_PageLinksFCREATE INDEX pl_pgid_idx ON ss_PageLinks (ss_PagesID)]?!%indexpl_pid_idxss_PageLinksECREATE INDEX pl_pid_idx ON ss_PageLinks (ss_ParentPagesID)jN#3indexcpd_pid_idxss_CouponToProductsUCREATE INDEX cpd_pid_idx ON ss_CouponToProducts (ss_ProductsID)hM#3indexcpd_cid_idxss_CouponToProductsTCREATE INDEX cpd_cid_idx ON ss_CouponToProducts (ss_CouponID)aL33‚itabless_CouponToProductsss_CouponToProductsSCREATE TABLE ss_CouponToProducts (
ss_CouponToProductsID INTEGER PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_CouponID INTEGER,
ss_ProductsID INTEGER,
ss_SortOrder )OKc=indexsqlite_autoindex_ss_PagesProductsDefaults_1ss_PagesProductsDefaultsR_J==‚Qtabless_PagesProductsDefaultsss_PagesProductsDefaultsQCREATE TABLE ss_PagesProductsDefaults (
ss_PagesProductsDefaultsID INTEGER PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_FieldName UNIQUE,
ss_FieldValue )MI#iindexpg_uuid_idxss_PagesPCREATE INDEX pg_uuid_idx ON ss_Pages (ss_UUID)UH#yindexpg_file_idxss_PagesOCREATE INDEX pg_file_idx ON ss_Pages (ss_PageFileName)QG#qindexpg_name_idxss_PagesNCREATE INDEX pg_name_idx ON ss_Pages (ss_PageName)RF%qindexpg_recid_idxss_PagesMCREATE INDEX pg_recid_idx ON ss_Pages (ss_PagesID)ŠoE•1tabless_Pagesss_PagesLCREATE TABLE ss_Pages (
ss_PagesID INTEGER PRIMARY KEY,
ss_Agent,
ss_Created,
ss_LastChanged,
ss_Status,
ss_PageName,
ss_DisplayPageName,
ss_PageTitle,
ss_PageGraphic,
ss_DisplayPageGraphic,
ss_Text1,
ss_Text2,
ss_Text3,
ss_LinkName,
ss_LinkGraphic,
ss_LinkText,
ss_PageTextWrap,
ss_LinksToPage,
ss_PageTemplate,
ss_ItemAlignment,
ss_Columns,
ss_DisplayColumnBorders,
ss_PageWidth,
ss_PageWidthType DEFAULT "percent",   
ss_DisplayUniversalHeader,
ss_DisplayUniversalFooter,
ss_TextColor,
ss_BackgroundColor,
ss_LinkColor,
ss_VisitedLinkColor,
ss_ActiveLinkColor,
ss_BackgroundImage,
ss_PageFileName,
ss_MetaKeywords,
ss_MetaDescription,
ss_SearchProducts,
ss_Index,
ss_Order,
ss_ProductsSortField,
ss_PagesSortField,
ss_ProductsFirst,
ss_NumberProducts,
ss_PageField1,
ss_PageField2,
ss_PageField3,
ss_PageField4,
ss_PageField5,
ss_PageLinks,
ss_ProductLinks,
ss_PageProductLinks,
ss_UUID,
ss_PageSitemap,
ss_PageSitemapPriority,
ss_PageField6,
ss_PageField7,
ss_PageField8,
ss_PageField9,
ss_PageField10,
ss_PageField11,
ss_PageField12,
ss_PageField13,
ss_PageField14,
ss_PageField15,
ss_PageField16,
ss_PageField17,
ss_PageField18,
ss_PageField19,
ss_PageField20,
ss_PageField21,
ss_PageField22,
ss_PageField23,
ss_PageField24,
ss_PageField25,
ss_DobaPageID,
ss_LinkGraphicSize,
ss_PageGlobalCrossSell,
ss_LinkColumns,
ss_PageGraphicDesc,
ss_LinkGraphicDesc
)D)%Cindexpl_pidprid_idxss_PageLinksKCREATE INDEX pl_pidprid_idx ON ss_PageLinks (ss_ParentPagesID, ss_ProductsID, ss_SortOrder)C)%=indexpl_pidpgid_idxss_PageLinksICREATE INDEX pl_pidpgid_idx ON ss_PageLinks (ss_ParentPagesID, ss_PagesID, ss_SortOrder) !%S=##oindexpr_uuid_idxss9PM'indexsqlite_autoindex_ss_NonceTable_1ss_NonceTableW





















Â+W
Ÿ
bøÅ†ë´bÞ|¹g€«ÂÖ~

"dd#-indexqp_prid_idxss_QuantityPricelCREATE INDEX qp_prid_idx ON ss_QuantityPrice (ss_ProductsID)fc--‚tabless_QuantityPricess_QuantityPricekCREATE TABLE ss_QuantityPrice (
ss_QtyPriceID INTEGER PRIMARY KEY AUTOINCREMENT,
ss_ProductsID INTEGER,
ss_SortOrder  INTEGER,
ss_Quantity   INTEGER,
ss_PricePerUnit,
ss_OnSalePerUnit
)Rb''‚ctabless_OrderStatsss_OrderStatsjCREATE TABLE ss_OrderStats (
ss_OrderStatsID INTEGER PRIMARY KEY AUTOINCREMENT,
ss_Name,
ss_Price,
ss_Quantity,
ss_SubTotal,
ss_SKU,
ss_PageOrderedFrom,
ss_Host,
ss_Date
)da%%ƒtabless_RefOrdersss_RefOrdersiCREATE TABLE ss_RefOrders (
ss_RefOrderID INTEGER PRIMARY KEY AUTOINCREMENT,
ss_RefName,
ss_OrderNum,
ss_ShipName,
ss_Email,
ss_ProductTotal,
ss_GrandTotal,
ss_Date,
ss_PayType,
ss_SubTotal
)P`++Ytablesqlite_sequencesqlite_sequencehCREATE TABLE sqlite_sequence(name,seq)ƒ@_##†Gtabless_Referersss_ReferersgCREATE TABLE ss_Referers (
ss_RefID INTEGER PRIMARY KEY AUTOINCREMENT,
ss_RefName,
ss_RefEmail,
ss_RefContactName,
ss_RefCompanyName,
ss_RefAddress1,
ss_RefAddress2,
ss_RefCity,
ss_RefState,
ss_RefZip,
ss_RefCountry,
ss_RefPhone,
ss_RefFax,
ss_RefPayMethod,
ss_RefAssociateURL,
ss_RefURLRedirect,
ss_RefCommission NUMERIC,
ss_RefPercentage NUMERIC,
ss_RefCommPerc INTEGER,
ss_WhiteListType INTEGER,
ss_WhiteList
)`^'%indexCrossSell_idxss_CrossSellfCREATE INDEX CrossSell_idx ON ss_CrossSell (ss_ProductsID)]%%Etabless_CrossSellss_CrossSelleCREATE TABLE ss_CrossSell (
ss_ProductsID INTEGER,
ss_ChildID INTEGER,
ss_SortOrder INTEGER)\7?#indexAux_ChildToParent_idxss_ProductToSubproductAuxdCREATE INDEX Aux_ChildToParent_idx ON ss_ProductToSubproductAux(ss_ChildID)FZ??‚tabless_ProductToSubproductAuxss_ProductToSubproductAuxbCREATE TABLE ss_ProductToSubproductAux (
ss_ParentID INTEGER,
ss_ChildID INTEGER,
UNIQUE (ss_ParentID, ss_ChildID) ON CONFLICT IGNORE )Q[e?indexsqlite_autoindex_ss_ProductToSubproductAux_1ss_ProductToSubproductAuxc	tuY7+indexAux_ProductToPage_idxss_PageLinksAuxaCREATE INDEX Aux_ProductToPage_idx ON ss_PageLinksAux(ss_ProductsID)=XQ+indexsqlite_autoindex_ss_PageLinksAux_1ss_PageLinksAux_,W++‚tabless_PageLinksAuxss_PageLinksAux^CREATE TABLE ss_PageLinksAux (
ss_PagesID INTEGER,
ss_ProductsID INTEGER,
UNIQUE (ss_PagesID, ss_ProductsID) ON CONFLICT IGNORE )„+)	indexAux_Product_idxss_ProductsAux]CREATE INDEX Aux_Product_idx ON ss_ProductsAux (ss_ProductsID);UO)indexsqlite_autoindex_ss_ProductsAux_1ss_ProductsAux\5T))[l%#}indexwsh_cust_idxss_WishListtCREATE INDEX wsh_cust_idx ON ss_WishList (ss_CustomerID)|k##ƒ?tabless_WishListss_WishListsCREATE TABLE ss_WishList
(
  ss_WishListID INTEGER PRIMARY KEY AUTOINCREMENT,
  ss_CustomerID INTEGER,
  ss_WishListName,
  ss_WishListLink,
  ss_Visibility,
  ss_Comments,
  ss_Created,
  ss_LastChanged,
  ss_Agent
)Vj'!sindexrev_email_idxss_ReviewsrCREATE INDEX rev_email_idx ON ss_Reviews (ss_Email)Zi%!}indexrev_guid_idxss_ReviewsqCREATE INDEX rev_guid_idx ON ss_Reviews (ss_ProductGUID)Yh%!{indexrev_prid_idxss_ReviewspCREATE INDEX rev_prid_idx ON ss_Reviews (ss_ProductsID)‚g!!ƒitabless_Reviewsss_ReviewsoCREATE TABLE ss_Reviews (
ss_ReviewsID INTEGER PRIMARY KEY AUTOINCREMENhV+)	indexAux_Product_idxss_ProductsAux]CREATE INDEX Aux_Product_idx ON ss_ProductsAux (ss_ProductsID);UO)indexsqlite_autoindex_ss_ProductsAux_1ss_ProductsAux\5T))‚%tabless_ProductsAuxss_ProductsAux[CREATE TABLE ss_ProductsAux (
ss_ProductsID INTEGER,
ss_Name,
ss_KeywordString,
ss_Price NUMERIC,
UNIQUE(ss_ProductsID) ON CONFLICT REPLACE)QSM]‚indexkpd_kw_idx_all_indexable_fields2ss_KeywordToProduct_all_indexable_fieldsZCREATE UNIQUE INDEX kpd_kw_idx_all_indexable_fields2 on ss_KeywordToProduct_all_indexable_fields (ss_Keyword, ss_ProductsID)RR]]wtabless_KeywordToProduct_all_indexable_fieldsss_KeywordToProduct_all_indexable_fieldsYCREATE TABLE ss_KeywordToProduct_all_indexable_fields (
ss_Keyword,
ss_ProductsID INTEGER,
ss_KeywordWeight INTEGER
)





















=‡š
¡
9'Ìp
	¼!³EgüøÖXä‡[w	indexmisc_idxss_Misc€CREATE UNIQUE INDEX misc_idx on ss_Misc (ss_Category, ss_Name)rv;tabless_Miscss_MiscCREATE TABLE ss_Misc
(
  ss_Category,
  ss_Name,
  ss_Value,
  ss_Extra1,
  ss_Extra2
)|u);!indexss_subhist_idxss_SubscriptionsHistory~CREATE INDEX ss_subhist_idx on ss_SubscriptionsHistory (ss_SubscriptionID)6t;;‚tabless_SubscriptionsHistoryss_SubscriptionsHistory}CREATE TABLE ss_SubscriptionsHistory (
  ss_SubscriptionID INTEGER, 
  ss_Event INTEGER, 
  ss_Timestamp, 
  ss_EventData
)gs#-indexss_sub_idx2ss_Subscriptions|CREATE INDEX ss_sub_idx2 on ss_Subscriptions (ss_GatewayStatus)mr!-indexss_sub_idxss_Subscriptions{CREATE INDEX ss_sub_idx on ss_Subscriptions (ss_GatewaySubscriptionID)‡p--Wtabless_Subscriptionsss_SubscriptionsyCREATE TABLE ss_Subscriptions 
(
  ss_SubscriptionID INTEGER PRIMARY KEY AUTOINCREMENT,
  ss_OrderID INTEGER,
  ss_ProductsID INTEGER,
  ss_ProductGUID,
  ss_PaymentGateway,
  ss_GatewaySubscriptionID INTEGER UNIQUE,
  ss_Quantity INTEGER,
  ss_FiniteOptions,
  ss_FreeformOptions,
  ss_SKU,
  ss_Graphic,
  ss_SubPaymentIntervalUnit,
  ss_SubRegularPaymentAmount NUMERIC,
  ss_SubEndingPeriod,
  ss_SubBillOn,
  ss_SubTrialCheckBox,
  ss_SubTrialPaymentAmount NUMERIC,
  ss_SubTrialPeriods,
  ss_SubOneTimeCheckBox,
  ss_SubOneTimePaymentAmount NUMERIC,
  ss_Created,
  ss_LastChanged,
  ss_Agent,
  ss_GatewaySubscriptionInfo,
  ss_EmailCount INTEGER DEFAULT 0,
  ss_ProductName,
  ss_Email, 
  ss_CustomerName, 
  ss_GatewayStatus, 
  ss_PastOccurrences INTEGER,
  ss_StartDate, 
  ss_Amount, 
  ss_TrialAmount, 
  ss_PaymentMethod,
  ss_Expiring INTEGER DEFAULT 0
)?qS-indexsqlite_autoindex_ss_Subscriptions_1ss_Subscriptionszlo%3
indexwsh_prod_idxss_WishListProductsxCREATE INDEX wsh_prod_idx ON ss_WishListProducts (ss_ProductsID)ln%3
indexwsh_list_idxss_WishListProductswCREATE INDEX wsh_list_idx ON ss_WishListProducts (ss_WishListID)ƒm33…Wtabless_WishListProductsss_WishListProductsuCREATE TABLE ss_WishListProducts
(
  ss_WishListProductsID INTEGER PRIMARY KEY AUTOINCREMENT,
  ss_WishListID INTEGER,
  ss_ProductsID INTEGER,
  ss_SelectedFiniteOptions,
  ss_SelectedFreeformOptions,
  ss_MerchantField,
  ss_QntyDesired INTEGER,
  ss_QntyPurchased INTEGER,
  ss_PageAddedFrom,
  ss_DateAdded INTEGER,
  ss_Comment,
  ss_Priority INTEGER
)[l%#}indexwsh_cust_idxss_WishListtCREATE INDEX wsh_cust_idx ON ss_WishList (ss_CustomerID)|k##ƒ?tabless_WishListss_WishListsCREATE TABLE ss_WishList
(
  ss_WishListID INTEGER PRIMARY KEY AUTOINCREMENT,
  ss_CustomerID INTEGER,
  ss_WishListName,
  ss_WishListLink,
  ss_Visibility,
  ss_Comments,
  ss_Created,
  ss_LastChanged,
  ss_Agent
)Vj'!sindexrev_email_idxss_ReviewsrCREATE INDEX rev_email_idx ON ss_Reviews (ss_Email)Zi%!}indexrev_guid_idxss_ReviewsqCREATE INDEX rev_guid_idx ON ss_Reviews (ss_ProductGUID)Yh%!{indexrev_prid_idxss_ReviewspCREATE INDEX rev_prid_idx ON ss_Reviews (ss_ProductsID)‚g!!ƒitabless_Reviewsss_ReviewsoCREATE TABLE ss_Reviews (
ss_ReviewsID INTEGER PRIMARY KEY AUTOINCREMENT,
ss_ProductsID INTEGER,
ss_ProductGUID,
ss_Name,
ss_Email,
ss_Title,
ss_ReviewContents,
ss_Response,
ss_Rating NUMERIC,
ss_Status NUMERIC DEFAULT 0,
ss_Time NUMERIC)ff#/indexpv_prid_idxss_ProductOptionsnCREATE INDEX pv_prid_idx ON ss_ProductOptions (ss_ProductsID)ƒve//‡tabless_ProductOptionsss_ProductOptionsmCREATE TABLE ss_ProductOptions (
ss_OptionsID INTEGER PRIMARY KEY AUTOINCREMENT,
ss_ProductsID INTEGER,
ss_Use,
ss_Menu1,
ss_Menu2,
ss_Menu3,
ss_Menu4,
ss_ExtraString,
ss_Option,
ss_SKU,
ss_PriceMod,
ss_WeightMod,
ss_Image,
ss_QuantityOnHand NUMERIC,
ss_LowStockThreshold NUMERIC,
ss_OutOfStockLimit NUMERIC,
ss_GTIN,
ss_QBImport,
ss_ExtraOptionField1,
ss_ExtraOptionField2,
ss_OptionOrder INTEGER,
ss_Created DATETIME,
ss_LastChanged DATETIME,
ss_Agent
)dd#-indexqp_prid_idxss_QuantityPricelCREATE INDEX qp_prid_idx ON ss_QuantityPrice (ss_ProductsID)
haha - 2025