drop table TBL_ACCESSORY
drop table TBL_FORMPARENTCHILD
drop table TBL_FORMS
drop table TBL_FORMSDETAIL
drop table TBL_FORMSDETAILUI
drop table TBL_FORMSUI
drop table TBL_OBJECTID
drop table TBL_ORDERNUM
drop table TBL_SHENQING
drop table TBL_SHENQING_C
drop table TBL_SYSMENU
drop table TBL_TREESDEFINE

CREATE TABLE TBL_ACCESSORY (
	UUID varchar (20)  ,
	ENTITYUUID varchar (50) ,
	FILENAME varchar (100) ,
	SAVEPATH varchar (200) ,
	SAVETYPE numeric(18, 0) NULL ,
	CONTENT image NULL 
) 

CREATE TABLE TBL_FORMPARENTCHILD (
	UUID varchar (20)  ,
	PARENTFORMUUID varchar (20) ,
	CHILDFORMUUID varchar (20) 
) 

CREATE TABLE TBL_FORMS (
	UUID varchar (60)  ,
	TBLID varchar (100) ,
	TBLNAME varchar (100) ,
	DESCRIPTION varchar (500) ,
	STATUS numeric(18, 0) NULL ,
	TABLE_ACL numeric(18, 0) NULL ,
	ROW_ACL numeric(18, 0) NULL ,
	TYPE numeric(18, 0) NULL ,
	SQLSELECTCOLUMN varchar (4000) ,
	SQLFROMCOLUMN varchar (4000) ,
	SQLWHERECOLUMN varchar (4000) ,
	BASESQL varchar (4000) 
) 

CREATE TABLE TBL_FORMSDETAIL (
	UUID varchar (20)  ,
	OTHERDOCTYPE numeric(18, 0) NULL ,
	OPERINDEX numeric(18, 0) NULL ,
	NOTNULL numeric(18, 0) NULL ,
	LISTVIEW numeric(18, 0) NULL ,
	ISOTHERDOC numeric(18, 0) NULL ,
	ISAUDIT numeric(18, 0) NULL ,
	FORMUUID varchar (60) ,
	FIELDTYPE numeric(18, 0) NULL ,
	FIELDNAME varchar (100) ,
	FIELDLENGTH numeric(18, 0) NULL ,
	FIELDID varchar (100) ,
	DEFAULTVALUE varchar (100) ,
	COL_ACL numeric(18, 0) NULL ,
	TABLEID varchar (100) ,
	LOGIC varchar (20) 
) 

CREATE TABLE TBL_FORMSDETAILUI (
	DETAILUUID varchar (20) ,
	FORMUUID varchar (60) ,
	UITYPE numeric(18, 0) NULL ,
	SYSFUNCTION varchar (100) 
) 

CREATE TABLE TBL_FORMSUI (
	UUID varchar (20)  ,
	FORMUUID varchar (60) ,
	UINAME varchar (255) ,
	PATH varchar (255) ,
	TYPE numeric(18, 0) NULL 
) 

CREATE TABLE TBL_OBJECTID (
	UUID varchar (20)  
) 

CREATE TABLE TBL_ORDERNUM (
	UUID varchar (20)  ,
	HEADSTR varchar (200) ,
	NUM numeric(18, 0) NULL 
) 

CREATE TABLE TBL_SHENQING (
	UUID varchar (20)  ,
	SHENQINGREN varchar (20) ,
	TITLE varchar (200) ,
	DESCRIPTION varchar (2000) ,
	SHIJIAN numeric(18, 0) NULL 
) 

CREATE TABLE TBL_SHENQING_C (
	UUID varchar (20)  ,
	TBL_SHENQING_FK varchar (20) ,
	FILES varchar (20) ,
	DESCRIPTION varchar (2000) 
) 

CREATE TABLE TBL_SYSMENU (
	UUID varchar (20)  ,
	SYSTEMID numeric(18, 0) NULL ,
	MENULEVEL numeric(18, 0) NULL ,
	INDEXNUM numeric(18, 0) NULL ,
	NAME varchar (100) ,
	DESCRIPTION varchar (500) ,
	ICON varchar (400) ,
	TARGETPAGE varchar (400) ,
	PARENTUUID varchar (20) ,
	PARENTTARGET varchar (400) ,
	PARENTCATPATH varchar (500) 
) 

CREATE TABLE TBL_TREESDEFINE (
	UUID varchar (20)  ,
	TREEID varchar (50) ,
	viewDbColumnDesc varchar (100) ,
	trueDbColumn varchar (30) ,
	baseSql varchar (400) ,
	isFolder numeric(18, 0) NULL ,
	needNesting numeric(18, 0) NULL ,
	isRoot numeric(18, 0) NULL ,
	nodeType numeric(18, 0) NULL ,
	PARENTUUID varchar (20) ,
	PCDbColumn varchar (30) ,
	VIEWNAME varchar (30) 
) 
GO