taomee-server-leak/boke/db/src/db.py at main · moleworld-dev/taomee-server-leak · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
#!/usr/bin/python
# -*- coding: utf-8 -*-

for i in range(100):
	print "drop database POP_%02d;"%(i)
	print "create  database POP_%02d;"%(i)

#user
for i in range(100):
	for j in range( 10):
		print """
create table   POP_%02d.t_user_%01d (
	  userid int(10) unsigned NOT NULL,
	  flag 	int(10) unsigned NOT NULL,
	  register_time int(10) unsigned NOT NULL,
	  sex 	int(1) unsigned NOT NULL,
	  age  	int(3) unsigned NOT NULL,
	  nick 	char(16) NOT NULL,
	  last_islandid int(10) unsigned NOT NULL,
	  last_mapid 	int(10) unsigned NOT NULL,
	  last_x 		int(10) unsigned NOT NULL,
	  last_y 		int(10) unsigned NOT NULL,
	  last_login 	int(10) unsigned NOT NULL,
	  PRIMARY KEY  (userid)
) ENGINE=InnoDB;
		"""%	(i,j)

		print """
create table   POP_%02d.t_task_%01d (
	  userid int(10) unsigned NOT NULL,
	  taskid int(10) unsigned NOT NULL,
	  task_nodeid int(10) unsigned NOT NULL,
	  PRIMARY KEY  (userid,taskid,task_nodeid)
) ENGINE=InnoDB;
		"""%(i,j)

		print """
create table   POP_%02d.t_find_map_%01d (
	  userid int(10) unsigned NOT NULL,
	  islandid int(10) unsigned NOT NULL,
	  mapid int(10) unsigned NOT NULL,
	  PRIMARY KEY  (userid,islandid,mapid )
) ENGINE=InnoDB;
		"""%(i,j)

		print """
create table   POP_%02d.t_item_%01d (
	  userid 	int(10) unsigned NOT NULL,
	  itemid 	int(10) unsigned NOT NULL,
	  usecount 	int(10) unsigned NOT NULL,
	  count 	int(10) unsigned NOT NULL,
	  PRIMARY KEY  (userid,itemid )
) ENGINE=InnoDB;

		"""%(i,j)