:::

3-1 上課範例:tad0616.sql

CREATE TABLE `tad_notes` (
  `note_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cate_sn` smallint(5) unsigned NOT NULL,
  `note_title` varchar(255) NOT NULL,
  `note_content` mediumtext NOT NULL,
  `note_date` datetime NOT NULL,
  `note_public` enum('1','0') NOT NULL,
  `note_count` smallint(5) unsigned NOT NULL,
  `uid` smallint(5) unsigned NOT NULL,
  `note_sort` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`note_sn`)
) ENGINE=MyISAM ;

CREATE TABLE `tad_note_cate` (
  `cate_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cate_title` varchar(255) NOT NULL,
  `cate_sort` smallint(5) unsigned NOT NULL,
  `cate_enable` enum('1','0') NOT NULL,
  `cate_count` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`cate_sn`)
) ENGINE=MyISAM ;

:::

搜尋

QR Code 區塊

https%3A%2F%2Fwww.tad0616.net%2Fmodules%2Ftad_book3%2Fpage.php%3Ftbsn%3D22%26tbdsn%3D597

書籍目錄

展開 | 闔起

線上使用者

33人線上 (6人在瀏覽線上書籍)

會員: 0

訪客: 33

更多…