VbzCart/tables: Revision history

8 March 2009

• curprev 21:2221:22, 8 March 2009 Woozle talk contribs 6,725 bytes −34,639 moved the rest of the tables and procs into separate pages; removed obsolete table-design notes

29 December 2008

• curprev 18:5018:50, 29 December 2008 Woozle talk contribs 41,364 bytes −4,134 →Stock Management: moved all tables to separate pages; +stock_history_legacy

27 December 2008

• curprev 18:2118:21, 27 December 2008 Woozle talk contribs 45,498 bytes +85 →Ordering: ord_trxact, ord_trx_type
• curprev 15:3415:34, 27 December 2008 Woozle talk contribs 45,413 bytes −9,431 →Ordering: extracted tables to their own pages; added ord_shipmt
• curprev 03:1203:12, 27 December 2008 Woozle talk contribs 54,844 bytes −1,765 →stk_history: extracted stk_history to separate page

6 December 2008

• curprev 16:0216:02, 6 December 2008 Woozle talk contribs m 56,609 bytes −22 →Catalog: better description (did *I* write that garbledygook?)
• curprev 16:0016:00, 6 December 2008 Woozle talk contribs 56,631 bytes −12,079 →Catalog: tables extracted to separate pages

30 November 2008

• curprev 16:0216:02, 30 November 2008 Woozle talk contribs 68,710 bytes +97 →cat_supp: +Notes field

25 November 2008

• curprev 23:1923:19, 25 November 2008 Woozle talk contribs 68,613 bytes +71 →Restocking: rstk req item minima

21 November 2008

• curprev 01:4501:45, 21 November 2008 Woozle talk contribs 68,542 bytes +677 →core_orders: field reshuffling

15 November 2008

• curprev 03:0203:02, 15 November 2008 Woozle talk contribs 67,865 bytes +96 →stk_history: +QtyFound
• curprev 03:0003:00, 15 November 2008 Woozle talk contribs 67,769 bytes +93 →stk_bins: +WhenTainted

8 November 2008

• curprev 02:0102:01, 8 November 2008 Woozle talk contribs 67,676 bytes +39 →Restocking: new names

7 November 2008

• curprev 18:1918:19, 7 November 2008 Woozle talk contribs 67,637 bytes −3,198 →Restocking: one more table extracted to a separate page; renamed new tables to use singular
• curprev 17:5217:52, 7 November 2008 Woozle talk contribs 70,835 bytes −1,917 →rstk_items: split tables off into separate pages
• curprev 17:1517:15, 7 November 2008 Woozle talk contribs m 72,752 bytes −12 →Navigation: post-move updates
• curprev 17:1317:13, 7 November 2008 Woozle talk contribs m 72,764 bytes 0 VbzCart tables moved to VbzCart/tables: makes use of subpage features, and makes it clear that this is a subtopic of VbzCart

8 June 2008

• curprev 23:5023:50, 8 June 2008 Woozle talk contribs 72,764 bytes +238 →shop_clients: using CRC32 instead of compressed string
• curprev 16:0516:05, 8 June 2008 Woozle talk contribs 72,526 bytes +1,264 →Shopping: shop_log, shop_clients under construction
• curprev 14:5414:54, 8 June 2008 Woozle talk contribs m 71,262 bytes +190 →error/message log: specifically for admin activity
• curprev 14:4814:48, 8 June 2008 Woozle talk contribs m 71,072 bytes +64 →shop_carts: ID_Session is TBI
• curprev 14:4314:43, 8 June 2008 Woozle talk contribs 71,008 bytes +838 →Shopping: shop_cust_data, shop_cust_data_types; removed old description of "ord_cart_items"
• curprev 13:3413:34, 8 June 2008 Woozle talk contribs m 70,170 bytes +1 →shop_cart_lines: fixed wrong quote char

24 May 2008

• curprev 16:0216:02, 24 May 2008 Woozle talk contribs 70,169 bytes +67 →=shop_cart_lines: fixed indent; +CatNum
• curprev 16:0016:00, 24 May 2008 Woozle talk contribs 70,102 bytes +1,933 →Shopping: preliminary SQL for carts & cart lines
• curprev 15:4815:48, 24 May 2008 Woozle talk contribs m 68,169 bytes −1 →stk_items: format tweak

22 May 2008

• curprev 23:0723:07, 22 May 2008 Woozle talk contribs 68,170 bytes +456 →cat_images: WebSpec

15 May 2008

• curprev 21:2721:27, 15 May 2008 Woozle talk contribs 67,714 bytes +233 →rstk_items: two timestamp fields

13 April 2008

• curprev 13:2213:22, 13 April 2008 Woozle talk contribs 67,481 bytes +584 →cat_images: added FileFerret columns

4 April 2008

• curprev 20:0620:06, 4 April 2008 Woozle talk contribs 66,897 bytes 0 →ctg_upd2: QtyMin_Stock -> QtyMin_Stk to match cat_items

30 March 2008

• curprev 15:3415:34, 30 March 2008 Woozle talk contribs 66,897 bytes +14 →cat_pages: updated _cat_pages to use non-cached data only

27 March 2008

• curprev 14:5714:57, 27 March 2008 Woozle talk contribs 66,883 bytes +71 →cat_images: +isActive field

26 March 2008

• curprev 13:4913:49, 26 March 2008 Woozle talk contribs 66,812 bytes −25 →ctg_upd1: cntDups isn't needed here; any duplicates indicate a problem with the source data
• curprev 12:5712:57, 26 March 2008 Woozle talk contribs 66,837 bytes +7 →ctg_upd2: don't preserve CatNum

23 March 2008

• curprev 22:5822:58, 23 March 2008 Woozle talk contribs 66,830 bytes +25 →ctg_upd2: ID_Item needs to be a key too, for the last join to cat_items
• curprev 21:4421:44, 23 March 2008 Woozle talk contribs 66,805 bytes +100 →ctg_upd2: +isForSale

22 March 2008

• curprev 22:0422:04, 22 March 2008 Woozle talk contribs 66,705 bytes +4 →ctg_upd2: CatNum is sometimes NULL in cat_items because old items may get returned to use
• curprev 21:5021:50, 22 March 2008 Woozle talk contribs 66,701 bytes +82 →stk_history: Qty -> QtyDone, +QtyLeft so we have an ongoing record of whether the stock qty was being correctly adjusted
• curprev 21:4821:48, 22 March 2008 Woozle talk contribs 66,619 bytes −2 →ctg_upd2: CatNum NOT NULL
• curprev 21:4521:45, 22 March 2008 Woozle talk contribs 66,621 bytes +94 →ctg_upd2: +CatNum

20 March 2008

• curprev 19:3519:35, 20 March 2008 Woozle talk contribs 66,527 bytes −20 →ctg_upd2: some fields in cat_items need to be preserved, so we have to save them here

19 March 2008

• curprev 15:4815:48, 19 March 2008 Woozle talk contribs m 66,547 bytes +88 →ctg_upd2: note about isActive
• curprev 15:4415:44, 19 March 2008 Woozle talk contribs 66,459 bytes −513 →Catalog Entry: moved queries to Catalog Building; added link for easy reference
• curprev 12:1812:18, 19 March 2008 Woozle talk contribs 66,972 bytes −1,017 →ctg_upd* data building: moved to Catalog Building page

18 March 2008

• curprev 12:3512:35, 18 March 2008 Woozle talk contribs 67,989 bytes +643 →ctg_upd* data building: saving this much for now; not tested

17 March 2008

• curprev 17:3617:36, 17 March 2008 Woozle talk contribs m 67,346 bytes +16 →ctg_upd1: actually, I added a couple of debugging fields to qryCtg_src
• curprev 17:3417:34, 17 March 2008 Woozle talk contribs 67,330 bytes +1,963 →ctg_upd2: ctg_upd* data building

16 March 2008

• curprev 02:5802:58, 16 March 2008 Woozle talk contribs 65,367 bytes +511 →ctg_updates: ctg_upd2

13 March 2008

• curprev 20:4720:47, 13 March 2008 Woozle talk contribs 64,856 bytes +15 →ctg_updates: changed primary key to IDS_Item; ID_Item is autonumber

12 March 2008

• curprev 15:0315:03, 12 March 2008 Woozle talk contribs m 64,841 bytes 0 →cat_ship_costs: surplus comma removal