execute sp_addtype dm_Bool, 'bit'
execute sp_addtype dm_address, 'varchar(1000)'
execute sp_addtype dm_articleType, 'varchar(8)'
execute sp_addtype dm_billID, 'varchar(30)'
execute sp_addtype dm_blogID, 'varchar(10)'
execute sp_addtype dm_categoryID, 'varchar(30)'
execute sp_addtype dm_categoryName, 'varchar(30)'
execute sp_addtype dm_city, 'varchar(50)'
execute sp_addtype dm_country, 'varchar(100)'
execute sp_addtype dm_date, 'datetime'
execute sp_addtype dm_deliverID, 'varchar(5)'
execute sp_addtype dm_departmentID, 'varchar(10)'
execute sp_addtype dm_email, 'varchar(100)'
execute sp_addtype dm_expressID, 'varchar(5)'
execute sp_addtype dm_goodID, 'varchar(100)'
execute sp_addtype dm_imgUrl, 'varchar(200)'
execute sp_addtype dm_ip, 'varchar(15)'
execute sp_addtype dm_ipLocation, 'varchar(200)'
execute sp_addtype dm_linkUrl, 'varchar(200)'
execute sp_addtype dm_memberID, 'varchar(20)'
execute sp_addtype dm_menuID, 'varchar(4)'
execute sp_addtype dm_menuName, 'varchar(16)'
execute sp_addtype dm_mobi, 'varchar(15)'
execute sp_addtype dm_msgContent, 'varchar(50)'
execute sp_addtype dm_msgID, 'varchar(4)'
execute sp_addtype dm_msgTitle, 'varchar(50)'
execute sp_addtype dm_name, 'varchar(50)'
execute sp_addtype dm_orderID, 'varchar(20)'
execute sp_addtype dm_orderIndex, 'int'
execute sp_addtype dm_paymentID, 'varchar(5)'
execute sp_addtype dm_permissionID, 'varchar(3)'
execute sp_addtype dm_productName, 'varchar(500)'
execute sp_addtype dm_providerID, 'varchar(10)'
execute sp_addtype dm_providerName, 'varchar(50)'
execute sp_addtype dm_province, 'varchar(100)'
execute sp_addtype dm_pwd, 'varchar(172)'
execute sp_addtype dm_quantity, 'float'
execute sp_addtype dm_remark, 'text'
execute sp_addtype dm_roleID, 'varchar(6)'
execute sp_addtype dm_sum, 'money'
execute sp_addtype dm_tagID, 'varchar(6)'
execute sp_addtype dm_tel, 'varchar(25)'
execute sp_addtype dm_templateName, 'varchar(30)'
execute sp_addtype dm_txDate, 'varchar(19)'
execute sp_addtype dm_voucherID, 'varchar(20)'
execute sp_addtype dm_zip, 'varchar(20)'