URL:
<http://gna.org/support/?2134>
Summary: tourney attributes completion
Project: pokersource
Submitted by: loic
Submitted on: Monday 10/13/2008 at 10:27
Category: poker-network
Priority: 5 - Normal
Severity: 3 - Normal
Status: In Progress
Privacy: Public
Assigned to: proppy
Originator Email:
Open/Closed: Open
Discussion Lock: Any
Operating System: None
Effort: 0.00
_______________________________________________________
Details:
Implement the tourney attributes based on the attrtourney architecture.
CREATE TABLE `prizes` (
`serial` int(11) NOT NULL auto_increment,
/* Short name of the prize */
`name` varchar(255) default NULL,
/* Long description of the prize */
`description` varchar(255) default NULL,
/* URL to the image to be displayed */
`image_url` text,
PRIMARY KEY (`serial`)
);
CREATE TABLE `results` (
`serial` int(11) NOT NULL auto_increment,
/* Foreign key to users table */
`user_serial` int(11) default NULL,
/* Foreign key to tourneys table */
`tourney_serial` int(11) default NULL,
/* Foreign key to prizes table */
`prize_serial` int(11) default NULL,
/* Indicates if the player was the winner or not */
`is_winner` int(1) default '0',
PRIMARY KEY (`serial`),
UNIQUE KEY `winner` (`user_serial`,`tourney_serial`)
);
CREATE TABLE `ads` (
`serial` int(11) NOT NULL auto_increment,
/* Name for the video */
`name` varchar(255) default NULL,
/* type should be 'flv' */
`type` varchar(100) default 'flv',
/* Filesize */
`size` int(16) default NULL,
/* Title for the ad */
`title` varchar(255) default NULL,
/* Description of the ad */
`description` varchar(255) default NULL,
/* Width in pixels */
`width` int(10) default '100',
/* Height in pixels */
`height` int(10) default '100',
/* Type of video - 1 = ad displayed during break. 2 = ad displayed during
registration. 3 = ad displayed when tourney ends */
`custom_type` int(10) default '0',
/* Foreign key to the `tourneys` table */
`tourney_serial` int(11) default NULL,
/* The break at which this ad is displayed. 0 = start of tourney, 1 = first
break and so on */
`break_num` int(11) default NULL,
/* Length is seconds of the clip */
`clip_length` int(11) default NULL,
PRIMARY KEY (`serial`),
KEY `custom_id` (`custom_id`)
);
Additionals to table `tourneys`:
/* Foreign key to the table `prizes` */
`prize_serial` int(11) default NULL,
/* Name of the sponsor */
`sponsor` varchar(255) default NULL,
/* URL of the sponsor website */
`sponsor_url` varchar(255) default NULL,
/* Flag to indicate if the tourney is monthly or not */
`is_monthly` int(1) default '0',
_______________________________________________________
Reply to this item at:
<http://gna.org/support/?2134>
_______________________________________________
Message sent via/by Gna!
http://gna.org/
_______________________________________________
Pokersource-users mailing list
[email protected]
https://mail.gna.org/listinfo/pokersource-users
