CREATE TABLE `cccp_languages` (
`id` INT( 4 ) NOT NULL ,
`language` VARCHAR( 16 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`language`
)
) TYPE = MYISAM ;

INSERT INTO `cccp_languages` VALUES ( 1,'Plain Text');
INSERT INTO `cccp_languages` VALUES ( 2,'Java');
INSERT INTO `cccp_languages` VALUES ( 3,'Perl');
INSERT INTO `cccp_languages` VALUES ( 4,'PHP');
INSERT INTO `cccp_languages` VALUES ( 5,'Python');
INSERT INTO `cccp_languages` VALUES ( 6,'C');
INSERT INTO `cccp_languages` VALUES ( 7,'C89');
INSERT INTO `cccp_languages` VALUES ( 8,'C++');
INSERT INTO `cccp_languages` VALUES ( 9,'C#');
INSERT INTO `cccp_languages` VALUES ( 10,'Ruby');
INSERT INTO `cccp_languages` VALUES ( 11,'VB');
INSERT INTO `cccp_languages` VALUES ( 12,'Pascal');
INSERT INTO `cccp_languages` VALUES ( 13,'mIRC');
INSERT INTO `cccp_languages` VALUES ( 14,'PL/I');
INSERT INTO `cccp_languages` VALUES ( 15,'SQL');
INSERT INTO `cccp_languages` VALUES ( 16,'XML');
INSERT INTO `cccp_languages` VALUES ( 17,'Scheme');

CREATE TABLE `cccp_pastebin` (
`id` INT( 10 ) NOT NULL PRIMARY KEY ,
`subject` VARCHAR( 64 ) NOT NULL DEFAULT 'No subject',
`language` INT( 4 ) NOT NULL DEFAULT '1',
`code` BLOB NOT NULL ,
`nickname` VARCHAR( 32 ) NOT NULL DEFAULT 'Anonymous',
`updated` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) TYPE = MYISAM ;

CREATE TABLE `cccp_paste_history_meta` (
`id` INT( 10 ) NOT NULL PRIMARY KEY auto_increment,
`ip` VARCHAR( 15 ) NOT NULL ,
`operation` VARCHAR( 6 ) NOT NULL ,
`pastebin_id` INT ( 10 ) NOT NULL,
`registered` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) TYPE = MYISAM