fork(1) download
copy 
  1. -- phpMyAdmin SQL Dump
  2. -- version 2.10.3
  3. -- http://w...content-available-to-author-only...n.net
  4. -- 
  5. -- 主機: localhost
  6. -- 建立日期: Aug 17, 2015, 07:21 AM
  7. -- 伺服器版本: 6.0.4
  8. -- PHP 版本: 6.0.0-dev
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. -- 
  13. -- 資料庫: `xanxus`
  14. -- 
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. -- 
  19. -- 資料表格式： `bag`
  20. -- 
  21.  
  22. CREATE TABLE `bag` (
  23.   `id` smallint(9) DEFAULT NULL,
  24.   `relatedID` smallint(9) DEFAULT NULL,
  25.   `序號` int(11) NOT NULL AUTO_INCREMENT,
  26.   `發包日期` date DEFAULT NULL,
  27.   `專案別` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  28.   `發案者` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  29.   `委外類別` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  30.   `委外工作內容` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  31.   `外包人員` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  32.   `外包金額` int(20) DEFAULT NULL,
  33.   `分期` int(20) DEFAULT NULL,
  34.   `比例` float(5,2) DEFAULT NULL,
  35.   `分期金額` float(7,2) DEFAULT NULL,
  36.   `扣款` int(20) DEFAULT NULL,
  37.   `扣款事由` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  38.   `實付金額` int(20) DEFAULT NULL,
  39.   `交件日期` date DEFAULT NULL,
  40.   `請款日期` date DEFAULT NULL,
  41.   `付款日期` date DEFAULT NULL,
  42.   `請款憑據` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  43.   `備註` text COLLATE utf8_unicode_ci,
  44.   PRIMARY KEY (`序號`),
  45.   KEY `caseid` (`id`),
  46.   KEY `relatedID` (`relatedID`)
  47. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
  48.  
  49. -- 
  50. -- 列出以下資料庫的數據： `bag`
  51. -- 
  52.  
  53. INSERT INTO `bag` VALUES (216, 96, 10, '2015-08-01', '專案1', 'andy', '視覺設計', 'afsddfgfdg', 'selina', 1400, 8, 12.50, 175.00, 100, 'hfgh', 1000, '2015-08-02', '2015-08-03', '2015-08-05', 'dfgsdfg', 'dfg');
  54. INSERT INTO `bag` VALUES (216, 96, 16, '0000-00-00', '專案1', '', '內容專家', '', '', 0, 0, 0.00, 0.00, 0, '', 0, '0000-00-00', '0000-00-00', '0000-00-00', '', '');
  55. INSERT INTO `bag` VALUES (216, 96, 17, '0000-00-00', '專案1', '', '影音後製', '', '', 0, 0, 0.00, 0.00, 0, '', 0, '0000-00-00', '0000-00-00', '0000-00-00', '', '');
  56.  
  57. -- 
  58. -- 備份資料表限制
  59. -- 
  60.  
  61. -- 
  62. -- 資料表限制 `bag`
  63. -- 
  64. ALTER TABLE `bag`
  65.   ADD CONSTRAINT `bag_ibfk_1` FOREIGN KEY (`id`) REFERENCES `case` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  66.  
Success #stdin #stdout #stderr 0s 3392KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 10: near "SET": syntax error
Error: near line 22: near "AUTO_INCREMENT": syntax error
Error: near line 53: no such table: bag
Error: near line 54: no such table: bag
Error: near line 55: no such table: bag
Error: near line 64: no such table: bag
https://ideone.com/QH3jV5
language:
SQLite (sqlite 3.27.2)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!