topical media & game development

talk show tell print

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.