Ticket #1746: testsort.sql

File testsort.sql, 3.2 KB (added by numbars@…, 16 years ago)

This file demonstrates the weird folder sorting in list view

2-- Table structure for table `videometadata`
5DROP TABLE IF EXISTS `videometadata`;
6CREATE TABLE `videometadata` (
7  `intid` int(10) unsigned NOT NULL auto_increment,
8  `title` varchar(128) NOT NULL default '',
9  `director` varchar(128) NOT NULL default '',
10  `plot` text,
11  `rating` varchar(255) NOT NULL default '',
12  `inetref` varchar(32) NOT NULL default '',
13  `year` int(10) unsigned NOT NULL default '0',
14  `userrating` float NOT NULL default '0',
15  `length` int(10) unsigned NOT NULL default '0',
16  `showlevel` int(10) unsigned NOT NULL default '0',
17  `filename` text NOT NULL,
18  `coverfile` text NOT NULL,
19  `childid` int(11) NOT NULL default '-1',
20  `browse` tinyint(1) NOT NULL default '1',
21  `playcommand` varchar(255) default NULL,
22  `category` int(10) unsigned NOT NULL default '0',
23  PRIMARY KEY  (`intid`),
24  KEY `director` (`director`),
25  KEY `title` (`title`),
26  KEY `title_2` (`title`)
30-- Dumping data for table `videometadata`
32INSERT INTO `videometadata` VALUES (400,'000.Rod Sterling Interview','','Rod Serling\'s seminal anthology series focused on ordinary folks who suddenly found themselves in extraordinary, usually supernatural, situations. The stories would typically end with an ironic twist that would see the guilty punished.\n<br><br>\n\n<b class=\"ch\">Seasons:</b>\n\n   (USA)','','0052520',1959,0,60,1,'/myth/video/library/SciFi/Twilight Zone.01/Twilight Zone - 000 - Rod Sterling Interview.wmv','/myth/video/.covers/0052520.jpg',-1,1,'playvideo.sh \"/cdrom/Twilight Zone - 000 - Rod Sterling Interview.wmv\" 0040',6);
33INSERT INTO `videometadata` VALUES (4127,'082.Pyramids Of Mars','','The TARDIS materialises on Earth in the year 1911 inside an old priory owned by Egyptologist Marcus Scarman. Scarman has been possessed by Sutekh, last survivor of the god-like Osirans, who held prisoner inside a pyramid in Egypt by a signal trasnmitted from one on Mars. Sutekh desires his freedom and instructs Scarman to construct servicer robots - which look like Eygptian mummies - to build a missile with which to destroy the Martian pyramid UK)','Tom Baker,Elisabeth Sladen','0056751',1975,8,100,1,'/myth/video/library/SciFi/Doctor Who/Dr Who - Pyramids Of Mars.avi','/myth/video/.covers/0056751-pyramids.jpg',-1,1,'playvideo.sh \"/cdrom/Dr Who - Pyramids Of Mars.avi\" 0302',6);
34INSERT INTO `videometadata` VALUES (986,'1x01.Pilot','','Two FBI agents, Fox Mulder the believer and Dana Scully the skeptic investigate the strange and unexplained while hidden forces work to impede their efforts.  (USA,Canada)','','0106179',1993,0,45,1,'/myth/video/library/SciFi/X Files/X-Files - 1x01 - Pilot.avi','/myth/video/.covers/0106179-01.jpg',-1,1,'playvideo.sh \"/cdrom/X-Files - 1x01 - Pilot.avi\" 0063',6);
35INSERT INTO `videometadata` VALUES (3361,'1x13.Orac','','In the third century of the second calendar, a corrupt galactic federation, with Earth at its center...\n  (UK)','','0076987',1978,0,50,1,'/myth/video/library/SciFi/Blakes 7/Blakes 7.1x13.Orac.avi','/myth/video/.covers/0076987-01.jpg',-1,1,'playvideo.sh \"/cdrom/Blake\'s 7.1x13.Orac.avi\" 0204',6);
38update settings set data = 0 where value = "VideoTreeNoDB"
39update settings set data = 1 where value = "VideoTreeLoadMetaData"