📄 setup.asp
字号:
NewColumns2(5, DataType_MYSQL) = "TEXT"
NewColumns2(5, ConstraintAccess) = "NULL"
NewColumns2(5, ConstraintSQL6) = "NULL"
NewColumns2(5, ConstraintSQL7) = "NULL"
NewColumns2(5, ConstraintMySQL) = "NULL"
NewColumns2(6, Prefix) = strMemberTablePrefix
NewColumns2(6, FieldName) = "M_LNEWS"
NewColumns2(6, TableName) = "MEMBERS"
NewColumns2(6, DataType_Access) = "MEMO"
NewColumns2(6, DataType_SQL6) = "TEXT"
NewColumns2(6, DataType_SQL7) = "NTEXT"
NewColumns2(6, DataType_MYSQL) = "TEXT"
NewColumns2(6, ConstraintAccess) = "NULL"
NewColumns2(6, ConstraintSQL6) = "NULL"
NewColumns2(6, ConstraintSQL7) = "NULL"
NewColumns2(6, ConstraintMySQL) = "NULL"
NewColumns2(7, Prefix) = strMemberTablePrefix
NewColumns2(7, FieldName) = "M_QUOTE"
NewColumns2(7, TableName) = "MEMBERS"
NewColumns2(7, DataType_Access) = "MEMO"
NewColumns2(7, DataType_SQL6) = "TEXT"
NewColumns2(7, DataType_SQL7) = "NTEXT"
NewColumns2(7, DataType_MYSQL) = "TEXT"
NewColumns2(7, ConstraintAccess) = "NULL"
NewColumns2(7, ConstraintSQL6) = "NULL"
NewColumns2(7, ConstraintSQL7) = "NULL"
NewColumns2(7, ConstraintMySQL) = "NULL"
NewColumns2(8, Prefix) = strMemberTablePrefix
NewColumns2(8, FieldName) = "M_BIO"
NewColumns2(8, TableName) = "MEMBERS"
NewColumns2(8, DataType_Access) = "MEMO"
NewColumns2(8, DataType_SQL6) = "TEXT"
NewColumns2(8, DataType_SQL7) = "NTEXT"
NewColumns2(8, DataType_MYSQL) = "TEXT"
NewColumns2(8, ConstraintAccess) = "NULL"
NewColumns2(8, ConstraintSQL6) = "NULL"
NewColumns2(8, ConstraintSQL7) = "NULL"
NewColumns2(8, ConstraintMySQL) = "NULL"
NewColumns2(9, Prefix) = strMemberTablePrefix
NewColumns2(9, FieldName) = "M_MARSTATUS"
NewColumns2(9, TableName) = "MEMBERS"
NewColumns2(9, DataType_Access) = "TEXT (100)"
NewColumns2(9, DataType_SQL6) = "VARCHAR (100)"
NewColumns2(9, DataType_SQL7) = "NVARCHAR (100)"
NewColumns2(9, DataType_MYSQL) = "VARCHAR (100)"
NewColumns2(9, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0374 DEFAULT ''"
NewColumns2(9, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0374 DEFAULT ''"
NewColumns2(9, ConstraintMySQL) = "DEFAULT '' NULL"
NewColumns2(10, Prefix) = strMemberTablePrefix
NewColumns2(10, FieldName) = "M_LINK1"
NewColumns2(10, TableName) = "MEMBERS"
NewColumns2(10, DataType_Access) = "TEXT (255)"
NewColumns2(10, DataType_SQL6) = "VARCHAR (255)"
NewColumns2(10, DataType_SQL7) = "NVARCHAR (255)"
NewColumns2(10, DataType_MYSQL) = "VARCHAR (255)"
NewColumns2(10, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0375 DEFAULT ''"
NewColumns2(10, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0375 DEFAULT ''"
NewColumns2(10, ConstraintMySQL) = "DEFAULT '' NULL"
NewColumns2(11, Prefix) = strMemberTablePrefix
NewColumns2(11, FieldName) = "M_LINK2"
NewColumns2(11, TableName) = "MEMBERS"
NewColumns2(11, DataType_Access) = "TEXT (255)"
NewColumns2(11, DataType_SQL6) = "VARCHAR (255)"
NewColumns2(11, DataType_SQL7) = "NVARCHAR (255)"
NewColumns2(11, DataType_MYSQL) = "VARCHAR (255)"
NewColumns2(11, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0376 DEFAULT ''"
NewColumns2(11, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0376 DEFAULT ''"
NewColumns2(11, ConstraintMySQL) = "DEFAULT '' NULL"
NewColumns2(12, Prefix) = strMemberTablePrefix
NewColumns2(12, FieldName) = "M_CITY"
NewColumns2(12, TableName) = "MEMBERS"
NewColumns2(12, DataType_Access) = "TEXT (100)"
NewColumns2(12, DataType_SQL6) = "VARCHAR (100)"
NewColumns2(12, DataType_SQL7) = "NVARCHAR (100)"
NewColumns2(12, DataType_MYSQL) = "VARCHAR (100)"
NewColumns2(12, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0377 DEFAULT ''"
NewColumns2(12, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0377 DEFAULT ''"
NewColumns2(12, ConstraintMySQL) = "DEFAULT '' NULL"
NewColumns2(13, Prefix) = strMemberTablePrefix
NewColumns2(13, FieldName) = "M_PHOTO_URL"
NewColumns2(13, TableName) = "MEMBERS"
NewColumns2(13, DataType_Access) = "TEXT (255)"
NewColumns2(13, DataType_SQL6) = "VARCHAR (255)"
NewColumns2(13, DataType_SQL7) = "NVARCHAR (255)"
NewColumns2(13, DataType_MYSQL) = "VARCHAR (255)"
NewColumns2(13, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0378 DEFAULT ''"
NewColumns2(13, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0378 DEFAULT ''"
NewColumns2(13, ConstraintMySQL) = "DEFAULT '' NULL"
NewColumns2(14, Prefix) = strMemberTablePrefix
NewColumns2(14, FieldName) = "M_STATE"
NewColumns2(14, TableName) = "MEMBERS"
NewColumns2(14, DataType_Access) = "TEXT (100)"
NewColumns2(14, DataType_SQL6) = "VARCHAR (100)"
NewColumns2(14, DataType_SQL7) = "NVARCHAR (100)"
NewColumns2(14, DataType_MYSQL) = "VARCHAR (100)"
NewColumns2(14, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0379 DEFAULT ''"
NewColumns2(14, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC0379 DEFAULT ''"
NewColumns2(14, ConstraintMySQL) = "DEFAULT '' NULL"
NewColumns2(15, Prefix) = strTablePrefix
NewColumns2(15, FieldName) = "C_STRFULLNAME"
NewColumns2(15, TableName) = "CONFIG"
NewColumns2(15, DataType_Access) = "SMALLINT"
NewColumns2(15, DataType_SQL6) = "SMALLINT"
NewColumns2(15, DataType_SQL7) = "SMALLINT"
NewColumns2(15, DataType_MySQL) = "SMALLINT"
NewColumns2(15, ConstraintAccess) = "NULL"
NewColumns2(15, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1000 DEFAULT 0"
NewColumns2(15, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1000 DEFAULT 0"
NewColumns2(15, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(16, Prefix) = strTablePrefix
NewColumns2(16, FieldName) = "C_STRPICTURE"
NewColumns2(16, TableName) = "CONFIG"
NewColumns2(16, DataType_Access) = "SMALLINT"
NewColumns2(16, DataType_SQL6) = "SMALLINT"
NewColumns2(16, DataType_SQL7) = "SMALLINT"
NewColumns2(16, DataType_MySQL) = "SMALLINT"
NewColumns2(16, ConstraintAccess) = "NULL"
NewColumns2(16, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1001 DEFAULT 0"
NewColumns2(16, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1001 DEFAULT 0"
NewColumns2(16, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(17, Prefix) = strTablePrefix
NewColumns2(17, FieldName) = "C_STRSEX"
NewColumns2(17, TableName) = "CONFIG"
NewColumns2(17, DataType_Access) = "SMALLINT"
NewColumns2(17, DataType_SQL6) = "SMALLINT"
NewColumns2(17, DataType_SQL7) = "SMALLINT"
NewColumns2(17, DataType_MySQL) = "SMALLINT"
NewColumns2(17, ConstraintAccess) = "NULL"
NewColumns2(17, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1002 DEFAULT 0"
NewColumns2(17, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1002 DEFAULT 0"
NewColumns2(17, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(18, Prefix) = strTablePrefix
NewColumns2(18, FieldName) = "C_STRCITY"
NewColumns2(18, TableName) = "CONFIG"
NewColumns2(18, DataType_Access) = "SMALLINT"
NewColumns2(18, DataType_SQL6) = "SMALLINT"
NewColumns2(18, DataType_SQL7) = "SMALLINT"
NewColumns2(18, DataType_MySQL) = "SMALLINT"
NewColumns2(18, ConstraintAccess) = "NULL"
NewColumns2(18, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1003 DEFAULT 0"
NewColumns2(18, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1003 DEFAULT 0"
NewColumns2(18, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(19, Prefix) = strTablePrefix
NewColumns2(19, FieldName) = "C_STRSTATE"
NewColumns2(19, TableName) = "CONFIG"
NewColumns2(19, DataType_Access) = "SMALLINT"
NewColumns2(19, DataType_SQL6) = "SMALLINT"
NewColumns2(19, DataType_SQL7) = "SMALLINT"
NewColumns2(19, DataType_MySQL) = "SMALLINT"
NewColumns2(19, ConstraintAccess) = "NULL"
NewColumns2(19, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1004 DEFAULT 0"
NewColumns2(19, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1004 DEFAULT 0"
NewColumns2(19, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(20, Prefix) = strTablePrefix
NewColumns2(20, FieldName) = "C_STRAGE"
NewColumns2(20, TableName) = "CONFIG"
NewColumns2(20, DataType_Access) = "SMALLINT"
NewColumns2(20, DataType_SQL6) = "SMALLINT"
NewColumns2(20, DataType_SQL7) = "SMALLINT"
NewColumns2(20, DataType_MySQL) = "SMALLINT"
NewColumns2(20, ConstraintAccess) = "NULL"
NewColumns2(20, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1005 DEFAULT 0"
NewColumns2(20, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1005 DEFAULT 0"
NewColumns2(20, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(21, Prefix) = strTablePrefix
NewColumns2(21, FieldName) = "C_STRCOUNTRY"
NewColumns2(21, TableName) = "CONFIG"
NewColumns2(21, DataType_Access) = "SMALLINT"
NewColumns2(21, DataType_SQL6) = "SMALLINT"
NewColumns2(21, DataType_SQL7) = "SMALLINT"
NewColumns2(21, DataType_MySQL) = "SMALLINT"
NewColumns2(21, ConstraintAccess) = "NULL"
NewColumns2(21, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1006 DEFAULT 0"
NewColumns2(21, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1006 DEFAULT 0"
NewColumns2(21, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(22, Prefix) = strTablePrefix
NewColumns2(22, FieldName) = "C_STROCCUPATION"
NewColumns2(22, TableName) = "CONFIG"
NewColumns2(22, DataType_Access) = "SMALLINT"
NewColumns2(22, DataType_SQL6) = "SMALLINT"
NewColumns2(22, DataType_SQL7) = "SMALLINT"
NewColumns2(22, DataType_MySQL) = "SMALLINT"
NewColumns2(22, ConstraintAccess) = "NULL"
NewColumns2(22, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1007 DEFAULT 0"
NewColumns2(22, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1007 DEFAULT 0"
NewColumns2(22, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(23, Prefix) = strTablePrefix
NewColumns2(23, FieldName) = "C_STRBIO"
NewColumns2(23, TableName) = "CONFIG"
NewColumns2(23, DataType_Access) = "SMALLINT"
NewColumns2(23, DataType_SQL6) = "SMALLINT"
NewColumns2(23, DataType_SQL7) = "SMALLINT"
NewColumns2(23, DataType_MySQL) = "SMALLINT"
NewColumns2(23, ConstraintAccess) = "NULL"
NewColumns2(23, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1008 DEFAULT 0"
NewColumns2(23, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1008 DEFAULT 0"
NewColumns2(23, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(24, Prefix) = strTablePrefix
NewColumns2(24, FieldName) = "C_STRHOBBIES"
NewColumns2(24, TableName) = "CONFIG"
NewColumns2(24, DataType_Access) = "SMALLINT"
NewColumns2(24, DataType_SQL6) = "SMALLINT"
NewColumns2(24, DataType_SQL7) = "SMALLINT"
NewColumns2(24, DataType_MySQL) = "SMALLINT"
NewColumns2(24, ConstraintAccess) = "NULL"
NewColumns2(24, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1009 DEFAULT 0"
NewColumns2(24, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1009 DEFAULT 0"
NewColumns2(24, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(25, Prefix) = strTablePrefix
NewColumns2(25, FieldName) = "C_STRLNEWS"
NewColumns2(25, TableName) = "CONFIG"
NewColumns2(25, DataType_Access) = "SMALLINT"
NewColumns2(25, DataType_SQL6) = "SMALLINT"
NewColumns2(25, DataType_SQL7) = "SMALLINT"
NewColumns2(25, DataType_MySQL) = "SMALLINT"
NewColumns2(25, ConstraintAccess) = "NULL"
NewColumns2(25, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1010 DEFAULT 0"
NewColumns2(25, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1010 DEFAULT 0"
NewColumns2(25, ConstraintMySQL) = "DEFAULT 0 NULL"
NewColumns2(26, Prefix) = strTablePrefix
NewColumns2(26, FieldName) = "C_STRQUOTE"
NewColumns2(26, TableName) = "CONFIG"
NewColumns2(26, DataType_Access) = "SMALLINT"
NewColumns2(26, DataType_SQL6) = "SMALLINT"
NewColumns2(26, DataType_SQL7) = "SMALLINT"
NewColumns2(26, DataType_MySQL) = "SMALLINT"
NewColumns2(26, ConstraintAccess) = "NULL"
NewColumns2(26, ConstraintSQL6) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1011 DEFAULT 0"
NewColumns2(26, ConstraintSQL7) = "NULL CONSTRAINT " & strTablePrefix & "SnitzC1011 DEFAULT 0"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -