http://www.accessengineeringlibrary.com dumped !?
http://www.accessengineeringlibrary.com/html/Description.asp?bookid=2001776c'
http://www.accessengineeringlibrary.com/admin
michael_jurick admin
http://www.accessengineeringlibrary.com/admin
michael_jurick admin
TableNumber 1:
Table name : Activate_FreeTrial Sum Table 14 Table ID 635865332
intSubsID, dtStartDate, dtEndDate, intStatus, strPurchaseOrderNo, dtAdded, strSubscType, strAddedBy, dtChanged, strChangedBy, intInstID, strPONumber, intPackageID, dtExpdate,
TableNumber 2:
Table name : ccdetails Sum Table 25 Table ID 715865617
Errors on send get Columns Query
TableNumber 3:
Table name : CustomerHelp Sum Table 14 Table ID 795865902
HelpId, Orderno, CustomerName, CustomerEmailAddress, HeplDescription, Datetime, OperatingSystem, BrowserName, BrowserVersion, AddedBy, AddedDate, ChangedBy, ChangedDate, OrderDate,
TableNumber 4:
Table name : dtlCart Sum Table 8 Table ID 2121774616
dblCartID, strChapterId, intChapterType, intQty, dblGrossPrice, intTrackingCode, intCurrencyType, dtAdded,
TableNumber 5:
Table name : dtlPackage Sum Table 3 Table ID 1249439525
ID, intPackageID, strBookID,
TableNumber 6:
Table name : dtproperties Sum Table 7 Table ID 117575457
id, objectid, property, value, lvalue, version, uvalue,
TableNumber 7:
Table name : MghCheckRefurl Sum Table 2 Table ID 1345439867
Linkfor, Link,
TableNumber 8:
Table name : MstAccessArticles Sum Table 4 Table ID 1167343223
Catid, IntInstid, Sessionid, AccessDate,
TableNumber 9:
Table name : mstAccessByBarCode Sum Table 5 Table ID 539864990
NSrNo, IntInstId, LastDateAccess, hit, BarCode,
TableNumber 10:
Table name : mstAccessByIp Sum Table 5 Table ID 1183343280
NSrNo, Intinstid, DtLastAccess, Hit, AccessIp,
TableNumber 11:
Table name : MstAccessByRefUrl Sum Table 5 Table ID 523864933
NSrNo, intinstid, LastDateAccess, Hit, RefUrl,
TableNumber 12:
Table name : mstAccessTopics Sum Table 5 Table ID 907866301
NId, Catid, IntInstId, Sessionid, AccessDate,
TableNumber 13:
Table name : MstActiveConnections Sum Table 4 Table ID 886294217
Errors on send get Columns Query
TableNumber 14:
Table name : mstAdmin_Access Sum Table 4 Table ID 1206295357
NSrNo, NstaffCode, P_Admin_Area, Description,
TableNumber 15:
Table name : mstadmin_area Sum Table 4 Table ID 402816497
P_Admin_Area, Description, URL, Date_Created,
TableNumber 16:
Table name : mstAdminUsers Sum Table 3 Table ID 484196775
strUserId, strPassword, dtAdded,
TableNumber 17:
Table name : mstBarcodes Sum Table 6 Table ID 489768802
intInstID, url, prefix, barcode, ikey, fix,
TableNumber 18:
Table name : mstBook Sum Table 15 Table ID 1877633782
Errors on send get Columns Query
TableNumber 19:
Table name : mstBook_030109 Sum Table 14 Table ID 1637632927
strBookID, strISBN, strTitle, strPrintISBN, strBookStrap, intNoOfPages, dblRetailPrice, dtPubDate, strTOC, intPermission, dtAdded, strAddedBy, dtChanged, strChangedBy,
TableNumber 20:
Table name : mstBook_13Apr09 Sum Table 15 Table ID 162151673
strBookID, strISBN, strTitle, strPrintISBN, strBookStrap, intNoOfPages, dblRetailPrice, dtPubDate, strTOC, intPermission, dtAdded, strAddedBy, dtChanged, strChangedBy, OldEdition,
TableNumber 21:
Table name : mstBook_28112008 Sum Table 14 Table ID 1493632414
strBookID, strISBN, strTitle, strPrintISBN, strBookStrap, intNoOfPages, dblRetailPrice, dtPubDate, strTOC, intPermission, dtAdded, strAddedBy, dtChanged, strChangedBy,
TableNumber 22:
Table name : mstBook_310109 Sum Table 14 Table ID 1749633326
strBookID, strISBN, strTitle, strPrintISBN, strBookStrap, intNoOfPages, dblRetailPrice, dtPubDate, strTOC, intPermission, dtAdded, strAddedBy, dtChanged, strChangedBy,
TableNumber 23:
Table name : mstBook_old9-Mar-09 Sum Table 14 Table ID 2021634295
strBookID, strISBN, strTitle, strPrintISBN, strBookStrap, intNoOfPages, dblRetailPrice, dtPubDate, strTOC, intPermission, dtAdded, strAddedBy, dtChanged, strChangedBy,
TableNumber 24:
Table name : mstBookAuthor Sum Table 4 Table ID 28579190
strBookID, strAuthor, intMode, strDetails,
TableNumber 25:
Table name : mstBookAuthor_030109 Sum Table 4 Table ID 1621632870
strBookID, strAuthor, intMode, strDetails,
TableNumber 26:
Table name : mstBookAuthor_13Apr09 Sum Table 4 Table ID 194151787
strBookID, strAuthor, intMode, strDetails,
TableNumber 27:
Table name : mstBookAuthor_28112008 Sum Table 4 Table ID 1525632528
strBookID, strAuthor, intMode, strDetails,
TableNumber 28:
Table name : mstBookAuthor_310109 Sum Table 4 Table ID 1797633497
strBookID, strAuthor, intMode, strDetails,
TableNumber 29:
Table name : mstBookFormat Sum Table 7 Table ID 45243216
strBookID, StrChapterid, FormatId, FormatPermission, FormatDownloadSize, FormatDownloadTime, FormatUploadDate,
TableNumber 30:
Table name : mstBookImage Sum Table 3 Table ID 363864363
intBookID, strBImagePath, strSImagePath,
TableNumber 31:
Table name : mstChapter Sum Table 21 Table ID 60579304
strChapterID, strBookID, strTitle, strMetadata, strChapterNumber, strFloatCount, strDOI, strStartPage, strEndPage, intNoOfPages, intSequence, strFileSize, intPermission, strDownloadTime, strPrevStartPage, strPrevEndPage, strAddedBy, dtAdded, strChangedBy, dtChanged, strPageList,
TableNumber 32:
Table name : mstChapter_030109 Sum Table 21 Table ID 1669633041
strChapterID, strBookID, strTitle, strMetadata, strChapterNumber, strFloatCount, strDOI, strStartPage, strEndPage, intNoOfPages, intSequence, strFileSize, intPermission, strDownloadTime, strPrevStartPage, strPrevEndPage, strAddedBy, dtAdded, strChangedBy, dtChanged, strPageList,
TableNumber 33:
Table name : mstChapter_13Apr09 Sum Table 21 Table ID 210151844
strChapterID, strBookID, strTitle, strMetadata, strChapterNumber, strFloatCount, strDOI, strStartPage, strEndPage, intNoOfPages, intSequence, strFileSize, intPermission, strDownloadTime, strPrevStartPage, strPrevEndPage, strAddedBy, dtAdded, strChangedBy, dtChanged, strPageList,
TableNumber 34:
Table name : mstChapter_28112008 Sum Table 21 Table ID 1509632471
strChapterID, strBookID, strTitle, strMetadata, strChapterNumber, strFloatCount, strDOI, strStartPage, strEndPage, intNoOfPages, intSequence, strFileSize, intPermission, strDownloadTime, strPrevStartPage, strPrevEndPage, strAddedBy, dtAdded, strChangedBy, dtChanged, strPageList,
TableNumber 35:
Table name : mstChapter_310109 Sum Table 21 Table ID 1781633440
strChapterID, strBookID, strTitle, strMetadata, strChapterNumber, strFloatCount, strDOI, strStartPage, strEndPage, intNoOfPages, intSequence, strFileSize, intPermission, strDownloadTime, strPrevStartPage, strPrevEndPage, strAddedBy, dtAdded, strChangedBy, dtChanged, strPageList,
TableNumber 36:
Table name : mstChapterAuthor Sum Table 4 Table ID 44579247
strChapterID, strAuthor, intMode, strDetails,
TableNumber 37:
Table name : mstChapterAuthor_030109 Sum Table 4 Table ID 1653632984
strChapterID, strAuthor, intMode, strDetails,
TableNumber 38:
Table name : mstChapterAuthor_13Apr09 Sum Table 4 Table ID 178151730
strChapterID, strAuthor, intMode, strDetails,
TableNumber 39:
Table name : mstChapterAuthor_28112008 Sum Table 4 Table ID 1541632585
strChapterID, strAuthor, intMode, strDetails,
TableNumber 40:
Table name : mstChapterAuthor_310109 Sum Table 4 Table ID 1765633383
strChapterID, strAuthor, intMode, strDetails,
TableNumber 41:
Table name : mstChapterCatalog Sum Table 3 Table ID 76579361
ChapterID, ChapterXml, ChapterTaxList,
TableNumber 42:
Table name : mstChapterCatalog_030109 Sum Table 3 Table ID 1685633098
ChapterID, ChapterXml, ChapterTaxList,
TableNumber 43:
Table name : mstChapterCatalog_13Apr09 Sum Table 3 Table ID 226151901
ChapterID, ChapterXml, ChapterTaxList,
TableNumber 44:
Table name : mstChapterCatalog_28112008 Sum Table 3 Table ID 1573632699
ChapterID, ChapterXml, ChapterTaxList,
TableNumber 45:
Table name : mstChapterCatalog_310109 Sum Table 3 Table ID 1829633611
ChapterID, ChapterXml, ChapterTaxList,
TableNumber 46:
Table name : mstChapterPrice Sum Table 11 Table ID 92579418
strChapterID, dblPrice, intCurrency, strAddedBy, dtAdded, strChangedBy, dtChanged, AdobePrice, AdobeTrackingCode, DXOnlinePrice, DXOnlineTrackingCode,
TableNumber 47:
Table name : mstChapterPrice_030109 Sum Table 11 Table ID 1701633155
strChapterID, dblPrice, intCurrency, strAddedBy, dtAdded, strChangedBy, dtChanged, AdobePrice, AdobeTrackingCode, DXOnlinePrice, DXOnlineTrackingCode,
TableNumber 48:
Table name : mstChapterPrice_13Apr09 Sum Table 11 Table ID 242151958
strChapterID, dblPrice, intCurrency, strAddedBy, dtAdded, strChangedBy, dtChanged, AdobePrice, AdobeTrackingCode, DXOnlinePrice, DXOnlineTrackingCode,
TableNumber 49:
Table name : mstChapterPrice_28112008 Sum Table 11 Table ID 1557632642
strChapterID, dblPrice, intCurrency, strAddedBy, dtAdded, strChangedBy, dtChanged, AdobePrice, AdobeTrackingCode, DXOnlinePrice, DXOnlineTrackingCode,
TableNumber 50:
Table name : mstChapterPrice_310109 Sum Table 11 Table ID 1813633554
strChapterID, dblPrice, intCurrency, strAddedBy, dtAdded, strChangedBy, dtChanged, AdobePrice, AdobeTrackingCode, DXOnlinePrice, DXOnlineTrackingCode,
TableNumber 51:
Table name : mstChapterTaxonomy Sum Table 2 Table ID 124579532
strChapterID, intTaxoID,
TableNumber 52:
Table name : mstChapterTaxonomy_030109 Sum Table 2 Table ID 1733633269
strChapterID, intTaxoID,
TableNumber 53:
Table name : mstChapterTaxonomy_13Apr09 Sum Table 2 Table ID 258152015
strChapterID, intTaxoID,
TableNumber 54:
Table name : mstChapterTaxonomy_28112008 Sum Table 2 Table ID 1605632813
strChapterID, intTaxoID,
TableNumber 55:
Table name : mstChapterTaxonomy_310109 Sum Table 2 Table ID 1861633725
strChapterID, intTaxoID,
TableNumber 56:
Table name : mstChapterTaxonomy_old9-Mar-09 Sum Table 2 Table ID 2053634409
strChapterID, intTaxoID,
TableNumber 57:
Table name : mstConfiguration Sum Table 2 Table ID 864722133
strConfigID, intDays,
TableNumber 58:
Table name : mstCountry Sum Table 3 Table ID 775673811
strCountryName, strCountryCode, strOracleCountryCode,
TableNumber 59:
Table name : mstCountry_29Mar07 Sum Table 2 Table ID 2128062667
strCountryName, strCountryCode,
TableNumber 60:
Table name : mstCreditType Sum Table 4 Table ID 1913773875
CTID, CTName, CTValue, CTFlag,
TableNumber 61:
Table name : mstCustomerFeedback Sum Table 14 Table ID 1289771652
intFeedbackID, strComments, strCategory, strName, strTitle, strOrganization, strAddress1, strCity, strCountryCode, intZip, strStateCode, strWorkPhone, strFax, strEmail,
TableNumber 62:
Table name : mstEmailedChapter Sum Table 9 Table ID 1010818663
intEmailID, strFromEmail, strToEmail, strSubject, dtAdded, intInstID, strChapterID, strKey, intStatus,
TableNumber 63:
Table name : mstformat Sum Table 2 Table ID 921770341
Nformatid, formatdescription,
TableNumber 64:
Table name : mstInstConnection Sum Table 4 Table ID 967674495
intConnectionType, intStatus, dtAdded, intSubsID,
TableNumber 65:
Table name : mstInstitution Sum Table 65 Table ID 361104377
intInstID, intRegID, strConFirstName, strConLastName, strTitle, strInstitution, strAddress1, strAddress2, strCity, intZip, strWorkPhone, strFax, strEmail, intEmailAlert, strURL, strTechContactName, strTechPhoneNo, dtAdded, strAddedBy, strChangedBy, dtChanged, strUserName, strPassword, strPasswordHint, strUserType, strTrackingCode, strChannelCode, strAgencyCode, intStatus, strSurveyCode, strInstCode, strCountryCode, strStateCode, strDisplayName, intConnections, strcn_ip, strcn_ipup, strcn_ref, strcn_brcd, boolDisplayName, strLogoURL, strSpecialityCode, strProfessionCode, dblAmount, blnPaymode, allowSubUsers, qfnumber, strshiptoaccno, strbilltoaccno, strbilltotitle, strbilltofirstname, strbilltolastname, strbilltoemail, strbilltoemailalert, strbilltostreet1, strbilltostreet2, strbilltocity, strbilltozip, strbilltoworkphone, strbilltofax, strbilltostatecode, strbilltocountrycode, strbilltoorganization, strSalesOverrideFlag, Tempid,
TableNumber 66:
Table name : mstInstitution_13Feb07 Sum Table 56 Table ID 1456060273
intInstID, intRegID, strConFirstName, strConLastName, strTitle, strInstitution, strAddress1, strAddress2, strCity, intZip, strWorkPhone, strFax, strEmail, intEmailAlert, strURL, strTechContactName, strTechPhoneNo, dtAdded, strAddedBy, strChangedBy, dtChanged, strUserName, strPassword, strPasswordHint, strUserType, strTrackingCode, strChannelCode, strAgencyCode, intStatus, strSurveyCode, strInstCode, strCountryCode, strStateCode, strDisplayName, intConnections, strcn_ip, strcn_ipup, strcn_ref, strcn_brcd, boolDisplayName, strLogoURL, strSpecialityCode, strProfessionCode, dblAmount, blnPaymode, allowSubUsers, qfnumber, strbilltostreet1, strbilltostreet2, strbilltocity, strbilltozip, strbilltoworkphone, strbilltofax, strbilltostatecode, strbilltocountrycode, strSalesOverrideFlag,
TableNumber 67:
Table name : mstInstitutionRegRequest Sum Table 50 Table ID 473104776
intRegID, strConFirstName, strConLastName, strTitle, strInstitution, strAddress1, strAddress2, strCity, intZip, strWorkPhone, strFax, strEmail, intEmailAlert, strURL, strTechContactName, strTechPhoneNo, strPurchaseOrderNo, intNoOfConConnection, strIPList, strConnectionMode, strUserName, strPassword, strRegType, strPasswordHint, dtAdded, intProcesses, strAddedBy, dtChanged, strChangedBy, strSurveyCode, strInstCode, strCountryCode, strStateCode, strRequestor, strshiptoaccno, strbilltoaccno, strbilltotitle, strbilltofirstname, strbilltolastname, strbilltoemail, strbilltoemailalert, strbilltostreet1, strbilltostreet2, strbilltocity, strbilltozip, strbilltoworkphone, strbilltofax, strbilltostatecode, strbilltocountrycode, strbilltoorganization,
TableNumber 68:
Table name : mstInstitutionType Sum Table 2 Table ID 743673697
strInstCode, strType,
TableNumber 69:
Table name : mstInstReferer Sum Table 5 Table ID 884198200
strReferer, intStatus, dtAdded, intInstID, ikey,
TableNumber 70:
Table name : mstInstUsers Sum Table 14 Table ID 1307867726
intInstSubCode, strFirstName, strLastName, strUserName, strPassword, intStatus, dtAdded, intInstID, strPasswordHint, strEmail, strSpecialityCode, bitNotifyEmail, dtChanged, strChangedBy,
TableNumber 71:
Table name : mstInstUsers_070809 Sum Table 14 Table ID 1420584149
intInstSubCode, strFirstName, strLastName, strUserName, strPassword, intStatus, dtAdded, intInstID, strPasswordHint, strEmail, strSpecialityCode, bitNotifyEmail, dtChanged, strChangedBy,
TableNumber 72:
Table name : mstIPAddress Sum Table 5 Table ID 1556200594
fltStartIP, fltEndIP, intStatus, dtAdded, intInstID,
TableNumber 73:
Table name : mstIPAddress_12Dec07 Sum Table 5 Table ID 345104320
fltStartIP, fltEndIP, intStatus, dtAdded, intInstID,
TableNumber 74:
Table name : mstLibraryAdmin Sum Table 9 Table ID 545437017
LibraryId, intInstId, strFirstName, strLastName, strUserName, strPassword, intStatus, dtAdded, dtChanged,
TableNumber 75:
Table name : mstMessages Sum Table 5 Table ID 283864078
strMsgID, strMailRcpt, strSubject, strBody, strMsgTitle,
TableNumber 76:
Table name : mstMessages_20Mar09 Sum Table 5 Table ID 130151559
strMsgID, strMailRcpt, strSubject, strBody, strMsgTitle,
TableNumber 77:
Table name : mstMessages_old9-Mar-09 Sum Table 5 Table ID 2069634466
strMsgID, strMailRcpt, strSubject, strBody, strMsgTitle,
TableNumber 78:
Table name : mstNewContent Sum Table 4 Table ID 1832393597
strBookID, strISBN, strTitle, strAuthor,
TableNumber 79:
Table name : mstNews Sum Table 8 Table ID 821630020
intNewsID, dtNews, strFileName, strHeadline, strDescription, strFileLocation, intStatus, DtNewsEnd,
TableNumber 80:
Table name : MstNewsHits Sum Table 5 Table ID 1451868239
NNewsHitId, NNewsId, NHits, LastaccessDate, IntInstid,
TableNumber 81:
Table name : mstNewStoriesHit Sum Table 4 Table ID 1960394053
NSrNo, Bookid, Hit, LastHitDate,
TableNumber 82:
Table name : MstNumberOfSessions Sum Table 4 Table ID 1649440950
NSrno, Sessionid, IntInstId, unidate,
TableNumber 83:
Table name : mstOrder Sum Table 12 Table ID 164195635
intOrdID, dblTaxPerc, intTaxApplicable, dblTaxAmount, dblGross, dblNet, intCurrencyType, dtAdded, intInstID, intOrderType, intSubsID, intPaymentMode,
TableNumber 84:
Table name : mstPackage Sum Table 8 Table ID 285960095
intPackageID, intStatus, strDescription, dtAdded, dtModified, strModuleID, strpkgdetails, intveryfy,
TableNumber 85:
Table name : mstProfession Sum Table 3 Table ID 1908201848
intProfessionID, strProfessionCode, strProfession,
TableNumber 86:
Table name : mstsearches Sum Table 7 Table ID 1247343508
ID, phrase, dateSearched, userIP, SessionId, SearchType, intinstid,
TableNumber 87:
Table name : mstSettings Sum Table 4 Table ID 896722247
idSetting, settingKey, settingValue, comments,
TableNumber 88:
Table name : mstSiteMessage Sum Table 4 Table ID 1780201392
intMsgID, strMessage, dtDisplay, boolActive,
TableNumber 89:
Table name : mstSpeciality Sum Table 3 Table ID 1940201962
intSpecialityID, strSpecialityCode, strSpeciality,
TableNumber 90:
Table name : MstStaff Sum Table 7 Table ID 1707869151
NstaffCode, TFirstName, TLastName, TDesignation, TEmail, TUserName, TPassword,
TableNumber 91:
Table name : mstState Sum Table 4 Table ID 711673583
strStateName, strStateCode, strCountryCode, IsStateTaxable,
TableNumber 92:
Table name : mstSubsActivationPending Sum Table 8 Table ID 1803869493
intActID, dtAdded, intInstID, intSubsID, dblAmount, intProcessed, dtChanged, intCurrency,
TableNumber 93:
Table name : mstSubscription Sum Table 14 Table ID 816057993
intSubsID, dtStartDate, dtEndDate, intStatus, strPurchaseOrderNo, dtAdded, strSubscType, strAddedBy, dtChanged, strChangedBy, intInstID, strPONumber, intPackageID, dtExpdate,
TableNumber 94:
Table name : mstSubscription__13Feb07 Sum Table 14 Table ID 1424060159
intSubsID, dtStartDate, dtEndDate, intStatus, strPurchaseOrderNo, dtAdded, strSubscType, strAddedBy, dtChanged, strChangedBy, intInstID, strPONumber, intPackageID, dtExpdate,
TableNumber 95:
Table name : mstSubscription_29Apr09 Sum Table 14 Table ID 274152072
intSubsID, dtStartDate, dtEndDate, intStatus, strPurchaseOrderNo, dtAdded, strSubscType, strAddedBy, dtChanged, strChangedBy, intInstID, strPONumber, intPackageID, dtExpdate,
TableNumber 96:
Table name : mstSubscription_AccessEngg Sum Table 14 Table ID 290152129
intSubsID, dtStartDate, dtEndDate, intStatus, strPurchaseOrderNo, dtAdded, strSubscType, strAddedBy, dtChanged, strChangedBy, intInstID, strPONumber, intPackageID, dtExpdate,
TableNumber 97:
Table name : mstSuccessfulRead Sum Table 11 Table ID 2005634238
IntInstId, strUserName, Sessionid, strISBN, strBookTitle, strBookID, strChapterID, strTitle, IPAddress, readDate, formatID,
TableNumber 98:
Table name : mstSuccessPDFReadBookReport2 Sum Table 19 Table ID 1973634124
intInstID, strInstitution, strISBN, strTitle, ReportYear, ReportTimestamp, JanCounter, FebCounter, MarCounter, AprCounter, MayCounter, JunCounter, JulCounter, AugCounter, SepCounter, OctCounter, NovCounter, DecCounter, YTDCounter,
TableNumber 99:
Table name : mstSuccessReadBookReport2 Sum Table 19 Table ID 1989634181
intInstID, strInstitution, strISBN, strTitle, ReportYear, ReportTimestamp, JanCounter, FebCounter, MarCounter, AprCounter, MayCounter, JunCounter, JulCounter, AugCounter, SepCounter, OctCounter, NovCounter, DecCounter, YTDCounter,
TableNumber 100:
Table name : mstSurvey Sum Table 2 Table ID 1511676433
strSurveyCode, strSurveyDesc,
TableNumber 101:
Table name : mstTaxonomy Sum Table 7 Table ID 1477632357
intTaxoID, strDesc, strParent, strProdCode, intArtCount, strTaxoIDPath, strTaxoNamePath,
TableNumber 102:
Table name : mstTaxonomy_030109 Sum Table 7 Table ID 1717633212
intTaxoID, strDesc, strParent, strProdCode, intArtCount, strTaxoIDPath, strTaxoNamePath,
TableNumber 103:
Table name : mstTaxonomy_28112008 Sum Table 7 Table ID 1589632756
intTaxoID, strDesc, strParent, strProdCode, intArtCount, strTaxoIDPath, strTaxoNamePath,
TableNumber 104:
Table name : mstTaxonomy_310109 Sum Table 7 Table ID 1845633668
intTaxoID, strDesc, strParent, strProdCode, intArtCount, strTaxoIDPath, strTaxoNamePath,
TableNumber 105:
Table name : mstTaxonomy_old9-Mar-09 Sum Table 7 Table ID 2037634352
intTaxoID, strDesc, strParent, strProdCode, intArtCount, strTaxoIDPath, strTaxoNamePath,
TableNumber 106:
Table name : mstTempShoppingCart Sum Table 10 Table ID 247671930
intTShopCartID, strChapterID, dblSessionID, strIPAddress, intChapterType, intCurrencyType, dblUnitPrice, intQty, dblTotal, dtAdded,
TableNumber 107:
Table name : mstTitle Sum Table 3 Table ID 1117247035
iTitleId, strTitleCode, strTitleDesc,
TableNumber 108:
Table name : mstTracking Sum Table 7 Table ID 459864705
TrackingCode, FormatId, TrackingDesc, TrackingPrice, MinPage, MaxPage, suppliedcode,
TableNumber 109:
Table name : mstTrialActivationPending Sum Table 4 Table ID 1016390690
intTrialID, strKey, dtAdded, intRegID,
TableNumber 110:
Table name : mstTrunAways Sum Table 5 Table ID 1231343451
IntId, IntInstid, Sessionid, Ip, Turndate,
TableNumber 111:
Table name : OrderDetail Sum Table 9 Table ID 1552060615
intRefid, intOrdID, strChapterPackageId, intChapterPackageType, intQty, dblGrossPrice, intTrackingCode, QFnumber, TempId,
TableNumber 112:
Table name : OrderDetail__13Feb07 Sum Table 8 Table ID 1440060216
intRefid, intOrdID, strChapterPackageId, intChapterPackageType, intQty, dblGrossPrice, intTrackingCode, qfnumber,
TableNumber 113:
Table name : OrderDetail_12mar09 Sum Table 9 Table ID 2101634580
intRefid, intOrdID, strChapterPackageId, intChapterPackageType, intQty, dblGrossPrice, intTrackingCode, QFnumber, TempId,
TableNumber 114:
Table name : OrderMaster Sum Table 12 Table ID 50151274
intOrdId, intInstID, dblTaxAmount, dblNetPrice, intCurrencyType, intPaymentMode, intOrderType, dtOrderDate, intHistId, PONumber, QFNumber, TempId,
TableNumber 115:
Table name : OrderMaster_12mar09 Sum Table 12 Table ID 2085634523
intOrdId, intInstID, dblTaxAmount, dblNetPrice, intCurrencyType, intPaymentMode, intOrderType, dtOrderDate, intHistId, PONumber, QFNumber, TempId,
TableNumber 116:
Table name : OrderTemp Sum Table 11 Table ID 232387897
intOrdId, dblCartID, strCustString, dblTaxAmount, dblNetPrice, intCurrencyType, intPaymentMode, intOrderType, dtOrderDate, blnOrderGenerated, intHistId,
TableNumber 117:
Table name : OrderTempID Sum Table 2 Table ID 864058164
OrderNo, TempID,
TableNumber 118:
Table name : OrderTempID_24Jan07 Sum Table 2 Table ID 1008058677
OrderNo, TempID,
TableNumber 119:
Table name : SubscriptionHistory Sum Table 8 Table ID 1080390918
intRecId, intInstID, dtStartDate, dtEndDate, dtExpdate, blnPaymentMode, dtModified, dblamount,
TableNumber 120:
Table name : SubscriptionHistory_distinctOrders Sum Table 8 Table ID 306152186
intRecId, intInstID, dtStartDate, dtEndDate, dtExpdate, blnPaymentMode, dtModified, dblamount,
TableNumber 121:
Table name : sysconstraints Sum Table 7 Table ID 63339290
constid, id, colid, spare1, status, actions, error,
TableNumber 122:
Table name : syssegments Sum Table 3 Table ID 47339233
segment, name, status,
TableNumber 123:
Table name : tempmstChapter Sum Table 21 Table ID 1190295300
strChapterID, strBookID, strTitle, strMetadata, strChapterNumber, strFloatCount, strDOI, strStartPage, strEndPage, intNoOfPages, intSequence, strFileSize, intPermission, strDownloadTime, strPrevStartPage, strPrevEndPage, strPageList, strAddedBy, dtAdded, strChangedBy, dtChanged,
TableNumber 124:
Table name : tempnewcontent Sum Table 4 Table ID 1848393654
strBookID, strISBN, strTitle, strAuthor,
TableNumber 125:
Table name : temptest Sum Table 2 Table ID 1993774160
Linkfor, Link,
TableNumber 126:
Table name : traActiveConnection Sum Table 2 Table ID 407672500
intCounter, intInstID,
TableNumber 127:
Table name : traTaxonomyHits Sum Table 4 Table ID 2139154666
intCounter, dtDate, intInstID, intTaxoID,
TableNumber 128:
Table name : TreeList_Tmp Sum Table 3 Table ID 2124586657
id, subdirectory, depth,
TableNumber 129:
Table name : vwEmailChapterKey Sum Table 5 Table ID 672721449
strConfigID, strChapterID, strKey, intInstID, dtAdded,
TableNumber 130:
Table name : vwNews Sum Table 5 Table ID 464720708
intNewsID, dtNews, strFileName, strHeadline, strDescription,
TableNumber 131:
Table name : vwSiteMessage Sum Table 1 Table ID 1972202076
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Table name : ccdetails
--------------------------------------
ccnumber cctype ccexpdate strCountryName authcode
371560710293006 A 11/2011 FL 6780
372504493512009 A 04/2011 AR 238
373725791863005 A 06/2010 CA 4537
374581346501007 A 05/2010 - 4140
376677477951009 A 09/2011 - 5208
377262095561016 A 01/2010 TN 9222
378292664811350 A 11/2009 NJ 6782
378316787463003 A 04/2013 NY 4794
378341589966011 A 06/2009 CA 4895
378731758841005 A 08/2011 MI 248
379062102841007 A 12/2008 ON 1254
379635319911000 A 06/2009 FL 6808
379693605901003 A 07/2012 NH 9489
4006310000008283 V 06/2011 - 327
4030030064841268 V 12/2010 - 896
4043085017620016 V 08/2009 - 744
4053060021770518 V 01/2012 - 831
4246315124722669 V 10/2008 CA 74
4271790181022054 V 01/2009 TX 44
4311951801115759 V 10/2015 - 611
4339931192166304 V 08/2009 OK 329
4355092009146812 V 09/2010 - 591
4500030101302408 V 04/2010 ON 246
4520840005596087 V 02/2009 NF 631
4530912641235012 V 04/2010 QC 267
4539794040759169 V 07/2011 - 432
4548032774262111 V 12/2009 - 947
4581992447412047 V 11/2010 - 429
4715360000375408 V 01/2011 ON 649
4715634801160981 V 04/2010 TX 238
4798178866053145 V 10/2011 OR 444
4828702858811014 V 10/2012 GA 468
4859489143666823 V 09/2009 CT 687
4868320089583624 V 05/2010 CA 662
5211461012479570
V
04/2010
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TableNumber 1:
Table name : Activate_FreeTrial Sum Table 14 Table ID 635865332
intSubsID, dtStartDate, dtEndDate, intStatus, strPurchaseOrderNo, dtAdded, strSubscType, strAddedBy, dtChanged, strChangedBy, intInstID, strPONumber, intPackageID, dtExpdate,
TableNumber 2:
Table name : ccdetails Sum Table 25 Table ID 715865617
Errors on send get Columns Query
I can get again
intRecNum
intOrdId
ccnumber
cctype
ccexpdate
authcode
dtadded
strConFirstName
strConLastName
strTitle
strInstitution
strAddress1
strAddress2
strCity
strZip
strWorkPhone
strFax
strEmail
strCountryName
strStateName
strSpeciality
strProfession
strSurveyCode
blnOrderGenerated
PreAuthCode
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
562 1250 5418590012345679 M 12/2009 123 Feb 25 2009 2:39PM Anand Pandit Mr. Value-Chain Pune Pune 411014 919890197232 anand.pandit@value-chain.biz - INDI OTH OTP WOTHER 1 697232
561 1247 4530912641235012 V 04/2010 267 Feb 19 2009 10:36PM AMAL CHARKAOUI Ms. 6755A PIERRE AUGER MONTREAL H1M 2Z8 0015142538563 amalrayan@hotmail.com QC CAN IND STU WDM 1 93573
560 1246 5405920901462662 M 01/2012 752 Feb 19 2009 8:03PM Joyce Pardi Ms. BPMC-KAPL 2401 River Rd C218L837 Schenectady 12301 518 395 7499 518 395 7761 pardij@kapl.gov NY US OTH OTP WJNL 1 91963
559 1245 4548032774262111 V 12/2009 947 Feb 13 2009 11:47PM M.Angel P.Gracia Mr. Student C/.Joan Miro-7 Barcelona 08005 0034-932211349 indexmig@menta.net - SPA MEC STU WFREE 1 49757
558 1243 378316787463003 A 04/2013 4794 Feb 10 2009 12:31AM Cathy Backes Ms. Cadwalader Wickersham & Taft One Word Financial Center 30th Floor, Library New York 10281 2125046767 cathy.backes@cwt.com NY US OTH OTP WOTHER 1 146434
557 1239 4053060021770518 V 01/2012 831 Feb 3 2009 6:27AM Angel Rodriguez Mr. Rincon de los Nogales #2 Rincon Arboledas Puebla 72460 012222283530 angel_rg87@hotmail.com - MEX ELE STU WOTHER 1 32651
556 1238 4311951801115759 V 10/2015 611 Feb 2 2009 4:01PM Hopin Chen Mr. N-sys 2F-1, No.56, Sing-Yi Rd , Beit District Taipei 112 +886935738246 morris_chen@n-sys.net - TAI MAT OTP WFREE 1 78108
555 1237 4868320089583624 V 05/2010 662 Feb 1 2009 9:03AM Christopher Mueller Dr. 1931 California St # 6 Mountain View 94040 9252627148 chrismueller_82@hotmail.com CA US CIV PRE WONLIN 1 790193
554 1235 4715360000375408 V 01/2011 649 Jan 28 2009 1:12AM Vera Rodic Mrs. 2380 Speakman Drive Sheridan Science & Technology Mississauga L5K 1B4 9052872276 905-822-2882 vera.rodic@teck.com ON CAN OTH OTP WONLIN 1 65481
553 1233 5436395510818708 M 03/2011 634 Jan 21 2009 3:51AM Winston Riley Mr. ENDECO TRINIDAD LIMITED 19 COBLENTZ AVENUE CASCADE PORT OF SPAIN 0000 868 627 6102 868 623 6355 wriley@planning-endeco.com - TRIN CIV PRE WONLIN 1 20358
552 1232 4500030101302408 V 04/2010 246 Jan 18 2009 7:54AM 16 Barcham Cres Ottawa K2J 3Z7 henry.jaffe16@rogers.com ON CAN WOTHER 1 493
551 1231 4355092009146812 V 09/2010 591 Jan 13 2009 7:52PM Fatih OVALI Mr. STM Defense Technologies Ankara Teknoloji Gelistirme Bo 5. Cadde No:2/3 Bilkent ANKARA 06800 +905058185460 fovali@stm.com.tr - TRKY ELE OTP WOTHER 1 50200
550 1230 4828702858811014 V 10/2012 468 Jan 13 2009 8:56AM Anwer Habib Dr. PO Box 1571 Pine Lake 30072 4045203855 anwer.habib@gmail.com GA US BIO OTP WOTHER 1 264942
549 1229 371560710293006 A 11/2011 6780 Jan 13 2009 8:35AM 2507 San Domingo Street Coral Gables 33134 roldan.guillen@woodgroup.com FL US OTH PRE WOTHER 1 143806
548 1226 4339931192166304 V 08/2009 329 Jan 10 2009 1:37PM Jonathan Hill Dr. 852 Golden Pond Dr. Yukon 73099 405-265-2239 hillengineering@gmail.com OK US CIV PRE 1 15926
547 1222 4581992447412047 V 11/2010 429 Jan 8 2009 2:31AM Carl Hjerpe Mr. Sigunvagen 4 Nacka 131 46 +46-707737186 c.j.hjerpe@sagacitas.se - SWE CHE PRE WOTHER 1 113770
546 1219 5534170337178953 M 06/2009 703 Jan 4 2009 7:16PM Tim Lenior Mr. ASaP BV Distelweg 80m Amsterdam 1031CM +31204924748 +31203372798 tlenior@asap4u.nl - NET CHE OTP WOTHER 1 80622
545 1216 379062102841007 A 12/2008 1254 Dec 19 2008 8:53PM Clive Matthews Mr. Global Spectrum 99 Dundas Street London N6A 6K1 519 667-5787 519 432-3386 cmatthews@johnlabattcentre.com ON CAN MEC OTP WONLIN 1 113908
544 1214 378341589966011 A 06/2009 4895 Dec 11 2008 6:53PM Grigori Dzekon Mr. 150 executive Park Blvd, Suite San Francisco 94134 4155334031 george@priocom.com CA US COM OTP WOTHER 1 123597
543 1204 379693605901003 A 07/2012 9489 Dec 1 2008 8:46PM Ronald Egan Prof. 552 Morrill St. Gilford 03249 6093348065 regan@kepner-tregoe.com NH US IND PRF WOTHER 1 108720
542 1203 4798178866053145 V 10/2011 444 Nov 25 2008 1:23AM Russell Pierson Mr. Bineham Construction Inc 4171 W 1st Ave Eugene 97402 877-895-6627 541-302-5926 russ@binehamconstruction.com OR US OTH OTP WOTHER 1 314235
541 1202 4859489143666823 V 09/2009 687 Nov 21 2008 11:20PM Jordy Scott Mr. 644 Danbury Road PO Box 724 Wilton 06897 203-762-2000 kristad@glengatecompany.com CT US OTH OTP WONLIN 1 207398
540 1201 5528517371141834 M 11/2009 398 Nov 20 2008 2:49AM Benjamin Wilson Mr. ATC Associates 824 Renewal Lane Leasburg 27291 9198710999 bwilson_leasburg@hotmail.com NC US CIV PRE WOTHER 1 56045
539 1200 4271790181022054 V 01/2009 44 Nov 17 2008 11:33PM leon fowler Mr. 1532 e 10th odessa 79761 4325538297 cubs17cub@yahoo.com TX US OTH OTP 1 17450
538 1199 4539794040759169 V 07/2011 432 Nov 17 2008 5:34PM Juliet Davis Ms. London
Scvhool of Economics Houghton Street London WC2A 2AE +442079231463 j.p.davis@lse.ac.uk - UK CON STU WOTHER 1 40824
537 1197 4006310000008283 V 06/2011 327 Nov 5 2008 2:37AM Barry Phillip Mr. Baker Hughes Trinidad Limited 3&3A Sweet Briar Road St Clair Maraval port of Spain WI 18686806201 18686915500 barry.phillip@bakerhughes.com - TRIN ENV PRE WONLIN 1 29185
536 1196 376677477951009 A 09/2011 5208 Nov 1 2008 11:12PM Israel De Leon Salas Mr. TRAFICO INTELIGENTE CONSULTORE MALECON CARLOS A. MADRAZO 681- COL. CENTRO VILLAHERMOSA TABASCO 86000 52 993 1310996 52 618 8138915 israeldeleons@aol.com - MEX CIV PRE WONLIN 1 111875
535 1193 378731758841005 A 08/2011 248 Oct 28 2008 11:58PM Helen Xiang Dr. 4700 Broadmoor Ave SE Suite 20 Kentwood 49512 616-656-7454 helen.xiang@intertek.com MI US MAT PRE WONLIN 1 163556
534 1191 377262095561016 A 01/2010 9222 Oct 22 2008 7:38AM Michael Vance Mr. 828 Pearson Oaks Dr Collierville 38017 901-326-1800 toolman_206@yahoo.com TN US CHE PRE WONLIN 1 179134
533 1190 379635319911000 A 06/2009 6808 Oct 20 2008 8:54AM David Kozan Mr. 701 Jenks Ave Panama City 32401 850 785-5999 kozandw@cdm.com FL US CIV PRE WOTHER 1 147064
532 1182 4043085017620016 V 08/2009 744 Oct 11 2008 2:32PM Mustafa Özkurt Mr. Kennedy Cad. 119/11 Ankara 06420 05336987274 y_ozkurt@hotmail.com - TRKY MEC PRE WDM 1 863620
531 1181 4520840005596087 V 02/2009 631 Oct 9 2008 6:11PM David Healey Mr. 8 Wilcox Place Mount Pearl A1N 3B7 709-368-2088 davehealey@nf.aibn.com NF CAN MEC PRE WOTHER 1 32190
530 1179 378292664811350 A 11/2009 6782 Oct 8 2008 3:57AM John Battler Dr. Kline & Company 150 Clove Rd Little Falls 07424 973-35-431 john.battler@yahoo.com NJ US CHE PRE WOTHER 1 122406
529 1174 4715634801160981 V 04/2010 238 Oct 4 2008 12:47AM Lynn Fisher Ms. Total Petrochemicals, Inc. PO Box 1200 Deer Park 77536 281-884-7675 lynn.fisher@total.com TX US OTH OTP WOTHER 1 15169
528 1305 5500187002321718 M 09/2010 731 Sep 23 2008 3:18AM Martin Fischer Mr. 12 yarra st South Yarra 3141 1233153433 fischer.carlito@gmail.com - AUSL CIV PRE WOTHER 0 416150
527 1305 5500187002321718 M 09/2010 731 Sep 23 2008 3:13AM Martin Fischer Mr. 12 yarra st South Yarra 3141 1233153433 fischer.carlito@gmail.com - AUSL CIV PRE WOTHER 0 818948
526 1169 4246315124722669 V 10/2008 74 Sep 20 2008 2:48AM TOM KERSCHER Mr. ENVENT CORPORATION 2398 CALIFORNIA AVE SIGNAL HILL 90755 562-997-9465 562-997-9485 TLKERSCHER@ENVENT.NET CA US ENV PRE WWOM 1 56144
525 1168 372504493512009 A 04/2011 238 Sep 18 2008 3:20AM Michael Tarini Mr. Garver Engineers 14200 Westbury Drive Little Rock 72223 501-537-3409 mjtarini@garverengineers.com AR US CIV PRE WOTHER 1 104814
524 1167 4030030064841268 V 12/2010 896 Sep 17 2008 4:09PM fRANCO Poletti Dr. poletti via pastorino genoa 16164 3471576645 franco_poletti@libero.it - ITA ELE PRE 1 92385
523 1165 373725791863005 A 06/2010 4537 Sep 12 2008 1:18AM Pedro Ganaja Dr. 24831 Via Santa Cruz Mission Viejo 92692 949 707-4547 munetaka.ganaha@mac.com CA US CON PRF WOTHER 1 174514
522 1158 5403023306424940 M 11/2008 334 Sep 3 2008 12:12AM Antony Joseph Dr. 1459 Society hill dr bensalem 19020 2672072158 antony@panathara.org PA US BIO OTP WOTHER 1 904854
521 1157 5211461012479570 M 09/2010 170 Sep 1 2008 12:29AM Norman Johnson Mr. 1223 Hamstead Court Knoxville 37922 865-223-8189 njohnson@jegroup.us TN US CIV PRE WOTHER 1 870232
No comments:
Post a Comment