phpmywind表结构.pdfVIP

phpmywind表结构 2012/ 10/ 17 星期三 DROP TA BLE IF EX ISTS `#@__admanage`; CREATE TA BLE `#@__admanage` ( `id` smallint( ) unsigned NOT NULL A UTO_ INCREMENT COMMENT 信息id, `classid` smallint( ) unsigned NOT NULL COMMENT 投放范围(广告位), `parentid` smallint( ) unsigned NOT NULL COMMENT 所属广告位父id, `parentstr` varchar(80) NOT NULL COMMENT 所属广告位父id字符串, `title` varchar(30) NOT NULL COMMENT 广告标识, `admode` char(10) NOT NULL COMMENT 展示模式, `picurl` varchar(100) NOT NULL COMMENT 上传内容地址, `adtext` text NOT NULL COMMENT 展示内容, `linkurl` varchar(2 ) NOT NULL COMMENT 跳转链接, `orderid` smallint( ) unsigned NOT NULL COMMENT 列 序, `posttime` int(10) unsigned NOT NULL COMMENT 提交时间, `checkinfo` enum(true,false) NOT NULL COMMENT 审核状态, PRIMA RY KEY (`id`) ) ENGINE=MyISA M DEFA ULT CHA RSET=utf8; DROP TA BLE IF EX ISTS `#@__admin`; CREATE TA BLE `#@__admin` ( `id` smallint( ) unsigned NOT NULL A UTO_ INCREMENT COMMENT 信息id, `username` varchar(30) NOT NULL COMMENT 用户名, `password` char(32) NOT NULL COMMENT 密码, `loginip` char(20) NOT NULL COMMENT 登陆IP, `logintime` int(10) unsigned NOT NULL COMMENT 登陆时间, `levelname` tinyint(1) unsigned NOT NULL COMMENT 级别, `checkadmin` enum(true,false) NOT NULL COMMENT 审核, PRIMA RY KEY (`id`) ) ENGINE=MyISA M DEFA ULT CHA RSET=utf8; DROP TA BLE IF EX ISTS `#@__adtype`; CREATE TA BLE `#@__adtype` ( `id` smallint( ) unsigned NOT NULL A UTO_ INCREMENT COMMENT 信息id, `parentid` smallint( ) unsigned NOT NULL COMMENT 所属广告位id, `parentstr` varchar( 0) NOT NULL COMMENT 所属广告位id字符串, `classname` varchar(30) NOT NULL COMMENT 广告位名称, `width` smallint( ) unsigned NOT NULL COMMENT 广告位宽度, `height` smallint( ) unsigned NOT NULL COMMENT 广告位高度, `orderid` smallint( ) unsigned NOT NULL COMMENT 列顺序, `checkinfo` enum(true,false) NOT NULL