-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsql.sql
More file actions
22 lines (18 loc) · 781 Bytes
/
Copy pathsql.sql
File metadata and controls
22 lines (18 loc) · 781 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
CREATE TABLE IF NOT EXISTS `tbl_user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) NOT NULL,
`user_password` varchar(255) NOT NULL,
`user_created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`user_edited_date` datetime DEFAULT NULL,
PRIMARY KEY (`user_id`,`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE TABLE IF NOT EXISTS `tbl_company` (
`company_id` int(11) NOT NULL AUTO_INCREMENT,
`company_name` varchar(255) NOT NULL,
`company_email` varchar(255) NOT NULL,
`company_website` text NOT NULL,
`company_phoneno` varchar(255) NOT NULL,
`company_contactperson` varchar(255) NOT NULL,
`salary` float NOT NULL,
PRIMARY KEY (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;