5dNpzrLz

1CREATE DATABASE /*!32312 IF NOT EXISTS*/`test` /*!40100 DEFAULT CHARACTER SET latin1 */;
2
3USE `test`;
4
5/*Table structure for table `item` */
6
7DROP TABLE IF EXISTS `item`;
8
9CREATE TABLE `item` (
10  `id` int(10) unsigned NOT NULL auto_increment,
11  `item` varchar(100) default NULL,
12  `user_id` int(10) default NULL,
13  PRIMARY KEY  (`id`)
14) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
15
16/*Data for the table `item` */
17
18insert  into `item`(`id`,`item`,`user_id`) values (1,'Item 1',1),(2,'Item 2',1),(3,'Item 3',2),(4,'Item 4',2),(5,'Item 5',3),(6,'Item 6',3);
19
20/*Table structure for table `user` */
21
22DROP TABLE IF EXISTS `user`;
23
24CREATE TABLE `user` (
25  `id` int(10) unsigned NOT NULL auto_increment,
26  `user` varchar(100) default NULL,
27  PRIMARY KEY  (`id`)
28) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
29
30/*Data for the table `user` */
31
32insert  into `user`(`id`,`user`) values (1,'User 1'),(2,'User 2'),(3,'User 3'),(4,'User 4');