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 ;