Class: ScribeDb::CreateDb

Inherits:
Object
  • Object
show all
Defined in:
lib/scribelite/schema.rb

Instance Method Summary collapse

Instance Method Details

#up ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
 
# File 'lib/scribelite/schema.rb', line 7

def up

ActiveRecord::Schema.define do

create_table :scribes, :id => :string do |t|    
    ## "id": "0a3a4dbf6630338bc4df8e36bd081f8f7d2dee9441131cb03a18d43eb4882d5ci0",
    ## note: change to uuid (universally unique id) - why? why not?
    ##        id gets used by row_id (internal orm db machinery) and is int
   ## t.string   :uuid,  null: false, index: { unique: true, name: 'scribe_uuids' }

   ## "title": "Inscription 10371414",
   ##   note: use num/no. from title only - why? why not?
    t.integer  :num, null: false, index: { unique: true, name: 'scribe_nums' }
   
    ##  "content length": "85 bytes",
    ## note:  extract bytes as integer!!!
    ##    change to bytes - why? why not?
    t.integer  :bytes
    ## "content type": "text/plain;charset=utf-8",
    ## note: make sure always lower/down case!!!
    t.string   :content_type

    ## add allow duplicate opt-in protocol flag e.g. esip6
    t.boolean    :duplicate      ## allows duplicates flag - make duplicate the default - why? why not?
    t.boolean    :flagged,  null: false,  default: false  ## censored flag / removed on request

    ## move sha to tx - why? why not?
    t.string     :sha    # ,  null: false    ## sha hash as hexstring

  ## timestamp last
  t.timestamps
end


## change to tx/txs or txn/txns - why? why not?

create_table :txs, :id => :string do |t|
    ## "id": "0a3a4dbf6630338bc4df8e36bd081f8f7d2dee9441131cb03a18d43eb4882d5ci0",
    ## note: change to uuid (universally unique id) - why? why not?
    ##        id gets used by row_id (internal orm db machinery) and is int
    ## t.string   :id,  null: false, index: { unique: true, name: 'blob_uuids' }
 
    t.binary     :data     # ,  null: false
 
    ## "timestamp": "2023-06-01 05:00:57 UTC"
    ##   or use date_utc ???
    ##   or change to t.integer AND timestamp  or time or epoch(time) - why? why not?
    t.datetime    :date, null: false

    t.integer    :block, null: false
    t.integer    :idx,   null: false  ## transaction index (number)

    t.string     :from, null: false
    t.string     :to,   null: false   

    t.integer    :fee
    t.integer    :value

  
    ## timestamp last
  t.timestamps
end

end # block Schema.define

end