CREATE TABLE ACCOUNT(ACNO CHAR(3), ACCOUNT CHAR(20));
CREATE TABLE AINWORD(ARTCODE CHAR(12));  
CREATE TABLE AKFWORD(ARTCODE CHAR(12));
CREATE TABLE ANTWORD(AATLS CHAR(16))
CREATE TABLE ARTCAT(CAT CHAR(3), ARTCAT CHAR(30))
CREATE TABLE ARTKEY(ARTCODE CHAR(12),BARTCODE CHAR(11),AKEYNO CHAR(6)) 
CREATE TABLE ARTMAN(ARTICID CHAR(6), ARTDESC VARCHAR(45))
CREATE TABLE ARTMAST(ARTCODE CHAR(12),ARTITLE VARCHAR(350),ARTAUTHL VARCHAR(40),ARTAUTHF VARCHAR(30),AJTAUTH1 VARCHAR(35),AJTAUTH2 VARCHAR(35),VOLUMENO CHAR(8),ATYPE CHAR(1),AAUTS CHAR(16),ATILS CHAR(16),AATLS CHAR(16),PAGES CHAR(10),ABSTRACT VARCHAR(4000), CONSTRAINT AM_PK PRIMARY KEY(ARTCODE)) 
CREATE TABLE ARTWORD(AATLS CHAR(16))
CREATE TABLE BACKVOLS(VOLCODE CHAR(10), STATUS CHAR(3), CONSTRAINT HL_PK PRIMARY KEY(VOLCODE))
CREATE TABLE BAINWORD(BARTCODE CHAR(11))
CREATE TABLE BAKFWORD(BARTCODE CHAR(11))
CREATE TABLE BINDERY(JCODE CHAR(4),BYEAR CHAR(4),BVOLUME CHAR(5),BRISSUES TINYINT(3),BTISSUES TINYINT(3),BPISSUES VARCHAR(250), CONSTRAINT BV_PK PRIMARY KEY(JCODE)) 
CREATE TABLE BUDGETB(VOUCHNO CHAR(5), PONO CHAR(15),DISCODE CHAR(4), ACNO CHAR(3), VENDCODE CHAR(4),INVOICENO CHAR(15), INVOIDATE DATE, BILLAMOUNT DECIMAL(9,2), BILLPASDAT DATE , CHKDD vARCHAR(100), PAIDATE DATE, ACCREG CHAR(5), PAGES CHAR(10), ACCNOS CHAR(15),PAYNOTE VARCHAR(100),CONSTRAINT BB_PK PRIMARY KEY(VOUCHNO))
CREATE TABLE BUDGETJ(VOUCHNO CHAR(5), PONO CHAR(15),DISCODE CHAR(4), ACNO CHAR(3),VENDCODE CHAR(4), INVOICENO CHAR(15), INVOIDATE DATE, BILLAMOUNT DECIMAL(9,2), BILLPASDAT DATE,  CHKDD VARCHAR(100),  PAIDATE DATE, PAYNOTE VARCHAR(100), CONSTRAINT BJ_PK PRIMARY KEY(VOUCHNO))
CREATE TABLE BULLETIN(ITEMNO CHAR(5),SUBJECT CHAR(30),SOURCE VARCHAR(100)) 
CREATE TABLE CATPAT (CATPAT CHAR(5))
CREATE TABLE CLASH(CLASCODE CHAR(7), HEADING CHAR(35)) 
CREATE TABLE CONTCODE(CCODE CHAR(2),COUNTRY CHAR(20),CONSTRAINT CC_PK PRIMARY KEY(CCODE)) 
CREATE TABLE CONTYPE(CONTYPE CHAR(30),CONTCOD CHAR(2)) 
CREATE TABLE COURESERV(CRC CHAR(4), COURSE CHAR(35), BOID CHAR(8), CONSTRAINT CR_PK PRIMARY KEY(CRC))
CREATE TABLE COURSE(KCODE CHAR(3),COURSE CHAR(15), CONSTRAINT CO_PK PRIMARY KEY(KCODE)) 
CREATE TABLE CROSREFR(KEYNO CHAR(6),SEE VARCHAR(35), SEEALSO VARCHAR(35)) 
CREATE TABLE CURISSUE(IC CHAR(2),JCODE CHAR(4),VENDCODE CHAR(4),DISCODE CHAR(4),COST DECIMAL(8,2),AMOUNTRS DECIMAL(10,2),KURRENCY CHAR(10), CONVERATE DECIMAL(5,2),PONO CHAR(6),SUBSDATE DATE, PODATE DATE, FIRSTVOL CHAR(5),FISSUDATE DATE,SUBSCRIPNO CHAR(15),SUBRENEWAL DATE,COPIES TINYINT(1),RENEW CHAR(1)) 
CREATE TABLE CURJART(ITEMNO CHAR(5),JCODE CHAR(4),REFERENCE CHAR(40),ARTITLE VARCHAR(150),AUTHORS VARCHAR(100)) 
CREATE TABLE CURSERIAL(ISSUCODE CHAR(8), STATUS CHAR(3), CONSTRAINT CS_PK PRIMARY KEY(ISSUCODE))
CREATE TABLE DISCIPLINE(DISCODE CHAR(4), DISCIPLINE VARCHAR(25), CONSTRAINT DC_PK PRIMARY KEY(DISCODE))
CREATE TABLE FINAL(UCAN CHAR(8)) 
CREATE TABLE FUNDSB(DISCODE CHAR(4),ACNO CHAR(3),ALLOTMENT DECIMAL(9,2),CLOSBALAN DECIMAL(9,2),DC CHAR(3), CONSTRAINT FB_UK UNIQUE(DISCODE,ACNO)) 
CREATE TABLE FUNDSJ(DISCODE CHAR(4),ACNO CHAR(3),ALLOTMENT DECIMAL(9,2),CLOSBALAN DECIMAL(9,2),DC CHAR(3), CONSTRAINT FJ_UK UNIQUE(DISCODE,ACNO)) 
CREATE TABLE GAPYEAR(IC CHAR(2),JCODE CHAR(4),GAPYER CHAR(9),GAPVOL VARCHAR(100)) 
CREATE TABLE GATEREGIS(BOID CHAR(8), ENTRYDATE DATE, EXITDATE DATE,ENTRYPOINT CHAR(10),DURATION TINYINT(3),FREQ TINYINT(1))
CREATE TABLE HOLIDAYS(HDATE DATE,HOLIDAY CHAR(25))
CREATE TABLE ILLUSTRATE(ILLC CHAR(1),ILLUSTRATE CHAR(25),  CONSTRAINT IL_PK PRIMARY KEY(ILLC))
CREATE TABLE IMPRINT(GAPID CHAR(10),PUBLISHER VARCHAR(75),PLACE VARCHAR(25),CONSTRAINT IM_PK PRIMARY KEY(GAPID)) 
CREATE TABLE INTERLIB(IC CHAR(2), LIBRARY VARCHAR(15), CONSTRAINT IC_PK PRIMARY KEY(IC))
CREATE TABLE INTWORD(UCAN CHAR(8)) 
CREATE TABLE KEYCAT(CAT CHAR(2), KEYCAT CHAR(30))
CREATE TABLE KEYMAN(KEYNO CHAR(5), KEYDESC VARCHAR(45))
CREATE TABLE KEYTERM(BOID CHAR(8),KEYTERM CHAR(20)) 
CREATE TABLE KEYTRANS(BOID CHAR(8), KEYNO CHAR(5), ISSUDATE DATE, OPERATOR CHAR(10))
CREATE TABLE KEYWORD(KEYNO CHAR(6),KEYWORD CHAR(35),CROSRFR CHAR(6),CONSTRAINT KW_PK PRIMARY KEY(KEYNO)) 
CREATE TABLE KWORDAND(UCAN CHAR(8))
CREATE TABLE KWORDOR(UCAN CHAR(8))
CREATE TABLE LANGUAGE(LANGCODE CHAR(3),LANGUAGE CHAR(20), CONSTRAINT LC_PK PRIMARY KEY(LANGCODE)) 
CREATE TABLE LIBADD(DISCODE CHAR(4),DISCIPLINE CHAR(20), TOTITLE CHAR(8), TOTVOLS CHAR(10), TOTAMT CHAR(12))
CREATE TABLE LIBARCH(TITLENO CHAR(5),QUESTION VARCHAR(60),ANSWER VARCHAR(100))
CREATE TABLE LIBASUB(TITLENO CHAR(5),TERM VARCHAR(30))
CREATE TABLE LIBMAP(LROW TINYINT(3),RACK TINYINT(3), SHC CHAR(3),STCALLNO CHAR(20),EDCALLNO CHAR(20), HALL VARCHAR(30),LOCATE CHAR(2))
CREATE TABLE LIBRULES(MEMCAT CHAR(1),DESCAT CHAR(25),MAXBOOKS TINYINT(2),LOANPERIOD TINYINT(2),FINEFORM CHAR(18),DEPOSIT TINYINT(3),AUTORENEW ENUM('Y','N'),NORENEWAL TINYINT(1),XTRABOOKS TINYINT(1),CONSTRAINT LR_PK PRIMARY KEY(MEMCAT)) 
CREATE TABLE MEMREGIS(BOID CHAR(8),LNAME VARCHAR(35),FNAME VARCHAR(25),ADD1 CHAR(40),ADD2 CHAR(40),CITY VARCHAR(25),STATE CHAR(2),PINCODE CHAR(6),EMAILID VARCHAR(30),TELNO CHAR(15),FORMOFADD CHAR(10),COURSE CHAR(15),REGDATE DATE,EXPDATE DATE, MESSAGE CHAR(1),CONDSTOP CHAR(1),OVERIDING CHAR(1),PASSWORD CHAR(10),BIRTHDATE DATE, BLDGROUP CHAR(4), CONSTRAINT MR_PK PRIMARY KEY(BOID)) 
CREATE TABLE MESSAGE(BOID CHAR(8),COMMENTS VARCHAR(40))
CREATE TABLE MULTIVOL(UCAN CHAR(8),ACCNUM CHAR(8),VOLUME CHAR(10),EDITION CHAR(2),VYEAR CHAR(4),VPAGE CHAR(5),VPRICE DECIMAL(8,2),STATUS CHAR(3),LISSUED DATE,FCOUNT TINYINT(4),CHCK CHAR(1),CONSTRAINT MV_PK PRIMARY KEY(ACCNUM))
CREATE TABLE NIRACS(TITLENO CHAR(5),UCAN CHAR(8),AUTHLAST VARCHAR(40),AUTHFIRST VARCHAR(30), JAUTH1 VARCHAR(35), JAUTH2 VARCHAR(35), TITLE VARCHAR(150),ACEIT CHAR(3),DELTAS CHAR(16),ISBN CHAR(13),GAPID CHAR(10),ATLS CHAR(16),DISCODE CHAR(7),PONO CHAR(13),VENDCODE CHAR(4),KURRENCY CHAR(10),PRICE DECIMAL(8,2),QUANTITY TINYINT(2),AMTRS DECIMAL(8,2),REQDATE DATE, ORDERDATE DATE,RCVDATE DATE, SEL CHAR(1),CONSTRAINT AC_PK PRIMARY KEY(TITLENO))
CREATE TABLE NIRBCS(UCAN CHAR(8),CLASSNO CHAR(15),CUTNO CHAR(10),CORPAUT ENUM('Y','N'),AUTHLAST VARCHAR(40),AUTHFIRST VARCHAR(30),JAUTH1 VARCHAR(35),JAUTH2 VARCHAR(35),TITLE VARCHAR(350),PDESCRIP VARCHAR(100),NOTES VARCHAR(4000),ACEIT CHAR(3),DELTAS CHAR(16),ISBN CHAR(13),GAPID CHAR(10),SERICODE CHAR(5),AUTS CHAR(16),TILS CHAR(16),ATLS CHAR(16),TAPS CHAR(5),DISCODE CHAR(7),RCVDDATE DATE,NFC CHAR(3),SEL CHAR(1),CONSTRAINT BC_PK PRIMARY KEY(UCAN),FULLTEXT KEY TITLE(TITLE,AUTHLAST,AUTHFIRST)) ENGINE=MyISAM 
CREATE TABLE OVERDUES(BOID CHAR(8),ACCNO CHAR(8),FINEAMT DECIMAL(6,2),DUEDATE DATE,RETDATE DATE,BILLNO CHAR(5),OPERATOR CHAR(10)) 
CREATE TABLE PATRON(BOID CHAR(8),ACCNO CHAR(8),ISSUDATE DATE, OPERATOR CHAR(10),QUICK ENUM('Y','N')) 
CREATE TABLE PERPROP(TAGNO CHAR(5), PROPDESC VARCHAR(60), PERMITDATE DATE, BOID CHAR(8), OPERATOR CHAR(10), CONSTRAINT PP_PK PRIMARY KEY(TAGNO))
CREATE TABLE PONACQ(PONO CHAR(15),DISCODE CHAR(7),VENDCODE CHAR(4),OCOMITMENT DECIMAL(8,2),CCOMITMENT DECIMAL(8,2),PODATE DATE, CONSTRAINT PA_PK PRIMARY KEY(PONO)) 
CREATE TABLE PROFILE(BOID CHAR(8),ATKWORD CHAR(25)) 
CREATE TABLE QUICKREFR(BOID CHAR(8),ACCNO CHAR(8),ISSUDATE DATE, OPERATOR CHAR(10))
CREATE TABLE RELOCATE(ACCNUM CHAR(8),DEPTACC CHAR(6),DISCODE CHAR(4),RLSTATUS CHAR(3),OLSTATUS CHAR(3),SEL ENUM('T','F'), CONSTRAINT RL_PK PRIMARY KEY(ACCNUM)) 
CREATE TABLE RESERVES(BOID CHAR(8),ACCNO CHAR(8), RSVDATE DATE, RECEIVED ENUM('Y','N')) 
CREATE TABLE SCARP(ITEMNO CHAR(5),JCODE CHAR(4),CURISSUE VARCHAR(25)) 
CREATE TABLE SERIAL(JCODE CHAR(4),SCLASSNO CHAR(10),CCODE CHAR(2),ISSN CHAR(8),FTITLE VARCHAR(150),VRTITLE VARCHAR(150),ISSUEBODY VARCHAR(150),IMPRINT VARCHAR(150),SNOTES VARCHAR(300),FLATS CHAR(8),STARTYR CHAR(4),ENDYEAR CHAR(4),ISSUEPERYR TINYINT(3),LOCATION CHAR(10),CONSTRAINT SL_PK PRIMARY KEY(JCODE)) 
CREATE TABLE SERIES(SERICODE CHAR(5),SERIES VARCHAR(75),CONSTRAINT SR_PK PRIMARY KEY(SERICODE))
CREATE TABLE SERMON(IC CHAR(2),JCODE CHAR(4),SDH CHAR(4),EDH CHAR(4),STARTVOL CHAR(5),ENDVOL CHAR(5),TOTVOLS TINYINT(4),GAPS ENUM('Y','N')) 
CREATE TABLE SERPAT(IC CHAR(2),JCODE CHAR(4),YEAR CHAR(4),VOLNO CHAR(5),ISSNO CHAR(2),ISSDATE DATE,RECDATE DATE,CLMDATE DATE) 
CREATE TABLE SPECIAL(BOID CHAR(8),SPACN CHAR(5), DOCUMENT VARCHAR(60), DUEDATE DATE, OPERATOR CHAR(10),CONSTRAINT SP_PK PRIMARY KEY(SPACN)) 
CREATE TABLE STATECODE(SCODE CHAR(2),STATE CHAR(20)) 
CREATE TABLE STATUS(STATUS CHAR(3), STXPAND VARCHAR(25), CONSTRAINT ST_PK PRIMARY KEY(STATUS))
CREATE TABLE STOCK(ACCNO CHAR(8),CLASSNO CHAR(15), CUTNO CHAR(10), VCNO CHAR(10), STATUS CHAR(3), CHK ENUM('T','F'))
CREATE TABLE STOPWORD(STOPWORD CHAR(20)) 
CREATE TABLE SUBJCODE(BBCLASS CHAR(15),SUBJECT VARCHAR(35),SEEALSO CHAR(15)) 
CREATE TABLE SUBJECT(UCAN CHAR(8),KEYNO CHAR(6), CONSTRAINT SJ_UK UNIQUE(UCAN,KEYNO))
CREATE TABLE SUBJHEAD(SHC CHAR(3), SUBJHEAD CHAR(25), CONSTRAINT SH_PK PRIMARY KEY(SHC)) 
CREATE TABLE SUGGEST(BOID CHAR(8),SUGGEST VARCHAR(150))
CREATE TABLE TAPS(TAPS VARCHAR(15), TAPCODE CHAR(1))
CREATE TABLE TRANCIRC(BOID CHAR(8),ACCNO CHAR(8),DUEDATE DATE,LRENEWAL DATE,NORENEW TINYINT(1),RESERVED ENUM('T','F'),RECALL ENUM('T','F'),LONGTERM ENUM('T','F'),OPERATOR CHAR(10),CONSTRAINT TC_PK PRIMARY KEY(ACCNO))
CREATE TABLE TRANSERIAL(ISSUCODE CHAR(8), ISSUDATE DATE, BOID CHAR(8))
CREATE TABLE USERCHART(BOID CHAR(8),MONTH1 TINYINT(3),MONTH2 TINYINT(3),MONTH3 TINYINT(3),MONTH4 TINYINT(3),MONTH5 TINYINT(3),MONTH6 TINYINT(3),MONTH7 TINYINT(3),MONTH8 TINYINT(3),MONTH9 TINYINT(3),MONTH10 TINYINT(3),MONTH11 TINYINT(3),MONTH12 TINYINT(3),NUSER TINYINT(3))
CREATE TABLE USERFREQ(BOID CHAR(8), FREQ TINYINT(3))
CREATE TABLE VENDOR(VENDCODE CHAR(4),VENDOR VARCHAR(60),ADR2 VARCHAR(40),ADR3 VARCHAR(40),CITY VARCHAR(40),STATE VARCHAR(30),PINC CHAR(6),PHONE CHAR(15),FAX CHAR(15),EMAILID VARCHAR(50), CONTACT VARCHAR(35),DESIGN VARCHAR(30),CONSTRAINT VC_PK PRIMARY KEY(VENDCODE)) 
CREATE TABLE VTITLE(ACCNUM CHAR(8),VTITLE VARCHAR(150),CONSTRAINT VT_PK PRIMARY KEY(ACCNUM)) 
CREATE TABLE XCHANGE(KURRENCY CHAR(10),CONVERATE DECIMAL(5,2))