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