Web Marketing Tool
Reseller
WMT .
designs
Login

Table: designs



Tool: Design Management
Associated Objects: Designs, Design

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v2
member INT UNSIGNED NOT NULL v5
title VARCHAR(255) v2.1
designtype TINYINT UNSIGNED v2.1
description TEXT v5
price FLOAT v2.1
paid FLOAT v2.1
scriptapproved BOOL v2.1
designapproved BOOL v2.1
complete BOOL v2.1
photosapproved BOOL v2.1
added INT UNSIGNED v2.1
updated INT UNSIGNED v2.1
template INT UNSIGNED default 1 v5
site INT UNSIGNED DEFAULT 0 v5
lastemployeeactiontime INT UNSIGNED DEFAULT 0 v2
lastclientactiontime INT UNSIGNED v2.1
lastemployeeactionid INT UNSIGNED v2.1
lastemployeeaction VARCHAR(50) v2.1
lastclientaction VARCHAR(50) v2.1
statusupdated INT UNSIGNED DEFAULT 0 v2.1
statuscolor TINYINT v2.1
draftupdated INT UNSIGNED DEFAULT 0 v2.1
revisions TINYINT DEFAULT 0 v2.1
locked BIT(1) DEFAULT 0 v2.1
photos TINYINT DEFAULT 5 v2.1
designtemplate INT UNSIGNED DEFAULT 0 v5
url VARCHAR(100) v2.1


Example PHP Usage

The following php example is designed for the main folder: /


Other Design Management Tables

designnotes     designphotos     designrevisions     designs     designtemplates     designtypes     setupdesign    



webmarketingtool.com Webutation DMCA.com Protection Status Authorize.net GoDaddy
Valid HTML! Valid CSS!


Reseller: WMT
|
Login
(502) 225-3237