</div>
<div style="float:left;width:50px;padding:60px 0px 0px 5px;">
<input type="submit" name="Submit_confirm" value="提交"> <br /> <br />
<input type="button" name="Submit3" value="清空" onClick="sql.value=''"><br /><br />
<input type="button" name="ok" value="返回" onClick="javascript:history.go(-1)">
</div>
</form>
<div style="clear:both"></div>
<% if str = "" then %>
<form action="?key=addtable" method="post">
<div style="clear:both;text-align:left;"><br />
<font color=red>创建新表：</font><br>
表 名：<input type="text" name="table_name" size="20"><br>
字段数：<input type="text" name="field_num" size="20">
<input type="submit" name="Submit_create" value="提交">
<input type="reset" name="Submit32" value="重置">
</div>
</form>
<br><br>
<a href="?key=tosql&strt=2">导出所有表结构到SQL</a>
<%
end if
end sub
'==================================================================创建表界面
sub add_table(table_name,field_num)
'table_name = 表名称
'field_num = 字段数
on error resume next
if not IsNumeric(field_num) then
echo "字段数必须是整数。"
echo "<input type='button' name='ok' value=' 返 回 ' onClick='javascript:history.go(-1)'>"
exit sub
end if
%>
<p class="hei"><span>创建表：</span><%=table_name%></p>
<form action="?key=createtable" method="post">
<table width="600" border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="75" height="20" align="center">字段名</td>
<td width="99" height="20" align="center">类 型</td>
<td width="73" height="20" align="center">大 小</td>
<td width="96" height="20" align="center">空值</td>
<td width="83" height="20" align="center">自动编号</td>
<td width="143" height="20" align="center">主 键</td>
</tr>
<% for i = 0 to field_num - 1 %>
<tr>
<td width="75" height="20" align="center">
<input type="text" name="field_name" size="10">
</td>
<td width="99" height="20" align="center">
<% fieldtypelist(0) %>
</td>
<td width="73" height="20" align="center">
<input type="text" name="field_size" size="10">
</td>
<td width="96" height="20" align="center">
<select name="null">
<option value="NOT_NULL">NOT_NULL</option>
<option value="NULL">NULL</option>
</select>
</td>
<td width="83" height="20" align="center">
<select size="1" name="autoincrement">
<option></option>
<option>自动编号</option>
</select>
</td>
<td width="143" height="20" align="left">
<select name="primarykey">
<option></option>
<option value="primarykey">primarykey</option>
</select>
</td>
</tr>
<% next %>
<tr>
<td height="35" align="center" colspan="5">
<input type="hidden" name="i" value=<%=field_num%>>
<input type="hidden" name="table_name" value="<%=table_name%>">
<input type="submit" name="Submit" value=" 提 交 ">
<input type="reset" name="Submit2" value=" 重 置 ">
<input type="button" name="ok" value=" 放 弃 " onClick="javascript:history.go(-1)">
</td>
<td height="20"></td>
</tr>
</table>
</form>
<%
end sub
