upgrade/0.0.0_to_0.9.0/skins.sql

   1 -- MySQL dump 9.11
   2 --
   3 -- Host: localhost    Database: x4dat
   4 -- ------------------------------------------------------
   5 -- Server version       4.0.21-log
   6
   7 --
   8 -- Table structure for table `skins`
   9 --
  10
  11 DROP TABLE IF EXISTS skins;
  12 CREATE TABLE skins (
  13   id tinyint(1) unsigned NOT NULL default '0',
  14   name varchar(32) NOT NULL default '',
  15   date varchar(10) NOT NULL default '',
  16   comment varchar(255) NOT NULL default '',
  17   auteur varchar(30) NOT NULL default '',
  18   skin_tpl varchar(32) NOT NULL default '',
  19   ext char(3) NOT NULL default '',
  20   PRIMARY KEY  (id)
  21 ) TYPE=MyISAM PACK_KEYS=1 COMMENT='liste des skins';
  22
  23 --
  24 -- Dumping data for table `skins`
  25 --
  26
  27 INSERT INTO skins VALUES (1,'Defaut','2000-03-07','Skin par défaut','Equipe X.org','default.tpl','png');
  28 INSERT INTO skins VALUES (2,'Sharky','2003-04-01','Une skin aquatique','Jeremy Lainé','sharky.tpl','png');
  29 INSERT INTO skins VALUES (3,'Spectral','2000-03-21','Un peu plus haut en couleurs :))','Equipe X.org','spectral.tpl','png');
  30 INSERT INTO skins VALUES (4,'Espace','2000-03-25','Thème spatial','Equipe X.org','espace.tpl','png');
  31 INSERT INTO skins VALUES (5,'Linux','2000-03-23','Une skin sérieuse pour polytechniciens linuxiens','Equipe X.org','linux.tpl','png');
  32 INSERT INTO skins VALUES (6,'HumLinux','2000-03-29','Une skin sexy inspirée d\'un thème WindowMaker...','Equipe X.org','humlinux.tpl','png');
  33 INSERT INTO skins VALUES (7,'Trapped','2002-12-21','La légende continue...','Thierry Bonnefous','trapped.tpl','png');
  34 INSERT INTO skins VALUES (8,'NewXorg','2001-06-02','Skin avec le logo officiel de l\'association','Equipe X.org','newxorg.tpl','png');
  35 INSERT INTO skins VALUES (9,'OldTimes','2000-03-08','La skin historique','Equipe X.org','oldtimes.tpl','png');
  36 INSERT INTO skins VALUES (10,'NBviolet','2000-03-08','Purple Rain en noir et blanc','Equipe X.org','nbviolet.tpl','png');
  37
  38 update auth_user_md5 set skin=skin+100;
  39
  40 update auth_user_md5 set skin=10 where skin=110;
  41 update auth_user_md5 set skin=9 where skin=101;
  42 update auth_user_md5 set skin=8 where skin=106;
  43 update auth_user_md5 set skin=7 where skin=112;
  44 update auth_user_md5 set skin=6 where skin=107;
  45 update auth_user_md5 set skin=5 where skin=104;
  46 update auth_user_md5 set skin=4 where skin=105;
  47 update auth_user_md5 set skin=3 where skin=103;
  48 update auth_user_md5 set skin=2 where skin=115;
  49 update auth_user_md5 set skin=1 where skin>=100;