View file database.sql

File size: 1.64Kb 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE TABLE IF NOT EXISTS `files` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `password` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `time` bigint(20) NOT NULL,
  `downloaded` bigint(20) NOT NULL,
  `userid` bigint(20) NOT NULL,
  `report` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

INSERT INTO `settings` (`id`, `name`, `value`) VALUES
(1, 'name', 'Up.DDViet.VN - Sharing Files'),
(2, 'header', '<img src=\\"http://ddviet.vn/digitalvb/tech2in/tech2in_base/tech2_logo.png\\" alt=\\"Logo\\"/>'),
(3, 'note', 'Chào mừng bạn đến với wap ! Miễn phí 100MB dung lượng cho mỗi thành viên, hãy tham gia để cùng chia sẽ tệp tin.\r\n<hr>\r\nWelcome to wap! Free 100 MB diskpace, you must signup to upload files!'),
(4, 'upmax', '100'),
(5, 'signup', '1');

CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mail` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `lv` int(1) NOT NULL DEFAULT '0',
  `disk` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `users` (`id`, `mail`, `password`, `lv`, `disk`) VALUES
(1, 'admin', MD5('123456'), 2, 0);