NxMnn3BF

1DROP TABLE IF EXISTS games;
2			CREATE TABLE games (
3			  game_id BIGINT NOT NULL auto_increment,
4			  sn_app_id varchar(255) default NULL,
5			  sn_api_key varchar(255) default NULL,
6			  sgn_api_secret varchar(255) default NULL,
7			  name varchar(255) default NULL,
8			  canvas varchar(255) default NULL,
9			  owner_userid varchar(255) default NULL,
10			  support_email varchar(255) default NULL,
11			  featured BIGINT default NULL,
12			  partner BIGINT default NULL,
13			  network ENUM('facebook','bebo'),
14			  PRIMARY KEY  (game_id)
15			) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16		
17			DROP TABLE IF EXISTS game_data_names;
18			CREATE TABLE game_data_names (
19			  game_data_names_id BIGINT NOT NULL auto_increment,
20			  game_id BIGINT NOT NULL references games,
21			  name_1 varchar(255) default NULL,
22			  name_2 varchar(255) default NULL,
23			  name_3 varchar(255) default NULL,
24			  name_4 varchar(255) default NULL,
25			  PRIMARY KEY  (game_data_names_id)
26			) ENGINE=InnoDB DEFAULT CHARSET=latin1;
27
28			DROP TABLE IF EXISTS game_data_values;
29			CREATE TABLE game_data_values (
30			  game_data_values_id BIGINT NOT NULL auto_increment,
31			  player_id varchar(255) default NULL,
32			  game_id BIGINT NOT NULL references games,
33			  updated_at datetime default NULL,
34			  name_1 varchar(255) default NULL,
35			  name_2 varchar(255) default NULL,
36			  name_3 varchar(255) default NULL,
37			  name_4 varchar(255) default NULL,
38			  score BIGINT default NULL,
39			  PRIMARY KEY  (game_data_values_id)
40			) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42			DROP TABLE IF EXISTS game_feed;
43			CREATE TABLE game_feed (
44			  game_feed_id BIGINT NOT NULL auto_increment,
45			  player_id BIGINT default NULL,
46			  game_id BIGINT NOT NULL references games,
47			  updated_at datetime default NULL,
48			  message varchar(255) default NULL,
49			  PRIMARY KEY (game_feed_id)
50			) ENGINE=InnoDB DEFAULT CHARSET=latin1;
51
52			DROP TABLE IF EXISTS game_stats;
53			CREATE TABLE game_stats (
54			  game_stats_id BIGINT NOT NULL auto_increment,
55			  game_id BIGINT NOT NULL references games,
56			  out_impressions BIGINT default NULL,
57			  out_clicks BIGINT default NULL,
58			  in_impressions BIGINT default NULL,
59			  in_clicks BIGINT default NULL,
60			  score BIGINT default NULL,
61			  PRIMARY KEY  (game_stats_id)
62			) ENGINE=InnoDB DEFAULT CHARSET=latin1;
63
64			DROP TABLE IF EXISTS schema_info;
65			CREATE TABLE schema_info (
66			  version int(11) default NULL
67			) ENGINE=MyISAM DEFAULT CHARSET=latin1;
68
69			INSERT INTO schema_info (version) VALUES (1)