常见数据库模版

来源：互联网发布：武汉软件新城健身房编辑：程序博客网时间：2024/04/23 21:42

CREATE TABLE `Tbl_Assigner` (
`FAssignerId` int(11) unsigned NOT NULL auto_increment,
`FActId` int(11) NOT NULL,
`FQQ` varchar(16) collate utf8_bin NOT NULL COMMENT '用户QQ号码',
PRIMARY KEY (`FAssignerId`),
INDEX `INDEX_ACTID`(`FActId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `Tbl_Speed_Statistics_Area` (
`FSpeedId` int(10) NOT NULL auto_increment,
`FTamsId` int(10) NOT NULL,
`FPageUrl` varchar(255) default NULL,
`FAll` int(4) default '0',
`FPro` varchar(32) default '',
`FTime` datetime default NULL,
PRIMARY KEY (`FSpeedId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `Tbl_Component`;
CREATE TABLE `Tbl_Component` (
`FComId` int(10) NOT NULL auto_increment,
`FComName` varchar(255) collate utf8_bin NOT NULL,
`FComMemo` varchar(255) collate utf8_bin default NULL,
`FComType` int(10) default '1',
`FEnable` int(11) NOT NULL default '1',
`FTime` varchar(32) collate utf8_bin NOT NULL,
`FMemo` text collate utf8_bin,
PRIMARY KEY (`FComId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;