| 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; |