zgjtmgHd

1--
2-- Database: `jpadb`
3--
4CREATE DATABASE `jpadb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
5USE `jpadb`;
6
7-- --------------------------------------------------------
8
9--
10-- Table structure for table `project`
11--
12
13CREATE TABLE IF NOT EXISTS `project` (
14  `pname` varchar(255) DEFAULT NULL,
15  `pnumber` int(11) NOT NULL AUTO_INCREMENT,
16  `plocation` varchar(255) DEFAULT NULL,
17  `dept_no` int(11) DEFAULT NULL,
18  PRIMARY KEY (`pnumber`)
19) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;