# MySQL dump 8.16 # # Host: localhost Database: TLDDB #-------------------------------------------------------- # Server version 3.23.47 # # Table structure for table 'ADDRESS' # DROP TABLE IF EXISTS ADDRESS; CREATE TABLE ADDRESS ( ADDR_ID int(8) NOT NULL default '0', ORG_ID int(8) NOT NULL default '0', STREET varchar(50) NOT NULL default '', CITY varchar(30) NOT NULL default '', STATE varchar(15) NOT NULL default '', ZIP int(5) NOT NULL default '0', PRIMARY KEY (ADDR_ID) ) TYPE=MyISAM; # # Dumping data for table 'ADDRESS' # LOCK TABLES ADDRESS WRITE; INSERT INTO ADDRESS VALUES (1,100006,'301 Century Pkwy','Allen','TX',75013),(2,100009,'413 E 4th Ave','Amarillo','TX',79101),(3,100020,'800 Guadalupe St','Austin','TX',78701),(4,100100,'1515 Young St','Dallas','TX',75201),(5,100038,'1118 North Main Street','Blanco','TX',78606),(6,100065,'522 W College St','Carthage','TX',75633),(7,100077,'220 S Bonham Ave','Cleveland','TX',77327),(8,100093,'708 E Goliad Ave','Crockett','TX',75835),(9,100103,'1700 Highway 51 S','Decatur','TX',76234),(10,100108,'502 Oakland St','Denton','TX',76201),(11,100124,'501 N Oregon St','El Paso','TX',79901),(12,100142,'500 W 3rd St','Fort Worth','TX',76102),(13,100144,'416 S Friendswood Dr','Friendswood','TX',77546),(14,100185,'500 McKinney St','Houston','TX',77002),(15,100200,'209 Nugent St','Johnson City','TX',78636),(16,100215,'855 S Jefferson','La Grange','TX',78945),(17,100223,'100 W Walker St','League City','TX',77573),(18,100231,'217 S Main St','Lockhart','TX',78644),(19,100243,'300 S Alamo Blvd','Marshall','TX',75670),(20,100256,'300 W Grubb Dr','Mesquite','TX',75149),(21,100280,'6720 NE Loop 820','North Richland Hills','TX',76180),(22,100292,'326 S Main St','Paris','TX',75460),(23,100319,'900 Civic Center Dr','Richardson','TX',75080),(24,100327,'701 E Mimosa St','Rockport','TX',78382),(25,100334,'600 Soledad St','San Antonio','TX',78205),(26,500109,'PO Box 97148','Waco','TX',76798),(27,500221,'PCL 1.128, 471; PO Box P','Austin','TX',78713),(28,500216,'P.O. Box 5188','Denton','TX',76203),(29,500224,'PO Box 830643','Dallas','TX',75083),(30,500210,'114 University Libraries','Houston','TX',77204); UNLOCK TABLES; # # Table structure for table 'AUTHORIZATION' # DROP TABLE IF EXISTS AUTHORIZATION; CREATE TABLE AUTHORIZATION ( AUTH_ID int(8) NOT NULL default '0', ORG_ID int(8) NOT NULL default '0', IP varchar(14) default NULL, USR_NAME varchar(20) NOT NULL default '', PASSWORD varchar(20) NOT NULL default '', PRIMARY KEY (AUTH_ID) ) TYPE=MyISAM; # # Dumping data for table 'AUTHORIZATION' # LOCK TABLES AUTHORIZATION WRITE; INSERT INTO AUTHORIZATION VALUES (1,100006,'','usrname01','password01'),(2,100009,'','usrname02','password02'),(3,100020,'','usrname03','password03'),(4,100100,'','usrname04','password04'),(5,100038,'','usrname05','password05'),(6,100065,'','usrname06','password06'),(7,100077,'','usrname07','password07'),(8,100093,'','usrname08','password08'),(9,100103,'','usrname09','password09'),(10,100108,'','usrname10','password10'),(11,100124,'','usrname11','password11'),(12,100142,'','usrname12','password12'),(13,100144,'','usrname13','password13'),(14,100185,'','usrname14','password14'),(15,100200,'','usrname15','password15'),(16,100215,'','usrname16','password16'),(17,100223,'','usrname17','password17'),(18,100231,'','usrname18','password18'),(19,100243,'','usrname19','password19'),(20,100256,'','usrname20','password20'),(21,100280,'','usrname21','password21'),(22,100292,'','usrname22','password22'),(23,100319,'','usrname23','password23'),(24,100327,'','usrname24','password24'),(25,100334,'','usrname25','password25'),(26,500109,'','usrname26','password26'),(27,500221,'','usrname27','password27'),(28,500216,'','usrname28','password28'),(29,500224,'','usrname29','password29'),(30,500210,'','usrname30','password30'); UNLOCK TABLES; # # Table structure for table 'EADDRESS' # DROP TABLE IF EXISTS EADDRESS; CREATE TABLE EADDRESS ( EA_ID int(8) NOT NULL default '0', ORG_ID int(8) NOT NULL default '0', EMAIL varchar(50) NOT NULL default '', PHONE varchar(15) NOT NULL default '', PRIMARY KEY (EA_ID) ) TYPE=MyISAM; # # Dumping data for table 'EADDRESS' # LOCK TABLES EADDRESS WRITE; INSERT INTO EADDRESS VALUES (1,100006,'bbuehler@ci.allen.tx.us','9727270190'),(2,100009,'reference@amarillolibrary.org','8063783050'),(3,100020,'aplmail@ci.austin.tx.us','5129747300'),(4,100100,'director@dallaslibrary.org','2146701400'),(5,100038,'blanlib@moment.net','2108333428'),(6,100065,'SammyBrownLibrary@msn.com','9036936741'),(7,100077,'aml@austinmemlib.org','2815923920'),(8,100093,'shofflib@crockettlibrary.com','9365443089'),(9,100103,'N/A','9406275512'),(10,100108,'library@cityofdenton.com','9403498566'),(11,100124,'lockhartws@ci.el-paso.tx.us','9155433541'),(12,100142,'ibrary@fortworthlibrary.org','8178717706'),(13,100144,'frpublib@friendswood.lib.tx.us','2814827135'),(14,100185,'website@hpl.lib.tx.us','8323931300'),(15,100200,'jclib@moment.net','8308684469'),(16,100215,'library@fais.net','9799683765'),(17,100223,'lwesterh@stic.lib.tx.us','2813388486'),(18,100231,'lockhart@jump.net','5123988322'),(19,100243,'pharmon@marshallpubliclibrary.org','9039354465'),(20,100256,'mainbr@library.mesquite.tx.us','9722166220'),(21,100280,'slb@flash.net','8175811570'),(22,100292,'pmcanally@neto.com','9037858531'),(23,100319,'wanda_vent@cor.gov','9727444350'),(24,100327,'mpolston@acplibrary.org','3617900153'),(25,100334,'libwebadmin@sanantonio.gov','2102072500'),(26,500109,'librarywebmaster@baylor.edu','2547102112'),(27,500221,'ladd@mail.utexas.edu','5124954299'),(28,500216,'webmaster@library.unt.edu','9405652413'),(29,500224,'jvik@utdallas.edu','9728832955'),(30,500210,'infoweb@lib.uh.edu','7137431050'); UNLOCK TABLES; # # Table structure for table 'ORGANIZATION' # DROP TABLE IF EXISTS ORGANIZATION; CREATE TABLE ORGANIZATION ( ORG_ID int(8) NOT NULL default '0', NAME varchar(40) NOT NULL default '', URL varchar(40) NOT NULL default '', LOGO varchar(50) default NULL, PRIMARY KEY (ORG_ID) ) TYPE=MyISAM; # # Dumping data for table 'ORGANIZATION' # LOCK TABLES ORGANIZATION WRITE; INSERT INTO ORGANIZATION VALUES (100006,'Allen Public Library','http://www.allenlibrary.org/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100009,'Amarillo Public Library','http://www.amarillolibrary.org','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100100,'Dallas Public Library','http://dallaslibrary.org','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100020,'Austin Public Library','http://www.ci.austin.tx.us/library/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100038,'Blanco Library','http://www.moment.net/~blanlib/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100065,'Sammy Brown Library','http://www.carthagetexas.com/sammybrown/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100077,'Austin Memorial Library','http://www.austinmemlib.org','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100093,'J.H. Wootters Crockett Public Library','http://www.crockettlibrary.com','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100103,'Decatur Public Library','http://www.decaturpubliclibrary.com/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100108,'Denton Public Library','http://www.dentonlibrary.com','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100124,'El Paso Public Library','http://www.ci.el-paso.tx.us/library/libr','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100142,'Fort Worth Public Library','http://www.fortworthlibrary.org','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100144,'Friendswood Public Library','http://www.friendswood.lib.tx.us/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100185,'Houston Public Library','http://www.hpl.lib.tx.us/hpl/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100200,'Johnson City Library','http://www.moment.net/~jclib/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100215,'Fayette Public Library','http://lagrange.fais.net/library/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100223,'Helen Hall Library','http://www.leaguecitylibrary.org','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100231,'Dr. Eugene Clark Library','http://www.library.ci.lockhart.tx.us','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100243,'Marshall Public Library','http://www.marshallpubliclibrary.org','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100256,'Mesquite Public Library','http://www.cityofmesquite.com/library/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100280,'North Richland Hills Public Library','http://www.library.nrhtx.com','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100292,'Paris Public Library','http://www.paristexaslibrary.com','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100319,'Richardson Public Library','http://www.cor.net/library/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100327,'Aransas County Public Library','http://www.acplibrary.org','http://www.unt.edu/zlot/RFP/zlot.jpg'),(100334,'San Antonio Public Library','http://www.sanantonio.gov/library','http://www.unt.edu/zlot/RFP/zlot.jpg'),(500109,'Baylor University','http://www3.baylor.edu/Library/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(500221,'University of Texas at Austin','http://www.lib.utexas.edu/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(500216,'University of North Texas at Denton','http://www.library.unt.edu/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(500224,'University of Texas at Dallas','http://www.utdallas.edu/library/','http://www.unt.edu/zlot/RFP/zlot.jpg'),(500210,'University of Houston','http://info.lib.uh.edu/','http://www.unt.edu/zlot/RFP/zlot.jpg'); UNLOCK TABLES;