发表时间：2008-9-24    浏览次数：550

<%

set conn=server.CreateObject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
sql="CREATE TABLE [news] ("&_
"[news_id] COUNTER CONSTRAINT PrimaryKey PRIMARY KEY,"&_'自动编号(主键)
"[news_title] text(225),"&_'文本（最大225字符）
"[news_type] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[news_index] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[news_date] datetime DEFAULT now(),"&_'时间(默认值now())
"[news_content] memo,"&_'备注
"[news_pic] text(255),"&_'文本（最大225字符）
"[news_fujian] text(255),"&_'文本（最大225字符）
"[depart_id] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[news_author] text(50),"&_'文本（最大50字符）
"[news_checkname] text(50),"&_'文本（最大50字符）
"[news_check] integer DEFAULT 1,"&_'数字长整型(默认值1)
"[news_order] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[newsclass_id] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[news_link] text(50),"&_'文本（最大50字符）
"[news_hit] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[news_english] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[pclass_id] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[news_over] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[news_isnew] integer DEFAULT 0,"&_'数字长整型(默认值0)
"[news_zwlx] text(50) )"'文本（最大50字符）
conn.execute sql 

%>