Kawai Wiki

Rev

Rev 31 | Rev 53 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31 Rev 51
Line 55... Line 55...
55
55
56
--
56
--
57
-- Table structure for table `groups`
57
-- Table structure for table `groups`
58
--
58
--
59
59
60
DROP TABLE IF EXISTS `groups`;
-
 
-
 
60
DROP TABLE IF EXISTS `Groups`;
61
61
62
62
63
CREATE TABLE `groups` (
-
 
-
 
63
CREATE TABLE `Groups` (
64
  `id` INT(11) NOT NULL,
64
  `id` INT(11) NOT NULL,
65
  `locale` VARCHAR(10) NOT NULL,
65
  `locale` VARCHAR(10) NOT NULL,
66
  `value` VARCHAR(50) NOT NULL,
66
  `value` VARCHAR(50) NOT NULL,
67
  PRIMARY KEY (`id`,`locale`)
67
  PRIMARY KEY (`id`,`locale`)
68
);
68
);
Line 71... Line 71...
71
--
71
--
72
-- Dumping data for table `groups`
72
-- Dumping data for table `groups`
73
--
73
--
74
74
75
75
76
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');
-
 
-
 
76
INSERT INTO `Groups` VALUES (1,'en','Guest'),(2,'en','Admin'),(3,'en','Editor'),(1,'pt','Convidado'),(2,'pt','Admin'),(3,'pt','Editor');
77
77
78
78
79
--
79
--
80
-- Table structure for table `languages`
80
-- Table structure for table `languages`
81
--
81
--
82
82
83
DROP TABLE IF EXISTS `languages`;
-
 
-
 
83
DROP TABLE IF EXISTS `Languages`;
84
84
85
85
86
CREATE TABLE `languages` (
-
 
-
 
86
CREATE TABLE `Languages` (
87
  `id` INT(11) NOT NULL,
87
  `id` INT(11) NOT NULL,
88
  `locale` VARCHAR(10) NOT NULL DEFAULT '',
88
  `locale` VARCHAR(10) NOT NULL DEFAULT '',
89
  `value` VARCHAR(100) NOT NULL,
89
  `value` VARCHAR(100) NOT NULL,
90
  PRIMARY KEY (`id`,`locale`)
90
  PRIMARY KEY (`id`,`locale`)
91
);
91
);
Line 94... Line 94...
94
--
94
--
95
-- Dumping data for table `languages`
95
-- Dumping data for table `languages`
96
--
96
--
97
97
98
98
99
INSERT INTO `languages` VALUES (1,'en_US','English'),(2,'en_US','Portuguese'),(1,'pt_BR','Inglês'),(2,'pt_BR','Português');
-
 
-
 
99
INSERT INTO `Languages` VALUES (1,'en','English'),(2,'en','Portuguese'),(1,'pt','Inglês'),(2,'pt','Português');
100
100
101
101
102
--
102
--
103
-- Table structure for table `users`
103
-- Table structure for table `users`
104
--
104
--
105
105
106
DROP TABLE IF EXISTS `users`;
-
 
-
 
106
DROP TABLE IF EXISTS `Users`;
107
107
108
108
109
CREATE TABLE `users` (
-
 
-
 
109
CREATE TABLE `Users` (
110
  `id` INT(11) NOT NULL AUTO_INCREMENT,
110
  `id` INT(11) NOT NULL AUTO_INCREMENT,
111
  `username` VARCHAR(100) DEFAULT NULL,
111
  `username` VARCHAR(100) DEFAULT NULL,
112
  `password` VARCHAR(100) DEFAULT NULL,
112
  `password` VARCHAR(100) DEFAULT NULL,
113
  `email` VARCHAR(100) DEFAULT NULL,
113
  `email` VARCHAR(100) DEFAULT NULL,
114
  `group_id` INT(11) DEFAULT NULL,
114
  `group_id` INT(11) DEFAULT NULL,
Line 121... Line 121...
121
--
121
--
122
-- Dumping data for table `users`
122
-- Dumping data for table `users`
123
--
123
--
124
124
125
125
126
INSERT INTO `users` VALUES (1,'admin','abc123','admin@admin.com.br',2,1),(2,'saoj','abc123','sergio.oliveira.jr@gmail.com',2,1),(3,'pelasaco','abc123','pela@pela.com.br',3,1);
-
 
-
 
126
INSERT INTO `Users` VALUES (1,'admin','abc123','admin@admin.com.br',2,1),(2,'saoj','abc123','sergio.oliveira.jr@gmail.com',2,1),(3,'pelasaco','abc123','pela@pela.com.br',3,1);
127
127
128
128
129
129
130
130
131
131