24 April 2008
My Project “Database”
Pada kali ini merupakan struktur dan data dari database dari project ini, berikut adalah script sqlnya:
– Database: `marupro`
–
– ——————————————————–
–
– Table structure for table `detailteman`
–
CREATE TABLE `detailteman` (
`urut` int(11) NOT NULL auto_increment,
`ip` varchar(25) NOT NULL,
`id` varchar(21) NOT NULL,
`join` datetime NOT NULL,
`lastlogin` datetime default NULL,
`logincount` int(10) NOT NULL default ’0′,
`uploadcount` int(10) NOT NULL default ’0′,
PRIMARY KEY (`urut`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
– ——————————————————–
–
– Table structure for table `file_upload`
–
CREATE TABLE `file_upload` (
`urut` int(11) NOT NULL auto_increment,
`id` varchar(21) NOT NULL,
`path` tinytext NOT NULL,
PRIMARY KEY (`urut`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
– ——————————————————–
–
– Table structure for table `kategori`
–
CREATE TABLE `kategori` (
`idk` int(11) NOT NULL auto_increment,
`nama` varchar(50) NOT NULL,
PRIMARY KEY (`idk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
– ——————————————————–
–
– Table structure for table `komentar`
–
CREATE TABLE `komentar` (
`ido` int(11) NOT NULL auto_increment,
`idt` int(11) NOT NULL,
`email` varchar(50) NOT NULL,
`isi` longtext NOT NULL,
`waktu` datetime NOT NULL,
PRIMARY KEY (`ido`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
– ——————————————————–
–
– Table structure for table `tamu`
–
CREATE TABLE `tamu` (
`urut` int(11) NOT NULL auto_increment,
`ip` varchar(25) NOT NULL,
`email` varchar(50) NOT NULL,
`nama` varchar(50) NOT NULL,
`situs` varchar(50) NOT NULL,
`komen` longtext NOT NULL,
`avatar` varchar(100) NOT NULL,
PRIMARY KEY (`urut`),
KEY `ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
– ——————————————————–
–
– Table structure for table `teman`
–
CREATE TABLE `teman` (
`id` varchar(21) NOT NULL,
`password` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`namaawal` varchar(25) NOT NULL,
`namaakhir` varchar(25) NOT NULL,
`status` tinyint(1) NOT NULL default ’0′,
`level` varchar(13) NOT NULL default ‘user’,
`foto` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
– ——————————————————–
–
– Table structure for table `tutorial`
–
CREATE TABLE `tutorial` (
`idt` int(11) NOT NULL auto_increment,
`judul` varchar(50) NOT NULL,
`isi` longtext NOT NULL,
`waktu` datetime NOT NULL,
`idk` int(11) NOT NULL,
`id` varchar(21) NOT NULL,
`gambar` varchar(100) NOT NULL,
PRIMARY KEY (`idt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
