This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
hxmc:user_database [2013/10/23 08:41] tschulz |
hxmc:user_database [2013/10/28 07:16] (current) tschulz [SQL] |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== Media Path Table ===== | ===== Media Path Table ===== | ||
- | * id (int) pk, auto inc | + | * MediaPathid (int) pk, auto inc |
* unc_url (varchar) | * unc_url (varchar) | ||
+ | * pathType (int) | ||
* username (varchar) | * username (varchar) | ||
* password (varchar) | * password (varchar) | ||
===== Video Position Table ===== | ===== Video Position Table ===== | ||
- | * int (int) pk, auto inc | + | * Posid (int) pk, auto inc |
+ | * Userid (int) fk | ||
* media_path (varchar) | * media_path (varchar) | ||
* position (float) | * position (float) | ||
+ | ===== User Table ===== | ||
+ | * Userid (int) pk, auto inc | ||
+ | * username (varchar) | ||
+ | * password (varchar) | ||
+ | * Description (varchar) | ||
+ | * email (varchar) | ||
+ | |||
+ | ===== Settings Table ===== | ||
+ | * Settingid (int) pk, auto inc | ||
+ | * Userid (int) fk | ||
+ | * setting_name (varchar) | ||
+ | * setting_value (varchar) | ||
+ | |||
+ | ===== SQL ===== | ||
+ | <file sql hxmc.sql> | ||
+ | -- phpMyAdmin SQL Dump | ||
+ | -- version 3.4.10.1deb1 | ||
+ | -- http://www.phpmyadmin.net | ||
+ | -- | ||
+ | -- Host: localhost | ||
+ | -- Generation Time: Oct 28, 2013 at 07:16 AM | ||
+ | -- Server version: 5.5.29 | ||
+ | -- PHP Version: 5.3.10-1ubuntu3.8 | ||
+ | |||
+ | 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: `hxmc` | ||
+ | -- | ||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `imageCache` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `imageCache` ( | ||
+ | `cacheId` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
+ | `srcUrl` text NOT NULL, | ||
+ | `localPath` text NOT NULL, | ||
+ | `cacheDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | ||
+ | PRIMARY KEY (`cacheId`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `mediaPath` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `mediaPath` ( | ||
+ | `MediaPathId` int(11) unsigned NOT NULL AUTO_INCREMENT, | ||
+ | `unc_url` text NOT NULL, | ||
+ | `pathType` int(10) unsigned NOT NULL, | ||
+ | `username` text NOT NULL, | ||
+ | `password` text NOT NULL, | ||
+ | PRIMARY KEY (`MediaPathId`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `settings` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `settings` ( | ||
+ | `Settingid` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
+ | `Userid` int(10) unsigned NOT NULL, | ||
+ | `setting_name` text NOT NULL, | ||
+ | `setting_value` text NOT NULL, | ||
+ | PRIMARY KEY (`Settingid`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `users` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `users` ( | ||
+ | `Userid` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
+ | `username` text NOT NULL, | ||
+ | `password` text NOT NULL, | ||
+ | `desciption` text NOT NULL, | ||
+ | `email` text NOT NULL, | ||
+ | `isAdmin` tinyint(1) NOT NULL, | ||
+ | PRIMARY KEY (`Userid`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `users` | ||
+ | -- | ||
+ | |||
+ | INSERT INTO `users` (`Userid`, `username`, `password`, `desciption`, `email`, `isAdmin`) VALUES | ||
+ | (1, 'tschulz', 'pwd', 'Thad', 'toschulz@gmail.com', 1); | ||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `videoPosition` | ||
+ | -- | ||
+ | CREATE TABLE IF NOT EXISTS `videoPosition` ( | ||
+ | `Posid` int(11) unsigned NOT NULL AUTO_INCREMENT, | ||
+ | `Userid` int(11) unsigned NOT NULL, | ||
+ | `media_path` text NOT NULL, | ||
+ | `position` float unsigned NOT NULL, | ||
+ | PRIMARY KEY (`Posid`) | ||
+ | ) 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 */; | ||
+ | </file> |