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","