Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DESCRIBE pet:
- Field Type Null Key Default Extra
- id int(11) NO PRI NULL auto_increment
- detail longtext NO UNI NULL
- sugCat int(11) NO 0
- catid int(11) NO MUL NULL
- tags text YES NULL
- date timestamp NO MUL CURRENT_TIMESTAMP
- views int(11) NO 0
- downloads int(11) NO 0
- delreq int(11) NO 0
- country varchar(30) YES US
- ownerID varchar(50) YES ABC
- supOwnID varchar(50) NO NULL
- newdelreq int(11) NO 0
- abnorml int(11) NO 0
- descrpt text YES NULL
- link text YES NULL
- bornDt datetime YES NULL
- DESCRIBE ownrs:
- Field Type Null Key Default Extra
- id int(11) NO PRI NULL auto_increment
- uniqueID varchar(50) NO UNI NULL
- password varchar(64) NO NULL
- salt varchar(3) YES NULL
- question varchar(50) YES NULL
- answer varchar(30) YES NULL
- email varchar(50) NO NULL
- name varchar(30) NO MUL DEF
- joindate timestamp NO CURRENT_TIMESTAMP
- age int(11) YES NULL
- location text YES NULL
- contact mediumtext YES NULL
- super int(11) NO 0
- male int(11) NO 1
- catlimit int(11) NO 2
- makeWait int(11) NO 0
- modOwnr int(11) NO 0
- DESCRIBE petfb:
- Field Type Null Key Default Extra
- id int(11) NO PRI NULL auto_increment
- petid int(11) NO MUL NULL
- feedback int(11) NO MUL NULL
- fbdate timestamp NO CURRENT_TIMESTAMP
- ownrid varchar(50) NO MUL NULL
- ownerid varchar(50) NO MUL NULL
- sugownid int(11) NO 0
- DESCRIBE comments:
- Field Type Null Key Default Extra
- id int(11) NO PRI NULL auto_increment
- comment longtext NO NULL
- comDate timestamp NO MUL CURRENT_TIMESTAMP
- petid int(11) NO MUL NULL
- ownrid varchar(50) NO MUL NULL
- likes int(11) NO 0
- dislk int(11) NO 0
- report int(11) NO 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement