topical media & game development
professional-sql-09-sql-tables.sql / sql
DROP TABLE IF EXISTS WROX_SITE_ACCESS;
CREATE TABLE WROX_SITE_ACCESS (
ACCESS_TIME TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
IP_ADDRESS INTEGER UNSIGNED NOT NULL,
REQ_PAGE VARCHAR(255) NOT NULL,
PRIMARY KEY (ACCESS_TIME, IP_ADDRESS)
)
ENGINE=InnoDB DEFAULT CHARACTER SET latin1
COLLATE latin1_general_cs;
(C) Æliens
20/2/2008
You may not copy or print any of this material without explicit permission of the author or the publisher.
In case of other copyright issues, contact the author.