EPpjaH1k

1SET FOREIGN_KEY_CHECKS=0;
2
3
4DROP table IF EXISTS `camera_photos`;
5CREATE table `camera_photos` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `creator_id` int(11) NOT NULL,
8  `creator_name` varchar(50) NOT NULL,
9  `file_state` enum('purchased','preview') NOT NULL DEFAULT 'preview',
10  `file_name` varchar(50) NOT NULL,
11  `reports` int(11) NOT NULL DEFAULT '0',
12  `deleted` enum('1','0') NOT NULL DEFAULT '0',
13  `ip_address` varchar(50) NOT NULL,
14  `created_at` int(11) NOT NULL DEFAULT '0',
15  PRIMARY KEY (`id`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17
18
19ALTER table permissions_ranks ADD command_update_camera ENUM('0','1') NOT NULL DEFAULT '0'
20
21
22INSERT INTO `server_settings` VALUES ('camera.photo.publish.price.duckets', '100', 'The duckets-price of a web publish');
23INSERT INTO `server_settings` VALUES ('camera.photo.purchase.item_id', '777954880', 'The item id of the default photo poster');
24INSERT INTO `server_settings` VALUES ('camera.photo.purchase.price.coins', '100', 'The coins-price of a photo poster');
25INSERT INTO `server_settings` VALUES ('camera.photo.purchase.price.duckets', '100', 'The duckets-price of a photo poster');