思加

個人項目計畫
Post Reply
ejsoon
Site Admin
Posts: 2838
Joined: 2016 Jan 10, 22:15

思加

Post by ejsoon » 2017 Sep 06, 17:37

每個人貢獻一個主意或靈感,大家就會有很多。

ejsoon
Site Admin
Posts: 2838
Joined: 2016 Jan 10, 22:15

Re: 思加

Post by ejsoon » 2017 Sep 06, 17:37

Code: Select all

CREATE DATABASE  IF NOT EXISTS `idea_mix` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `idea_mix`;
-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: localhost    Database: idea_mix
-- ------------------------------------------------------
-- Server version	5.5.5-10.1.21-MariaDB

/*!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 `im_system`
--

DROP TABLE IF EXISTS `im_system`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `im_system` (
  `systemid` int(11) NOT NULL COMMENT '主id',
  `create_userid` int(11) NOT NULL COMMENT '創建者id',
  `create_time` datetime NOT NULL COMMENT '創建時間',
  `valid` tinyint(4) NOT NULL DEFAULT '1' COMMENT '有效',
  PRIMARY KEY (`systemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='主表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `im_system`
--

LOCK TABLES `im_system` WRITE;
/*!40000 ALTER TABLE `im_system` DISABLE KEYS */;
/*!40000 ALTER TABLE `im_system` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `im_system_detail`
--

DROP TABLE IF EXISTS `im_system_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `im_system_detail` (
  `systemid` int(11) NOT NULL COMMENT '主id',
  `topical` varchar(45) NOT NULL COMMENT '主題',
  `start_time` datetime NOT NULL COMMENT '開始時間',
  `end_time` datetime NOT NULL COMMENT '結束時間',
  `publish_time` datetime NOT NULL COMMENT '發表結果時間',
  `index_html` text COMMENT '回答頁面',
  `result_html` text COMMENT '顯示結果頁',
  `zh_no` varchar(15) DEFAULT NULL COMMENT '中文序號(如「第七期」)',
  `topical_placeholder` varchar(45) DEFAULT NULL COMMENT '主題預填字',
  `comment_placeholder` varchar(45) DEFAULT NULL COMMENT '評論預填字',
  PRIMARY KEY (`systemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='主表詳情';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `im_system_detail`
--

LOCK TABLES `im_system_detail` WRITE;
/*!40000 ALTER TABLE `im_system_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `im_system_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `im_topical`
--

DROP TABLE IF EXISTS `im_topical`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `im_topical` (
  `topicalid` int(11) NOT NULL AUTO_INCREMENT COMMENT '主題id',
  `systemid` int(11) NOT NULL COMMENT '主id',
  `userid` int(11) NOT NULL COMMENT '用戶id',
  `reply` varchar(45) DEFAULT NULL COMMENT '回答',
  `comment` varchar(145) DEFAULT NULL COMMENT '評論',
  PRIMARY KEY (`topicalid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='主題表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `im_topical`
--

LOCK TABLES `im_topical` WRITE;
/*!40000 ALTER TABLE `im_topical` DISABLE KEYS */;
/*!40000 ALTER TABLE `im_topical` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `im_user`
--

DROP TABLE IF EXISTS `im_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `im_user` (
  `userid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(45) NOT NULL COMMENT '用戶姓名',
  `nickname` varchar(45) DEFAULT NULL COMMENT '用戶昵稱',
  `intro` varchar(4) NOT NULL COMMENT '邀請碼',
  `password` varchar(45) DEFAULT NULL COMMENT '登入密碼',
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '得分',
  `degree` int(11) NOT NULL DEFAULT '3' COMMENT '等級(1管理員,2高級用戶,3普通用戶)',
  `comefrom` varchar(45) DEFAULT NULL COMMENT '來自',
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用戶表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `im_user`
--

LOCK TABLES `im_user` WRITE;
/*!40000 ALTER TABLE `im_user` DISABLE KEYS */;
INSERT INTO `im_user` VALUES (1,'尹卂',NULL,'FE77',NULL,0,1,NULL);
/*!40000 ALTER TABLE `im_user` 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 2017-09-06 17:34:51

ejsoon
Site Admin
Posts: 2838
Joined: 2016 Jan 10, 22:15

Re: 思加

Post by ejsoon » 2017 Sep 08, 16:10

改名「知和,思加」

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest