svnno****@sourc*****
svnno****@sourc*****
2012年 5月 7日 (月) 00:15:47 JST
ForkRevision: 104
http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=104
Author: hryksbt
Date: 2012-05-07 00:15:47 +0900 (Mon, 07 May 2012)
Log Message:
-----------
カード会社マスタと、国マスタを追加したDump
Modified Paths:
--------------
trunk/Documents/DBテーブル定義(ユーザ管理DB).xlsx
Added Paths:
-----------
trunk/Database/SmartEngineDB.sql
Removed Paths:
-------------
trunk/Database/SmartEngineDB_users.sql
-------------- next part --------------
Added: trunk/Database/SmartEngineDB.sql
===================================================================
--- trunk/Database/SmartEngineDB.sql (rev 0)
+++ trunk/Database/SmartEngineDB.sql 2012-05-06 15:15:47 UTC (rev 104)
@@ -0,0 +1,118 @@
+-- MySQL dump 10.13 Distrib 5.1.62, for apple-darwin10.3.0 (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 `credit_campanies`
+--
+
+DROP TABLE IF EXISTS `credit_campanies`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `credit_campanies` (
+ `id` int(11) NOT NULL,
+ `campany_name` varchar(64) NOT NULL,
+ `delete_flag` int(11) NOT NULL,
+ `regist_date` datetime NOT NULL,
+ `modify_date` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `credit_campanies`
+--
+
+LOCK TABLES `credit_campanies` WRITE;
+/*!40000 ALTER TABLE `credit_campanies` DISABLE KEYS */;
+/*!40000 ALTER TABLE `credit_campanies` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `new_table`
+--
+
+DROP TABLE IF EXISTS `new_table`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `new_table` (
+ `id` int(11) NOT NULL,
+ `country_name` varchar(64) NOT NULL,
+ `delete_flag` int(11) NOT NULL,
+ `regist_date` datetime NOT NULL,
+ `modify_date` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `new_table`
+--
+
+LOCK TABLES `new_table` WRITE;
+/*!40000 ALTER TABLE `new_table` DISABLE KEYS */;
+/*!40000 ALTER TABLE `new_table` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- 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-07 0:13:25
Deleted: trunk/Database/SmartEngineDB_users.sql
===================================================================
--- trunk/Database/SmartEngineDB_users.sql 2012-05-06 14:45:18 UTC (rev 103)
+++ trunk/Database/SmartEngineDB_users.sql 2012-05-06 15:15:47 UTC (rev 104)
@@ -1,68 +0,0 @@
-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
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)