CREATE TABLE `column` (
  `id` int(11) NOT NULL auto_increment,
  `columnname` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=19 ;

CREATE TABLE `comment` (
  `id` int(11) NOT NULL auto_increment,
  `user` text NOT NULL,
  `comment` text NOT NULL,
  `date` datetime NOT NULL,
  `tid` int(11) NOT NULL COMMENT 'id',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=37 ;

CREATE TABLE `diary` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `date` date NOT NULL,
  `hit` int(11) NOT NULL default '0',
  `cid` int(11) NOT NULL COMMENT 'Ŀid',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=71 ;

CREATE TABLE `otherinfo` (
  `info` text NOT NULL,
  `notice` text NOT NULL,
  `link` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;



INSERT INTO `otherinfo` (`info`, `notice`, `link`) VALUES 
('<p>ں̨</p>', '<p>ں̨</p>', '<p>ں̨</p>');
