rmvL6dBN

1--
2-- Table structure for table `audio_visual_license_request_table`
3--
4
5DROP TABLE IF EXISTS `audio_visual_license_request_table`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `audio_visual_license_request_table` (
9  `id` int(11) NOT NULL AUTO_INCREMENT,
10  `customer_id` int(11) DEFAULT '0',
11  `order_id` int(11) DEFAULT '0',
12  `license_applicant_name` varchar(255) DEFAULT NULL,
13  `license_applicant_number` varchar(255) DEFAULT NULL,
14  `license_applicant_address` varchar(255) DEFAULT NULL,
15  `license_applicant_zipCode` varchar(255) DEFAULT NULL,
16  `license_applicant_country` varchar(255) DEFAULT NULL,
17  `license_customer_name` varchar(255) DEFAULT NULL,
18  `license_email_address` varchar(255) DEFAULT NULL,
19  `license_telephone_number` varchar(255) DEFAULT NULL,
20  `license_client` varchar(255) DEFAULT NULL,
21  `license_client_applicant_number` varchar(255) DEFAULT NULL,
22  `license_client_address` varchar(255) DEFAULT NULL,
23  `license_client_zipCode` varchar(255) DEFAULT NULL,
24  `license_client_city` varchar(255) DEFAULT NULL,
25  `license_client_country` varchar(255) DEFAULT NULL,
26  `license_applicant_city` varchar(255) DEFAULT NULL,
27  `license_client_customer_name` varchar(255) DEFAULT NULL,
28  `license_client_email_address` varchar(255) DEFAULT NULL,
29  `license_client_telephone_number` varchar(255) DEFAULT NULL,
30  `production_title` varchar(255) DEFAULT NULL,
31  `serial_catalog_number` varchar(255) DEFAULT NULL,
32  `audio_visual_source` varchar(255) DEFAULT NULL,
33  `quantity` varchar(255) DEFAULT NULL,
34  `budget` varchar(255) DEFAULT NULL,
35  `reproduction` varchar(5) DEFAULT NULL,
36  `license_disc_type` varchar(255) DEFAULT NULL,
37  `audio_titles` int(11) DEFAULT NULL,
38  `audio_visual_purpose` varchar(255) DEFAULT NULL,
39  `DVD_length_in_seconds` int(11) DEFAULT NULL,
40  `music_length_in_seconds` int(11) DEFAULT '0',
41  `date_of_insert` datetime DEFAULT '0000-00-00 00:00:00',
42  `remarks` varchar(255) DEFAULT NULL,
43  `license_fee` float DEFAULT '0',
44  `initialRecordingFee` float DEFAULT '0',
45  `CopyLicensePerDisc` float DEFAULT '0',
46  `CopyLicenseTotal` float DEFAULT '0',
47  `musicBlocks` float DEFAULT '0',
48  PRIMARY KEY (`id`)
49) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
50/*!40101 SET character_set_client = @saved_cs_client */;