pears.NetDBSetupPrerequisites
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
CREATE PROCEDURE "pears"."NetDBSetupPrerequisites"( IN "WebUserID" CHAR(20) DEFAULT NULL ) BEGIN CREATE TABLE IF NOT EXISTS "pears"."ErrorList"( "ErrorCode" INTEGER NOT NULL, "ErrorMessage" CHAR(250) NULL, "TotalCount" INTEGER NULL, "LastOccurrence" "datetime" NULL, "HelpMessage" CHAR(1024) NULL, CONSTRAINT "ErrorCode" PRIMARY KEY("ErrorCode" ASC), ) IN "system"; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 79,'invalid new user',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 80,'missing Parameter string',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 82,'Invalid data',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 83,'invalid user',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 84,'invalid type',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 85,'invalid message type',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 86,'invalid shift type',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 87,'invalid availability type',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 88,'Invalid transaction type',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 89,'invalid staff',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 90,'Unable to create a reminder',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 91,'No default ID found',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 92,'unable to create a reminder',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 93,'pDiaryID required',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 94,'Invalid Event Type',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 95,'Invalid Event code',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 96,'Invalid Action',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 97,'There is an error with the linking on your profile',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 99,'Permission denied',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 100,'invalid date or time',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 101,'invalid date',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 102,'invalid time',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 105,'invalid start date',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 106,'invalid start time',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 107,'invalid end date',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 108,'invalid end time',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 110,'Invalid Event date',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 111,'invalid shift date',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 112,'invalid date of birth',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 113,'Shift must not be in the past','If you wish to record an event in the past, please contact your consultant' ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 114,'Unable to add events more than six months in the future',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 115,'Start date must be a Monday',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 116,'Finish day appears to be before start day',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 117,'Date must be between',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 118,'Minutes Before cannot exceed 30240 minutes (or 21 days)',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 119,'pdate is null',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 120,'Invalid start date or time',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 121,'Invalid end date or time',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 122,'Finish time appears to be before Start time',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 130,'order reason required',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 132,'RefCode required','https://iqxusers.co.uk/iqxhelp/doku.php?id=iqxweb:pages-functions:login' ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 133,'please enter a comment detailing your reasons',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 135,'quantity is 0',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 136,'reason is compulsory',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 138,'Missing surname, forenames, email address or template contact ID',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 139,'incomplete message',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 140,'Please ensure there is a Company Name',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 141,'Please ensure there is a valid Account Code',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 142,'Please enter both a forename and a surname',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 143,'No Fax number or Email Address provided.',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 144,'no message',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 145,'Description required',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 146,'Please ensure the Position field is filled',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 160,'Check NI number',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 161,'invalid quantity',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 162,'please check data',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 163,'Please use a unique Account Code',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 164,'Check your bank details are correct',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 165,'invalid recipient',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 166,'Please enter a valid Pay Rate',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 167,'Please enter a valid Charge Rate',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 168,'no SMS-enabled phone or email address',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 169,'Please check Vacancy',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 170,'Please check Person',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 171,'Please check Status',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 172,'Please enter a valid shift type',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 180,'You are not logged in',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 181,'please enter a login',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 186,'only candidates should use the registration form - other users should log in directly',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 190,'please enter a valid email address',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 191,'Registration',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 194,'unspecified error',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 200,'Timesheet already finalised or deleted',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 201,'Not able to create line',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 202,'Cancellation failed',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 203,'Confirmation failed',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 204,'Candidate not available',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 205,'Not an agency login',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 206,'No company link',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 207,'*** has already been submitted',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 208,'Already Applied',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 209,'Apply',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 210,'the Note is too long. It has been limited to 50 characters',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 211,'this person is already in the short list',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 212,'You have already Applied for this post',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 213,'This person is already in the short list',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 214,'Login not found',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 215,'you may already be registered','please contact the agency' ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 216,'Please contact our support team for information why you can''t register',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 217,'you appear to be logged in already','please close and re-open your browser' ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 218,'A record exists for you but is archived. Please contact',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 219,'Login exists but the link broken. Please contact',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 220,'Person exists but there is no login. Please contact',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 221,'that email address already exists. Please check it or contact your consultant',NULL ) ; INSERT INTO "ErrorList"( "ErrorCode","ErrorMessage","HelpMessage" ) ON existing UPDATE defaults off VALUES( 222,'Email address already in use',NULL ) END GO COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetDBSetupPrerequisites" IS {CREATE PROCEDURE pears."NetDBSetupPrerequisites"(IN WebUserID CHAR(20) DEFAULT NULL) BEGIN CREATE TABLE IF NOT EXISTS pears.ErrorList ( ErrorCode INTEGER NOT NULL, ErrorMessage CHAR(250) NULL, TotalCount INTEGER NULL, LastOccurrence datetime NULL, HelpMessage CHAR(1024) NULL, CONSTRAINT ErrorCode PRIMARY KEY ( ErrorCode ASC ) ) IN system; INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(79,'invalid new user',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(80,'missing Parameter string',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(82,'Invalid data',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(83,'invalid user',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(84,'invalid type',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(85,'invalid message type',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(86,'invalid shift type',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(87,'invalid availability type',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(88,'Invalid transaction type',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(89,'invalid staff',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(90,'Unable to create a reminder',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(91,'No default ID found',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(92,'unable to create a reminder',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(93,'pDiaryID required',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(94,'Invalid Event Type',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(95,'Invalid Event code',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(96,'Invalid Action',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(97,'There is an error with the linking on your profile',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(99,'Permission denied',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(100,'invalid date or time',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(101,'invalid date',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(102,'invalid time',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(105,'invalid start date',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(106,'invalid start time',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(107,'invalid end date',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(108,'invalid end time',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(110,'Invalid Event date',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(111,'invalid shift date',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(112,'invalid date of birth',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(113,'Shift must not be in the past','If you wish to record an event in the past, please contact your consultant'); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(114,'Unable to add events more than six months in the future',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(115,'Start date must be a Monday',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(116,'Finish day appears to be before start day',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(117,'Date must be between',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(118,'Minutes Before cannot exceed 30240 minutes (or 21 days)',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(119,'pdate is null',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(120,'Invalid start date or time',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(121,'Invalid end date or time',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(122,'Finish time appears to be before Start time',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(130,'order reason required',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(132,'RefCode required','https://iqxusers.co.uk/iqxhelp/doku.php?id=iqxweb:pages-functions:login'); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(133,'please enter a comment detailing your reasons',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(135,'quantity is 0',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(136,'reason is compulsory',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(138,'Missing surname, forenames, email address or template contact ID',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(139,'incomplete message',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(140,'Please ensure there is a Company Name',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(141,'Please ensure there is a valid Account Code',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(142,'Please enter both a forename and a surname',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(143,'No Fax number or Email Address provided.',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(144,'no message',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(145,'Description required',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(146,'Please ensure the Position field is filled',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(160,'Check NI number',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(161,'invalid quantity',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(162,'please check data',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(163,'Please use a unique Account Code',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(164,'Check your bank details are correct',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(165,'invalid recipient',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(166,'Please enter a valid Pay Rate',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(167,'Please enter a valid Charge Rate',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(168,'no SMS-enabled phone or email address',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(169,'Please check Vacancy',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(170,'Please check Person',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(171,'Please check Status',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(172,'Please enter a valid shift type',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(180,'You are not logged in',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(181,'please enter a login',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(186,'only candidates should use the registration form - other users should log in directly',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(190,'please enter a valid email address',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(191,'Registration',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(194,'unspecified error',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(200,'Timesheet already finalised or deleted',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(201,'Not able to create line',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(202,'Cancellation failed',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(203,'Confirmation failed',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(204,'Candidate not available',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(205,'Not an agency login',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(206,'No company link',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(207,'*** has already been submitted',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(208,'Already Applied',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(209,'Apply',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(210,'the Note is too long. It has been limited to 50 characters',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(211,'this person is already in the short list',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(212,'You have already Applied for this post',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(213,'This person is already in the short list',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(214,'Login not found',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(215,'you may already be registered','please contact the agency'); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(216,'Please contact our support team for information why you can''t register',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(217,'you appear to be logged in already','please close and re-open your browser'); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(218,'A record exists for you but is archived. Please contact',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(219,'Login exists but the link broken. Please contact',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(220,'Person exists but there is no login. Please contact',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(221,'that email address already exists. Please check it or contact your consultant',NULL); INSERT INTO ErrorList (ErrorCode,ErrorMessage,HelpMessage) ON existing UPDATE defaults off VALUES(222,'Email address already in use',NULL); END }
127.0.0.1