/home/desid573/public_html/ims2/system/sqlite
Edit: /home/desid573/public_html/ims2/system/sqlite/1410inventory.sqlite (13312B)
SQLite format 3 @ ]
( ] -r
P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)>[tableadminadminCREATE TABLE 'admin' (
'id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
'first_name' TEXT NOT NULL,
'last_name' TEXT NOT NULL,
'email' TEXT NOT NULL,'mobile1' TEXT NOT NULL,'mobile2' TEXT DEFAULT NULL,
'password' TEXT NOT NULL,
'role' TEXT NOT NULL,
'created_on' DATETIME NOT NULL,
'last_login' DATETIME,
'last_seen' DATETIME,
'last_edited' DATETIME DEFAULT CURRENT_TIMESTAMP,'account_status' BOOLEAN DEFAULT 1 ,'deleted' BOOLEAN DEFAULT 0 ,
CONSTRAINT admin_email_unique UNIQUE(email),
CONSTRAINT admin_mobile_unique UNIQUE(mobile1)
))= indexsqlite_autoindex_admin_2admin)= indexsqlite_autoindex_admin_1admi
1 1 L -##3333 AdminDemodemo@1410inc.xyz0802111111107032222222$2y$10$xv9I14OlR36kPCjlTv.wEOX/6Dl7VMuWCl4vCxAVWP1JwYIaw4J2CSuper2016-05-27 16:43:212017-01-06 10:15:152017-04-07 17:31:402016-05-27 15:43:37
- demo@1410inc.xyz
# 08021111111
%transactions items eventlog admin
a P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)>[tableadminadminCREATE TABLE 'admin' (
'id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
'first_name' TEXT NOT NULL,
'last_name' TEXT NOT NULL,
'email' TEXT NOT NULL,'mobile1' TEXT NOT NULL,'mobile2' TEXT DEFAULT NULL,
'password' TEXT NOT NULL,
'role' TEXT NOT NULL,
'created_on' DATETIME NOT NULL,
'last_login' DATETIME,
'last_seen' DATETIME,
'last_edited' DATETIME DEFAULT CURRENT_TIMESTAMP,'account_status' BOOLEAN DEFAULT 1 ,'deleted' BOOLEAN DEFAULT 0 ,
CONSTRAINT admin_email_unique UNIQUE(email),
CONSTRAINT admin_mobile_unique UNIQUE(mobile1)
) = )= indexsqlite_autoindex_admin_2admin)= indexsqlite_autoindex_admin_1admin
H f P f H H qtableitemsitems CREATE TABLE 'items' (
'id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,'name' TEXT NOT NULL,'code' TEXT NOT NULL,
'description' TEXT,
'unitPrice' REAL NOT NULL,
'quantity' NUMERIC NOT NULL,
'dateAdded' DATETIME NOT NULL,
'lastUpdated' DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT name_unique UNIQUE (name),
CONSTRAINT code_unique UNIQUE (code)
))= indexsqlite_autoindex_items_2items )= indexsqlite_autoindex_items_1items
X ]tableeventlogeventlogCREATE TABLE 'eventlog' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'event' TEXT NOT NULL,'eventRowIdOrRef' INTEGER, 'eventDesc' TEXT, 'eventTable' TEXT, 'staffInCharge' INTEGER, 'eventTime' DATETIME DEFAULT CURRENT_TIMESTAMP) ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq))= indexsqlite_autoindex_admin_2admin)= indexsqlite_autoindex_admin_1admin
p %%#tabletransactionstransactions CREATE TABLE 'transactions' ('transId' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,'ref' TEXT NOT NULL, 'itemName' TEXT NOT NULL, 'itemCode' TEXT NOT NULL, 'description' TEXT, 'quantity' NUMERIC NOT NULL, 'unitPrice' REAL NOT NULL, 'totalPrice' REAL NOT NULL, 'totalMoneySpent' REAL NOT NULL, 'amountTendered' REAL NOT NULL, 'changeDue' REAL NOT NULL, 'modeOfPayment' TEXT NOT NULL, 'transType' INTEGER NOT NULL, 'staffId' INTEGER NOT NULL, 'transDate' DATETIME NOT NULL, 'lastUpdated' DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,'cancelled' BOOLEAN NOT NULL DEFAULT 0 ,'vatAmount' REAL,'vatPercentage' REAL, 'discount_amount' REAL, 'discount_percentage' REAL, 'cust_name' TEXT, 'cust_phone' TEXT, 'cust_email' TEXT)