#!/usr/bin/perl # # Installer for the LUMP system. # # Author: J.P.Knight@lboro.ac.uk # use strict; use POSIX; use constant STAGE_CPAN_DIR => 1; use constant STAGE_CPAN_INSTALL => 2; use constant STAGE_ASK_DB_DETAILS => 3; use constant STAGE_DB_DETAILS => 4; use constant STAGE_DB_CHECK => 5; use constant STAGE_DB_CREATE => 6; use constant STAGE_DB_SCHEMA => 7; use constant STAGE_DB_POPULATE => 8; use constant STAGE_LC_DB_DETAILS => 9; use constant STAGE_LC_DB_CHECK => 10; use constant STAGE_LC_DB_CREATE => 11; use constant STAGE_LC_DB_SCHEMA => 12; use constant STAGE_ASK_CODE_DETAILS => 13; use constant STAGE_CHECK_MODULES => 14; use constant STAGE_CODE_INSTALL => 15; my @lump_required_modules = ( 'Algorithm::Diff', 'Archive::Any', 'Authen::Krb5', 'Authen::SASL', 'BibTeX::Parser', 'CGI::Cookie', 'DBD::mysql', 'DBI', 'DBIx::RetryOverDisconnects', 'Data::Dumper', 'Date::Calc', 'Date::Simple', 'Digest::SHA', 'Encode', 'Fcntl', 'File::Basename', 'Getopt::Long', 'HTTP::Async', 'HTTP::Request', 'HTTP::Request::Common', 'IO::File', 'IP::Anonymous', 'LWP', 'LWP::Simple ()', 'LWP::UserAgent', 'MD5', 'Net::LDAP', 'NetAddr::IP', 'POSIX', 'Perl::Tidy', 'Tie::Persistent', 'Time::HiRes', 'URI::Escape', 'WebService::ISBNDB::API::Books', 'XML::LibXML', 'XML::Mini::Document', 'XML::Simple', 'ZOOM', ); my @clump_required_modules = ( 'Data::Dumper', 'HTTP::Cookies', 'HTTP::Request::Common', 'JSON', 'LWP', 'LWP::UserAgent', 'LWP::UserAgent', 'MARC::Record', 'XML::Simple', 'ZOOM', ); my @required_modules; my $loan_cache_schema = [ "CREATE TABLE `ISBN2item` ( `id` int(11) NOT NULL auto_increment, `itemId` int(11) default NULL, `isbn` varchar(255) default NULL, PRIMARY KEY (`id`), KEY `isbnIdx` (`isbn`), KEY `itemIdx` (`itemId`) ) ENGINE=MyISAM AUTO_INCREMENT=411547 DEFAULT CHARSET=latin1; ", "CREATE TABLE `items` ( `id` int(11) NOT NULL auto_increment, `lcn` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=377889 DEFAULT CHARSET=latin1; ", "CREATE TABLE `loans` ( `id` int(11) NOT NULL auto_increment, `itemId` int(11) default NULL, `issued` datetime default NULL, `returned` datetime default NULL, `itemType` varchar(255) default NULL, `department` varchar(255) default NULL, PRIMARY KEY (`id`), KEY `itemIdx2` (`itemId`), KEY `issuedIdx` (`issued`), KEY `returnedIdx` (`returned`) ) ENGINE=MyISAM AUTO_INCREMENT=562288 DEFAULT CHARSET=latin1; " ]; my $schema = [ "create table structural_unit ( id int not null primary key auto_increment, structural_unit_type_id int not null, deleted enum('N','Y') default 'N', state enum('draft','published','suppressed') default 'draft', created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table structural_unit_link ( id int not null primary key auto_increment, parent_su_id int not null, child_su_id int not null, rank int, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table structural_unit_type ( id int not null primary key auto_increment, name varchar(255), created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table structural_unit_type_link ( id int not null primary key auto_increment, name varchar(255), parent_su_type_id int not null, child_su_type_id int not null, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table data_type_group ( id int not null primary key auto_increment, structural_unit_type_id int not null, title varchar(255), rank int not null, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table data_type ( id int not null primary key auto_increment, data_type_group_id int not null, rank int not null default 0, name varchar(255), repeatable enum('Y','N') not null default 'N', default_value text, size int, edit_representation enum('input text','textarea','checkbox','radio button', 'popup menu', 'scrolling list') not null default 'input text', validation_pattern text, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table controlled_vocabulary ( id int not null primary key auto_increment, data_type_id int not null, possible_value text, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table data_element ( id int not null primary key auto_increment, data_type_id int not null, structural_unit_id int not null, value text, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table editing_event ( id int not null primary key auto_increment, data_element_id int not null, user_id int not null, diff text, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table user ( id int not null primary key auto_increment, username varchar(255), fullname varchar(255), email varchar(255), created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table user_usergroup_link ( id int not null primary key auto_increment, user_id int not null, usergroup_id int not null, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table usergroup ( id int not null primary key auto_increment, group_name varchar(255), priority_id int not null, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table access_control_list ( id int not null primary key auto_increment, user_group_id int not null, structural_unit_id int, data_type_group_id int, view enum('Y','N') not null default 'N', edit enum('Y','N') not null default 'N', created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table acl_defaults ( id int not null primary key auto_increment, priority_id int not null, structural_unit_type_id int not null, data_type_group_id int, view enum('Y','N') not null default 'N', edit enum('Y','N') not null default 'N', created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table priority ( id int not null primary key auto_increment, value int not null, name varchar(255), created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table display_format ( id int not null primary key auto_increment, format_type_id int not null, structural_unit_type_id int, data_type_group_id int, template text, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table import_format ( id int not null primary key auto_increment, format_type_id int not null, structural_unit_type_id int, template text, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table format_type ( id int not null primary key auto_increment, name varchar(255), created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table translation ( id int not null primary key auto_increment, format_type_id int not null, pattern_match text, pattern_replacement text, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table user_item_rating ( id int not null primary key auto_increment, user_id int not null, structural_unit_id int not null, rating enum('Good','Bad'), created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table ip_address_range ( id int not null primary key auto_increment, name varchar(255), cidr varchar(50), default_view_exclude enum('Y','N') default 'N', created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); ", "create table view_log ( id int not null primary key auto_increment, src_ip varchar(50), client_name varchar(100), structural_unit_id int not null, structural_unit_type_id int not null, username varchar(50) not null, created_by varchar(20), created_time datetime, modified_by varchar(20), modified_time datetime ); " ]; my $indexes = [ "create index su_sutid_idx on structural_unit (structural_unit_type_id); ", "create index sul_parent_idx on structural_unit_link ( parent_su_id ); ", "create index sul_child_idx on structural_unit_link ( child_su_id ); ", "create index sutl_parent_idx on structural_unit_type_link (parent_su_type_id); ", "create index sutl_child_idx on structural_unit_type_link (child_su_type_id); ", "create index dtg_sut_idx on data_type_group (structural_unit_type_id); ", "create index dtg_title_idx on data_type_group (title); ", "create index dt_dtg_idx on data_type (data_type_group_id); ", "create index dt_name_idx on data_type (name); ", "create index cv_dt_idx on controlled_vocabulary (data_type_id); ", "create index de_dt_idx on data_element (data_type_id); ", "create index de_su_idx on data_element (structural_unit_id); ", "create index ee_de_idx on editing_event (data_element_id); ", "create index ee_user_idx on editing_event (user_id); ", "create index username_idx on user (username); ", "create index uugl_user_idx on user_usergroup_link ( user_id ); ", "create index uugl_group_idx on user_usergroup_link ( usergroup_id ); ", "create index ug_gname_idx on usergroup (group_name); ", "create index acl_ug_idx on access_control_list (user_group_id); ", "create index acl_su_idx on access_control_list (structural_unit_id); ", "create index acl_dtg_idx on access_control_list (data_type_group_id); ", "create index df_ft_idx on display_format ( format_type_id ); ", "create index df_sut_idx on display_format ( structural_unit_type_id ); ", "create index df_dtg_idx on display_format ( data_type_group_id ); ", "create index if_ft_idx on import_format (format_type_id); ", "create index if_sut_idx on import_format (structural_unit_type_id); " ]; my $dummy_data = [ '-- MySQL dump 10.11 ', '-- ', '-- Host: localhost Database: LUMP ', '-- ------------------------------------------------------ ', '-- Server version 5.0.95 ', '/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; ', '/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; ', '/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; ', '/*!40101 SET NAMES utf8 */; ', '/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; ', '/*!40103 SET TIME_ZONE=\'+00:00\' */; ', '/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; ', '/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; ', '/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=\'NO_AUTO_VALUE_ON_ZERO\' */; ', '/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; ', '-- ', '-- Dumping data for table `access_control_list` ', '-- ', 'LOCK TABLES `access_control_list` WRITE; ', '/*!40000 ALTER TABLE `access_control_list` DISABLE KEYS */; ', 'INSERT INTO `access_control_list` (`id`, `user_group_id`, `structural_unit_id`, `data_type_group_id`, `view`, `edit`, `created_by`, `created_time`, `modified_by`, `modified_time`) VALUES (1,1,NULL,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(2,2,NULL,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(3,3,NULL,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(4,5,5,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(5,4,5,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(6,6,5,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(7,7,5,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(8,5,5,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(9,4,5,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(10,6,5,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(11,7,5,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(12,5,6,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(13,4,6,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(14,6,6,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(15,7,6,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(16,5,6,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(17,4,6,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(18,6,6,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(19,7,6,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(20,5,7,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(21,4,7,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(22,6,7,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(23,7,7,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(24,5,7,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(25,4,7,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(26,6,7,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(27,7,7,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(28,5,7,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(29,4,7,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(30,6,7,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(31,7,7,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(32,1,7,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(33,2,7,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(34,5,8,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(35,4,8,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(36,6,8,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(37,7,8,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(38,5,8,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(39,4,8,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(40,6,8,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(41,7,8,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(42,5,8,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(43,4,8,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(44,6,8,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(45,7,8,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(46,1,8,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(47,2,8,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(48,5,8,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(49,4,8,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(50,6,8,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(51,7,8,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(52,3,8,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(53,5,9,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(54,4,9,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(55,6,9,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(56,7,9,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(57,5,9,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(58,4,9,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(59,6,9,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(60,7,9,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(61,5,9,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(62,4,9,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(63,6,9,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(64,7,9,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(65,1,9,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(66,2,9,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(67,5,10,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(68,4,10,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(69,6,10,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(70,7,10,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(71,5,10,17,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(72,4,10,17,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(73,6,10,17,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(74,7,10,17,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(75,5,10,18,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(76,4,10,18,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(77,6,10,18,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(78,7,10,18,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(79,1,10,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(80,2,10,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(81,5,10,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(82,4,10,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(83,6,10,19,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(84,7,10,19,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(85,5,11,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(86,4,11,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(87,6,11,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(88,7,11,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(89,5,11,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(90,4,11,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(91,6,11,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(92,7,11,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(93,5,11,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(94,4,11,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(95,6,11,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(96,7,11,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(97,1,11,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(98,2,11,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(99,5,12,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(100,4,12,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(101,6,12,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(102,7,12,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(103,5,12,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(104,4,12,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(105,6,12,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(106,7,12,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(107,5,12,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(108,4,12,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(109,6,12,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(110,7,12,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(111,1,12,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(112,2,12,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(113,5,12,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(114,4,12,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(115,6,12,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(116,7,12,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(117,3,12,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(118,5,13,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(119,4,13,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(120,6,13,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(121,7,13,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(122,5,13,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(123,4,13,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(124,6,13,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(125,7,13,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(126,5,13,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(127,4,13,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(128,6,13,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(129,7,13,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(130,1,13,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(131,2,13,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(132,5,14,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(133,4,14,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(134,6,14,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(135,7,14,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(136,5,14,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(137,4,14,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(138,6,14,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(139,7,14,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(140,5,14,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(141,4,14,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(142,6,14,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(143,7,14,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(144,6,14,14,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(145,7,14,14,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(146,1,14,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(147,2,14,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(148,5,14,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(149,4,14,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(150,5,15,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(151,4,15,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(152,6,15,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(153,7,15,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(154,5,15,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(155,4,15,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(156,6,15,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(157,7,15,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(158,5,15,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(159,4,15,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(160,6,15,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(161,7,15,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(162,6,15,14,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(163,7,15,14,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(164,1,15,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(165,2,15,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(166,5,15,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(167,4,15,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(168,5,16,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(169,4,16,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(170,6,16,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(171,7,16,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(172,5,16,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(173,4,16,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(174,6,16,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(175,7,16,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(176,5,16,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(177,4,16,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(178,6,16,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(179,7,16,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(180,1,16,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(181,2,16,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(182,5,17,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(183,4,17,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(184,6,17,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(185,7,17,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(186,5,17,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(187,4,17,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(188,6,17,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(189,7,17,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(190,5,17,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(191,4,17,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(192,6,17,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(193,7,17,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(194,1,17,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(195,2,17,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(196,5,17,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(197,4,17,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(198,6,17,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(199,7,17,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(200,3,17,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(201,5,18,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(202,4,18,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(203,6,18,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(204,7,18,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(205,5,18,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(206,4,18,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(207,6,18,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(208,7,18,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(209,5,18,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(210,4,18,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(211,6,18,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(212,7,18,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(213,1,18,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(214,2,18,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(215,5,19,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(216,4,19,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(217,6,19,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(218,7,19,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(219,5,19,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(220,4,19,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(221,6,19,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(222,7,19,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(223,5,19,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(224,4,19,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(225,6,19,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(226,7,19,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(227,1,19,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(228,2,19,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(229,5,19,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(230,4,19,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(231,6,19,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(232,7,19,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(233,3,19,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(234,5,20,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(235,4,20,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(236,6,20,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(237,7,20,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(238,5,20,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(239,4,20,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(240,6,20,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(241,7,20,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(242,5,20,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(243,4,20,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(244,6,20,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(245,7,20,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(246,6,20,14,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(247,7,20,14,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(248,1,20,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(249,2,20,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(250,5,20,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(251,4,20,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(252,5,21,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(253,4,21,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(254,6,21,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(255,7,21,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(256,5,21,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(257,4,21,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(258,6,21,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(259,7,21,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(260,5,21,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(261,4,21,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(262,6,21,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(263,7,21,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(264,1,21,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(265,2,21,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(266,9,22,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(267,8,22,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(268,10,22,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(269,11,22,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(270,9,22,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(271,8,22,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(272,10,22,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(273,11,22,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(274,9,23,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(275,8,23,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(276,10,23,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(277,11,23,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(278,9,23,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(279,8,23,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(280,10,23,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(281,11,23,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(282,9,24,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(283,8,24,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(284,10,24,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(285,11,24,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(286,9,24,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(287,8,24,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(288,10,24,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(289,11,24,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(290,9,24,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(291,8,24,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(292,10,24,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(293,11,24,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(294,1,24,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(295,2,24,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(296,9,25,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(297,8,25,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(298,10,25,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(299,11,25,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(300,9,25,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(301,8,25,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(302,10,25,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(303,11,25,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(304,9,25,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(305,8,25,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(306,10,25,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(307,11,25,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(308,1,25,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(309,2,25,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(310,9,26,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(311,8,26,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(312,10,26,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(313,11,26,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(314,9,26,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(315,8,26,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(316,10,26,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(317,11,26,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(318,9,26,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(319,8,26,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(320,10,26,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(321,11,26,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(322,1,26,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(323,2,26,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(324,9,26,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(325,8,26,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(326,10,26,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(327,11,26,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(328,3,26,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(329,9,27,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(330,8,27,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(331,10,27,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(332,11,27,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(333,9,27,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(334,8,27,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(335,10,27,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(336,11,27,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(337,9,27,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(338,8,27,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(339,10,27,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(340,11,27,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(341,1,27,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(342,2,27,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(343,9,27,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(344,8,27,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(345,10,27,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(346,11,27,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(347,3,27,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(348,9,28,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(349,8,28,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(350,10,28,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(351,11,28,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(352,9,28,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(353,8,28,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(354,10,28,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(355,11,28,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(356,9,28,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(357,8,28,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(358,10,28,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(359,11,28,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(360,1,28,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(361,2,28,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(362,9,28,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(363,8,28,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(364,10,28,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(365,11,28,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(366,3,28,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(367,9,29,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(368,8,29,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(369,10,29,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(370,11,29,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(371,9,29,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(372,8,29,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(373,10,29,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(374,11,29,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(375,9,29,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(376,8,29,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(377,10,29,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(378,11,29,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(379,1,29,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(380,2,29,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(381,9,29,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(382,8,29,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(383,10,29,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(384,11,29,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(385,3,29,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(386,9,30,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(387,8,30,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(388,10,30,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(389,11,30,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(390,9,30,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(391,8,30,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(392,10,30,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(393,11,30,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(394,9,30,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(395,8,30,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(396,10,30,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(397,11,30,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(398,1,30,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(399,2,30,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(400,9,30,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(401,8,30,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(402,10,30,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(403,11,30,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(404,3,30,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(405,9,31,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(406,8,31,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(407,10,31,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(408,11,31,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(409,9,31,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(410,8,31,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(411,10,31,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(412,11,31,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(413,9,31,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(414,8,31,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(415,10,31,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(416,11,31,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(417,1,31,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(418,2,31,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(419,9,32,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(420,8,32,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(421,10,32,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(422,11,32,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(423,9,32,6,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(424,8,32,6,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(425,10,32,6,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(426,11,32,6,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(427,9,32,7,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(428,8,32,7,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(429,10,32,7,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(430,11,32,7,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(431,1,32,7,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(432,2,32,7,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(433,10,32,8,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(434,11,32,8,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(435,1,32,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(436,2,32,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(437,9,32,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(438,8,32,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(439,13,35,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(440,12,35,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(441,14,35,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(442,15,35,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(443,13,35,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(444,12,35,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(445,14,35,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(446,15,35,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(447,13,36,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(448,12,36,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(449,14,36,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(450,15,36,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(451,13,36,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(452,12,36,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(453,14,36,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(454,15,36,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(455,1,NULL,1,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(456,1,NULL,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(457,1,NULL,7,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(458,1,NULL,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(459,1,NULL,12,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(460,1,NULL,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(461,1,NULL,17,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(462,1,NULL,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(463,1,NULL,22,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(464,1,NULL,24,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'); ', '/*!40000 ALTER TABLE `access_control_list` ENABLE KEYS */; ', 'UNLOCK TABLES; ', '-- ', '-- Dumping data for table `acl_defaults` ', '-- ', 'LOCK TABLES `acl_defaults` WRITE; ', '/*!40000 ALTER TABLE `acl_defaults` DISABLE KEYS */; ', 'INSERT INTO `acl_defaults` (`id`, `priority_id`, `structural_unit_type_id`, `data_type_group_id`, `view`, `edit`, `created_by`, `created_time`, `modified_by`, `modified_time`) VALUES (1,4,1,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(2,3,1,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(3,5,1,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(4,6,1,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(5,4,1,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(6,3,1,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(7,5,1,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(8,6,1,1,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(9,4,1,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(10,3,1,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(11,5,1,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(12,6,1,2,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(13,1,1,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(14,2,1,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(15,4,1,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(16,3,1,3,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(17,5,1,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(18,6,1,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(19,7,1,3,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(20,4,2,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(21,3,2,NULL,\'Y\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(22,5,2,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(23,6,2,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(24,4,2,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(25,3,2,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(26,5,2,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(27,6,2,4,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(28,4,3,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(29,3,3,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(30,5,3,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(31,6,3,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(32,4,3,5,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(33,3,3,5,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(34,5,3,5,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(35,6,3,5,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(36,4,4,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(37,3,4,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(38,5,4,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(39,6,4,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(40,4,4,6,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(41,3,4,6,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(42,5,4,6,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(43,6,4,6,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(44,4,4,7,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(45,3,4,7,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(46,5,4,7,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(47,6,4,7,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(48,1,4,7,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(49,2,4,7,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(50,5,4,8,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(51,6,4,8,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(52,1,4,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(53,2,4,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(54,4,4,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(55,3,4,8,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(56,4,6,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(57,3,6,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(58,5,6,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(59,6,6,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(60,4,6,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(61,3,6,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(62,5,6,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(63,6,6,10,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(64,4,6,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(65,3,6,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(66,5,6,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(67,6,6,11,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(68,1,6,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(69,2,6,11,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(70,4,7,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(71,3,7,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(72,5,7,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(73,6,7,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(74,4,7,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(75,3,7,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(76,5,7,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(77,6,7,12,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(78,4,7,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(79,3,7,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(80,5,7,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(81,6,7,13,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(82,5,7,14,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(83,6,7,14,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(84,1,7,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(85,2,7,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(86,4,7,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(87,3,7,14,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(88,4,10,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(89,3,10,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(90,5,10,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(91,6,10,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(92,4,10,17,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(93,3,10,17,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(94,5,10,17,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(95,6,10,17,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(96,4,10,18,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(97,3,10,18,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(98,5,10,18,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(99,6,10,18,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(100,1,10,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(101,2,10,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(102,4,10,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(103,3,10,19,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(104,5,10,19,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(105,6,10,19,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(106,4,12,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(107,3,12,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(108,5,12,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(109,6,12,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(110,4,12,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(111,3,12,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(112,5,12,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(113,6,12,21,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(114,4,13,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(115,3,13,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(116,5,13,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(117,6,13,NULL,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(118,4,13,22,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(119,3,13,22,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(120,5,13,22,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(121,6,13,22,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(122,4,13,23,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(123,3,13,23,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(124,5,13,23,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(125,6,13,23,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(126,1,13,24,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(127,2,13,24,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(128,4,13,24,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(129,3,13,24,\'N\',\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(130,5,13,24,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(131,6,13,24,\'Y\',\'Y\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'); ', '/*!40000 ALTER TABLE `acl_defaults` ENABLE KEYS */; ', 'UNLOCK TABLES; ', '-- ', '-- Dumping data for table `controlled_vocabulary` ', '-- ', 'LOCK TABLES `controlled_vocabulary` WRITE; ', '/*!40000 ALTER TABLE `controlled_vocabulary` DISABLE KEYS */; ', '/*!40000 ALTER TABLE `controlled_vocabulary` ENABLE KEYS */; ', 'UNLOCK TABLES; ', '-- ', '-- Dumping data for table `data_element` ', '-- ', 'LOCK TABLES `data_element` WRITE; ', '/*!40000 ALTER TABLE `data_element` DISABLE KEYS */; ', 'INSERT INTO `data_element` (`id`, `data_type_id`, `structural_unit_id`, `value`, `created_by`, `created_time`, `modified_by`, `modified_time`) VALUES (1,110,1,\'http://www.example.com/\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(2,111,1,\'Example Institution\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(3,112,1,\'http://www.lboro.ac.uk/about/images/p-lulogo.gif\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(4,79,2,\'LB\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(5,80,2,\'Library\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(6,47,3,\'A\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(7,48,3,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(8,49,3,\'First Year Undergraduate\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(9,82,4,\'2008\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(10,25,5,\'2008\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(11,26,5,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(12,27,5,\'Administrators Guide\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(13,29,5,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(14,30,5,\'08LBA124\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(15,113,6,\'Dr Cool\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(16,114,6,\'Administrators Guide Main Reading List\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(17,28,5,\'Dr Cool\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(18,50,7,\'
This demonstration reading list contains examples of the different types of material that can be added using this system, and how LORLS can be used as a master for all your course resources.
By using simple html you can use the note field for adding Headings and course notes.
You can also copy whole or part of a list into another module saving time and effort. For larger modules you can easily divide your reading lists into sub-lists.
You can order the list alphabetically, and re-rank items just as you wish
Click on Edit note add your notes and when complete click Submit note.
Return to the main list by clicking Manage List
\\r\\n\\r\\nAdding Books:
* ISBNs should be entered without any spaces or hyphens.
* ISBNs may be copied and pasted from the Library Catalogue.ISBNs with \\\'x\\\' must be lower case
Click New Item insert ISBN click \\"Get Bibliographic Details\\" button (if the Library holds the item, the top part of the form will be filled in automatically).\\r\\n
\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(19,1,8,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(20,2,8,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(21,4,8,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(22,6,8,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(23,7,8,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(24,8,8,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(25,9,8,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(26,10,8,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(27,12,8,\'Polity\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(28,13,8,\'2003\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(29,14,8,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(30,15,8,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(31,16,8,\'Soap opera\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(32,17,8,\'0745626556\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(33,18,8,\'Hobson, Dorothy\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(34,20,8,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(35,21,8,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(36,22,8,\'15\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(37,23,8,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(38,24,8,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(39,50,9,\'Book Chapters:
You can specify a chapter by following the instructions above and then complete part \\\'B\\\' on the form. See below:
\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(40,83,10,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(41,84,10,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(42,86,10,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(43,88,10,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(44,89,10,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(45,90,10,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(46,91,10,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(47,92,10,\'Please read chapter two only\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(48,93,10,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(49,94,10,\'Polity\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(50,95,10,\'2003\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(51,96,10,\'Hobson, Dorothy\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(52,97,10,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(53,98,10,\'Elements of production\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(54,99,10,\'63-78\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(55,100,10,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(56,101,10,\'Soap opera\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(57,102,10,\'0745626556\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(58,103,10,\'Hobson, Dorothy\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(59,105,10,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(60,106,10,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(61,107,10,\'16\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(62,108,10,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(63,109,10,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(64,50,11,\'E-Books:
Following instructions for print book, and then enter the URL of an item available electronically.
\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(65,1,12,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(66,2,12,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(67,4,12,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(68,6,12,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(69,7,12,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(70,8,12,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(71,9,12,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(72,10,12,\'ATHENS username and password required\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(73,11,12,\'http://www.LBORO.eblib.com/EBLWeb/patron/?target=patron&extendedid=E_414848_0;\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(74,12,12,\'Idea Group Pub.\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(75,13,12,\'2004\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(76,14,12,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(77,15,12,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(78,16,12,\'Beyond knowledge management\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(79,17,12,\'1591401801\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(80,18,12,\'Lehaney, Brian\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(81,20,12,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(82,21,12,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(83,22,12,\'17\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(84,23,12,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(85,24,12,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(86,50,13,\'Adding journal articles:
Both print and electronic articles can be added to your list.
From Author/Title page of Serials Catalogue, click on the relevant number on the Left Hand Side of the screen, eg: 3.
\\r\\n\\r\\n* Paste the Control number into the relevant ISBN/ISSN field in your Serial record
If an ISSN or Control number is entered, click \\"Get Bibliographic Details\\" button.If the Library holds the item, the top part of the form will be filled in automatically.
\\r\\n\\r\\nIf the ISSN will not link follow the instructions below:-
\\r\\n\\r\\n* Click MARC tags on the Choose format line.
\\r\\n\\r\\n* Copy and paste the 9-digit number from the 001 field on the LHS of the screen.
\\r\\n\\r\\n
For electronic resource Serials, copy and paste the http:// string on the External line, excluding the last semi-colon.\\r\\n\\r\\n\\r\\n
\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(87,52,14,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(88,53,14,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(89,55,14,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(90,57,14,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(91,58,14,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(92,59,14,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(93,60,14,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(94,61,14,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(95,62,14,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(96,63,14,\'001051800\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(97,64,14,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(98,66,14,\'2\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(99,67,14,\'42-44\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(100,68,14,\'Plagiarism and the role of the library\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(101,69,14,\'12\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(102,70,14,\'Library & information update.\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(103,71,14,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(104,73,14,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(105,74,14,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(106,75,14,\'18\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(107,76,14,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(108,77,14,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(109,52,15,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(110,53,15,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(111,55,15,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(112,57,15,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(113,58,15,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(114,59,15,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(115,60,15,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(116,61,15,\'Also available from Loughborough University Institutional Repository\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(117,62,15,\'http://www.lirg.org.uk/lir/previous.htm\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(118,63,15,\'000167249\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(119,64,15,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(120,65,15,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(121,66,15,\'26\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(122,67,15,\'38-42\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(123,68,15,\'Publish and be read? A review of the usage of Loughborough University Library publications\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(124,69,15,\'82\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(125,70,15,\'Library and information research.\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(126,71,15,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(127,73,15,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(128,74,15,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(129,75,15,\'19\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(130,76,15,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(131,77,15,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(132,50,16,\'Short loan photocopies:
Articles that are in great demand can be copied from the hard copy of journals the Library holds, and added to the short loan collection.
Copyright cleared copies will be applied for from the British Library for those articles not in stock.
Also extracts of books the Library has in stock can be copied, so long as they are no more than one chapter or 10% of the book.
\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(133,1,17,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(134,2,17,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(135,4,17,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(136,6,17,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(137,7,17,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(138,8,17,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(139,9,17,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(140,10,17,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(141,12,17,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(142,13,17,\'1999\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(143,14,17,\'\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(144,15,17,\'0\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(145,16,17,\'The institutional structure of regulatory agencies\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(146,17,17,\'001060013\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(147,18,17,\'Llewellyn, David T\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(148,20,17,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(149,21,17,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(150,22,17,\'20\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(151,23,17,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(152,24,17,\'N\',\'admin\',\'2012-11-12 16:46:55\',\'admin\',\'2012-11-12 16:46:55\'),(153,50,18,\'If you have a section of notes or items you want to repeat elsewhere
you can copy the items using
\\r\\n\\r\\n1. Select the items you want to repeat.
\\r\\n\\r\\n2. Click \\"Append selected to module\\" the items will be appended to the end of the current reading list.
\\r\\n\\r\\nTo append to another Reading List
that you own (thus allowing you to create similar or identical copies of a reading list):-
\\r\\n\\r\\n* Change the module code in the prompt box beside the button.\\r\\n