SmartUpload

Fork

[Smartupload-svn] [34] mysqldumpデータ更新

svnno****@sourc***** svnno****@sourc*****
2011年 5月 6日 (金) 01:58:44 JST

• 前の記事 [Smartupload-svn] [33] テストデータ追加
• 次の記事 [Smartupload-svn] [35]
• 記事の並び順: [ 日付 ] [ スレッド ] [ 件名 ] [ 著者 ]

Revision: 34
          http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=34
Author:   hryksbt
Date:     2011-05-06 01:58:44 +0900 (Fri, 06 May 2011)

Log Message:
-----------
mysqldumpデータ更新

Modified Paths:
--------------
    trunk/Database/dump.sql

Added Paths:
-----------
    trunk/SmartUpload/data/aaa.jpg.r0
    trunk/SmartUpload/data/aaa.jpg.r7


-------------- next part --------------
Modified: trunk/Database/dump.sql
===================================================================
--- trunk/Database/dump.sql	2011-05-05 16:54:58 UTC (rev 33)
+++ trunk/Database/dump.sql	2011-05-05 16:58:44 UTC (rev 34)
@@ -1,75 +1,117 @@
--- phpMyAdmin SQL Dump
--- version 3.2.4
--- http://www.phpmyadmin.net
+-- MySQL dump 10.13  Distrib 5.1.41, for Win32 (ia32)
 --
--- ホスト: localhost
--- 生成時間: 2011 年 4 月 26 日 23:45
--- サーバのバージョン: 5.1.41
--- PHP のバージョン: 5.3.1
+-- Host: localhost    Database: upload
+-- ------------------------------------------------------
+-- Server version	5.1.41
 
-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 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
 --
--- データベース: `upload`
+-- Table structure for table `category`
 --
-CREATE DATABASE `upload` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-USE `upload`;
 
--- --------------------------------------------------------
+DROP TABLE IF EXISTS `category`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `category` (
+  `cat_number` smallint(6) NOT NULL AUTO_INCREMENT,
+  `cat_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+  PRIMARY KEY (`cat_number`),
+  UNIQUE KEY `index_cat_name` (`cat_name`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- テーブルの構造 `data_info`
+-- Dumping data for table `category`
 --
 
-CREATE TABLE IF NOT EXISTS `data_info` (
+LOCK TABLES `category` WRITE;
+/*!40000 ALTER TABLE `category` DISABLE KEYS */;
+INSERT INTO `category` VALUES (3,'application'),(1,'music'),(2,'photo');
+/*!40000 ALTER TABLE `category` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `data_info`
+--
+
+DROP TABLE IF EXISTS `data_info`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `data_info` (
+  `num` bigint(20) NOT NULL AUTO_INCREMENT,
+  `contentname` varchar(64) NOT NULL,
   `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,
+  `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
   `data_size` int(10) NOT NULL,
   `rank` int(3) DEFAULT NULL,
+  `category` smallint(6) NOT NULL,
+  `comment` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
+  PRIMARY KEY (`num`),
   UNIQUE KEY `index_filename` (`filename`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- テーブルのデータをダンプしています `data_info`
+-- Dumping data for table `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);
+LOCK TABLES `data_info` WRITE;
+/*!40000 ALTER TABLE `data_info` DISABLE KEYS */;
+INSERT INTO `data_info` VALUES (1,'','aaa.jpg','2011-04-18 00:00:00','a',666,NULL,0,'ああああああああ'),(2,'','bbb','2011-04-18 23:49:46','',777,NULL,0,''),(3,'','test.txt','2011-04-26 00:50:36','',20,NULL,0,''),(4,'3','test2.txt','2011-05-06 01:35:08','a',9092,NULL,3,'test2');
+/*!40000 ALTER TABLE `data_info` ENABLE KEYS */;
+UNLOCK TABLES;
 
--- --------------------------------------------------------
-
 --
--- テーブルの構造 `user_info`
+-- Table structure for table `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,
+DROP TABLE IF EXISTS `user_info`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user_info` (
+  `num` bigint(20) NOT NULL AUTO_INCREMENT,
+  `userid` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+  `fullname` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin 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;
+  `charge` tinyint(1) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`num`),
+  UNIQUE KEY `index_email` (`email`)
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- テーブルのデータをダンプしています `user_info`
+-- Dumping data for table `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);
+LOCK TABLES `user_info` WRITE;
+/*!40000 ALTER TABLE `user_info` DISABLE KEYS */;
+INSERT INTO `user_info` VALUES (1,'b','bbb','BBB',1,'2011-05-01 00:29:57',NULL,'',0,0),(2,'a','aaa','AAA',1,'2011-04-26 23:34:00',NULL,'aaa',0,0);
+/*!40000 ALTER TABLE `user_info` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 /*!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 */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2011-05-06  1:56:05

Added: trunk/SmartUpload/data/aaa.jpg.r7
===================================================================
(Binary files differ)


Property changes on: trunk/SmartUpload/data/aaa.jpg.r7
___________________________________________________________________
Added: svn:mime-type
   + application/octet-stream

• 前の記事 [Smartupload-svn] [33] テストデータ追加
• 次の記事 [Smartupload-svn] [35]
• 記事の並び順: [ 日付 ] [ スレッド ] [ 件名 ] [ 著者 ]