svnno****@sourc*****
svnno****@sourc*****
2011年 10月 15日 (土) 01:55:23 JST
ForkRevision: 72
http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=72
Author: hryksbt
Date: 2011-10-15 01:55:23 +0900 (Sat, 15 Oct 2011)
Log Message:
-----------
countryテーブルを追加
Modified Paths:
--------------
trunk/Database/dump.sql
-------------- next part --------------
Modified: trunk/Database/dump.sql
===================================================================
--- trunk/Database/dump.sql 2011-10-09 16:00:39 UTC (rev 71)
+++ trunk/Database/dump.sql 2011-10-14 16:55:23 UTC (rev 72)
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 5.1.41, for Win32 (ia32)
+-- MySQL dump 10.13 Distrib 5.5.8, for Win32 (x86)
--
-- Host: localhost Database: upload
-- ------------------------------------------------------
--- Server version 5.1.41
+-- Server version 5.5.8
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -27,7 +27,7 @@
`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;
+) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -36,11 +36,37 @@
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
-INSERT INTO `category` VALUES (3,'application'),(1,'music'),(2,'photo');
+INSERT INTO `category` VALUES (1,'music'),(2,'photo'),(3,'application');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;
--
+-- Table structure for table `country`
+--
+
+DROP TABLE IF EXISTS `country`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `country` (
+ `num` int(128) NOT NULL AUTO_INCREMENT,
+ `country_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`num`),
+ UNIQUE KEY `num` (`num`),
+ UNIQUE KEY `country_name` (`country_name`)
+) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `country`
+--
+
+LOCK TABLES `country` WRITE;
+/*!40000 ALTER TABLE `country` DISABLE KEYS */;
+INSERT INTO `country` VALUES (1,'アメリカ'),(2,'日本'),(3,'インド'),(4,'ブラジル'),(5,'インドネシア'),(6,'中国');
+/*!40000 ALTER TABLE `country` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `data_info`
--
@@ -49,17 +75,17 @@
/*!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,
+ `contentname` varchar(64) CHARACTER SET latin1 NOT NULL,
+ `filename` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`uploaddate` datetime NOT NULL,
- `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
+ `username` varchar(64) 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,
+ `comment` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`num`),
UNIQUE KEY `index_filename` (`filename`)
-) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -68,7 +94,7 @@
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');
+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'),(5,'lll','dump.sql','2011-08-31 01:03:47','a',4752,NULL,1,'lll');
/*!40000 ALTER TABLE `data_info` ENABLE KEYS */;
UNLOCK TABLES;
@@ -114,4 +140,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2011-05-06 1:56:05
+-- Dump completed on 2011-10-15 1:53:15