CREATE DATABASE "output.add" ENCRYPT False
EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Version_Major',
        '0'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Version_Minor',
        '0'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Default_Table_Path',
        '.\'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Temp_Table_Path',
        '.\'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Log_In_Required',
        'False'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Verify_Access_Rights',
        'False'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Encrypt_Table_Password',
        ''
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Encrypt_New_Table',
        'False'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Enable_Internet',
        'False'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Internet_Security_Level',
        '2'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Max_Failed_Attempts',
        '5'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Logins_Disabled',
        'False'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Logins_Disabled_Msg',
        ''
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Comment',
        ''
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'User_Defined_Prop',
        ''
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'FTS_Delimiters',
        
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'FTS_Noise_Words',
        ''
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'FTS_Drop_Chars',
        ''
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'FTS_Conditional_Chars',
        ''
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Encrypt_Indexes',
        'False'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Query_Log_Table',
        ''
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Encrypt_Communication',
        'False'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Disable_DLL_Caching',
        'False'
      );

EXECUTE PROCEDURE
   sp_ModifyDatabase
      (
        'Triggers_Disabled',
        'False'
      );

CREATE TABLE [..\electronics\projects\home control\tables\tempSeries.adt] ( 
      Observed CIChar( 16 ),
      OrdTableUsed Integer,
      TheColor Integer,
      OrdWhatMeasured Integer,
      UseYScale CIChar( 1 )) IN DATABASE;
EXECUTE PROCEDURE sp_CreateIndex90( 
   'tempSeries',
   'tempSeries.adi',
   'BYWHATMEASURED',
   'OrdWhatMeasured;Observed',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_CreateIndex90( 
   'tempSeries',
   'tempSeries.adi',
   'BYOBSERVED',
   'Observed;OrdWhatMeasured',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_ModifyTableProperty( 'tempSeries', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'tempSeriesfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'tempSeries', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'tempSeriesfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'tempSeries', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'tempSeriesfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'tempSeries', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'tempSeriesfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'tempSeries', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'tempSeriesfail');

CREATE TABLE [..\electronics\projects\home control\tables\Boards.adt] ( 
      Comment CIChar( 50 ),
      CPUUID Integer,
      Kind CIChar( 30 ),
      Label CIChar( 50 ),
      Location CIChar( 30 ),
      RRFPartNumber Integer,
      Tag CIChar( 1 ),
      UID Integer,
      WantsPressureValue Logical,
      XBeeUID Integer) IN DATABASE;
EXECUTE PROCEDURE sp_ModifyTableProperty( 'Boards', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'Boardsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Boards', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'Boardsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Boards', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'Boardsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Boards', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'Boardsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Boards', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'Boardsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Boards', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'Boardsfail');

EXECUTE PROCEDURE sp_ModifyFieldProperty ( 'Boards', 
      'WantsPressureValue', 'Field_Default_Value', 
      'false', 'APPEND_FAIL', 'Boardsfail' ); 

CREATE TABLE [..\electronics\projects\home control\tables\SensorTypes3.adt] ( 
      Name CIChar( 30 ),
      UID Integer,
      Comment CIChar( 50 )) IN DATABASE;
EXECUTE PROCEDURE sp_CreateIndex90( 
   'SensorTypes3',
   'SensorTypes3.adi',
   'BYUID',
   'UID',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_CreateIndex90( 
   'SensorTypes3',
   'SensorTypes3.adi',
   'BYNAME',
   'Name',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTypes3', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'SensorTypes3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTypes3', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'SensorTypes3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTypes3', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'SensorTypes3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTypes3', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'SensorTypes3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTypes3', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'SensorTypes3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTypes3', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'SensorTypes3fail');

CREATE TABLE [..\electronics\projects\home control\tables\RRFNotes.adt] ( 
      Category CIChar( 30 ),
      Note Memo,
      Timestamp TimeStamp) IN DATABASE;
EXECUTE PROCEDURE sp_CreateIndex90( 
   'RRFNotes',
   'RRFNotes.adi',
   'BYDATE',
   'Timestamp;Category',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_CreateIndex90( 
   'RRFNotes',
   'RRFNotes.adi',
   'BYCATEGORY',
   'Category; Timestamp',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_ModifyTableProperty( 'RRFNotes', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'RRFNotesfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'RRFNotes', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'RRFNotesfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'RRFNotes', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'RRFNotesfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'RRFNotes', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'RRFNotesfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'RRFNotes', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'RRFNotesfail');

CREATE TABLE [.\household\HC3 data\Summary3.adt] ( 
      ACPercent Integer,
      AvgTempF Double( 0 ),
      AvgWindMPH Integer,
      FurnacePercent Integer,
      MaxRH Integer,
      MaxTempF Double( 0 ),
      MaxWindMPH Integer,
      MinRH Integer,
      MinTempF Double( 0 ),
      Rainmm Double( 0 ),
      Sunrise Time,
      SunriseBad Logical,
      Sunset Time,
      SunsetBad Logical,
      TheDate Date,
      PondTempF Double( 0 ),
      PM25 Double( 0 )) IN DATABASE;
EXECUTE PROCEDURE sp_CreateIndex90( 
   'Summary3',
   'Summary3.adi',
   'BYDATE',
   'TheDate',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_ModifyTableProperty( 'Summary3', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'Summary3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Summary3', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'Summary3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Summary3', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'Summary3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Summary3', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'Summary3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Summary3', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'Summary3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Summary3', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'Summary3fail');

CREATE TABLE [..\electronics\projects\home control\tables\SensorTableLink.adt] ( 
      UID Integer,
      SensorUID Integer,
      WhatMeasured2 Integer,
      TableUID Integer,
      FieldName CIChar( 50 )) IN DATABASE;
EXECUTE PROCEDURE sp_CreateIndex90( 
   'SensorTableLink',
   'SensorTableLink.adi',
   'BYSENSOR',
   'SensorUID',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_CreateIndex90( 
   'SensorTableLink',
   'SensorTableLink.adi',
   'BYWM',
   'WhatMeasured2;SensorUID',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_CreateIndex90( 
   'SensorTableLink',
   'SensorTableLink.adi',
   'BYTABLE',
   'TableUID;FieldName',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTableLink', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'SensorTableLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTableLink', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'SensorTableLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTableLink', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'SensorTableLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTableLink', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'SensorTableLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTableLink', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'SensorTableLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'SensorTableLink', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'SensorTableLinkfail');

CREATE TABLE [..\electronics\projects\home control\tables\BoardSensorLink.adt] ( 
      UID Integer,
      BoardUID Integer,
      SensorUID Integer,
      BoardSlotUID Integer,
      Comment CIChar( 50 )) IN DATABASE;
EXECUTE PROCEDURE sp_CreateIndex90( 
   'BoardSensorLink',
   'BoardSensorLink.adi',
   'BYUID',
   'UID',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_CreateIndex90( 
   'BoardSensorLink',
   'BoardSensorLink.adi',
   'BYBOARD',
   'BoardUID;BoardSlotUID;UID',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSensorLink', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'BoardSensorLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSensorLink', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'BoardSensorLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSensorLink', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'BoardSensorLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSensorLink', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'BoardSensorLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSensorLink', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'BoardSensorLinkfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSensorLink', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'BoardSensorLinkfail');

CREATE TABLE [..\electronics\projects\home control\tables\BoardSlots.adt] ( 
      UID AutoInc,
      Name CIChar( 30 )) IN DATABASE;
EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSlots', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'BoardSlotsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSlots', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'BoardSlotsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSlots', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'BoardSlotsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSlots', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'BoardSlotsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSlots', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'BoardSlotsfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'BoardSlots', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'BoardSlotsfail');

CREATE TABLE [.\household\HC3 data\GraphSeries3.adt] ( 
      Axis CIChar( 1 ),
      BoardName CIChar( 20 ),
      PlotOrder Integer,
      Color Integer,
      FieldName CIChar( 20 ),
      FieldType Integer,
      Legend CIChar( 50 ),
      ObservedString CIChar( 20 ),
      ObservedUID Integer,
      GraphUID Integer,
      QuerySchema Memo,
      RangeQuery Memo,
      SensorUID Integer,
      SeriesKind Integer,
      SeriesKindString CIChar( 20 ),
      TableName CIChar( 20 ),
      TableUID Integer,
      WhatMeasured Integer,
      WhatMeasuredString CIChar( 20 )) IN DATABASE;
EXECUTE PROCEDURE sp_ModifyTableProperty( 'GraphSeries3', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'GraphSeries3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'GraphSeries3', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'GraphSeries3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'GraphSeries3', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'GraphSeries3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'GraphSeries3', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'GraphSeries3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'GraphSeries3', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'GraphSeries3fail');

EXECUTE PROCEDURE sp_ModifyFieldProperty ( 'GraphSeries3', 
      'FieldType', 'Comment', 
      '1 boolean, 2 float, 3 integer', 'APPEND_FAIL', 'GraphSeries3fail' ); 

CREATE TABLE [..\electronics\projects\home control\tables\DownpourWeek.adt] ( 
      TheDate Date,
      MMInWeek Double( 0 )) IN DATABASE;
EXECUTE PROCEDURE sp_ModifyTableProperty( 'DownpourWeek', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'DownpourWeekfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'DownpourWeek', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'DownpourWeekfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'DownpourWeek', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'DownpourWeekfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'DownpourWeek', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'DownpourWeekfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'DownpourWeek', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'DownpourWeekfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'DownpourWeek', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'DownpourWeekfail');

CREATE TABLE [..\electronics\projects\home control\tables\ConsecutiveRainyDays.adt] ( 
      StartRun Date,
      RunLength Integer,
      Rained Logical) IN DATABASE;
EXECUTE PROCEDURE sp_ModifyTableProperty( 'ConsecutiveRainyDays', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'ConsecutiveRainyDaysfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'ConsecutiveRainyDays', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'ConsecutiveRainyDaysfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'ConsecutiveRainyDays', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'ConsecutiveRainyDaysfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'ConsecutiveRainyDays', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'ConsecutiveRainyDaysfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'ConsecutiveRainyDays', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'ConsecutiveRainyDaysfail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'ConsecutiveRainyDays', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'ConsecutiveRainyDaysfail');

CREATE TABLE [..\electronics\projects\home control\tables\Sensors3.adt] ( 
      Comment CIChar( 50 ),
      Label CIChar( 20 ),
      Location CIChar( 30 ),
      ObservedUID Integer,
      TypeUID Integer,
      UID Integer,
      OrderNumber Integer,
      SerialNumber CIChar( 50 )) IN DATABASE;
EXECUTE PROCEDURE sp_CreateIndex90( 
   'Sensors3',
   'Sensors3.adi',
   'BYUID',
   'UID',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_CreateIndex90( 
   'Sensors3',
   'Sensors3.adi',
   'BYTYPEANDLABEL',
   'TypeUID;Label',
   '',
   2,
   512,
   '' ); 


EXECUTE PROCEDURE sp_ModifyTableProperty( 'Sensors3', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'Sensors3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Sensors3', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'Sensors3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Sensors3', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'Sensors3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Sensors3', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'Sensors3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Sensors3', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'Sensors3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Sensors3', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'Sensors3fail');

CREATE TABLE [.\household\HC3 data\graph-related\Graphs3.adt] ( 
      Autostart Logical,
      BackgroundColor Integer,
      Caption CIChar( 50 ),
      Description Memo,
      TitleForMenu CIChar( 30 ),
      UID Integer,
      YAxisLeft Integer,
      YAxisRight Integer,
      Indoor Logical) IN DATABASE;
EXECUTE PROCEDURE sp_ModifyTableProperty( 'Graphs3', 
   'Table_Auto_Create', 
   'False', 'APPEND_FAIL', 'Graphs3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Graphs3', 
   'Table_Permission_Level', 
   '2', 'APPEND_FAIL', 'Graphs3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Graphs3', 
   'Table_Memo_Block_Size', 
   '8', 'APPEND_FAIL', 'Graphs3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Graphs3', 
   'Triggers_Disabled', 
   'False', 'APPEND_FAIL', 'Graphs3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Graphs3', 
   'Table_Trans_Free', 
   'False', 'APPEND_FAIL', 'Graphs3fail');

EXECUTE PROCEDURE sp_ModifyTableProperty( 'Graphs3', 
   'Table_WEB_delta', 
   'False', 'APPEND_FAIL', 'Graphs3fail');

EXECUTE PROCEDURE sp_ModifyFieldProperty ( 'Graphs3', 
      'YAxisLeft', 'Comment', 
      '0 standard, 1 adaptive, 2 0-adaptive', 'APPEND_FAIL', 'Graphs3fail' ); 

EXECUTE PROCEDURE 
  sp_CreateLink ( 
     'NamedHardware',
     'G:\databases\household\named hardware\NamedHardware.add',
     TRUE,
     TRUE,
     FALSE,
     '',
     ''/* YOUR PASSWORD GOES HERE */ );
EXECUTE PROCEDURE 
  sp_CreateLink ( 
     'HC3Data',
     '.\household\HC3 data\HC3 data.add',
     TRUE,
     FALSE,
     FALSE,
     '',
     ''/* YOUR PASSWORD GOES HERE */ );
EXECUTE PROCEDURE sp_ModifyPermission( 11, NULL, NULL, 'DB:Public', 2147483904, FALSE );

