From: David B. <db...@sp...> - 2001-03-28 21:15:09
|
On Wed, Mar 28, 2001 at 09:37:18AM -0600, mik...@ba... mangled the electrons to say: > We're about to push some asset management fields into the database. > Does anybody have any recommendations for fields to include? A > list > would be nice... > > CREATE TABLE DATA_FOLDER1 ( > resource_id INT NOT NULL, /* Maps to resource_id > in resource table */ > VALUE2 VARCHAR(255) NULL, > VALUE3 VARCHAR(255) NULL, > VALUE4 VARCHAR(255) NULL, > VALUE5 VARCHAR(16) NULL, /* IP addr in > xxx.xxx.xxx.xxx format */ Perhaps a netmask to go with it.. David Beery -- Wireless First http://www.speedconnect.com MDS, MMDS, ITFS, 2.4Ghz (v) 231 922-2367 (f) 231 922-2370 |