Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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: `dropbin`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `file`
- --
- CREATE TABLE IF NOT EXISTS `file` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `file_name` VARCHAR(256) NOT NULL,
- `file_size` BIGINT(20) NOT NULL,
- `file_comment` VARCHAR(256) NOT NULL,
- `file_permission_id` INT(11) NOT NULL,
- `file_user_id` INT(11) NOT NULL COMMENT 'owner',
- `file_folder_id` INT(11) NOT NULL,
- `folder_dt_created` datetime NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;
- --
- -- Dumping data for table `file`
- --
- INSERT INTO `file` (`id`, `file_name`, `file_size`, `file_comment`, `file_permission_id`, `file_user_id`, `file_folder_id`, `folder_dt_created`) VALUES
- (10, 'RBH Data Centre Modelling __.pdf', 51870, '', 0, 0, 0, '0000-00-00 00:00:00'),
- (11, 'RBH Data Centre Modelling __.pdf', 51870, '', 0, 0, 0, '0000-00-00 00:00:00'),
- (30, 'RBH Data Centre Modelling Final.pdf', 1394565, 'Sample Comment', 1, 9, 1, '2014-12-19 20:02:39'),
- (31, 'RBH Data Centre Modelling v2.pdf', 260205, 'Sample Comment', 1, 9, 1, '2014-12-19 20:09:59'),
- (32, 'Lewisham and Greenwich NHS Trust proposed solution.docx', 20297, 'Sample Comment', 1, 9, 1, '2014-12-19 20:10:11'),
- (33, 'RBH Data Centre Modelling v2.pdf', 260205, 'Sample Comment', 2, 9, 2, '2014-12-19 20:10:57');
- -- --------------------------------------------------------
- --
- -- Table structure for table `folder`
- --
- CREATE TABLE IF NOT EXISTS `folder` (
- `folder_id` INT(11) NOT NULL AUTO_INCREMENT,
- `folder_name` VARCHAR(500) NOT NULL,
- `folder_comment` VARCHAR(500) NOT NULL,
- `folder_user_id` INT(11) NOT NULL,
- `folder_size` INT(11) NOT NULL,
- PRIMARY KEY (`folder_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
- --
- -- Dumping data for table `folder`
- --
- INSERT INTO `folder` (`folder_id`, `folder_name`, `folder_comment`, `folder_user_id`, `folder_size`) VALUES
- (1, 'test', 'DEFAULT', 9, 0),
- (2, 'asdf', 'asdfadf', 9, 0),
- (3, 'asdf', 'asdf', 9, 0),
- (4, 'asdfadf', 'ddd', 9, 0),
- (5, '', '', 9, 0),
- (6, 'album2', 'asdfasf', 9, 0),
- (7, 'Test2', '', 7, 0),
- (8, 'new', 'DEFAULT', 10, 0),
- (9, 'test2', '', 10, 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `user`
- --
- CREATE TABLE IF NOT EXISTS `user` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `username` VARCHAR(50) NOT NULL,
- `password` VARCHAR(50) NOT NULL,
- `first_name` VARCHAR(50) NOT NULL,
- `last_name` VARCHAR(50) NOT NULL,
- `email` VARCHAR(50) NOT NULL,
- `avatar` VARCHAR(50) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
- --
- -- Dumping data for table `user`
- --
- INSERT INTO `user` (`id`, `username`, `password`, `first_name`, `last_name`, `email`, `avatar`) VALUES
- (6, 'tndfr2', 'dcfd1bb8695ad49fb1464baa39d5c4e9', 'bbbbb', 'nas', 'taibi', ''),
- (7, 'tndfr', 'c67740361b823eaec68d599ad1c3b9e2', 'nas', 'taibi', 'tndfr@hotmail.com', ''),
- (9, 'test', '098f6bcd4621d373cade4e832627b4f6', 'test', 'test', 'test', ''),
- (10, 'new', '22af645d1859cb5ca6da0c484f1f37ea', 'new', 'new', 'new', '');
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement