File: 7007.sql

package info (click to toggle)
ocsinventory-server 2.5%2Bdfsg1-1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 7,088 kB
  • sloc: php: 27,462; perl: 8,241; sh: 1,680; sql: 1,355; xml: 1,041; makefile: 34
file content (18 lines) | stat: -rwxr-xr-x 713 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
CREATE TABLE batteries (
   `ID` int(11) not null AUTO_INCREMENT,
   `HARDWARE_ID` int(11), 
   `LOCATION` varchar(255) default null, 
   `MANUFACTURER` varchar(255) default null, 
   `MANUFACTUREDATE` varchar(10) default null, 
   `SERIALNUMBER` varchar(255) default null, 
   `NAME` varchar(255) default null, 
   `CHEMISTRY` varchar(20) default null, 
   `DESIGNCAPACITY` varchar(10) default null, 
   `DESIGNVOLTAGE` varchar(20) default null, 
   `SBDSVERSION` varchar(255) default null, 
   `MAXERROR` int(10) default null, 
   `OEMSPECIFIC` varchar(255) default null, 
   PRIMARY KEY (`ID`,`HARDWARE_ID`),
   key `NAME` (`NAME`),
   key `MANUFACTURER` (`MANUFACTURER`)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8;