VbzCart/docs/tables: Revision history

29 October 2007

• curprev 01:2601:26, 29 October 2007‎ imported>Woozle‎ 44,113 bytes +2,030‎ →‎Ordering: first pass at rstk_items; some name changes

28 October 2007

• curprev 21:2921:29, 28 October 2007‎ imported>Woozle‎ 42,083 bytes −122‎ →‎cat_depts: renamed table in SQL; note about eventual obsolescence
• curprev 20:1120:11, 28 October 2007‎ imported>Woozle‎ m 42,205 bytes −11‎ →‎cat_suppliers: -> cat_supp
• curprev 19:5819:58, 28 October 2007‎ 65.87.181.82 talk‎ 42,216 bytes −3‎ →‎cat_suppliers: consolidated; updated
• curprev 19:3119:31, 28 October 2007‎ imported>Woozle‎ m 42,219 bytes −81‎ →‎Navigation: using navbar inclusion

20 October 2007

• curprev 18:5818:58, 20 October 2007‎ imported>Woozle‎ 42,300 bytes +112‎ →‎brs_topics: sort; tidied column

18 October 2007

• curprev 23:3923:39, 18 October 2007‎ imported>Woozle‎ m 42,188 bytes +27‎ →‎brs_topics: section for new table
• curprev 23:3823:38, 18 October 2007‎ imported>Woozle‎ 42,161 bytes +252‎ →‎brs_topics: titles x topics
• curprev 22:5922:59, 18 October 2007‎ imported>Woozle‎ 41,909 bytes +62‎ →‎brs_topics: fixed a few syntax glitches; works now.

17 October 2007

• curprev 14:0914:09, 17 October 2007‎ imported>Woozle‎ 41,847 bytes −345‎ →‎_title_ittyps: wrong... these don't belong here.
• curprev 14:0114:01, 17 October 2007‎ imported>Woozle‎ 42,192 bytes +91‎ →‎cat_items: note about sorting
• curprev 13:5913:59, 17 October 2007‎ imported>Woozle‎ 42,101 bytes +345‎ →‎_title_ittyps: added GrpCode, GrpDescr, GrpSort
• curprev 13:4713:47, 17 October 2007‎ imported>Woozle‎ m 41,756 bytes +87‎ →‎Future Changes: probably obsolete
• curprev 13:4613:46, 17 October 2007‎ imported>Woozle‎ 41,669 bytes −341‎ →‎Stored Procedures: probably wrong, and definitely not used; rewrite from scratch when needed.
• curprev 13:4513:45, 17 October 2007‎ imported>Woozle‎ 42,010 bytes −8,985‎ →‎table-filler functions: moved all filler functions so they are underneath the definition for the table they fill
• curprev 13:4313:43, 17 October 2007‎ imported>Woozle‎ 50,995 bytes +7,259‎ →‎Calculated Tables: moved filler procedures here from separate section
• curprev 13:0513:05, 17 October 2007‎ imported>Woozle‎ 43,736 bytes +1,321‎ →‎Tables: moved some update procedures to go with the tables they update; GrpSort

16 October 2007

• curprev 20:0020:00, 16 October 2007‎ imported>Woozle‎ 42,415 bytes +86‎ →‎cat_items: GrpCode and GrpDescr

13 October 2007

• curprev 02:2602:26, 13 October 2007‎ imported>Woozle‎ 42,329 bytes +319‎ →‎v_stk_byItemAndBin_wItemInfo: wInfo version which also has Bin info

12 October 2007

• curprev 21:2621:26, 12 October 2007‎ imported>Woozle‎ 42,010 bytes +192‎ →‎v_stk_byItemAndBin: wItemInfo version

26 September 2007

• curprev 22:3322:33, 26 September 2007‎ imported>Woozle‎ m 41,818 bytes −17‎ spam reversion
• curprev 21:5321:53, 26 September 2007‎ 209.200.38.173 talk‎ 41,835 bytes +7‎ No edit summary
• curprev 21:4821:48, 26 September 2007‎ 222.240.208.14 talk‎ 41,828 bytes +10‎ No edit summary

22 September 2007

• curprev 23:5823:58, 22 September 2007‎ imported>Woozle‎ 41,818 bytes +739‎ →‎stk_bin_history: browsing: brs_topics - first draft

21 September 2007

• curprev 11:1911:19, 21 September 2007‎ imported>Woozle‎ 41,079 bytes +18‎ →‎_title_ittyps <- (3 different procedures): forgot to include cntInStock in insertion list

20 September 2007

• curprev 23:2623:26, 20 September 2007‎ imported>Woozle‎ 41,061 bytes +123‎ →‎_title_ittyps <- (3 different procedures): cntInStock calculation
• curprev 23:1323:13, 20 September 2007‎ imported>Woozle‎ 40,938 bytes +274‎ →‎_title_ittyps: added cntInStock field
• curprev 22:2022:20, 20 September 2007‎ imported>Woozle‎ 40,664 bytes +179‎ →‎_title_ittyps <- (3 different procedures): removed WHERE i.isForSale clause

23 August 2007

• curprev 13:1713:17, 23 August 2007‎ imported>Woozle‎ 40,485 bytes +310‎ →‎v_stk_items_remaining: v_stk_byItemAndBin
• curprev 11:2011:20, 23 August 2007‎ imported>Woozle‎ 40,175 bytes +268‎ →‎v_stk_items_remaining: "items_remaining" is grouped by item; original query renamed to "lines_remaining"
• curprev 02:2502:25, 23 August 2007‎ imported>Woozle‎ 39,907 bytes +378‎ →‎v_stk_items_remaining: separate Qty fields for different Bin conditions
• curprev 02:2002:20, 23 August 2007‎ imported>Woozle‎ m 39,529 bytes −17‎ →‎stk_bins: fixed broken comment
• curprev 02:0902:09, 23 August 2007‎ imported>Woozle‎ 39,546 bytes +261‎ →‎stk_bins: added isForShip field

22 August 2007

• curprev 12:5412:54, 22 August 2007‎ imported>Woozle‎ m 39,285 bytes +26‎ →‎v_items: used by clsItemsExt

15 August 2007

• curprev 21:5221:52, 15 August 2007‎ imported>Woozle‎ 39,259 bytes +484‎ →‎v_titles: v_items (original version)

27 July 2007

• curprev 19:0019:00, 27 July 2007‎ imported>Woozle‎ m 38,775 bytes 0‎ →‎cat_items: realized that "Qty" should come first
• curprev 18:3318:33, 27 July 2007‎ imported>Woozle‎ 38,775 bytes +65‎ →‎cat_items: MinQty_Stk

11 July 2007

• curprev 02:1302:13, 11 July 2007‎ imported>Woozle‎ 38,710 bytes +11‎ →‎v_stk_items_remaining: CatNum

10 July 2007

• curprev 17:4817:48, 10 July 2007‎ imported>Woozle‎ 38,699 bytes +558‎ →‎stk_history: stk_bin_history

6 July 2007

• curprev 12:2612:26, 6 July 2007‎ imported>Woozle‎ 38,141 bytes +178‎ →‎error/message log: ditched EvWhenFinished
• curprev 12:0012:00, 6 July 2007‎ imported>Woozle‎ 37,963 bytes +83‎ →‎error/message log: EvWhen -> EvWhenStart + EvWhenFinish
• curprev 01:1301:13, 6 July 2007‎ imported>Woozle‎ m 37,880 bytes +70‎ →‎error/message log: Notes field

5 July 2007

• curprev 18:2818:28, 5 July 2007‎ imported>Woozle‎ 37,810 bytes +101‎ →‎stk_items: CatNum field

4 July 2007

• curprev 00:1100:11, 4 July 2007‎ imported>Woozle‎ 37,709 bytes +5‎ →‎v_stk_items_remaining: added missing WhenChanged field; renamed QtyAvail back to Qty for class compatibility

3 July 2007

• curprev 21:3121:31, 3 July 2007‎ imported>Woozle‎ 37,704 bytes +128‎ →‎cat_items: ItOpt_Sort field
• curprev 19:3719:37, 3 July 2007‎ imported>Woozle‎ m 37,576 bytes −5‎ →‎cat_titles: primary key for ID
• curprev 19:3619:36, 3 July 2007‎ imported>Woozle‎ m 37,581 bytes +5‎ →‎cat_items: fixed comments
• curprev 14:2414:24, 3 July 2007‎ imported>Woozle‎ 37,576 bytes +314‎ →‎error/message log: user/machine fields
• curprev 14:0214:02, 3 July 2007‎ imported>Woozle‎ 37,262 bytes +803‎ →‎data_log: message log

2 July 2007

• curprev 00:1200:12, 2 July 2007‎ imported>Woozle‎ 36,459 bytes +36,459‎ post-import tidying