Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted by rogue ( 15 years ago )
/*
SQLyog Ultimate v8.71 
MySQL - 5.5.8 : Database - mydb
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_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 `about` */

DROP TABLE IF EXISTS `about`;

CREATE TABLE `about` (
  `key` varchar(64) NOT NULL,
  `value` varchar(64) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `about` */

insert  into `about`(`key`,`value`) values ('version','1.0.0.0');

/*Table structure for table `file_index` */

DROP TABLE IF EXISTS `file_index`;

CREATE TABLE `file_index` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` char(8) NOT NULL,
  `guid` char(8) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `file_index` */



/*Table structure for table `file_markers` */

DROP TABLE IF EXISTS `file_markers`;

CREATE TABLE `file_markers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` char(8) NOT NULL,
  `position` int(10) unsigned NOT NULL,
  `text` varchar(64) NOT NULL,
  `type` smallint(1) unsigned NOT NULL DEFAULT '1',
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `FK_file_markers` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `file_markers` */



/*Table structure for table `file_playlist` */

DROP TABLE IF EXISTS `file_playlist`;

CREATE TABLE `file_playlist` (
  `pid` char(8) NOT NULL,
  `lid` smallint(5) unsigned NOT NULL,
  `index` smallint(5) unsigned NOT NULL,
  UNIQUE KEY `pItem` (`pid`,`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `file_playlist` */

/*Table structure for table `file_state` */

DROP TABLE IF EXISTS `file_state`;

CREATE TABLE `file_state` (
  `pid` char(8) NOT NULL,
  `hasData` tinyint(1) NOT NULL DEFAULT '0',
  `hasThumb` tinyint(1) NOT NULL DEFAULT '0',
  `hasAV` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `file_state` */



/*Table structure for table `file_type` */

DROP TABLE IF EXISTS `file_type`;

CREATE TABLE `file_type` (
  `ext` varchar(16) NOT NULL,
  `cat_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ext`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `file_type` */

insert  into `file_type`(`ext`,`cat_id`) values ('.nfo',0),('.exe',0),('.msi',0),('.srt',0),('.txt',0),('.sfk',0),('.db',0),('.doc',0),('.wmv',1),('.avi',1),('.mpg',1),('.rm',1),('.flv',1),('.mp4',1),('.mpeg',1),('.mkv',1),('.mov',1),('.vob',1),('.divx',1),('.asf',1),('.f4v',1),('.jpg',2),('.gif',2),('.mp3',3),('.!ut',4),('.ini',0),('.psd',0),('.url',0),('',0),('.pdf',0),('.noindex',0),('.jpeg',2),('.bmp',2),('.jpe',2),('.png',2),('.zip',5),('.bup',0),('.ifo',0),('.dat',0),('.log',0),('.accurip',0),('.cue',0),('.sfv',0),('.asd',0),('.bak',0),('.htm',0),('.atr',0),('.idx',0),('.pk',0),('.pls',3),('.flac',3),('.mp2',3),('.wma',3),('.wav',3),('.ogg',3),('.wpl',3),('.m3u',3),('.rar',5),('.rmvb',1),('.m4a',3),('.loc',0),('.bat',0),('.key',0),('.0',0),('.theme',0),('.webloc',0),('.icns',0),('.icontainer',0),('.html',0),('.db3',0),('.mng',0),('.ai',0),('.svg',0),('.rtf',0),('.tif',0),('.eps',2),('.ico',2),('.cur',2),('.icon',2),('.vtx',0),('.7',0),('.ac3',3),('.cmd',0),('.reg',0),('.mht',0),('.7z',5),('.test',0),('.iso',0),('.ssa',0),('.1',0),('.r39',0),('.r40',0),('.r44',0),('.r03',0),('.r25',0),('.r37',0),('.r05',0),('.r26',0),('.r20',0),('.r07',1);

/*Table structure for table `files` */

DROP TABLE IF EXISTS `files`;

CREATE TABLE `files` (
  `id` int(10) unsigned DEFAULT NULL,
  `pid` char(8) NOT NULL,
  `guid` char(8) NOT NULL,
  `path` varchar(512) NOT NULL,
  `comment` varchar(255) NOT NULL DEFAULT '',
  `tags` varchar(512) NOT NULL DEFAULT '',
  `url` char(255) NOT NULL DEFAULT '',
  `hash` char(32) NOT NULL DEFAULT '',
  `cat_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `size` bigint(20) unsigned NOT NULL DEFAULT '0',
  `duration` int(10) unsigned NOT NULL DEFAULT '0',
  `runtime` int(10) unsigned NOT NULL DEFAULT '0',
  `views` smallint(5) unsigned NOT NULL DEFAULT '0',
  `rating` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `fav` tinyint(1) NOT NULL DEFAULT '0',
  `watch` tinyint(1) NOT NULL DEFAULT '0',
  `creationtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `accesstime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modifiedtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deletiontime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `dbtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `pHash` (`pid`),
  UNIQUE KEY `filePath` (`path`(333)),
  UNIQUE KEY `fileID` (`id`),
  KEY `parent` (`guid`),
  KEY `tagsIndex` (`tags`(333)),
  KEY `fsize` (`size`),
  KEY `fhash` (`hash`),
  KEY `com` (`comment`),
  KEY `url` (`url`),
  FULLTEXT KEY `ft` (`path`,`tags`),
  FULLTEXT KEY `ftpath` (`path`),
  FULLTEXT KEY `tags` (`tags`),
  FULLTEXT KEY `alltext` (`path`,`comment`,`tags`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Data for the table `files` */



/*Table structure for table `filters` */

DROP TABLE IF EXISTS `filters`;

CREATE TABLE `filters` (
  `id` smallint(1) unsigned NOT NULL AUTO_INCREMENT,
  `text` varchar(255) NOT NULL,
  `params` text NOT NULL,
  `checked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `NewIndex1` (`text`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Data for the table `filters` */



/*Table structure for table `folder_index` */

DROP TABLE IF EXISTS `folder_index`;

CREATE TABLE `folder_index` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `guid` char(8) NOT NULL COMMENT 'should only be used for join',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fid` (`guid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `folder_index` */



/*Table structure for table `folders` */

DROP TABLE IF EXISTS `folders`;

CREATE TABLE `folders` (
  `id` int(10) unsigned DEFAULT NULL,
  `guid` char(8) NOT NULL,
  `path` varchar(255) NOT NULL,
  `creationtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modifiedtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  UNIQUE KEY `fid` (`guid`),
  UNIQUE KEY `folderID` (`id`),
  KEY `fullPath` (`path`),
  FULLTEXT KEY `ftpath` (`path`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Data for the table `folders` */



/*Table structure for table `grid_state` */

DROP TABLE IF EXISTS `grid_state`;

CREATE TABLE `grid_state` (
  `state` varchar(255) NOT NULL,
  `name` varchar(20) NOT NULL,
  `index` tinyint(2) unsigned NOT NULL,
  `visible` tinyint(1) NOT NULL,
  `width` smallint(4) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `grid_state` */



/*Table structure for table `playlists` */

DROP TABLE IF EXISTS `playlists`;

CREATE TABLE `playlists` (
  `lid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`lid`),
  UNIQUE KEY `pname` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `playlists` */



/*Table structure for table `search` */

DROP TABLE IF EXISTS `search`;

CREATE TABLE `search` (
  `text` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `count` smallint(5) unsigned NOT NULL DEFAULT '1',
  UNIQUE KEY `searchtext` (`text`),
  FULLTEXT KEY `NewIndex1` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `search` */



/*Table structure for table `tags` */

DROP TABLE IF EXISTS `tags`;

CREATE TABLE `tags` (
  `tag` varchar(64) NOT NULL,
  `matches` smallint(5) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Data for the table `tags` */



/* Trigger structure for table `file_index` */

DELIMITER $$

/*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `file_index_Delete` */$$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `file_index_Delete` AFTER DELETE ON `file_index` FOR EACH ROW BEGIN
      update files set deletiontime=now(),id=null where files.id=old.id;
    END */$$


DELIMITER ;

/* Trigger structure for table `folder_index` */

DELIMITER $$

/*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `folder_index_Delete` */$$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `folder_index_Delete` AFTER DELETE ON `folder_index` FOR EACH ROW BEGIN
 UPDATE folders SET id=NULL WHERE folders.id=OLD.id;
        delete from file_index where file_index.guid = old.guid;
    END */$$


DELIMITER ;

/*Table structure for table `file_info` */

DROP TABLE IF EXISTS `file_info`;

/*!50001 DROP VIEW IF EXISTS `file_info` */;
/*!50001 DROP TABLE IF EXISTS `file_info` */;

/*!50001 CREATE TABLE  `file_info`(
 `pid` char(8) ,
 `id` int(10) unsigned ,
 `guid` char(8) ,
 `path` varchar(512) ,
 `comment` varchar(255) ,
 `tags` varchar(512) ,
 `url` char(255) ,
 `hash` char(32) ,
 `cat_id` tinyint(2) unsigned ,
 `size` bigint(20) unsigned ,
 `duration` int(10) unsigned ,
 `runtime` int(10) unsigned ,
 `views` smallint(5) unsigned ,
 `rating` tinyint(2) unsigned ,
 `fav` tinyint(1) ,
 `watch` tinyint(1) ,
 `creationtime` datetime ,
 `accesstime` datetime ,
 `modifiedtime` datetime ,
 `deletiontime` datetime ,
 `dbtime` timestamp ,
 `hasData` tinyint(1) ,
 `hasThumb` tinyint(1) ,
 `hasAV` tinyint(1) 
)*/;

/*View structure for view file_info */

/*!50001 DROP TABLE IF EXISTS `file_info` */;
/*!50001 DROP VIEW IF EXISTS `file_info` */;

/*!50001 CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `file_info` AS (select `files`.`pid` AS `pid`,`files`.`id` AS `id`,`files`.`guid` AS `guid`,`files`.`path` AS `path`,`files`.`comment` AS `comment`,`files`.`tags` AS `tags`,`files`.`url` AS `url`,`files`.`hash` AS `hash`,`files`.`cat_id` AS `cat_id`,`files`.`size` AS `size`,`files`.`duration` AS `duration`,`files`.`runtime` AS `runtime`,`files`.`views` AS `views`,`files`.`rating` AS `rating`,`files`.`fav` AS `fav`,`files`.`watch` AS `watch`,`files`.`creationtime` AS `creationtime`,`files`.`accesstime` AS `accesstime`,`files`.`modifiedtime` AS `modifiedtime`,`files`.`deletiontime` AS `deletiontime`,`files`.`dbtime` AS `dbtime`,`file_state`.`hasData` AS `hasData`,`file_state`.`hasThumb` AS `hasThumb`,`file_state`.`hasAV` AS `hasAV` from (`files` left join `file_state` on((`files`.`pid` = `file_state`.`pid`)))) */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

Revise this Paste

Your Name: Code Language: