i f   n o t   E x i s t s ( S E L E C T   *   F R O M   i n f o r m a t i o n _ s c h e m a . t a b l e s   w h e r e   T a b l e _ n a m e   =   ' L i c e n s e ' ) 
 
 b e g i n 
 
 	 C R E A T E   T A B L E   [ d b o ] . [ L i c e n s e ] ( 
 
 	 	 [ I D ]   [ i n t ]   P r i m a r y   k e y , 
 
 	 	 [ M a t _ I D ]   [ b i g i n t ]   r e f e r e n c e s   d b o . M a t t e r ( I D )   N O T   N U L L , 
 
 	 	 [ K S _ I D ]   [ i n t ]   r e f e r e n c e s   d b o . K a l a S e r i a l ( I D )   N O T   N U L L , 
 
 	 	 [ D o m _ I D _ S t a r t u p F o r m ]   [ i n t ]   r e f e r e n c e s   d b o . D o m a i n ( I D )   N O T   N U L L   D e f a u l t   - 1 , 
 
 	 	 [ I s A c t i v e S i n g l e O r g a n i z a t i o n ]   [ b i t ]   N O T   N U L L , 
 
 	 	 [ D o m _ I D _ N o e G h o f l ]   [ i n t ]   r e f e r e n c e s   d b o . D o m a i n ( I D )   N O T   N U L L   , 
 
 	 	 [ D o m _ I D _ A c t i v a t i o n ]   [ i n t ]   r e f e r e n c e s   d b o . D o m a i n ( I D )   N O T   N U L L , 
 
 	 	 [ I n s t a l l a t i o n D a t e ]   [ i n t ]   N O T   N U L L , 
 
 	 	 [ I n s t a l l a t i o n T i m e ]   [ i n t ]   N O T   N U L L , 
 
 	 	 [ L a s t D a t e ]   [ i n t ]   N O T   N U L L , 
 
 	 	 [ L a s t T i m e ]   [ i n t ]   N O T   N U L L , 
 
 	 	 [ F i r s t N a m e ]   [ n v a r c h a r ] ( 1 0 0 )   N U L L , 
 
 	 	 [ L a s t N a m e ]   [ n v a r c h a r ] ( 1 0 0 )   N U L L , 
 
 	 	 [ N a t i o n a l C o d e ]   [ n v a r c h a r ] ( 1 0 0 )   N U L L , 
 
 	 	 [ M o b i l e ]   [ n v a r c h a r ] ( 1 0 0 )   N U L L , 
 
 	 	 [ I P S e r v e r ]   [ n v a r c h a r ] ( 1 0 0 )   N U L L , 
 
 	 	 [ I s C l i e n t ]   [ b i t ]   N O T   N U L L , 
 
 	 	 [ S e r v e r N a m e ]   [ n v a r c h a r ] ( 2 0 0 )   N U L L , 
 
 	 	 [ D a b a b a s e N a m e ]   [ n v a r c h a r ] ( 2 0 0 )   N U L L , 
 
 	 	 [ U s e r N a m e ]   [ n v a r c h a r ] ( 2 0 0 )   N U L L , 
 
 	 	 [ P a s s w o r d ]   [ n v a r c h a r ] ( 2 0 0 )   N U L L , 
 
 	 	 [ I s W i n d o w s A u t h e n t i c a t i o n ]   [ b i t ]   N O T   N U L L , 
 
 	 	 [ T o k e n ]   [ n v a r c h a r ] ( 5 0 0 )   N U L L , 
 
 	 	 [ A c t i v e d S y s t e m s ]   [ n v a r c h a r ] ( 1 0 0 0 )   N U L L , 
 
 	 	 [ C l i e n t C o u n t ]   [ i n t ]   N O T   N U L L   D E F A U L T   1 , 
 
 	 	 [ I n t e r n a l C l i e n t I P S e r v e r ]   [ n v a r c h a r ] ( 2 0 0 )   N U L L , 
 
 	 	 [ I n t e r n a l C l i e n t S e r v e r N a m e ]   [ n v a r c h a r ] ( 4 0 0 )   N U L L , 
 
 	 	 [ I n t e r n a l C l i e n t D a b a b a s e N a m e ]   [ n v a r c h a r ] ( 4 0 0 )   N U L L , 
 
 	 	 [ I n t e r n a l C l i e n t U s e r N a m e ]   [ n v a r c h a r ] ( 4 0 0 )   N U L L , 
 
 	 	 [ I n t e r n a l C l i e n t P a s s w o r d ]   [ n v a r c h a r ] ( 4 0 0 )   N U L L , 
 
 	 	 [ E x t e r n a l C l i e n t I P S e r v e r ]   [ n v a r c h a r ] ( 2 0 0 )   N U L L , 
 
 	 	 [ E x t e r n a l C l i e n t S e r v e r N a m e ]   [ n v a r c h a r ] ( 4 0 0 )   N U L L , 
 
 	 	 [ E x t e r n a l C l i e n t D a b a b a s e N a m e ]   [ n v a r c h a r ] ( 4 0 0 )   N U L L , 
 
 	 	 [ E x t e r n a l C l i e n t U s e r N a m e ]   [ n v a r c h a r ] ( 4 0 0 )   N U L L , 
 
 	 	 [ E x t e r n a l C l i e n t P a s s w o r d ]   [ n v a r c h a r ] ( 4 0 0 )   N U L L , 
 
 	 	 [ D o m _ I D _ G u i l d ]   [ i n t ]   r e f e r e n c e s   d b o . D o m a i n ( I D )   N O T   N U L L   D e f a u l t   - 1 , 
 
 	 	 [ D o m _ I D _ S t a r t u p ]   [ i n t ]   r e f e r e n c e s   d b o . D o m a i n ( I D )   N O T   N U L L , 
 
 	 	 [ C o m p u t e r N a m e ]   [ n v a r c h a r ] ( 1 0 0 )   N U L L , 
 
 	 	 [ O r g a n i z a t i o n C o u n t ]   [ i n t ]   N O T   N U L L   D e f a u l t   - 1 , 
 
 	 	 [ C o d i n g L e v e l C o u n t ]   [ i n t ]   N O T   N U L L   D e f a u l t   0 , 
 
 	 	 [ T a f _ I D ]   [ b i g i n t ]   r e f e r e n c e s   d b o . T a f s i l i ( I D )   N O T   N U L L   D e f a u l t   - 1 
 
 	 )   
 
 e n d 
 
 