SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `addresslist` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` char(8) collate utf8_unicode_ci NOT NULL,
`company` char(60) collate utf8_unicode_ci NOT NULL,
`address` char(60) collate utf8_unicode_ci NOT NULL,
`mobile` char(15) collate utf8_unicode_ci NOT NULL,
`tel` char(30) collate utf8_unicode_ci NOT NULL,
`fax` char(30) collate utf8_unicode_ci NOT NULL,
`qq` char(12) collate utf8_unicode_ci NOT NULL,
`email` char(50) collate utf8_unicode_ci NOT NULL,
`website` char(100) collate utf8_unicode_ci NOT NULL,
`memo` char(100) collate utf8_unicode_ci NOT NULL,
`classid` char(15) collate utf8_unicode_ci NOT NULL,
`edittime` datetime NOT NULL,
`ip` char(16) collate utf8_unicode_ci NOT NULL,
`hittimes` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `admin` (
`id` tinyint(3) unsigned NOT NULL auto_increment,
`adminname` char(10) collate utf8_unicode_ci NOT NULL,
`pwd` char(60) collate utf8_unicode_ci NOT NULL,
`logintime` datetime NOT NULL,
`ip` char(16) collate utf8_unicode_ci NOT NULL,
`logintimes` smallint(5) unsigned NOT NULL,
`edittime` datetime NOT NULL,
`edittimes` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;