SQLite format 3@ 3#3-) 2 v " LU^4j5I#indexsqlite_autoindex_roles_pages_1roles_pagesp?tablepagespagesCREATE TABLE pages ( id INTEGER PRIMARY KEY NOT NULL, display_value VARCHAR2(30) NOT NULL, description VARCHAR2(200), modified_date TIMESTAMP(11), created_date TIMESTAMP(11) NOT NULL DEFAULT 'systimestamp' )>StablecountrycountryCREATE TABLE country ( iso CHAR(2) NOT NULL PRIMARY KEY, name VARCHAR(80) NOT NULL, printable_name VARCHAR(80) NOT NULL, iso3 CHAR(3), numcode SMALLINT )-Aindexsqlite_autoindex_country_1country`)!indexunique_foo_barauthor_oldCREATE UNIQUE INDEX unique_foo_bar ON author_old (foo, bar)!!Mtableauthor_oldauthor_oldCREATE TABLE author_old ( first_name VARCHAR(100), last_name VARCHAR(100), country_iso char(2), birthdate DATETIME, foo VARCHAR(24), bar VARCHAR(24), CONSTRAINT name PRIMARY KEY (first_name, last_name) )3G!indexsqlite_autoindex_author_old_1author_oldvKtablegenregenreCREATE TABLE genre ( id INTEGER PRIMARY KEY, name varchar(100), is_active INTEGER )/%%!tablebooks_genresbooks_genresCREATE TABLE books_genres ( book_id INTEGER REFERENCES book, genre_id INTEGER REFERENCES genre, primary key (book_id, genre_id) )7K%indexsqlite_autoindex_books_genres_1books_genresbtableformatformatCREATE TABLE format ( id INTEGER PRIMARY KEY, name varchar(100) )AUtableborrowerborrowerCREATE TABLE borrower ( id INTEGER PRIMARY KEY, name varchar(100), phone varchar(20), url varchar(100), email varchar(100), active integer ) %%itableauthor_booksauthor_booksCREATE TABLE author_books ( author_id INTEGER, book_id INTEGER, PRIMARY KEY (author_id, book_id) )7K%indexsqlite_autoindex_author_books_1author_books7 Itableauthorauthor CREATE TABLE author ( author_id INTEGER PRIMARY KEY, first_name VARCHAR(100), last_name VARCHAR(100), country_iso char(2), birthdate DATETIME ); [indexisbnbook CREATE UNIQUE INDEX isbn ON book (isbn)I )cindexbook_idx_ownerbook CREATE INDEX book_idx_owner ON book (owner)L +gindexbook_idx_formatbook CREATE INDEX book_idx_format ON book (format)R/oindexbook_idx_borrowerbook CREATE INDEX book_idx_borrower ON book (borrower)g1tablebookbookCREATE TABLE book ( id INTEGER PRIMARY KEY, isbn varchar(100), title varchar(100), publisher varchar(100), pages int, year int, format int REFERENCES format, genre int REFERENCES genre, borrower int REFERENCES borrower, borrowed varchar(100), owner int REFERENCES user, extra varchar(100) )-1tableaddressaddressCREATE TABLE address ( address_id INTEGER PRIMARY KEY, user_id INTEGER, street VARCHAR(32), city VARCHAR(32), country_iso char(2) )tableemployeremployerCREATE TABLE employer ( employer_id INTEGER PRIMARY KEY, name VARCHAR(32), category VARCHAR(32), country VARCHAR(24) )p''tableuser_employeruser_employerCREATE TABLE user_employer ( user_id INTEGER, employer_id INTEGER ) gtablelicenseslicensesCREATE TABLE licenses ( license_id INTEGER, name VARCHAR(32), label VARCHAR(32), active INTEGER )AYtableoptionsoptionsCREATE TABLE options ( options_id INTEGER PRIMARY KEY, option_one VARCHAR(32), option_two VARCHAR(32), option_three VARCHAR(32), user_id INTEGER )stableuseruserCREATE TABLE user ( user_id INTEGER PRIMARY KEY, user_name VARCHAR(32), fav_cat VARCHAR(32), fav_book VARCHAR(32), occupation VARCHAR(32), country_iso char(2), birthdate DATETIME, opt_in INTEGER, license_id INTE ~5zG%!3Joe Smith2!3Joe SmithProgrammer1974-04-21 00:00:00: #3 plaxSci-FiFungibilityeditorPL1977-10-24 22:22:22K !5!3jswHistoricalHistory of the WorldunemployedRU1965-03-24 22:22:22G /!3 samTechnicalHigher Order PerlprogrammerUS1973-05-24 22:22:22> '3muffetFantasyCooking FunginoneGB1983-10-24 22:22:22@ %!3jdoeSci-FiNecronomiconmanagementUS1970-04-23 00:00:00  yellowredgreengraybrownblackturquoisetealpumpkingreensky bluefuchsiaorangepurpleyellow blueredgreen QQ:-U Creative CommonsCreative Commons Attribution license#? LGPLGNU Lesser Public License#A GPLGNU General Public License' '7 Perl ArtisticPerl Artistic License    hh_+')Ac )#Convoluted PHPProgrammingDE/Contractor HeavenLosingDE )Convoluted PHPMarketingDE!#Worst PerlProgrammingUKBest PerlPerlUS #`>7 /!1101 Maple StreetSmallvilleAT /!1101 Maple '!1023 Side AveSanta LolaGF 99 Elm StDownTownUT #%991 Star StNowhere CityGK!+399 Cherry ParkJimsvilleUT##142 Main StMiddle CityGK< '!1023 Side AveSa%  +999 Main StreetPodunkUT ##101 Main StMiddle CityGK Y Gm/^ G { abcc-M1\-=5R-M1AM1How to Test Perl Form ProcessorsEreWhon PublishingG 'I   0-7475-8134-6Harry Potter and the Last GaspBoomsbury!W 'U! 0-596-10092-2Perl Testing: A Developer's NotebookO'Reilly2009-01-16K )+-! 123-1234-0-123Winnie The PoohHoughton MifflinY2008-11-14I 782128254The Complete Java 2 Certification Study Guide: Programmer's and Developers Exams (With CD-ROM)Sybex Inc< '! 434012386The ConfusionHeinemannY2009-01-16= )! 9 788256006199IdiotenInterbook/m2004-00-10R '_   0-7475-5100-6Harry Potter and the Order of the PhoenixBoomsbury               too 12143022 '0-7475-8134-6'0-596-10092-2)123-1234-0-123 782128254 434012386)9 788256006199' 0-7475-5100-6 V-' 3IanLangworthUK1971-12-22 00:00:00$ 3chromaticUK1969-10-01 00:00:00$3A.A.MilneUK1904-08-09 00:00:00(3MichaelErnestUK1970-10-01 00:00:00'3PhilipHellerUS1976-01-01 00:00:00'3SimonRobertsUK1975-05-01 00:00:00)!3NeilStephensonUS1959-10-31 00:00:00,#3FyodorDostoyevskyRU1821-11-11 00:00:00&3J.K.RowlingGB2003-01-16 00:00:00      -b-3+%/ Mistress Muffet999-000-2222muffet@tuffet.orgB%?) John Doe607-222-3333http://www.somewhere.com/john@gmail.comG-#9+ Ole Øyvind Hove23 23 14 97http://thefeed.no/oleooleo@trenger.ro In Shelf  E-book'Graphic NovelTradeComic Hardcover Paperback                   Technical Fantasy!Historical Mystery  Computers  Sci-Fi dd2!3NeilStephensonUS1959-10-31 00:00:00foo2foo35#3FyodorDostoyevskyRU1821-11-11 00:00:00foo1bar1/3J.K.RowlingGB2003-01-16 00:00:00foo0bar0 !NeilStephenson#FyodorDostoyevsky J.K.Rowling  foo2foo3 foo1bar1  foo0bar0  |\1R' ZWZIMBABWEZimbabweZWE'''USUNITED STATESUnited StatesUSAH)))GBUNITED KINGDOMUnited KingdomGBR:1 11RURUSSIAN FEDERATIONRussian FederationRUS ROROMANIARomaniaROM PTPORTUGALPortugalPRTl PLPOLANDPolandPOLh DEGERMANYGermanyDEUFRFRANCEFranceFRADKDENMARKDenmarkDNK)))CZCZECH REPUBLICCzech RepublicCZEAUAUSTRALIAAustraliaAUS$ATATLANTISAtlantisATL'''GFGRAND FENWICKGrand FenwickGFKUTUTOPIAUtopiaUTOGKGRAUSTARKGraustarkGRA ZWUSGBRU RO PT PL DE FRDKCZAUATGFUT GK      X l  (sjz w > B w stableuseruserCREATE TABLE user ( user_id INTEGER PRIMARY KEY, user_name VARCHAR(32), fav_cat VARCHAR(32), fav_book VARCHAR(32), occupation VARCHAR(32), country_iso char(2), birthdate DATETIME, opt_in INTEGER, license_id INTEGER )AYtableoptionsoptionsCREATE TABLE options ( options_id INTEGER PRIMARY KEY, option_one VARCHAR(32), option_two VARCHAR(32), option_three VARCHAR(32), user_id INTEGER ) gtablelicenseslicensesCREATE TABLE licenses ( license_id INTEGER, name VARCHAR(32), label VARCHAR(32), active INTEGER )p''tableuser_employeruser_employerCREATE TABLE user_employer ( user_id INTEGER, employer_id INTEGER )tableemployeremployerCREATE TABLE employer ( employer_id INTEGER PRIMARY KEY, name VARCHAR(32), category VARCHAR(32), country VARCHAR(24) )-1tableaddressaddressCREATE TABLE address ( address_id INTEGER PRIMARY KEY, user_id INTEGER, street VARCHAR(32), city VARCHAR(32), country_iso char(2) )g1tablebookbookCREATE TABLE book ( id INTEGER PRIMARY KEY, isbn varchar(100), title varchar(100), publisher varchar(100), pages int, year int, format int REFERENCES format, genre int REFERENCES genre, borrower int REFERENCES borrower, borrowed varchar(100), owner int REFERENCES user, extra varchar(100) )R/oindexbook_idx_borrowerbook CREATE INDEX book_idx_borrower ON book (borrower)L +gindexbook_idx_formatbook CREATE INDEX book_idx_format ON book (format)I )cindexbook_idx_ownerbook CREATE INDEX book_idx_owner ON book (owner); [indexisbnbook CREATE UNIQUE INDEX isbn ON book (isbn)7 Itableauthorauthor CREATE TABLE author ( author_id INTEGER PRIMARY KEY, first_name VARCHAR(100), last_name VARCHAR(100), country_iso char(2), birthdate DATETIME ) %%itableauthor_bostableuseruserCREATE TABLE user ( user_id INTEGER PRIMARY KEY, user_name VARCHAR(32), fav_cat VARCHAR(32), fav_book VARCHAR(32), occupation VARCHAR(32), country_iso char(2), birthdate DATETIME, opt_in INTEGER, license_id INTEGER )AYtableoptionsoptionsCREATE TABLE options ( options_id INTEGER PRIMARY KEY, option_one VARCHAR(32), option_two VARCHAR(32), option_three VARCHAR(32), user_id INTEGER ) gtablelicenseslicensesCREATE TABLE licenses ( license_id INTEGER, name VARCHAR(32), label VARCHAR(32), active INTEGER )p''tableuser_employeruser_employerCREATE TABLE user_employer ( user_id INTEGER, employer_id INTEGER )tableemployeremployerCREATE TABLE employer ( employer_id INTEGER PRIMARY KEY, name VARCHAR(32), category VARCHAR(32), country VARCHAR(24) )-1tableaddressaddressCREATE TABLE address ( address_id INTEGER PRIMARY KEY, user_id INTEGER, street VARCHAR(32), city VARCHAR(32), country_iso char(2) )g1tablebookbookCREATE TABLE book ( id INTEGER PRIMARY KEY, isbn varchar(100), title varchar(100), publisher varchar(100), pages int, year int, format int REFERENCES format, genre int REFERENCES genre, borrower int REFERENCES borrower, borrowed varchar(100), owner int REFERENCES user, extra varchar(100) )R/oindexbook_idx_borrowerbook CREATE INDEX book_idx_borrower ON book (borrower)L +gindexbook_idx_formatbook CREATE INDEX book_idx_format ON book (format)I )cindexbook_idx_ownerbook CREATE INDEX book_idx_owner ON book (owner); [indexisbnbook CREATE UNIQUE INDEX isbn ON book (isbn)7 Itableauthorauthor CREATE TABLE author ( author_id INTEGER PRIMARY KEY, first_name VARCHAR(100), last_name VARCHAR(100), country_iso char(2), birthdate DATETIME ) %%itableauthor_booksauthor_booksCREATE TABLE author_books ( author_id INTEGER, book_id INTEGER, PRIMARY KEY (author_id, book_id) )  c E m  X k , [N[cd~Stablebook2pkbook2pk"CREATE TABLE book2pk ( libraryid INTEGER NOT NULL DEFAULT 1, id INTEGER NOT NULL, isbn varchar(100), title varchar(100), publisher varchar(100), pages int, year int, PRIMARY KEY (libraryid, id) )- Aindexsqlite_autoindex_book2pk_1book2pk#T#}indexunique_roleroles!CREATE UNIQUE INDEX unique_role ON roles (display_value)tablerolesroles CREATE TABLE roles ( id INTEGER PRIMARY KEY NOT NULL, display_value VARCHAR2(30) NOT NULL, description VARCHAR2(200), active smallint(38) NOT NULL DEFAULT '1 ', modified_date TIMESTAMP(11), created_date DATETIME(11) NOT NULL DEFAULT 'systimestamp' )7K%indexsqlite_autoindex_author_books_1author_booksAUtableborrowerborrowerCREATE TABLE borrower ( id INTEGER PRIMARY KEY, name varchar(100), phone varchar(20), url varchar(100), email varchar(100), active integer )btableformatformatCREATE TABLE format ( id INTEGER PRIMARY KEY, name varchar(100) )/%%!tablebooks_genresbooks_genresCREATE TABLE books_genres ( book_id INTEGER REFERENCES book, genre_id INTEGER REFERENCES genre, primary key (book_id, genre_id) )7K%indexsqlite_autoindex_books_genres_1books_genresvKtablegenregenreCREATE TABLE genre ( id INTEGER PRIMARY KEY, name varchar(100), is_active INTEGER )!!Mtableauthor_oldauthor_oldCREATE TABLE author_old ( first_name VARCHAR(100), last_name VARCHAR(100), country_iso char(2), birthdate DATETIME, foo VARCHAR(24), bar VARCHAR(24), CONSTRAINT name PRIMARY KEY (first_name, last_name) )3G!indexsqlite_autoindex_author_old_1author_old`)!indexunique_foo_barauthor_oldCREATE UNIQUE INDEX unique_foo_bar ON author_old (foo, bar)>StablecountrycountryCREATE TABLE country ( iso CHAR(2) NOT NULL PRIMARY KEY, name VARCHAR(80) NOT NULL, printable_name VARCHAR(80) NOT NULL, iso3 CHAR(3), numcode SMALLINT )-Aindexsqlite_autoindex_country_1countryp?tablepagespagesCREATE TABLE pages ( id INTEGER PRIMARY KEY NOT NULL, display_value VARCHAR2(30) NOT NULL, description VARCHAR2(200), modified_date TIMESTAMP(11), created_date TIMESTAMP(11) NOT NULL DEFAULT 'systimestamp' ) ##[tableroles_pagesroles_pagesCREATE TABLE roles_pages ( role_fk NUMBER(38) NOT NULL, page_fk NUMBER(38) NOT NULL, edit_flag NUMBER(38) NOT NULL DEFAULT '0 ', created_date TIMESTAMP(11) NOT NULL DEFAULT 'systimestamp', PRIMARY KEY (role_fk, page_fk) )5I#indexsqlite_autoindex_roles_pages_1roles_pagesl;#indexroles_pages_idx_page_fkroles_pagesCREATE INDEX roles_pages_idx_page_fk ON roles_pages (page_fk)   XVA 'I0-7475-8134-6Harry Potter and the Last GaspBoomsbury!F 'U0-596-10092-2Perl Testing: A Developer's NotebookO'Reilly: )+-123-1234-0-123Winnie The PoohHoughton MifflinY| I782128254The Complete Java 2 Certification Study Guide: Programmer's and Developers Exams (With CD-ROM)Sybex Inc, '434012386The ConfusionHeinemannY+ )9 788256006199IdiotenInterbook/mK '_0-7475-5100-6Harry Potter and the Order of the PhoenixBoomsbury