Snitz Classifieds Ads 3.4
[DROP]
ADS_CONTENT
[END]
[DROP]
ADS_CATEGORY
[END]
[CREATE]
ADS_CONTENT
ID
TOPIC_ID#int##
NAME#varchar(75)#NULL#
EMAIL#varchar(50)##
DATE_POSTED#varchar (20)##
PRICE#varchar(20)#NULL#
AD_TITLE#varchar(100)##
CONTENT#memo##
ADDRESS#varchar(100)#NULL#
CITY#varchar(50)##
STATE#varchar(20)##
ZIP#varchar(12)#NULL#
LINK#varchar(100)#NULL#
IMAGE_URL#varchar(75)#NULL#
ADDED_BY#int##
[END]
[CREATE]
ADS_CATEGORY
ID
CATEGORY_NAME#varchar(50)##
DESCRIPTION#memo#NULL#
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Computers', 'Accessories, Desktop, Laptop, more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Real Estate', 'Apartments, Condos, more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Automobiles', 'Cars, Imports, Motocycles, more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Wanted', 'Merchandise, Services,  more...')
[END]
[INSERT]
ADS_CATEGORY
(category_name, description)#('Relationships', 'Man seeking Woman, Woman seeking Man, etc...')
[END]