Skip to content

Instantly share code, notes, and snippets.

@beppu
Created March 23, 2009 11:26
Show Gist options
  • Select an option

  • Save beppu/83519 to your computer and use it in GitHub Desktop.

Select an option

Save beppu/83519 to your computer and use it in GitHub Desktop.
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