eiVXceLc

1- For Cast
2CREATE TABLE IF NOT EXISTS `live_casts` (
3  `player_id` int(11) NOT NULL,
4  `cast_name` varchar(255) NOT NULL,
5  `password` tinyint(1) NOT NULL DEFAULT '0',
6  `description` varchar(255) DEFAULT NULL,
7  `spectators` smallint(5) DEFAULT '0',
8  UNIQUE KEY `player_id_2` (`player_id`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1;
10
11- For houses
12CREATE TABLE IF NOT EXISTS `houses` (
13  `id` int(11) NOT NULL AUTO_INCREMENT,
14  `owner` int(11) NOT NULL,
15  `paid` int(10) unsigned NOT NULL DEFAULT '0',
16  `warnings` int(11) NOT NULL DEFAULT '0',
17  `name` varchar(255) NOT NULL,
18  `rent` int(11) NOT NULL DEFAULT '0',
19  `town_id` int(11) NOT NULL DEFAULT '0',
20  `bid` int(11) NOT NULL DEFAULT '0',
21  `bid_end` int(11) NOT NULL DEFAULT '0',
22  `last_bid` int(11) NOT NULL DEFAULT '0',
23  `highest_bidder` int(11) NOT NULL DEFAULT '0',
24  `size` int(11) NOT NULL DEFAULT '0',
25  `beds` int(11) NOT NULL DEFAULT '0',
26  PRIMARY KEY (`id`),
27  KEY `owner` (`owner`),
28  KEY `town_id` (`town_id`)
29) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2506 ;
30
31- Newstickers
32CREATE TABLE IF NOT EXISTS `z_news_tickers` (
33  `date` int(11) NOT NULL DEFAULT '1',
34  `author` int(11) NOT NULL,
35  `image_id` int(3) NOT NULL DEFAULT '0',
36  `text` text NOT NULL,
37  `hide_ticker` tinyint(1) NOT NULL
38) ENGINE=MyISAM DEFAULT CHARSET=latin1;