-- MySQL dump 10.11
--
-- Host: localhost    Database: grupponorba
-- ------------------------------------------------------
-- Server version	5.0.51a-24+lenny5-log

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

--
-- Table structure for table `categorie`
--

DROP TABLE IF EXISTS `categorie`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `categorie` (
  `categoria_id` int(11) NOT NULL auto_increment,
  `titolo` varchar(45) NOT NULL,
  `dalet_titolo` varchar(45) default NULL,
  `path` varchar(45) NOT NULL default '0',
  `order` int(11) default NULL,
  PRIMARY KEY  (`categoria_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `categorie`
--

LOCK TABLES `categorie` WRITE;
/*!40000 ALTER TABLE `categorie` DISABLE KEYS */;
INSERT INTO `categorie` VALUES (1,'TgNorba24',NULL,'0',1),(2,'Sport','SPORT','1,',9),(3,'Attualità','ATTUALITA’','1,',5),(4,'Cronaca','CRONACA','1,',2),(5,'Spettacolo','SPETTACOLO','1,',7),(6,'Cultura','CULTURA','1,',6),(7,'Economia','ECONOMIA','1,',4),(8,'Politica','POLITICA','1,',3),(9,'Moda&Mode','MODA&MODE','1,',8);
/*!40000 ALTER TABLE `categorie` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `controllers`
--

DROP TABLE IF EXISTS `controllers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `controllers` (
  `controller_id` int(11) NOT NULL auto_increment,
  `controller_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`controller_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `controllers`
--

LOCK TABLES `controllers` WRITE;
/*!40000 ALTER TABLE `controllers` DISABLE KEYS */;
INSERT INTO `controllers` VALUES (1,'Posts'),(2,'Index');
/*!40000 ALTER TABLE `controllers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `groups`
--

DROP TABLE IF EXISTS `groups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `groups` (
  `group_id` int(11) NOT NULL auto_increment,
  `group` varchar(45) NOT NULL,
  PRIMARY KEY  (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `groups`
--

LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` VALUES (1,'Admin');
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `groups_privileges`
--

DROP TABLE IF EXISTS `groups_privileges`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `groups_privileges` (
  `group_privilege_id` int(11) NOT NULL auto_increment,
  `group_id` int(11) NOT NULL,
  `privilege_id` int(11) NOT NULL,
  `privilege_type` enum('allow','deny') NOT NULL,
  PRIMARY KEY  (`group_privilege_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `groups_privileges`
--

LOCK TABLES `groups_privileges` WRITE;
/*!40000 ALTER TABLE `groups_privileges` DISABLE KEYS */;
INSERT INTO `groups_privileges` VALUES (1,1,1,'allow'),(2,1,2,'allow'),(3,1,3,'allow'),(4,1,4,'allow');
/*!40000 ALTER TABLE `groups_privileges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `homes`
--

DROP TABLE IF EXISTS `homes`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `homes` (
  `sezione_id` int(11) NOT NULL,
  `sezione` varchar(65) NOT NULL,
  `sito_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `homes`
--

LOCK TABLES `homes` WRITE;
/*!40000 ALTER TABLE `homes` DISABLE KEYS */;
INSERT INTO `homes` VALUES (1,'primo_piano',1),(2,'cronaca',1),(3,'sport',1),(4,'moda_mode',1);
/*!40000 ALTER TABLE `homes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `homes_has_notizie`
--

DROP TABLE IF EXISTS `homes_has_notizie`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `homes_has_notizie` (
  `notizia_id` int(11) NOT NULL,
  `sezione_id` int(11) NOT NULL,
  PRIMARY KEY  (`notizia_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `homes_has_notizie`
--

LOCK TABLES `homes_has_notizie` WRITE;
/*!40000 ALTER TABLE `homes_has_notizie` DISABLE KEYS */;
INSERT INTO `homes_has_notizie` VALUES (1,1),(5,2),(3,2),(8,2);
/*!40000 ALTER TABLE `homes_has_notizie` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notizie`
--

DROP TABLE IF EXISTS `notizie`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `notizie` (
  `notizia_id` int(11) NOT NULL auto_increment,
  `categoria_id` int(11) NOT NULL,
  `video_id` int(11) default NULL,
  `titolo` varchar(255) NOT NULL,
  `descrizione` text NOT NULL,
  `autore` varchar(255) NOT NULL,
  `operatore` varchar(255) default NULL,
  `online` tinyint(1) NOT NULL default '0',
  `user_insert` int(11) NOT NULL default '0',
  `user_update` int(11) default NULL,
  `date_ins` datetime NOT NULL,
  `date_upd` datetime default NULL,
  PRIMARY KEY  (`notizia_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;


--
-- Table structure for table `ou_privileges`
--

DROP TABLE IF EXISTS `ou_privileges`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ou_privileges` (
  `ou_privilege_id` int(11) NOT NULL auto_increment,
  `ou_id` int(11) NOT NULL,
  `privilege_id` int(11) NOT NULL,
  `privilege_type` enum('allow','deny') NOT NULL,
  PRIMARY KEY  (`ou_privilege_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `ou_privileges`
--

LOCK TABLES `ou_privileges` WRITE;
/*!40000 ALTER TABLE `ou_privileges` DISABLE KEYS */;
INSERT INTO `ou_privileges` VALUES (1,1,1,'allow'),(2,1,2,'allow'),(3,1,3,'allow'),(4,1,4,'allow');
/*!40000 ALTER TABLE `ou_privileges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ous`
--

DROP TABLE IF EXISTS `ous`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ous` (
  `ou_id` int(11) NOT NULL auto_increment,
  `ou` varchar(45) NOT NULL,
  `path` varchar(45) NOT NULL default '0',
  PRIMARY KEY  (`ou_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `ous`
--

LOCK TABLES `ous` WRITE;
/*!40000 ALTER TABLE `ous` DISABLE KEYS */;
INSERT INTO `ous` VALUES (1,'Produzione','0'),(2,'Registi','1,'),(3,'Montatori','1,2,'),(4,'Prova','1,2,');
/*!40000 ALTER TABLE `ous` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `privileges`
--

DROP TABLE IF EXISTS `privileges`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `privileges` (
  `privilege_id` int(11) NOT NULL auto_increment,
  `controller_id` int(11) NOT NULL,
  `privilege_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`privilege_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `privileges`
--

LOCK TABLES `privileges` WRITE;
/*!40000 ALTER TABLE `privileges` DISABLE KEYS */;
INSERT INTO `privileges` VALUES (1,1,'index'),(2,1,'list'),(3,1,'edit'),(4,1,'add');
/*!40000 ALTER TABLE `privileges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resources`
--

DROP TABLE IF EXISTS `resources`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `resources` (
  `resource_id` int(11) NOT NULL auto_increment,
  `controller_id` int(11) NOT NULL,
  `resource_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`resource_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `resources`
--

LOCK TABLES `resources` WRITE;
/*!40000 ALTER TABLE `resources` DISABLE KEYS */;
INSERT INTO `resources` VALUES (1,1,'index'),(2,1,'list'),(3,1,'edit'),(4,1,'add');
/*!40000 ALTER TABLE `resources` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `thumbs`
--

DROP TABLE IF EXISTS `thumbs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `thumbs` (
  `thumb_id` int(11) NOT NULL auto_increment,
  `video_id` int(11) NOT NULL,
  `default` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`thumb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `thumbs_files`
--

DROP TABLE IF EXISTS `thumbs_files`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `thumbs_files` (
  `thumb_file_id` int(11) NOT NULL auto_increment,
  `thumb_id` int(11) NOT NULL,
  `size_id` int(11) NOT NULL,
  `thumb` varchar(255) NOT NULL,
  PRIMARY KEY  (`thumb_file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `thumbs_sizes`
--

DROP TABLE IF EXISTS `thumbs_sizes`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `thumbs_sizes` (
  `size_id` int(11) NOT NULL auto_increment,
  `label` varchar(45) NOT NULL,
  `w` int(11) NOT NULL,
  `h` int(11) NOT NULL,
  PRIMARY KEY  (`size_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `thumbs_sizes`
--

LOCK TABLES `thumbs_sizes` WRITE;
/*!40000 ALTER TABLE `thumbs_sizes` DISABLE KEYS */;
INSERT INTO `thumbs_sizes` VALUES (1,'player',640,360),(2,'xsmall',102,57),(3,'medium',113,63),(4,'large',149,84),(5,'xlarge',153,86),(6,'xxlarge',242,136),(7,'xxxlarge',292,164),(9,'xxxxlarge',382,214),(10,'xxxxxlarge',660,371);
/*!40000 ALTER TABLE `thumbs_sizes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `uid` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `nome` varchar(45) NOT NULL,
  `cognome` varchar(45) NOT NULL,
  `group_id` int(11) default NULL,
  `ou_id` int(11) default NULL,
  `date_ins` datetime NOT NULL,
  `date_upd` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'filippo','31f17d0937946da06e9648dbe01bfec9','Filippo','Panessa',1,1,'0000-00-00 00:00:00',NULL),(2,'antonio','4a181673429f0b6abbfd452f0f3b5950','Antonio','Lanzolla',1,3,'0000-00-00 00:00:00',NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `videos`
--

DROP TABLE IF EXISTS `videos`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `videos` (
  `video_id` int(11) NOT NULL auto_increment,
  `watermark_id` int(11) NOT NULL default '1',
  `directory` varchar(255) default NULL,
  `file` varchar(255) default NULL,
  `mp4_watermark` varchar(255) default NULL,
  `m4v` varchar(255) default NULL,
  `ogv` varchar(255) default NULL,
  `webm` varchar(255) default NULL,
  `mp4_watermark_status` enum('WAIT','BUSY','ERROR','OK','UPLOAD','UPLOADED') NOT NULL default 'WAIT',
  `m4v_status` enum('WAIT','BUSY','ERROR','OK','UPLOAD','UPLOADED') NOT NULL default 'WAIT',
  `ogv_status` enum('WAIT','BUSY','ERROR','OK','UPLOAD','UPLOADED') NOT NULL default 'WAIT',
  `webm_status` enum('WAIT','BUSY','ERROR','OK','UPLOAD','UPLOADED') NOT NULL default 'WAIT',
  `thumbs_status` enum('WAIT','BUSY','ERROR','OK','UPLOAD','UPLOADED') NOT NULL default 'WAIT',
  `posticipate` tinyint(1) NOT NULL default '0',
  `duration` time default NULL,
  PRIMARY KEY  (`video_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `watermarks`
--

DROP TABLE IF EXISTS `watermarks`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `watermarks` (
  `watermark_id` int(11) NOT NULL auto_increment,
  `label` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `w` int(11) NOT NULL,
  `h` int(11) NOT NULL,
  PRIMARY KEY  (`watermark_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `watermarks`
--

LOCK TABLES `watermarks` WRITE;
/*!40000 ALTER TABLE `watermarks` DISABLE KEYS */;
INSERT INTO `watermarks` VALUES (1,'TgNorba24','tgnorba.png',525,315),(2,'GruppoNorba','gn.png',525,315);
/*!40000 ALTER TABLE `watermarks` 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 2011-04-13 17:00:59