保存为 sql.acp
#TITLE=MYSQL
; This file is provided as a default auto-completion file for MYSQL
#CASE=n
;Division
#T=au
auto_increment
#T=cm
COMMENT;
#T=pk
PRIMARY KEY (^!)
#T=uk
UNIQUE KEY `^!` (``)
#T=key
KEY `^!` (``)
#T=ct
DROP TABLE IF EXISTS `^!`;
create table `^!`(
`id` int(8) unsigned not null auto_increment COMMENT 'ID',
/* 内容 */
`title` varchar(100) NOT NULL default '' COMMENT '标题',
`content` text default NULL COMMENT '内容',
/* 共有信息 */
`active` tinyint(1) unsigned NOT NULL default 0 COMMENT '是否激活',
`created` int(10) unsigned NOT NULL default 0 COMMENT '建立时间',
`poscode` int(10) unsigned NOT NULL default 0 COMMENT '排序',
`updated` int(10) unsigned NOT NULL default 0 COMMENT '修改时间',
`viewed` int(10) unsigned NOT NULL default 0 COMMENT '最后访问时间',
`hits` int(8) unsigned NOT NULL default 0 COMMENT '点击数',
`user_id` int(8) unsigned NOT NULL default 0 COMMENT '用户 ID',
`username` varchar(25) NOT NULL default '' COMMENT '用户名',
PRIMARY KEY (`id`)
)ENGINE=MyISAM COMMENT='';
#T=drop
DROP TABLE IF EXISTS `^!`;
#T=var
varchar(^!) NOT NULL default '' COMMENT '',
#T=dec
decimal(10,2) NOT NULL default 0 COMMENT '^!',
#T=text
text default NULL COMMENT '^!',
#T=tiny
tinyint(1) unsigned NOT NULL default 0 COMMENT '^!',
#T=int
int(10) unsigned NOT NULL default 0 COMMENT '^!',
#
