|
 |
Hi(gh)!
Meanwhile, I have built the structure for the POV-o-Rama image database;
it should be imported to any not-too-old installation of MySQL (remember
to save it as *.sql).
Changes relative to ER diagram: the type designations for external files
(i. e. texture, heightfield, bumpmap etc.) have been transferred to a
table on its own (see "externalfiletypes" in the dump).
Here is the code:
-- phpMyAdmin SQL Dump
-- version 3.4.11.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Created: 28. Apr 2013 um 04:09
-- Server version: 5.5.30
-- PHP version: 5.4.4-15
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `povorama`
--
-- --------------------------------------------------------
--
-- Table structure for table `addsoftware`
--
CREATE TABLE IF NOT EXISTS `addsoftware` (
`ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(40) NOT NULL,
`Link` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `externalfiles`
--
CREATE TABLE IF NOT EXISTS `externalfiles` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Filename` varchar(200) NOT NULL,
`Externalfiletype_ID` tinyint(3) unsigned NOT NULL,
`Format_ID` tinyint(3) unsigned NOT NULL,
`Size` int(10) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `externalfiletypes`
--
CREATE TABLE IF NOT EXISTS `externalfiletypes` (
`ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(20) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `formats`
--
CREATE TABLE IF NOT EXISTS `formats` (
`ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`Extension` varchar(4) NOT NULL,
`Name` varchar(40) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `images`
--
CREATE TABLE IF NOT EXISTS `images` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Filename` varchar(200) NOT NULL,
`Title` varchar(80) NOT NULL,
`Published` date NOT NULL,
`Format_ID` tinyint(3) unsigned NOT NULL,
`Size` int(10) unsigned NOT NULL,
`Width` smallint(5) unsigned NOT NULL,
`Height` smallint(5) unsigned NOT NULL,
`POVVersion_ID` tinyint(3) unsigned NOT NULL,
`ImageVersion` smallint(5) unsigned NOT NULL,
`PostProcessed` tinyint(1) NOT NULL,
`NumColors` int(10) unsigned DEFAULT NULL,
`AvgBrightness` float DEFAULT NULL,
`AvgSaturation` float DEFAULT NULL,
`FreqHue0_35` int(10) unsigned DEFAULT NULL,
`FreqHue36_71` int(10) unsigned DEFAULT NULL,
`FreqHue72_107` int(10) unsigned DEFAULT NULL,
`FreqHue108_143` int(10) unsigned DEFAULT NULL,
`FreqHue144_179` int(10) unsigned DEFAULT NULL,
`FreqHue180_215` int(10) unsigned DEFAULT NULL,
`FreqHue216_251` int(10) unsigned DEFAULT NULL,
`FreqHue252_287` int(10) unsigned DEFAULT NULL,
`FreqHue288_323` int(10) unsigned DEFAULT NULL,
`FreqHue324_359` int(10) unsigned DEFAULT NULL,
`FreqBright0_10` int(10) unsigned DEFAULT NULL,
`FreqBright11_20` int(10) unsigned DEFAULT NULL,
`FreqBright21_30` int(10) unsigned DEFAULT NULL,
`FreqBright31_40` int(10) unsigned DEFAULT NULL,
`FreqBright41_50` int(10) unsigned DEFAULT NULL,
`FreqBright51_60` int(10) unsigned DEFAULT NULL,
`FreqBright61_70` int(10) unsigned DEFAULT NULL,
`FreqBright71_80` int(10) unsigned DEFAULT NULL,
`FreqBright81_90` int(10) unsigned DEFAULT NULL,
`FreqBright91_100` int(10) unsigned DEFAULT NULL,
`FreqSatur0_10` int(10) unsigned DEFAULT NULL,
`FreqSatur11_20` int(10) unsigned DEFAULT NULL,
`FreqSatur21_30` int(10) unsigned DEFAULT NULL,
`FreqSatur31_40` int(10) unsigned DEFAULT NULL,
`FreqSatur41_50` int(10) unsigned DEFAULT NULL,
`FreqSatur51_60` int(10) unsigned DEFAULT NULL,
`FreqSatur61_70` int(10) unsigned DEFAULT NULL,
`FreqSatur71_80` int(10) unsigned DEFAULT NULL,
`FreqSatur81_90` int(10) unsigned DEFAULT NULL,
`FreqSatur91_100` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `images_addsoftware`
--
CREATE TABLE IF NOT EXISTS `images_addsoftware` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Images_ID` mediumint(8) unsigned NOT NULL,
`AddSoftware_ID` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `images_externalfiles`
--
CREATE TABLE IF NOT EXISTS `images_externalfiles` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Images_ID` mediumint(8) unsigned NOT NULL,
`Externalfiles_ID` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `images_keycont`
--
CREATE TABLE IF NOT EXISTS `images_keycont` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Images_ID` mediumint(8) unsigned NOT NULL,
`KeyCont_ID` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `images_keypov`
--
CREATE TABLE IF NOT EXISTS `images_keypov` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Images_ID` mediumint(8) unsigned NOT NULL,
`KeyPOV_ID` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `images_povernicks`
--
CREATE TABLE IF NOT EXISTS `images_povernicks` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Image_ID` mediumint(8) unsigned NOT NULL,
`POVerNick_ID` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `images_scripts`
--
CREATE TABLE IF NOT EXISTS `images_scripts` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Images_ID` mediumint(8) unsigned NOT NULL,
`Scripts_ID` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `keycont`
--
CREATE TABLE IF NOT EXISTS `keycont` (
`ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(40) NOT NULL,
`KeyCont3rd_ID` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `keycont1st`
--
CREATE TABLE IF NOT EXISTS `keycont1st` (
`ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(40) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `keycont2nd`
--
CREATE TABLE IF NOT EXISTS `keycont2nd` (
`ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(40) NOT NULL,
`KeyCont1st_ID` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `keycont3rd`
--
CREATE TABLE IF NOT EXISTS `keycont3rd` (
`ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(40) NOT NULL,
`KeyCont2nd_ID` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `keypov`
--
CREATE TABLE IF NOT EXISTS `keypov` (
`ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(40) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `povernicks`
--
CREATE TABLE IF NOT EXISTS `povernicks` (
`ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`Nickname` varchar(40) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `povernicks_poverreal`
--
CREATE TABLE IF NOT EXISTS `povernicks_poverreal` (
`ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`POVerNick_ID` smallint(5) unsigned NOT NULL,
`POVerReal_ID` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `poverreal`
--
CREATE TABLE IF NOT EXISTS `poverreal` (
`ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`FirstName` varchar(40) NOT NULL,
`Surname` varchar(40) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `povversions`
--
CREATE TABLE IF NOT EXISTS `povversions` (
`ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(30) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `scripts`
--
CREATE TABLE IF NOT EXISTS `scripts` (
`ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`Filename` varchar(200) NOT NULL,
`Type` enum('main','include') NOT NULL,
`Size` int(10) unsigned NOT NULL,
`NumLines` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
/*!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 */;
See you in Khyberspace!
Yadgar
Now playing: Night Mist (Peak)
Post a reply to this message
|
|
