This is an old revision of the document!
-- phpMyAdmin SQL Dump -- version 3.4.10.1deb1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 24, 2013 at 02:01 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 `mediaPath` -- CREATE TABLE IF NOT EXISTS `mediaPath` ( `MediaPathId` int(11) unsigned NOT NULL AUTO_INCREMENT, `unc_url` text 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=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 */;