--
-- Host: localhost    Database: damvsbrooks
-- ------------------------------------------------------


--
-- Table structure for table `collection`
--

CREATE TABLE `collection` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `public` int(11) DEFAULT '0',
  `theme` varchar(100) DEFAULT NULL,
  `theme2` varchar(100) DEFAULT NULL,
  `theme3` varchar(100) DEFAULT NULL,
  `allow_changes` int(11) DEFAULT '0',
  `cant_delete` int(11) DEFAULT '0',
  `keywords` text,
  `savedsearch` int(11) DEFAULT NULL,
  `home_page_publish` int(11) DEFAULT NULL,
  `home_page_text` text,
  `home_page_image` int(11) DEFAULT NULL,
  PRIMARY KEY (`ref`),
  KEY `theme` (`theme`),
  KEY `public` (`public`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `collection`
--

INSERT INTO `collection` VALUES (1,'My Collection',1,'2008-01-01 10:00:00',0,NULL,'0','1',NULL,1,NULL,NULL,NULL,NULL,NULL),(3,'Upload 130731015132',1,'2013-07-30 21:51:32',1,'',NULL,NULL,0,0,'',NULL,0,'',NULL),(4,'Upload 130731020206',1,'2013-07-30 22:02:06',1,'',NULL,NULL,0,0,'',NULL,0,'',NULL),(5,'My Collection',2,'2014-02-04 15:14:48',0,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL),(6,'My Collection',3,'2014-02-04 15:32:46',0,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL),(7,'My Collection',4,'2014-02-11 16:50:45',0,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `collection_keyword`
--

CREATE TABLE `collection_keyword` (
  `collection` int(11) DEFAULT NULL,
  `keyword` int(11) DEFAULT NULL,
  KEY `collection` (`collection`),
  KEY `keyword` (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `collection_keyword`
--

INSERT INTO `collection_keyword` VALUES (3,4),(3,3),(3,12),(3,11),(3,10),(4,4),(4,3),(4,16),(4,11),(4,15),(5,18),(5,19),(5,20),(6,25),(6,19),(6,20),(7,45),(7,19),(7,20);

--
-- Table structure for table `collection_log`
--

CREATE TABLE `collection_log` (
  `date` datetime DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `collection` int(11) DEFAULT NULL,
  `type` char(1) DEFAULT NULL,
  `resource` int(11) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `collection_log`
--

INSERT INTO `collection_log` VALUES ('2013-07-29 22:54:11',1,2,'X',NULL,''),('2013-07-30 22:00:44',1,3,'T',NULL,'#all_users'),('2013-07-30 22:00:47',1,3,'T',NULL,'#all_users'),('2013-07-30 22:01:23',1,3,'T',NULL,'#all_users'),('2013-07-30 22:02:37',1,4,'T',NULL,'#all_users'),('2013-07-30 22:02:48',1,4,'T',NULL,'#all_users'),('2014-02-11 11:36:43',1,3,'a',1,''),('2014-02-11 11:38:41',1,3,'a',2,''),('2014-02-11 12:47:03',1,3,'r',2,''),('2014-02-11 12:47:04',1,3,'r',1,''),('2014-02-11 12:48:51',1,1,'a',3,'');

--
-- Table structure for table `collection_resource`
--

CREATE TABLE `collection_resource` (
  `collection` int(11) DEFAULT NULL,
  `resource` int(11) DEFAULT NULL,
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `comment` text,
  `rating` int(11) DEFAULT NULL,
  `use_as_theme_thumbnail` int(11) DEFAULT NULL,
  `purchase_size` varchar(10) DEFAULT NULL,
  `purchase_complete` int(11) DEFAULT '0',
  `purchase_price` decimal(10,2) DEFAULT '0.00',
  `sortorder` int(11) DEFAULT NULL,
  KEY `collection` (`collection`),
  KEY `resource_collection` (`collection`,`resource`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `collection_resource`
--

INSERT INTO `collection_resource` VALUES (1,3,'2014-02-11 17:48:51',NULL,NULL,NULL,'',0,0.00,1);

--
-- Table structure for table `collection_savedsearch`
--

CREATE TABLE `collection_savedsearch` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `collection` int(11) DEFAULT NULL,
  `search` text,
  `restypes` text,
  `starsearch` int(11) DEFAULT NULL,
  `archive` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `result_limit` int(11) DEFAULT NULL,
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `collection_savedsearch`
--


--
-- Table structure for table `daily_stat`
--

CREATE TABLE `daily_stat` (
  `year` int(11) DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `day` int(11) DEFAULT NULL,
  `usergroup` int(11) DEFAULT '0',
  `activity_type` varchar(50) DEFAULT NULL,
  `object_ref` int(11) DEFAULT NULL,
  `count` int(11) DEFAULT '0',
  KEY `stat_day` (`year`,`month`,`day`),
  KEY `stat_month` (`year`,`month`),
  KEY `stat_usergroup` (`usergroup`),
  KEY `stat_day_activity` (`year`,`month`,`day`,`activity_type`),
  KEY `stat_day_activity_ref` (`year`,`month`,`day`,`activity_type`,`object_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daily_stat`
--

INSERT INTO `daily_stat` VALUES (2013,7,30,0,'User session',1,2),(2013,7,30,3,'New collection',1,1),(2013,7,31,3,'User session',1,4),(2013,7,31,0,'User session',1,6),(2013,7,31,3,'Keyword added to resource',5,3),(2013,7,31,3,'Keyword added to resource',6,3),(2013,7,31,3,'Keyword added to resource',7,1),(2013,7,31,3,'Keyword added to resource',8,4),(2013,7,31,3,'Keyword added to resource',9,1),(2013,7,31,3,'Keyword added to resource',2,1),(2013,7,31,3,'Search',0,4),(2013,7,31,3,'Keyword added to resource',13,1),(2013,7,31,3,'Keyword added to resource',14,1),(2014,1,13,0,'User session',1,1),(2014,1,21,3,'User session',1,1),(2014,2,4,3,'User session',1,1),(2014,2,4,0,'User session',2,1),(2014,2,4,3,'Keyword added to resource',21,1),(2014,2,4,3,'Keyword added to resource',22,1),(2014,2,4,3,'Keyword added to resource',23,1),(2014,2,4,3,'Keyword added to resource',24,1),(2014,2,4,3,'Keyword added to resource',8,1),(2014,2,4,3,'Add saved search to collection',0,1),(2014,2,4,0,'User session',3,1),(2014,2,4,2,'User session',2,1),(2014,2,5,3,'User session',1,1),(2014,2,5,3,'Search',0,5),(2014,2,5,0,'User session',1,2),(2014,2,10,0,'User session',2,1),(2014,2,11,3,'User session',1,2),(2014,2,11,3,'Keyword added to resource',22,7),(2014,2,11,3,'Keyword added to resource',23,7),(2014,2,11,3,'Keyword added to resource',26,1),(2014,2,11,3,'Keyword added to resource',8,6),(2014,2,11,3,'Keyword added to resource',2,5),(2014,2,11,3,'Keyword added to resource',27,1),(2014,2,11,3,'Keyword added to resource',28,3),(2014,2,11,3,'Keyword added to resource',3,6),(2014,2,11,3,'Keyword added to resource',4,3),(2014,2,11,3,'Create resource',1,1),(2014,2,11,3,'Resource upload',1,1),(2014,2,11,3,'Keyword added to resource',29,2),(2014,2,11,3,'Keyword added to resource',30,2),(2014,2,11,3,'Keyword added to resource',31,2),(2014,2,11,3,'Keyword added to resource',1,1),(2014,2,11,3,'Create resource',2,1),(2014,2,11,3,'Resource upload',2,1),(2014,2,11,3,'Resource view',2,3),(2014,2,11,3,'Resource download',2,1),(2014,2,11,3,'Resource view',1,5),(2014,2,11,3,'E-mailed resource',1,1),(2014,2,11,3,'Search',0,9),(2014,2,11,3,'Keyword usage',2,1),(2014,2,11,3,'Keyword added to resource',32,2),(2014,2,11,3,'Keyword added to resource',33,5),(2014,2,11,3,'Keyword added to resource',34,5),(2014,2,11,3,'Keyword added to resource',35,5),(2014,2,11,3,'Keyword added to resource',36,3),(2014,2,11,3,'Keyword added to resource',37,2),(2014,2,11,3,'Keyword added to resource',10,14),(2014,2,11,3,'Create resource',3,1),(2014,2,11,3,'Resource upload',3,1),(2014,2,11,3,'Keyword added to resource',38,1),(2014,2,11,3,'Keyword added to resource',39,1),(2014,2,11,3,'Keyword added to resource',40,1),(2014,2,11,3,'Keyword added to resource',41,1),(2014,2,11,3,'Keyword added to resource',42,1),(2014,2,11,3,'Keyword added to resource',43,2),(2014,2,11,3,'Keyword added to resource',44,1),(2014,2,11,3,'Resource view',3,25),(2014,2,11,0,'User session',1,2),(2014,2,11,0,'User session',3,6),(2014,2,11,3,'Keyword added to resource',13,1),(2014,2,11,3,'Resource edit',3,4),(2014,2,11,0,'User session',2,2),(2014,2,11,2,'Search',0,3),(2014,2,11,2,'Resource view',3,3),(2014,2,11,3,'E-mailed resource',3,1),(2014,2,11,3,'Resource download',3,5),(2014,2,11,0,'User session',4,2),(2014,2,12,0,'User session',2,1),(2014,2,12,3,'Resource view',3,3),(2014,2,12,2,'Search',0,1),(2014,2,12,2,'Resource view',3,1),(2014,2,13,3,'User session',1,2),(2014,2,13,3,'Search',0,1),(2014,2,13,3,'Resource view',3,1),(2014,2,25,3,'Resource view',3,2),(2014,2,25,0,'User session',2,1),(2014,2,25,3,'Resource download',3,1);

--
-- Table structure for table `dynamic_tree_node`
--

CREATE TABLE `dynamic_tree_node` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `resource_type_field` int(11) DEFAULT '0',
  `parent` int(11) DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ref`),
  KEY `parent` (`parent`),
  KEY `resource_type_field` (`resource_type_field`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dynamic_tree_node`
--


--
-- Table structure for table `external_access_keys`
--

CREATE TABLE `external_access_keys` (
  `resource` int(11) DEFAULT NULL,
  `access_key` char(10) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `collection` int(11) DEFAULT NULL,
  `request_feedback` int(11) DEFAULT '0',
  `email` varchar(100) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `lastused` datetime DEFAULT NULL,
  `access` int(11) DEFAULT '-1',
  `expires` datetime DEFAULT NULL,
  KEY `resource` (`resource`),
  KEY `resource_key` (`resource`,`access_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `external_access_keys`
--

INSERT INTO `external_access_keys` VALUES (1,'11ccbb9af4',1,NULL,0,NULL,NULL,'2014-02-11 11:47:16',0,NULL),(3,'cc7f4f2dee',1,NULL,0,NULL,NULL,'2014-02-25 11:33:54',0,NULL),(3,'cc7f4f2dee',1,NULL,0,NULL,NULL,'2014-02-25 11:33:54',0,NULL);

--
-- Table structure for table `ip_lockout`
--

CREATE TABLE `ip_lockout` (
  `ip` varchar(40) NOT NULL DEFAULT '',
  `tries` int(11) DEFAULT '0',
  `last_try` datetime DEFAULT NULL,
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ip_lockout`
--


--
-- Table structure for table `keyword`
--

CREATE TABLE `keyword` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(100) DEFAULT NULL,
  `soundex` varchar(50) DEFAULT NULL,
  `hit_count` int(11) DEFAULT '0',
  PRIMARY KEY (`ref`),
  KEY `keyword` (`keyword`),
  KEY `keyword_hit_count` (`hit_count`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `keyword`
--

INSERT INTO `keyword` VALUES (1,'2','',0),(2,'test','T230',4),(3,'admin','A350',6),(4,'user','U260',3),(5,'2013','0000',0),(9,'2013-07-31 01:51','0000',0),(6,'2013-07','0000',0),(7,'2013-07-31 01:50','0000',0),(8,'1','0000',1),(10,'3','',0),(11,'upload','U143',0),(12,'130731015132','',0),(13,'client1','C453',0),(14,'2013-07-31 02:01','0000',0),(15,'4','',0),(16,'130731020206','',0),(17,'','',-5),(18,'5','',0),(19,'my','M000',0),(20,'collection','C4235',0),(21,'client2','C453',0),(22,'2014','0000',4),(26,'2014-02-11 16:33','0000',0),(23,'2014-02','0000',4),(28,'2014-02-11 16:36','0000',2),(24,'2014-02-04 20:30','0000',0),(25,'6','',0),(27,'2014-02-11 16:34','0000',0),(29,'mena','M500',2),(30,'01','0000',2),(31,'jpg','J120',2),(32,'2014-02-11 17:47','0000',2),(33,'clinical','C452',5),(34,'care','C600',5),(35,'benches','B522',5),(36,'pdf','P310',3),(37,'file','F400',2),(38,'cpp','C100',1),(39,'4809','0000',1),(40,'s','S000',1),(41,'od','O300',1),(42,'pcs','P200',1),(43,'50','0000',2),(44,'final','F540',1),(45,'7','',0);

--
-- Table structure for table `keyword_related`
--

CREATE TABLE `keyword_related` (
  `keyword` int(11) DEFAULT NULL,
  `related` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `keyword_related`
--


--
-- Table structure for table `plugins`
--

CREATE TABLE `plugins` (
  `name` varchar(20) NOT NULL DEFAULT '',
  `descrip` varchar(100) DEFAULT NULL,
  `author` varchar(100) DEFAULT NULL,
  `update_url` varchar(100) DEFAULT NULL,
  `info_url` varchar(100) DEFAULT NULL,
  `inst_version` float DEFAULT NULL,
  `config` longblob,
  `config_json` text,
  `config_url` varchar(100) DEFAULT NULL,
  `enabled_groups` varchar(200) DEFAULT NULL,
  `priority` int(11) DEFAULT '999',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `plugins`
--


--
-- Table structure for table `preview_size`
--

CREATE TABLE `preview_size` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `id` char(3) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `padtosize` int(11) DEFAULT '0',
  `name` varchar(50) DEFAULT NULL,
  `internal` int(11) DEFAULT '0',
  `allow_preview` int(11) DEFAULT '0',
  `allow_restricted` int(11) DEFAULT '0',
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `preview_size`
--

INSERT INTO `preview_size` VALUES (1,'thm',150,150,0,'Thumbnail',1,0,0),(2,'pre',350,350,0,'Preview',1,0,1),(3,'scr',1100,800,0,'Screen',0,1,0),(4,'lpr',2000,2000,0,'Low resolution print',0,0,0),(5,'hpr',999999,999999,0,'High resolution print',0,0,0),(6,'col',75,75,0,'Collection',1,0,0);

--
-- Table structure for table `report`
--

CREATE TABLE `report` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `query` text,
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report`
--

INSERT INTO `report` VALUES (1,'Keywords used in resource edits','select k.keyword \'Keyword\',sum(count) \'Entered Count\' from keyword k,daily_stat d where k.ref=d.object_ref and d.activity_type=\'Keyword added to resource\'\n\n# --- date ranges\n# Make sure date is greater than FROM date\nand \n(\nd.year>[from-y]\nor \n(d.year=[from-y] and d.month>[from-m])\nor\n(d.year=[from-y] and d.month=[from-m] and d.day>=[from-d])\n)\n# Make sure date is less than TO date\nand\n(\nd.year<[to-y]\nor \n(d.year=[to-y] and d.month<[to-m])\nor\n(d.year=[to-y] and d.month=[to-m] and d.day<=[to-d])\n)\n\n\ngroup by k.ref order by \'Entered Count\' desc limit 100;\n'),(2,'Keywords used in searches','select k.keyword \'Keyword\',sum(count) Searches from keyword k,daily_stat d where k.ref=d.object_ref and d.activity_type=\'Keyword usage\'\n\n# --- date ranges\n# Make sure date is greater than FROM date\nand \n(\nd.year>[from-y]\nor \n(d.year=[from-y] and d.month>[from-m])\nor\n(d.year=[from-y] and d.month=[from-m] and d.day>=[from-d])\n)\n# Make sure date is less than TO date\nand\n(\nd.year<[to-y]\nor \n(d.year=[to-y] and d.month<[to-m])\nor\n(d.year=[to-y] and d.month=[to-m] and d.day<=[to-d])\n)\n\n\ngroup by k.ref order by Searches desc\n'),(3,'Resource download summary','select r.ref \'Resource ID\',r.view_title_field \'Title\',count(*) Downloads \n\nfrom\n\nresource_log rl\njoin resource r on rl.resource=r.ref\nwhere\nrl.type=\'d\'\nand rl.date>=date(\'[from-y]-[from-m]-[from-d]\') and rl.date<=adddate(date(\'[to-y]-[to-m]-[to-d]\'),1)\ngroup by r.ref order by \'Downloads\' desc'),(4,'Resource views','select r.ref \'Resource ID\',r.view_title_field \'Title\',sum(count) Views from resource r,daily_stat d where r.ref=d.object_ref and d.activity_type=\'Resource view\'\n\n# --- date ranges\n# Make sure date is greater than FROM date\nand \n(\nd.year>[from-y]\nor \n(d.year=[from-y] and d.month>[from-m])\nor\n(d.year=[from-y] and d.month=[from-m] and d.day>=[from-d])\n)\n# Make sure date is less than TO date\nand\n(\nd.year<[to-y]\nor \n(d.year=[to-y] and d.month<[to-m])\nor\n(d.year=[to-y] and d.month=[to-m] and d.day<=[to-d])\n)\n\n\ngroup by r.ref order by Views desc;\n'),(5,'Resources sent via e-mail','select r.ref \'Resource ID\',r.view_title_field \'Title\',sum(count) Sent from resource r,daily_stat d where r.ref=d.object_ref and d.activity_type=\'E-mailed resource\'\n\n# --- date ranges\n# Make sure date is greater than FROM date\nand \n(\nd.year>[from-y]\nor \n(d.year=[from-y] and d.month>[from-m])\nor\n(d.year=[from-y] and d.month=[from-m] and d.day>=[from-d])\n)\n# Make sure date is less than TO date\nand\n(\nd.year<[to-y]\nor \n(d.year=[to-y] and d.month<[to-m])\nor\n(d.year=[to-y] and d.month=[to-m] and d.day<=[to-d])\n)\n\n\ngroup by r.ref order by Sent desc;\n'),(6,'Resources added to collection','select r.ref \'Resource ID\',r.view_title_field \'Title\',sum(count) Added from resource r,daily_stat d where r.ref=d.object_ref and d.activity_type=\'Add resource to collection\'\n\n# --- date ranges\n# Make sure date is greater than FROM date\nand \n(\nd.year>[from-y]\nor \n(d.year=[from-y] and d.month>[from-m])\nor\n(d.year=[from-y] and d.month=[from-m] and d.day>=[from-d])\n)\n# Make sure date is less than TO date\nand\n(\nd.year<[to-y]\nor \n(d.year=[to-y] and d.month<[to-m])\nor\n(d.year=[to-y] and d.month=[to-m] and d.day<=[to-d])\n)\n\n\ngroup by r.ref order by Added desc;\n'),(7,'Resources created','select\nrl.date \'Date / Time\',\nconcat(u.username,\' (\',u.fullname,\' )\') \'Created By User\',\ng.name \'User Group\',\nr.ref \'Resource ID\',\nr.view_title_field \'Resource Title\'\n\nfrom\nresource_log rl\njoin resource r on r.ref=rl.resource\nleft outer join user u on rl.user=u.ref\nleft outer join usergroup g on u.usergroup=g.ref\nwhere\nrl.type=\'c\'\nand\nrl.date>=date(\'[from-y]-[from-m]-[from-d]\') and rl.date<=adddate(date(\'[to-y]-[to-m]-[to-d]\'),1)\norder by rl.date'),(8,'Resources with zero downloads','select ref \'Resource ID\',view_title_field \'Title\' from resource where ref not in \n\n(\n#Previous query to fetch resource downloads\nselect r.ref from resource r,daily_stat d where r.ref=d.object_ref and d.activity_type=\'Resource download\'\n\n# --- date ranges\n# Make sure date is greater than FROM date\nand \n(\nd.year>[from-y]\nor \n(d.year=[from-y] and d.month>[from-m])\nor\n(d.year=[from-y] and d.month=[from-m] and d.day>=[from-d])\n)\n# Make sure date is less than TO date\nand\n(\nd.year<[to-y]\nor \n(d.year=[to-y] and d.month<[to-m])\nor\n(d.year=[to-y] and d.month=[to-m] and d.day<=[to-d])\n)\n\n\ngroup by r.ref\n)'),(9,'Resources with zero views','select ref \'Resource ID\',view_title_field \'Title\' from resource where ref not in \n\n(\n#Previous query to fetch resource views\nselect r.ref from resource r,daily_stat d where r.ref=d.object_ref and d.activity_type=\'Resource view\'\n\n# --- date ranges\n# Make sure date is greater than FROM date\nand \n(\nd.year>[from-y]\nor \n(d.year=[from-y] and d.month>[from-m])\nor\n(d.year=[from-y] and d.month=[from-m] and d.day>=[from-d])\n)\n# Make sure date is less than TO date\nand\n(\nd.year<[to-y]\nor \n(d.year=[to-y] and d.month<[to-m])\nor\n(d.year=[to-y] and d.month=[to-m] and d.day<=[to-d])\n)\n\ngroup by r.ref\n)'),(10,'Resource downloads by group','select\ng.name \'Group Name\',\ncount(rl.resource) \'Resource Downloads\'\n\nfrom\nresource_log rl\nleft outer join user u on rl.user=u.ref\nleft outer join usergroup g on u.usergroup=g.ref\nwhere\nrl.type=\'d\'\nand rl.date>=date(\'[from-y]-[from-m]-[from-d]\') and rl.date<=adddate(date(\'[to-y]-[to-m]-[to-d]\'),1)\ngroup by g.ref order by \'Resource Downloads\' desc'),(11,'Resource download detail','select\nrl.date \'Date / Time\',\nconcat(u.username,\' (\',u.fullname,\' )\') \'Downloaded By User\',\ng.name \'User Group\',\nr.ref \'Resource ID\',\nr.title \'Resource Title\',\nrt.name \'Resource Type\'\n\nfrom\nresource_log rl\njoin resource r on r.ref=rl.resource\nleft outer join user u on rl.user=u.ref\nleft outer join usergroup g on u.usergroup=g.ref\nleft outer join resource_type rt on r.resource_type=rt.ref\nwhere\nrl.type=\'d\'\nand\nrl.date>=date(\'[from-y]-[from-m]-[from-d]\') and rl.date<=adddate(date(\'[to-y]-[to-m]-[to-d]\'),1)\norder by rl.date'),(12,'User details including group allocation','select \nu.username \'Username\',\nu.email \'E-mail address\',\nu.fullname \'Full Name\',\nu.created \'Created\',\nu.last_active \'Last Seen\',\ng.name \'Group name\'\n\nfrom user u join usergroup g on u.usergroup=g.ref\n\norder by username;'),(13,'Expired Resources','select distinct resource.ref \'Resource ID\',resource.field8 \'Resource Title\',resource_data.value \'Expires\' from resource join resource_data on resource.ref=resource_data.resource join resource_type_field on resource_data.resource_type_field=resource_type_field.ref where resource_type_field.type=6 and value>=date(\'[from-y]-[from-m]-[from-d]\') and value<=adddate(date(\'[to-y]-[to-m]-[to-d]\'),1) and length(value)>0 and resource.ref>0 order by resource.ref;'),(14,'Resources created - with thumbnails','select\nr.ref \'thumbnail\',\nrl.date \'Date / Time\',\nconcat(u.username,\' (\',u.fullname,\' )\') \'Created By User\',\ng.name \'User Group\',\nr.ref \'Resource ID\',\nr.view_title_field \'Resource Title\'\n\nfrom\nresource_log rl\njoin resource r on r.ref=rl.resource\nleft outer join user u on rl.user=u.ref\nleft outer join usergroup g on u.usergroup=g.ref\nwhere\nrl.type=\'c\'\nand\nrl.date>=date(\'[from-y]-[from-m]-[from-d]\') and rl.date<=adddate(date(\'[to-y]-[to-m]-[to-d]\'),1)\norder by rl.date;');

--
-- Table structure for table `report_periodic_emails`
--

CREATE TABLE `report_periodic_emails` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) DEFAULT NULL,
  `send_all_users` int(11) DEFAULT NULL,
  `report` int(11) DEFAULT NULL,
  `period` int(11) DEFAULT NULL,
  `email_days` int(11) DEFAULT NULL,
  `last_sent` datetime DEFAULT NULL,
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report_periodic_emails`
--


--
-- Table structure for table `request`
--

CREATE TABLE `request` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) DEFAULT NULL,
  `collection` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `request_mode` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `comments` text,
  `expires` date DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `reason` text,
  `reasonapproved` text,
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `request`
--


--
-- Table structure for table `research_request`
--

CREATE TABLE `research_request` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `description` text,
  `deadline` datetime DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `contact` varchar(100) DEFAULT NULL,
  `finaluse` text,
  `resource_types` varchar(50) DEFAULT NULL,
  `noresources` int(11) DEFAULT NULL,
  `shape` varchar(50) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `collection` int(11) DEFAULT NULL,
  PRIMARY KEY (`ref`),
  KEY `research_collections` (`collection`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `research_request`
--


--
-- Table structure for table `resource`
--

CREATE TABLE `resource` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `resource_type` int(11) DEFAULT NULL,
  `has_image` int(11) DEFAULT '0',
  `is_transcoding` int(11) DEFAULT '0',
  `hit_count` int(11) DEFAULT '0',
  `new_hit_count` int(11) DEFAULT '0',
  `creation_date` datetime DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `user_rating` int(11) DEFAULT NULL,
  `user_rating_count` int(11) DEFAULT NULL,
  `user_rating_total` int(11) DEFAULT NULL,
  `country` varchar(200) DEFAULT NULL,
  `file_extension` varchar(10) DEFAULT NULL,
  `preview_extension` varchar(10) DEFAULT NULL,
  `image_red` int(11) DEFAULT NULL,
  `image_green` int(11) DEFAULT NULL,
  `image_blue` int(11) DEFAULT NULL,
  `thumb_width` int(11) DEFAULT NULL,
  `thumb_height` int(11) DEFAULT NULL,
  `archive` int(11) DEFAULT '0',
  `access` int(11) DEFAULT '0',
  `colour_key` varchar(5) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `file_path` varchar(500) DEFAULT NULL,
  `file_modified` datetime DEFAULT NULL,
  `file_checksum` varchar(32) DEFAULT NULL,
  `request_count` int(11) DEFAULT '0',
  `expiry_notification_sent` int(11) DEFAULT '0',
  `preview_tweaks` varchar(50) DEFAULT NULL,
  `geo_lat` double DEFAULT NULL,
  `geo_long` double DEFAULT NULL,
  `mapzoom` int(11) DEFAULT NULL,
  `disk_usage` int(11) DEFAULT NULL,
  `disk_usage_last_updated` datetime DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  `preview_attempts` int(11) DEFAULT NULL,
  `field12` varchar(200) DEFAULT NULL,
  `field8` varchar(200) DEFAULT NULL,
  `field3` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`ref`),
  KEY `hit_count` (`hit_count`),
  KEY `resource_archive` (`archive`),
  KEY `resource_access` (`access`),
  KEY `resource_type` (`resource_type`),
  KEY `resource_creation_date` (`creation_date`),
  KEY `rating` (`rating`),
  KEY `colour_key` (`colour_key`),
  KEY `has_image` (`has_image`),
  KEY `file_checksum` (`file_checksum`),
  KEY `geo_lat` (`geo_lat`),
  KEY `geo_long` (`geo_long`),
  KEY `disk_usage` (`disk_usage`),
  KEY `created_by` (`created_by`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource`
--

INSERT INTO `resource` VALUES (-1,NULL,2,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,1,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2014-02-11 17:47','Clinical Care Benches',NULL),(1,NULL,1,1,0,0,5,'2014-02-11 11:36:42',NULL,NULL,NULL,NULL,NULL,'jpg','jpg',1,543,1000,150,56,3,0,'WBECN',1,NULL,'2014-02-11 11:36:43','',0,0,'0|1',NULL,NULL,NULL,98304,'2014-02-11 11:36:43',57344,0,'2014-02-11 16:36','Test',NULL),(2,NULL,1,1,0,0,3,'2014-02-11 11:38:41',NULL,NULL,NULL,NULL,NULL,'jpg','jpg',1,543,1000,150,56,3,0,'WBECN',1,NULL,'2014-02-11 11:38:41','',0,0,'0|1',NULL,NULL,NULL,98304,'2014-02-11 11:38:41',57344,0,'2014-02-11 16:36','Test',NULL),(3,NULL,2,1,0,0,35,'2014-02-11 12:48:51',NULL,NULL,NULL,NULL,NULL,'pdf','jpg',66,814,934,150,51,0,3,'WCBNE',1,NULL,'2014-02-11 12:49:13','',0,0,'0|1',NULL,NULL,NULL,2113536,'2014-02-11 12:49:13',520192,0,'2014-02-11 17:47','Clinical Care Benches',NULL),(-3,NULL,1,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,3,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `resource_alt_files`
--

CREATE TABLE `resource_alt_files` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `resource` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `file_name` varchar(200) DEFAULT NULL,
  `file_extension` varchar(10) DEFAULT NULL,
  `file_size` int(11) DEFAULT '0',
  `creation_date` datetime DEFAULT NULL,
  `unoconv` int(11) DEFAULT NULL,
  `alt_type` varchar(100) DEFAULT NULL,
  `page_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_alt_files`
--


--
-- Table structure for table `resource_custom_access`
--

CREATE TABLE `resource_custom_access` (
  `resource` int(11) DEFAULT NULL,
  `usergroup` int(11) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `access` int(11) DEFAULT NULL,
  `user_expires` date DEFAULT NULL,
  KEY `resource` (`resource`),
  KEY `usergroup` (`usergroup`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_custom_access`
--

INSERT INTO `resource_custom_access` VALUES (3,6,NULL,0,NULL),(3,5,NULL,0,NULL),(3,8,NULL,0,NULL),(3,7,NULL,0,NULL),(3,2,NULL,0,NULL),(3,9,NULL,0,NULL),(3,3,NULL,0,NULL),(3,4,NULL,0,NULL),(3,1,NULL,0,NULL);

--
-- Table structure for table `resource_data`
--

CREATE TABLE `resource_data` (
  `resource` int(11) DEFAULT NULL,
  `resource_type_field` int(11) DEFAULT NULL,
  `value` mediumtext,
  KEY `resource` (`resource`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_data`
--

INSERT INTO `resource_data` VALUES (-1,73,','),(-1,12,'2014-02-11 17:47'),(-1,8,'Clinical Care Benches'),(1,73,','),(1,12,'2014-02-11 16:36'),(1,54,','),(1,8,'Test'),(1,51,'mena_01.jpg'),(2,73,','),(2,12,'2014-02-11 16:36'),(2,54,','),(2,8,'Test'),(2,51,'mena_01.jpg'),(-1,1,'Clinical Care Benches'),(-1,18,'PDF test file'),(3,12,'2014-02-11 17:47'),(3,8,'Clinical Care Benches'),(3,1,'Clinical Care Benches'),(3,18,'PDF test file'),(3,51,'CPP-4809 S_OD_PCS_50_50_Clinical Care benches_Final.pdf'),(3,73,',');

--
-- Table structure for table `resource_dimensions`
--

CREATE TABLE `resource_dimensions` (
  `resource` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT '0',
  `height` int(11) DEFAULT '0',
  `file_size` int(11) DEFAULT '0',
  `resolution` int(11) DEFAULT '0',
  `unit` varchar(11) DEFAULT '0',
  `page_count` int(11) DEFAULT NULL,
  KEY `resource` (`resource`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_dimensions`
--

INSERT INTO `resource_dimensions` VALUES (2,800,300,57344,0,'0',NULL),(1,800,300,57344,0,'0',NULL),(3,0,0,520192,0,'0',NULL);

--
-- Table structure for table `resource_keyword`
--

CREATE TABLE `resource_keyword` (
  `resource` int(11) DEFAULT NULL,
  `keyword` int(11) DEFAULT NULL,
  `hit_count` int(11) DEFAULT '0',
  `position` int(11) DEFAULT '0',
  `resource_type_field` int(11) DEFAULT '0',
  `new_hit_count` int(11) DEFAULT '0',
  KEY `resource_keyword` (`resource`,`keyword`),
  KEY `resource` (`resource`),
  KEY `keyword` (`keyword`),
  KEY `resource_type_field` (`resource_type_field`),
  KEY `rk_all` (`resource`,`keyword`,`resource_type_field`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_keyword`
--

INSERT INTO `resource_keyword` VALUES (-1,32,0,2,12,0),(-1,23,0,1,12,0),(-1,22,0,0,12,0),(-1,8,0,0,-1,0),(-1,33,0,0,8,0),(1,23,0,1,12,0),(1,22,0,0,12,0),(1,2,0,0,8,0),(1,28,0,2,12,0),(1,8,0,0,-1,0),(1,29,0,0,51,0),(1,30,0,1,51,0),(1,31,0,2,51,0),(2,23,0,1,12,0),(2,22,0,0,12,0),(2,2,0,0,8,0),(2,28,0,2,12,0),(2,1,0,0,-1,0),(2,29,0,0,51,0),(2,30,0,1,51,0),(2,31,0,2,51,0),(-1,34,0,1,8,0),(-1,35,0,2,8,0),(-1,33,0,0,1,0),(-1,34,0,1,1,0),(-1,35,0,2,1,0),(-1,36,0,0,18,0),(-1,2,0,1,18,0),(-1,37,0,2,18,0),(3,35,0,2,8,0),(3,34,0,1,8,0),(3,33,0,0,8,0),(3,33,0,0,1,0),(3,34,0,1,1,0),(3,35,0,2,1,0),(3,36,0,0,18,0),(3,2,0,1,18,0),(3,37,0,2,18,0),(3,22,0,0,12,0),(3,23,0,1,12,0),(3,32,0,2,12,0),(3,10,0,0,-1,0),(3,38,0,0,51,0),(3,39,0,1,51,0),(3,40,0,2,51,0),(3,41,0,3,51,0),(3,42,0,4,51,0),(3,43,0,5,51,0),(3,43,0,6,51,0),(3,33,0,7,51,0),(3,34,0,8,51,0),(3,35,0,9,51,0),(3,44,0,10,51,0),(3,36,0,11,51,0);

--
-- Table structure for table `resource_log`
--

CREATE TABLE `resource_log` (
  `date` datetime DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `resource` int(11) DEFAULT NULL,
  `type` char(1) DEFAULT NULL,
  `resource_type_field` int(11) DEFAULT NULL,
  `notes` text,
  `diff` text,
  `usageoption` int(11) DEFAULT NULL,
  `purchase_size` varchar(10) DEFAULT NULL,
  `purchase_price` decimal(10,2) DEFAULT '0.00',
  `access_key` char(50) DEFAULT NULL,
  KEY `resource` (`resource`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_log`
--

INSERT INTO `resource_log` VALUES ('2013-07-29 22:37:46',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2013-07-29 22:46:17',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2013-07-30 21:38:13',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2013-07-30 21:46:41',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2013-07-31 13:55:41',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2013-07-31 14:01:25',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2013-07-31 15:36:16',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2013-07-31 15:36:55',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-01-13 15:19:33',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-04 15:15:41',2,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-04 15:33:47',3,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-05 11:21:08',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-05 11:22:58',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-10 14:48:23',2,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 11:36:43',1,1,'c',NULL,'','',-1,'',0.00,NULL),('2014-02-11 11:36:43',1,1,'u',NULL,'','',-1,'',0.00,NULL),('2014-02-11 11:38:41',1,2,'c',NULL,'','',-1,'',0.00,NULL),('2014-02-11 11:38:41',1,2,'u',NULL,'','',-1,'',0.00,NULL),('2014-02-11 11:39:03',1,2,'d',NULL,'','',-1,'',0.00,''),('2014-02-11 11:44:56',1,1,'E',NULL,'javi@backroompr.com','',-1,'',0.00,NULL),('2014-02-11 12:48:51',1,3,'c',NULL,'','',-1,'',0.00,NULL),('2014-02-11 12:48:51',1,3,'u',NULL,'','',-1,'',0.00,NULL),('2014-02-11 12:59:10',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 13:00:05',3,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 13:01:25',1,3,'e',73,'','+ client1',-1,'',0.00,NULL),('2014-02-11 13:02:11',1,3,'a',NULL,'','Open -> Custom',-1,'',0.00,NULL),('2014-02-11 13:02:39',3,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 13:04:06',3,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 13:04:43',1,3,'e',73,'','- client1',-1,'',0.00,NULL),('2014-02-11 13:05:49',3,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 13:06:30',2,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 13:08:14',3,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 13:10:13',3,2,'x',NULL,'','',-1,'',0.00,NULL),('2014-02-11 13:10:25',3,1,'x',NULL,'','',-1,'',0.00,NULL),('2014-02-11 13:11:17',3,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 13:15:51',1,3,'E',NULL,'dtimiraos@vsbrooks.com','',-1,'',0.00,NULL),('2014-02-11 13:15:52',1,3,'E',NULL,'javi@backroompr.com','',-1,'',0.00,NULL),('2014-02-11 14:46:40',NULL,3,'d',NULL,'','',-1,'',0.00,'cc7f4f2dee'),('2014-02-11 14:53:37',NULL,3,'d',NULL,'','',-1,'',0.00,'cc7f4f2dee'),('2014-02-11 14:53:56',NULL,3,'d',NULL,'','',-1,'',0.00,'cc7f4f2dee'),('2014-02-11 14:54:12',NULL,3,'d',NULL,'','',-1,'',0.00,'cc7f4f2dee'),('2014-02-11 14:58:12',NULL,3,'d',NULL,'','',-1,'',0.00,'cc7f4f2dee'),('2014-02-11 16:39:13',2,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 16:50:22',1,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 16:58:03',4,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-11 16:59:29',4,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-12 10:52:16',2,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-25 11:33:42',2,0,'l',NULL,NULL,NULL,NULL,NULL,0.00,NULL),('2014-02-25 11:33:54',NULL,3,'d',NULL,'','',-1,'',0.00,'cc7f4f2dee');

--
-- Table structure for table `resource_related`
--

CREATE TABLE `resource_related` (
  `resource` int(11) DEFAULT NULL,
  `related` int(11) DEFAULT NULL,
  KEY `resource_related` (`resource`),
  KEY `related` (`related`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_related`
--


--
-- Table structure for table `resource_type`
--

CREATE TABLE `resource_type` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `allowed_extensions` text,
  `order_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_type`
--

INSERT INTO `resource_type` VALUES (1,'Photo',NULL,30),(2,'Document',NULL,40),(3,'Video',NULL,50),(4,'Audio',NULL,60),(5,'client',NULL,70);

--
-- Table structure for table `resource_type_field`
--

CREATE TABLE `resource_type_field` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `title` varchar(400) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `options` text,
  `order_by` int(11) DEFAULT '0',
  `keywords_index` int(11) DEFAULT '0',
  `partial_index` int(11) DEFAULT '0',
  `resource_type` int(11) DEFAULT '0',
  `resource_column` varchar(50) DEFAULT NULL,
  `display_field` int(11) DEFAULT '1',
  `use_for_similar` int(11) DEFAULT '1',
  `iptc_equiv` varchar(20) DEFAULT NULL,
  `display_template` text,
  `tab_name` varchar(50) DEFAULT NULL,
  `required` int(11) DEFAULT '0',
  `smart_theme_name` varchar(200) DEFAULT NULL,
  `exiftool_field` varchar(200) DEFAULT NULL,
  `advanced_search` int(11) DEFAULT '1',
  `simple_search` int(11) DEFAULT '0',
  `help_text` text,
  `display_as_dropdown` int(11) DEFAULT '0',
  `external_user_access` int(11) DEFAULT '1',
  `autocomplete_macro` text,
  `hide_when_uploading` int(11) DEFAULT '0',
  `hide_when_restricted` int(11) DEFAULT '0',
  `value_filter` text,
  `exiftool_filter` text,
  `omit_when_copying` int(11) DEFAULT '0',
  `tooltip_text` text,
  `regexp_filter` varchar(400) DEFAULT NULL,
  `sync_field` int(11) DEFAULT NULL,
  `display_condition` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`ref`),
  KEY `resource_type` (`resource_type`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_type_field`
--

INSERT INTO `resource_type_field` VALUES (1,'keywords','Keywords',1,NULL,30,1,0,0,NULL,1,1,'2#025',NULL,NULL,0,NULL,'Keywords,Subject',1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'country','Country',9,'Afghanistan, Aland Islands, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antarctica, Antigua And Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia And Herzegovina, Botswana, Bouvet Island, Brazil, British Indian Ocean Territory, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Cayman Islands, Central African Republic, Chad, Chile, China, Christmas Island, Cocos (Keeling) Islands, Colombia, Comoros, Congo, Congo - The Democratic Republic Of The, Cook Islands, Costa Rica, Côte D\'ivoire, Croatia, Cuba, Cyprus, Czech Republic, Denmark, Djibouti, Dominica, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Falkland Islands (Malvinas), Faroe Islands, Fiji, Finland, France, French Guiana, French Polynesia, French Southern Territories, Gabon, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guadeloupe, Guam, Guatemala, Guernsey, Guinea, Guinea-Bissau, Guyana, Haiti, Heard Island And Mcdonald Islands, Holy See (Vatican City State), Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iran - Islamic Republic Of, Iraq, Ireland, Isle Of Man, Israel, Italy, Jamaica, Japan, Jersey, Jordan, Kazakhstan, Kenya, Kiribati, Korea - Democratic People\'s Republic Of, Korea - Republic Of, Kuwait, Kyrgyzstan, Lao People\'s Democratic Republic, Latvia, Lebanon, Lesotho, Liberia, Libyan Arab Jamahiriya, Liechtenstein, Lithuania, Luxembourg, Macao, Macedonia - The Former Yugoslav Republic Of, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Martinique, Mauritania, Mauritius, Mayotte, Mexico, Micronesia - Federated States Of, Moldova - Republic Of, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Myanmar, Namibia, Nauru, Nepal, Netherlands, Netherlands Antilles, New Caledonia, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norfolk Island, Northern Mariana Islands, Norway, Oman, Pakistan, Palau, Palestinian Territory - Occupied, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Pitcairn, Poland, Portugal, Puerto Rico, Qatar, Réunion, Romania, Russian Federation, Rwanda, Saint Barthélemy, Saint Helena, Saint Kitts And Nevis, Saint Lucia, Saint Martin, Saint Pierre And Miquelon, Saint Vincent And The Grenadines, Samoa, San Marino, Sao Tome And Principe, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, South Georgia And The South Sandwich Islands, Spain, Sri Lanka, Sudan, Suriname, Svalbard And Jan Mayen, Swaziland, Sweden, Switzerland, Syrian Arab Republic, Taiwan - Province Of China, Tajikistan, Tanzania - United Republic Of, Thailand, Timor-Leste, Togo, Tokelau, Tonga, Trinidad And Tobago, Tunisia, Turkey, Turkmenistan, Turks And Caicos Islands, Tuvalu, Uganda, Ukraine, United Arab Emirates, United Kingdom, United States, United States Minor Outlying Islands, Uruguay, Uzbekistan, Vanuatu, Venezuela - Bolivarian Republic Of, Viet Nam, Virgin Islands - British, Virgin Islands - U.S., Wallis And Futuna, Western Sahara, Yemen, Zambia, Zimbabwe',60,1,0,0,'country',1,1,'2#101',NULL,NULL,0,NULL,'category,country',1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'title','Title',0,NULL,10,1,0,0,'title',0,1,'2#005',NULL,NULL,1,NULL,'Title',1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'extract','Document extract',1,NULL,7,0,0,2,NULL,1,0,NULL,'<div class=\"RecordStory\">\n\n  <h1>[title]</h1>\n\n  <p>[value]</p>\n\n</div>',NULL,0,NULL,NULL,1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'credit','Credit',0,NULL,90,1,0,0,NULL,1,1,'2#080',NULL,NULL,0,NULL,'Source,Creator,Credit,By-line',1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'date','Date',4,NULL,80,1,0,0,'creation_date',1,1,'2#055',NULL,NULL,0,NULL,'DateTimeOriginal',0,0,NULL,0,1,NULL,0,0,'if ($value!=\'\'){$value=nicedate($value,false);}',NULL,NULL,NULL,NULL,NULL,NULL),(18,'caption','Caption',1,NULL,40,1,0,0,NULL,1,0,'2#120','<div class=\"item\"><h3>[title]</h3><p>[value]</p></div>\n\n<div class=\"clearerleft\"> </div>',NULL,0,NULL,'Caption-Abstract,Description,ImageDescription',1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,NULL,'Notes',1,NULL,110,0,0,0,NULL,1,0,'2#103','<div class=\"RecordStory\">\n\n  <h1>[title]</h1>\n\n  <p>[value]</p>\n\n</div>',NULL,0,NULL,'JobID',1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'person','Named person(s)',0,NULL,70,1,0,0,NULL,1,1,NULL,NULL,NULL,0,NULL,'People',1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'camera','Camera make / model',0,NULL,1600,0,0,1,NULL,1,0,NULL,NULL,NULL,0,NULL,'Model',1,0,NULL,0,1,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'originalfilename','Original filename',0,NULL,20,1,0,0,'file_path',0,1,NULL,NULL,NULL,0,NULL,NULL,1,0,NULL,0,1,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'source','Source',3,',Digital Camera, Scanned Negative, Scanned Photo',1601,0,0,1,NULL,1,1,NULL,NULL,NULL,0,NULL,NULL,1,0,NULL,0,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'text','Extracted text',5,NULL,50,1,0,0,NULL,0,0,NULL,'<div class=\"item\"><h3>[title]</h3><p>[value]</p></div><div class=\"clearerleft\"> </div>',NULL,0,NULL,NULL,1,0,NULL,0,1,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'client','client',3,',client1,client2',0,1,0,0,NULL,1,1,NULL,NULL,NULL,0,NULL,NULL,1,0,NULL,0,1,NULL,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `site_text`
--

CREATE TABLE `site_text` (
  `page` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `text` text,
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `language` varchar(10) DEFAULT NULL,
  `ignore_me` int(11) DEFAULT NULL,
  `specific_to_group` int(11) DEFAULT NULL,
  `custom` int(11) DEFAULT NULL,
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM AUTO_INCREMENT=100125 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `site_text`
--

INSERT INTO `site_text` VALUES ('collection_public','introtext','Public collections are created by other users.',1,'en',NULL,NULL,NULL),('all','searchpanel','Search using descriptions, keywords and resource numbers',2,'en',NULL,NULL,NULL),('home','themes','The very best resources, hand picked and grouped.',3,'en',NULL,NULL,NULL),('home','mycollections','Organise, collaborate & share your resources. Use these tools to help you work more effectively.',4,'en',NULL,NULL,NULL),('home','help','Help and advice to get the most out of ResourceSpace.',5,'en',NULL,NULL,NULL),('home','welcometitle','Welcome to ResourceSpace',6,'en',NULL,NULL,NULL),('home','welcometext','Your introductory text here.',7,'en',NULL,NULL,NULL),('themes','introtext','Themes are groups of resources that have been selected by the administrators to provide an example of the resources available in the system.',8,'en',NULL,NULL,NULL),('edit','multiple','Please select which fields you wish to overwrite. Fields you do not select will be left untouched.',9,'en',NULL,NULL,NULL),('team_archive','introtext','To edit individual archive resources, simply search for the resource, and click edit in the ‘Resource Tool’ panel on the resource screen. All resources that are ready to be archived are listed Resources Pending list. From this list it is possible to add further information and transfer the resource record into the archive. ',10,'en',NULL,NULL,NULL),('research_request','introtext','Our professional researchers are here to assist you in finding the very best resources for your projects. Complete this form as thoroughly as possible so we’re able to meet your criteria accurately. <br><br>A member of the research team will be assigned to your request. We’ll keep in contact via email throughout the process, and once we’ve completed the research you’ll receive an email with a link to all the resources that we recommend.  ',11,'en',NULL,NULL,NULL),('collection_manage','introtext','Organise and manage your work by grouping resources together. Create ‘Collections’ to suit your way of working. You may want to group resources under projects that you are working on independently, share resources amongst a project team or simply keep your favourite resources together in one place. All the collections in your list appear in the ‘My Collections’ panel at the bottom of the screen.',12,'en',NULL,NULL,NULL),('collection_manage','findpublic','Public collections are groups of resources made widely available by users of the system. Enter a collection ID, or all or part of a collection name or username to find public collections. Add them to your list of collections to access the resources.',13,'en',NULL,NULL,NULL),('team_home','introtext','Welcome to the team centre. Use the links below to administer resources, respond to resource requests, manage themes and alter system settings.',14,'en',NULL,NULL,NULL),('help','introtext','Get the most out of ResourceSpace. These guides will help you use the system and the resources more effectively. </p>\n\n\n\n<p>Use \"Themes\" to browse resources by theme or use the simple search box to search for specific resources.</p>\n\n\n<p><a href=\"http://www.montala.net/downloads/resourcespace-GettingStarted.pdf\">Download the user guide (PDF file)</a>\n\n\n<p><a target=\"_blank\" href=\"http://wiki.resourcespace.org/index.php/Main_Page\">Online Documentation (Wiki)</a>',15,'en',NULL,NULL,NULL),('terms and conditions','terms and conditions','Your terms and conditions go here.',16,'en',NULL,NULL,NULL),('contribute','introtext','You can contribute your own resources. When you initially create a resource it is in the \"Pending Submission\" status. When you have uploaded your file and edited the fields, set the status field to \"Pending Review\". It will then be reviewed by the resources team.',17,'en',NULL,NULL,NULL),('done','user_password','An e-mail containing your username and password has been sent.',18,'en',NULL,NULL,NULL),('user_password','introtext','Enter your e-mail address and your username and password will be sent to you.',19,'en',NULL,NULL,NULL),('edit','batch',NULL,20,'en',NULL,NULL,NULL),('team_copy','introtext','Enter the ID of the resource you would like to copy. Only the resource data will be copied - any uploaded file will not be copied.',21,'en',NULL,NULL,NULL),('delete','introtext','Please enter your password to confirm that you would like to delete this resource.',22,'en',NULL,NULL,NULL),('team_report','introtext','Please choose a report and a date range. The report can be opened in Microsoft Excel or similar spreadsheet application.',23,'en',NULL,NULL,NULL),('terms','introtext','Before you proceed you must accept the terms and conditions.\n\n',24,'en',NULL,NULL,NULL),('download_progress','introtext','Your download will start shortly. When your download completes, use the links below to continue.',25,'en',NULL,NULL,NULL),('view','storyextract','Story extract:',26,'en',NULL,NULL,NULL),('contact','contact','Your contact details here.',27,'en',NULL,NULL,NULL),('search_advanced','introtext','<strong>Search Tip</strong><br>Any section that you leave blank, or unticked will include ALL those terms in the search. For example, if you leave all the country boxes empty, the search will return results from all those countries. If you select only ‘Africa’ then the results will ONLY contain resources from ‘Africa’. ',28,'en',NULL,NULL,NULL),('all','researchrequest','Let our resources team find the resources you need.',29,'en',NULL,NULL,NULL),('done','research_request','A member of the research team will be assigned to your request. We’ll keep in contact via email throughout the process, and once we’ve completed the research you’ll receive an email with a link to all the resources that we recommend.',30,'en',NULL,NULL,NULL),('done','collection_email','An email containing a link to the collection has been sent to the users you specified. The collection has been added to their \'Collections\' list.',31,'en',NULL,NULL,NULL),('done','resource_email','An email containing a link to the resource has been sent to the users you specified.',32,'en',NULL,NULL,NULL),('themes','manage','Organise and edit the themes available online. Themes are specially promoted collections. <br><br> <strong>1 To create a new entry under a Theme -  build a collection</strong><br> Choose <strong>My Collections</strong> from the main top menu and set up a brand new <strong>public</strong> collection. Remember to include a theme name during the setup. Use an existing theme name to group the collection under a current theme (make sure you type it exactly the same), or choose a new title to create a brand new theme. Never allow users to add/remove resources from themed collections. <br> <br><strong>2 To edit the content of an existing entry under a theme </strong><br> Choose <strong>edit collection</strong>. The items in that collection will appear in the <strong>My Collections</strong> panel at the bottom of the screen. Use the standard tools to edit, remove or add resources. <br> <br><strong>3 To alter a theme name or move a collection to appear under a different theme</strong><br> Choose <strong>edit properties</strong> and edit theme category or collection name. Use an existing theme name to group the collection under an current theme (make sure you type it exactly the same), or choose a new title to create a brand new theme. <br> <br><strong>4 To remove a collection from a theme </strong><br> Choose <strong>edit properties</strong> and delete the words in the theme category box. ',33,'en',NULL,NULL,NULL),('terms','terms','Your terms and conditions go here.',34,'en',NULL,NULL,NULL),('done','resource_request','Your request has been submitted and we will be in contact shortly.',35,'en',NULL,NULL,NULL),('user_request','introtext','Please complete the form below to request a user account.',36,'en',NULL,NULL,NULL),('themes','findpublic','Public collections are collections of resources that have been shared by other users.',37,'en',NULL,NULL,NULL),('done','user_request','Your request for a user account has been sent. Your login details will be sent to you shortly.',38,'en',NULL,NULL,NULL),('about','about','Your about text goes here.',39,'en',NULL,NULL,NULL),('team_content','introtext',NULL,40,'en',NULL,NULL,NULL),('done','deleted','The resource has been deleted.',41,'en',NULL,NULL,NULL),('upload','introtext',NULL,42,'en',NULL,NULL,NULL),('home','restrictedtitle','<h1>Welcome to ResourceSpace</h1>',43,'en',NULL,NULL,NULL),('home','restrictedtext','Please click on the link that you were e-mailed to access the resources selected for you.',44,'en',NULL,NULL,NULL),('resource_email','introtext','Quickly share this resource with other users by email. A link is automatically sent out. You can also include any message as part of the email.',45,'en',NULL,NULL,NULL),('team_resource','introtext','Add individual resources or batch upload resources. To edit individual resources, simply search for the resource, and click edit in the ‘Resource Tool’ panel on the resource screen.',46,'en',NULL,NULL,NULL),('team_user','introtext','Use this section to add, remove and modify users.',47,'en',NULL,NULL,NULL),('team_research','introtext','Organise and manage ‘Research Requests’. <br><br>Choose ‘edit research’ to review the request details and assign the research to a team member. It is possible to base a research request on a previous collection by entering the collection ID in the ‘edit’ screen. <br><br>Once the research request is assigned, choose ‘edit collection’ to add the research request to ‘My collection’ panel. Using the standard tools, it is then possible to add resources to the research. <br><br>Once the research is complete, choose ‘edit research’,  change the status to complete and an email is automatically  sent to the user who requested the research. The email contains a link to the research and it is also automatically added to their ‘My Collection’ panel.',48,'en',NULL,NULL,NULL),('collection_edit','introtext','Organise and manage your work by grouping resources together. Create ‘Collections’ to suit your way of working.\n\n<br>\n\nAll the collections in your list appear in the ‘My Collections’ panel at the bottom of the screen\n\n<br><br>\n\n<strong>Private Access</strong> allows only you and and selected users to see the collection. Ideal for grouping resources under projects that you are working on independently and share resources amongst a project team.\n\n<br><br>\n\n<strong>Public Access</strong> allows all users of the system to search and see the collection. Useful if you wish to share collections of resources that you think others would benefit from using.\n\n<br><br>\n\nYou can choose whether you allow other users (public or users you have added to your private collection) to add and remove resources or simply view them for reference.',49,'en',NULL,NULL,NULL),('team_stats','introtext','Charts are generated on demand based on live data. Tick the box to print all charts for your selected year.',50,'en',NULL,NULL,NULL),('resource_request','introtext','The resource you requested is not available online. The resource information is automatically included in the email but you can add additional comments if you wish.',51,'en',NULL,NULL,NULL),('team_batch','introtext',NULL,52,'en',NULL,NULL,NULL),('team_batch_upload','introtext',NULL,53,'en',NULL,NULL,NULL),('team_batch_select','introtext',NULL,54,'en',NULL,NULL,NULL),('download_click','introtext','To download the resource file, right click the link below and choose \"Save As...\". You will then be asked where you would like to save the file. To open the file in your browser simply click the link.',55,'en',NULL,NULL,NULL),('collection_manage','newcollection','To create a new collection, enter a short name.',56,'en',NULL,NULL,NULL),('collection_email','introtext','Please complete the form below. The recipients will receive an email containing links to the collections rather than file attachments so they can choose and download the appropriate resources.',57,'en',NULL,NULL,NULL),('all','footer','Powered by <a target=\"_blank\" href=\"http://www.resourcespace.org/\">ResourceSpace</a>: Open Source Digital Asset Management',58,'en',NULL,NULL,NULL),('change_language','introtext','Please select your language below.',59,'en',NULL,NULL,NULL),('all','searchpanel','Search using descriptions, keywords and resource numbers',60,'es',NULL,NULL,NULL),('all','footer','Accionado por el <a href=\"http://www.resourcespace.org/\">ResourceSpace</a>',61,'es',NULL,NULL,NULL),('all','researchrequest','Let our resources team find the resources you need.',62,'es',NULL,NULL,NULL),('delete','introtext',NULL,68,'es',NULL,NULL,NULL),('contribute','introtext','You can contribute your own resources. When you initially create a resource it is in the \"Pending Submission\" status. When you have uploaded your file and edited the fields, set the status field to \"Pending Review\". It will then be reviewed by the resources team.',69,'es',NULL,NULL,NULL),('done','deleted','The resource has been deleted.',70,'es',NULL,NULL,NULL),('user_preferences','introtext','Enter a new password below to change your password.',71,'en',NULL,NULL,NULL),('collection_manage','findpublic','Public collections are groups of resources made widely available by users of the system. Enter a collection ID, or all or part of a collection name or username to find public collections. Add them to your list of collections to access the resources.',72,'es',NULL,NULL,NULL),('themes','findpublic','Powered by <a href=\"http://www.resourcespace.org/\">ResourceSpace</a>',73,'es',NULL,NULL,NULL),('login','welcomelogin','Welcome to ResourceSpace, please log in...',74,'en',NULL,NULL,NULL),('all','footer','Desarrollado por <a href=\"http://www.resourcespace.org/\">ResourceSpace</a>',75,'es',NULL,NULL,NULL),('all','researchrequest','Pídenos fotografías, vídeos o testimonios.',76,'es',NULL,NULL,NULL),('contact','contact','Introduce aquí tus datos de contacto.',77,'es',NULL,NULL,NULL),('collection_manage','newcollection','Para crear una nueva colección, introduce un nombre.',78,'es',NULL,NULL,NULL),('delete','introtext','Por favor, introduce tu contraseña para confirmar que quieres borrar este contenido.',79,'es',NULL,NULL,NULL),('done','deleted','El contenido ha sido borrado.',80,'es',NULL,NULL,NULL),('done','research_request','Un miembro del equipo del SERGI se asignará a tu petición. Te mantendremos informado durante el proceso. Una vez tengamos los resultados de tu petición te enviaremos un correo electrónico con un enlace a los contenidos seleccionados.',81,'es',NULL,NULL,NULL),('all','searchpanel','Busca por descripciones, palabras clave y códigos de contenido.',82,'es',NULL,NULL,NULL),('about','about','Imágenes y Palabras pretende ser un lugar...',83,'es',NULL,NULL,NULL),('collection_edit','introtext','Organiza tu trabajo agrupando recursos. Crea tantas colecciones como necesites.\n\n<br>\n\nTodas la colecciones aparecerán en tu panel \"Mis colecciones\" en la parte inferior de la pantalla.\n\n<br><br>\n\n<strong>Acceso privado</strong> sólo permite a ti y a los usuarios que selecciones a visualizar la colección. <br><br>\n\n<strong>Accesos público</strong> permite a todos los usuarios de la aplicación a visualizar la colección.\n\n<br><br>\n\nTambién puedes elegir qué usuarios podrán modificar la colección o simplemente podrán visualizarla.',84,'es',NULL,NULL,NULL),('collection_email','introtext','Completa el formulario adjunto para enviar por mail esta colección. Recibirás un link con todo el material y podrás elegir lo que más se adapte a tus necesidades.',85,'es',NULL,NULL,NULL),('collection_manage','findpublic','Las colecciones públicas son grupos de material disponible para los usuarios del sistema. Para encontrarlas debes introducir un identificador. Éste puede ser el nombre completo o parcial de la colección que te interese o bien el ID de usuario de la misma. Añádelo a tu lista de colecciones para acceder al material.\n\n\n\n',86,'es',NULL,NULL,NULL),('home','restrictedtitle','<h1>Bienvenido al Panel de Control</h1>',87,'es',NULL,NULL,NULL),('home','themes','Aquí encontrarás los materiales recogidos recientemente.',88,'es',NULL,NULL,NULL),('home','welcometext',NULL,92,'es',NULL,NULL,NULL),('help','introtext','Obtén el máximo rendimiento del Espacio de Material. Estas guías te ayudarán a usar el sistema con mayor efectividad.',93,'es',NULL,NULL,NULL),('home','welcometitle','Bienvenida/o a Imágenes y Palabras, una herramienta que te permitirá buscar fotografías, vídeos y testimonios entre sus más de xxx materiales.',94,'es',NULL,NULL,NULL),('team_batch','introtext',NULL,95,'es',NULL,NULL,NULL),('team_home','introtext','Bienvenido al Panel de Control. Utiliza los enlaces siguientes para gestionar materiales, responder a peticiones de materiales, gestionar temas o modificar configuraciones del sistema.',96,'es',NULL,NULL,NULL),('user_password','introtext','Introduce tu dirección de e-mail y te enviaremos tu nombre de usuario y contraseña.',97,'es',NULL,NULL,NULL),('team_user','introtext','Utiliza esta sección para añadir, eliminar o modificar usuarios.',98,'es',NULL,NULL,NULL),('collection_public','introtext','Encuentra una colección pública',99,'es',NULL,NULL,NULL),('home','mycollections','Esta herramienta te permite seleccionar, organizar y compartir tu material. ',100,'es',NULL,NULL,NULL),('collection_manage','introtext','Organiza y controla tu trabajo agrupando material. Crea \"Colecciones\" que se ajusten a tus necesidades de trabajo. Podrías querer agrupar colecciones en proyectos con los que trabajas independientemente, compartirlas con un equipo o simplemente guardar tu material favorito en un sitio concreto. Todas estas opciones aparecerán en la pestaña \"Mis colecciones\" en un botón de tu pantalla.',101,'es',NULL,NULL,NULL),('done','collection_email','Los usuarios que quieras pueden recibir un correo con un enlace a la colección que les envíes. Esta recopilación se añade a su \"Lista de Colecciones\"',102,'es',NULL,NULL,NULL),('done','resource_request','Tu petición ha sido enviada y en breve nos pondremos en contacto contigo',103,'es',NULL,NULL,NULL),('done','user_password','Te hemos envíado un correo electrónico con tu ID de usuario y tu contraseña',104,'es',NULL,NULL,NULL),('done','user_request','Tu solicitud para obtener una cuenta de usuario ha sido enviada. Muy pronto te enviaremos los detalles.',105,'es',NULL,NULL,NULL),('download_click','introtext','Para bajar el archivo adjunto pincha en el enlace de abajo y elige \"Guardar como\". Te preguntarán dónde quieres guardar el archivo. Para abrir el archivo en tu navegador sólo tienes que pinchar el enlace.',106,'es',NULL,NULL,NULL),('download_progress','introtext','La descarga comenzará en pocos segundos',107,'es',NULL,NULL,NULL),('edit','batch',NULL,108,'es',NULL,NULL,NULL),('edit','multiple','Selecciona los campos que desees editar de la lista de abajo. Los que selecciones se sobreescribirán sobre el material que estés editando. Cualquier campo no selecciónado será ignorado.',109,'es',NULL,NULL,NULL),('home','help',NULL,110,'es',NULL,NULL,NULL),('home','restrictedtext','Por favor, pincha en el enlace que te envíamos a tu correo para acceder a los materiales seleccionados para ti',111,'es',NULL,NULL,NULL),('login','welcomelogin','Bienvenido a Palabras y Fotografías',112,'es',NULL,NULL,NULL),('research_request','introtext','Podemos ayudarte a encontrar el material que mejor se ajuste a tus necesidades. Completa el cuestionario tan minuciosamente como sea posible para que evaluemos los criterios que más te interesan. Estaremos en contacto por correo electrónico sobre la evolución del proceso y una vez hayamos completado la busqueda recibirás un mail con un enlace al material que te recomendamos',113,'es',NULL,NULL,NULL),('resource_email','introtext','Comparte este material rápidamente vía mail. Se enviará automáticamente un enlace. Además puedes incluir texto informativo como parte del correo electrónico.',114,'es',NULL,NULL,NULL),('resource_request','introtext','El material que has solicitado no esta disponible en Internet. La información que has requerido se incluirá automáticamente en el correo electrónico, si quieres puedes añadir cualquier comentario adicional.',115,'es',NULL,NULL,NULL),('search_advanced','introtext','Búsqueda por Campos. Cualquier sección que dejes en blanco o no selecciones, incluirá todos esos términos en la búsqueda. Por ejemplo, si dejas todas las opciones de un país vacías, la búsqueda te dará resultados de todos esos países. Si seleccionas sólo Ãfrica entonces los resultados sólo contendrán material de Ãfrica.\n\n',116,'es',NULL,NULL,NULL),('team_archive','introtext','Para editar materiales de archivo individualmente, simplemente busca por el material y pincha en \"Herramienta de Material\" en la misma pantalla. Todos los materiales listos para ser archivados serán listados en Material Pendiente de Lista. Desde esta lista es posible añadir información posteriormente y transferir el material grabado al archivo\n\n',117,'es',NULL,NULL,NULL),('view','storyextract','Estracto de historia:',118,'es',NULL,NULL,NULL),('user_request','introtext','Por favor completa el formulario adjunto para solicitar una cuenta de usuario.',119,'es',NULL,NULL,NULL),('team_research','introtext','Organiza y controla “Criterios de Búsquedaâ€. Elige “Editar búsquedaâ€ para examinar los detalles de la búsqueda y asignarle la investigación a un miembro del equipo. Es posible basar una búsqueda en una colección previa introduciendo el nombre de la misma en “Editâ€. Una vez sean asignados los criterios de búsqueda, selecciona “Editar Colecciónâ€ para añadir los criterios al panel “Mi colecciónâ€. Usando las herramientas estándar es posible añadir material a la búsqueda. Una vez se ha completado, selecciona “Editar búsquedaâ€ y cambia el estado para recibir automáticamente un correo electrónico con la información solicitada. El mail contendrá un enlace a la búsqueda y además se añadirá automáticamente al panel “Mi colecciónâ€.',120,'es',NULL,NULL,NULL),('team_batch_select','introtext',NULL,121,'es',NULL,NULL,NULL),('team_batch_upload','introtext',NULL,122,'es',NULL,NULL,NULL),('team_resource','introtext','Añade material individual o sube varios materiales simultáneamente. Para editar materiales individuales sólo tienes que buscar el material, y pinchar en editar en \"Herramienta de Material\" de la pantalla de material.',123,'es',NULL,NULL,NULL),('team_stats','introtext','Los gráficos son generados a bajo demanda. Marca la casilla para imprimir todos los gráficos del años seleccionado.',124,'es',NULL,NULL,NULL),('terms','introtext','Antes de iniciar el proceso de descarga debes aceptar los siguientes términos y condiciones de uso.\n\n',125,'es',NULL,NULL,NULL),('themes','findpublic','Encuentra una colección pública introduciendo un término de búsqueda',126,'es',NULL,NULL,NULL),('upload','introtext',NULL,127,'es',NULL,NULL,NULL),('themes','manage','Organiza y edita los temas disponibles en la red. Los temas aparecen organizados en colecciones. Para crear una nueva entrada e incluirla en un tema, debes pinchar en \"Construye una colección\" y elegir \"Mis Colecciones\" del menú principal. Recuerda incluir el nombre de un tema durante la configuración y crear una nueva colección. Puedes usar un nombre ya existente para agrupar la nueva colección en un apartado ya establecido (es importante asegurarse de que el nombre es exactamente el mismo) o elegir un nuevo título para crear una nueva categoría de temas. Nunca permitas a los usuarios que añadan o cambien materiales de las colecciones ya establecidas. Para editar el contenido de una entrada existente bajo un tema, elige “Editar una Colecciónâ€. Los iconos de esta colección aparecerán en el botón de la pantalla “Mis Coleccionesâ€. Emplea las herramientas estándar para editar, mover o añadir material. Para cambiar el  nombre de un tema o mover una colección y que ésta aparezca ubicada en un tema diferente. Elige: “Editar Propiedadesâ€ y edita la categoría del tema o el nombre de la colección. Selecciona un nombre existente para el tema y así agruparlo en de las categorías existentes (asegúrate de que lo escribes exactamente igual), o elige un nuevo título para crear un nuevo tipo de tema. Para borrar una selección del tema. Elige: “Editar Propiedadesâ€ y borra las palabras de la caja de categorías del tema.',128,'es',NULL,NULL,NULL),('themes','introtext','Los temas están formados por grupos con nuestros mejores materiales',129,'es',NULL,NULL,NULL),('team_copy','introtext','Introduce el identificador del material que te gustaría copiar. Sólo se copiará el material señalado -no se copiará ningún archivo adjunto.',130,'es',NULL,NULL,NULL),('change_language','introtext','Por favor, selecciona el idioma en el que deseas trabajar.',131,'es',NULL,NULL,NULL),('team_content','introtext',NULL,133,'es',NULL,NULL,NULL),('team_report','introtext','Por favor, elige un informe y un rango de fecha. El informe podrá abrirse en un documento de Excel o un documento de características similares.',134,'es',NULL,NULL,NULL),('change_password','introtext','Por favor introduzca una nueva contraseña.',135,'es',NULL,NULL,NULL),('upload_swf','introtext',NULL,136,'en',NULL,NULL,NULL),('tag','introtext','Help to improve search results by tagging resources. Say what you see, separated by spaces or commas... for example: dog, house, ball, birthday cake. Enter the full name of anyone visible in the photo and the location the photo was taken if known.',137,'en',NULL,NULL,NULL),('about','about','★サイトã®説明を記述ã—ã¦ãã ã•ã„★',138,'jp',NULL,NULL,NULL),('download_click','introtext','ファイルをダウンロードã™るã«ã¯ã€リンク上ã§å³クリックã—\"åå‰を付ã‘ã¦リンク先をä¿存\"をé¸択ã—ã¾ã™。 ファイルã®ä¿存先をèžã‹れã¾ã™。ファイルを開ãã«ã¯ブラウザã®ファイルを開ãã®リンクをクリックã—ã¾ã™。',139,'jp',NULL,NULL,NULL),('home','restrictedtitle','<h1>★サイトã®å称を記述ã—ã¦ãã ã•ã„★</h1>',140,'jp',NULL,NULL,NULL),('home','welcometitle','★ウェルカムメッセージã®タイトルを記述ã—ã¦ãã ã•ã„★',141,'jp',NULL,NULL,NULL),('home','welcometext','★ウェルカムメッセージを記述ã—ã¦ãã ã•ã„★',142,'jp',NULL,NULL,NULL),('all','researchrequest','ã‚ãªãŸãŒ求ã‚ã¦ã„る写真画åƒを調査ä¾頼ã—ã¦ã¿ã¦ãã ã•ã„。',143,'jp',NULL,NULL,NULL),('all','searchpanel','説明文ã€キーワードã€リソース・ナンãƒーを使ã£ã¦検索ã—ã¦ãã ã•ã„。',144,'jp',NULL,NULL,NULL),('change_language','introtext','下記ã‹ら言語をé¸択ã—ã¦ãã ã•ã„。',145,'jp',NULL,NULL,NULL),('change_password','introtext','ã‚ãªãŸã®パスワードを変更ã™るãŸã‚ã«以下ã«新ã—ã„パスワードを入力ã—ã¦ãã ã•ã„。',146,'jp',NULL,NULL,NULL),('collection_edit','introtext','リソースを分類ã™るã“ã¨ã«よã£ã¦ã€作å“を組織化ã—ã€管ç†ã—ã¦ãã ã•ã„。ã‚ãªãŸã®æµ儀ã§作å“ã«é©ã—ãŸコレクションを作æˆã—ã¦ãã ã•ã„。<br>画é¢ã®下部ã®マイコレクション・パãƒルã«一覧ãŒ表示ã•れã¾ã™。<br><br>ã‚ãªãŸã¨é¸ã°れãŸ人ã ã‘ãŒå‚照ã§ãる<strong>プライベート・アクセス</strong>ã®コレクションã§ã™。ã‚ãªãŸãŒå˜独ã‚るã„ã¯プロジェクトãƒーム間ã§リソースを共有ã—ã¦作業ã™る上ã§リソースã®グループ化ã«最é©ã§ã™。<br><br><strong>公開アクセス</strong>ã®コレクションã¯全ユーザãŒ検索ã¨å‚照ãŒã§ãã¾ã™。ã‚ãªãŸãŒリソースã®コレクションを共有ã™るã¨ã€他ã®人ã¯利益を得るã§ã—ょã†。<br><br>ã‚ãªãŸã¯ã€他ã®ユーザ(ã‚ãªãŸã®プライベート・コレクションを公開もã—ãã¯追加ã—ãŸユーザ)ã«リソースを追加ã€削除å¯能ã¨ã™るã‹ã€ã¾ãŸã¯å‚照ã®ã¿ã¨ã™るã‹をé¸択ã§ãã¾ã™。',147,'jp',NULL,NULL,NULL),('contact','contact','★ã“ã¡らã«ã¯ã‚ãªãŸã®連絡先を記入ã—ã¦ãã ã•ã„★',148,'jp',NULL,NULL,NULL),('search_advanced','introtext','<strong>検索ã®技</strong><br>検索ã§空白ã®ã¾ã¾ã«ã™るã‹ã€ã¾ãŸã¯ãƒェックを入れãªã‹ã£ãŸセクションã¯ã™ã¹ã¦ã®用語をå«んã もã®ã¨ã—ã¦検索ã—ã¾ã™。 例ãˆã°ã€国を空白ã«ã™るã¨ã€検索ã¯ã™ã¹ã¦ã®国ã‹らçµ果を返ã™ã§ã—ょã†。 ã‚ãªãŸãŒアフリカã ã‘をé¸択ã™るã¨ã€çµ果ã¯アフリカã‹らã®リソースã ã‘をå«むã§ã—ょã†。',149,'jp',NULL,NULL,NULL),('collection_email','introtext','以下ã®フォームã«記入ã—ã¦ã€ã“ã®コレクションをメールã—ã¦ãã ã•ã„。 ユーザãŒé©切ãªリソースをé¸んã§ã€ダウンロードã§ãるよã†ã«ã€ファイル添付よりむã—ã‚リソースã¸ã®リンクをå—ã‘å–るã§ã—ょã†。',150,'jp',NULL,NULL,NULL),('collection_manage','findpublic','公開ã®コレクションã¯システムã®ユーザã«よã£ã¦広ã利用å¯能ã«ã•れãŸリソースã®グループã§ã™。 コレクションIDã‹コレクションåã¾ãŸã¯ユーザåã®ã™ã¹ã¦ã¾ãŸã¯一部を入力ã—ã¦ã€公開ã®コレクションを見ã¤ã‘ã¦ãã ã•ã„。 ã‚ãªãŸã®コレクションã®リストã«ãれらを追加ã—ã¦ã€リソースã«アクセスã—ã¦ãã ã•ã„。',151,'jp',NULL,NULL,NULL),('collection_manage','introtext','リソースを分類ã™るã“ã¨ã«よã£ã¦ã€作å“を組織化ã—ã¦ã€管ç†ã—ã¦ãã ã•ã„。 ã‚ãªãŸã®やり方ã«åˆã£ãŸコレクションを作æˆã—ã¦ãã ã•ã„。 ã‚ãªãŸã¯ã€ã‚ãªãŸãŒå˜独ã§å–り組んã§ã„るプロジェクトã®下ã§リソースを分類ã—ãŸりã€プロジェクト・ãƒームã§リソースを共有ã—ãŸりã€ã¾ãŸã¯1ã¤ã®場所ã§å˜ã«ãŠ気ã«入りã®リソースをåŽ集ã™るã“ã¨ãŒã§ãã¾ã™。 ã‚ãªãŸã®ã™ã¹ã¦ã®コレクションãŒスクリーン下部ã®マイ・コレクションパãƒルã«表示ã•れã¾ã™。',152,'jp',NULL,NULL,NULL),('home','help','本サイトを最大é™ã«活用ã™るãŸã‚ã®ヘルプã¨助言。',153,'jp',NULL,NULL,NULL),('home','mycollections','リソースã®組織化ã€共åŒ化ã€共有化ã—ã¦ãã ã•ã„。 より効果的ã«åƒã‘るよã†ã«ã“れらã®ツールを活用ã—ã¦ãã ã•ã„。',154,'jp',NULL,NULL,NULL),('home','restrictedtext','ã‚ãªãŸã®ãŸã‚ã«é¸択ã•れãŸリソースã«アクセスã™るãŸã‚ã«メールã•れãŸリンクをクリックã—ã¦ãã ã•ã„。',155,'jp',NULL,NULL,NULL),('login','welcomelogin','★ウェルカムメッセージを記入ã—ã¦ãã ã•ã„★',156,'jp',NULL,NULL,NULL),('themes','findpublic','公開コレクションã¯他ã®ユーザã«よã£ã¦共有ã•れãŸリソースã®コレクションã§ã™。',157,'jp',NULL,NULL,NULL),('user_password','introtext','Eメールアドレスを入力ã—ã¦ãã ã•ã„。ãã†ã™れã°ã€ã‚ãªãŸã®ユーザåã¨パスワードãŒã‚ãªãŸã«é€信ã•れるã§ã—ょã†。',158,'jp',NULL,NULL,NULL),('user_request','introtext','以下ã®フォームã«記入ã—ã¦ã€ユーザアカウントをè¦求ã—ã¦ãã ã•ã„。',159,'jp',NULL,NULL,NULL),('view','storyextract','ストーリ抽出:',160,'jp',NULL,NULL,NULL),('collection_manage','newcollection','新è¦コレクションを作æˆã™るãŸã‚ã«短å称を入力ã—ã¦ãã ã•ã„。',161,'jp',NULL,NULL,NULL),('collection_public','introtext','他ã®ユーザã«よã£ã¦作æˆã•れãŸ公開コレクション。',162,'jp',NULL,NULL,NULL),('contribute','introtext','ã‚ãªãŸã¯ã‚ãªãŸ自身ã®リソースを投稿ã§ãã¾ã™。 ã‚ãªãŸãŒリソースを作æˆã—ãŸ直後ã¯登録待ã¡状態ã«ã‚りã¾ã™。 ã‚ãªãŸã®ファイルをアップロードã—ã¦ã€フィールドを編集後ã«ã¯レビュー待ã¡状態ã«設定ã•れã¾ã™。 次ã«リソースãƒームã«よã£ã¦レビューã•れるã§ã—ょã†。',163,'jp',NULL,NULL,NULL),('delete','introtext','ã“ã®リソースを削除ã™るã«ã¯パスワードを入力ã—ã¦ã€確èªã—ã¦ãã ã•ã„。',164,'jp',NULL,NULL,NULL),('done','collection_email','コレクションã¸ã®リンクをå«むメールをã‚ãªãŸãŒ指定ã—ãŸユーザã«é€りã¾ã—ãŸ。 コレクションã¯\'コレクション\'リストã«加ãˆられã¾ã™。',165,'jp',NULL,NULL,NULL),('done','deleted','リソースã¯削除ã•れã¾ã—ãŸ。',166,'jp',NULL,NULL,NULL),('done','research_request','調査ãƒームã®メンãƒーãŒã‚ãªãŸã®è¦求ã«アサインã•れるã§ã—ょã†。 メールã§ç§ãŸã¡ã¯途中経éŽをãŠ知らã›ã—ã¾ã™。ãã—ã¦ã€ç§ãŸã¡ãŒ調査を終了ã™るã¨ã€ã‚ãªãŸã¯ç§ãŸã¡ãŒ推薦ã™るã™ã¹ã¦ã®リソースã¸ã®リンクをメールã§å—ã‘å–りã¾ã™。',167,'jp',NULL,NULL,NULL),('done','resource_email','リソースã¸ã®リンクをå«むメールをã‚ãªãŸãŒ指定ã—ãŸユーザã«é€りã¾ã—ãŸ。',168,'jp',NULL,NULL,NULL),('done','resource_request','ã‚ãªãŸã®è¦求ã¯å—付ã—ã¾ã—ãŸã®ã§ã€ç§ãŸã¡ã¯ã¾もãªãã€連絡ã™るã§ã—ょã†。',169,'jp',NULL,NULL,NULL),('done','user_password','ã‚ãªãŸã®ユーザåã¨パスワードをå«むメールをé€りã¾ã—ãŸ。',170,'jp',NULL,NULL,NULL),('done','user_request','ユーザアカウントを求ã‚るã‚ãªãŸã®è¦求をé€りã¾ã—ãŸ。 ã¾もãªãã€ã‚ãªãŸã®ログイン詳細ãŒé€られるã§ã—ょã†。',171,'jp',NULL,NULL,NULL),('download_progress','introtext','ã‚ãªãŸã®ダウンロードã¯ã¾もãªãã€始ã¾るã§ã—ょã†。 ダウンロード完了後ã€継続ã™るã«ã¯以下ã®リンクを使用ã—ã¦ãã ã•ã„。',172,'jp',NULL,NULL,NULL),('edit','batch',NULL,173,'jp',NULL,NULL,NULL),('edit','multiple','ã©ã®フィールドを上書ãã—ãŸã„ã‹をé¸択ã—ã¦ãã ã•ã„。 ã‚ãªãŸãŒé¸択ã—ãªã„フィールドã¯ãã®ã¾ã¾ã®状態ã§ãŠã‹れるã§ã—ょã†。',174,'jp',NULL,NULL,NULL),('help','introtext','本サイトを最大é™ã«活用ã—ã¦ãã ã•ã„。 ã“れらã®ガイドã¯ã€ã‚ãªãŸãŒã€より効果的ã«システムã¨リソースを使用ã™るã®を助ã‘るã§ã—ょã†。 </p>    <p>テーマを使用ã—ã¦ã€テーマã§リソースをブラウズã™るã‹ã€ã¾ãŸã¯å˜純検索を使用ã—ã¦ã€特定ã®リソースを検索ã—ã¦ãã ã•ã„。</p>   <p><a href=http://www.montala.net/downloads/ResourceSpace-GettingStarted.pdf>Download the user guide (PDF file)</a>   <p><a target=_blank href=http://wiki.resourcespace.org/index.php/Main_Page>Online Documentation (Wiki)</a>',175,'jp',NULL,NULL,NULL),('home','themes','精é¸ã•れ分類ã•れãŸ最良ã®リソース',176,'jp',NULL,NULL,NULL),('research_request','introtext','ã‚ãªãŸã®プロジェクトã«ã€最も良ã„リソースを見ã¤ã‘るã®手助ã‘ã™るãŸã‚ã«ã€ç§ãŸã¡ã®プロã®調査者ãŒã“ã“ã«ã„ã¾ã™。 ç§ãŸã¡ãŒ正確ã«評価基準を満ãŸã™ã“ã¨ãŒã§ãるよã†ã«ã€ã“ã®フォームã«ã§ãるã ã‘全ã¦ã«記入ã—ã¦ãã ã•ã„。 <br><br>調査ãƒームã®メンãƒーãŒã‚ãªãŸã®è¦求ã«アサインã•れるã§ã—ょã†。 途中経éŽをメールã§報告ã—ã¾ã™ã€ãã—ã¦ã€ç§ãŸã¡ãŒ調査を完了ã—ãŸ後ã€ç§ãŸã¡ãŒ推薦ã™るã™ã¹ã¦ã®リソースã¸ã®リンクをメールã§å—ã‘å–ã£ã¦ãã ã•ã„。',177,'jp',NULL,NULL,NULL),('resource_email','introtext','メールã§素早ã他ã®ユーザã¨ã“ã®リソースを共有ã§ãã¾ã™。 自動的ã«リンクをé€信ã—ã¾ã™。 ã¾ãŸã€ã‚ãªãŸã¯メールã®一部ã¨ã—ã¦任æ„ã®メッセージも入れるã“ã¨ãŒã§ãã¾ã™。',178,'jp',NULL,NULL,NULL),('resource_request','introtext','ã”è¦望ã®リソースã¯オンラインã§利用å¯能ã§ã¯ã‚りã¾ã›ん。 リソース情報ã¯メールã«自動的ã«å«ã¾れã¦ã„ã¾ã™ãŒã€望むãªらã€ã‚ãªãŸã¯追加コメントを加ãˆるã“ã¨ãŒã§ãã¾ã™。',179,'jp',NULL,NULL,NULL),('tag','introtext','リソースã«タグ付ã‘をã™るã“ã¨ã«よã£ã¦検索çµ果を改善ã§ãã¾ã™。 例ãˆã°ã€空白ã‹コンマã«よã£ã¦分割ã•れãŸ: 犬,家,ボール,ãƒースデーケーキ。 写真ã«写ã£ã¦ã„る人ã®フルãƒームや分ã‹ã£ã¦ã„る地åを入れã¦ãã ã•ã„。',180,'jp',NULL,NULL,NULL),('team_archive','introtext','個々ã®アーカイブリソースを編集ã™るãŸã‚ã«ã€リソースをå˜純検索ã—ã¦ãã ã•ã„ã€ãã—ã¦ã€リソーススクリーンã®上ã®リソース・ツール パãƒルã®編集をクリックã—ã¦ãã ã•ã„。 アーカイブã•れる準備ãŒã§ãã¦ã„るリソースãŒ記載ã•れãŸリソース・ペンディング リストã§ã™。 ã“ã®リストã‹らã€アーカイブã«詳細情報ã®追加ã¨ã€リソース・レコードを移ã™ã®ã¯å¯能ã§ã™。',181,'jp',NULL,NULL,NULL),('team_batch','introtext',NULL,182,'jp',NULL,NULL,NULL),('team_batch_select','introtext',NULL,183,'jp',NULL,NULL,NULL),('team_batch_upload','introtext',NULL,184,'jp',NULL,NULL,NULL),('team_copy','introtext','ã‚ãªãŸãŒコピーã—ãŸã„リソースã®IDを入力ã—ã¦ãã ã•ã„。 リソースデータã ã‘ãŒコピーã•れるã§ã—ょã†--アップロードã•れãŸファイルã¯コピーã•れãªã„ã§ã—ょã†。',185,'jp',NULL,NULL,NULL),('team_home','introtext','ãƒームセンターã¸よã†ã“ã。 以下ã®リンクを使用ã—ã¦ã€リソースã®管ç†ã€リソースã®è¦求ã¸対応ã€テーマã®管ç†ã€システム設定ã®変更をã—ã¦ãã ã•ã„。',186,'jp',NULL,NULL,NULL),('team_report','introtext','レãƒートã¨日付ã®範囲をé¸んã§ãã ã•ã„。 Microsoft Excelã‹åŒ様ã®スプレッドシートアプリケーションã§レãƒートを開ãã“ã¨ãŒã§ãã¾ã™。',187,'jp',NULL,NULL,NULL),('team_research','introtext','調査è¦求ã®組織化ã¨管ç†。 <Br><Br>調査ã®編集をé¸んã§ã€è¦求ã®詳細をå†検討ã—ã¦ã€調査をãƒームメンãƒーã«割り当ã¦ã¦ãã ã•ã„。 編集画é¢ã«コレクションIDを入力ã™るã“ã¨ã«よã£ã¦調査è¦求を以å‰ã®コレクションã«基礎ã¥ã‘るã®ã¯å¯能ã§ã™。 <Br><Br>調査è¦求ãŒã„ã£ãŸん割り当ã¦られãŸ後ã€コレクション編集をé¸んã§ã€マイコレクションパãƒルã«調査è¦求を加ãˆã¦ãã ã•ã„。 標準ã®ツールを使用ã—ã¦ã€ãã—ã¦ã€リソースを調査ã«追加ã™るã®ã¯å¯能ã§ã™。 <Br><Br>調査ãŒã„ã£ãŸん完了ã™るã¨調査編集をé¸んã§ã€ステータスを完了ã«変ãˆã¦ãã ã•ã„。ãã†ã™れã°ã€自動的ã«調査をè¦求ã—ãŸユーザã«メールをé€りã¾ã™。 メールã¯調査ã¸ã®リンクをå«んã§ã„ã¾ã™ã€ãã—ã¦ã€ã¾ãŸã€ãれã¯自動的ã«彼らã®マイコレクションパãƒルã«加ãˆられã¾ã™。',188,'jp',NULL,NULL,NULL),('team_resource','introtext','個別ã«リソース追加ã‹リソースをãƒッãƒã§アップロードã—ã¦ãã ã•ã„。 個々ã®リソースを編集ã™るã«ã¯ã€å˜純検索ã§リソースを検索ã—ã¦ã€リソーススクリーン上ã®リソースツールパãƒルã®編集をクリックã—ã¾ã™ 。',189,'jp',NULL,NULL,NULL),('team_stats','introtext','ãƒャートã¯ライブデータã‹らè¦求ã«応ã˜ã¦作られã¾ã™。 é¸択ã•れãŸ年ã®ã™ã¹ã¦ã®ãƒャートをå°刷ã™るã«ã¯ãƒェックボックスをオンã«ã—ã¾ã™。',190,'jp',NULL,NULL,NULL),('team_user','introtext','ユーザã®追加ã€削除ã€変更をã™るã«ã¯ã“ã®セクションを使用ã—ã¦ãã ã•ã„。',191,'jp',NULL,NULL,NULL),('terms','introtext','先ã«進ã‚るãŸã‚ã«ã¯ã‚ãªãŸã¯æ¡件ã«åŒæ„ã—ãªã‘れã°ãªりã¾ã›ん。',192,'jp',NULL,NULL,NULL),('terms','terms','★使用æ¡件を記入ã—ã¦ãã ã•ã„★',193,'jp',NULL,NULL,NULL),('terms and conditions','terms and conditions','★使用æ¡件を記入ã—ã¦ãã ã•ã„★',194,'jp',NULL,NULL,NULL),('themes','introtext','テーマã¯リソースã®グループã§ã™。',195,'jp',NULL,NULL,NULL),('themes','manage','オンラインã§利用å¯能ãªテーマを組織化ã—ã€編集ã—ã¦ãã ã•ã„。 テーマã¯特ã«ã€推薦ã•れãŸコレクションã§ã™。 <br><br> <strong>1 テーマã®下ã«新è¦エントリー作æˆ -  コレクション構築</strong><br> メインã®トップメニューã‹ら<strong>マイコレクション</strong>をé¸択ã—ã€ 新è¦ã®<strong>公開</strong> コレクションを設定。 セットアップã®間ã€忘れãšã«テーマåをå«んã§ãã ã•ã„。 ç¾在ã®テーマã®下ã§コレクションを分類ã™るã®ã«既存ã®テーマåを使用ã™るã‹(全ãåŒ一)ã€ã¾ãŸã¯新ã—ã„タイトルをé¸んã§ã€真新ã—ã„テーマを作æˆã—ã¦ãã ã•ã„。 ユーザã«テーマ化ã•れãŸコレクションã‹らリソースを追加/削除ã•ã›ãªã„よã†ã«ã—ã¦ãã ã•ã„。<br> <br><strong>2 テーマã®下ã®既存ã®エントリーã®内容を編集</strong><br><strong>コレクション編集</strong>をé¸択。 コレクションã®アイテムã¯画é¢下部ã®<strong>マイコレクション</strong> パãƒルã«表示ã•れã¾ã™。リソースã®編集ã€削除ã€追加ã®ãŸã‚ã«標準ツールを使用。<br> <br><strong>3 テーマåã®変更や別ã®テーマã®下ã«表示ã•れるよã†コレクションを移動</strong><br><strong>プロパティ編集</strong>をé¸択ã—テーマカテゴリやコレクションåを編集。ç¾在ã®テーマã®下ã§コレクションを分類ã™るã®ã«既存ã®テーマåを使用ã™るã‹(全ãåŒ一)ã€ã¾ãŸã¯新ã—ã„タイトルをé¸んã§ã€真新ã—ã„テーマを作æˆã—ã¦ãã ã•ã„。 <br> <br><strong>4 テーマã‹らコレクション削除</strong><br><strong>プロパティ編集</strong>をé¸択ã—テーマカテゴリ欄ã®文字を削除。',196,'jp',NULL,NULL,NULL),('upload','introtext',NULL,197,'jp',NULL,NULL,NULL),('upload_swf','introtext',NULL,198,'jp',NULL,NULL,NULL),('collection_public','introtext','Les collections publiques sont créées par d\'autres utilisateurs',199,'fr',NULL,NULL,NULL),('all','searchpanel','Recherchez en utilisant les descriptions, mots clés et numéros de documents',200,'fr',NULL,NULL,NULL),('home','themes','Les meilleurs documents, sélectionnés et regroupés',201,'fr',NULL,NULL,NULL),('home','mycollections','Organisez et échangez vos documents. Ces outils vous aident à travailler plus efficacement.',202,'fr',NULL,NULL,NULL),('home','help','Aide et conseils pour obtenir le meilleur de ResourceSpace.',203,'fr',NULL,NULL,NULL),('home','welcometitle','Bienvenue dans ResourceSpace',204,'fr',NULL,NULL,NULL),('home','welcometext','Votre texte d\'introduction ici.',205,'fr',NULL,NULL,NULL),('themes','introtext','Les thèmes sont des groupes de ressources.',206,'fr',NULL,NULL,NULL),('edit','multiple','Veuillez choisir les champs que vous souhaitez écraser. Les champs non sélectionnés resteront inchangés.',207,'fr',NULL,NULL,NULL),('team_archive','introtext','Pour modifier un document archivé, recherchez simplement le document, et cliquez sur Modifier dans le panneau \'Outils de document\' sur l\'écran du document. Tous les documents qui sont prêts à être archivés sont listés dans la liste des documents en attente. Depuis cette liste, il est possible d\'ajouter des informations supplémentaires et d\'archiver le document.',208,'fr',NULL,NULL,NULL),('research_request','introtext','Nos professionnels sont là pour vous assister dans la recherche des meilleurs documents pour vos projets. Remplissez ce formulaire aussi précisément que possible pour que nous soyons capables de répondre précisément à votre requête. <br/><br/> Un membre de notre équipe de recherche sera assigné à votre requête. Nous garderons le contact via e-mail tout au long du processus. Et une fois la recherche terminée, vous recevrez par e-mail un lien vers tous les documents que nous recommandons.  ',209,'fr',NULL,NULL,NULL),('collection_manage','introtext','Organisez et gérez votre travail en groupant les documents. Créez des \'Collections\' selon votre méthode de travail. Vous pouvez grouper les documents par projet, les partager avec l\'équipe du projet, ou simplement conserver vos documents préférés en un seul endroit. Toutes vos collections sont listées dans le panneau \'Mes collections\' en bas de l\'écran.',210,'fr',NULL,NULL,NULL),('collection_manage','findpublic','Les collections publiques sont des groupes de documents rendus disponibles pour tous par d\'autres utilisateurs du système. Saisissez un numéro de collection, ou tout ou partie d\'un nom de collection ou d\'utilisateur pour trouver une collection publique. Ajoutez-les à votre liste de collections pour accéder à leur contenu.',211,'fr',NULL,NULL,NULL),('team_home','introtext','Bienvenue dans l\'espace équipe. Utilisez les liens ci-dessous pour administrer les documents, répondre aux requêtes de documents, gérer les thèmes et modifier les réglages du système.',212,'fr',NULL,NULL,NULL),('help','introtext','Obtenez le meilleur de ResourceSpace. Ces guides vous aideront à utiliser le système et les documents plus efficacement. </p>\n\n\n\n<p>Utilisez le menu \"Thèmes\" pour parcourir les ressources par thème ou utilisez la recherche simple pour trouver des ressources spécifiques.</p>\n\n\n<p><a href=\"http://www.montala.net/downloads/ResourceSpace-GettingStarted.pdf\">Téléchargez le guide utilisateur (fichier PDF) (anglais)</a>\n\n\n<p><a target=\"_blank\" href=\"http://wiki.resourcespace.org/index.php/Main_Page\">Documentation en ligne (Wiki) (anglais)</a>',213,'fr',NULL,NULL,NULL),('terms and conditions','terms and conditions','Placez ici vos termes et conditions.',214,'fr',NULL,NULL,NULL),('contribute','introtext','Vous pouvez proposer vos propres documents. Quand vous créez un nouveau document, son statut est \"En attente de soumission\". Quand vous avez déposé votre fichier et modifié les champs, affectez la valeur \"En attente de validation\" au champ statut. Votre document sera alors vérifié par l\'équipe ressources.',215,'fr',NULL,NULL,NULL),('done','user_password','Un mél contenant vos identifiant et mot de passe a été envoyé.',216,'fr',NULL,NULL,NULL),('user_password','introtext','Saisissez votre adresse électronique pour recevoir vos identifiant et mot de passe.',217,'fr',NULL,NULL,NULL),('edit','batch',NULL,218,'fr',NULL,NULL,NULL),('team_copy','introtext','Spécifiez le numéro du document que vous voulez copier. Seules les données du document seront copiées – aucun fichier ne sera copié.',219,'fr',NULL,NULL,NULL),('delete','introtext','Veuillez saisir votre mot de passe afin de confirmer la suppression de ce document.',220,'fr',NULL,NULL,NULL),('team_report','introtext','Veuillez choisir un type de rapport et une plage de dates. Le rapport peut être ouvert avec Microsoft Excel ou tout tableur similaire.',221,'fr',NULL,NULL,NULL),('terms','introtext','Avant de continuer, vous devez accepter les termes et conditions.',222,'fr',NULL,NULL,NULL),('download_progress','introtext','Votre téléchargement va démarrer rapidement. Quand le téléchargement sera terminé, utilisez les liens ci-dessous pour continuer.',223,'fr',NULL,NULL,NULL),('view','storyextract','Historique d\'extraction:',224,'fr',NULL,NULL,NULL),('contact','contact','Placez les détails pour vous contacter ici.',225,'fr',NULL,NULL,NULL),('search_advanced','introtext','<strong>Astuce de recherche</strong><br>Toute section que vous laissez vide ou décochée inclura TOUS les documents dans la recherche. Par exemple, si vous laissez vide le choix du pays, la recherche renverra des résultats de tous les pays. Si vous choisissez seulement \'Afrique\' alors les résultats contiendront SEULEMENT des documents de l\'\'Afrique\'.',226,'fr',NULL,NULL,NULL),('all','researchrequest','Laissez notre équipe documents trouver les documents dont vous avez besoin.',227,'fr',NULL,NULL,NULL),('done','research_request','Un membre de l\'équipe documents sera assigné à votre demande. Nous resterons en contact par mél au cours du processus, et une fois la recherche terminée, vous recevrez par mél un lien vers tous les documents que nous recommandons.',228,'fr',NULL,NULL,NULL),('done','collection_email','Un mél contenant un lien vers la collection a été envoyé aux utilisateurs spécifiés. La collection a été ajoutée à leur liste de \'Collections\'.',229,'fr',NULL,NULL,NULL),('done','resource_email','Un mél contenant un lien vers le document a été envoyé aux utilisateurs spécifiés.',230,'fr',NULL,NULL,NULL),('themes','manage','Organiser et gérer les thèmes disponibles. Les thèmes sont des collections particulièrement mises en avant.<br/><br/><strong>1. Pour créer une nouvelle entrée dans un thème – constuire une collection</strong><br/> Choisissez <strong>Mes collections</strong> depuis le menu principal et créez une nouvelle collection <strong>publique</strong>. Rapellez-vous d\'inclure un nom de thème durant la création de la collection. Utilisez un nom de thème existant pour grouper la collection dans un thème déjà présent (assurez-vous de le saisir à l\'identique), ou choisissez un nouveau nom pour créer un nouveau thème. N\'autorisez jamais vos utilisateurs à ajouter / retirer des documents de collections thématiques.<br/><br/><strong>2. Pour modifier le contenu d\'une collection thématique</strong><br/> Choisissez <strong>Modifier la collection</strong>. Les éléments dans cette collection apparaîtront dans le panneau <strong>Mes collections</strong> en bas de l\'écran. Utilisez les outils standard pour modifier, retirer ou ajouter des documents.<br/><br/><strong>3. Pour modifier un nom de thème ou déplacer une collection pour qu\'elle apparaisse dans un autre thème</strong><br/> Choisissez <strong>Modifier les propriétés</strong> et modifiez la catégorie du thème ou le nom de la collection. Utilisez un nom de thème existant pour grouper la collection dans un thème déjà présent (assurez-vous de le saisir à l\'identique), ou choisissez un nouveau nom pour créer un nouveau thème.<br/><br/><strong>4. Pour retirer une collection d\'un thème</strong><br/> Choisissez <strong>Modifier les propriétés</strong>et supprimez les mots dans le champ de catégorie du thème.',231,'fr',NULL,NULL,NULL),('terms','terms','Placez ici vos termes et conditions.',232,'fr',NULL,NULL,NULL),('done','resource_request','Votre requête a été soumise et vous serez contacté rapidement.',233,'fr',NULL,NULL,NULL),('user_request','introtext','Veuillez compléter le formulaire ci-dessous pour demander un compte utilisateur.',234,'fr',NULL,NULL,NULL),('themes','findpublic','Les collections publiques sont des collections de documents qui ont été partagées par d\'autres utilisateurs.',235,'fr',NULL,NULL,NULL),('done','user_request','Votre demande de compte utilisateur a été envoyée. Vos identifiant et mot de passe vous seront envoyés prochainement.',236,'fr',NULL,NULL,NULL),('about','about','Placez ici votre texte d\'à propos.',237,'fr',NULL,NULL,NULL),('team_content','introtext',NULL,238,'fr',NULL,NULL,NULL),('done','deleted','Le document a été supprimé.',239,'fr',NULL,NULL,NULL),('upload','introtext',NULL,240,'fr',NULL,NULL,NULL),('home','restrictedtitle','<h1>Bienvenue dans ResourceSpace</h1>',241,'fr',NULL,NULL,NULL),('home','restrictedtext','Veuillez cliquer sur le lien qui vous a été envoyé par mél pour accéder aux documents sélectionnés pour vous.',242,'fr',NULL,NULL,NULL),('resource_email','introtext','Partagez rapidement par mél ce document avec d\'autres utilisateurs. Un lien sera automatiquement envoyé. Vous pouvez aussi inclure un message dans le mél.',243,'fr',NULL,NULL,NULL),('team_resource','introtext','Ajoutez un document individuel ou un ensemble de documents. Pour modifier individuellement les documents, rechercher simplement le document et cliquez sur Modifier dans le panneau \'Outils de document\' sur l\'écran du document..',244,'fr',NULL,NULL,NULL),('team_user','introtext','Utilisez cette section pour ajouter, supprimer et modifier les utilisateurs.',245,'fr',NULL,NULL,NULL),('team_research','introtext','Organisez et gérer les \'requêtes de recherche\'. <br/><br/> Choisir \'Modifier la recherche\' pour vérifier les détails de la requête et assigner la recherche à un membre de l\'équipe. Il est possible de baser une requête de recherche sur une collection existante en saisissant le numéro de cette collection dans l\'écran de modification.<br/><br/> Une fois la requête assignée, choisissez \'Modifier la collection\' pour ajouter la requête de recherche au panneau \'Mes collections\'. En utilisant les outils standard, il est alors possible d\'ajouter des documents à la recherche. <br/><br/> Une fois que la recherche est terminée, choisissez \'Modifier la recherche\', changez le statut pour \'terminée\' ; un mél sera automatiquement envoyé à l\'utilisateur qui a demandé la recherche. Le mél contient un lien vers la recherche et la recherche est automatiquement ajoutée aux collections de l\'utilisateur.',246,'fr',NULL,NULL,NULL),('collection_edit','introtext','Organisez et gérez votre travail en groupant les documents. Créez des \'Collections\' pour correspondre à votre méthode de travail.<br/> Toutes vos collections apparaissent dans le panneau \'Mes Collections\' en bas de l\'écran <br/><br/> L\'<strong>accès privé</strong> vous autorise, vous et les utilisateurs sélectionnés, à voir la collection. Idéal pour grouper les documents par projet sur lesquels vous travaillez et partager les documetns avec les membres de l\'équipe. <br/><br/> L\'<strong>accès public</strong> autorise tous les utilisateurs du système à voir et rechercher dans la collection. C\'est utile si vous souhaitez partager des collections de documents que vous pensez bénéfiques pour d\'autres utilisateurs. <br/><br/> Vous pouvez choisir si vous souhaitez ou non autoriser d\'autres utilisateurs (tous, ou uniquement ceux que vous avez ajoutés à votre collection privée) à ajouter et retirer des documents ou simplement les visualiser pour référence.',247,'fr',NULL,NULL,NULL),('team_stats','introtext','Les graphiques sont créés à la demande en fonction de données temps réel. Cochez la case pour imprimer tous les graphiques de l\'année sélectionnée.',248,'fr',NULL,NULL,NULL),('resource_request','introtext','La ressource que vous avez demandée n\'est pas disponible en ligne. Les informations sur la ressource sont automatiquement insérées dans le mél, mais vous pouvez ajouter des commentaires additionnels si vous le souhaitez.',249,'fr',NULL,NULL,NULL),('team_batch','introtext',NULL,250,'fr',NULL,NULL,NULL),('team_batch_upload','introtext',NULL,251,'fr',NULL,NULL,NULL),('team_batch_select','introtext',NULL,252,'fr',NULL,NULL,NULL),('download_click','introtext','Pour télécharger le fichier ressource, cliquez droit sur le lien ci-dessous et choisissez \"Enregistrer sous...\". Il vous sera alors demandé l\'emplacement où vous souhaitez sauvegarder le fichier. Pour ouvrir le fichier dans votre navigateur, cliquez simplement sur le lien.',253,'fr',NULL,NULL,NULL),('collection_manage','newcollection','Pour créer une nouvelle collection, entrez un nom court.',254,'fr',NULL,NULL,NULL),('collection_email','introtext','Remplissez le formulaire ci-dessous pour envoyer cette collection par mél. Les utilisateurs recevront un lien vers la ressource plutôt que des fichiers attachés pour qu\'ils puissent choisir et télécharger les ressources appropriées.',255,'fr',NULL,NULL,NULL),('all','footer','Ce site utilise le système de gestion des actifs numériques <a href=\"http://www.resourcespace.org/\">ResourceSpace</a>.',256,'fr',NULL,NULL,NULL),('change_language','introtext','Veuillez sélectionner votre langue ci-dessous.',257,'fr',NULL,NULL,NULL),('change_password','introtext','Saisissez un nouveau mot de passe ci-dessous pour changer votre mot de passe.',258,'fr',NULL,NULL,NULL),('login','welcomelogin','Bienvenue dans ResourceSpace, veuillez vous identifier...',259,'fr',NULL,NULL,NULL),('all','emailresource','[img_gfx/whitegry/titles/title.gif]<br>\n[fromusername] [lang_hasemailedyouaresource]<br><br>\n[message]<br><br>\n<a href=\"[url]\">[embed_thumbnail]</a><br><br>\n[lang_clicktoviewresource]<br><a href=\"[url]\">[resourcename] - [url]</a><br><br>\n[text_footer]\n',260,'en',NULL,NULL,1),('all','emailnewresearchrequestwaiting','[img_gfx/whitegry/titles/title.gif]<br>\n[username] ([userfullname] - [useremail])\n[lang_haspostedresearchrequest]<br><br>\n[lang_nameofproject]:[name]<br><br>\n[lang_descriptionofproject]:[description]<br><br>\n[lang_deadline]:[deadline]<br><br>\n[lang_contacttelephone]:[contact]<br><br>\n[lang_finaluse]: [finaluse]<br><br>\n[lang_shaperequired]: [shape]<br><br>\n[lang_noresourcesrequired]: [noresources]<br><br>\n<a href=\"[url]\">[url]</a><br><br>\n<a href=\"[teamresearchurl]\">[teamresearchurl]</a><br><br>\n[text_footer]\n',261,'en',NULL,NULL,1),('all','emailresearchrequestassigned','[img_gfx/whitegry/titles/title.gif]<br>\n[lang_researchrequestassignedmessage]<br><br>\n[text_footer]\n',262,'en',NULL,NULL,1),('all','emailresearchrequestcomplete','[img_gfx/whitegry/titles/title.gif]<br>\n[lang_researchrequestcompletemessage] <br><br> \n[lang_clicklinkviewcollection] <br><br> \n<a href=\"[url]\">[url]</a><br><br>\n[text_footer]\n',263,'en',NULL,NULL,1),('all','emailnotifyresourcessubmitted','[img_gfx/whitegry/titles/title.gif]<br>\n[lang_userresourcessubmitted]\n[list] <br>\n[lang_viewalluserpending] <br><br> \n<a href=\"[url]\">[url]</a><br><br>\n[text_footer]\n',264,'en',NULL,NULL,1),('all','emailnotifyresourcesunsubmitted','[img_gfx/whitegry/titles/title.gif]<br>\n[lang_userresourcesunsubmitted]\n[list] <br>\n[lang_viewalluserpending] <br><br> \n<a href=\"[url]\">[url]</a><br><br>\n[text_footer]\n',265,'en',NULL,NULL,1),('all','emaillogindetails','[img_gfx/whitegry/titles/title.gif]<br>\n[welcome]<br><br> \n[lang_newlogindetails]<br><br> \n[lang_username] : [username] <br><br>\n[lang_password] : [password]<br><br>\n<a href=\"[url]\">[url]</a><br><br>\n[text_footer]\n',266,'en',NULL,NULL,1),('all','emailreminder','[img_gfx/whitegry/titles/title.gif]<br>\n[lang_newlogindetails] <br><br>\n[lang_username] : [username] <br> \n[lang_password]  : [password] <br><br>\n<a href=\"[url]\">[url]</a><br><br>\n[text_footer]\n',267,'en',NULL,NULL,1),('all','emailresourcerequest','[img_gfx/whitegry/titles/title.gif]<br>\n[lang_username] : [username] <br>\n[list] <br>\n[details]<br><br>\n[lang_clicktoviewresource] <br><br>\n<a href=\"[url]\">[url]</a>\n',268,'en',NULL,NULL,1),('all','emailcollection','[img_gfx/whitegry/titles/title.gif]<br>\n[fromusername] [lang_emailcollectionmessage] <br><br> \n[lang_message] : [message]<br><br> \n[lang_clicklinkviewcollection] [list]\n',269,'en',NULL,NULL,1),('all','emailcollectionexternal','[img_gfx/whitegry/titles/title.gif]<br>\n[fromusername] [lang_emailcollectionmessageexternal] <br><br> \n[lang_message] : [message]<br><br> \n[lang_clicklinkviewcollection] [list]\n',100123,'en',NULL,NULL,1),('all','emailbulk','[img_gfx/whitegry/titles/title.gif]<br><br>\n[text]<br><br>\n[text_footer]\n',270,'en',NULL,NULL,1),('change_language','introtext','Bitte wählen Sie Ihre Sprache aus:',271,'de',NULL,NULL,0),('all','researchrequest','Lassen Sie unser Team nach den benötigten Resourcen suchen.',272,'de',NULL,NULL,0),('all','searchpanel','Suche nach Beschreibung, Schlagworten und Ressourcen IDs',273,'de',NULL,NULL,0),('about','about','Ihr Text zu \"Über uns\" hier.',274,'de',NULL,NULL,0),('change_password','introtext','Neues Passwort unten eingeben, um es zu ändern.',275,'de',NULL,NULL,0),('collection_edit','introtext','Organisieren und verwalten Sie Ihre Arbeit, indem Sie Ressourcen in Gruppen zusammenstellen. Erstellen Sie Kollektionen wie Sie sie benötigen.\n\n<br>\n\nAlle Kollektionen in Ihrer Liste erscheinen im \"Meine Kollektionen\" Menü am unteren Ende des Fensters.\n\n<br><br>\n\n<strong>Privater Zugriff</strong> erlaubt nur Ihnen und ausgewählten Benutzern, die Kollektion zu anzusehen. Ideal, um Ressourcen für die eigene Arbeit zusammenzustellen und im Team weiterzugeben.\n\n<br><br>\n\n<strong>Öffentlicher Zugriff</strong> erlaubt allen Benutzern, die Kollektion zu finden und anzusehen.\n\n<br><br>\n\nSie können aussuchen, ob Sie anderen Benutzern (öffentlicher Zugriff oder ausgewählte Benutzer beim privaten Zugriff) erlauben, Ressourcen hinzuzufügen oder zu löschen.',276,'de',NULL,NULL,0),('collection_email','introtext','Bitte füllen Sie das untenstehende Formular aus, um die Kollektion per E-Mail weiterzugeben. Der/die Benutzer werden statt eines Dateianhangs einen Link zu dieser Kollektion erhalten und können dann die passenden Ressourcen auswählen und herunterladen.',277,'de',NULL,NULL,0),('collection_manage','findpublic','Öffentliche Kollektionen sind für alle Benutzer zugängliche Gruppen von Ressourcen. Um öffentliche Kollektionen zu finden, geben Sie die ID, oder einen Teil des Kollektions- bzw. Benutzernamens ein. Fügen Sie dann die Kollektion zu Ihren Kollektionen hinzu, um auf die Ressourcen zuzugreifen.',278,'de',NULL,NULL,0),('collection_manage','introtext','Organisieren und verwalten Sie Ihre Arbeit, indem Sie Ressourcen in Gruppen zusammenstellen. Erstellen Sie Kollektionen wie Sie sie benötigen. Sie können Kollektionen an andere weitergeben oder einfach Gruppen von Ressourcen zusammen halten. Alle Kollektionen in Ihrer Liste finden Sie im \"Meine Kollektionen\" Menü am unteren Ende des Fensters.',279,'de',NULL,NULL,0),('collection_manage','newcollection','Um eine neue Kollektion zu erstellen, geben Sie bitte einen Kurznamen an.',280,'de',NULL,NULL,0),('collection_public','introtext','Öffentliche Kollektionen werden von anderen Benutzern erstellt und freigegeben.',281,'de',NULL,NULL,0),('contact','contact','Ihre Kontaktdaten hier.',282,'de',NULL,NULL,0),('contribute','introtext','Sie können Ihre eigenen Ressourcen hochladen. Wenn Sie eine Ressource erstellen, wird diese zunächst durch uns geprüft. Nachdem Sie die Datei hochgeladen und die Felder ausgefüllt haben, setzen Sie bitte den Status auf \"Benutzer-Beiträge: Überprüfung noch nicht erledigt\".',283,'de',NULL,NULL,0),('delete','introtext','Bitte geben Sie Ihr Passwort ein, um zu bestätigen, dass Sie diese Ressource löschen wollen.',284,'de',NULL,NULL,0),('done','collection_email','Eine E-Mail mit Link zur Kollektion wurde an die angegebenen Benutzer gesendet. Die Kollektion wurde zur Liste Ihrer Kollektionen hinzugefügt.',285,'de',NULL,NULL,0),('done','deleted','Die Ressource wurde gelöscht.',286,'de',NULL,NULL,0),('done','research_request','Ein Mitglied unseres Teams wird sich um Ihre Anfrage kümmern. Wir werden Sie per e-mail über den aktuellen Stand informieren. Wenn Ihre Anfrage bearbeitet ist, erhalten Sie eine e-mail mit einem Link zu den Ressourcen, die wir für Ihre Anfrage empfehlen.',287,'de',NULL,NULL,0),('done','resource_email','Eine E-Mail mit Link zur Ressource wurde an die angegebenen Benutzer gesendet.',288,'de',NULL,NULL,0),('done','resource_request','Ihre Anfrage wurde abgeschickt und wird in Kürze bearbeitet.',289,'de',NULL,NULL,0),('done','user_password','Eine E-Mail mit Ihrem Benutzernamen und Passwort wurde an Sie gesendet.',290,'de',NULL,NULL,0),('done','user_request','Ihre Anfrage nach einem Zugang wurde abgeschickt und wird in Kürze bearbeitet.',291,'de',NULL,NULL,0),('download_click','introtext','Um die Datei herunterzuladen, clicken Sie bitte mit der rechten Maustaste auf den untenstehenden Link und wählen Sie \"Speichern unter...\". Sie können dann auswählen an welchem Ort Sie die Datei abspeichern wollen. Um die Datei im Browser zu öffnen, clicken Sie den Link bitte mit der linken Maustaste.',292,'de',NULL,NULL,0),('download_progress','introtext','Ihr Download wird in Kürze starten. Nachdem der Download abgeschlossen ist, wählen Sie bitte einen der folgenden Links.',293,'de',NULL,NULL,0),('edit','batch',NULL,294,'de',NULL,NULL,0),('edit','multiple','Bitte wählen Sie die Felder aus, die Sie verändern wollen. Felder, die Sie nicht anwählen, werden nicht verändert.',295,'de',NULL,NULL,0),('help','introtext','Diese Anleitungen helfen Ihnen, ResourceSpace und Ihre Medien effektiv zu nutzen.</p>\n<p>Benutzen Sie \"Themen\", um Ressourcen nach Themen zu erkunden oder nutzen Sie die Suche um spezifische Ressourcen zu finden.</p>\n<p><a href=\"http://www.montala.net/downloads/resourcespace-GettingStarted.pdf\">User Guide</a> (PDF, englisch)<br /><a target=\"_blank\" href=\"http://wiki.resourcespace.org/index.php/Main_Page\">Online Dokumentation</a> (Wiki)</p>',296,'de',NULL,NULL,0),('home','help','Hilfe für die Arbeit mit ResourceSpace',297,'de',NULL,NULL,0),('home','mycollections','Hier können Sie Ihre Kollektionen organisieren, verwalten und weitergeben.',298,'de',NULL,NULL,0),('home','restrictedtext','Bitte klicken Sie auf den Link, den Sie per E-Mail erhalten haben, um auf die für Sie ausgesuchten Ressourcen zuzugreifen.',299,'de',NULL,NULL,0),('home','restrictedtitle','<h1>Willkommen bei ResourceSpace</h1>',300,'de',NULL,NULL,0),('home','themes','Von unserem Team vorausgewählte Bilder',301,'de',NULL,NULL,0),('home','welcometext','Ihr Einleitungstext hier',302,'de',NULL,NULL,0),('home','welcometitle','Willkommen bei ResourceSpace',303,'de',NULL,NULL,0),('login','welcomelogin','Willkommen bei ResourceSpace. Bitte loggen Sie sich ein...',304,'de',NULL,NULL,0),('research_request','introtext','Unser Team unterstützt Sie dabei, die optimalen Ressourcen für Ihre Projekte zu finden. Füllen Sie dieses Formular bitte möglichst vollständig aus, damit wir Ihre Anforderungen erfüllen können.\n<br /><br />\nWir werden Sie kontinuierlich informieren. Sobald wir Ihre Anfrage bearbeitet haben, werden Sie eine E-Mail mit einem Link zu den von uns empfohlenen Bildern erhalten.',305,'de',NULL,NULL,0),('resource_email','introtext','Geben Sie dieses Bild per E-Mail weiter. Es wird ein Link versendet. Sie können außerdem eine persönliche Nachricht in die E-Mail einfügen.',306,'de',NULL,NULL,0),('resource_request','introtext','Die Ressource, die Sie herunterladen möchten, ist nicht online verfügbar. Die Informationen zur Ressource werden automatisch per E-Mail versendet. Zusätzlich können Sie weitere Bemerkungen hinzufügen.',307,'de',NULL,NULL,0),('search_advanced','introtext','<strong>Suchtipp</strong><br>\nJeder Bereich, den Sie nicht ausfüllen / anclicken, liefert alle Resultate aus dem Bereich.',308,'de',NULL,NULL,0),('tag','introtext','Verbessern Sie die Suchergebnisse, indem Sie Ressourcen taggen. Sagen Sie, was Sie sehen, getrennt durch Leerzeichen oder Komma... z.B.: Hund, Haus, Ball, Geburtstag, Kuchen. Geben Sie den vollen Namen von Personen in Fotos und die Ort der Aufnahme an, wenn bekannt.',309,'de',NULL,NULL,0),('terms','introtext','Sie müssen zuerst die Nutzungsbedingungen akzeptieren.\n\n',310,'de',NULL,NULL,0),('terms','terms','Ihre Nutzungsbedingungen hier.',311,'de',NULL,NULL,0),('terms and conditions','terms and conditions','Ihre Nutzungsbedingungen hier.',312,'de',NULL,NULL,0),('themes','findpublic','Öffentliche Kollektionen sind Kollektionen, die von anderen Benutzern freigegeben wurden.',313,'de',NULL,NULL,0),('themes','introtext','Themen sind von unserem Team zusammengestellte Gruppen von Ressourcen.',314,'de',NULL,NULL,0),('user_password','introtext','Bitte geben Sie Ihre E-Mail Adresse ein. Ihre Zugangsdaten werden dann an per E-Mail an Sie versendet.',315,'de',NULL,NULL,0),('user_request','introtext','Um einen Zugang anzufordern, füllen Sie bitte das untenstehende Formular aus.',316,'de',NULL,NULL,0),('team_archive','introtext','Um einzelne Ressourcen im Archiv zu bearbeiten, suchen Sie einfach nach den Ressourcen und klicken auf \"bearbeiten\" unter \"Ressourcen-Werkzeuge\". Alle Ressourcen, die archiviert werden sollen, werden in der Liste \"Archivierung noch nicht erledigt\" angezeigt. Von dieser Liste aus können Sie weitere Informationen ergänzen und die Ressource ins Archiv verschieben.',317,'de',NULL,NULL,0),('team_batch','introtext',NULL,318,'de',NULL,NULL,0),('team_batch_select','introtext',NULL,319,'de',NULL,NULL,0),('team_batch_upload','introtext',NULL,320,'de',NULL,NULL,0),('team_copy','introtext','Geben Sie die ID der Ressource ein, die Sie kopieren möchten. Nur die Metadaten der Ressource werden kopiert – hochgeladene Dateien werden nicht kopiert.',321,'de',NULL,NULL,0),('team_home','introtext','Willkommen in der Administration. Bitte benutzen Sie die untenstehenden Links, um die Ressourcen zu verwalten, auf Ressourcenanfragen zu antworten, Themen zu verwalten und die Systemeinstellungen zu bearbeiten.',322,'de',NULL,NULL,0),('team_report','introtext','Bitte wählen Sie einen Bericht und einen Zeitraum. Der Bericht kann in Microsoft Excel oder einer anderen Tabellenkalkulation geöffnet werden.',323,'de',NULL,NULL,0),('team_research','introtext','Organisieren und verwalten Sie Ihre \"Ressourcenanfragen\".<br /><br />Wählen Sie \"Anfrage bearbeiten\", um die Details der Anfrage zu sehen und sie einem Teammitglied zuzuweisen. Es ist möglich, eine Antwort auf einer existierenden Kollektion aufzubauen. Geben Sie dazu die Kollektions-ID in der Ansicht zur Bearbeitung ein.<br /><br />Wenn die Ressourcenanfrage zugewiesen ist, wählen Sie \"Kollektion bearbeiten\", um die Anfrage zu Ihren Kollektionen hinzuzufügen. So können Sie Ressourcen zu dieser Kollektion hinzufügen.<br /><br />Wenn die Kollektion vollständig ist, wählen Sie \"Anfrage bearbeiten\", stellen Sie den Status auf \"abgeschlossen\" und eine E-Mail wird automatisch an den Anfrager geschickt. Diese E-Mail enthält einen Link zur erstellten Kollektion, welche außerdem automatisch zu den Kollektionen des Benutzers hinzugefügt wird.',324,'de',NULL,NULL,0),('view','storyextract','Story:',325,'de',NULL,NULL,0),('team_resource','introtext','Fügen Sie einzelne Ressourcen hinzu oder nutzen Sie den Stapelupload. Um einzelne Ressourcen zu bearbeiten, suchen Sie nach der Ressource und wählen Sie \"bearbeiten\" unter den \"Ressourcen-Werkzeugen\".',326,'de',NULL,NULL,0),('team_stats','introtext','Statistiken werden auf Basis der aktuellsten Daten erstellt. Aktivieren Sie die Checkbox, um alle Statistiken für das gewählte Jahr auszugeben.',327,'de',NULL,NULL,0),('team_user','introtext','In diesem Bereich können Sie Benutzer hinzufügen, löschen und verändern.',328,'de',NULL,NULL,0),('themes','manage','Organisieren und bearbeiten Sie Ihre Themen. Themen sind besonders hervorgehobene Kollektionen. <br /><br /><strong>1 Um einen neuen Eintrag in einem Thema anzulegen, müssen Sie zuerst eine neue Kollektion anlegen</strong><br />Wählen Sie <strong>Meine Kollektionen</strong> aus der oberen Navigation und legen Sie eine neue <strong>öffentliche</strong> Kollektion an. Stellen Sie sicher, dass Sie einen Namen für Ihr Thema eingeben. Um die aktuelle Kollektion einem bestehenden Thema zuzuordnen, nutzen Sie einen bestehenden Themennamen. Wenn Sie einen noch nicht vergebenen Themennamen angeben, erstellen Sie ein neues Thema. <br /><br /><strong>2 Um den Inhalt eines bestehenden Themas zu ändern, </strong><br>wählen Sie <strong>\'Kollektion bearbeiten\'</strong>. Die Ressourcen in dieser Kollektion erscheinen unten im <strong>\'Meine Kollektionen\'</strong> Bereich. Nutzen Sie die Standardwerkzeuge um Resourcen zu bearbeiten, hizuzufügen oder zu löschen.<br /><br /><strong>3 Um eine Kollektion umzubenennen oder unter einem anderen Thema anzuzeigen,</strong><br />wählen Sie <strong>\'bearbeiten\'</strong> und bearbeiten Sie die Themenkategorie oder die Kollektionsnamen. <br /><br /><strong>4 Um eine Kollektion aus einem Thema zu entfernen,</strong><br>wählen Sie<strong> \'bearbeiten\'</strong> und löschen Sie den Eintrag im Feld \"Themen-Kategorie\".',329,'de',NULL,NULL,0),('upload','introtext',NULL,330,'de',NULL,NULL,0),('upload_swf','introtext',NULL,331,'de',NULL,NULL,0),('home','welcometitle','Välkommen till ResourceSpace',332,'sv',NULL,NULL,0),('home','welcometext','Skriv en introduktion här …',333,'sv',NULL,NULL,0),('all','footer','<a target=\"_blank\" href=\"http://www.resourcespace.org/\">ResourceSpace</a>: Digital materialförvaltning (dam) med öppen källkod',334,'sv',NULL,NULL,0),('all','searchpanel','Sök efter material genom att ange beskrivning, nyckelord eller materialnr.',335,'sv',NULL,NULL,0),('resource_email','introtext','Dela snabbt och enkelt material med andra. Ett e-postmeddelande innehållande en webblänk till materialen skapas och skickas automatiskt. Du kan även lägga till ett eget meddelande.',336,'sv',NULL,NULL,0),('home','themes','De bästa materialen, speciellt utvalda och sorterade.',337,'sv',NULL,NULL,0),('home','restrictedtitle','<h1>Välkommen till ResourceSpace</h1>',338,'sv',NULL,NULL,0),('about','about','Din egen text för ’Om oss’ …',339,'sv',NULL,NULL,0),('home','help','Hjälp och tips som ser till att du får ut det mesta möjliga av ResourceSpace.',340,'sv',NULL,NULL,0),('home','mycollections','Organisera dina material och samarbeta med andra. De här verktygen hjälper dig att arbeta mer effektivt.',341,'sv',NULL,NULL,0),('terms','terms','Dina regler …',342,'sv',NULL,NULL,0),('terms and conditions','terms and conditions','Dina regler och villkor …',343,'sv',NULL,NULL,0),('home','restrictedtext','Klicka på webblänken som skickades till dig om du vill komma åt materialen som är utvalda för dig.',344,'sv',NULL,NULL,0),('change_language','introtext','Välj ditt önskade språk nedan.',345,'sv',NULL,NULL,0),('all','researchrequest','Låt vårt team hitta materialen du är ute efter.',346,'sv',NULL,NULL,0),('change_password','introtext','Skriv in ett nytt lösenord nedan om du vill byta lösenord.',347,'sv',NULL,NULL,0),('contact','contact','Dina kontaktuppgifter …',348,'sv',NULL,NULL,0),('view','storyextract','Textutdrag:',349,'sv',NULL,NULL,0),('team_home','introtext','Välkommen till sidan Administration. Använd länkarna nedan om du vill administrera material, svara på förfrågningar, hantera teman och ändra systeminställningar.',350,'sv',NULL,NULL,0),('themes','introtext','Teman är grupper av material som har valts ut av administratörerna som exempel på vilka material som finns i systemet.',351,'sv',NULL,NULL,0),('collection_manage','findpublic','Gemensamma samlingar är grupper av material som har gjorts allmänt tillgängliga av användare i systemet. Skriv in ett samlingsnr, hela eller delar av samlingsnamnet, eller ett användarnamn när du vill söka efter en gemensam samling. Lägg till den hittade samlingen till din lista över samlingar om du vill kunna nå materialen enkelt.',352,'sv',NULL,NULL,0),('collection_public','introtext','Gemensamma samlingar är skapade av andra användare.',353,'sv',NULL,NULL,0),('themes','findpublic','Gemensamma samlingar är samlingar med material som har delats ut av andra användare.',354,'sv',NULL,NULL,0),('help','introtext','Få ut det mesta möjliga av ResourceSpace. Instruktionerna nedan hjälper dig att använda systemet och materialen effektivare.</p>\n\n<p>Använd Teman om du vill bläddra bland material per tema eller använd Enkel sökning om du vill söka efter specifikt material.</p>\n\n<p><a target=\"_blank\" href=\"http://www.montala.net/downloads/resourcespace-GettingStarted.pdf\">Hämta den engelska användarhandboken (pdf-fil)</a>\n\n<p><a target=\"_blank\" href=\"http://wiki.resourcespace.org/index.php/Main_Page\">Dokumentation på webben (engelskspråkig wiki)</a>',355,'sv',NULL,NULL,0),('collection_email','introtext','Dela snabbt och enkelt materialet i denna samling med andra. Ett e-postmeddelande innehållande en webblänk till materialet skapas och skickas automatiskt. Du kan även lägga till ett eget meddelande.',356,'sv',NULL,NULL,0),('collection_edit','introtext','Organisera och hantera dina material genom att dela upp dem i samlingar.\n\n<br>\n\nDu når alla dina samlingar från panelen <b>Mina&nbsp;samlingar</b> i nederkant av skärmen.\n\n<br><br>\n\n<strong>Privat åtkomst</strong> tillåter endast dig och dina utvalda användare att se samlingen. Idealiskt om du vill samla material i projekt som du jobbar med enskilt eller i en grupp.\n\n<br><br>\n\n<strong>Gemensam åtkomst</strong> tillåter alla interna användare att söka efter och se samlingen. Användbart om du vill dela materialet med andra som skulle kunna ha nytta av det. \n\n<br><br>\n\nDu kan välja om du vill att de andra användarna ska kunna lägga till och ta bort material eller bara kunna visa materialen.',357,'sv',NULL,NULL,0),('edit','multiple','Markera de fält du vill uppdatera med ny information. Omarkerade fält lämnas oförändrade.',358,'sv',NULL,NULL,0),('collection_manage','introtext','Organisera och hantera ditt material genom att dela upp det i samlingar. Skapa samlingar för ett eget projekt, om du vill underlätta samarbetet i en projektgrupp eller om du vill samla dina favoriter på ett ställe. Du når alla dina samlingar från panelen <b>Mina&nbsp;samlingar</b> i nederkant av skärmen.',359,'sv',NULL,NULL,0),('collection_manage','newcollection','Fyll i ett samlingsnamn om du vill skapa en ny samling.',362,'sv',NULL,NULL,0),('contribute','introtext','Du kan bidra med eget material. När du först skapar materialet får det statusen ’Under registrering’. Överför en eller flera filer och fyll i fälten med relevant metadata. Sätt statusen till ’Väntande på granskning’ när du är klar.',363,'sv',NULL,NULL,0),('delete','introtext','Du måste ange ditt lösenord för att bekräfta att du vill ta bort det här materialet.',360,'sv',NULL,NULL,0),('done','deleted','Materialet har tagits bort.',361,'sv',NULL,NULL,0),('done','collection_email','Ett e-postmeddelande innehållande en webblänk har skickats till användarna du specificerade. Samlingen har lagts till i respektive användares panel <b>Mina&nbsp;samlingar</b>.',364,'sv',NULL,NULL,0),('done','research_request','En medlem av researchteamet kommer att få i uppdrag att besvara din researchförfrågan. Vi kommer att hålla kontakt genom e-post under arbetets gång. När vi har slutfört arbetet kommer du att få ett e-postmeddelande med en webblänk till alla material vi rekommenderar.',365,'sv',NULL,NULL,0),('done','resource_email','Ett e-postmeddelande innehållande en webblänk till materialen har skickats till användarna du specificerade.',366,'sv',NULL,NULL,0),('done','resource_request','Din begäran har mottagits och vi kommer att höra av oss inom kort.',367,'sv',NULL,NULL,0),('done','user_password','Ett e-postmeddelande innehållande ditt användarnamn och lösenord har skickats.',368,'sv',NULL,NULL,0),('done','user_request','Din ansökan om ett användarkonto har skickats. Dina inloggningsuppgifter kommer att skickas till dig inom kort.',369,'sv',NULL,NULL,0),('download_click','introtext','Högerklicka på länken nedan och välj <b>Spara&nbsp;som</b> om du vill hämta materialet. Du kommer att få frågan var du vill spara filen. Öppna filen i din webbläsare genom att klicka på webblänken.',370,'sv',NULL,NULL,0),('download_progress','introtext','Din hämtning startas inom kort. När hämtningen är klar kan du fortsätta genom att klicka på länkarna nedan.',371,'sv',NULL,NULL,0),('edit','batch',NULL,372,'sv',NULL,NULL,0),('team_resource','introtext','Lägg till material ett och ett eller i grupp. Om du vill redigera ett material kan du enklast söka efter det och sedan klicka på <b>Redigera</b> på sidan som visar materialet.',373,'sv',NULL,NULL,0),('login','welcomelogin','Välkommen till ResourceSpace',374,'sv',NULL,NULL,0),('user_request','introtext','Fyll i formuläret nedan om du vill ansöka om ett användarkonto.',375,'sv',NULL,NULL,0),('research_request','introtext','Researchteamet hjälper dig att finna de bästa materialen till dina projekt. Fyll i formuläret nedan så noggrant som möjligt så att vi kan ge dig ett relevant svar. <br><br>En medlem av teamet kommer att få i uppdrag att besvara din researchförfrågan. Vi kommer att hålla kontakt genom e-post under arbetets gång. När vi har slutfört arbetet kommer du att få ett e-postmeddelande med en webblänk till alla material vi rekommenderar.',376,'sv',NULL,NULL,0),('resource_request','introtext','Materialet du begärde finns inte tillgängligt. Information om materialet infogas automatiskt i e-postmeddelandet, och du kan även lägga till en egen kommentar om du vill.',377,'sv',NULL,NULL,0),('search_advanced','introtext','<strong>Söktips</strong><br>Ett avsnitt som du lämnar tomt eller omarkerat medför att <i>allt</i> inkluderas i sökningen. Om du till exempel lämnar alla länders kryssrutor omarkerade, begränsas sökningen inte med avseende på land. Om du däremot sedan markerar kryssrutan ’Sverige’ ger sökningen endast material från just Sverige.',378,'sv',NULL,NULL,0),('tag','introtext','Hjälp till att förbättra framtida sökresultat genom att förse materialen med relevant metadata. Ange till exempel nyckelord som beskrivning av vad du ser på en bild: kanin, hus, boll, födelsedagstårta. Separera nyckelorden med kommatecken eller mellanslag. Ange fullständiga namn på alla personer som förekommer på ett fotografi. Ange platsen för ett fotografi om den är känd.',379,'sv',NULL,NULL,0),('user_password','introtext','Fyll i din e-postadress och ditt användarnamn så kommer ett nytt lösenord att skickas till dig.',380,'sv',NULL,NULL,0),('upload_swf','introtext',NULL,381,'sv',NULL,NULL,0),('upload','introtext',NULL,382,'sv',NULL,NULL,0),('themes','manage','Organisera och redigera tillgängliga teman. Teman är grupper av material som har valts ut av administratörerna som exempel på vilka material som finns i systemet.<br><br><strong>Skapa teman</strong><br><Om du vill skapa ett nytt tema måste du först skapa en samling.<br>Gå till <b>Mina&nbsp;samlingar</b> och skapa en ny <strong>gemensam samling</strong>. Välj en temakategori från listan om du vill lägga till samlingen i en existerande temakategori eller ange ett nytt namn om du vill skapa en ny temakategori. Tillåt inte användare att lägga till/ta bort material från teman.<br><br><strong>Redigera teman</strong><br>Om du vill redigera materialen i ett existerande tema väljer du verktyget <strong>Välj samling</strong>. Materialen i samlingen blir då åtkomliga i panelen <b>Mina&nbsp;samlingar</b> i nederkanten av skärmen. Använd de vanliga verktygen om du vill redigera, lägga till eller ta bort material.<br><br><strong>Byta namn på teman och flytta samlingar</strong><br>Välj verktyget <strong>Redigera samling</strong>. Ange ett nytt namn i fältet Namn om du vill byta namn på temat. Välj en temakategori från listan om du vill flytta samlingen till en existerande temakategori eller ange ett nytt namn om du vill skapa en ny temakategori och flytta samlingen dit.<br><br><strong>Ta bort en samling från ett tema</strong><br>Välj verktyget <strong>Redigera samling</strong> och rensa fältet Temakategori och fältet där nya temakategorinamn anges.',383,'sv',NULL,NULL,0),('terms','introtext','Innan du kan fortsätta måste du acceptera reglerna och villkoren.',384,'sv',NULL,NULL,0),('team_user','introtext','Använd den här delen om du vill lägga till, ta bort eller redigera användare.',385,'sv',NULL,NULL,0),('team_stats','introtext','En statistikrapport kan skapas vid behov, baserad på aktuell data. Markera kryssrutan om du vill skriva ut all statistik för det valda året.',386,'sv',NULL,NULL,0),('team_research','introtext','Organisera och hantera researchförfrågningar.<br><br>Välj verktyget <b>Redigera researchförfrågan</b> om du vill granska förfrågan och tilldela en medlem i researchteamet uppdraget att besvara förfrågan. Med samma verktyg kan du lägga till en befintlig samling till researchen genom att ange samlingens nummer.<br><br>När en medlem har tilldelats researchen blir den tillgänglig för medlemmen i panelen <b>Mina&nbsp;samlingar</b>. Använd de vanliga verktygen om du vill lägga till material till researchen.<br><br>När researchen är slutförd väljer du återigen verktyget <b>Redigera researchförfrågan</b> och ändrar status till ’Besvarad’. När du klickar på <b>Spara</b> skickas automatiskt ett e-postmeddelande till användaren som skickade researchförfrågan. Meddelandet innehåller en webblänk som leder till researchen och den läggs också till i användarens panel<b>Mina&nbsp;samlingar</b>.',387,'sv',NULL,NULL,0),('team_report','introtext','Välj en rapport och en period. Rapporten kan öppnas i till exempel MS Excel eller LibreOffice Calc.',388,'sv',NULL,NULL,0),('team_copy','introtext','Ange numret för materialet du vill kopiera. Endast materialets metadata kommer att kopieras &ndash; eventuella filer kommer inte att kopieras.',389,'sv',NULL,NULL,0),('team_batch_upload','introtext',NULL,390,'sv',NULL,NULL,0),('team_batch_select','introtext',NULL,391,'sv',NULL,NULL,0),('team_batch','introtext',NULL,392,'sv',NULL,NULL,0),('team_archive','introtext','Om du vill redigera ett arkiverat material gör du det enklast genom att söka efter det här och sedan klicka på <b>Redigera</b> på sidan som visar materialet. Alla material som väntar på arkivering kan enkelt nås från länken nedan. Lägg till eventuell relevant information innan du flyttar materialet till arkivet.',393,'sv',NULL,NULL,0),('collection_email','introtextthemeshare','Complete the form below to e-mail the themes in this theme category. The recipients will receive an email containing links to each of the themes.',100124,'en',NULL,NULL,NULL);

--
-- Table structure for table `sysvars`
--

CREATE TABLE `sysvars` (
  `name` varchar(50) DEFAULT NULL,
  `value` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sysvars`
--

INSERT INTO `sysvars` VALUES ('last_sent_stats','2014-02-11 12:58:42');

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `fullname` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `usergroup` int(11) DEFAULT NULL,
  `last_active` datetime DEFAULT NULL,
  `logged_in` int(11) DEFAULT NULL,
  `last_browser` text,
  `last_ip` varchar(100) DEFAULT NULL,
  `current_collection` int(11) DEFAULT NULL,
  `accepted_terms` int(11) DEFAULT '0',
  `account_expires` datetime DEFAULT NULL,
  `comments` text,
  `session` varchar(50) DEFAULT NULL,
  `ip_restrict` text,
  `password_last_change` datetime DEFAULT NULL,
  `login_tries` int(11) DEFAULT '0',
  `login_last_try` datetime DEFAULT NULL,
  `approved` int(11) DEFAULT '1',
  `lang` varchar(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ref`),
  KEY `session` (`session`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,'admin','0e97058d62bc810c01829f9827a2b3ff','Admin User','javi@backroompr.com',3,'2014-02-13 17:18:52',1,'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1700.107 Safari/537.36','98.242.188.7',1,1,NULL,'','88e908a4e5d62e2615d26d83a4b763e8','','2013-07-29 22:38:16',0,'2014-02-11 13:07:11',1,'en-US','2013-07-30 02:37:35'),(2,'danny','6108270fe6107362b5ec3c9b9b46486c','','',2,'2014-02-25 11:33:43',1,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_1) AppleWebKit/537.73.11 (KHTML, like Gecko) Version/7.0.1 Safari/537.73.11','50.186.208.8',5,1,NULL,'','d2fcc49d1568a52dd311964ff2ba3eb6','','2014-02-04 15:15:21',0,'2014-02-11 16:35:16',1,'en-US','2014-02-04 20:14:48'),(4,'jackie','33a5d452718283995fcc4d6b3d57ec18','','',2,'2014-02-11 16:59:34',1,'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)','205.145.107.101',7,1,NULL,'','28daf466059862c9a8867b148a3c626c','','2014-02-11 16:51:18',0,NULL,1,'en-US','2014-02-11 21:50:45'),(3,'javi','33914e0f3c1ced3d5f60d6e73e172f3f','','',2,'2014-02-11 13:12:29',1,'Mozilla/5.0 (Windows NT 6.1; rv:26.0) Gecko/20100101 Firefox/26.0','98.242.188.7',6,1,NULL,'','f42de7a13c6dc54974a73babb3703b67','','2014-02-04 15:32:57',0,'2014-02-11 12:59:54',1,'en-US','2014-02-04 20:32:46');

--
-- Table structure for table `user_collection`
--

CREATE TABLE `user_collection` (
  `user` int(11) DEFAULT NULL,
  `collection` int(11) DEFAULT NULL,
  `request_feedback` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_collection`
--

INSERT INTO `user_collection` VALUES (1,1,0);

--
-- Table structure for table `user_rating`
--

CREATE TABLE `user_rating` (
  `user` int(11) DEFAULT '0',
  `rating` int(11) DEFAULT '0',
  `ref` int(11) DEFAULT '0',
  KEY `ref` (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_rating`
--


--
-- Table structure for table `user_userlist`
--

CREATE TABLE `user_userlist` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) DEFAULT NULL,
  `userlist_name` varchar(50) DEFAULT NULL,
  `userlist_string` text,
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_userlist`
--


--
-- Table structure for table `usergroup`
--

CREATE TABLE `usergroup` (
  `ref` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `permissions` text,
  `fixed_theme` varchar(50) DEFAULT NULL,
  `parent` varchar(50) DEFAULT NULL,
  `search_filter` text,
  `edit_filter` text,
  `ip_restrict` text,
  `resource_defaults` text,
  `config_options` text,
  `welcome_message` text,
  `request_mode` int(11) DEFAULT '0',
  `allow_registration_selection` int(11) DEFAULT '0',
  PRIMARY KEY (`ref`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usergroup`
--

INSERT INTO `usergroup` VALUES (1,'Administrators','s,g,c,e,t,h,r,u,i,e-2,e-1,e0,e1,e3,v,o,m,q,n,f*,j*,k,R,Ra,Rb',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,0,0),(2,'General Users','s,e-1,e-2,g,d,q,n,f*,j*',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,1,1),(3,'Super Admin','s,g,c,e,a,t,h,u,r,i,e-2,e-1,e0,e1,e2,e3,o,m,g,v,q,n,f*,j*,k,R,Ra',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,0,0),(4,'Archivists','s,g,c,e,t,h,r,u,i,e1,e2,e3,v,q,n,f*,j*',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,0,0),(5,'Restricted User - Requests Emailed','s,f*,j*,q',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,0,0),(6,'Restricted User - Requests Managed','s,f*,j*,q',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,1,0),(7,'Restricted User - Payment Immediate','s,f*,j*,q',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,2,0),(8,'Restricted User - Payment Invoice','s,f*,j*,q',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,3,0),(9,'Client User - company1','s,f8,f1,f18,e0,e1,e2,d,U,E',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,0,0);

--
-- Dumping events for database 'damvsbrooks'
--

--
-- Dumping routines for database 'damvsbrooks'
--


