VbzCart/docs/tables: Revision history

12 March 2008

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

11 March 2008

• curprev 21:4921:49, 11 March 2008‎ imported>Woozle‎ 64,841 bytes +55‎ →‎ctg_prc_funcs: "Notes" field (from original)
• curprev 18:5118:51, 11 March 2008‎ imported>Woozle‎ 64,786 bytes +1,071‎ →‎Catalog Entry: ctg_supp, ctg_prc_funcs (not tested)

28 February 2008

• curprev 20:4820:48, 28 February 2008‎ imported>Woozle‎ 63,715 bytes +631‎ →‎ctg_updates: isActive
• curprev 19:5019:50, 28 February 2008‎ imported>Woozle‎ m 63,084 bytes +19‎ →‎ctg_updates: index for IDS_Item

27 February 2008

• curprev 16:4016:40, 27 February 2008‎ imported>Woozle‎ 63,065 bytes +35‎ →‎ctg_updates: fixed SQL so it's acceptable; added index
• curprev 16:3016:30, 27 February 2008‎ imported>Woozle‎ 63,030 bytes +1,336‎ →‎Catalog Entry: ctg_updates

26 February 2008

• curprev 22:5422:54, 26 February 2008‎ imported>Woozle‎ 61,694 bytes −7‎ →‎ctg_sources: using "source
• curprev 22:5322:53, 26 February 2008‎ imported>Woozle‎ 61,701 bytes +1,020‎ →‎Catalog Entry: ctg_sources

25 February 2008

• curprev 16:5716:57, 25 February 2008‎ imported>Woozle‎ m 60,681 bytes −81‎ →‎Related Pages: moved SQL page link to main VbzCart page
• curprev 02:5302:53, 25 February 2008‎ imported>Woozle‎ 60,762 bytes +81‎ →‎Related Pages: link to VbzCart SQL
• curprev 00:5000:50, 25 February 2008‎ imported>Woozle‎ m 60,681 bytes +2,179‎ added transcludable sections to all SQL code

18 February 2008

• curprev 00:3900:39, 18 February 2008‎ imported>Woozle‎ 58,502 bytes +802‎ →‎ctg_items: defined
• curprev 00:1600:16, 18 February 2008‎ imported>Woozle‎ 57,700 bytes +986‎ →‎ctg_titles: defined
• curprev 00:0900:09, 18 February 2008‎ imported>Woozle‎ 56,714 bytes +633‎ →‎Catalog Entry: finished ctg_groups definition

17 February 2008

• curprev 19:5919:59, 17 February 2008‎ imported>Woozle‎ 56,081 bytes +700‎ →‎Catalog: saving for now; Windows being flaky

22 January 2008

• curprev 22:0322:03, 22 January 2008‎ imported>Woozle‎ 55,381 bytes +224‎ →‎cat_items: CatSfx

12 December 2007

• curprev 13:1613:16, 12 December 2007‎ imported>Woozle‎ 55,157 bytes +277‎ →‎_titles: min & max selling prices per title

11 December 2007

• curprev 22:4722:47, 11 December 2007‎ imported>Woozle‎ 54,880 bytes +13‎ →‎cat_pages: Upd_CatPages() now gets its data from a view; slight revision to SQL to avoid dept path conflicts. Still some ambiguity.

8 December 2007

• curprev 18:4518:45, 8 December 2007‎ imported>Woozle‎ 54,867 bytes +1,646‎ →‎cat_pages: cat_ship_costs

1 December 2007

• curprev 19:4719:47, 1 December 2007‎ imported>Woozle‎ 53,221 bytes +536‎ →‎ord_pkgs: WhenVoided: we're not deleting packages anymore

27 November 2007

• curprev 01:3401:34, 27 November 2007‎ imported>Woozle‎ m 52,685 bytes −9‎ Reverted edits by 208.48.253.137 (Talk); changed back to last version by Woozle

23 November 2007

• curprev 21:0321:03, 23 November 2007‎ 208.48.253.137 talk‎ 52,694 bytes +9‎ No edit summary

14 November 2007

• curprev 23:0823:08, 14 November 2007‎ imported>Woozle‎ 52,685 bytes +50‎ →‎Navigation: related pages: customer tables

12 November 2007

• curprev 12:3812:38, 12 November 2007‎ imported>Woozle‎ m 52,635 bytes +46‎ →‎Navigation: section for navbar
• curprev 12:3612:36, 12 November 2007‎ imported>Woozle‎ 52,589 bytes +148‎ →‎Ordering: link to new page about customer tables

11 November 2007

• curprev 23:0523:05, 11 November 2007‎ imported>Woozle‎ 52,441 bytes +45‎ →‎rstk_items: currency format conversion, like the others
• curprev 20:2220:22, 11 November 2007‎ imported>Woozle‎ 52,396 bytes +46‎ →‎core_restocks: another currency fix
• curprev 19:5919:59, 11 November 2007‎ imported>Woozle‎ 52,350 bytes +18‎ →‎ord_pkgs: converting currency INT -> DECIMAL
• curprev 19:3519:35, 11 November 2007‎ imported>Woozle‎ 52,332 bytes +28‎ →‎ord_lines: changed currency fields from integer cents to DECIMAL(9,2)
• curprev 19:1519:15, 11 November 2007‎ imported>Woozle‎ 52,304 bytes +27‎ →‎core_orders: converted currency from integer cents to DECIMAL(9,2)
• curprev 18:5118:51, 11 November 2007‎ imported>Woozle‎ 52,277 bytes +27‎ →‎cat_items: converted currency from integer cents to DECIMAL(9,2)
• curprev 17:4617:46, 11 November 2007‎ imported>Woozle‎ 52,250 bytes +18‎ →‎_title_ittyps: currMinPrice/currMaxPrice INT -> DECIMAL(9,2)

9 November 2007

• curprev 11:4811:48, 9 November 2007‎ imported>Woozle‎ 52,232 bytes +58‎ →‎ord_pkgs: oops, ID_Order is kind of important

8 November 2007

• curprev 15:5615:56, 8 November 2007‎ imported>Woozle‎ 52,174 bytes +1,173‎ →‎ord_pkg_lines: ord_event_types, ord_events
• curprev 01:4801:48, 8 November 2007‎ imported>Woozle‎ 51,001 bytes −4‎ →‎ord_pkg_lines: xINTx VARCHAR
• curprev 01:4401:44, 8 November 2007‎ imported>Woozle‎ 51,005 bytes +25‎ →‎ord_pkgs: apparently I have a near-complete inability to spot missing "COMMENT" keywords
• curprev 01:0201:02, 8 November 2007‎ imported>Woozle‎ 50,980 bytes +7‎ →‎ord_pkgs: possibly fixed the problem
• curprev 00:3400:34, 8 November 2007‎ imported>Woozle‎ 50,973 bytes +590‎ →‎Ordering: ord_pkg_lines definition

7 November 2007

• curprev 21:4221:42, 7 November 2007‎ imported>Woozle‎ 50,383 bytes +1,043‎ →‎ord_pkgs: definition
• curprev 02:0002:00, 7 November 2007‎ imported>Woozle‎ 49,340 bytes +349‎ →‎ord_lines: pkg tables -- saving work; not done.

5 November 2007

• curprev 12:2212:22, 5 November 2007‎ imported>Woozle‎ 48,991 bytes −3,230‎ →‎Views: moved over to "data views" page

4 November 2007

• curprev 14:3214:32, 4 November 2007‎ imported>Woozle‎ 52,221 bytes +278‎ →‎core_orders: sorting order

31 October 2007

• curprev 20:1020:10, 31 October 2007‎ imported>Woozle‎ 51,943 bytes +20‎ →‎rstk_items: changed field names for less ambiguity of meaning
• curprev 10:5310:53, 31 October 2007‎ imported>Woozle‎ 51,923 bytes +77‎ →‎core_orders: had to open up WhenStarted to NULL values because of legacy data

30 October 2007

• curprev 12:4312:43, 30 October 2007‎ imported>Woozle‎ 51,846 bytes +92‎ →‎ord_lines: Seq field
• curprev 10:3910:39, 30 October 2007‎ imported>Woozle‎ 51,754 bytes +8‎ →‎rstk_items: one line missing "COMMENT"
• curprev 10:3610:36, 30 October 2007‎ imported>Woozle‎ 51,746 bytes +121‎ →‎core_restocks: added missing "COMMENT" keyword
• curprev 01:2001:20, 30 October 2007‎ imported>Woozle‎ 51,625 bytes +1,595‎ →‎ord_lines: SQL to create table
• curprev 01:0101:01, 30 October 2007‎ imported>Woozle‎ 50,030 bytes +2,748‎ →‎core_orders: SQL to create table