|
��/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ b i z _ P r o d u c t s ] S c r i p t D a t e : 0 2 / 0 8 / 2 0 1 0 1 7 : 0 3 : 2 2 * * * * * * /
S E T A N S I _ N U L L S O N
G O
S E T Q U O T E D _ I D E N T I F I E R O N
G O
C R E A T E T A B L E [ d b o ] . [ b i z _ P r o d u c t s ] (
[ I d ] [ u n i q u e i d e n t i f i e r ] N O T N U L L C O N S T R A I N T [ D F _ b i z _ P r o d u c t s _ I d ] D E F A U L T ( n e w i d ( ) ) ,
[ A p p l i c a t i o n I d ] [ u n i q u e i d e n t i f i e r ] N O T N U L L ,
[ C a t e g o r y I d ] [ u n i q u e i d e n t i f i e r ] N O T N U L L ,
[ N a m e ] [ n v a r c h a r ] ( 2 5 6 ) N O T N U L L ,
[ N u m b e r ] [ n v a r c h a r ] ( 3 2 ) N O T N U L L ,
[ M a n u f a c t o r y ] [ n v a r c h a r ] ( 2 5 6 ) N U L L ,
[ D e s c r i p t i o n ] [ n t e x t ] N U L L ,
[ C r e a t e d B y ] [ u n i q u e i d e n t i f i e r ] N O T N U L L ,
[ C r e a t e d O n ] [ d a t e t i m e ] N O T N U L L ,
[ L a s t U p d a t e d B y ] [ u n i q u e i d e n t i f i e r ] N U L L ,
[ L a s t U p d a t e d O n ] [ d a t e t i m e ] N U L L ,
[ E x t e n s i o n D a t a T y p e I d ] [ u n i q u e i d e n t i f i e r ] N O T N U L L ,
[ E x t e n s i o n D a t a ] [ n v a r c h a r ] ( m a x ) N O T N U L L ,
C O N S T R A I N T [ P K _ b i z _ P r o d u c t s ] P R I M A R Y K E Y C L U S T E R E D
(
[ I d ] A S C
) W I T H ( P A D _ I N D E X = O F F , S T A T I S T I C S _ N O R E C O M P U T E = O F F , I G N O R E _ D U P _ K E Y = O F F , A L L O W _ R O W _ L O C K S = O N , A L L O W _ P A G E _ L O C K S = O N ) O N [ P R I M A R Y ]
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
G O
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ b i z _ P r o d u c t L o g s ] S c r i p t D a t e : 0 2 / 0 8 / 2 0 1 0 1 7 : 0 3 : 1 8 * * * * * * /
S E T A N S I _ N U L L S O N
G O
S E T Q U O T E D _ I D E N T I F I E R O N
G O
C R E A T E T A B L E [ d b o ] . [ b i z _ P r o d u c t L o g s ] (
[ I d ] [ u n i q u e i d e n t i f i e r ] N O T N U L L C O N S T R A I N T [ D F _ b i z _ P r o d u c t L o g s _ I d ] D E F A U L T ( n e w i d ( ) ) ,
[ P r o d u c t I d ] [ u n i q u e i d e n t i f i e r ] N O T N U L L ,
[ B o d y ] [ n t e x t ] N O T N U L L ,
[ L o g g e d O n ] [ d a t e t i m e ] N O T N U L L ,
[ L o g g e d B y ] [ u n i q u e i d e n t i f i e r ] N O T N U L L ,
C O N S T R A I N T [ P K _ b i z _ P r o d u c t L o g s ] P R I M A R Y K E Y C L U S T E R E D
(
[ I d ] A S C
) W I T H ( P A D _ I N D E X = O F F , S T A T I S T I C S _ N O R E C O M P U T E = O F F , I G N O R E _ D U P _ K E Y = O F F , A L L O W _ R O W _ L O C K S = O N , A L L O W _ P A G E _ L O C K S = O N ) O N [ P R I M A R Y ]
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
G O
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I've worked as a software architect and developer based on Microsoft .NET framework and web technology since 2002, having rich experience on SaaS, multiple-tier web system and website development. I've devoted into open source project development since 2003, and have created 3 main projects including DataQuicker (ORM), ExcelQuicker (Excel Report Generator), and RapidWebDev (Enterprise-level CMS)
I worked in BenQ (8 mo), Bleum (4 mo), Newegg (1 mo), Microsoft (3 yr) and Autodesk (5 yr) before 2012. Now I own a startup company in Shanghai China to deliver the exceptional results to global internet users by leveraging the power of Internet and the local excellence.