svnno****@sourc*****
svnno****@sourc*****
2011年 4月 26日 (火) 23:48:10 JST
ForkRevision: 19
http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=19
Author: hryksbt
Date: 2011-04-26 23:48:09 +0900 (Tue, 26 Apr 2011)
Log Message:
-----------
Added Paths:
-----------
trunk/Database/
trunk/Database/dump.sql
-------------- next part --------------
Added: trunk/Database/dump.sql
===================================================================
--- trunk/Database/dump.sql (rev 0)
+++ trunk/Database/dump.sql 2011-04-26 14:48:09 UTC (rev 19)
@@ -0,0 +1,75 @@
+-- phpMyAdmin SQL Dump
+-- version 3.2.4
+-- http://www.phpmyadmin.net
+--
+-- ホスト: localhost
+-- 生成時間: 2011 年 4 月 26 日 23:45
+-- サーバのバージョン: 5.1.41
+-- PHP のバージョン: 5.3.1
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!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 */;
+
+--
+-- データベース: `upload`
+--
+CREATE DATABASE `upload` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
+USE `upload`;
+
+-- --------------------------------------------------------
+
+--
+-- テーブルの構造 `data_info`
+--
+
+CREATE TABLE IF NOT EXISTS `data_info` (
+ `filename` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
+ `uploaddate` datetime NOT NULL,
+ `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
+ `data_size` int(10) NOT NULL,
+ `rank` int(3) DEFAULT NULL,
+ UNIQUE KEY `index_filename` (`filename`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- テーブルのデータをダンプしています `data_info`
+--
+
+INSERT INTO `data_info` (`filename`, `uploaddate`, `username`, `data_size`, `rank`) VALUES
+('aaa.jpg', '2011-04-18 00:00:00', NULL, 666, NULL),
+('bbb', '2011-04-18 23:49:46', NULL, 777, NULL),
+('test.txt', '2011-04-26 00:50:36', NULL, 20, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- テーブルの構造 `user_info`
+--
+
+CREATE TABLE IF NOT EXISTS `user_info` (
+ `userid` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ `fullname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+ `country_code` smallint(6) NOT NULL,
+ `add_date` datetime NOT NULL,
+ `change_date` datetime DEFAULT NULL,
+ `email` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+ `frag` tinyint(1) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`userid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- テーブルのデータをダンプしています `user_info`
+--
+
+INSERT INTO `user_info` (`userid`, `password`, `fullname`, `country_code`, `add_date`, `change_date`, `email`, `frag`) VALUES
+('a', 'aaa', 'aaa', 1, '2011-04-26 23:34:00', NULL, 'aaa', 0);
+
+/*!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 */;