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/www/cgi-bin/shopsite-data/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/jackjohn/www/cgi-bin/shopsite-data/shopsite_reports_db
SQLite format 3@  ,7,,-#_

s		\V[\?s#R!uindexReferers_uReferersCREATE INDEX Referers_u ON Referers (Date, ss_RefID)N'gindexReferers_dateReferersCREATE INDEX Referers_date ON Referers (Date)7AtableReferersReferersCREATE TABLE Referers 
   (Date REFERENCES Timelog, 
   ss_RefID REFERENCES ReferersData, Revenue REAL DEFAULT 0, Orders INTEGER DEFAULT 0,   Coupons DEFAULT 0, Rewards DEFAULT 0, GiftCertsBought DEFAULT 0, GiftCertsUsed DEFAULT 0, Discounts DEFAULT 0    , UNIQUE (Date, ss_RefID) )/Cindexsqlite_autoindex_Referers_1Referers_)%indexShippingData_2ShippingDataCREATE INDEX ShippingData_2 ON ShippingData (ss_Shipping)t%%+tableShippingDataShippingDataCREATE TABLE ShippingData 
   (ShippingID INTEGER PRIMARY KEY, 
   ss_Shipping)T!yindexShipping_uShippingCREATE INDEX Shipping_u ON Shipping (Date, ShippingID)N'gindexShipping_dateShippingCREATE INDEX Shipping_date ON Shipping (Date)~OtableShippingShippingCREATE TABLE Shipping 
   (Date REFERENCES Timelog, 
   ShippingID REFERENCES ShippingData, Orders INTEGER DEFAULT 0, Revenue REAL DEFAULT 0, Shipping REAL DEFAULT 0 , Surcharges REAL DEFAULT 0   , UNIQUE (Date, ShippingID) )/Cindexsqlite_autoindex_Shipping_1ShippingW'#sindexCouponsData_2CouponsDataCREATE INDEX CouponsData_2 ON CouponsData (ss_Name)n###tableCouponsDataCouponsDataCREATE TABLE CouponsData 
   (ss_CouponID INTEGER PRIMARY KEY, 
   ss_Name)QwindexCoupons_uCouponsCREATE INDEX Coupons_u ON Coupons (Date, ss_CouponID)J%cindexCoupons_dateCouponsCREATE INDEX Coupons_date ON Coupons (Date)MqtableCouponsCouponsCREATE TABLE Coupons 
   (Date REFERENCES Timelog, 
   ss_CouponID REFERENCES CouponsData, CouponUnits INTEGER DEFAULT 0, Coupons REAL DEFAULT 0    , UNIQUE (Date, ss_CouponID) )-Aindexsqlite_autoindex_Coupons_1Couponsf!indexProducts_uProductsCREATE INDEX Products_u ON Products (Date, ss_ProductsID, ss_OptionsID)N
'gindexProducts_dateProductsCREATE INDEX Products_date ON Products (Date)tableProductsProductsCREATE TABLE Products 
   (Date REFERENCES Timelog, 
   ss_ProductsID REFERENCES ProductsData, ss_OptionsID REFERENCES OptionsData, ProductUnits INTEGER DEFAULT 0, Sales REAL DEFAULT 0, Rewards REAL DEFAULT 0,     UNIQUE (Date, ss_ProductsID, ss_OptionsID) )/Cindexsqlite_autoindex_Products_1Products
r
)#%indexOptionsData_23OptionsDataCREATE INDEX OptionsData_23 ON OptionsData (ss_ProductsID, ss_FiniteOptions)|	+#7indexOptionsData_234OptionsData
CREATE INDEX OptionsData_234 ON OptionsData (ss_ProductsID, ss_FiniteOptions, ss_SKU)'##tableOptionsDataOptionsData	CREATE TABLE OptionsData 
   (ss_OptionsID INTEGER PRIMARY KEY, 
   ss_ProductsID REFERENCES ProductsData, ss_FiniteOptions, ss_SKU)f+%	indexProductsData_23ProductsDataCREATE INDEX ProductsData_23 ON ProductsData (ss_Name, ss_SKU)Z)%uindexProductsData_3ProductsDataCREATE INDEX ProductsData_3 ON ProductsData (ss_SKU)[)%windexProductsData_2ProductsDataCREATE INDEX ProductsData_2 ON ProductsData (ss_Name){%%9tableProductsDataProductsDataCREATE TABLE ProductsData 
   (ss_ProductsID INTEGER PRIMARY KEY, 
   ss_Name, ss_SKU)J%cindexTimelog_dateTimelogCREATE INDEX Timelog_date ON Timelog (Date)AYtableTimelogTimelogCREATE TABLE Timelog 
   (Date PRIMARY KEY DEFAULT CURRENT_DATE, 
   Revenue REAL DEFAULT 0, Orders INTEGER DEFAULT 0, Tax REAL DEFAULT 0, Shipping REAL DEFAULT 0, Surcharges REAL DEFAULT 0, Coupons REAL DEFAULT 0, Discounts REAL DEFAULT 0, Rewards REAL DEFAULT 0, GiftCertsUsed REAL DEFAULT 0, GiftCertsBought REAL DEFAULT 0, CartsAccessed INTEGER DEFAULT 0, CartsAccessedTotal REAL DEFAULT 0, CartsFirstAbandonEmail INTEGER DEFAULT 0, CartsSecondAbandonEmail INTEGER DEFAULT 0, CartsRecovered INTEGER DEFAULT 0, CartsRecoveredTotal REAL DEFAULT 0 )-Aindexsqlite_autoindex_Timelog_1Timelog!

































9_

s		\$V[?s#\q%%%tableReferersDataReferersData CREATE TABLE ReferersData 
   (ss_RefID INTEGER PRIMARY KEY, 
   ss_RefName)R!uindexReferers_uReferersCREATE INDEX Referers_u ON Referers (Date, ss_RefID)N'gindexReferers_dateReferersCREATE INDEX Referers_date ON Referers (Date)AtableReferersReferersCREATE TABLE Referers 
   (Date REFERENCES Timelog, 
   ss_RefID REFERENCES ReferersData, Revenue REAL DEFAULT 0, Orders INTEGER DEFAULT 0,   Coupons DEFAULT 0, Rewards DEFAULT 0, GiftCertsBought DEFAULT 0, GiftCertsUsed DEFAULT 0, Discounts DEFAULT 0    , UNIQUE (Date, ss_RefID) )/Cindexsqlite_autoindex_Referers_1Referers)%indexShippingData_2ShippingDataCREATE INDEX ShippingData_2 ON ShippingData (ss_Shipping)t%%+tableShippingDataShippingDataCREATE TABLE ShippingData 
   (ShippingID INTEGER PRIMARY KEY, 
   ss_Shipping)T!yindexShipping_uShippingCREATE INDEX Shipping_u ON Shipping (Date, ShippingID)N'gindexShipping_dateShippingCREATE INDEX Shipping_date ON Shipping (Date)/Cindexsqlite_autoindex_Shipping_1Shipping~OtableShippingShippingCREATE TABLE Shipping 
   (Date REFERENCES Timelog, 
   ShippingID REFERENCES ShippingData, Orders INTEGER DEFAULT 0, Revenue REAL DEFAULT 0, Shipping REAL DEFAULT 0 , Surcharges REAL DEFAULT 0   , UNIQUE (Date, ShippingID) )W'#sindexCouponsData_2CouponsDataCREATE INDEX CouponsData_2 ON CouponsData (ss_Name)n###tableCouponsDataCouponsDataCREATE TABLE CouponsData 
   (ss_CouponID INTEGER PRIMARY KEY, 
   ss_Name)QwindexCoupons_uCouponsCREATE INDEX Coupons_u ON Coupons (Date, ss_CouponID)J%cindexCoupons_dateCouponsCREATE INDEX Coupons_date ON Coupons (Date)-Aindexsqlite_autoindex_Coupons_1CouponsMqtableCouponsCouponsCREATE TABLE Coupons 
   (Date REFERENCES Timelog, 
   ss_CouponID REFERENCES CouponsData, CouponUnits INTEGER DEFAULT 0, Coupons REAL DEFAULT 0    , UNIQUE (Date, ss_CouponID) )f!indexProducts_uProductsCREATE INDEX Products_u ON Products (Date, ss_ProductsID, ss_OptionsID)N
'gindexProducts_dateProductsCREATE INDEX Products_date ON Products (Date)tableProductsProductsCREATE TABLE Products 
   (Date REFERENCES Timelog, 
   ss_ProductsID REFERENCES ProductsData, ss_OptionsID REFERENCES OptionsData, ProductUnits INTEGER DEFAULT 0, Sales REAL DEFAULT 0, Rewards REAL DEFAULT 0,     UNIQUE (Date, ss_ProductsID, ss_OptionsID) )/Cindexsqlite_autoindex_Products_1Products
r
)#%indexOptionsData_23OptionsDataCREATE INDEX OptionsData_23 ON OptionsData (ss_ProductsID, ss_FiniteOptions)|	+#7indexOptionsData_234OptionsData
CREATE INDEX OptionsData_234 ON OptionsData (ss_ProductsID, ss_FiniteOptions, ss_SKU)'##tableOptionsDataOptionsData	CREATE TABLE OptionsData 
   (ss_OptionsID INTEGER PRIMARY KEY, 
   ss_ProductsID REFERENCES ProductsData, ss_FiniteOptions, ss_SKU)f+%	indexProductsData_23ProductsDataCREATE INDEX ProductsData_23 ON ProductsData (ss_Name, ss_SKU)Z)%uindexProductsData_3ProductsDataCREATE INDEX ProductsData_3 ON ProductsData (ss_SKU)[)%windexProductsData_2ProductsDataCREATE INDEX ProductsData_2 ON ProductsData (ss_Name){%%9tableProductsDataProductsDataCREATE TABLE ProductsData 
   (ss_ProductsID INTEGER PRIMARY KEY, 
   ss_Name, ss_SKU)J%cindexTimelog_dateTimelogCREATE INDEX Timelog_date ON Timelog (Date)AYtableTimelogTimelogCREATE TABLE Timelog 
   (Date PRIMARY KEY DEFAULT CURRENT_DATE, 
   Revenue REAL DEFAULT 0, Orders INTEGER DEFAULT 0, Tax REAL DEFAULT 0, Shipping REAL DEFAULT 0, Surcharges REAL DEFAULT 0, Coupons REAL DEFAULT 0, Discounts REAL DEFAULT 0, Rewards REAL DEFAULT 0, GiftCertsUsed REAL DEFAULT 0, GiftCertsBought REAL DEFAULT 0, CartsAccessed INTEGER DEFAULT 0, CartsAccessedTotal REAL DEFAULT 0, CartsFirstAbandonEmail INTEGER DEFAULT 0, CartsSecondAbandonEmail INTEGER DEFAULT 0, CartsRecovered INTEGER DEFAULT 0, CartsRecoveredTotal REAL DEFAULT 0 )-Aindexsqlite_autoindex_Timelog_1Timelog

ZK
			/hU|KNi#Z\72K%Z72K%indexsqlite_autoindex_PaymentTypes_1PaymentTypes5o0-'indexLocationsData_23LocationsData3CREATE INDEX LocationsData_23 ON LocationsData (ss_State, ss_Country)c/+'indexLocationsData_3LocationsData2CREATE INDEX LocationsData_3 ON LocationsData (ss_Country)`.+'}indexLocationsData_2LocationsData1CREATE INDEX LocationsData_2 ON LocationsData (ss_State)-''?tableLocationsDataLocationsData0CREATE TABLE LocationsData 
   (LocationID INTEGER PRIMARY KEY, 
   ss_State, ss_Country)a,#
indexLocations_uLocations/CREATE INDEX Locations_u ON Locations (Date, LocationID, ss_Zip)R+)kindexLocations_dateLocations.CREATE INDEX Locations_date ON Locations (Date))otableLocationsLocations,CREATE TABLE Locations 
   (Date REFERENCES Timelog, 
   LocationID REFERENCES LocationsData, ss_Zip TEXT, Orders INTEGER DEFAULT 0, Revenue REAL DEFAULT 0, Tax REAL DEFAULT 0, Shipping REAL DEFAULT 0    , UNIQUE (Date, LocationID, ss_Zip) )1*Eindexsqlite_autoindex_Locations_1Locations-l(-'indexCustomersData_23CustomersData+CREATE INDEX CustomersData_23 ON CustomersData (ss_Name, ss_Email)`'+'}indexCustomersData_3CustomersData*CREATE INDEX CustomersData_3 ON CustomersData (ss_Email)_&+'{indexCustomersData_2CustomersData)CREATE INDEX CustomersData_2 ON CustomersData (ss_Name)}%''9tableCustomersDataCustomersData(CREATE TABLE CustomersData 
   (CustomerID INTEGER PRIMARY KEY, 
   ss_Name, ss_Email)X$#}indexCustomers_uCustomers'CREATE INDEX Customers_u ON Customers (Date, CustomerID)R#)kindexCustomers_dateCustomers&CREATE INDEX Customers_date ON Customers (Date)!!tableCustomersCustomers$CREATE TABLE Customers 
   (Date REFERENCES Timelog, 
   CustomerID REFERENCES CustomersData, Orders INTEGER DEFAULT 0, Revenue REAL DEFAULT 0,    Coupons REAL DEFAULT 0,    Discounts REAL DEFAULT 0,    Rewards REAL DEFAULT 0    , UNIQUE (Date, CustomerID) )1"Eindexsqlite_autoindex_Customers_1Customers%^ )%}indexReferersData_2ReferersData"CREATE INDEX ReferersData_2 ON ReferersData (ss_RefName)q%%%tableReferersDataReferersData CREATE TABLE ReferersData 
   (ss_RefID INTEGER PRIMARY KEY, 
   ss_RefName)R!uindexReferers_uReferersCREATE INDEX Referers_u ON Referers (Date, ss_RefID)N'gindexReferers_dateReferersCREATE INDEX Referers_date ON Referers (Date)/Cindexsqlite_autoindex_Referers_1Referers7AtableReferersReferersCREATE TABLE Referers 
   (Date REFERENCES Timelog, 
   ss_RefID REFERENCES ReferersData, Revenue REAL DEFAULT 0, Orders INTEGER DEFAULT 0,   Coupons DEFAULT 0, Rewards DEFAULT 0, GiftCertsBought DEFAULT 0, GiftCertsUsed DEFAULT 0, Discounts DEFAULT 0    , UNIQUE (Date, ss_RefID) )_)%indexShippingData_2ShippingDataCREATE INDEX ShippingData_2 ON ShippingData (ss_Shipping)t%%+tableShippingDataShippingDataCREATE TABLE ShippingData 
   (ShippingID INTEGER PRIMARY KEY, 
   ss_Shipping)!yindexShipping_uShippingCREATE INDEX Shipping_u ON Shipping (Date, ShippingID)N'gindexShipping_dateShippingCREATE INDEX Shipping_date ON Shipping (Date)/Cindexsqlite_autoindex_Shipping_1Shipping~OtableShippingShippingCREATE TABLE Shipping 
   (Date REFERENCES Timelog, 
   ShippingID REFERENCES ShippingData, Orders INTEGER DEFAULT 0, Revenue REAL DEFAULT 0, Shipping REAL DEFAULT 0 , Surcharges REAL DEFAULT 0   , UNIQUE (Date, ShippingID) )W'#sindexCouponsData_2CouponsDataCREATE INDEX CouponsData_2 ON CouponsData (ss_Name)n###tableCouponsDataCouponsDataCREATE TABLE CouponsData 
   (ss_CouponID INTEGER PRIMARY KEY, 
   sse4)%	indexPaymentTypes_uPaymentTypes7CREATE INDEX PaymentTypes_u ON PaymentTypes (Date, ss_Paytype)^3/%windexPaymentTypes_datePaymentTypes6CREATE INDEX PaymentTypes_date ON PaymentTypes (Date)Z1%%wtablePaymentTypesPaymentTypes4CREATE TABLE PaymentTypes 
   (Date REFERENCES Timelog, 
   ss_Paytype INTEGER, Orders INTEGER DEFAULT 0, Revenue REAL DEFAULT 0, Tax REAL DEFAULT 0    , UNIQUE (Date, ss_Paytype) )





















haha - 2025