CREATE TABLE html ( id int not null auto_increment primary key, tag_name varchar(255) not null, tag_titl varchar(255), tag_desc text not null, tag_comp text not null, tag_euri text not null ); CREATE INDEX idx_html ON html( tag_name(150) ); CREATE TABLE css ( id int not null auto_increment primary key, property_name varchar(255) not null, property_titl varchar(255) not null, property_desc text not null, property_comp text not null, property_euri text not null ); CREATE INDEX idx_css ON css( property_name(150) ); CREATE TABLE core_attributes ( id int not null auto_increment primary key, attr_name varchar(255) not null, attr_desc text not null ); CREATE INDEX idx_cattr ON core_attributes( attr_name(150) ); CREATE TABLE tag_attributes ( id int not null auto_increment primary key, attr_name varchar(255) not null, attr_desc text not null, attr_rela text not null ); CREATE INDEX idx_tattr ON tag_attributes( attr_name(150) ); -- -- CORE EVENT ATTRIBUTES -- INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onclick','The onclick attribute is one of the most commonly used DHTML attributes. It tells the browser to implement the script when the element is clicked on with the mouse or pointer.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('ondblclick','Like the onclick attribute, the ondblclick attribute takes effect when the element is double clicked on. This is not as commonly found on Web pages, but can give your Web page the same functionality as an OS icon.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onmousedown','The onmousedown attribute activates when a mouse or pointer button is pressed down on the element.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onmouseup','The onmouseup attribute activates when a mouse or pointer button is released on the element.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onmousemove','The onmousemove attribute activates when a mouse or pointer is moved within the element.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onmouseout','The onmouseout attribute activates when a mouse or pointer is moved off of the element.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onmouseover','The onmouseover attribute activates when a mouse or pointer is moved onto the element.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onkeydown','The onkeydown attribute activates when a key is pressed down. This and the other key related events can often be difficult to activate over specific elements other than the entire body of the document.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onkeyup','The onkeyup attribute activates when a key is released.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onkeypress','The onkeypress attribute activates when a key is pressed and released.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onfocus','The onfocus attribute refers to when the focus or attention of the browser is on that element. This would be in a form field when the cursor is blinking in that field, or when an anchor element is highlighted. Scripts are kicked off when that element gains the focus.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onblur','The onblur attribute is the opposite of the onfocus attribute. It kicks off the script when the focus leaves the element, such as when the next form element is activated or some other portion of the screen is clicked.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onchange','The onchange attribute takes effect when the element value was changed.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onselect','The onselect attribute takes effect when some text is highlighted within a form field.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onreset','The onreset attribute takes effect when the form is reset (ie. the customer clicks on the reset button).'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onsubmit','The onsubmit attribute takes effect when the form is submitted (ie. the customer clicks on the submit button).'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onload','The onload attribute works when the page or frame is completely loaded into the browser. Note that some browsers execute this event when the page is first loaded, and others wait until every element of the page is loaded.'); INSERT INTO core_attributes(attr_name,attr_desc) VALUES('onunload','The onunload attribute works when the page or frame is exited.'); -- -- TAG ATTRIBUTES -- -- -- HTML TAGS -- INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("a"," (Anchor)","This element defines a hyperlink, the named target destination for a hyperlink, or both.","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 1.1, 2, 3, 4, 4.5-4.8, 6, 7Opera 4-7","http://www.htmlref.com/reference/appa/tag_a.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("abbr"," (Abbreviation)","This element allows authors to clearly indicate a sequence of characters that define an abbreviation for a word (such as Mr. instead of Mister, Calif instead of California).","HTML 4, 4.01, XHTML 1.0, 1.1, BasicNetscape 6, 7Opera 6, 7","http://www.htmlref.com/reference/appa/tag_abbr.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("acronym"," (Acronym)"," This element allows authors to clearly indicate a sequence of characters that compose an acronym or abbreviation for a word (XML, WWW, and so on). "," HTML 4, 4.01, XHTML 1.0, 1.1, BasicInternet Explorer 4, 5, 5.5, 6Netscape 6 ","http://www.htmlref.com/reference/appa/tag_acronym.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("address","
(Address)","This element marks up text indicating authorship or ownership of information. It generally occurs at the beginning or end of a document. "," HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 1.1, 2, 3, 4, 4.5-4.8, 6, 7Opera 4","http://www.htmlref.com/reference/appa/tag_address.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("applet"," (Java Applet)","This element identifies the inclusion of a Java applet. The strict HTML 4.01 definition does not include this element; it has been deprecated in favor of .","HTML 2, 3.2, 4, 4.01, and XHTML 1.0 (transitional)Internet Explorer 2, 3, 4, 5, 5.5, 6Netscape 2, 3, 4, 4.5-4.8, 6, 7","http://www.htmlref.com/reference/appa/tag_applet.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("area"," (Image Map Area)","Defines a hot-spot region on an image, and associates it with a hypertext link. This element is used only within a tag.","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 2, 3, 4- 4.7, 6, 7Opera 4-7","http://www.htmlref.com/reference/appa/tag_area.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("b"," (Bold)","This eblement indicates that the enclosed text should be displayed in boldface.","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 2, 3, 4- 4.7, 6, 7Opera 4-7","http://www.htmlref.com/reference/appa/tag_b.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("base"," (Base URL)","This element specifies the base URL to use for all relative URLs contained within a document.","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 2, 3, 4- 4.7, 6, 7Opera 4-7","http://www.htmlref.com/reference/appa/tag_base.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("basefont"," (Base Font)","This element establishes a default font size for a document. Font size then can be varied relative to the base font size using the element. ","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 2, 3, 4 5.5-4.8","http://www.htmlref.com/reference/appa/tag_basefont.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("bdo"," (Bidirectional Override)","This element is used to override the current directionality of text.","HTML 4, 4.01, XHTML 1.0, 1.1Internet Explorer 5, 5.5, 6Netscape 6, 7Opera 7","http://www.htmlref.com/reference/appa/tag_bdo.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("bgsound"," (Background Sound)","This Internet Explorer element associates a background sound with a page.","No standards, Internet Explorer 2, 3, 4, 5, 5.5, 6","http://www.htmlref.com/reference/appa/tag_bgsound.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("big"," (Big Font)","Indicates that the enclosed text should be displayed in a larger font relative to the current font.","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 1.1, 2, 3, 4, 4.5-4.8, 6, 7Opera 4-7","http://www.htmlref.com/reference/appa/tag_big.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("blink"," (Blinking Text Display)","This Netscape-specific element causes the enclosed text to flash slowly.","No Standards, Netscape 1, 2, 3, 4- 4.7, 6, 7","http://www.htmlref.com/reference/appa/tag_blink.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("blockquote","
(Block Quote)","This block element indicates that the enclosed text is an extended quotation. Usually, this is rendered visually by indentation.","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 2, 3, 4- 4.7, 6, 7Opera 4-7","http://www.htmlref.com/reference/appa/tag_blockquote.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("body"," (Document Body)","This element encloses a document\"s displayable content.","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 2, 3, 4- 4.7, 6, 7Opera 4-7","http://www.htmlref.com/reference/appa/tag_body.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("br","
(Line Break)","This empty element forces a line break.","HTML 2, 3.2, 4, 4.01, and XHTML 1.0, 1.1, BasicInternet Explorer 2, 3, 4, 5, 5.5, 6Netscape 1, 2, 3, 4- 4.7, 6, 7Opera 4-7","http://www.htmlref.com/reference/appa/tag_break.htm"); INSERT INTO html(tag_name,tag_titl,tag_desc,tag_comp,tag_euri) VALUES("button","