User contributions for Woozle

12 July 2009

• 12:5712:57, 12 July 2009 diff hist +820 VbzCart/tables/ord hold type prelim documentation; removed isActive; some renaming

10 July 2009

• 19:1519:15, 10 July 2009 diff hist +540 VbzCart/tables/shop cart cart can be used in multiple sessions, so removing ID_Session field
• 13:2613:26, 10 July 2009 diff hist +12 VbzCart/queries/qryOrders Pulled usage correction current
• 13:2513:25, 10 July 2009 diff hist +51 VbzCart/queries →Packages: qryOrders_Pulled, qryPkgs_Pull_status
• 13:2413:24, 10 July 2009 diff hist +97 VbzCart/queries/qryPkgs Pull status very slow current
• 13:2313:23, 10 July 2009 diff hist +821 N VbzCart/queries/qryPkgs Pull status New page: ==About== * '''History''': ** '''2009-07-10''' Adapted from MS Access ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryPkgs_Pull_status AS SELECT ps.*, pu.ID_Type AS ID_Pu...
• 12:5312:53, 10 July 2009 diff hist +514 N VbzCart/queries/qryOrders Pulled New page: ==About== * '''Used by''': {{vbzcart|table|ord_msg}} * '''History''': ** '''2009-07-10''' Adapted from MS Access (replaces qryOrderPulls_active) *** qryOrderPulls_active derived its list o...
• 11:4111:41, 10 July 2009 diff hist +173 VbzCart/tables/ord pull expanded "Notes" field
• 11:3311:33, 10 July 2009 diff hist +316 VbzCart/tables/ord msg made "Notes" field wider
• 01:3801:38, 10 July 2009 diff hist +142 VbzCart/tables →Ordering: almost the last of the tables to be migrated
• 01:3701:37, 10 July 2009 diff hist +469 N VbzCart/tables/ord msg media New page: ==About== * '''Used by''': {{vbzcart|table|ord_msg}} * '''History''': ** '''2009-07-09''' Adapted from MS Access (was [Message Media]) ==SQL== <section begin=sql /><mysql>CREATE TABLE `ord...
• 01:3301:33, 10 July 2009 diff hist +429 N VbzCart/tables/card auth code New page: ==About== * '''Purpose''': reference table which translates AVS codes into natural language * '''History''': ** '''2009-07-09''' Adapted from MS Access ==SQL== <section begin=sql /><mysql>... current
• 01:3001:30, 10 July 2009 diff hist +459 N VbzCart/tables/ord pull type New page: ==About== * '''Used by''': {{vbzcart|table|ord_pull}} * '''History''': ** '''2009-07-09''' adapted from MS Access (was: [Order Pull Types]) ==SQL== <section begin=sql /><mysql>CREATE TABLE...
• 01:2601:26, 10 July 2009 diff hist +953 N VbzCart/tables/ord pull New page: ==About== * '''Purpose''': Log of order pulls/releases * '''Notes''': this should probably be expanded into an order-related event log * '''Relates to''': {{vbzcart|table|core_orders}}, {{...
• 01:1901:19, 10 July 2009 diff hist +1,784 N VbzCart/tables/ord msg New page: ==About== * '''Purpose''': Record of messages sent/received about this order * '''Notes''': This subsystem should probably be rethought at some point when everything else is working * '''R...

9 July 2009

• 19:3919:39, 9 July 2009 diff hist −38 m VbzCart/tables →Navigation: "/customer" page no longer exists
• 19:3719:37, 9 July 2009 diff hist +800 VbzCart/tables →Ordering: Customers: moved list of customer tables here and created separate page for each table; deleting separate "customer tables" page
• 19:3619:36, 9 July 2009 diff hist +3,728 N VbzCart/tables/cust charges moved from "customer tables" page
• 19:3619:36, 9 July 2009 diff hist +666 N VbzCart/tables/cust phones moved from "customer tables" page
• 19:3619:36, 9 July 2009 diff hist +559 N VbzCart/tables/cust names moved from "customer tables" page
• 19:3619:36, 9 July 2009 diff hist +552 N VbzCart/tables/cust emails moved from "customer tables" page
• 19:3519:35, 9 July 2009 diff hist +1,549 N VbzCart/tables/cust cards moved from "customer tables" page
• 19:3519:35, 9 July 2009 diff hist +2,001 N VbzCart/tables/cust addr moved from "customer tables" page
• 19:3519:35, 9 July 2009 diff hist +631 VbzCart/tables/cust the actual correct SQL, with documentation
• 19:3319:33, 9 July 2009 diff hist +45 N PayPal Virtual Terminal Redirecting to PayPal Virtual Terminal service current
• 19:2219:22, 9 July 2009 diff hist +559 N VbzCart/tables/cust New page: ==About== * '''History''': ** '''2009-07-09''' moved to separate wiki page; no design changes ==SQL== <section begin=sql /><mysql>CREATE TABLE `cust_names` ( `ID` INT NOT NULL AU...
• 19:1419:14, 9 July 2009 diff hist +24 VbzCart/queries →Customers: qryCbx_CustNames
• 19:1319:13, 9 July 2009 diff hist +417 N VbzCart/queries/qryCbx CustNames New page: ==About== * '''Purpose''': Provides a list of customer names with associated cust_name IDs * '''Requires''': {{vbzcart|table|cust_names}} * '''Used by''': {{vbzcart/query|qryPkgs_Pull_stat... current
• 18:1718:17, 9 July 2009 diff hist +37 VbzCart/queries →Orders: Shipping: qryPkgs_status
• 18:1718:17, 9 July 2009 diff hist −25 m VbzCart/queries/qryCbx Orders minor doc formatting updates current
• 18:1618:16, 9 July 2009 diff hist +1,358 N VbzCart/queries/qryPkgs status New page: ==About== * '''Requires''': {{vbzcart|table|ord_pkg_lines}}, {{vbzcart|table|ord_pkgs}}, {{vbzcart|table|ord_shipmt}}, {{vbzcart|table|ord_lines}}, {{vbzcart|table|core_orders}} * '''Group... current
• 01:3801:38, 9 July 2009 diff hist +188 N ACH New page: category:acronymsACH is an acronym which can stand for: * Automated Clearing House, a banking term * Analysis of Competing Hypotheses, a methodology for evaluating data current
• 01:3801:38, 9 July 2009 diff hist +230 N Analysis of Competing Hypotheses New page: ==Overview== {{seed}} ==Links== ===Reference=== * {{wikipedia}} ===Software=== * [http://www2.parc.com/istl/projects/ach/ach.html ACH2.0] by PARC: written in ... current

8 July 2009

• 16:0016:00, 8 July 2009 diff hist +54 m Salter Path, NC +catgs current
• 16:0016:00, 8 July 2009 diff hist +113 Trinity Center category fixes/updates; ownership of TC current
• 15:5715:57, 8 July 2009 diff hist −67 Salter Path, NC Trinity Ctr is in Pine Knoll Shores
• 15:5715:57, 8 July 2009 diff hist +140 Pine Knoll Shores, NC trinity center; category updates
• 15:3615:36, 8 July 2009 diff hist +558 N Trinity Center New page: ==Overview== category:US/NC/Outer BanksTrinity Center is a spiritual retreat and conference center in Pine Knoll Shores, NC. {{seedling}} ==Contact== * '''Street address''': 6...

7 July 2009

• 21:2221:22, 7 July 2009 diff hist +54 m VbzCart/tables/ord trxact →About: now on L48 current
• 21:2121:21, 7 July 2009 diff hist +54 m VbzCart/tables/ord trx type →About: now on L48
• 21:2021:20, 7 July 2009 diff hist +54 VbzCart/tables/ord shipmt →About: now on L48

6 July 2009

• 19:5919:59, 6 July 2009 diff hist +131 VbzCart/procs/doCtgUpdate cat_items no longer has qtyForSale
• 19:4919:49, 6 July 2009 diff hist +13 VbzCart/procs/doCtgUpdate noted 5/4 addition in history
• 19:4519:45, 6 July 2009 diff hist +365 VbzCart/procs/doCtgUpdate listed all tables written to & all sources

5 July 2009

• 23:0123:01, 5 July 2009 diff hist 0 Template:town/US catg: US.x -> US/x
• 14:3814:38, 5 July 2009 diff hist +21 User:Woozle →Software: datamgr

2 July 2009

• 23:5023:50, 2 July 2009 diff hist −19 m VbzCart/tables →Catalog Entry: ctg_updates not needed
• 23:5023:50, 2 July 2009 diff hist +51 VbzCart/archive/tables ctg_updates now discarded
• 23:4823:48, 2 July 2009 diff hist +180 VbzCart/tables/ctg updates discarded current
• 23:4523:45, 2 July 2009 diff hist +71 VbzCart/tables/ctg prc funcs 7/2 implementation