开发者

Cocoa UltraSms Database structure

Here's a quicky:

Can someone tell me the table structure that cocoa ultrasms creates or give me a link to a dump of the database? (2 tables)

Cocoa UltraSms is mac only, but I only have my windows machine with me, and I need to recreate the database str开发者_如何学JAVAucture.


well, just in case someone else would ever need it ... smsin tabel:

CREATE TABLE `smsin` (
`id` int(11) unsigned NOT NULL auto_increment,
  `service` varchar(20) NOT NULL default '',
  `service_number_type` varchar(16) NOT NULL default 'Unknown',
  `service_number_npi` varchar(16) NOT NULL default 'Unknown',
  `status_report_sent` int(1) unsigned NOT NULL default '0',
  `sender` varchar(20) NOT NULL default '',
  `sender_number_type` varchar(16) NOT NULL default 'Unknown',
  `sender_number_npi` varchar(16) NOT NULL default 'Unknown',
  `timestmp` varchar(14) NOT NULL default '',
  `message` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜