SQLite format 3 @ ] v ] - I /C indexsqlite_autoindex_Triggers_1Triggers e'indexAccounts_key2AccountsCREATE INDEX Accounts_key2 ON Accounts ([OrganizationID],[OrderBy])Z'indexAccounts_key1AccountsCREATE INDEX Accounts_key1 ON Accounts ([OrganizationID])]
tableAccountsAccountsCREATE TABLE [Accounts] (
[AccountID] VARCHAR(10) NOT NULL ,
[OrganizationID] VARCHAR(10) NOT NULL,
[OrderBy] INTEGER ,
[Name] VARCHAR(250),
[XML] TEXT ,
PRIMARY KEY (AccountID)
)/C indexsqlite_autoindex_Accounts_1Accounts!''tableOrganizationsOrganizationsCREATE TABLE [Organizations] (
[ID] VARCHAR(10) NOT NULL ,
[Name] VARCHAR(250) ,
[XML] TEXT ,
PRIMARY KEY ([ID])
)9M' indexsqlite_autoindex_Organizations_1Organizations
!q5C7919B020Test
5C7919B020
Test
test@test.com
2012-02-02 00:00:00
1899-12-30 00:00:00
-1
!5C7919B020
!m6CD5DB4A5C7919B020 Samples
6CD5DB4A
5C7919B020
5
1899-12-30 00:00:00
2
Sample Triggers. Any triggers created in this account will not execute.
2012-01-05 00:00:00
-1
143
2000-01-01 00:00:00
Samples
-1
2012-01-05 00:00:00
-1
110
-1
2012-01-05 00:00:00
1899-12-30 00:00:00
0FBC51207A
5C791
06F438C07A B9D823407A!0FBC51207A
6CD5DB4A
5C7919B020 5C7919B020!5C7919B020 5C7919B020
5C7919B020 5C7919B020!5C7919B020 5C7919B020
N N} A!I6CD5DB4A6CD5D889Web Orders
6CD5D889
A sample trigger that shows how to parse fields from an payment gateway supplier (in this case 'ShareIT').#xD;#xA;#xD;#xA;
-1
processing@paymentgateway.com
Dear Mr./Mrs. Stephen Parker,#xD;#xA;#xD;#xA;We have received an order for your product "Widget".#xD;#xA;#xD;#xA;#xD;#xA;The credit card charge has been authorized.#x !!?C0FBC51207AD2AFBAC07AAutoTask Ticket New/Reply
D2AFBAC07A
-1
*