Created
March 23, 2009 11:26
-
-
Save beppu/83519 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 090204 0:32:51 13 Connect kohaadmin@localhost on koha | |
| 13 Query set autocommit=1 | |
| 13 Query set NAMES 'utf8' | |
| 13 Query select * from auth_types order by authtypetext | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='script' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='region' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag=NULL AND lang='en' AND type='variant' | |
| 13 Query SELECT description FROM language_descriptions WHERE subtag='en' AND lang='en' AND type='language' | |
| 13 Query SELECT a_session FROM sessions WHERE id='70464cf11d5d316532ee85f10577216a' | |
| 13 Query SELECT flags FROM borrowers WHERE userid='kohaadmin' | |
| 13 Query SELECT bit, flag, defaulton FROM userflags | |
| 13 Query SELECT flag, code | |
| FROM user_permissions | |
| JOIN permissions USING (module_bit, code) | |
| JOIN userflags ON (module_bit = bit) | |
| JOIN borrowers USING (borrowernumber) | |
| WHERE userid = 'kohaadmin' | |
| 13 Query REPLACE INTO sessions (id, a_session) VALUES('70464cf11d5d316532ee85f10577216a', '--- \n_SESSION_ATIME: 1233736371\n_SESSION_CTIME: 1233733184\n_SESSION_EXPIRE_LIST: {}\n\n_SESSION_ID: 70464cf11d5d316532ee85f10577216a\n_SESSION_REMOTE_ADDR: 127.0.0.1\nbarshelves: []\n\nbranch: NO_LIBRARY_SET\nbranchname: NO_LIBRARY_SET\ncardnumber: kohaadmin\nemailaddress: root@localhost\nfirstname: kohaadmin\nflags: 1\nid: kohaadmin\nip: 127.0.0.1\nlasttime: 1233736371\nnumber: 0\npubshelves: []\n\nsurname: kohaadmin\ntotshelves: \n bartotal: 0\n pubtotal: 0\n') | |
| 13 Query select borrowernumber from borrowers where userid='kohaadmin' | |
| 13 Query select borrowernumber from borrowers where cardnumber='kohaadmin' | |
| 13 Query SELECT flag, code, description | |
| FROM permissions | |
| JOIN userflags ON (module_bit = bit) | |
| 13 Query SELECT *,timestamp AS newdate | |
| FROM opac_news | |
| WHERE ( | |
| expirationdate > CURRENT_DATE() | |
| OR expirationdate IS NULL | |
| OR expirationdate = '00-00-0000' | |
| ) | |
| AND lang = 'koha' | |
| ORDER BY number | |
| 13 Quit |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment