CREATE TABLE opac_text (
			id varchar(255) NOT NULL,
			lang varchar(2) NOT NULL,
			label text NOT NULL,
			PRIMARY KEY (id, lang)
		);

INSERT INTO opac_text VALUES('TEXT_LOGGED_IN_AS', 'en', 'Logged in as');
INSERT INTO opac_text VALUES('TEXT_LOGGED_IN_AS', 'fr', 'Lecteur');
INSERT INTO opac_text VALUES('TEXT_MEMBERS_HOME', 'en', 'Members home');
INSERT INTO opac_text VALUES('TEXT_MEMBERS_HOME', 'fr', 'Accueil');
INSERT INTO opac_text VALUES('TEXT_LOGOUT', 'en', 'Logout');
INSERT INTO opac_text VALUES('TEXT_LOGOUT', 'fr', 'Quitter');
INSERT INTO opac_text VALUES('TEXT_LOG_IN_TO_KOHA','en', 'Login to Koha');
INSERT INTO opac_text VALUES('TEXT_LOG_IN_TO_KOHA','fr', 'S\'identifier dans Koha');
INSERT INTO opac_text VALUES('TEXT_REQUEST', 'en', 'Request');
INSERT INTO opac_text VALUES('TEXT_REQUEST', 'fr', 'Requête');
INSERT INTO opac_text VALUES('TEXT_BIBLIO_RECORD', 'en', 'BIBLIO RECORD');
INSERT INTO opac_text VALUES('TEXT_BIBLIO_RECORD', 'fr', 'NOTICE BIBLIOGRAPHIQUE');
INSERT INTO opac_text VALUES('TEXT_SUBTITLE', 'en', 'Subtitle');
INSERT INTO opac_text VALUES('TEXT_SUBTITLE', 'fr', 'Titre annexe');
INSERT INTO opac_text VALUES('TEXT_AUTHOR', 'en', 'Author');
INSERT INTO opac_text VALUES('TEXT_AUTHOR', 'fr', 'Auteur');
INSERT INTO opac_text VALUES('TEXT_SUBJECT', 'en', 'Subject');
INSERT INTO opac_text VALUES('TEXT_SUBJECT', 'fr', 'Sujet');
INSERT INTO opac_text VALUES('TEXT_COPYRIGHT', 'en', 'Copyright');
INSERT INTO opac_text VALUES('TEXT_COPYRIGHT', 'fr', 'Copyright');
INSERT INTO opac_text VALUES('TEXT_NBITEMS', 'en', 'Total number of items');
INSERT INTO opac_text VALUES('TEXT_NBITEMS', 'fr', 'Nombre total d\'exemplaires');
INSERT INTO opac_text VALUES('TEXT_ITEMTYPE', 'en', 'Item type');
INSERT INTO opac_text VALUES('TEXT_ITEMTYPE', 'fr', 'Type d\'exemplaire');
INSERT INTO opac_text VALUES('TEXT_CLASS', 'en', 'Class');
INSERT INTO opac_text VALUES('TEXT_CLASS', 'fr', 'Classe');
INSERT INTO opac_text VALUES('TEXT_LOCATION', 'en', 'Location');
INSERT INTO opac_text VALUES('TEXT_LOCATION', 'fr', 'Localisation');
INSERT INTO opac_text VALUES('TEXT_DATE_DUE', 'en', 'Date due');
INSERT INTO opac_text VALUES('TEXT_DATE_DUE', 'fr', 'Date de retour prévue');
INSERT INTO opac_text VALUES('TEXT_LAST_SEEN', 'en', 'Last seen');
INSERT INTO opac_text VALUES('TEXT_LAST_SEEN', 'fr', 'Date de retour effectif');
INSERT INTO opac_text VALUES('TEXT_BARCODE','en','Barcode');
INSERT INTO opac_text VALUES('TEXT_BARCODE','fr','Code barre');
INSERT INTO opac_text VALUES('TEXT_WEBSITE','en', 'Website');
INSERT INTO opac_text VALUES('TEXT_WEBSITE','fr', 'Site web');
INSERT INTO opac_text VALUES('TEXT_ONLINE','en', 'Online');
INSERT INTO opac_text VALUES('TEXT_ONLINE','fr', 'En ligne');
INSERT INTO opac_text VALUES('TEXT_AVAILABLE','en', 'Available');	
INSERT INTO opac_text VALUES('TEXT_AVAILABLE','fr', 'Disponible');