Project

Profile

Help

HostedRedmine.com has moved to the Planio platform. All logins and passwords remained the same. All users will be able to login and use Redmine just as before. Read more...

Task #219085 » fashion.sql

必要なテーブルを作成するSQLです。 - sorahiro yoshida, 2013-09-21 08:20 PM

 
-- phpMyAdmin SQL Dump
-- version 4.0.4.1
-- http://www.phpmyadmin.net
--
-- ホスト: localhost
-- 生成日時: 2013 年 9 月 21 日 18:38
-- サーバのバージョン: 5.5.31
-- PHP のバージョン: 5.4.19

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- データベース: `fashion`
--
CREATE DATABASE IF NOT EXISTS `fashion` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `fashion`;

-- --------------------------------------------------------

--
-- テーブルの構造 `Item`
--

CREATE TABLE IF NOT EXISTS `Item` (
`Item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`imge_url` text NOT NULL,
`create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`del_flg` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`Item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- テーブルの構造 `ItemData`
--

CREATE TABLE IF NOT EXISTS `ItemData` (
`itemdata_id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`name` text NOT NULL,
`brand` text NOT NULL,
`color` text NOT NULL,
`year` int(11) NOT NULL,
`tag` text NOT NULL,
`modify_date` date NOT NULL,
PRIMARY KEY (`itemdata_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- テーブルの構造 `ItemLink`
--

CREATE TABLE IF NOT EXISTS `ItemLink` (
`itemlink_id` int(11) NOT NULL,
`surch_id` int(11) NOT NULL COMMENT 'リンク元',
`dest_id` int(11) NOT NULL COMMENT 'リンク先',
`modify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`del_flg` int(11) NOT NULL DEFAULT '0' COMMENT '1:削除',
`link_type` int(11) NOT NULL COMMENT '1:上、2:下、3:同、4:斜め',
PRIMARY KEY (`itemlink_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- テーブルの構造 `User`
--

CREATE TABLE IF NOT EXISTS `User` (
`user_id` int(11) NOT NULL,
`name` text NOT NULL,
`email` text NOT NULL,
`password` text NOT NULL,
`create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'fashion application DB',
`del_flg` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!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 */;
    (1-1/1)