123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 |
- DROP TABLE NC_TASK_PROPERTY
- go
- CREATE TABLE NC_TASK_PROPERTY (
- TASK_ID CHAR (20) NOT NULL,
- PROP_NAME CHAR (20) NOT NULL,
- PROP_VALUE NVARCHAR(2000))
- go
- ALTER TABLE NC_TASK_QUEUE ADD ACTUAL_COMPLETION_TIME NUMERIC NULL
- go
- ALTER TABLE NC_TASK_PROPERTY ADD CONSTRAINT PN_TASK_PROPERTY PRIMARY KEY (TASK_ID,PROP_NAME)
- go
- INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(310,'build no.')
- go
-
-
-
-
-
-
|