Kawai Wiki

Rev

Rev 11 | Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
5 soliveira 1
-- MySQL dump 10.13  Distrib 5.1.41, for debian-linux-gnu (x86_64)
2
--
3
-- Host: localhost    Database: Kawai
4
-- ------------------------------------------------------
5
-- Server version       5.1.41-3ubuntu12.10
6
 
7
 
8
 
9
 
10
 
11
 
12
 
13
 
14
 
15
 
16
 
17
 
18
--
19
-- Current Database: `Kawai`
20
--
21
 
22
 
23
 
24
--
25
-- Table structure for table `groups`
26
--
27
 
28
DROP TABLE IF EXISTS `groups`;
29
 
30
 
31
CREATE TABLE `groups` (
32
  `id` INT(11) NOT NULL,
33
  `locale` VARCHAR(10) NOT NULL,
34
  `value` VARCHAR(50) NOT NULL,
35
  PRIMARY KEY (`id`,`locale`)
36
);
37
 
38
 
39
--
40
-- Dumping data for table `groups`
41
--
42
 
43
 
44
INSERT INTO `groups` VALUES (1,'en_US','Guest'),(2,'en_US','Admin'),(3,'en_US','Editor'),(1,'pt_BR','Convidado'),(2,'pt_BR','Admin'),(3,'pt_BR','Editor');
45
 
46
 
47
--
48
-- Table structure for table `languages`
49
--
50
 
51
DROP TABLE IF EXISTS `languages`;
52
 
53
 
54
CREATE TABLE `languages` (
55
  `id` INT(11) NOT NULL,
56
  `locale` VARCHAR(10) NOT NULL DEFAULT '',
57
  `value` VARCHAR(100) NOT NULL,
58
  PRIMARY KEY (`id`,`locale`)
59
);
60
 
61
 
62
--
63
-- Dumping data for table `languages`
64
--
65
 
66
 
67
INSERT INTO `languages` VALUES (1,'en_US','English'),(2,'en_US','Portuguese'),(1,'pt_BR','Inglês'),(2,'pt_BR','Português');
68
 
69
 
70
--
71
-- Table structure for table `users`
72
--
73
 
74
DROP TABLE IF EXISTS `users`;
75
 
76
 
77
CREATE TABLE `users` (
78
  `id` INT(11) NOT NULL AUTO_INCREMENT,
79
  `username` VARCHAR(100) DEFAULT NULL,
80
  `password` VARCHAR(100) DEFAULT NULL,
81
  `email` VARCHAR(100) DEFAULT NULL,
82
  `group_id` INT(11) DEFAULT NULL,
83
  `language_id` INT(11) DEFAULT NULL,
84
  PRIMARY KEY (`id`),
85
  UNIQUE KEY `users_username` (`username`)
86
);
87
 
88
 
89
--
90
-- Dumping data for table `users`
91
--
92
 
93
 
94
INSERT INTO `users` VALUES (1,'soliveira','abc123','sergio.oliveira.jr@gmail.com',1,1),(2,'saoj','abc123','sergio.oliveira.jr@gmail.com',2,1),(3,'pelasaco','abc123','pela@pela.com.br',3,1);
95
 
96
 
97
 
98
 
99