www.gusucode.com > 网站优化(SEO)新闻系统 2008源码程序 > manage/mdb_update.asp

    <%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conn_news.asp" -->
<!--#include file="config.asp" -->
<%
'on error resume next
dim conn
set conn = server.createobject("adodb.Connection")
conn.open MM_conn_news_STRING

response.Write("创建 t_js 表")
conn.execute("create table t_js")
conn.execute("alter table t_js add js_id int identity primary key")
conn.execute("alter table t_js add js_type varchar(200)")
conn.execute("alter table t_js add js_sid int")
conn.execute("alter table t_js add js_row int")
conn.execute("alter table t_js add js_column int")
conn.execute("alter table t_js add js_cut_title int")
conn.execute("alter table t_js add js_tid int")
conn.execute("alter table t_js add js_path varchar(255)")
conn.execute("alter table t_js add js_icon varchar(255)")
conn.execute("alter table t_js add js_img_width int")
conn.execute("alter table t_js add js_img_height int")
conn.execute("alter table t_js add js_repeat memo")
response.Write(" 成功<br>")


response.Write("更新 t_type 表")
conn.execute("alter table t_type add t_row int")
conn.execute("alter table t_type add t_column int")
conn.execute("alter table t_type add t_icon varchar(255)")
conn.execute("alter table t_type add t_repeat memo")
conn.execute("update t_type set t_icon = '·'")
conn.execute("update t_type set t_row = 10")
conn.execute("update t_type set t_column = 1")
conn.execute("update t_type set t_repeat = '{t_mark} {t_title} {t_date}'")
response.Write(" 成功<br>")
%>