- เครดิต
- 69
- เพื่อน
- ทักทาย
- บล็อก
- อัลบั้ม
- โพสต์
- กระทู้
- แชร์
- สำคัญ
- สิทธิ์อ่าน
- 10
- จำนวนผู้ติดตาม
- จำนวนผู้กำลังติดตาม
- เพศ
- ไม่บอก
|
-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 11, 2008 at 08:30 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `dz`
--
-- --------------------------------------------------------
--
-- Table structure for table `cdb_photo`
--
CREATE TABLE `cdb_photo` (
`id` int(11) NOT NULL auto_increment,
`cid` int(20) NOT NULL COMMENT '??ID',
`uid` int(15) NOT NULL COMMENT '????id',
`uploadsize` int(10) NOT NULL COMMENT '????',
`uploaddir` varchar(100) character set utf8 NOT NULL COMMENT '????',
`uploadtime` int(10) NOT NULL COMMENT '????',
`photoname` varchar(20) character set utf8 NOT NULL COMMENT '????',
PRIMARY KEY (`id`),
KEY `cid` (`cid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=10 ;
--
-- Dumping data for table `cdb_photo`
--
-- --------------------------------------------------------
--
-- Table structure for table `cdb_photo_type`
--
CREATE TABLE `cdb_photo_type` (
`id` int(11) NOT NULL auto_increment,
`uid` int(20) NOT NULL COMMENT '??ID',
`typename` char(50) character set utf8 NOT NULL COMMENT '????',
`trad` char(255) character set utf8 NOT NULL COMMENT '??',
`addtime` datetime NOT NULL,
`updatetime` datetime NOT NULL,
`isshow` int(1) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=6 ;
--
-- Dumping data for table `cdb_photo_type`
--
-- --------------------------------------------------------
--
-- Table structure for table `cdb_photo_user`
--
CREATE TABLE `cdb_photo_user` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL COMMENT '??ID',
`photoname` varchar(20) character set utf8 NOT NULL COMMENT '????',
`uploadsize` int(20) NOT NULL COMMENT '????',
`uploadtype` varchar(255) character set utf8 NOT NULL COMMENT '????',
`photonum` int(20) NOT NULL,
`addtime` datetime NOT NULL,
`updatetime` datetime NOT NULL,
`trad` char(255) character set utf8 NOT NULL,
`orderid` int(10) NOT NULL default '255',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `orderid` (`orderid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=6 ;
--
-- Dumping data for table `cdb_photo_user`
-- |
|