[101] usersテーブルのみ作成 (Smartupload-svn) - SmartUpload

Revision: 101
          http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=101
Author:   hryksbt
Date:     2012-05-06 00:26:01 +0900 (Sun, 06 May 2012)
Log Message:
-----------
usersテーブルのみ作成

Modified Paths:
--------------
    trunk/Documents/DBテーブル定義(ユーザ管理DB).xlsx
    trunk/Documents/SmartUpload_ユーザ管理DB_ER図.a5er

Added Paths:
-----------
    tags/SmartUpload.20120331/dump.sql
    trunk/Database/SmartEngineDB_users.sql

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

-------------- next part --------------
Added: tags/SmartUpload.20120331/dump.sql
===================================================================

--- tags/SmartUpload.20120331/dump.sql	                        (rev 0)
+++ tags/SmartUpload.20120331/dump.sql	2012-05-05 15:26:01 UTC (rev 101)
@@ -0,0 +1,143 @@
+-- MySQL dump 10.13  Distrib 5.5.8, for Win32 (x86)
+--
+-- Host: localhost    Database: upload
+-- ------------------------------------------------------
+-- Server version	5.5.8
+
+/*!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 */;
+
+--
+-- Table structure for table `category`
+--
+
+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=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `category`
+--
+
+LOCK TABLES `category` WRITE;
+/*!40000 ALTER TABLE `category` DISABLE KEYS */;
+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`
+--
+
+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) CHARACTER SET latin1 NOT NULL,
+  `filename` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `uploaddate` datetime NOT NULL,
+  `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) COLLATE utf8_unicode_ci NOT NULL,
+  PRIMARY KEY (`num`),
+  UNIQUE KEY `index_filename` (`filename`)
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `data_info`
+--
+
+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'),(5,'lll','dump.sql','2011-08-31 01:03:47','a',4752,NULL,1,'lll');
+/*!40000 ALTER TABLE `data_info` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `user_info`
+--
+
+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',
+  `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 */;
+
+--
+-- Dumping data for table `user_info`
+--
+
+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-10-15  1:53:15

Added: trunk/Database/SmartEngineDB_users.sql
===================================================================
--- trunk/Database/SmartEngineDB_users.sql	                        (rev 0)
+++ trunk/Database/SmartEngineDB_users.sql	2012-05-05 15:26:01 UTC (rev 101)
@@ -0,0 +1,68 @@
+CREATE DATABASE  IF NOT EXISTS `smartenginedb` /*!40100 DEFAULT CHARACTER SET latin1 */;
+USE `SmartEngineDB`;
+-- MySQL dump 10.13  Distrib 5.5.16, for osx10.5 (i386)
+--
+-- Host: localhost    Database: SmartEngineDB
+-- ------------------------------------------------------
+-- Server version	5.1.62
+
+/*!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 */;
+
+--
+-- Table structure for table `users`
+--
+
+DROP TABLE IF EXISTS `users`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `users` (
+  `id` int(11) NOT NULL,
+  `account` varchar(64) NOT NULL,
+  `password` varchar(64) NOT NULL,
+  `name` varchar(64) NOT NULL,
+  `address` varchar(128) NOT NULL,
+  `campany` varchar(64) DEFAULT NULL,
+  `country_id` int(11) NOT NULL,
+  `mail_address` varchar(64) NOT NULL,
+  `delete_flag` int(11) NOT NULL,
+  `accounting_flag` int(11) NOT NULL,
+  `credit_number` int(11) DEFAULT NULL,
+  `credit_expire` datetime DEFAULT NULL,
+  `credit_campany_id` int(11) DEFAULT NULL,
+  `bank_id` int(11) DEFAULT NULL,
+  `bank_account_number` int(11) DEFAULT NULL,
+  `create_date` datetime NOT NULL,
+  `modify_date` datetime DEFAULT NULL,
+  `application_date` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `users`
+--
+
+LOCK TABLES `users` WRITE;
+/*!40000 ALTER TABLE `users` DISABLE KEYS */;
+/*!40000 ALTER TABLE `users` 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 2012-05-06  0:24:22

Deleted: trunk/Database/dump.sql
===================================================================
--- trunk/Database/dump.sql	2012-05-05 10:17:29 UTC (rev 100)
+++ trunk/Database/dump.sql	2012-05-05 15:26:01 UTC (rev 101)
@@ -1,143 +0,0 @@
--- MySQL dump 10.13  Distrib 5.5.8, for Win32 (x86)
---
--- Host: localhost    Database: upload
--- ------------------------------------------------------
--- Server version	5.5.8
-
-/*!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 */;
-
---
--- Table structure for table `category`
---
-
-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=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `category`
---
-
-LOCK TABLES `category` WRITE;
-/*!40000 ALTER TABLE `category` DISABLE KEYS */;
-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`
---
-
-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) CHARACTER SET latin1 NOT NULL,
-  `filename` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
-  `uploaddate` datetime NOT NULL,
-  `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) COLLATE utf8_unicode_ci NOT NULL,
-  PRIMARY KEY (`num`),
-  UNIQUE KEY `index_filename` (`filename`)
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `data_info`
---
-
-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'),(5,'lll','dump.sql','2011-08-31 01:03:47','a',4752,NULL,1,'lll');
-/*!40000 ALTER TABLE `data_info` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `user_info`
---
-
-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',
-  `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 */;
-
---
--- Dumping data for table `user_info`
---
-
-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-10-15  1:53:15

Modified: trunk/Documents/DB?\227?\131?\134?\227?\131?\188?\227?\131?\150?\227?\131?\171?\229?\174?\154?\231?\190?\169(?\227?\131?\166?\227?\131?\188?\227?\130?\182?\231?\174?\161?\231?\144?\134DB).xlsx
===================================================================
(Binary files differ)

Modified: trunk/Documents/SmartUpload_?\227?\131?\166?\227?\131?\188?\227?\130?\182?\231?\174?\161?\231?\144?\134DB_ER?\229?\155?\179.a5er
===================================================================


SmartUpload
Fork

[Smartupload-svn] [101] usersテーブルのみ作成

SmartUpload Fork

[Smartupload-svn] [101] usersテーブルのみ作成

SmartUpload
Fork