Originally posted by dexterdom
View Post
Code:
CREATE TABLE tblCallerDetails( id INTEGER PRIMARY KEY, nmbr varchar(15) NOT NULL, name varchar(25) NOT NULL, attr INTEGER, notes varchar(255), last_ts integer, call_count INTEGER ) CREATE UNIQUE INDEX idxNUMR2 ON tblCallerDetails (nmbr) CREATE INDEX idxNAME2 ON tblCallerDetails (name) CREATE INDEX idxATTR2 ON tblCallerDetails (attr)
So, when you insert the data:
- nmbr would be the telephone number with no spaces.
- name would typically be Last Name, First Name
- attr is a numeric flag enum:
None = 0
Block = 1
Telemarketer = 2
Announce = 4
Business = 8
Family = 16
Friends = 32 - notes can be any text <= 255 characters.
- last_ts should be set to 0
- call_count should be set to 0
Regards,
Ultrajones
Comment