Skip to content

Instantly share code, notes, and snippets.

@kean
Created July 12, 2023 19:25
Show Gist options
  • Save kean/3fd7460407616348360e418301314578 to your computer and use it in GitHub Desktop.
Save kean/3fd7460407616348360e418301314578 to your computer and use it in GitHub Desktop.
CREATE TABLE ZSTATSRECORDVALUE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZSTATSRECORD INTEGER, ZBESTVIEWSPERDAYCOUNT INTEGER, ZPOSTSCOUNT INTEGER, ZVIEWSCOUNT INTEGER, ZVISITORSCOUNT INTEGER, ZINSIGHTYEAR INTEGER, ZMOSTPOPULARDAYOFWEEK INTEGER, ZMOSTPOPULARDAYOFWEEKPERCENTAGE INTEGER, ZMOSTPOPULARHOUR INTEGER, ZMOSTPOPULARHOURPERCENTAGE INTEGER, ZTOTALCOMMENTSCOUNT INTEGER, ZTOTALIMAGESCOUNT INTEGER, ZTOTALLIKESCOUNT INTEGER, ZTOTALPOSTSCOUNT INTEGER, ZTOTALWORDSCOUNT INTEGER, ZCLICKSCOUNT INTEGER, ZPARENT INTEGER, ZVIEWSCOUNT1 INTEGER, ZDOWNLOADCOUNT INTEGER, ZCOUNT INTEGER, ZTYPE INTEGER, ZTYPE1 INTEGER, ZCOMMENTSCOUNT INTEGER, ZLIKESCOUNT INTEGER, ZPOSTID INTEGER, ZVIEWSCOUNT2 INTEGER, ZOTHERCOUNT INTEGER, ZTOTALCOUNT INTEGER, ZFOLLOWERSCOUNT INTEGER, ZVIEWSCOUNT3 INTEGER, ZPARENT1 INTEGER, ZVIEWSCOUNT4 INTEGER, ZCURRENTSTREAKLENGTH INTEGER, ZLONGESTSTREAKLENGTH INTEGER, ZPOSTCOUNT INTEGER, ZSTREAKINSIGHT INTEGER, ZTYPE2 INTEGER, ZVIEWSCOUNT5 INTEGER, ZPARENT2 INTEGER, ZCOMMENTSCOUNT1 INTEGER, ZLIKESCOUNT1 INTEGER, ZVIEWSCOUNT6 INTEGER, ZVISITORSCOUNT1 INTEGER, ZCOMMENTCOUNT INTEGER, ZCOMMENTCOUNT1 INTEGER, ZVIEWSCOUNT7 INTEGER, ZPOSTID2 INTEGER, ZTYPE3 INTEGER, ZVIEWSCOUNT8 INTEGER, ZAUTHOR INTEGER, ZPLAYSCOUNT INTEGER, ZPOSTID3 INTEGER, ZCOMMENTSCOUNT2 INTEGER, ZLIKESCOUNT2 INTEGER, ZVIEWSCOUNT9 INTEGER, ZVISITORSCOUNT2 INTEGER, Z_FOK_PARENT INTEGER, Z_FOK_PARENT1 INTEGER, Z_FOK_STATSRECORD INTEGER, Z_FOK_STREAKINSIGHT INTEGER, Z_FOK_PARENT2 INTEGER, Z_FOK_AUTHOR INTEGER, ZBESTVIEWSDAY TIMESTAMP, ZAVERAGECOMMENTSCOUNT FLOAT, ZAVERAGEIMAGESCOUNT FLOAT, ZAVERAGELIKESCOUNT FLOAT, ZAVERAGEWORDSCOUNT FLOAT, ZSUBSCRIBEDDATE TIMESTAMP, ZPUBLISHEDDATE TIMESTAMP, ZCURRENTSTREAKEND TIMESTAMP, ZCURRENTSTREAKSTART TIMESTAMP, ZLONGESTSTREAKEND TIMESTAMP, ZLONGESTSTREAKSTART TIMESTAMP, ZDATE TIMESTAMP, ZPERIODSTART TIMESTAMP, ZICONURLSTRING VARCHAR, ZLABEL VARCHAR, ZURLSTRING VARCHAR, ZCOUNTRYCODE VARCHAR, ZCOUNTRYNAME VARCHAR, ZFILE VARCHAR, ZAVATARURLSTRING VARCHAR, ZNAME VARCHAR, ZFEATUREDIMAGEURLSTRING VARCHAR, ZTITLE VARCHAR, ZURLSTRING1 VARCHAR, ZICONURLSTRING1 VARCHAR, ZNAME1 VARCHAR, ZICONURLSTRING2 VARCHAR, ZLABEL1 VARCHAR, ZURLSTRING2 VARCHAR, ZSEARCHTERM VARCHAR, ZNAME2 VARCHAR, ZURLSTRING3 VARCHAR, ZPOSTID1 VARCHAR, ZPOSTURLSTRING VARCHAR, ZTITLE1 VARCHAR, ZAVATARURLSTRING1 VARCHAR, ZNAME3 VARCHAR, ZAVATARURLSTRING2 VARCHAR, ZNAME4 VARCHAR, ZPOSTURLSTRING1 VARCHAR, ZTITLE2 VARCHAR, ZPOSTURLSTRING2 VARCHAR, ZTITLE3 VARCHAR )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment