-- MS SQL-Server Table Script
-- This script is only to update table DDL from older version

-- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-- Usage:
-- 1) Check XC_VER
-- 2) The largest integer in XC_VER is the current version
-- 3) Execute from the next version.  e.g. 4 is the largest number in XC_VER, start from --VERSION = 5
-- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

-- 11/3/03
-- Add <FIELD>SHIFT</FIELD>, <FIELD>OFFSET</FIELD> and <FIELD>RIGHT_DIGIT</FIELD> to <TABLE>XC_SITESENSORS</TABLE>
-- Create <TABLE>XC_VER</TABLE> as version 4

-- 12/26/03
-- Add <TABLE>XC_RTUQC</TABLE>
-- Make <TABLE>XC_VER</TABLE> as version 5

-- 02/20/04
-- Add <TABLE>XC_SITES</TABLE> <FIELDS>COEFFICIENT 1-3</FIELDS>
-- Add <TABLE>XC_SITESENSORS</TABLE> <FIELDS>COEFFICIENT 1-5</FIELDS> 
-- Make <TABLE>XC_VER</TABLE> as version 6
 
-- VERSION=7
USE XC_DATA;

ALTER TABLE XC_DATA1 MAX_ROWS=4000000000000;
