File: database-irm0.9a.4-0.9b.txt

package info (click to toggle)
irm 1.0.3-2
  • links: PTS
  • area: main
  • in suites: woody
  • size: 816 kB
  • ctags: 753
  • sloc: php: 3,440; sh: 346; makefile: 40
file content (8 lines) | stat: -rw-r--r-- 359 bytes parent folder | download 
1
2
3
4
5
6
7
8
 
ALTER TABLE tracking ADD assign VARCHAR(200) AFTER author;
ALTER TABLE tracking ADD closedate DATETIME AFTER date; 
ALTER TABLE software ADD license INT AFTER location; 
ALTER TABLE computers ADD KEY (location);

CREATE TABLE templ_inst_software (ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), cID INT NOT NULL, INDEX(cID), sID INT NOT NULL, INDEX(sID));