User contributions for Woozle

12 March 2009

• 15:2515:25, 12 March 2009 diff hist −351 m MediaWiki/archive/customizing/URLs Reverted edits by LiaceLlial (Talk); changed back to last version by Woozle

11 March 2009

• 20:5920:59, 11 March 2009 diff hist +155 Microsoft/Windows/XP →Links: The Elder Geek

10 March 2009

• 22:0122:01, 10 March 2009 diff hist −9 m DVDs in Linux →Articles: updated hans.fugal.net link current
• 13:3613:36, 10 March 2009 diff hist +282 online banking guidelines bb&t no longer shows even daily balances

9 March 2009

• 11:2211:22, 9 March 2009 diff hist +73 VbzCart/procs upd_stkcontainers dropped
• 11:1911:19, 9 March 2009 diff hist +76 VbzCart/tables/ stk containers not used; use the query instead current
• 11:1811:18, 9 March 2009 diff hist +17 VbzCart/procs/Upd StkContainers updates: correct name of query to use; this is not used current

8 March 2009

• 21:2221:22, 8 March 2009 diff hist −34,639 VbzCart/tables moved the rest of the tables and procs into separate pages; removed obsolete table-design notes
• 21:2121:21, 8 March 2009 diff hist +115 VbzCart/procs/Upd Depts fr DeptIttyps more doc
• 21:2021:20, 8 March 2009 diff hist +105 VbzCart/procs/Upd Depts fr Depts Suppliers updated source table names; more doc
• 21:1521:15, 8 March 2009 diff hist +2 m VbzCart/procs fixed a link
• 21:1021:10, 8 March 2009 diff hist +1,719 N VbzCart/tables/event log New page: ==About== * '''Purpose''': admin error/message log * '''Notes''': ** This is a log specifically of administration activity (shipping, catalog updates, etc.) so should probably be renamed a...
• 21:0221:02, 8 March 2009 diff hist +934 N VbzCart/tables/cache log New page: ==About== * '''Purpose''': Log of all cache updates performed * '''Notes''': ** The stored procedures don't automatically update this log; that is handled by the DataMgr classes. ==SQL== <...
• 21:0021:00, 8 March 2009 diff hist +653 N VbzCart/tables/cache flow New page: ==About== * '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXIS...
• 20:5820:58, 8 March 2009 diff hist +617 N VbzCart/tables/cache queries New page: ==About== * '''Purpose''': List of stored procedures which update one table from others ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `data_procs`; CREATE T...
• 20:5620:56, 8 March 2009 diff hist +539 N VbzCart/tables/cache tables New page: ==About== * '''Purpose''': List of tables involved in data caching (either as a source or as a cache) ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `data_tables`; CREATE TABLE ...
• 20:5220:52, 8 March 2009 diff hist +1,367 N VbzCart/procs/Upd StkContainers New page: ==About== * '''Purpose''' update (replace/fill) {{vbzcart|table|_stk_containers}} * '''Status''': in progress; Packages and Restocks were not yet migrated when this was designed, but they ...
• 20:4320:43, 8 March 2009 diff hist +901 N VbzCart/tables/ stk containers New page: ==About== * '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table * '''Fields''': ** '''Name''': auto-generated but hopefully somewhat descript...
• 20:4020:40, 8 March 2009 diff hist +1,130 N VbzCart/procs/Upd SupplierIttyps New page: ==About== * '''Input''': {{vbzcart|table|cat_supp}}, {{vbzcart|table|_titles}}, {{vbzcart|table|_title_ittyps}}, {{vbzcart|table|cat_ittyps}} * '''Output''': {{vbzcart|table|_supplier_itty...
• 20:1920:19, 8 March 2009 diff hist +377 N VbzCart/tables/ supplier ittyps New page: ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `_supplier_ittyps`; CREATE TABLE `_supplier_ittyps` ( `ID` int(11) unsigned NOT NULL, `ItemType` varchar(63) NOT NULL, `It...
• 20:1820:18, 8 March 2009 diff hist +395 N VbzCart/procs/Upd DeptIttyps fr CatIttyps New page: ==About== * '''Input''': {{vbzcart|table|cat_ittyps}} * '''Output''': {{vbzcart|table|_dept_ittyps}} (update) ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_DeptIttyps_fr_CatItty...
• 20:1620:16, 8 March 2009 diff hist +527 N VbzCart/procs/Upd DeptIttyps fr TitleIttyps New page: ==About== * '''Input''': {{vbzcart|table|_title_ittyps}} (grouped by ID_ItTyp, ID_Dept) * '''Output''': {{vbzcart|table|_dept_ittyps}} (replace) ==SQL== <section begin=sql /><mysql>CREATE ...
• 20:1320:13, 8 March 2009 diff hist +572 N VbzCart/tables/ dept ittyps New page: ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`; CREATE TABLE `_dept_ittyps` ( `ID_ItTyp` int unsigned NOT NULL, `ID_Dept` int unsigned NOT NULL, `cntFor...
• 20:0120:01, 8 March 2009 diff hist +419 N VbzCart/procs/Upd TitleIttyps fr CatIttyps New page: ==About== * '''Input''': {{vbzcart|table|cat_ittyps}} * '''Output''': {{vbzcart|table|_title_ittyps}} (update) ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_TitleIttyps_fr_CatIt...
• 19:5919:59, 8 March 2009 diff hist +354 N VbzCart/procs/Upd TitleIttyps fr Titles New page: ==About== * '''Input''': {{vbzcart|table|_titles}} * '''Output''': {{vbzcart|table|_title_ittyps}} (update) ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_TitleIttyps_fr_Titles()...
• 19:5719:57, 8 March 2009 diff hist +1,611 N VbzCart/procs/Upd TitleIttyps fr CatItems Titles New page: ==About== * '''Purpose''': fills {{vbzcart|table|_title_ittyps}}. * '''Input''': {{vbzcart|table|cat_items}}, {{vbzcart|table|cat_titles}} * '''Output''': {{vbzcart|table|_title_ittyps}} (...
• 19:4819:48, 8 March 2009 diff hist +1,453 N VbzCart/tables/ title ittyps New page: ==About== * '''Purpose''': list of available titles for each item type * '''History''': ** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line it...
• 19:4419:44, 8 March 2009 diff hist +679 N VbzCart/procs/Upd Titles fr TitleIttyps New page: ==About== * '''Purpose''': Updates some fields in {{vbzcart|table|_titles}} * '''Input''': {{vbzcart|table|_title_ittyps}}, grouped by ID_Title * '''Output''': {{vbzcart|table|_titles}} (u...
• 19:4119:41, 8 March 2009 diff hist +736 N VbzCart/procs/Upd Titles fr CatItems New page: ==About== * '''Purpose''': sets some fields in {{vbzcart|table|_titles}} after that has been filled in by {{vbzcart|proc|Upd_Titles_fr_Depts}} ==SQL== <section begin=sql /><mysql>CREATE PR...
• 19:3819:38, 8 March 2009 diff hist +455 N VbzCart/procs/Upd Titles fr Depts New page: ==About== * '''Purpose''': Fills {{vbzcart|table|_titles}} ==SQL== <section begin=sql /><mysql> CREATE PROCEDURE Upd_Titles_fr_Depts() REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb) ...
• 19:3619:36, 8 March 2009 diff hist +742 N VbzCart/tables/ titles New page: ==About== * '''Purpose''': cached information about titles ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_titles`; CREATE TABLE `_titles` ( `ID` int(11) unsigned NOT NULL,...
• 19:3519:35, 8 March 2009 diff hist +654 N VbzCart/procs/Upd Depts fr DeptIttyps New page: ==About== * '''Purpose''': Updates some fields in {{vbzcart|table|_depts}} after that has been filled in by {{vbzcart|proc|Upd_Depts_fr_Depts_Suppliers}} ==SQL== <section begin=sql /><mysq...
• 19:3119:31, 8 March 2009 diff hist +746 N VbzCart/procs/Upd Depts fr Depts Suppliers New page: ==About== * '''Purpose''': fills {{vbzcart|table|_depts}} (does not set inPrint/inStock fields) ==SQL== <section begin=sql /><mysql> CREATE PROCEDURE Upd_Depts_fr_Depts_Suppliers() BE...
• 19:2919:29, 8 March 2009 diff hist +632 N VbzCart/tables/ depts New page: ==About== * '''Purpose''': Calculated information about departments ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_depts`; CREATE TABLE `_depts` ( `ID` int(11) unsigned NO... current
• 19:2519:25, 8 March 2009 diff hist +646 N VbzCart/archive/tables New page: ==updates== * '''Purpose''': timestamps on tables so we know when update queries need to be run * '''Status''': probably superceded by data flow tables and procs ===SQL=== <section begin=s...
• 19:2019:20, 8 March 2009 diff hist +437 N VbzCart/tables/var global New page: ==About== * '''Status''': not currently being used, but is probably needed for proper stats display in controlbar * '''Purpose''':computed variables, cache timestamps, and other variable s...
• 19:1819:18, 8 March 2009 diff hist +373 N VbzCart/tables/cat title x topic New page: ==About== * '''Status''': under development; may end up not being used ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_titles_x_topics`; CREATE TABLE `brs_titles_x_topics` ( ...
• 19:1719:17, 8 March 2009 diff hist +978 N VbzCart/tables/cat topic New page: ==About== * '''Status''': Under development. May end up not being used. ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_topics`; CREATE TABLE `brs_topics` ( `ID` INT...
• 19:1219:12, 8 March 2009 diff hist +732 N VbzCart/tables/shop log New page: ==About== * '''Status''': design is under construction * '''Purpose''': logs customer movement through the store, for analysis of usage patterns and looking for problems ==SQL== <section b... current
• 19:1019:10, 8 March 2009 diff hist +618 N VbzCart/tables/shop cart data type New page: ==About== * '''Purpose''': This table is probably unnecessary, but I can't convince myself of that. If nothing else, it will help prevent inconsistent usage. It might be useful for reports...
• 19:0719:07, 8 March 2009 diff hist +558 N VbzCart/tables/shop cart data New page: ==About== * '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order. ==SQL== <section begin=sql /><mysql>DROP TAB...
• 19:0619:06, 8 March 2009 diff hist +1,479 N VbzCart/tables/shop cart line New page: ==About== * '''Purpose''': individual items in a shopping cart; child table of {{vbzcart|table|shop_carts}} ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_lines`; CREA...
• 18:5918:59, 8 March 2009 diff hist +1,387 N VbzCart/tables/shop cart New page: ==About== * '''Purpose''': Shopping cart data is kept separate from order data because we end up with a lot of carts that never become orders; eventually they get cleaned out. Order data m...
• 18:5818:58, 8 March 2009 diff hist +842 N VbzCart/tables/ctg upd2 New page: ==About== * '''Purpose''': Experimental, but hopefully will replace {{vbzcart|table|ctg_updates}} which never worked entirely properly. ==SQL== <section begin=sql /><mysql>CREATE TABLE `ct... current
• 18:5618:56, 8 March 2009 diff hist +1,058 N VbzCart/tables/ctg upd1 New page: ==About== * '''Purpose''': Experimental, but hopefully will replace {{vbzcart|table|ctg_updates}} which never worked entirely properly. This table contains only the essential fields from {...
• 18:5418:54, 8 March 2009 diff hist +2,201 N VbzCart/tables/ctg updates New page: ==About== * '''Purpose''': There may be a better way to do this, but haven't been able to figure it out yet. This table keeps track of the correspondence between {items as generated from t...
• 18:5118:51, 8 March 2009 diff hist +940 N VbzCart/tables/ctg items New page: ==About== * '''Purpose''': Specifies which item varieties/prices are available in a group ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_items` ( ID INT NOT NULL AUTO_...
• 18:5018:50, 8 March 2009 diff hist +1,102 N VbzCart/tables/ctg titles New page: ==About== * '''Purpose''': Specifies which groups a title belongs to ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_titles` ( ID INT NOT NULL AUTO_INCREMENT, ID_Title ...
• 18:4918:49, 8 March 2009 diff hist +1,201 N VbzCart/tables/ctg groups New page: ==About== * '''Purpose''': Master list of groups (CTGs) * '''Fields''': ** '''ID_Supplier''': supplier to which this group applies; NULL = no fixed supplier, can be used for any of them **...
• 18:4418:44, 8 March 2009 diff hist +203 VbzCart/tables/ctg sources shortened SQL doc lines a bit by moving longer explanations to "about"