-
Notifications
You must be signed in to change notification settings - Fork 8
/
dbo.py
executable file
·40 lines (39 loc) · 1.3 KB
/
dbo.py
1
2
3
4
5
6
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
def create_schema(cur):
cur.execute("""CREATE TABLE IF NOT EXISTS sds(
timestamp INT,
arfcn INT,
timeslot INT,
comment TEXT,
raw TEXT,
MAC_PDU_CHANNEL_ALLOCATION_FLAG INT,
MAC_PDU_TYPE INT,
MAC_FILL_BIT_INDICATION INT,
MAC_PDU_TO INT,
LLC_FCS INT,
LLC_PDU_TYPE INT,
MLE_PROTOCOL_DISCRIMINATOR INT,
CMCE_PDU_TYPE INT,
DSDS_DATA_PDU_Calling_party_type_identifier INT,
DSDS_DATA_PDU_FROM INT,
DSDS_DATA_PDU_ADDRESS_EXTENSION INT,
DSDS_DATA_PDU_SHORT_DATA_TYPE INT,
DSDS_DATA_RAW TEXT,
ASCIIDEC TEXT,
SDS_TYPE_4_PROTOCOL_INDENTIFIER INT,
SDS_TYPE_4_MESSAGE_TYPE INT,
SDS_T4_TRANSFER_FORWARD_ADDRESS_TYPE INT,
SDS_T4_TRANSFER_DELIVERY_REPORT_REQUIRED INT,
SDS_T4_TRANSFER_SERVICE_SELECTION INT,
SDS_T4_TRANSFER_STORAGE INT,
SDS_T4_TRANSFER_MESSAGE_REFERENCE INT,
DS_T4_TRANSFER_TEXT_MESSAGE_TIMESTAMP_USED INT,
DS_T4_TRANSFER_TEXT_MESSAGE_TEXT_CODING_SCHEME INT,
DS_T4_TRANSFER_TEXT_MESSAGE_TIMESTAMP INT,
DS_T4_TRANSFER_USER_DATA_ASCII_INDEX INT,
SDS_T4_REPORT_ACK_REQUIRED INT,
SDS_T4_REPORT_RESERVED_BITS INT,
SDS_T4_REPORT_STORAGE INT,
SDS_T4_REPORT_DELIVERY_STATUS INT,
SDS_T4_REPORT_MESSAGE_REFERENCE INT,
SDS_T4_REPORT_USER_DATA INT,
SDS_T4_REPORT_USER_DATA_ASCII_INDEX INT)""")