-- DanGrimm - 25 Jun 2008
To add staff to job req system need to add them to staff staff_info database table

And then rely on nightly cron job to add them via this script!!!!!!!!! /home/mysql/scripts/staff/update_name_list.sh
Don't forget that you have to add their crux authcate name!!!!!!!!!! - it's way off to the right somewhere when editing.
Thesis project database

Date: Mon, 29 Oct 2007 10:44:34 +1100
From: Daniel Grimm <Daniel.Grimm@eng.monash.edu.au>
Subject: ecsedb ecsesql semester maintenance for project database
To: Dan Grimm <dan.grimm@eng.monash.edu.au>
Cc: Phieu Huynh <phil.huynh@eng.monash.edu.au>
Message-id: <47251EE2.60906@eng.monash.edu.au>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7bit
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)

Dan, (Phil, copy for your info)

Some notes by dan based on quick word with paul this morning.

Paul still working on some scripts to automate some of this, and other 
things like changing status between "allocating, updating, allocated" 
and php display.


SQLyog    - tool for maintaining sql databases
ecse-cluster/install/secure/sqlyog
Has registration string in text file there.

Student Thesis Project  Database:
End of semester  routine:   ----------------------done this morning by 
dan with paul's help.

This is missing little details like you can't just rename a database!!
You seem to have to create a new empty database and then copy to it, with data & structure.


1. 1.a create student_proj_year_sems.
    1.b copy  student_proj_old database to student_proj_YEAR_Sems.
2. copy student_proj to student_proj_old        
3. copy enrollments from STUDENT database to student_proj_new
4. copy student_proj_new to student_proj
5. In student_proj_new
      - either delete enrollment table or empty it.
      - change unit_info to current year/sem    update `unit_info` set 
`rec`='1',`year_unit_ran`='2008',`semister`='1'
      - empty all the tables in this new student_proj_new - start each semester with no projects or allocations or selections.
      Don't need to do this as all tables are empty- reset allocation status to not allocated = 2    update info set 
status_num=0


6. Did I mention that you have to copy to enrollments_sem_year and empty enrollments in "student" database?
7. Did I mention that you have to fiddle the menu scheduler as well in dbase_info database?
What have I forgotten?



Full history of sql commands recorded by sqlyog - gui interface hides a 
lot of it, but the change of fields was either directly typed or as sql 
command - lead to "update" sql queries - and need to remember to "save 
to disk"

/*[9:32:57 AM][  15 ms]*/ show databases
/*[9:39:36 AM][   0 ms]*/ show table status from `student_proj_old`
/*[9:39:36 AM][   0 ms]*/ show table status from `student_proj_old`
/*[9:39:36 AM][  15 ms]*/ use `student_proj_old`
/*[9:40:01 AM][   0 ms]*/ show tables from `student_proj_old`
/*[9:40:52 AM][   0 ms]*/ create database `student_proj_2006_sem2`
/*[9:40:53 AM][   0 ms]*/ use `student_proj_2006_sem2`
/*[9:40:53 AM][   0 ms]*/ show databases
/*[9:40:53 AM][   0 ms]*/ show table status from `student_proj_old`
/*[9:40:53 AM][   0 ms]*/ show table status from `student_proj_old`
/*[9:40:53 AM][   0 ms]*/ show tables from `student_proj_old`
/*[9:40:53 AM][   0 ms]*/ show tables from `student_proj_2006_sem2`
/*[9:40:59 AM][   0 ms]*/ show table status from `student_proj_old`
/*[9:40:59 AM][  16 ms]*/ show table status from `student_proj_old`
/*[9:41:07 AM][   0 ms]*/ show tables from `student_proj_old`
/*[9:41:48 AM][  15 ms]*/ show table status from `student_proj`
/*[9:41:48 AM][   0 ms]*/ show table status from `student_proj`
/*[9:41:48 AM][   0 ms]*/ use `student_proj`
/*[9:41:50 AM][  15 ms]*/ show tables from `student_proj`
/*[9:42:17 AM][   0 ms]*/ show table status from `student_proj_old`
/*[9:42:17 AM][   0 ms]*/ show table status from `student_proj_old`
/*[9:42:17 AM][   0 ms]*/ use `student_proj_old`
/*[9:42:18 AM][   0 ms]*/ show table status from `student_proj_new`
/*[9:42:18 AM][   0 ms]*/ show table status from `student_proj_new`
/*[9:42:18 AM][   0 ms]*/ use `student_proj_new`
/*[9:42:18 AM][   0 ms]*/ show tables from `student_proj_new`
/*[9:42:25 AM][   0 ms]*/ show table status from `student`
/*[9:42:25 AM][   0 ms]*/ show table status from `student`
/*[9:42:25 AM][   0 ms]*/ use `student`
/*[9:42:25 AM][   0 ms]*/ show tables from `student`
/*[9:42:37 AM][   0 ms]*/ show full fields from `student`.`enrolment`
/*[9:42:37 AM][   0 ms]*/ show keys from `student`.`enrolment`
/*[9:42:37 AM][  15 ms]*/ show create table `student`.`enrolment`
/*[9:42:41 AM][   0 ms]*/ show tables from `student`
/*[9:43:12 AM][   0 ms]*/ show table status from `student_proj_new`
/*[9:43:12 AM][   0 ms]*/ show table status from `student_proj_new`
/*[9:43:12 AM][   0 ms]*/ use `student_proj_new`
/*[9:43:20 AM][   0 ms]*/ show tables from `student_proj_new`
/*[9:43:34 AM][   0 ms]*/ show tables from `student_proj_new`
/*[9:43:53 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`allocations`
/*[9:43:53 AM][   0 ms]*/ show keys from `student_proj_new`.`allocations`
/*[9:43:53 AM][   0 ms]*/ show create table `student_proj_new`.`allocations`
/*[9:44:01 AM][  47 ms]*/ truncate table `student_proj_new`.`allocations`
/*[9:44:05 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`enrolment`
/*[9:44:05 AM][   0 ms]*/ show keys from `student_proj_new`.`enrolment`
/*[9:44:05 AM][   0 ms]*/ show create table `student_proj_new`.`enrolment`
/*[9:44:22 AM][   0 ms]*/ truncate table `student_proj_new`.`enrolment`
/*[9:44:29 AM][   0 ms]*/ show full fields from `student_proj_new`.`info`
/*[9:44:29 AM][   0 ms]*/ show keys from `student_proj_new`.`info`
/*[9:44:29 AM][   0 ms]*/ show create table `student_proj_new`.`info`
/*[9:44:37 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`selection`
/*[9:44:37 AM][   0 ms]*/ show keys from `student_proj_new`.`selection`
/*[9:44:37 AM][   0 ms]*/ show create table `student_proj_new`.`selection`
/*[9:44:42 AM][  16 ms]*/ truncate table `student_proj_new`.`selection`
/*[9:44:45 AM][   0 ms]*/ show full fields from `student_proj_new`.`status`
/*[9:44:45 AM][   0 ms]*/ show keys from `student_proj_new`.`status`
/*[9:44:45 AM][   0 ms]*/ show create table `student_proj_new`.`status`
/*[9:44:48 AM][   0 ms]*/ show full fields from `student_proj_new`.`status`
/*[9:44:48 AM][   0 ms]*/ show keys from `student_proj_new`.`status`
/*[9:44:48 AM][   0 ms]*/ select * from `student_proj_new`.`status`  
limit 0, 50
/*[9:44:54 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`unit_info`
/*[9:44:54 AM][   0 ms]*/ show keys from `student_proj_new`.`unit_info`
/*[9:44:54 AM][   0 ms]*/ select * from `student_proj_new`.`unit_info`  
limit 0, 50
/*[9:45:22 AM][  31 ms]*/ update `unit_info` set 
`rec`='1',`year_unit_ran`='2008',`semister`='1' where `rec`='1'
/*[9:45:23 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`unit_info`
/*[9:45:23 AM][   0 ms]*/ show keys from `student_proj_new`.`unit_info`
/*[9:45:23 AM][   0 ms]*/ select * from `student_proj_new`.`unit_info`  
limit 0, 50
/*[9:45:29 AM][   0 ms]*/ show full fields from `student_proj_new`.`types`
/*[9:45:29 AM][   0 ms]*/ show keys from `student_proj_new`.`types`
/*[9:45:29 AM][   0 ms]*/ select * from `student_proj_new`.`types`  
limit 0, 50
/*[9:45:35 AM][   0 ms]*/ show full fields from `student_proj_new`.`info`
/*[9:45:35 AM][  16 ms]*/ show keys from `student_proj_new`.`info`
/*[9:45:35 AM][  16 ms]*/ select * from `student_proj_new`.`info`  limit 
0, 50
/*[9:45:49 AM][   0 ms]*/ show full fields from `student_proj_new`.`status`
/*[9:45:49 AM][   0 ms]*/ show keys from `student_proj_new`.`status`
/*[9:45:49 AM][   0 ms]*/ select * from `student_proj_new`.`status`  
limit 0, 50
/*[9:46:17 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`unit_info`
/*[9:46:17 AM][   0 ms]*/ show keys from `student_proj_new`.`unit_info`
/*[9:46:17 AM][   0 ms]*/ select * from `student_proj_new`.`unit_info`  
limit 0, 50
/*[9:46:19 AM][   0 ms]*/ show full fields from `student_proj_new`.`types`
/*[9:46:19 AM][   0 ms]*/ show keys from `student_proj_new`.`types`
/*[9:46:19 AM][   0 ms]*/ select * from `student_proj_new`.`types`  
limit 0, 50
/*[9:46:38 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`allocations`
/*[9:46:38 AM][   0 ms]*/ show keys from `student_proj_new`.`allocations`
/*[9:46:38 AM][   0 ms]*/ select * from 
`student_proj_new`.`allocations`  limit 0, 50
/*[9:46:40 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`enrolment`
/*[9:46:40 AM][   0 ms]*/ show keys from `student_proj_new`.`enrolment`
/*[9:46:40 AM][   0 ms]*/ select * from `student_proj_new`.`enrolment`  
limit 0, 50
/*[9:46:48 AM][   0 ms]*/ show full fields from `student_proj_new`.`info`
/*[9:46:48 AM][   0 ms]*/ show keys from `student_proj_new`.`info`
/*[9:46:48 AM][   0 ms]*/ select * from `student_proj_new`.`info`  limit 
0, 50
/*[9:47:52 AM][  47 ms]*/ update info set status_num=0
/*[9:47:57 AM][   0 ms]*/ show full fields from `student_proj_new`.`info`
/*[9:47:57 AM][   0 ms]*/ show keys from `student_proj_new`.`info`
/*[9:47:57 AM][  15 ms]*/ select * from `student_proj_new`.`info`  limit 
0, 50
/*[9:50:51 AM][   0 ms]*/ use `student_proj_old`
/*[9:50:54 AM][   0 ms]*/ show tables from `student_proj_old`
/*[9:51:35 AM][   0 ms]*/ show tables from `student_proj_old`
/*[9:53:42 AM][   0 ms]*/ use `student_proj`
/*[9:53:43 AM][   0 ms]*/ show tables from `student_proj`
/*[9:54:12 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`enrolment`
/*[9:54:12 AM][   0 ms]*/ show keys from `student_proj_new`.`enrolment`
/*[9:54:12 AM][   0 ms]*/ select * from `student_proj_new`.`enrolment`  
limit 0, 50
/*[9:54:12 AM][   0 ms]*/ use `student_proj_new`
/*[9:56:24 AM][   0 ms]*/ use `student_proj_old`
/*[9:56:26 AM][   0 ms]*/ show full fields from 
`student_proj_old`.`enrolment`
/*[9:56:26 AM][   0 ms]*/ show keys from `student_proj_old`.`enrolment`
/*[9:56:26 AM][  16 ms]*/ select * from `student_proj_old`.`enrolment`  
limit 0, 50
/*[9:56:29 AM][   0 ms]*/ show full fields from `student_proj_old`.`status`
/*[9:56:29 AM][  16 ms]*/ show keys from `student_proj_old`.`status`
/*[9:56:29 AM][   0 ms]*/ select * from `student_proj_old`.`status`  
limit 0, 50
/*[9:56:31 AM][   0 ms]*/ show full fields from 
`student_proj_old`.`unit_info`
/*[9:56:31 AM][   0 ms]*/ show keys from `student_proj_old`.`unit_info`
/*[9:56:31 AM][   0 ms]*/ select * from `student_proj_old`.`unit_info`  
limit 0, 50
/*[9:56:41 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`unit_info`
/*[9:56:41 AM][   0 ms]*/ show keys from `student_proj_new`.`unit_info`
/*[9:56:41 AM][   0 ms]*/ select * from `student_proj_new`.`unit_info`  
limit 0, 50
/*[9:56:41 AM][   0 ms]*/ use `student_proj_new`
/*[9:56:51 AM][   0 ms]*/ show full fields from 
`student_proj_new`.`enrolment`
/*[9:56:51 AM][  16 ms]*/ show keys from `student_proj_new`.`enrolment`
/*[9:56:51 AM][   0 ms]*/ select * from `student_proj_new`.`enrolment`  
limit 0, 50
/*[9:57:00 AM][   0 ms]*/ show full fields from `student_proj_new`.`info`
/*[9:57:00 AM][   0 ms]*/ show keys from `student_proj_new`.`info`
/*[9:57:00 AM][  16 ms]*/ select * from `student_proj_new`.`info`  limit 
0, 50
/*[9:57:04 AM][   0 ms]*/ show full fields from 
`student_proj_old`.`unit_info`
/*[9:57:04 AM][   0 ms]*/ show keys from `student_proj_old`.`unit_info`
/*[9:57:04 AM][   0 ms]*/ select * from `student_proj_old`.`unit_info`  
limit 0, 50
/*[9:57:04 AM][   0 ms]*/ use `student_proj_old`
/*[9:57:05 AM][   0 ms]*/ use `student_proj`
/*[9:57:09 AM][   0 ms]*/ show full fields from `student_proj`.`enrolment`
/*[9:57:09 AM][   0 ms]*/ show keys from `student_proj`.`enrolment`
/*[9:57:09 AM][   0 ms]*/ select * from `student_proj`.`enrolment`  
limit 0, 50
/*[9:57:11 AM][   0 ms]*/ show full fields from `student_proj`.`unit_info`
/*[9:57:11 AM][   0 ms]*/ show keys from `student_proj`.`unit_info`
/*[9:57:11 AM][   0 ms]*/ select * from `student_proj`.`unit_info`  
limit 0, 50
/*[9:59:58 AM][   0 ms]*/ show full fields from 
`student_proj_old`.`unit_info`
/*[9:59:58 AM][   0 ms]*/ show keys from `student_proj_old`.`unit_info`
/*[9:59:58 AM][   0 ms]*/ select * from `student_proj_old`.`unit_info`  
limit 0, 50
/*[9:59:58 AM][   0 ms]*/ use `student_proj_old`
/*[10:07:39 AM][   0 ms]*/ use `student`
/*[10:07:41 AM][   0 ms]*/ use `student_proj`
/*[10:07:42 AM][  16 ms]*/ use `student_proj_new`
/*[10:07:45 AM][   0 ms]*/ use `student_proj_old`
/*[10:07:54 AM][   0 ms]*/ use `loans`
/*[10:07:54 AM][   0 ms]*/ show tables from `loans`
/*[10:07:57 AM][   0 ms]*/ show full fields from 
`loans`.`handbook_allocations`
/*[10:07:57 AM][   0 ms]*/ show keys from `loans`.`handbook_allocations`
/*[10:07:57 AM][  31 ms]*/ select * from `loans`.`handbook_allocations`  
limit 0, 50
/*[10:07:57 AM][   0 ms]*/ describe `loans`.`handbook_allocations`
/*[10:07:57 AM][   0 ms]*/ show index from `loans`.`handbook_allocations`
/*[10:08:21 AM][   0 ms]*/ show full fields from 
`loans`.`handbook_allocations`
/*[10:08:21 AM][   0 ms]*/ show keys from `loans`.`handbook_allocations`
/*[10:08:21 AM][   0 ms]*/ select * from `loans`.`handbook_allocations`  
limit 0, 50
/*[10:08:26 AM][   0 ms]*/ show full fields from `loans`.`item_status`
/*[10:08:26 AM][   0 ms]*/ show keys from `loans`.`item_status`
/*[10:08:26 AM][   0 ms]*/ select * from `loans`.`item_status`  limit 0, 50
/*[10:08:30 AM][   0 ms]*/ show full fields from `loans`.`item_types`
/*[10:08:30 AM][   0 ms]*/ show keys from `loans`.`item_types`
/*[10:08:30 AM][   0 ms]*/ select * from `loans`.`item_types`  limit 0, 50
/*[10:08:33 AM][   0 ms]*/ show full fields from `loans`.`loan_items`
/*[10:08:33 AM][   0 ms]*/ show keys from `loans`.`loan_items`
/*[10:08:33 AM][   0 ms]*/ select * from `loans`.`loan_items`  limit 0, 50
/*[10:08:36 AM][   0 ms]*/ show full fields from `loans`.`item_status`
/*[10:08:36 AM][   0 ms]*/ show keys from `loans`.`item_status`
/*[10:08:36 AM][   0 ms]*/ select * from `loans`.`item_status`  limit 0, 50
/*[10:08:37 AM][  16 ms]*/ show full fields from `loans`.`item_types`
/*[10:08:37 AM][   0 ms]*/ show keys from `loans`.`item_types`
/*[10:08:37 AM][   0 ms]*/ select * from `loans`.`item_types`  limit 0, 50
/*[10:08:38 AM][   0 ms]*/ show full fields from `loans`.`loan_items_copy`
/*[10:08:38 AM][   0 ms]*/ show keys from `loans`.`loan_items_copy`
/*[10:08:38 AM][  31 ms]*/ select * from `loans`.`loan_items_copy`  
limit 0, 50
/*[10:08:51 AM][   0 ms]*/ show full fields from `loans`.`loan_items_copy`
/*[10:08:51 AM][   0 ms]*/ show keys from `loans`.`loan_items_copy`
/*[10:08:51 AM][   0 ms]*/ show create table `loans`.`loan_items_copy`
/*[10:08:59 AM][   0 ms]*/ show full fields from `loans`.`loan_items_copy`
/*[10:08:59 AM][  15 ms]*/ show keys from `loans`.`loan_items_copy`
/*[10:08:59 AM][   0 ms]*/ select * from `loans`.`loan_items_copy`  
limit 0, 50
/*[10:09:17 AM][   0 ms]*/ show full fields from `loans`.`loan_items`
/*[10:09:17 AM][   0 ms]*/ show keys from `loans`.`loan_items`
/*[10:09:17 AM][   0 ms]*/ select * from `loans`.`loan_items`  limit 0, 50
/*[10:09:24 AM][   0 ms]*/ show full fields from `loans`.`resource`
/*[10:09:24 AM][   0 ms]*/ show keys from `loans`.`resource`
/*[10:09:24 AM][  31 ms]*/ select * from `loans`.`resource`  limit 0, 50
/*[10:09:32 AM][   0 ms]*/ show full fields from `loans`.`one_off_items`
/*[10:09:32 AM][   0 ms]*/ show keys from `loans`.`one_off_items`
/*[10:09:32 AM][   0 ms]*/ select * from `loans`.`one_off_items`  limit 
0, 50
/*[10:09:44 AM][   0 ms]*/ show full fields from `loans`.`on_loan`
/*[10:09:44 AM][   0 ms]*/ show keys from `loans`.`on_loan`
/*[10:09:44 AM][   0 ms]*/ select * from `loans`.`on_loan`  limit 0, 50
/*[10:09:57 AM][   0 ms]*/ show full fields from `loans`.`loan_items_temp`
/*[10:09:57 AM][   0 ms]*/ show keys from `loans`.`loan_items_temp`
/*[10:09:57 AM][   0 ms]*/ select * from `loans`.`loan_items_temp`  
limit 0, 50
/*[10:09:59 AM][  15 ms]*/ show full fields from `loans`.`loan_items_copy1`
/*[10:09:59 AM][   0 ms]*/ show keys from `loans`.`loan_items_copy1`
/*[10:09:59 AM][  16 ms]*/ select * from `loans`.`loan_items_copy1`  
limit 0, 50
/*[10:10:03 AM][   0 ms]*/ show full fields from `loans`.`loan_items_copy`
/*[10:10:03 AM][   0 ms]*/ show keys from `loans`.`loan_items_copy`
/*[10:10:03 AM][   0 ms]*/ select * from `loans`.`loan_items_copy`  
limit 0, 50
/*[10:10:07 AM][   0 ms]*/ show full fields from `loans`.`loan_items`
/*[10:10:07 AM][   0 ms]*/ show keys from `loans`.`loan_items`
/*[10:10:07 AM][   0 ms]*/ select * from `loans`.`loan_items`  limit 0, 50
/*[10:10:10 AM][   0 ms]*/ show full fields from `loans`.`item_types`
/*[10:10:10 AM][  15 ms]*/ show keys from `loans`.`item_types`
/*[10:10:10 AM][   0 ms]*/ select * from `loans`.`item_types`  limit 0, 50
/*[10:10:12 AM][   0 ms]*/ show full fields from `loans`.`item_status`
/*[10:10:12 AM][   0 ms]*/ show keys from `loans`.`item_status`
/*[10:10:12 AM][   0 ms]*/ select * from `loans`.`item_status`  limit 0, 50
/*[10:10:14 AM][   0 ms]*/ describe `loans`.`item_status`
/*[10:10:14 AM][   0 ms]*/ show index from `loans`.`item_status`
/*[10:10:18 AM][   0 ms]*/ show full fields from `loans`.`item_status`
/*[10:10:18 AM][   0 ms]*/ show keys from `loans`.`item_status`
/*[10:10:18 AM][   0 ms]*/ select * from `loans`.`item_status`  limit 0, 50
/*[10:10:19 AM][   0 ms]*/ show full fields from `loans`.`item_types`
/*[10:10:19 AM][   0 ms]*/ show keys from `loans`.`item_types`
/*[10:10:19 AM][   0 ms]*/ select * from `loans`.`item_types`  limit 0, 50
/*[10:10:21 AM][   0 ms]*/ show full fields from `loans`.`loan_items`
/*[10:10:21 AM][   0 ms]*/ show keys from `loans`.`loan_items`
/*[10:10:21 AM][   0 ms]*/ select * from `loans`.`loan_items`  limit 0, 50
/*[10:10:30 AM][   0 ms]*/ show full fields from `loans`.`item_status`
/*[10:10:30 AM][   0 ms]*/ show keys from `loans`.`item_status`
/*[10:10:30 AM][   0 ms]*/ select * from `loans`.`item_status`  limit 0, 50
/*[10:10:36 AM][   0 ms]*/ show full fields from `loans`.`loan_items`
/*[10:10:36 AM][   0 ms]*/ show keys from `loans`.`loan_items`
/*[10:10:36 AM][   0 ms]*/ select * from `loans`.`loan_items`  limit 0, 50
/*[10:10:49 AM][   0 ms]*/ show full fields from `loans`.`on_loan`
/*[10:10:49 AM][   0 ms]*/ show keys from `loans`.`on_loan`
/*[10:10:49 AM][   0 ms]*/ select * from `loans`.`on_loan`  limit 0, 50
/*[10:11:07 AM][   0 ms]*/ show full fields from `loans`.`item_status`
/*[10:11:07 AM][   0 ms]*/ show keys from `loans`.`item_status`
/*[10:11:07 AM][   0 ms]*/ select * from `loans`.`item_status`  limit 0, 50
/*[10:11:16 AM][   0 ms]*/ show full fields from `loans`.`loan_items`
/*[10:11:16 AM][   0 ms]*/ show keys from `loans`.`loan_items`
/*[10:11:16 AM][   0 ms]*/ select * from `loans`.`loan_items`  limit 0, 50
/*[10:11:49 AM][   0 ms]*/ show full fields from `loans`.`item_types`
/*[10:11:49 AM][   0 ms]*/ show keys from `loans`.`item_types`
/*[10:11:49 AM][   0 ms]*/ select * from `loans`.`item_types`  limit 0, 50
/*[10:11:58 AM][   0 ms]*/ show full fields from `loans`.`resource`
/*[10:11:58 AM][   0 ms]*/ show keys from `loans`.`resource`
/*[10:11:58 AM][   0 ms]*/ select * from `loans`.`resource`  limit 0, 50
/*[10:12:02 AM][   0 ms]*/ show full fields from 
`loans`.`handbook_allocations`
/*[10:12:02 AM][   0 ms]*/ show keys from `loans`.`handbook_allocations`
/*[10:12:02 AM][   0 ms]*/ select * from `loans`.`handbook_allocations`  
limit 0, 50
/*[10:12:18 AM][   0 ms]*/ show full fields from 
`loans`.`handbook_allocations`
/*[10:12:18 AM][   0 ms]*/ show keys from `loans`.`handbook_allocations`
/*[10:12:18 AM][   0 ms]*/ select * from `loans`.`handbook_allocations`  
limit 0, 50
/*[10:12:24 AM][   0 ms]*/ show full fields from `loans`.`item_status`
/*[10:12:24 AM][   0 ms]*/ show keys from `loans`.`item_status`
/*[10:12:24 AM][   0 ms]*/ select * from `loans`.`item_status`  limit 0, 50
/*[10:12:31 AM][   0 ms]*/ show full fields from 
`loans`.`handbook_allocations`
/*[10:12:31 AM][   0 ms]*/ show keys from `loans`.`handbook_allocations`
/*[10:12:31 AM][   0 ms]*/ select * from `loans`.`handbook_allocations`  
limit 0, 50
/*[10:12:34 AM][   0 ms]*/ show full fields from `loans`.`item_status`
/*[10:12:34 AM][   0 ms]*/ show keys from `loans`.`item_status`
/*[10:12:34 AM][   0 ms]*/ select * from `loans`.`item_status`  limit 0, 50
/*[10:13:31 AM][   0 ms]*/ use `proxy`
/*[10:13:33 AM][   0 ms]*/ show tables from `proxy`
/*[10:13:34 AM][   0 ms]*/ show full fields from `proxy`.`ip_usage`
/*[10:13:34 AM][   0 ms]*/ show keys from `proxy`.`ip_usage`
/*[10:13:34 AM][  31 ms]*/ select * from `proxy`.`ip_usage`  limit 0, 50
/*[10:13:49 AM][  16 ms]*/ show full fields from `proxy`.`lab_logs`
/*[10:13:49 AM][   0 ms]*/ show keys from `proxy`.`lab_logs`
/*[10:13:49 AM][  94 ms]*/ select * from `proxy`.`lab_logs`  limit 0, 50
/*[10:13:56 AM][   0 ms]*/ show full fields from `proxy`.`proxylogs`
/*[10:13:56 AM][   0 ms]*/ show keys from `proxy`.`proxylogs`
/*[10:13:56 AM][ 110 ms]*/ select * from `proxy`.`proxylogs`  limit 0, 50
/*[10:14:03 AM][   0 ms]*/ show full fields from `proxy`.`proxylogs_report`
/*[10:14:03 AM][   0 ms]*/ show keys from `proxy`.`proxylogs_report`
/*[10:14:03 AM][ 203 ms]*/ select * from `proxy`.`proxylogs_report`  
limit 0, 50
/*[10:14:13 AM][   0 ms]*/ show full fields from `proxy`.`monthly_usage`
/*[10:14:13 AM][   0 ms]*/ show keys from `proxy`.`monthly_usage`
/*[10:14:13 AM][   0 ms]*/ select * from `proxy`.`monthly_usage`  limit 
0, 50
/*[10:14:20 AM][   0 ms]*/ show full fields from `proxy`.`monthly_usage`
/*[10:14:20 AM][   0 ms]*/ show keys from `proxy`.`monthly_usage`
/*[10:14:20 AM][   0 ms]*/ select * from `proxy`.`monthly_usage`  limit 
0, 50
/*[10:14:21 AM][   0 ms]*/ show full fields from `proxy`.`monthly_usage`
/*[10:14:21 AM][   0 ms]*/ show keys from `proxy`.`monthly_usage`
/*[10:14:21 AM][   0 ms]*/ show create table `proxy`.`monthly_usage`
/*[10:16:01 AM][   0 ms]*/ use `dbase_info`
/*[10:16:01 AM][   0 ms]*/ show tables from `dbase_info`
Topic MySql . { Edit | Attach | Ref-By | Printable | Diffs | r1.2 | > | r1.1 | More }
Revision r1.2 - 27 Jun 2008 - 05:40 GMT - DanGrimm Parents: WebHome	Copyright © 1999-2003 by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Ideas, requests, problems regarding TWiki? Send feedback.
	TWiki > ECSEIT > MySql	TWiki webs: Main \| TWiki \| Know \| Sandbox
	ECSEIT . { Changes \| Index \| Search \| Go }