tWGexDi6

1-- ---
2-- Globals
3-- ---
4
5-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
6-- SET FOREIGN_KEY_CHECKS=0;
7
8-- ---
9-- Table 'filenames'
10-- 
11-- ---
12
13DROP TABLE IF EXISTS `filenames`;
14		
15CREATE TABLE `filenames` (
16  `uid` INT(255) NOT NULL AUTO_INCREMENT DEFAULT NULL,
17  `driveid` CHAR(255) NULL DEFAULT NULL,
18  `filename` CHAR NULL DEFAULT NULL,
19  `full_path` CHAR(255) NULL DEFAULT NULL,
20  `file_size` INTEGER NULL DEFAULT NULL,
21  `md5` INTEGER NULL DEFAULT NULL,
22  PRIMARY KEY (`uid`)
23);
24
25-- ---
26-- Table 'driveinfo'
27-- 
28-- ---
29
30DROP TABLE IF EXISTS `driveinfo`;
31		
32CREATE TABLE `driveinfo` (
33  `driveid` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
34  `drive_size` INTEGER NULL DEFAULT NULL,
35  `brand` INTEGER NULL DEFAULT NULL,
36  `file_system` INTEGER NULL DEFAULT NULL,
37  PRIMARY KEY (`driveid`)
38);
39
40-- ---
41-- Foreign Keys 
42-- ---
43
44ALTER TABLE `filenames` ADD FOREIGN KEY (driveid) REFERENCES `driveinfo` (`driveid`);
45
46-- ---
47-- Table Properties
48-- ---
49
50-- ALTER TABLE `filenames` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
51-- ALTER TABLE `driveinfo` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
52
53-- ---
54-- Test Data
55-- ---
56
57-- INSERT INTO `filenames` (`uid`,`driveid`,`filename`,`full_path`,`file_size`,`md5`) VALUES
58-- ('','','','','','');
59-- INSERT INTO `driveinfo` (`driveid`,`drive_size`,`brand`,`file_system`) VALUES
60-- ('','','','');