Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

Search the wiki
»

Search in all Namespaces and all Categories
Search Files and Attachments

Filter by Category

This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.1 seconds and yielded 30 results.

public qrtz_triggers (table) — 9.8%

[...] wikibot Table public.qrtz_triggers Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group varchar(80) not null job_name varchar(80) not null job_group varchar(80) not null is_volatile boolean not null description varchar(120) null next_fire_time bigint null prev_fire_time bigint null trigger_state varchar(16) not null trigger_type varchar(8) not null start_time bigint not null end_time [...]

Purchasing PurchaseOrderDetail (table) — 8.9%

[...] ProductID ProductID Purchasing.PurchaseOrderHeader PurchaseOrderID PurchaseOrderID Triggers Trigger Type iPurchaseOrderDetail ON INSERT uPurchaseOrderDetail ON UPDATE Trigger iPurchaseOrderDetail CREATE TRIGGER [Purchasing].[iPurchaseOrderDetail] ON [Purchasing].[PurchaseOrderDetail] AFTER INSERT AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY INSERT INTO [Production].[TransactionHistory] ([ProductID] [...]

Sales SalesOrderHeader (table) — 6.1%

[...] SalesOrderID SalesOrderID Sales.SalesOrderHeaderSalesReason SalesOrderID SalesOrderID Triggers Trigger Type uSalesOrderHeader ON UPDATE Trigger uSalesOrderHeader CREATE TRIGGER [Sales].[uSalesOrderHeader] ON [Sales].[SalesOrderHeader] AFTER UPDATE NOT FOR REPLICATION AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY -- Update RevisionNumber for modification of any field EXCEPT the Status. IF NOT UPDATE([Status]) [...]

Sales SalesOrderDetail (table) — 4.9%

[...] SalesOrderID SalesOrderID Sales.SpecialOfferProduct SpecialOfferID SpecialOfferID Triggers Trigger Type iduSalesOrderDetail ON INSERT UPDATE DELETE Trigger iduSalesOrderDetail CREATE TRIGGER [Sales].[iduSalesOrderDetail] ON [Sales].[SalesOrderDetail] AFTER INSERT, DELETE, UPDATE AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY -- If inserting or updating these columns IF UPDATE([ProductID]) OR UPDATE([OrderQty]) [...]

public qrtz_trigger_listeners (table) — 4.9%

wikibot Table public.qrtz_trigger_listeners Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group [...]

Production WorkOrder (table) — 4.5%

[...] Table Column Referencing Column Production.WorkOrderRouting WorkOrderID WorkOrderID Triggers Trigger Type iWorkOrder ON INSERT uWorkOrder ON UPDATE Trigger iWorkOrder CREATE TRIGGER [Production].[iWorkOrder] ON [Production].[WorkOrder] AFTER INSERT AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY INSERT INTO [Production].[TransactionHistory]( [ProductID] ,[ReferenceOrderID] ,[TransactionType] [...]

Purchasing PurchaseOrderHeader (table) — 4.1%

[...] Referencing Column Purchasing.PurchaseOrderDetail PurchaseOrderID PurchaseOrderID Triggers Trigger Type uPurchaseOrderHeader ON UPDATE Trigger uPurchaseOrderHeader CREATE TRIGGER [Purchasing].[uPurchaseOrderHeader] ON [Purchasing].[PurchaseOrderHeader] AFTER UPDATE AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY -- Update RevisionNumber for modification of any field EXCEPT the Status. IF NOT UPDATE([Status]) [...]

public setipinterfacekeysonupdate (trigger function) — 4.1%

wikibot Trigger Function public.setipinterfacekeysonupdate Source CREATE OR REPLACE FUNCTION public.setipinterfacekeysonupdate() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN -- ifServices must have an IP address that is *not* 0.0.0.0 IF NEW.ipAddr IS NOT NULL AND NEW.ipAddr = '0.0.0.0' THEN RAISE EXCEPTION 'IfServices Trigger Exception, Condition 0: ipAddr of 0.0.0.0 is not allowed in ifServices table'; END IF; -- -- (Used with Trigger Update [...]

dbo uspLogError (procedure) — 3.7%

[...] Execute Procedure HumanResources.uspUpdateEmployeePersonalInfo Execute Table Production.WorkOrder Trigger iWorkOrder Execute Table Production.WorkOrder Trigger uWorkOrder Execute Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderDetail Trigger uPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderHeader [...]

dbo uspPrintError (procedure) — 3.7%

[...] Child Type Child Object Execute Procedure dbo.uspLogError Execute Table Production.WorkOrder Trigger iWorkOrder Execute Table Production.WorkOrder Trigger uWorkOrder Execute Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderDetail Trigger uPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderHeader [...]

Sales Individual (table) — 3.3%

[...] Referenced Column Person.Contact ContactID ContactID Sales.Customer CustomerID CustomerID Triggers Trigger Type iuIndividual ON INSERT UPDATE Trigger iuIndividual CREATE TRIGGER [Sales].[iuIndividual] ON [Sales].[Individual] AFTER INSERT, UPDATE NOT FOR REPLICATION AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; -- Only allow the Customer to be a Store OR Individual IF EXISTS (SELECT * FROM inserted INNER JOIN [Sales].[Store] [...]

public setipinterfacekeysoninsert (trigger function) — 3.3%

wikibot Trigger Function public.setipinterfacekeysoninsert Source CREATE OR REPLACE FUNCTION public.setipinterfacekeysoninsert() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN -- ifServices must have an IP address that is *not* 0.0.0.0 IF NEW.ipAddr IS NOT NULL AND NEW.ipAddr = '0.0.0.0' THEN RAISE EXCEPTION 'IfServices Trigger Exception, Condition 0: ipAddr of 0.0.0.0 is not allowed in ifServices table'; END IF; -- -- (Insert with old style foreign key) -- This condition [...]

public setifservicekeysoninsert (trigger function) — 3.3%

wikibot Trigger Function public.setifservicekeysoninsert Source CREATE OR REPLACE FUNCTION public.setifservicekeysoninsert() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN -- -- (Used with Trigger Insert with old style foreign key) -- This condition keeps the ifServiceID inSync with the composite foreign key of nodeid, ipaddr, serviceid -- This usually happens when a new record is written by our JDBC code (non-Hibernate DAO) for the old JDBC style -- code has no knowledge of [...]

public setsnmpinterfacekeysonupdate (trigger function) — 3.3%

wikibot Trigger Function public.setsnmpinterfacekeysonupdate Source CREATE OR REPLACE FUNCTION public.setsnmpinterfacekeysonupdate() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN -- -- (Used for Trigger update with old style foreign key) -- This condition keeps snmpinterfaceid inSync with the composite foreign key of nodeid, ipaddr, ifindex -- This usually happens when a record is being updated by old JDBC code (non-Hibernate DAOs) and has changed -- one or more of the composite [...]

Sales Store (table) — 2.8%

[...] Detail Table Column Referencing Column Sales.StoreContact CustomerID CustomerID Triggers Trigger Type iStore ON INSERT Trigger iStore CREATE TRIGGER [Sales].[iStore] ON [Sales].[Store] AFTER INSERT AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY -- Only allow the Customer to be a Store OR Individual IF EXISTS (SELECT * FROM inserted INNER JOIN [Sales].[Individual] ON inserted.[CustomerID] [...]

public setsnmpinterfacekeysoninsert (trigger function) — 2.8%

wikibot Trigger Function public.setsnmpinterfacekeysoninsert Source CREATE OR REPLACE FUNCTION public.setsnmpinterfacekeysoninsert() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN -- -- (Used for Trigger insert with old style foreign key) -- This condition keeps the snmpInterfaceId inSync with the composite foreign key of nodeid, ipaddr, ifindex -- This usually happens when a new record is written by our JDBC code (non-Hibernate DAO) for the old JDBC style -- code has no knowledge [...]

public qrtz_cron_triggers (table) — 2.4%

[...] Table public.qrtz_cron_triggers Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group varchar(80) not null cron_expression varchar(80) not null time_zone_id varchar(80) null Primary Key Primary Key Columns pk_qrtz_cron_triggers [...]

public qrtz_blob_triggers (table) — 2.4%

[...] Table public.qrtz_blob_triggers Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group varchar(80) not null blob_data bytea null Primary Key Primary Key Columns pk_qrtz_blob_triggers [...]

public setifservicekeysonupdate (trigger function) — 2.4%

wikibot Trigger Function public.setifservicekeysonupdate Source CREATE OR REPLACE FUNCTION public.setifservicekeysonupdate() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN -- -- (Update with old style foreign key) -- This condition keeps ifserviceid inSync with the composite foreign key of nodeid, ipaddr, serviceid -- This usually happens when a record is being updated by old JDBC code (non-Hibernate DAOs) and has changed -- one or more of the composite key values, the ifServiceId needs to be updated -- [...]

public qrtz_simple_triggers (table) — 2.4%

[...] Table public.qrtz_simple_triggers Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group varchar(80) not null repeat_count bigint not null repeat_interval bigint not null times_triggered bigint not null Primary Key Primary Key Columns pk_qrtz_simple_triggers [...]

public qrtz_paused_trigger_grps (table) — 2.4%

wikibot Table public.qrtz_paused_trigger_grps Columns Column Data Type Nullable Default Description trigger_group varchar(80) not null [...]

ddlDatabaseTriggerLog (database trigger) — 2.0%

wikibot Database Trigger ddlDatabaseTriggerLog Description Database trigger to audit all of the DDL changes made to the AdventureWorks [...]

Production TransactionHistory (table) — 2.0%

[...] Type Object Type Referencing Object Child Type Child Object Insert Table Production.WorkOrder Trigger iWorkOrder Insert Table Production.WorkOrder Trigger uWorkOrder Insert Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail [...]

Purchasing Vendor (table) — 2.0%

[...] Purchasing.VendorAddress VendorID VendorID Purchasing.VendorContact VendorID VendorID Triggers Trigger Type dVendor INSTEAD OF DELETE Trigger dVendor CREATE TRIGGER [Purchasing].[dVendor] ON [Purchasing].[Vendor] INSTEAD OF DELETE NOT FOR REPLICATION AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY DECLARE @DeleteCount int; SELECT @DeleteCount = COUNT(*) FROM deleted; IF @DeleteCount > 0 BEGIN [...]

HumanResources Employee (table) — 1.2%

[...] Purchasing.PurchaseOrderHeader EmployeeID EmployeeID Sales.SalesPerson EmployeeID SalesPersonID Triggers Trigger Type dEmployee INSTEAD OF DELETE Trigger [...]

dbo DatabaseLog (table) — 1.2%

[...] table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. Columns Column Data Type Nullable Default Description DatabaseLogID int not null Primary key for DatabaseLog records. PostTime datetime not null The date and time the DDL change occurred. DatabaseUser sysname not null The user who implemented the DDL change. Event sysname not null The type of DDL statement that was executed. Schema sysname null The schema to which the changed object belongs. Object sysname null [...]

Database Objects OpenNMS — 1.2%

[...] qrtz_job_details (public) qrtz_job_listeners (public) qrtz_locks (public) qrtz_paused_trigger_grps (public) qrtz_scheduler_state (public) qrtz_simple_triggers (public) qrtz_trigger_listeners (public) qrtz_triggers (public) reportlocator (public) resourcereference (public) servermap (public) service (public) servicemap (public) snmpinterface (public) statisticsreport (public) statisticsreportdata (public) stpinterface (public) stpnode (public) testdatatypes [...]

dbo ufnGetAccountingEndDate (function) — 0.8%

[...] Function dbo.ufnGetAccountingEndDate Description Scalar function used in the uSalesOrderHeader trigger to set the starting account date. Source CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]() RETURNS [datetime] AS BEGIN RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112)); END; Dependencies Reference Type Object Type Referencing Object Child Type Child Object Execute Table Sales.SalesOrderHeader Trigger [...]

public qrtz_fired_triggers (table) — 0.8%

[...] public.qrtz_fired_triggers Columns Column Data Type Nullable Default Description entry_id varchar(95) not null trigger_name varchar(80) not null trigger_group [...]

dbo ufnGetAccountingStartDate (function) — 0.8%

[...] Function dbo.ufnGetAccountingStartDate Description Scalar function used in the uSalesOrderHeader trigger to set the ending account date. Source CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]() RETURNS [datetime] AS BEGIN RETURN CONVERT(datetime, '20030701', 112); END; Dependencies Reference Type Object Type Referencing Object Child Type Child Object Execute Table Sales.SalesOrderHeader Trigger [...]