私の

public text v1 · immutable
#883696
·published 2008-01-30 07:00 UTC
 CREATE TABLE `tts_installerapp` (
  `id` bigint(11) NOT NULL auto_increment,
  `source` bigint(11) NOT NULL,
  `name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `bundleIdentifier` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `version` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `time` bigint(11) NOT NULL,
  `category` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `description` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `type` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `xml` text character set utf8 collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=latin1

CREATE TABLE `tts_userapp` (
  `userid` bigint(11) NOT NULL,
  `appid` bigint(11) NOT NULL,
  UNIQUE KEY `userid` (`userid`,`appid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1