WIPUP

Be ambitious Show us a WIP!

Temporary new database dump for those trying out Eadrax.
By Moult from WIPUP - WIPUP is a flexible and easy way to show people what you're working on.
26th September 2009

You should share it.

It doesn't matter if your update looks horrible, your update is a valued part of the creation process and deserves every right to be proudly showcased out there for the world to see. At WIPUP, we believe that this in-between is just as important and breathtakingly awesome as the finished product iself - it's the hidden spectacular adventure behind the creation. Anything from a brainwave of an idea to a tiny nudge of a pixel - we want you to use WIPUP to suit your workflow.

You can start sharing this update with your friends by directing them to this URL:

For those social folk we've got a few shortcuts to share on your social network's stream.

Twitter Facebook Digg Delicious

Use this instead of what's inside DATABASES (untested)



Pastebin (mysql)

  1. CREATE TABLE IF NOT EXISTS `categories` (
  2.   `id` int(11) NOT NULL auto_increment,
  3.   `name` varchar(255) NOT NULL,
  4.   PRIMARY KEY  (`id`)
  6.  
  7. INSERT INTO `categories` (`id`, `name`) VALUES
  8. (1, '2D Animation'),
  9. (2, '3D Animation'),
  10. (3, '3D Modeling'),
  11. (4, 'Application Programming'),
  12. (5, 'Digital Paintings'),
  13. (6, 'Documents & Articles'),
  14. (7, 'Games'),
  15. (8, 'Homework'),
  16. (9, 'Interface Design'),
  17. (10, 'Literature & Fiction'),
  18. (11, 'Magazines & Newsletters'),
  19. (12, 'Miscellaneous'),
  20. (13, 'Music'),
  21. (14, 'Posters'),
  22. (15, 'Presentations'),
  23. (16, 'Sound Effects'),
  24. (17, 'Vector Art'),
  25. (18, 'Video'),
  26. (19, 'Website Programming');
  27.  
  28. CREATE TABLE IF NOT EXISTS `comments` (
  29.   `id` int(11) NOT NULL auto_increment,
  30.   `uid` int(11) NOT NULL,
  31.   `upid` int(11) NOT NULL,
  32.   `comment` text NOT NULL,
  34.   PRIMARY KEY  (`id`),
  35.   KEY `uid` (`uid`),
  36.   KEY `upid` (`upid`)
  38.  
  39. CREATE TABLE IF NOT EXISTS `kudos` (
  40.   `id` int(11) NOT NULL auto_increment,
  41.   `uid` int(11) NOT NULL,
  42.   `upid` int(11) NOT NULL,
  44.   PRIMARY KEY  (`id`),
  45.   KEY `uid` (`uid`),
  46.   KEY `upid` (`upid`)
  48.  
  49. CREATE TABLE IF NOT EXISTS `news` (
  50.   `id` int(11) NOT NULL auto_increment,
  51.   `uid` int(11) NOT NULL,
  52.   `cid` int(11) NOT NULL,
  53.   `upid` int(11) NOT NULL,
  54.   `pid` int(11) NOT NULL,
  55.   `kid` int(11) NOT NULL,
  56.   `sid` int(11) NOT NULL,
  57.   `tid` int(11) NOT NULL,
  59.   PRIMARY KEY  (`id`)
  60. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
  61.  
  62. CREATE TABLE IF NOT EXISTS `openid` (
  63.   `url` varchar(255) NOT NULL,
  64.   `uid` int(10) NOT NULL,
  65.   PRIMARY KEY  (`url`),
  66.   KEY `uid` (`uid`)
  68.  
  69. CREATE TABLE IF NOT EXISTS `projects` (
  70.   `id` int(11) NOT NULL auto_increment,
  71.   `uid` int(11) NOT NULL,
  72.   `cid` int(11) NOT NULL,
  73.   `name` varchar(255) NOT NULL,
  74.   `website` varchar(255) NOT NULL,
  75.   `contributors` varchar(255) NOT NULL,
  76.   `icon` varchar(255) NOT NULL,
  77.   `description` text NOT NULL,
  78.   `views` int(11) NOT NULL,
  80.   PRIMARY KEY  (`id`),
  81.   KEY `uid` (`uid`),
  82.   KEY `cid` (`cid`)
  84.  
  85. INSERT INTO `projects` (`uid`, `cid`, `name`, `description`) VALUES
  86. (1, 12, 'Uncategorised', 'Every update that is not part of any user-defined project is put into this section. This includes updates submitted by guest users.');
  87.  
  88. CREATE TABLE IF NOT EXISTS `subscribe` (
  89.   `id` int(11) NOT NULL auto_increment,
  90.   `pid` int(11) NOT NULL,
  91.   `uid` int(11) NOT NULL,
  93.   PRIMARY KEY  (`id`),
  94.   KEY `pid` (`pid`),
  95.   KEY `uid` (`uid`)
  97.  
  98. CREATE TABLE IF NOT EXISTS `track` (
  99.   `id` int(11) NOT NULL auto_increment,
  100.   `track` int(11) NOT NULL,
  101.   `uid` int(11) NOT NULL,
  103.   PRIMARY KEY  (`id`),
  104.   KEY `track` (`track`),
  105.   KEY `uid` (`uid`)
  107.  
  108. CREATE TABLE IF NOT EXISTS `updates` (
  109.   `id` int(11) NOT NULL auto_increment,
  110.   `pid` int(11) NOT NULL,
  111.   `uid` int(11) NOT NULL,
  112.   `summary` varchar(255) NOT NULL,
  113.   `filename` varchar(255) NOT NULL,
  114.   `detail` text NOT NULL,
  115.   `syntax` varchar(255) NOT NULL,
  116.   `pastebin` text NOT NULL,
  117.   `ext` varchar(10) NOT NULL,
  118.   `views` int(11) NOT NULL,
  120.   PRIMARY KEY  (`id`),
  121.   KEY `pid` (`pid`),
  122.   KEY `uid` (`uid`)
  124.  
  125. CREATE TABLE IF NOT EXISTS `users` (
  126.   `id` int(11) NOT NULL auto_increment,
  127.   `username` varchar(50) NOT NULL,
  128.   `password` varchar(255) NOT NULL,
  129.   `description` text NOT NULL,
  130.   `email` varchar(50) NOT NULL,
  131.   `msn` varchar(50) NOT NULL,
  132.   `gtalk` varchar(50) NOT NULL,
  133.   `yahoo` varchar(50) NOT NULL,
  134.   `skype` varchar(50) NOT NULL,
  135.   `website` varchar(50) NOT NULL,
  136.   `location` varchar(50) NOT NULL,
  137.   `dob` varchar(8) NOT NULL,
  138.   `gender` enum('Unknown','Male','Female') NOT NULL default 'Unknown',
  139.   `avatar` varchar(255) NOT NULL,
  141.   `level` enum('Normal','Special','Staff','Admin') NOT NULL default 'Normal',
  142.   `lastactive` int(11) NOT NULL,
  143.   PRIMARY KEY  (`id`),
  144.   UNIQUE KEY `username` (`username`)
  146.  
  147. INSERT INTO `users` (`username`, `password`, `description`) VALUES
  148. ('Guest', 'guest', 'This is a special user to represent guest submissions on the website. Please register to access all the features of the website.');
  149.  
  150. ALTER TABLE `comments`
  151.   ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  152.   ADD CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`upid`) REFERENCES `updates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  153.  
  154. ALTER TABLE `kudos`
  155.   ADD CONSTRAINT `kudos_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  156.   ADD CONSTRAINT `kudos_ibfk_2` FOREIGN KEY (`upid`) REFERENCES `updates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  157.  
  158. ALTER TABLE `openid`
  159.   ADD CONSTRAINT `openid_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  160.  
  161. ALTER TABLE `projects`
  162.   ADD CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  163.   ADD CONSTRAINT `projects_ibfk_2` FOREIGN KEY (`cid`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  164.  
  165. ALTER TABLE `subscribe`
  166.   ADD CONSTRAINT `subscribe_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  167.   ADD CONSTRAINT `subscribe_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  168.  
  169. ALTER TABLE `track`
  170.   ADD CONSTRAINT `track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  171.   ADD CONSTRAINT `track_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  172.  
  173. ALTER TABLE `updates`
  174.   ADD CONSTRAINT `updates_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  175.   ADD CONSTRAINT `updates_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Revise Paste

Comments

Moult says:

Note: has been committed as of 29/09/09. Pending deletion.

Leave a comment

If you were logged in, we won't ask you silly questions like in primary school.

What is the colour of King George's favourite black horse?