28 lines
711 B
SQL
28 lines
711 B
SQL
CREATE TABLE `files` (
|
|
`id` int(10) NOT NULL auto_increment,
|
|
`pid` varchar(100) NOT NULL,
|
|
`timest` int(10) NOT NULL,
|
|
`expire` int(10) NOT NULL,
|
|
`file` varchar(250) NOT NULL,
|
|
`name` varchar(250) NOT NULL,
|
|
`size` int(10) NOT NULL,
|
|
`mime` varchar(100) NOT NULL,
|
|
`downloads` int(10) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
|
|
|
|
CREATE TABLE `pastebin` (
|
|
`id` int(10) NOT NULL auto_increment,
|
|
`pid` varchar(100) NOT NULL,
|
|
`timest` int(10) NOT NULL,
|
|
`expire` int(10) NOT NULL,
|
|
`downloads` int(11) NOT NULL,
|
|
`payload` text NOT NULL,
|
|
`syntax` varchar(20) NOT NULL,
|
|
`pub` int(1) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
|
|
|