issue #23241: add triggers, indexes, and api views and functions
authorSteve Hackbarth <stephenhackbarth@gmail.com>
Wed, 9 Apr 2014 02:12:14 +0000 (22:12 -0400)
committerSteve Hackbarth <stephenhackbarth@gmail.com>
Wed, 9 Apr 2014 02:12:14 +0000 (22:12 -0400)
commit7c18749b54192b1d191d8c990c261b1567db8bd6
tree2416be36b451d45ed3ec745ff72ba1323bcd9845
parent41b6c030efe9c783f71a78d6a2239e49907e6235
issue #23241: add triggers, indexes, and api views and functions
208 files changed:
foundation-database/api/functions/getcustnumberfrominfo.sql [new file with mode: 0644]
foundation-database/api/functions/insertsalesline.sql [new file with mode: 0644]
foundation-database/api/views/account.sql [new file with mode: 0644]
foundation-database/api/views/accountchar.sql [new file with mode: 0644]
foundation-database/api/views/accountcomment.sql [new file with mode: 0644]
foundation-database/api/views/accountfile.sql [new file with mode: 0644]
foundation-database/api/views/accountimage.sql [new file with mode: 0644]
foundation-database/api/views/address.sql [new file with mode: 0644]
foundation-database/api/views/addresschar.sql [new file with mode: 0644]
foundation-database/api/views/addresscomment.sql [new file with mode: 0644]
foundation-database/api/views/apmemo.sql [new file with mode: 0644]
foundation-database/api/views/armemo.sql [new file with mode: 0644]
foundation-database/api/views/bom.sql [new file with mode: 0644]
foundation-database/api/views/bomitem.sql [new file with mode: 0644]
foundation-database/api/views/bomitemcomment.sql [new file with mode: 0644]
foundation-database/api/views/bomitemsubstitute.sql [new file with mode: 0644]
foundation-database/api/views/budget.sql [new file with mode: 0755]
foundation-database/api/views/budgetentry.sql [new file with mode: 0755]
foundation-database/api/views/cashreceipt.sql [new file with mode: 0644]
foundation-database/api/views/cashreceiptapply.sql [new file with mode: 0644]
foundation-database/api/views/cashreceiptapplymisc.sql [new file with mode: 0644]
foundation-database/api/views/contact.sql [new file with mode: 0644]
foundation-database/api/views/contactchar.sql [new file with mode: 0644]
foundation-database/api/views/contactcomment.sql [new file with mode: 0644]
foundation-database/api/views/creditmemo.sql [new file with mode: 0644]
foundation-database/api/views/creditmemoline.sql [new file with mode: 0644]
foundation-database/api/views/custchar.sql [new file with mode: 0644]
foundation-database/api/views/custcomment.sql [new file with mode: 0644]
foundation-database/api/views/custcreditcard.sql [new file with mode: 0644]
foundation-database/api/views/customer.sql [new file with mode: 0644]
foundation-database/api/views/customertaxreg.sql [new file with mode: 0644]
foundation-database/api/views/customertype.sql [new file with mode: 0644]
foundation-database/api/views/customertypechar.sql [new file with mode: 0644]
foundation-database/api/views/custshipto.sql [new file with mode: 0644]
foundation-database/api/views/custtax.sql [new file with mode: 0644]
foundation-database/api/views/employee.sql [new file with mode: 0644]
foundation-database/api/views/employeechar.sql [new file with mode: 0644]
foundation-database/api/views/employeecomment.sql [new file with mode: 0644]
foundation-database/api/views/extshipmaint.sql [new file with mode: 0644]
foundation-database/api/views/freightpricingscheduleitem.sql [new file with mode: 0644]
foundation-database/api/views/glaccount.sql [new file with mode: 0644]
foundation-database/api/views/incident.sql [new file with mode: 0644]
foundation-database/api/views/incidentchar.sql [new file with mode: 0644]
foundation-database/api/views/incidentcomment.sql [new file with mode: 0644]
foundation-database/api/views/incidentfile.sql [new file with mode: 0644]
foundation-database/api/views/incidentimage.sql [new file with mode: 0644]
foundation-database/api/views/invoice.sql [new file with mode: 0644]
foundation-database/api/views/invoiceline.sql [new file with mode: 0644]
foundation-database/api/views/item.sql [new file with mode: 0644]
foundation-database/api/views/itemalias.sql [new file with mode: 0644]
foundation-database/api/views/itemchar.sql [new file with mode: 0644]
foundation-database/api/views/itemcomment.sql [new file with mode: 0644]
foundation-database/api/views/itemcost.sql [new file with mode: 0644]
foundation-database/api/views/itemfile.sql [new file with mode: 0644]
foundation-database/api/views/itemimage.sql [new file with mode: 0644]
foundation-database/api/views/itemsite.sql [new file with mode: 0644]
foundation-database/api/views/itemsitecomment.sql [new file with mode: 0644]
foundation-database/api/views/itemsource.sql [new file with mode: 0644]
foundation-database/api/views/itemsourceprice.sql [new file with mode: 0644]
foundation-database/api/views/itemsubstitute.sql [new file with mode: 0644]
foundation-database/api/views/itemtaxtype.sql [new file with mode: 0644]
foundation-database/api/views/itemuomconversion.sql [new file with mode: 0644]
foundation-database/api/views/journalentry.sql [new file with mode: 0644]
foundation-database/api/views/location.sql [new file with mode: 0644]
foundation-database/api/views/misccounttag.sql [new file with mode: 0644]
foundation-database/api/views/physinvcount.sql [new file with mode: 0644]
foundation-database/api/views/pricingschedule.sql [new file with mode: 0644]
foundation-database/api/views/pricingscheduleassign.sql [new file with mode: 0644]
foundation-database/api/views/pricingscheduleitem.sql [new file with mode: 0644]
foundation-database/api/views/pricingscheduleitemchar.sql [new file with mode: 0644]
foundation-database/api/views/project.sql [new file with mode: 0644]
foundation-database/api/views/projectcomment.sql [new file with mode: 0644]
foundation-database/api/views/prospect.sql [new file with mode: 0644]
foundation-database/api/views/purchaseline.sql [new file with mode: 0644]
foundation-database/api/views/purchaselinechar.sql [new file with mode: 0644]
foundation-database/api/views/purchaselinecomment.sql [new file with mode: 0644]
foundation-database/api/views/purchaseorder.sql [new file with mode: 0644]
foundation-database/api/views/purchaseordercomment.sql [new file with mode: 0644]
foundation-database/api/views/quote.sql [new file with mode: 0644]
foundation-database/api/views/quotecomment.sql [new file with mode: 0644]
foundation-database/api/views/quoteline.sql [new file with mode: 0644]
foundation-database/api/views/quotelinechar.sql [new file with mode: 0644]
foundation-database/api/views/quotelinecomment.sql [new file with mode: 0644]
foundation-database/api/views/salescredit.sql [new file with mode: 0644]
foundation-database/api/views/saleshistory.sql [new file with mode: 0644]
foundation-database/api/views/salesline.sql [new file with mode: 0644]
foundation-database/api/views/saleslinechar.sql [new file with mode: 0644]
foundation-database/api/views/saleslinecomment.sql [new file with mode: 0644]
foundation-database/api/views/salesorder.sql [new file with mode: 0644]
foundation-database/api/views/salesordercomment.sql [new file with mode: 0644]
foundation-database/api/views/salesrep.sql [new file with mode: 0644]
foundation-database/api/views/site.sql [new file with mode: 0644]
foundation-database/api/views/sitezone.sql [new file with mode: 0644]
foundation-database/api/views/task.sql [new file with mode: 0644]
foundation-database/api/views/taskcomment.sql [new file with mode: 0644]
foundation-database/api/views/todo.sql [new file with mode: 0644]
foundation-database/api/views/vendor.sql [new file with mode: 0644]
foundation-database/api/views/vendoraddress.sql [new file with mode: 0644]
foundation-database/api/views/vendortype.sql [new file with mode: 0644]
foundation-database/manifest.js
foundation-database/public/indexes/evntlog.sql [new file with mode: 0644]
foundation-database/public/indexes/invcitemtax.sql [new file with mode: 0644]
foundation-database/public/indexes/shipitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/accnt.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/addr.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/alarm.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/apapply.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/apopen.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/arapply.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/aropen.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/bomhead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/bomitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/bomitemsub.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cashrcpt.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cashrcptitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cashrcptmisc.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/ccard.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/char.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/charass.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/charopt.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/checkhead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cmhead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cmitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cntct.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cntslip.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cobill.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cobmisc.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cohead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/coitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/comment.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/company.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/contrct.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/crmacct.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/curr_rate.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/curr_symbol.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/cust.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/custtype.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/docass.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/emp.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/evntlog.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/gltrans.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/grppriv.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/imageass.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/incdt.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/invchead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/invcitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/invhist.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/ipsass.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/ipshead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/ipsitemchar.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/ipsiteminfo.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/item.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/itemcost.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/itemsite.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/itemsrc.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/itemsrcp.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/itemsub.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/itemtax.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/itemuomconv.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/location.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/metasql.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/ophead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pack.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/period.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkgcmd.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkgcmdarg.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkghead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkgimage.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkgitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkgmetasql.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkgpriv.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkgreport.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkgscript.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pkguiform.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pohead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/poitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/pr.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/prj.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/prjtask.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/prospect.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/quhead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/quitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/recur.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/report.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/salesrep.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/saletype.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/shipdata.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/shipdatasum.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/shipform.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/shiphead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/shiptoinfo.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/shipvia.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/sltrans.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/taxauth.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/terms.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/todoitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/uomconv.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/usrpref.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/usrpriv.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/vend.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/vendaddr.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/vodist.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/vohead.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/voitem.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/whsezone.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/whsinfo.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/wo.sql [new file with mode: 0644]
foundation-database/public/trigger_functions/womatl.sql [new file with mode: 0644]