-- MySQL dump 10.19  Distrib 10.3.29-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: db    Database: koha_kohadev
-- ------------------------------------------------------
-- Server version	10.1.48-MariaDB-1~bionic

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `opac_news`
--

DROP TABLE IF EXISTS `opac_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `opac_news` (
  `idnew` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the news article',
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'branch code users to create branch specific news, NULL is every branch.',
  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'title of the news article',
  `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the body of your news article',
  `lang` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'location for the article (koha is the staff interface, slip is the circulation receipt and language codes are for the opac)',
  `published_on` date DEFAULT NULL COMMENT 'publication date',
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'last modification',
  `expirationdate` date DEFAULT NULL COMMENT 'date the article is set to expire or no longer be visible',
  `number` int(11) DEFAULT NULL COMMENT 'the order in which this article appears in that specific location',
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'The user who created the news article',
  PRIMARY KEY (`idnew`),
  KEY `borrowernumber_fk` (`borrowernumber`),
  KEY `opac_news_branchcode_ibfk` (`branchcode`),
  CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `opac_news_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `opac_news`
--

LOCK TABLES `opac_news` WRITE;
/*!40000 ALTER TABLE `opac_news` DISABLE KEYS */;
INSERT INTO `opac_news` VALUES (1,NULL,'Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','koha','2007-10-29','2021-07-09 11:50:22','2099-01-10',1,NULL),(2,NULL,'What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','koha','2007-10-29','2021-07-09 11:50:22','2099-01-10',2,NULL),(3,NULL,'location=\"\"','news with location=\"\"','','2021-07-09','2021-07-09 11:52:28',NULL,NULL,51),(4,NULL,'news with location =\"\" 2','news with location =\"\" 2','','2021-07-09','2021-07-09 11:52:43',NULL,NULL,51),(5,NULL,'news staff 1','news staff 1','koha','2021-07-09','2021-07-09 11:53:05',NULL,NULL,51),(6,NULL,'news staff 2','news staff 2','koha','2021-07-09','2021-07-09 11:53:15',NULL,NULL,51),(7,NULL,'opac news en 1','opac news en 1','en','2021-07-09','2021-07-09 11:53:27',NULL,NULL,51),(8,NULL,'opac news en 2','opac news en 2','en','2021-07-09','2021-07-09 11:53:36',NULL,NULL,51),(9,NULL,'opac news fr 1','opac news fr 1','fr-FR','2021-07-09','2021-07-09 11:54:33',NULL,NULL,51),(10,NULL,'opac news fr 2','opac news fr 2','fr-FR','2021-07-09','2021-07-09 11:55:20',NULL,NULL,51),(11,NULL,'opac navright en 1','opac navright en 1','OpacNavRight_en','2021-07-09','2021-07-09 11:55:41',NULL,NULL,51),(12,NULL,'opac navright en 2','opac navright en 2','OpacNavRight_en','2021-07-09','2021-07-09 11:55:51',NULL,NULL,51),(13,NULL,'opac navright fr 1','opac navright fr 1','OpacNavRight_fr-FR','2021-07-09','2021-07-09 11:56:04',NULL,NULL,51),(14,NULL,'opac navright fr 2','opac navright fr 2','OpacNavRight_fr-FR','2021-07-09','2021-07-09 11:56:20',NULL,NULL,51);
/*!40000 ALTER TABLE `opac_news` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-07-09 11:57:18
