VbzCart/tables: Revision history

11 March 2008

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

28 February 2008

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

27 February 2008

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

26 February 2008

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

25 February 2008

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

18 February 2008

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

17 February 2008

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

22 January 2008

• curprev 22:0322:03, 22 January 2008 Woozle talk contribs 55,381 bytes +224 →cat_items: CatSfx

12 December 2007

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

11 December 2007

• curprev 22:4722:47, 11 December 2007 Woozle talk contribs 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 Woozle talk contribs 54,867 bytes +1,646 →cat_pages: cat_ship_costs

1 December 2007

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

27 November 2007

• curprev 01:3401:34, 27 November 2007 Woozle talk contribs 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 Woozle talk contribs 52,685 bytes +50 →Navigation: related pages: customer tables

12 November 2007

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

11 November 2007

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

9 November 2007

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

8 November 2007

• curprev 15:5615:56, 8 November 2007 Woozle talk contribs 52,174 bytes +1,173 →ord_pkg_lines: ord_event_types, ord_events
• curprev 01:4801:48, 8 November 2007 Woozle talk contribs 51,001 bytes −4 →ord_pkg_lines: xINTx VARCHAR
• curprev 01:4401:44, 8 November 2007 Woozle talk contribs 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 Woozle talk contribs 50,980 bytes +7 →ord_pkgs: possibly fixed the problem
• curprev 00:3400:34, 8 November 2007 Woozle talk contribs 50,973 bytes +590 →Ordering: ord_pkg_lines definition

7 November 2007

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

5 November 2007

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

4 November 2007

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

31 October 2007

• curprev 20:1020:10, 31 October 2007 Woozle talk contribs 51,943 bytes +20 →rstk_items: changed field names for less ambiguity of meaning
• curprev 10:5310:53, 31 October 2007 Woozle talk contribs 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 Woozle talk contribs 51,846 bytes +92 →ord_lines: Seq field
• curprev 10:3910:39, 30 October 2007 Woozle talk contribs 51,754 bytes +8 →rstk_items: one line missing "COMMENT"
• curprev 10:3610:36, 30 October 2007 Woozle talk contribs 51,746 bytes +121 →core_restocks: added missing "COMMENT" keyword
• curprev 01:2001:20, 30 October 2007 Woozle talk contribs 51,625 bytes +1,595 →ord_lines: SQL to create table
• curprev 01:0101:01, 30 October 2007 Woozle talk contribs 50,030 bytes +2,748 →core_orders: SQL to create table

29 October 2007

• curprev 21:4421:44, 29 October 2007 Woozle talk contribs 47,282 bytes +3,076 →Restocking: core_restocks