User Tools
hxmc:user_database
Differences
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/28 07:15] tschulz [Media Path Table] |
hxmc:user_database [2013/10/28 07:16] (current) tschulz [SQL] |
||
|---|---|---|---|
| Line 26: | Line 26: | ||
| ===== SQL ===== | ===== SQL ===== | ||
| - | <file> | + | <file sql hxmc.sql> |
| -- phpMyAdmin SQL Dump | -- phpMyAdmin SQL Dump | ||
| -- version 3.4.10.1deb1 | -- version 3.4.10.1deb1 | ||
| Line 32: | Line 32: | ||
| -- | -- | ||
| -- Host: localhost | -- Host: localhost | ||
| - | -- Generation Time: Oct 24, 2013 at 02:01 AM | + | -- Generation Time: Oct 28, 2013 at 07:16 AM |
| -- Server version: 5.5.29 | -- Server version: 5.5.29 | ||
| -- PHP Version: 5.3.10-1ubuntu3.8 | -- PHP Version: 5.3.10-1ubuntu3.8 | ||
| Line 48: | Line 48: | ||
| -- Database: `hxmc` | -- 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 ; | ||
| -- -------------------------------------------------------- | -- -------------------------------------------------------- | ||
| Line 58: | Line 72: | ||
| `MediaPathId` int(11) unsigned NOT NULL AUTO_INCREMENT, | `MediaPathId` int(11) unsigned NOT NULL AUTO_INCREMENT, | ||
| `unc_url` text NOT NULL, | `unc_url` text NOT NULL, | ||
| + | `pathType` int(10) unsigned NOT NULL, | ||
| `username` text NOT NULL, | `username` text NOT NULL, | ||
| `password` text NOT NULL, | `password` text NOT NULL, | ||
| Line 91: | Line 106: | ||
| `isAdmin` tinyint(1) NOT NULL, | `isAdmin` tinyint(1) NOT NULL, | ||
| PRIMARY KEY (`Userid`) | PRIMARY KEY (`Userid`) | ||
| - | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | + | ) 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); | ||
| -- -------------------------------------------------------- | -- -------------------------------------------------------- | ||
hxmc/user_database.1382962543.txt.gz · Last modified: 2013/10/28 07:15 by tschulz
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
