w9MKHyMg

1CREATE TABLE IF NOT EXISTS "info_contactsign_hist"(
2	"_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
3	"currenttime" INTEGER DEFAULT(STRFTIME('%s', 'now')),
4	"ismodified" INTEGER,
5	"guid" TEXT,
6	"moduser" TEXT,
7	"modified" INTEGER,
8	"createdate" INTEGER,
9	"isarchive" INTEGER,
10	"contact_id" TEXT,
11	"agreement_id" TEXT,
12	"contactsign_id" TEXT,
13	"user_id" TEXT,
14	"sign_phone" TEXT,
15	"sign_email" TEXT,
16	"signtype" TEXT,
17	"state" INTEGER,
18	"sign_ad" INTEGER,
19	"sign_pd" INTEGER,
20	"sign_pd2" INTEGER,
21	"sign_remote" INTEGER,
22	"sign_task" INTEGER,
23	"sign_rim" INTEGER,
24	"sign_rimFile" BLOB
25);
26
27-- rep_field
28
29DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'guid';
30INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('guid', 'info_contactsign_hist', 0);
31
32DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'moduser';
33INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('moduser', 'info_contactsign_hist', 0);
34
35DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'modified';
36INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('modified', 'info_contactsign_hist', 0);
37
38DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'createdate';
39INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('createdate', 'info_contactsign_hist', 0);
40
41DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'isarchive';
42INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('isarchive', 'info_contactsign_hist', 0);
43
44DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'contact_id';
45INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('contact_id', 'info_contactsign_hist', 0);
46
47DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'agreement_id';
48INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('agreement_id', 'info_contactsign_hist', 0);
49
50DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'contactsign_id';
51INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('contactsign_id', 'info_contactsign_hist', 0);
52
53DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'user_id';
54INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('user_id', 'info_contactsign_hist', 0);
55
56DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_phone';
57INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_phone', 'info_contactsign_hist', 0);
58
59DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_email';
60INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_email', 'info_contactsign_hist', 0);
61
62DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'signtype';
63INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('signtype', 'info_contactsign_hist', 0);
64
65DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'state';
66INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('state', 'info_contactsign_hist', 0);
67
68DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_ad';
69INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_ad', 'info_contactsign_hist', 0);
70
71DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_pd';
72INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_pd', 'info_contactsign_hist', 0);
73
74DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_pd2';
75INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_pd2', 'info_contactsign_hist', 0);
76
77DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_remote';
78INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_remote', 'info_contactsign_hist', 0);
79
80DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_task';
81INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_task', 'info_contactsign_hist', 0);
82
83DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_rim';
84INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_rim', 'info_contactsign_hist', 0);
85
86DELETE FROM REP_FIELD WHERE tablename = 'info_contactsign_hist' and name = 'sign_rimFile';
87INSERT INTO REP_FIELD(name, tablename, issearch) VALUES('sign_rimFile', 'info_contactsign_hist', 0);
88
89-- rep_constraint
90
91DELETE FROM rep_constraint WHERE foreign_table = 'info_contactsign_hist' AND foreign_field = 'user_id' AND references_table = 'info_dictionaryremote' AND references_field = '_id;
92INSERT INTO rep_constraint(foreign_table, foreign_field, references_table, references_field) VALUES('info_contactsign_hist', 'user_id', 'info_dictionaryremote', '_id');
93
94DELETE FROM rep_constraint WHERE foreign_table = 'info_contactsign_hist' AND foreign_field = 'agreement_id' AND references_table = 'info_dictionaryremote' AND references_field = '_id;
95INSERT INTO rep_constraint(foreign_table, foreign_field, references_table, references_field) VALUES('info_contactsign_hist', 'agreement_id', 'info_dictionaryremote', '_id');
96
97DELETE FROM rep_constraint WHERE foreign_table = 'info_contactsign_hist' AND foreign_field = 'contact_id' AND references_table = 'info_contact' AND references_field = '_id;
98INSERT INTO rep_constraint(foreign_table, foreign_field, references_table, references_field) VALUES('info_contactsign_hist', 'contact_id', 'info_contact', '_id');
99
100DELETE FROM rep_constraint WHERE foreign_table = 'info_contactsign_hist' AND foreign_field = 'contactsign_id' AND references_table = 'info_contactsign' AND references_field = '_id;
101INSERT INTO rep_constraint(foreign_table, foreign_field, references_table, references_field) VALUES('info_contactsign_hist', 'contactsign_id', 'info_contactsign', '_id');