Differences

This shows you the differences between two versions of the page.

--- hxmc:user_database [2013/10/23 08:44]
tschulz
+++ hxmc:user_database [2013/10/28 07:16]
tschulz [SQL]
@@ Line 2: / Line 2: @@
   * MediaPathid (int) pk, auto inc
   * unc_url (varchar)
+  * pathType (int)
   * username (varchar)
   * password (varchar)
@@ Line 18: / Line 19: @@
   * email (varchar)
+===== Settings Table =====
+  * Settingid (int) pk, auto inc
+  * Userid (int) fk
+  * setting_name (varchar)
+  * setting_value (varchar)
+===== SQL =====
+<file>
+-- 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>

ISD 820 Knowledge Base

User Tools

Site Tools

Differences

Page Tools