CREATE TABLE TBL_EQUIP(EQUIP_ID INTEGER,EQUIP_NAME VARCHAR)
CREATE TABLE TBL_ISON(PERSON_ID INTEGER,ITEM_ID INTEGER,MODERATOR BIT,CONFIRMED VARCHAR)
CREATE TABLE TBL_ITEM_EQUIP(ITEM_ID INTEGER,EQUIP_ID INTEGER,QTY SMALLINT)
CREATE TABLE TBL_ITEM_SUBJECTS(ITEM_SUBJECT_ID INTEGER,ITEM_SUBJECT_DESC VARCHAR,ITEM_SUBJECT_DBASE VARCHAR)
CREATE TABLE TBL_ITEM_TYPES(ITEM_TYPE_ID INTEGER,ITEM_TYPE_DESC VARCHAR,ITEM_TYPE_ICON LONGVARBINARY,ITEM_TYPE_DBASE VARCHAR)
CREATE TABLE TBL_MESSAGE_LOG(MESSAGE_ID INTEGER,PERSON_ID INTEGER,PROFORMA_ID INTEGER,MESSAGE_SEND_DATE TIMESTAMP,MESSAGE_SUBJECT VARCHAR,MESSAGE_CONTENTS LONGVARCHAR,EMAIL VARCHAR)
CREATE TABLE TBL_MESSAGE_PROFORMAS(PROFORMA_ID INTEGER,PROFORMA_SUBJECT VARCHAR,PROFORMA_CONTENTS LONGVARCHAR,LASTUPDATE TIMESTAMP)
CREATE TABLE TBL_PEOPLE(PERSON_ID INTEGER,PKEY VARCHAR,LNAME VARCHAR,FNAME VARCHAR,SUFFIX VARCHAR,NOTES VARCHAR,MAILING VARCHAR,EMAIL_NAME VARCHAR,OKADDRPHON VARCHAR,HASRESPONDED BIT,ATTENDING VARCHAR,RESPOND VARCHAR,INFERRED VARCHAR,STATUS VARCHAR,MAXDAY SMALLINT,MAXCON SMALLINT,FORMAT VARCHAR,AREAS VARCHAR,MEMBNUM VARCHAR,NOTAGNST VARCHAR,ARRDAY SMALLINT,ARRTIME SMALLINT,DEPDAY SMALLINT,DEPTIME SMALLINT,VOLUNTEER BIT,PAID SMALLINT,GHOST BIT,LASTUPDATE TIMESTAMP,BIO LONGVARCHAR,DATECREATED TIMESTAMP)
CREATE TABLE TBL_ROOM_AVAIL(ROOM_ID INTEGER,DAY_ID SMALLINT,STARTTIME REAL,ENDTIME REAL)
CREATE TABLE TBL_ROOMS(ROOM_ID INTEGER,RKEY VARCHAR,ROOM_NAME VARCHAR,CAPACITY INTEGER,NOTES VARCHAR,LASTUPDATE TIMESTAMP)
CREATE TABLE TBLCURRENTSELECTIONS(CURRENT_PERSON_ID INTEGER,CURRENT_ITEM_ID INTEGER,CURRENT_ROOM_ID INTEGER,CURRENT_MESSAGE_ID INTEGER,CURRENT_PROFORMA_ID INTEGER,PATHLASTUSED VARCHAR,CURRENT_IKEY VARCHAR,CURRENT_PKEY VARCHAR)
CREATE TABLE TBLDAYS(DAY_ID SMALLINT,DAY_NAME VARCHAR)
CREATE TABLE TBLIMPORTEDITEMSDBASE(IKEY VARCHAR,ITEM_ID INTEGER,IMPORTDATE TIMESTAMP)
CREATE TABLE TBLIMPORTEDPEOPLEDBASE(PKEY VARCHAR,PERSON_ID INTEGER,IMPORTDATE TIMESTAMP)
CREATE TABLE TBLMPVRR(COL_ID SMALLINT,ROOM_ID INTEGER,ROOM_NAME VARCHAR)
CREATE TABLE TBLMPVSTATES(STATE_ID SMALLINT,STATE_NAME VARCHAR,STATE_OLE LONGVARBINARY)
CREATE TABLE TBLSYSTEMSETTINGS(CONNAME VARCHAR,CONSUBTITLE VARCHAR,CHANGETRACKINGIND BIT,SHOWEMAILINAPPIND BIT,INSTALLDIRECTORY VARCHAR,DOC_PATH VARCHAR,WORD_APP_PATH VARCHAR,DBASE_ITEMS_PATH VARCHAR,DBASE_ITEMS_AVAIL BIT,DBASE_PRECIS_PATH VARCHAR,DBASE_PRECIS_AVAIL BIT,DBASE_PEOPLE_PATH VARCHAR,DBASE_PEOPLE_AVAIL BIT,DBASE_BIOS_PATH VARCHAR,DBASE_BIOS_AVAIL BIT,DBASE_ISON_PATH VARCHAR,DBASE_ISON_AVAIL BIT,DBASE_MASTER_PATH VARCHAR,DBASE_MASTER_AVAIL BIT,OLD_CDB_PATH VARCHAR,NEWMASTERIDLOW INTEGER,NEWMASTERIDHIGH INTEGER,MPVZOOM REAL,MPVFONTSIZE SMALLINT)
CREATE TABLE TBLTIMES(TIME REAL)
CREATE TABLE TBL_LENGTHS(NAME VARCHAR,LENGTH REAL)
CREATE TABLE TBL_ITEMS(ITEM_ID INTEGER,IKEY VARCHAR,ROOM_ID INTEGER,RKEY VARCHAR,DAY_ID SMALLINT,STARTTIME REAL,LENGTH REAL,NOTES VARCHAR,MINPEOPLE SMALLINT,MAXPEOPLE SMALLINT,EQUIPMENT VARCHAR,ITEM_TITLE VARCHAR,ITEM_TYPE_ID INTEGER,ITEM_SUBJECT_ID INTEGER,ATTEND SMALLINT,NOPRINT BIT,REC_NO INTEGER,CHANGE VARCHAR,PRECIS LONGVARCHAR,LASTUPDATE TIMESTAMP,DATECREATED TIMESTAMP,PLACEHOLDER_ID INTEGER)
CREATE INDEX INDEX_ITEM_ID ON TBL_ITEMS(ITEM_ID)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
CREATE ALIAS ABS FOR "java.lang.Math.abs"
CREATE ALIAS POWER FOR "java.lang.Math.pow"
CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
CREATE ALIAS TAN FOR "java.lang.Math.tan"
CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
CREATE ALIAS ACOS FOR "java.lang.Math.acos"
CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
CREATE ALIAS ASIN FOR "java.lang.Math.asin"
CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
CREATE ALIAS EXP FOR "java.lang.Math.exp"
CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
CREATE ALIAS COS FOR "java.lang.Math.cos"
CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
CREATE ALIAS LOG FOR "java.lang.Math.log"
CREATE ALIAS SIN FOR "java.lang.Math.sin"
CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
CREATE ALIAS USER FOR "org.hsqldb.Library.user"
CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
CREATE ALIAS ATAN FOR "java.lang.Math.atan"
CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
CREATE ALIAS RAND FOR "java.lang.Math.random"
CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
INSERT INTO TBL_EQUIP VALUES(999041998,'Flip Chart')
INSERT INTO TBL_EQUIP VALUES(999042035,'Slide Projector')
INSERT INTO TBL_EQUIP VALUES(999041954,'Video Player NTSC')
INSERT INTO TBL_EQUIP VALUES(999044846,'None')
INSERT INTO TBL_EQUIP VALUES(999119039,'PA')
INSERT INTO TBL_ISON VALUES(1,1,false,'N')
INSERT INTO TBL_ISON VALUES(1,14,false,'N')
INSERT INTO TBL_ISON VALUES(4,1,false,'N')
INSERT INTO TBL_ISON VALUES(1,1,NULL,NULL)
INSERT INTO TBL_ISON VALUES(991,3,false,'N')
INSERT INTO TBL_ISON VALUES(991,4,false,'N')
INSERT INTO TBL_ISON VALUES(991,8,false,'N')
INSERT INTO TBL_ISON VALUES(991,10,false,'N')
INSERT INTO TBL_ISON VALUES(991,11,false,'N')
INSERT INTO TBL_ISON VALUES(991,1,false,'N')
INSERT INTO TBL_ISON VALUES(991,17,false,'N')
INSERT INTO TBL_ISON VALUES(991,14,false,'N')
INSERT INTO TBL_ISON VALUES(991,13,false,'N')
INSERT INTO TBL_ISON VALUES(991,9,false,'N')
INSERT INTO TBL_ISON VALUES(991,15,false,'N')
INSERT INTO TBL_ISON VALUES(3,12,false,'N')
INSERT INTO TBL_ISON VALUES(3,14,NULL,NULL)
INSERT INTO TBL_ISON VALUES(3,13,NULL,NULL)
INSERT INTO TBL_ISON VALUES(3,6,NULL,NULL)
INSERT INTO TBL_ISON VALUES(NULL,NULL,NULL,NULL)
INSERT INTO TBL_ISON VALUES(NULL,NULL,NULL,NULL)
INSERT INTO TBL_ISON VALUES(22,1,NULL,NULL)
INSERT INTO TBL_ISON VALUES(2,3,NULL,NULL)
INSERT INTO TBL_ISON VALUES(4,3,NULL,NULL)
INSERT INTO TBL_ISON VALUES(22,3,NULL,NULL)
INSERT INTO TBL_ISON VALUES(9000,3,NULL,NULL)
INSERT INTO TBL_ISON VALUES(3,18,NULL,NULL)
INSERT INTO TBL_ISON VALUES(1000,10,NULL,NULL)
INSERT INTO TBL_ISON VALUES(2,10,NULL,NULL)
INSERT INTO TBL_ISON VALUES(105,10,NULL,NULL)
INSERT INTO TBL_ISON VALUES(110,10,NULL,NULL)
INSERT INTO TBL_ISON VALUES(1000,3,NULL,NULL)
INSERT INTO TBL_ISON VALUES(2,8,NULL,NULL)
INSERT INTO TBL_ISON VALUES(105,8,NULL,NULL)
INSERT INTO TBL_ISON VALUES(4,8,NULL,NULL)
INSERT INTO TBL_ISON VALUES(21,8,NULL,NULL)
INSERT INTO TBL_ISON VALUES(1000,8,NULL,NULL)
INSERT INTO TBL_ISON VALUES(3,8,NULL,NULL)
INSERT INTO TBL_ISON VALUES(110,16,NULL,NULL)
INSERT INTO TBL_ISON VALUES(999472064,5,NULL,NULL)
INSERT INTO TBL_ISON VALUES(3,2,NULL,NULL)
INSERT INTO TBL_ISON VALUES(999472885,3,NULL,NULL)
INSERT INTO TBL_ISON VALUES(21,19,NULL,NULL)
INSERT INTO TBL_ISON VALUES(3,5,NULL,NULL)
INSERT INTO TBL_ISON VALUES(105,995325344,NULL,NULL)
INSERT INTO TBL_ISON VALUES(1000,999370294,NULL,NULL)
INSERT INTO TBL_ITEM_SUBJECTS VALUES(1,'Hard SF','a')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(2,'Social SF','b')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(4,'Horror','d')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(8,'Filking','h')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(9,'Media','I')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(15,'YA topics','o')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(20,'Films','t')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(24,'Gaming','x')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(25,'Science','y')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(26,'Other','z')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(3,'Fantasy Writing','c')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(12,'Fanzines','l')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(21,'Video','u')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(19,'Literary history','s')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(999037792,'Costume',NULL)
INSERT INTO TBL_ITEM_SUBJECTS VALUES(999041451,'Slide Projector',NULL)
INSERT INTO TBL_ITEM_SUBJECTS VALUES(999041604,'Conrunning',NULL)
INSERT INTO TBL_ITEM_SUBJECTS VALUES(13,'Space','m')
INSERT INTO TBL_ITEM_SUBJECTS VALUES(999119986,'Art',NULL)
INSERT INTO TBL_ITEM_TYPES VALUES(1,'Panel','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e506963747572650001050000020000000700000050427275736800000000000000000020060000424d1e0600000000000036000000280000001c000000120000000100180000000000e8050000c40e0000c40e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffffffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffffffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000010500000000000021ad05fe','a')
INSERT INTO TBL_ITEM_TYPES VALUES(2,'Panel Moderator','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e506963747572650001050000020000000700000050427275736800000000000000000020060000424d1e0600000000000036000000280000001c000000120000000100180000000000e8050000c40e0000c40e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffff000000ffffffffffffffffffffffffffffff000000ffffffffffffffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffff000000ffffffffffffffffffffffffffffff000000ffffffffffffffffff000000000000000000000000000000000000000000ffffffffffff000000000000000000000000000000000000000000ffffffffffff000000ffffffffffffffffffffffffffffff000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000ffffffffffffffffff000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000ffffff000000ffffffffffffffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000ffffffffffffffffff000000ffffffffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000ffffffffffffffffff000000ffffffffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000000000000000000000000000ffffffffffffffffffffffff000000ffffffffffffffffff000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000010500000000000021ad05fe','b')
INSERT INTO TBL_ITEM_TYPES VALUES(3,'Reading','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e506963747572650001050000020000000700000050427275736800000000000000000020060000424d1e0600000000000036000000280000001c000000120000000100180000000000e8050000c40e0000c40e00000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000ff0000ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000c0c0c0ff0000ff0000ff0000ff0000ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000ff0000ff0000c0c0c0ff0000ff0000ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000c0c0c0ff0000ff0000ff0000c0c0c0ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000800000800000ff0000ff0000c0c0c0c0c0c0c0c0c0ff0000ff0000ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff80000080000000ffff00ffffff0000ff0000ff0000c0c0c0c0c0c0c0c0c0ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000ff000000ffff00ffff00ffffff0000ff0000ff0000c0c0c0c0c0c0ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000ff000000ffff00ffff00ffff00ffffff0000ff0000ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000ff000000ffff00ffff808080808080808080ff0000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff800000ff0000808080808080ffffffffffffffffffffffffff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000001050000000000005ead05fe','c')
INSERT INTO TBL_ITEM_TYPES VALUES(4,'Interviewing','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e506963747572650001050000020000000700000050427275736800000000000000000020060000424d1e0600000000000036000000280000001c000000120000000100180000000000e8050000c40e0000c40e00000000000000000000ffffffffffff000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000ffffffffffffffffffffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffff000000000000000000ffffffffffffffffffffffff000000000000000000ffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffff0000ff0000ff0000ff0000ff0000ff0000ff0000ff000000000000000000ffffffffffffffffffffffffffffff0000000000000000ff0000ff0000ff0000ff0000ff0000ff0000ffffffffffffffffffff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff000000ffffff000000ffffffffffffffffffffffffffffff0000000000000000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ffffffffffffff0000ff0000ff0000ff0000ff000000000000000000000000000000ffffff000000000000ffffffffffffffffffffffff0000000000000000000000000000000000000000ff0000ff0000ff0000ffffffffffffff0000ff0000ff0000ff000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffff0000000000000000000000000000000000000000000000ff0000ff0000ffffffffffffff0000ff0000ff0000ff000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000ff0000ff0000ffffffffffffff0000ff0000ff0000ff000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000ff0000ff0000ffffffffffffff0000ff0000ff000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000ff0000ffffffffffffff0000ff0000ff000000000000000000000000ffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000ff0000ffffffffffffff0000ffffffffffffff000000000000ffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffff0000ffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000105000000000000dead05fe','d')
INSERT INTO TBL_ITEM_TYPES VALUES(6,'Debate',NULL,'f')
INSERT INTO TBL_ITEM_TYPES VALUES(7,'Signing','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e506963747572650001050000020000000700000050427275736800000000000000000020060000424d1e0600000000000036000000280000001c000000120000000100180000000000e8050000c40e0000c40e00000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffff000000000000000000000000ffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000800000800000000000ffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffff0000ff0000800000800000000000ffffffffffffffffffffffffffffffffffff000000ffffff000000ffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000ff0000800000800000000000ffffffffffffffffffffffffffffff000000ffffff000000ffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000ff0000800000800000000000ffffffffffffffffffffffff000000ffffff000000ffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000ff000080000000ffff00ffffffffffffffffffffff000000000000000000ffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffff00ffff804000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00ffffff0000800000800000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000ff0000800000800000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffff0000ff0000800000800000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffff0000ff0000800000800000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffff0000ff0000800000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffff000000ff0000ff0000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000105000000000000e1ad05fe','g')
INSERT INTO TBL_ITEM_TYPES VALUES(10,'Specialized format',NULL,'j')
INSERT INTO TBL_ITEM_TYPES VALUES(11,'Kaffeeklatsche','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e506963747572650001050000020000000700000050427275736800000000000000000020060000424d1e0600000000000036000000280000001c000000120000000100180000000000e8050000c40e0000c40e00000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffff000000ffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffff000000ffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000ffffffffffff000000ffffffffffff000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000010500000000000021ad05fe','k')
INSERT INTO TBL_ITEM_TYPES VALUES(12,'Press',NULL,'p')
INSERT INTO TBL_ITEM_TYPES VALUES(998613177,'Play',NULL,NULL)
INSERT INTO TBL_ITEM_TYPES VALUES(8,'Solo Speech',NULL,'h')
INSERT INTO TBL_ITEM_TYPES VALUES(998613535,'Maquerade',NULL,NULL)
INSERT INTO TBL_ITEM_TYPES VALUES(998613272,'Masquerade Rehearsal',NULL,NULL)
INSERT INTO TBL_ITEM_TYPES VALUES(9,'Workshop',NULL,'I')
INSERT INTO TBL_ITEM_TYPES VALUES(998614149,'Quiz',NULL,NULL)
INSERT INTO TBL_ITEM_TYPES VALUES(13,'Video','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e506963747572650001050000020000000700000050427275736800000000000000000020060000424d1e0600000000000036000000280000001c000000120000000100180000000000e8050000c40e0000c40e00000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffff000000000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000000000000000000000000000000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000ffffffffffffffffff000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000000000000000000000000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000ffffffffffffffffff000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000000000000000000000000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000000000000000000000000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000ffffff000000000000000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00808000ffff00808000ffff00ffff00000000000000000000000000000000000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000ffffff000000000000000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00808000ffff00808000ffff00ffff00000000000000000000000000000000000000000000ffffffffffffffffff000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000ffffffffffff000000000000000000ffffffffffffffffff000000000000000000ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00ffff00000000000000000000ffffffffffff000000000000000000ffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000105000000000000dead05fe',NULL)
INSERT INTO TBL_ITEM_TYPES VALUES(999120905,'Business meeting',NULL,NULL)
INSERT INTO TBL_ITEM_TYPES VALUES(5,'Being Interviewed','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e506963747572650001050000020000000700000050427275736800000000000000000020060000424d1e0600000000000036000000280000001c000000120000000100180000000000e8050000c40e0000c40e00000000000000000000ffffffffffff000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000ffffffffffffffffffffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffff000000000000000000ffffffffffffffffffffffff000000000000000000ffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffff0000ff0000ff0000ff0000ff0000ff0000ff0000ff000000000000000000ffffffffffffffffffffffffffffff0000000000000000ff0000ff0000ff0000ff0000ff0000ff0000ffffffffffffffffffff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff000000ffffff000000ffffffffffffffffffffffffffffff0000000000000000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ffffffffffffff0000ff0000ff0000ff0000ff000000000000000000000000000000ffffff000000000000ffffffffffffffffffffffff0000000000000000000000000000000000000000ff0000ff0000ff0000ffffffffffffff0000ff0000ff0000ff000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffff0000000000000000000000000000000000000000000000ff0000ff0000ffffffffffffff0000ff0000ff0000ff000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000ff0000ff0000ffffffffffffff0000ff0000ff0000ff000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000ff0000ff0000ffffffffffffff0000ff0000ff000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000ff0000ffffffffffffff0000ff0000ff000000000000000000000000ffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000ff0000ffffffffffffff0000ffffffffffffff000000000000ffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffff0000ffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000105000000000000dead05fe','e')
INSERT INTO TBL_MESSAGE_LOG VALUES(1,2,1,NULL,'First Invitation','Dear David,\u000d\u000a\u000d\u000aI represent Yah Boo Hiss con 2000. \u000d\u000a\u000d\u000aThe convention is based in thistown and will run from date to date.\u000d\u000a\u000d\u000aThis is a trial email to see if you would be interested in attending as a special guest. \u000d\u000a\u000d\u000aYours sincerely, \u000d\u000a\u000d\u000aJoe Bloggs,\u000d\u000aProgramming \u000d\u000aYah Boo Hiss Con','arblaster.david.c@edumail.vic.gov.au')
INSERT INTO TBL_MESSAGE_LOG VALUES(2,2,1,NULL,'First Invitation','Dear David,\u000d\u000a\u000d\u000aI represent Yah Boo Hiss con 2000. \u000d\u000a\u000d\u000aThe convention is based in thistown and will run from date to date.\u000d\u000a\u000d\u000aThis is a trial email to see if you would be interested in attending as a special guest. \u000d\u000a\u000d\u000aYours sincerely, \u000d\u000a\u000d\u000aJoe Bloggs,\u000d\u000aProgramming \u000d\u000aYah Boo Hiss Con','arblaster.david.c@edumail.vic.gov.au')
INSERT INTO TBL_MESSAGE_LOG VALUES(3,2,1,NULL,'First Invitation','Dear David,\u000d\u000a\u000d\u000aI represent Yah Boo Hiss con 2000. \u000d\u000a\u000d\u000aThe convention is based in thistown and will run from date to date.\u000d\u000a\u000d\u000aThis is a trial email to see if you would be interested in attending as a special guest. \u000d\u000a\u000d\u000aYours sincerely, \u000d\u000a\u000d\u000aJoe Bloggs,\u000d\u000aProgramming \u000d\u000aYah Boo Hiss Con','arblaster.david.c@edumail.vic.gov.au')
INSERT INTO TBL_MESSAGE_LOG VALUES(4,3,1,NULL,'First Invitation','Dear Bill,\u000d\u000a\u000d\u000aI represent Yah Boo Hiss con 2000. \u000d\u000a\u000d\u000aThe convention is based in thistown and will run from date to date.\u000d\u000a\u000d\u000aThis is a trial email to see if you would be interested in attending as a special guest. \u000d\u000a\u000d\u000aYours sincerely, \u000d\u000a\u000d\u000aJoe Bloggs,\u000d\u000aProgramming \u000d\u000aYah Boo Hiss Con','bonzodog@doodahband.com')
INSERT INTO TBL_MESSAGE_LOG VALUES(5,3,1,NULL,'First Invitation','Dear Bill,\u000d\u000a\u000d\u000aI represent Yah Boo Hiss con 2000. \u000d\u000a\u000d\u000aThe convention is based in thistown and will run from date to date.\u000d\u000a\u000d\u000aThis is a trial email to see if you would be interested in attending as a special guest. \u000d\u000a\u000d\u000aYours sincerely, \u000d\u000a\u000d\u000aJoe Bloggs,\u000d\u000aProgramming \u000d\u000aYah Boo Hiss Con','bonzodog@doodahband.com')
INSERT INTO TBL_MESSAGE_LOG VALUES(6,3,1,NULL,'First Invitation','Dear Bill,\u000d\u000a\u000d\u000aI represent Yah Boo Hiss con 2000. \u000d\u000a\u000d\u000aThe convention is based in thistown and will run from date to date.\u000d\u000a\u000d\u000aThis is a trial email to see if you would be interested in attending as a special guest. \u000d\u000a\u000d\u000aYours sincerely, \u000d\u000a\u000d\u000aJoe Bloggs,\u000d\u000aProgramming \u000d\u000aYah Boo Hiss Con','bonzodog@doodahband.com')
INSERT INTO TBL_MESSAGE_LOG VALUES(7,3,0,NULL,'Custom Message','','bonzodog@doodahband.com')
INSERT INTO TBL_MESSAGE_LOG VALUES(8,3,1,NULL,'First Invitation','Dear Bill,\u000d\u000a\u000d\u000aI represent Yah Boo Hiss con 2000. \u000d\u000a\u000d\u000aThe convention is based in thistown and will run from date to date.\u000d\u000a\u000d\u000aThis is a trial email to see if you would be interested in attending as a special guest. \u000d\u000a\u000d\u000aYours sincerely, \u000d\u000a\u000d\u000aJoe Bloggs,\u000d\u000aProgramming \u000d\u000aYah Boo Hiss Con','bonzodog@doodahband.com')
INSERT INTO TBL_MESSAGE_PROFORMAS VALUES(0,'Custom Message',NULL,NULL)
INSERT INTO TBL_MESSAGE_PROFORMAS VALUES(1,'First Invitation','Dear [email_name],\u000d\u000a\u000d\u000aI represent Yah Boo Hiss con 2000. \u000d\u000a\u000d\u000aThe convention is based in thistown and will run from date to date.\u000d\u000a\u000d\u000aThis is a trial email to see if you would be interested in attending as a special guest. \u000d\u000a\u000d\u000aYours sincerely, \u000d\u000a\u000d\u000aJoe Bloggs,\u000d\u000aProgramming \u000d\u000aYah Boo Hiss Con','2000-02-03 12:22:28.0')
INSERT INTO TBL_PEOPLE VALUES(9000,'9000','Range','Spec',NULL,'added to test addition of person where master ID range has been specified',NULL,'Spec',NULL,true,'N',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,0,0,0,0,true,0,true,'2000-04-09 16:59:39.0',NULL,'2000-04-09 16:59:05.0')
INSERT INTO TBL_PEOPLE VALUES(2,'2','Arblaster','David','','Edit Test','','David','',true,'Y','','','',0,0,'','','','',1,9,3,15,true,0,true,'2000-05-04 14:58:59.0','','2000-03-04 11:59:57.0')
INSERT INTO TBL_PEOPLE VALUES(3,'3','Smith','Bill','','Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qu','','Bill','Y',true,'Y','','Y','',0,0,'','','','',0,0,0,0,true,1,true,NULL,'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qu',NULL)
INSERT INTO TBL_PEOPLE VALUES(4,'4','Bloggs 3','Joe','','','','Joe','N',true,'N','','N','',3,2,'','','','',1,0,4,0,true,0,true,'2000-04-10 19:17:53.0','','2000-04-07 15:06:52.0')
INSERT INTO TBL_PEOPLE VALUES(110,'110','Aldiss','Brian','','','','Bury.Me@WH.Smith.com','N',true,'N','','N','',0,0,'','','','',0,0,0,0,true,0,true,NULL,'',NULL)
INSERT INTO TBL_PEOPLE VALUES(105,'105','Banks','Ian','','','','Ian.Banks@GoodWriter.org','N',true,'N','','N','',1,1,'','','','',1,0,1,0,true,0,true,NULL,'',NULL)
INSERT INTO TBL_PEOPLE VALUES(22,'22','McCleod','Ken','Mr','','','ken.McCleod@Scotland.com','N',true,'N','Y','N','',1,1,'','','','',1,0,1,0,true,0,true,NULL,'',NULL)
INSERT INTO TBL_PEOPLE VALUES(21,'21','Pratchett','Terry','Mr','Test Update 2','','pterry@somewhere.com','N',true,'N','','N','',1,1,'','','','',1,0,1,0,true,0,true,NULL,'',NULL)
INSERT INTO TBL_PEOPLE VALUES(1000,'1000','Martin','George R R','','','','George.Martin@fever.dream.com','N',true,'N','','N','',1,1,'','','','',1,0,1,0,true,0,false,NULL,'',NULL)
INSERT INTO TBL_ROOM_AVAIL VALUES(1,1,9.5,15.0)
INSERT INTO TBL_ROOM_AVAIL VALUES(1,2,15.0,23.0)
INSERT INTO TBL_ROOM_AVAIL VALUES(4,1,17.0,26.0)
INSERT INTO TBL_ROOMS VALUES(0,NULL,'Not Assigned',NULL,NULL,'2000-01-09 10:08:56.0')
INSERT INTO TBL_ROOMS VALUES(1,NULL,'Auditorium',500,NULL,'2000-04-05 22:04:39.0')
INSERT INTO TBL_ROOMS VALUES(2,NULL,'Room 2',0,NULL,'2000-04-06 21:47:43.0')
INSERT INTO TBL_ROOMS VALUES(3,NULL,'Room 3',50,NULL,'2000-04-09 18:13:02.0')
INSERT INTO TBL_ROOMS VALUES(4,NULL,'Video Room',0,NULL,NULL)
INSERT INTO TBL_ROOMS VALUES(999120410,NULL,'Main Hall',NULL,NULL,NULL)
INSERT INTO TBL_ROOMS VALUES(999120433,NULL,'Lecture 1',NULL,NULL,NULL)
INSERT INTO TBL_ROOMS VALUES(999120509,NULL,'Lecture 2',NULL,NULL,NULL)
INSERT INTO TBLCURRENTSELECTIONS VALUES(3,2,2,7,1,'C:\ProgDB\Dev\',NULL,NULL)
INSERT INTO TBLDAYS VALUES(6,'1. Thursday')
INSERT INTO TBLDAYS VALUES(1,'2. Friday')
INSERT INTO TBLDAYS VALUES(2,'3. Saturday')
INSERT INTO TBLDAYS VALUES(3,'4. Sunday')
INSERT INTO TBLDAYS VALUES(4,'5. Monday')
INSERT INTO TBLDAYS VALUES(0,'0. Not Assigned')
INSERT INTO TBLDAYS VALUES(5,'6.Tuesday')
INSERT INTO TBLMPVRR VALUES(1,1,'Auditorium')
INSERT INTO TBLMPVRR VALUES(2,2,'Room 2')
INSERT INTO TBLMPVRR VALUES(3,3,'Room 3')
INSERT INTO TBLMPVRR VALUES(4,4,'Video Room')
INSERT INTO TBLMPVSTATES VALUES(0,'Dead',NULL)
INSERT INTO TBLMPVSTATES VALUES(10,'Available','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e5069637475726500010500000200000007000000504272757368000000000000000000a00f0000424d860f000000000000360000002800000041000000140000000100180000000000500f0000c40e0000c40e00000000000000000000b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00b3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffffb3ffff00000000000000000000000000000000000000000000000000000001050000000000002fad05fe')
INSERT INTO TBLMPVSTATES VALUES(11,'In Use','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e5069637475726500010500000200000007000000504272757368000000000000000000a00f0000424d860f000000000000360000002800000041000000140000000100180000000000500f0000c40e0000c40e00000000000000000000ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a4ffd1a400000000000000000000000000000000000000000000000000000001050000000000002fad05fe')
INSERT INTO TBLMPVSTATES VALUES(12,'Double Booked','151c2f00020000000d000e0014002100ffffffff4269746d617020496d616765005061696e742e5069637475726500010500000200000007000000504272757368000000000000000000a00f0000424d860f000000000000360000002800000041000000140000000100180000000000500f0000c40e0000c40e000000000000000000008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf8008e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf88e8bf800000000000000000000000000000000000000000000000000000001050000000000002fad05fe')
INSERT INTO TBLSYSTEMSETTINGS VALUES('SampleCon Alpha','spliflicatus extraordinary',true,true,NULL,'"C:\ProgDB\Version Log.doc"','"C:\Program Files\Microsoft Office\Office\winword.exe"','C:\ProgDB\Dbase\Items.dbf',false,'C:\ProgDB\Dbase\Precis.dbf',true,'C:\ProgDB\Dbase\People.dbf',true,'C:\ProgDB\Dbase\Bios.dbf',true,'C:\ProgDB\Dbase\Ison.dbf',true,NULL,false,NULL,9000,10000,0.75,8)
INSERT INTO TBLTIMES VALUES(0.0)
INSERT INTO TBLTIMES VALUES(9.0)
INSERT INTO TBLTIMES VALUES(9.5)
INSERT INTO TBLTIMES VALUES(10.0)
INSERT INTO TBLTIMES VALUES(11.0)
INSERT INTO TBLTIMES VALUES(12.0)
INSERT INTO TBLTIMES VALUES(13.0)
INSERT INTO TBLTIMES VALUES(14.0)
INSERT INTO TBLTIMES VALUES(15.0)
INSERT INTO TBLTIMES VALUES(16.0)
INSERT INTO TBLTIMES VALUES(17.0)
INSERT INTO TBLTIMES VALUES(18.0)
INSERT INTO TBLTIMES VALUES(19.0)
INSERT INTO TBLTIMES VALUES(20.0)
INSERT INTO TBLTIMES VALUES(21.0)
INSERT INTO TBLTIMES VALUES(22.0)
INSERT INTO TBLTIMES VALUES(23.0)
INSERT INTO TBLTIMES VALUES(24.0)
INSERT INTO TBLTIMES VALUES(25.0)
INSERT INTO TBLTIMES VALUES(26.0)
INSERT INTO TBL_LENGTHS VALUES('00:30',0.5)
INSERT INTO TBL_LENGTHS VALUES('01:00',1.0)
INSERT INTO TBL_LENGTHS VALUES('01:30',1.5)
INSERT INTO TBL_LENGTHS VALUES('02:00',2.0)
INSERT INTO TBL_LENGTHS VALUES('02:30',2.5)
INSERT INTO TBL_LENGTHS VALUES('03:00',3.0)
INSERT INTO TBL_ITEMS VALUES(-1,NULL,1,NULL,0,9.5,1.5,NULL,0,0,NULL,'Test PlaceHolder',NULL,NULL,0,false,0,NULL,NULL,'2000-04-10 12:16:10.0','2000-04-07 15:28:13.0',NULL)
INSERT INTO TBL_ITEMS VALUES(3,NULL,2,NULL,1,10.0,1.0,NULL,0,0,NULL,'Test 3',NULL,NULL,0,false,0,NULL,'A test precis, where various test program participants waffle on about the ineffable, does it, will it, can it work \u2026 and so on.','2000-04-09 20:11:42.0','2000-04-06 21:47:25.0',NULL)
INSERT INTO TBL_ITEMS VALUES(4,NULL,1,NULL,1,12.0,1.0,NULL,0,0,NULL,'Test 4',NULL,NULL,0,false,0,NULL,'A test precis, where various test program participants waffle on about the ineffable, does it, will it, can it work \u2026 and so on.','2000-04-09 20:12:17.0','2000-04-07 08:45:00.0',NULL)
INSERT INTO TBL_ITEMS VALUES(9,'hugos',1,NULL,2,20.0,2.0,NULL,0,0,'Billions and billions of dollars worth','Hugo Awards Ceremony',NULL,NULL,0,false,0,NULL,'Hugo Awards Ceremony','2000-04-09 18:16:51.0','2000-04-09 18:15:58.0',0)
INSERT INTO TBL_ITEMS VALUES(10,'hugorehear',1,NULL,2,15.0,1.0,NULL,0,0,NULL,'Hugo Rehearsal',NULL,NULL,0,false,0,NULL,'','2000-04-09 19:28:44.0','2000-04-09 19:27:54.0',0)
INSERT INTO TBL_ITEMS VALUES(11,NULL,0,NULL,0,9.25,1.0,NULL,0,0,NULL,'New Item',NULL,NULL,0,false,0,NULL,NULL,NULL,'2000-04-10 08:27:49.0',0)
INSERT INTO TBL_ITEMS VALUES(13,'f-aliennat',4,NULL,1,17.0,2.0,NULL,0,0,NULL,'Alien Nation (Hugo Nominee)',NULL,NULL,0,false,0,NULL,'Can''t parse dbase memo field','2000-04-10 13:15:32.0','2000-04-10 13:13:35.0',0)
INSERT INTO TBL_ITEMS VALUES(14,'awardanx',3,NULL,1,9.0,1.0,NULL,0,0,NULL,'Award Anxiety - How Do You Feel Before the Hugos Are Awarded?',NULL,NULL,0,false,0,NULL,'Can''t parse dbase memo field','2000-04-15 09:30:02.0','2000-04-10 13:13:43.0',0)
INSERT INTO TBL_ITEMS VALUES(15,'f-beetleju',4,NULL,1,19.0,2.0,NULL,0,0,NULL,'Beetlejuice (Hugo Nominee)',NULL,NULL,0,false,0,NULL,'Can''t parse dbase memo field','2000-04-10 13:15:43.0','2000-04-10 13:13:45.0',0)
INSERT INTO TBL_ITEMS VALUES(16,'f-big',4,NULL,1,21.0,1.75,NULL,0,0,NULL,'Big (Hugo Nominee)',NULL,NULL,0,false,0,NULL,'Can''t parse dbase memo field','2000-04-10 13:22:28.0','2000-04-10 13:13:46.0',0)
INSERT INTO TBL_ITEMS VALUES(17,'hugolost',0,NULL,0,0.0,0.0,NULL,0,0,NULL,'How Do You Feel About Losing a Hugo?',NULL,NULL,0,false,0,NULL,'Can''t parse dbase memo field','2000-04-10 13:13:51.0','2000-04-10 13:13:51.0',0)
INSERT INTO TBL_ITEMS VALUES(18,'f-hugowinn',0,NULL,0,0.0,2.0,NULL,0,0,NULL,'THE HUGO WINNER',NULL,NULL,0,false,0,NULL,'Can''t parse dbase memo field','2000-04-10 13:13:57.0','2000-04-10 13:13:57.0',0)
INSERT INTO TBL_ITEMS VALUES(19,'f-roger',0,NULL,0,0.0,1.5,NULL,0,0,NULL,'Who Framed Roger Rabbit (Hugo Nominee)',NULL,NULL,0,false,0,NULL,'Can''t parse dbase memo field','2000-04-10 13:14:02.0','2000-04-10 13:14:02.0',0)
INSERT INTO TBL_ITEMS VALUES(21,'scienceill',0,NULL,0,0.0,0.0,NULL,0,0,NULL,'The science illustrator',NULL,NULL,0,false,0,NULL,'','2000-04-11 09:05:42.0','2000-04-11 09:05:42.0',0)
INSERT INTO TBL_ITEMS VALUES(22,'acad416',0,NULL,0,0.0,0.0,NULL,0,0,NULL,'Academic Papers',NULL,NULL,0,false,0,NULL,'','2000-04-11 09:06:59.0','2000-04-11 09:06:59.0',0)
INSERT INTO TBL_ITEMS VALUES(23,'artwriters',2,NULL,1,12.0,1.0,NULL,0,0,NULL,'The Artist and the Writer',1,NULL,0,false,0,NULL,'','2000-05-02 20:59:21.0','2000-04-11 10:40:04.0',0)
INSERT INTO TBL_ITEMS VALUES(6,'conservat',3,'',1,11.0,1.0,'',0,0,'','A Question of Fannish Conservatism',NULL,NULL,0,false,0,'','Question:  For a bright population so full of ideas, why is fandom so conservative?  Is it related to the nerd''s desire of belonging and the security of being accepted?  Do you view this as a good, bad or indifferent thing?  What are some examples of intransigence in fandom?','2000-04-09 18:13:56.0','2000-04-09 17:54:29.0',0)
INSERT INTO TBL_ITEMS VALUES(24,'3d',0,'',0,0.0,0.0,'',0,0,'','3D SF Art an examination',1,NULL,0,false,0,'',' How useful are they? How does a writer know when they will need an agent?  What does an agent do so that a writer can get on with their writing? How is an agent helpful with a contract? ','2000-04-11 10:40:29.0','2000-04-11 10:40:29.0',0)
INSERT INTO TBL_ITEMS VALUES(995809144,'',1,NULL,1,10.0,1.0,'',NULL,NULL,'','=101 Dummy Item',5,8,NULL,NULL,NULL,'','dqwqwr\u000d\u000a\u000d\u000a\u000d\u000a\u000d\u000a\u000d\u000a\u000d\u000a\u000d\u000a\u000d\u000a',NULL,NULL,NULL)
INSERT INTO TBL_ITEMS VALUES(1,NULL,1,NULL,1,10.0,1.0,'',0,0,'','Test Item',1,13,0,NULL,0,'','A test precis, where various test program participants waffle on about the ineffable, does it, will it, can it work ? and so on.','2000-04-10 13:10:30.0','2000-02-26 13:36:38.0',NULL)
INSERT INTO TBL_ITEMS VALUES(12,'1991hugos',2,'',1,14.0,1.0,'',0,0,'999042035','1991: The Year in Review -- Nominating for the Hugos',1,1,0,NULL,0,'','A review of the works that were, or should have been, nominated for the Hugo.','2000-04-10 13:23:24.0','2000-04-10 13:13:33.0',0)
INSERT INTO TBL_ITEMS VALUES(20,'f-willow',0,NULL,0,0.0,2.0,'',0,0,'999044846','Willow (Hugo Nominee)',1,1,0,NULL,0,'','Can''t parse dbase memo field','2000-04-10 13:14:03.0','2000-04-10 13:14:03.0',0)
INSERT INTO TBL_ITEMS VALUES(995325344,'',2,'',2,24.0,1.5,'Notes: 1\u000d\u000aLorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum',NULL,NULL,'999044846','+001 Edit Test 2',11,12,NULL,true,NULL,'','Precis: 1\u000d\u000aLorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum',NULL,NULL,NULL)
INSERT INTO TBL_ITEMS VALUES(999370294,NULL,0,NULL,5,12.0,0.5,'',NULL,NULL,'999041998','1900 Looking forward to the 20th Century',1,1,NULL,NULL,NULL,'','Were Jules Verne and H.G. Wells Right ?',NULL,NULL,NULL)
INSERT INTO TBL_ITEMS VALUES(7,'litagents',3,'',1,11.0,0.5,'Needs at least one brave agent.',0,0,'999041954','15% off the top: The cost of SF literary agents',1,1,0,NULL,0,'',' How useful are they? How does a writer know when they will need an agent?  What does an agent do so that a writer can get on with their writing? How is an agent helpful with a contract? ','2000-04-09 18:13:38.0','2000-04-09 18:08:51.0',0)
INSERT INTO TBL_ITEMS VALUES(8,'watchmen',3,NULL,0,13.0,1.0,'',3,5,'999041998','The Watchmen- best other form of 87 ',1,1,0,NULL,0,'','','2000-04-16 10:32:43.0','2000-04-09 18:11:12.0',0)
INSERT INTO TBL_ITEMS VALUES(5,'conplay',1,NULL,1,19.0,2.0,'',0,0,'999041998','Conventional Behavior - a play by Jeralyn Horton ',1,1,0,NULL,0,'','','2000-05-03 08:24:06.0','2000-04-09 17:37:38.0',0)