Clovertech

smatdb Schema

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › smatdb Schema

  • Creator
    Topic
  • January 13, 2015 at 7:39 pm #54521
    Benjamin Rubin
    Participant

      I’ve been reviewing the Cloverleaf 6.1 documentation in preparation for an upgrade later this year. I see that the SMAT file format has been changed to sqlite by default now.  

      I don’t see the database schemas listed anywhere in the documentation. Could someone with a working 6.1 instance care to share the output of:

      Code:

      sqlite3 /path/to/file.smatdb .schema


      I’m trying to plan things in advance and it would be nice to be able to know if theres enough information in the new sqlite files to warrant using that over the standard .idx and .msg format.

    • Creator
      Topic
    Viewing 1 reply thread
    • Author
      Replies
      • January 14, 2015 at 1:53 pm #81820
        Alice Kazin
        Participant

          covte96>sqlite3 plus_out.smatdb .schema

          CREATE TABLE smat_info (Version INTEGER, ECD VARCHAR, WriteMode INTEGER, SearchMode INTEGER  );

          CREATE TABLE smat_msgs (MessageContent BLOB,DataLen INTEGER,DestConn VARCHAR,OrigDestConn VARCHAR,DataFmt VARCHAR,SepChars VARCHAR,DriverCtl VARCHAR,UserData VARCHAR,MidDomain INTEGER,MidHub INTEGER,MidNum INTEGER,SrcMidDomain INTEGER,SrcMidHub INTEGER,SrcMidNum INTEGER,Type VARCHAR,SourceConn VARCHAR,OrigSourceConn VARCHAR,Time INTEGER,Priority INTEGER,SaveContext VARCHAR,Flags INTEGER,State INTEGER,GroupMidDomain INTEGER,GroupMidHub INTEGER,GroupMidNum INTEGER,XltThread VARCHAR,Retries INTEGER,SkipXlt INTEGER,UseRecoverDB INTEGER,GroupID INTEGER,TimeIn INTEGER,TimeXlt INTEGER,TimeOut INTEGER,TimeQCur INTEGER,TimeQTot INTEGER,TimeRec INTEGER,TimeStor INTEGER,TimeArc INTEGER,DBTable VARCHAR,Flags_Resent INTEGER,Flags_Trace INTEGER,ErrorString VARCHAR);

          CREATE TRIGGER check_smat_info BEFORE INSERT ON smat_info WHEN 1 <= (select count(*) from smat_info) BEGIN SELECT CASE WHEN (1) THEN RAISE (ABORT, "Attempt to insert in smat_info when already populated") END; END;

          covte96>

        • January 14, 2015 at 4:11 pm #81821
          Benjamin Rubin
          Participant

            Perfect.

            Thanks!

        • Author
          Replies
        Viewing 1 reply thread
        • The forum ‘Cloverleaf’ is closed to new topics and replies.