All pastes #428874 Raw Edit

table

public php v1 · immutable
·published 2007-04-07 21:54 UTC
rendered paste body
$sql = 'DROP TABLE IF EXISTS `' . table_pageviews . '`;';mysql_query( $sql, $conn );$sql = "CREATE TABLE `" . table_pageviews . "` (  `pv_id` int(10) unsigned NOT NULL auto_increment,  `pv_type` enum('story','out','profile') NOT NULL default '',  `pv_page_id` int(11) NOT NULL default '0',  `pv_datetime` timestamp NOT NULL,  `pv_user_id` int(11) NOT NULL default '0',  `pv_user_ip` varchar(64) default NULL,  PRIMARY KEY  (`pv_id`),) TYPE = MyISAM;";echo 'Creating table: \'pageviews\'....<BR/>';mysql_query( $sql, $conn );