SCRIPT-db_create-v-016
[previously]
- [REFERENCE] HAVE
- ] # # - script.sql create-database - ovu, status
- [2014-12-dd] # # - CREATE-FILE-script-v-016.sql -
- x] used v-015 - thinking that I have already made some of these changes
- x] CREATE doc records
- x] # 4568 - v-015
- x] # 4569 - v-016 -
- x] REVIEW notes from records db-v-014
- *] notes show that some of these changes have been made (DROP tables ]books in lib, ] chapters ...
- x] explains process of constructing CREATE script FROM ....
- x] RESET all auto increment #'s
- x] to 1
- x] REMOVEd - tables
- x] webpages-membership
- x] tech-hw (custom)
- x] viewBooksInLibrary,
- x] viewChaptersInBook
- x] ADD
- x] photo field to table books as per notes v-014
- [2014-12-dd] REVIEW notes from record CREATE-db-v-013
- x] completed - no additional changes requried
- [2014-12-dd] TEST - script-db-create-v-016
- x] navigate to existing,empty db(db18)
- x] sql - paste entire script into
- x] RESULT = 31/32 tables created successfully
- x] ERROR(s) = 1, view buying - see details below
- *] NOTES = view priority and view priority1 are listed as tables, NOT as views
- [2014-12-26] FIX PRB - ERROR db-create
- x] download 'view creation script' from current db
- x] COMPARE - to script in RESULT= dont see the difference
- x] swap code for view-buying
- x] TRY - generate view with new script RESULT=PASS
[currently]
- ]
[next]
- ]
ERROR
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`donS2`@`%` SQL SECURITY DEFINER VIEW `view_buying` AS select `items`.`id_item` AS `id_item`,`items`.`name_item` AS `name_item`,`items`.`description_item` AS `description_item`,`items`.`parent_id` AS `parent_id`,`items`.`cogs` AS `cogs`,`items`.`quantity` AS `quantity`,`items`.`unit` AS `unit`,`items`.`content_item` AS `content_item`,`items`.`content_format` AS `content_format`,`items`.`photo` AS `photo`,`items`.`status` AS `status`,`items`.`owner` AS `owner`,`items`.`priority` AS `priority`,`itemcategories`.`name_itemCategory` AS `name_itemCategory`,`itemcategories`.`id_itemCategory` AS `id_itemCategory`,`itemcategories`.`parent_id` AS `parent_id_itemCategory`,`inventories`.`name_inventory` AS `name_inventory`,`inventories`.`id_inventory` AS `id_inventory`,`inventories`.`parent_id` AS `inventory_parent_id`,`warehouses`.`name_warehouse` AS `name_warehouse`,`warehouses`.`id_wareh[...]
MySQL said: 
#1054 - Unknown column 'itemcategories.
name_itemCategory' in 'order clause'