svnno****@sourc*****
svnno****@sourc*****
2012年 6月 10日 (日) 01:09:44 JST
ForkRevision: 126
http://sourceforge.jp/projects/smartupload/scm/svn/commits/126
Author: hryksbt
Date: 2012-06-10 01:09:44 +0900 (Sun, 10 Jun 2012)
Log Message:
-----------
モデル再作成&DB構成更新
Modified Paths:
--------------
trunk/Database/SmartEngineDB.sql
trunk/Documents/DBテーブル定義(ユーザ管理DB).xlsx
trunk/Documents/SmartUpload_ユーザ管理DB_ER図.a5er
trunk/Documents/proposal/DigitalContentsUp&Down.ppt
trunk/src/Engine/app/tests/cases/models/branch.test.php
trunk/src/Engine/app/tests/fixtures/attribute_fixture.php
trunk/src/Engine/app/tests/fixtures/bank_fixture.php
trunk/src/Engine/app/tests/fixtures/branch_fixture.php
trunk/src/Engine/app/tests/fixtures/category_fixture.php
trunk/src/Engine/app/tests/fixtures/content_fixture.php
trunk/src/Engine/app/tests/fixtures/credit_campany_fixture.php
trunk/src/Engine/app/tests/fixtures/nationality_fixture.php
trunk/src/Engine/app/tests/fixtures/user_fixture.php
trunk/src/Engine/app/tests/fixtures/user_modify_fixture.php
-------------- next part --------------
Modified: trunk/Database/SmartEngineDB.sql
===================================================================
--- trunk/Database/SmartEngineDB.sql 2012-06-06 16:41:25 UTC (rev 125)
+++ trunk/Database/SmartEngineDB.sql 2012-06-09 16:09:44 UTC (rev 126)
@@ -79,7 +79,6 @@
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `branches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
- `bank_name` varchar(64) NOT NULL,
`branch_name` varchar(64) NOT NULL,
`delete_flag` tinyint(1) NOT NULL,
`regist_date` datetime NOT NULL,
@@ -155,15 +154,15 @@
UNLOCK TABLES;
--
--- Table structure for table `credit_campanies`
+-- Table structure for table `countries`
--
-DROP TABLE IF EXISTS `credit_campanies`;
+DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `credit_campanies` (
+CREATE TABLE `countries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
- `campany_name` varchar(64) NOT NULL,
+ `country_name` varchar(64) NOT NULL,
`delete_flag` tinyint(1) NOT NULL,
`regist_date` datetime NOT NULL,
`modify_date` datetime NOT NULL,
@@ -172,24 +171,24 @@
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Dumping data for table `credit_campanies`
+-- Dumping data for table `countries`
--
-LOCK TABLES `credit_campanies` WRITE;
-/*!40000 ALTER TABLE `credit_campanies` DISABLE KEYS */;
-/*!40000 ALTER TABLE `credit_campanies` ENABLE KEYS */;
+LOCK TABLES `countries` WRITE;
+/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
+/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;
--
--- Table structure for table `nationalities`
+-- Table structure for table `credits`
--
-DROP TABLE IF EXISTS `nationalities`;
+DROP TABLE IF EXISTS `credits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `nationalities` (
+CREATE TABLE `credits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
- `country_name` varchar(64) NOT NULL,
+ `campany_name` varchar(64) NOT NULL,
`delete_flag` tinyint(1) NOT NULL,
`regist_date` datetime NOT NULL,
`modify_date` datetime NOT NULL,
@@ -198,12 +197,12 @@
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Dumping data for table `nationalities`
+-- Dumping data for table `credits`
--
-LOCK TABLES `nationalities` WRITE;
-/*!40000 ALTER TABLE `nationalities` DISABLE KEYS */;
-/*!40000 ALTER TABLE `nationalities` ENABLE KEYS */;
+LOCK TABLES `credits` WRITE;
+/*!40000 ALTER TABLE `credits` DISABLE KEYS */;
+/*!40000 ALTER TABLE `credits` ENABLE KEYS */;
UNLOCK TABLES;
--
@@ -259,7 +258,7 @@
`accounting_flag` tinyint(1) NOT NULL,
`credit_number` int(11) DEFAULT NULL,
`credit_expire` datetime DEFAULT NULL,
- `credit_campany_id` int(11) DEFAULT NULL,
+ `credit_id` int(11) DEFAULT NULL,
`bank_id` int(11) DEFAULT NULL,
`bank_account_number` int(11) DEFAULT NULL,
`create_date` datetime NOT NULL,
@@ -287,4 +286,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2012-06-07 1:38:57
+-- Dump completed on 2012-06-10 1:07:52
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
===================================================================