Get HTML - html_pages_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: html_pages_t.sql -- -- Author: Steve Roach -- -- Date: 24-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table HTMP_PAGES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 24-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE html_pages CASCADE CONSTRAINTS / CREATE TABLE html_pages ( name VARCHAR2(30) NOT NULL ,url VARCHAR2(4000) NOT NULL ,username VARCHAR2(4000) ,password VARCHAR2(4000) ) / COMMENT ON TABLE html_pages IS 'Holds details about web pages that may be accessed. This includes the URL and any security information required.' / COMMENT ON COLUMN html_pages.name IS 'Primary key. Local name given to the page for reference purposes. This should be unique and is used as a parameter to page processes so should contain no spaces or special characters.' / COMMENT ON COLUMN html_pages.url IS 'The URL of the page to be accessed.' / COMMENT ON COLUMN html_pages.username IS 'Username if the page requires secure login. NULL if not required.' / COMMENT ON COLUMN html_pages.password IS 'Password if the page requires secure login. NULL if not required.' /